Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question Required: (a) Using the financial statements, compute the following ratios for Sun Corporation for 2018. Show all computations. (4 marks) 1. Current ratio. 2.

Question

image text in transcribed

image text in transcribed

Required:

(a) Using the financial statements, compute the following ratios for Sun Corporation for 2018. Show all computations. (4 marks)

1. Current ratio.

2. Acid-test ratio.

3. Accounts receivable turnover.

4. Inventory turnover.

5. Profit margin.

6. Return on assets.

7. Assets turnover.

8. Times interest earned.

9. Working capital.

10. Debt to assets ratio.

Answer a)

Answer- (a)
1. Current Ratio
= Current Assets / Current Liablities
= 525000/225000 2.33
Current Assets
Cash 75000
Short term Inventments 75000
Accounts receivable(net) 150000
Inventory 225000
525000
Current Liablities
Accounts payable 75000
Short term notes payable 150000
225000
2. Acid test Ratio
= (Cash + Short term Inventments + Accounts receivable(net)) / Current Liablities
= 150000/225000 0.67
Cash 75000
Short term Inventments 75000
Accounts receivable(net) 150000
Current Liablities
Accounts payable 75000
Short term notes payable 150000
225000
3. Account Receivable Turnover
= Net credit sales / Average account receivable
= 1500000/131250 11.43
Net Sales 1500000
2018 2017
Accounts receivable(net) 150000 112500
Average account receivable= (150000+112500)/2
131250
4. Inventory Turnover
= Sales / Average Inventory
= 1500000/243750 6.15
Net Sales 1500000
2018 2017
Inventory 225000 262500
Average Inventory= (225000+262500)/2
= 243750
5. Profit Margin
= Net income / Investment
= 236250/975000 0.24
Net income 236250
Total assets 1500000
Less:
Accounts payable 75000
Short term notes payable 150000
Bond Payable 300000
Investment 975000
6.Return on Assets
= Net income / Average total assets
= 236250/1687500 0.14
Net income 236250
2018 2017
Total assets 1500000 1875000
Average total assets = (1500000+1875000)/2
= 1687500
7. Assets turnover
= Total Sales / [(Opening assets + closing assets)/2]
= 1500000/1687500 0.89
Where
Opening Assets=Assets at start of year
Closing Assets=Assets at end of year
Net Sales 1500000
$ Year
Opening Assets 1875000 2017
Closing Assets 1500000 2018
[(Opening assets + closing assets)/2] 1687500
8. Time Interest Earned
It is refered as Interest coverage ratio
Interest coverage ratio = EBIT/ Interest Expense
= 337500/67500 5 times
Where
EBIT means Income before income taxes
Income before income taxes 337500
Interest expenses 67500
9. Working Capital
= Current Assets - Current Liablities
= 525000-225000 300000
Current Assets
Cash 75000
Short term Inventments 75000
Accounts receivable(net) 150000
Inventory 225000
525000
Current Liablities
Accounts payable 75000
Short term notes payable 150000
225000
10. Debt to assets ratio
= (Short term debt + Long term debt)/ Total Assets
= (225000+300000)/1500000 0.35
Short term debt
Accounts payable 75000
Short term notes payable 150000
225000
Long term debt
Bond Payable 300000
Total assets 1500000

Required

(b) Prepare a vertical analysis of the 2018 income statement data for Sun Corporation . (2 marks)

(c) Based on the ratios calculated in (a), and the vertical analysis in (b), discuss briefly the improvement or lack thereof in financial position and operating results from 2017 to 2018 of Sun Corporation.

The financial statements of Sun Corporation appear below: Sun Corporation Comparative Balance Sheets December 31, 2017 - 18 Assets Cash Short-term investments Accounts receivable (net) Inventory Property, plant and equipment (net) 2018 S 75,000 75,000 150,000 225,000 975.000 2017 S 150,000 225,000 112,500 262,500 1,125,000 Total assets Liabilities and stockholders' equit Accounts payable Short-term notes payable Bonds payable Common stock Retained earnings Total liabilities and stockholders' equity S1500.000 S 75,000S 112,500 150,000 300,000 562,500 412.500 337,500 600,000 562,500 262.500 S1875.000 Sun Corporation Income Statement For the Year Ended December 31, 2018 Net sales Cost of goods sold Gross profit Expenses $1,500,000 937,500 562,500 Operating expenses Interest expense $157,500 67.500 Total expenses 225.000 337,500 101.250 Income before income taxes Income tax expense Net income

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting And Reporting A Global Perspective

Authors: Herv Stolowy, Yuan Ding

5th Edition

1473740207, 978-1473740204

More Books

Students also viewed these Accounting questions

Question

Why should an individual manager be interested in supporting HR?

Answered: 1 week ago