For the financial data given below for the company Sheela Foams Ltd, construct the Balance Sheet,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
For the financial data given below for the company Sheela Foams Ltd, construct the Balance Sheet, P&L and Cashflow Statements for the years 2023, 2024, and 2025. Perform the horizontal, vertical and ratio analysis of the financial statements prepared by you. Give your comments and analysis on the performance of the company. Balance Sheet $ in millions Trade Receivables Inventory PP&E Cash Other assets Assets Trade Payables Provisions Financial Liabilities Other liabilities Equity Liabilities & Equity 31-Mar- 20 143.9 85.0 632.5 24.8 45.9 932.1 68.0 32.5 6158 48.3 167.5 932.1 31-Mar- 31-Mar- 21 22 154.8 92.0 632.5 169.3 110.0 659.5 21.8 220.0 46.9 68.0 948.0 1,226.8 68.9 28.7 610.4 43.3 196.7 948.0 1,226.8 68.9 28.7 605.0 38.9 485.3 P&L $ in millions Revenue Cost of goods sold Gross Profit Operating expenses EBITDA D&A EBIT Interest expenses EBT Taxes Net Income 31-Mar- 31-Mar- 20 2.922.0 2,984.0 21 31-Mar- 22 3,040.0 (1,401.0) (1,383.0) (1,3670) 1,521.0 1,601.0 1,673.0 (1.212.2) (1.245.3) (1,068.2) 308.8 355.7 604.8 (44.0) 311 66. (31.0) 277.82 (56.0) 221.8 (207.5) 14.3 (65.0) 246.7 (210.0) 36.7 (41.0) 563.76 (52.0) 5118 (208.6) 303.2 For the financial data given below for the company Sheela Foams Ltd, construct the Balance Sheet, P&L and Cashflow Statements for the years 2023, 2024, and 2025. Perform the horizontal, vertical and ratio analysis of the financial statements prepared by you. Give your comments and analysis on the performance of the company. Balance Sheet $ in millions Trade Receivables Inventory PP&E Cash Other assets Assets Trade Payables Provisions Financial Liabilities Other liabilities Equity Liabilities & Equity 31-Mar- 20 143.9 85.0 632.5 24.8 45.9 932.1 68.0 32.5 6158 48.3 167.5 932.1 31-Mar- 31-Mar- 21 22 154.8 92.0 632.5 169.3 110.0 659.5 21.8 220.0 46.9 68.0 948.0 1,226.8 68.9 28.7 610.4 43.3 196.7 948.0 1,226.8 68.9 28.7 605.0 38.9 485.3 P&L $ in millions Revenue Cost of goods sold Gross Profit Operating expenses EBITDA D&A EBIT Interest expenses EBT Taxes Net Income 31-Mar- 31-Mar- 20 2.922.0 2,984.0 21 31-Mar- 22 3,040.0 (1,401.0) (1,383.0) (1,3670) 1,521.0 1,601.0 1,673.0 (1.212.2) (1.245.3) (1,068.2) 308.8 355.7 604.8 (44.0) 311 66. (31.0) 277.82 (56.0) 221.8 (207.5) 14.3 (65.0) 246.7 (210.0) 36.7 (41.0) 563.76 (52.0) 5118 (208.6) 303.2
Expert Answer:
Answer rating: 100% (QA)
Based on the given financial data I have constructed the Balance Sheet PL and Cash Flow statements for the years 2023 2024 and 2025 Balance Sheet Year ending Mar 31 2023 Trade receivables 1439 Invento... View the full answer
Related Book For
Horngrens Accounting The Financial Chapters
ISBN: 9780136162186
13th Edition
Authors: Tracie Miller Nobles, Brenda Mattison
Posted Date:
Students also viewed these accounting questions
-
Using an economic and market perspective how would you argue the removal of state restrictions that stop nurses from practicing to the full extent of their preparation?
-
A dc battery can deliver 45 mA at 9 V. What is the power rating?
-
The financial statements and industry norms are shown below for Pamplin, Inc.: a. Compute the financial ratios for Pamplin to compare both for 2012 and 2013 against the industry norms. b. How liquid...
-
Why are process control systems necessary? Give TWO examples of their usefulness within the plant.
-
Would a traditional income statement differ depending on whether the business is a service organization, merchandiser, or manufacturer?
-
Determine the moments at the supports, then draw the moment diagram. The members are fixed connected at the supports and at joint B. The moment of inertia of each member is given in the figure. Take...
-
An engineering laboratory experiment uses a triangular weir in an open channel to measure flow rate. The nominal weir angle is \(90^{\circ}\). In a certain test, the head of water above the weir was...
-
Kingston, Inc. management is considering purchasing a new machine at a cost of $4,133,250. They expect this equipment to produce cash flows of $814,322, $863,275, $937,250, $1,017,112, $1,212,960,...
-
Accounts Payable Accounts Receivable Cash B Bland Media Information: E $ 25,000 210,000 Rent Expense Supplies $ 75,000 9,000 146,000 Supplies Expense 12,000 Common Stock 35,000 Taxes Expense 10,000...
-
Analyze, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance sheet of ADP Inc. Note: Complete the entire question using the following Excel...
-
At the start of the current year, SBC Corp, purchased 25% OF Sky Tech Inc. for $48 million. At the time of purchase, the carrying value of Sky Techs net asset was $76 million. The fair value of Sky...
-
A fi rm has a fi xed cost of $2,500. At one unit of output variable cost is $3,400. Find (a) total cost at zero units of output and (b) marginal cost at one unit of output.
-
A firm has a fixed cost of $1,000. At one unit of output variable cost is $1,200. Find (a) total cost at zero units of output and (b) marginal cost at one unit of output.
-
You just got closed out of an economics course you need to graduate and need to persuade the department chair to open another section. She tells you that the school will have to pay a part-time...
-
At __________, quantity demanded equals quantity supplied.
-
An increase in supply is shown graphically by a shift of the supply curve to the ________.
-
7. 8. O Payback period was the earliest -Select- expected rate, the project will break even. The equation is: The -Select- a project's payback, the better the project is. However, payback has 3 main...
-
Describe basic managerial approaches to implementing controls and how these are implemented.
-
Dialex Watches completed the following selected transactions during 2024 and 2025: Requirements 1. Open T-accounts for Allowance for Bad Debts and Bad Debts Expense, assuming the accounts begin with...
-
George, Murphy, and Lincoln, a partnership, is considering admitting Thorton as a new partner. On July 31, 2024, the capital accounts of the three existing partners and their profit-and-loss-sharing...
-
Ember Company purchased a building with a market value of $280,000 and land with a market value of $55,000 on January 1, 2024. Ember Company paid $15,000 cash and signed a 25-year, 12% mortgage...
-
How does risk affect the financial management of sport organizations?
-
Describe the process of determining a nominal interest rate.
-
Of MLB, the NBA, and the NHL, which league has the most risk, and which has the least? Why?
Study smarter with the SolutionInn App