Income Statements for the Year Ended 31st Dec 2020 KM Ltd ROW Ltd £'000 £'000 Sales revenue 8,320 11,250 Cost of sales (6,020) (9,030) Gross profit 2,300 2,220 Operating expenses (1,048) (1,535) Operating profit 1,252 685 Finance charges (20) (70) Profit before tax 1,232 615 Taxation (62) (30) Profit for the year 1,170 585 SOFP (Balance Sheet) as at 31st Dec 2020 KM Ltd ROW Ltd £'000 £'000 £'000 £'000 Non-current assets 502 198 Current assets Inventory 1,290 2,437 Trade receivables 730 1,990 2,020 4,427 Total assets 2,522 4,625 Equity Share capital 1,350 800 Reserves 580 1,145 1,930 1,945 Current liabilities Trade payables 430 850 Taxation 62 30 Bank overdraft 35 350 527 1,230 Non-current liabilities Loans 65 1,450 Total equity and liabilities 2,522 4,625 You are required to: Use your Excel skills to calculate the following ratios for both companies. Working capital cycle/operating cycle Gearing Interest cover

Fundamentals of Financial Management (MindTap Course List)

15th Edition

ISBN:9781337395250

Author:Eugene F. Brigham, Joel F. Houston

Publisher:Eugene F. Brigham, Joel F. Houston

Chapter4: Analysis Of Financial Statements

Section: Chapter Questions

Problem 24P: Income Statement for Year Ended December 31, 2018 (Millions of Dollars) Net sales 795.0 Cost of...

See similar textbooks

Related questions

Question

Income Statements for the Year Ended 31^stDec 2020

	KM Ltd		ROW Ltd
		£'000		£'000
Sales revenue		8,320		11,250
Cost of sales		(6,020)		(9,030)
Gross profit		2,300		2,220
Operating expenses		(1,048)		(1,535)
Operating profit		1,252		685
Finance charges		(20)		(70)
Profit before tax		1,232		615
Taxation		(62)		(30)
Profit for the year		1,170		585

SOFP (Balance Sheet) as at 31^st Dec 2020
	KM Ltd		ROW Ltd
	£'000	£'000		£'000	£'000
Non-current assets		502			198

Current assets
Inventory	1,290			2,437
Trade receivables	730			1,990
		2,020			4,427
Total assets		2,522			4,625

Equity
Share capital	1,350			800
Reserves	580			1,145
		1,930			1,945

Current liabilities
Trade payables	430			850
Taxation	62			30
Bank overdraft	35			350
		527			1,230

Non-current liabilities
Loans		65			1,450
Total equity and liabilities		2,522			4,625

You are required to:

Use your Excel skills to calculate the following ratios for both companies.

Working capital cycle/operating cycle
Gearing
Interest cover

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions