Planet Ltd produces fridges and freezers, which are sold to retailers. The financial statements for the last three years are as follows:
Income statements for the year ending 31st December |
||
|
2021 |
2022 |
|
£000 |
£000 |
Revenue |
336,250 |
427,038 |
Cost of sales |
(126,675) |
(190,012) |
Gross profit |
209,575 |
237,025 |
Administration expenses |
(73,290) |
(95,795) |
Distribution expenses |
(14,678) |
(8,720) |
Operating profit |
121,407 |
121,931 |
Interest |
(8,750) |
(11,250) |
Profit before tax |
118,142 |
166,326 |
Tax |
(22,531) |
(22,136) |
Profit for the year |
90,126 |
88,545 |
|
||
|
2021 |
2022 |
|
£000 |
£000 |
Non-current assets |
|
|
Property, plant and equipment |
286,250 |
327,650 |
Current assets |
|
|
Inventories |
37,000 |
28,000 |
Trade receivables |
42,000 |
43,500 |
Cash |
19,632 |
24,570 |
|
98,632 |
96,070 |
Total assets |
384,882 |
423,720 |
|
|
|
Current liabilities |
|
|
Trade payables |
34,000 |
28,750 |
Accruals |
22,531 |
22,136 |
Tax liability |
1,250 |
1,425 |
|
57,781 |
52,311 |
Non-current liabilities |
|
|
Bank loan |
175,000 |
225,000 |
|
|
|
Equity |
|
|
Ordinary share capital of £1 (fully paid) |
80,000 |
80,000 |
|
72,101 |
66,409 |
|
152,101 |
146,409 |
Total equity and liabilities |
384,882 |
423,720 |
- Calculate the following financial ratios for the year 2022. Show your calculations.
The ratios for 2021 have been provided in the table below :
- Gross profit margin
- Net profit margin
- Return on capital employed
-
Current ratio - Quick ratio
- Inventory holding period
- Receivables collection period
- Payables payment period
- Gearing ratio
- Interest coverage
|
2021 |
2022 |
|
a) Gross profit margin |
62.33% |
|
|
b) Net profit margin |
26.80% |
|
|
c) Return on capital employed |
37.12% |
|
|
d) Current ratio |
1.71 :1 |
|
|
e) Quick ratio |
1.07 :1 |
|
|
f) Inventory holding period |
119 days |
|
|
Step by stepSolved in 3 steps
- Assume a merchandising company had credit sales of $380,000, cost of goods sold of $187,000, and net income of $60,000. It provided the following excerpts from its balance sheet: This Year Last Year Current assets: Accounts receivable $ 40,000 $ 46,000 Inventory $ 53,000 $ 50,000 Prepaid expenses $ 13,000 $ 11,000 Current liabilities: Accounts payable $ 39,000 $ 44,000 Income taxes payable $ 13,000 $ 10,000 If the company purchases its merchandise inventory on account, then based solely on the information provided, the company’s cash paid for inventory purchases would be: Garrison 17e Rechecks 2020-10-02 Multiple Choice $189,000. $185,000. $195,000. $179,000.arrow_forwardThe income statement of Sunland Company is shown below. SUNLAND COMPANYINCOME STATEMENTFOR THE YEAR ENDED DECEMBER 31, 2020 Sales revenue $6,630,000 Cost of goods sold Beginning inventory $1,840,000 Purchases 4,520,000 Goods available for sale 6,360,000 Ending inventory 1,530,000 Cost of goods sold 4,830,000 Gross profit 1,800,000 Operating expenses Selling expenses 450,000 Administrative expenses 660,000 1,110,000 Net income $690,000 Additional information: 1. Accounts receivable decreased $290,000 during the year. 2. Prepaid expenses increased $180,000 during the year. 3. Accounts payable to suppliers of merchandise decreased $260,000 during the year. 4. Accrued expenses payable decreased $120,000 during the year. 5. Administrative expenses include depreciation expense of $60,000.…arrow_forwardSisyphus Inc. records total sales of $657,500 in the current period, with a cost of goods sold of $389,000 . Sisyphus expects 4% of sales to be returned. How much in net sales will Sisyphus recognize for the current period? Group of answer choices $373,400 $268,500 $631,200 $657,500 $257,760 The Sisyphus Inc’s (SSY) Company’s annual statement of cash flows reported the following (in millions): Net cash from financing activities $63,864 Net cash from investing activities -62,512 Cash at the beginning of the year 13,152 Cash at the end of the year 18,948 What did SSY report for “Net cash from operating activities” during the year? Group of answer choices $71,220 million cash inflow None of the above $4,444 million cash outflow $4,444 million cash inflow $71,220 million cash outflowarrow_forward
- Bellingham Industries, a manufacturer of the furniture industry, had the following financial performance for the last two years as shown on their income statements below: Billingham Industries, Inc. Comparative Income Statement For the Years Ended December 31, 2021 and 2020 2021 2020 Amount Amount Sales $1,280,000 $1,180,000 Cost of goods sold 644,800 613,600 Gross profit 635,200 566,400 Selling expenses 230,500 188,800 Administrative expenses 182,500 177,000 Total operating expenses 413,000 365,800 Income from operations 222,200 200,600 Other income 77,000 70,800 Income before income tax 299,200 271,400 Income tax expense 121,600 106,200 Net income $177,600 $165,200 1. Prepare a horizontal analysis using the form provided to…arrow_forwardCalculating the Times-Interest-Earned Ratio Beech Company provided the following income statement for last year: Sales $24,350,735 Cost of goods sold 15,300,000 Gross margin $9,050,735 Operating expenses 4,910,685 Operating income $4,140,050 Interest expense 463,015 Income before taxes $3,677,035 Income taxes 1,461,214 Net income $2,215,821 Required: Calculate the times-interest-earned ratio. Round the answer to one decimal place.fill in the blank 1arrow_forwardIncome statement data for Winthrop Company for two recent years ended December 31 are as follows: 1 Current Year Previous Year 2 Sales $1,596,000.00 $1,400,000.00 3 Cost of goods sold 1,316,700.00 1,197,000.00 4 Gross profit $279,300.00 $203,000.00 5 Selling expenses $76,950.00 $67,500.00 6 Administrative expenses 55,000.00 50,000.00 7 Total operating expenses $131,950.00 $117,500.00 8 Income before income tax $147,350.00 $85,500.00 9 Income tax expense 11,060.00 7,000.00 10 Net income $136,290.00 $78,500.00 A. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. Round percentages to one decimal place. B. What conclusions can be drawn from the horizontal analysis? Round the answers to one decimal place.arrow_forward
- Sellall Department Stores reported the following amounts as of its December 31 year- end: Administrative Expenses, $1,800; Cost of Goods Sold, $19,440; Income Tax Expense, $2,790; Interest Expense, $1,400; Interest Revenue, $160; General Expenses, $2,000; Net Sales, $32,580; and Delivery (freight-out) Expense, $240. Prepare a multistep income statement for distribution to external financial statement users. SELLALL DEPARTMENT STORES Income Statementarrow_forwardBellingham Industries, a manufacturer of the furniture industry, had the following financial performance for the last two years as shown on their income statements below: Billingham Industries, Inc. Comparative Income Statement For the Years Ended December 31, 2021 and 2020 2021 2020 Amount Amount Sales $1,280,000 $1,180,000 Cost of goods sold 644,800 613,600 Gross profit 635,200 566,400 Selling expenses 230,500 188,800 Administrative expenses 182,500 177,000 Total operating expenses 413,000 365,800 Income from operations 222,200 200,600 Other income 77,000 70,800 Income before income tax 299,200 271,400 Income tax expense 121,600 106,200 Net income $177,600 $165,200 1. Prepare a horizontal analysis using the form provided to…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education