Question

Instructions: 1. On pages three and four, you will find condensed statement of financial position and income statement data f

Waterloo Corporation Statement of Financial Position 31-Dec 2015 2014 2013 Assets Cash $32,000 $19,000 $10,000 Accounts Recei

Waterloo Corporation Income Statement Year Ended December 31 2015 Sales $928,000 Less: Sales returns and 58,000 allowances Ne

Additional information: 1. The allowance for doubtful accounts was: 2013 $8,500 2014 $7,000 2015 $10,500 2. Assume 94% of net
Part 1: Ratio Analysis calculate the following ratios


2015 2014 1. Current ratio 2. Days Sales Outstanding 3. Days in Inventory 4. Debt to total assets 5. Times interest earned 6.

8. Profit margin 9. Asset turnover 10. Return on assets

(b) Compare the ratios between 2015 and 2014 and comment if the performance in 2015 was better or worse. (5 marks) Better
Part 2: Perform a vertical analysis of statement of financial position & Income statement

Waterloo Corporation Statement of Financial Position 31-Dec 2015 2014 Assets Cash Accounts Receivable (net) 2013 Inventory Ot

2014 Waterloo Corporation Income Statement Year Ended December 31 2015 Sales Less: Sales returns and allowances Net Sales Cos
Part 3: Perform a Horizontal Analysis of statement of Financial Position for 2015 and 2014 & Income statement for 2015

Waterloo Corporation Statement of Financial Position 31-Dec 2015 2014 Assets Cash Accounts Receivable (net) Inventory Other c

Waterloo Corporation Income Statement Year Ended December 31 2015 Sales Less: Sales returns and allowances Net Sales Cost of
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Part 1

1. Current Ratio = current assets/ current liabilities

Current assets = cash+ account receivables+ inventory+ other current assets

2014 - 209000/56000 = 3.7:1

2015 - 273000/71500 = 3.8:1

2. Days sale outstanding = Account receivables/ Average sales per day

2014 - 95000/928000/365 = 37.36 days

2015 - 70000/840000/365 = 30.42 days

3. Days in Inventory = Inventory/ cost of goods sold x 365

2014 - 81000/478000 * 365 = 58 days

2015 - 71000/ 465000* 365 = 48.67 days

4. Debt to Total assets ratio = Total equity/ Total assets

2014 - 674500/991000 = 0.68:1

2015 - 499000/630000 = 0.79:1

5. Times Interest Earned Ratio - EBIT/ Total Interest

2014 - 126000/28500 = 4.42:1

2015 - 76000/ 107500 = 7.07:1

6. Cash total Debt Coverage Ratio - Cash from operation/ Debt

2014 - 120000/316500 = 0.38:1

2015 - 126000/131000 = 0.96:1

( Debt = total assets - equity)

7. Gross Profit Margin - Gross profit/ Cost of Goods sold*100

2014 - 392000/478000*100 = 82%

2015 - 332000/465000*100= 71%

8. Profit Margin - Net Profit/ Net Sales*100

2014 - 76250/870000*100= 8.76%

2015 - 49000/797000*100 = 6.15%

9. Assets Turnover Ratio - Net sales/ Average Total Assets

2014 - 870000/810500 = 1.07:1

2015 - 797000/586000 = 1.36:1

10. Return on Assets - Net income/Average total assets

2014 - 76250/810500 = 0.09:1

2015 - 49000/586000 = 0.08:1

Add a comment
Know the answer?
Add Answer to:
Part 1: Ratio Analysis calculate the following ratios Part 2: Perform a vertical analysis of statement...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • please help Waterloo Corporation Statement of Financial Position 31-Dec 2015 2014 2013 Assets Cash $32,000 $19,000...

    please help Waterloo Corporation Statement of Financial Position 31-Dec 2015 2014 2013 Assets Cash $32,000 $19,000 $10,000 Accounts Receivable (net) 95,000 70,000 53,000 Inventory 81,000 71,000 53,000 Other current assets 65,000 49,000 61,000 Long-term investments 120,000 76,000 50,000 Property, Plant & Equipment (net) 598,000 345,000 315.000 Total Assets $991,000 $630,000 $542,000 $71,500 245.000 316,500 $56,000 75.000 131,000 $65,000 78,000 143,000 Liabilities & Shareholders' Equity Liabilities Current Liabilities Non-current liabilities Total Liabilities Shareholders' Equity Common Shares Retained Earnings Total Shareholders' Equity...

  • please do Waterloo Corporation Statement of Financial Position 31-Dec 2015 2014 2013 Assets Cash $32,000 $19,000...

    please do Waterloo Corporation Statement of Financial Position 31-Dec 2015 2014 2013 Assets Cash $32,000 $19,000 $10,000 Accounts Receivable (net) 95,000 70,000 53,000 Inventory 81,000 71,000 53,000 Other current assets 65,000 49,000 61,000 Long-term investments 120,000 76,000 50,000 Property, Plant & Equipment (net) 598,000 345,000 315.000 Total Assets $991,000 $630,000 $542,000 $71,500 245.000 316,500 $56,000 75.000 131,000 $65,000 78,000 143,000 Liabilities & Shareholders' Equity Liabilities Current Liabilities Non-current liabilities Total Liabilities Shareholders' Equity Common Shares Retained Earnings Total Shareholders' Equity...

  • 5. Calculate the 2015 financial ratios for Phocbe Corporation rounded to the nearest tenth and put...

    5. Calculate the 2015 financial ratios for Phocbe Corporation rounded to the nearest tenth and put a checkmark in tbe row in which Phorbe's ratios are better than the industry average: Ratio Gross Profit Margin Net Profit Margin Current Ratio Inventory Turnover Receivables Turnover Phoebe Corporation (2015) Industry Averages Phocbe is Better 55.0% 27.5% 3.3 % % 15.5 8.5 Select Financial Ratios What It Measures Eficiency of operations and product pricing Lisiency afher all expenses are considered Short-run debt-paying ability...

  • From the following financial statement calculate the following Ratios: Liquidity: a) Current Ratio b) Inventory Turnover...

    From the following financial statement calculate the following Ratios: Liquidity: a) Current Ratio b) Inventory Turnover Solvency: c) Debt to Total Assets Ratio d) Times Interest Earned Ratio Profitability: e) Return on Assets f) Profit Margin 9 Selected Statement of Financial Position Information 2019 ($'000) 2018 ($'000) 10 11 Cash and Cash Equivalents 12 Trade Receivables 13 Inventories 14 Total Current Assets 15 Total Assets 16 Total Current Liabilities 17 Total Liabilities 18 Retained Earnings 19 Shareholders Equity 20 21...

  • Question 1 The comparative data from the statement of financial position of Azam Berhad at 31...

    Question 1 The comparative data from the statement of financial position of Azam Berhad at 31 December, 2016 and 2017 are as follows. Comparative data on current assets and current liabilities at 31 December 2017 I 2017 2016 I RM RM Current Assets Inventories 454.500 ||490.200 Accounts receivable I 174.100 1190.750 Prepaid expenses 17.100 119.200 Cash and cash equivalents T136.500 17.550 Current Liabilities Accounts payable Short-term bank loan 11117,450 ||123.450 117.250 III.250 Statement of profit or loss for the year...

  • Problem 14-5A Condensed statement of financial position and income statement data for Speedway Corporation follow: 2016...

    Problem 14-5A Condensed statement of financial position and income statement data for Speedway Corporation follow: 2016 $17,900 48,100 63,700 129,700 SPEEDWAY CORPORATION Statement of Financial Position December 31 2018 2017 Assets Current assets Cash $25,200 $20,100 Accounts receivable (net) 55,300 45,300 Inventory 100,000 85,100 Total current assets 180,500 150,500 Long-term investments 57,500 69,700 Property, plant, and equipment (net) 498,900 371,800 Total assets $736,900 $592,000 Liabilities and Shareholders' Equity Liabilities Current liabilities $85,700 $79,600 Non-current liabilities 155,700 85,400 Total liabilities 241,400...

  • Show step by step working claculations Income Statement compared with Industry Average For the year ended 30th June 201...

    Show step by step working claculations Income Statement compared with Industry Average For the year ended 30th June 2016 Peters Industry Average 100.0% Net sales $972,500 Cost of sales 653.520 65.8 34.2 Gross profit Selling and general expenses Other expenses Profit 318,980 201,308 5.835 19.7 04 Peters Retailers Pty Statement of financial Position compared with Industry Average as at 30h June 2016 Peters Industry Average $406,800 70.9% 151,200 23.6 0.8 Current assets Property, plant and equipment, net Intangible assets, net...

  • 2015 to compare 4-9. (Ratio analysis) The financial statements and industry norms are shown be for...

    2015 to compare 4-9. (Ratio analysis) The financial statements and industry norms are shown be for Pamplin, Inc.: a. Compute the financial ratios for Pamplin for 2014 and for 2015 to com both against the industry norms. b. How liquid is the firm? c. Areits managers generating an adequate operating profit on the firm's d. How is the firm financing its assets? e. Are its managers generating a good return on equity? INDUSTRY NORN 5.00 3.00 2.20 90.00 0.33 Current...

  • PROBLEM 1-8 Financial Statement Ratio Analysis The balance sheet and income statement for Chico Electronics are...

    PROBLEM 1-8 Financial Statement Ratio Analysis The balance sheet and income statement for Chico Electronics are reproduced below (tax rate is 40%) CHICO ELECTRONICS Balance Sheet($thousands) As of December 31 Year 4 Year 5 $ 683 1.490 1,415 $ 325 3,599 2,423 13 6,360 1,541 $8,058 $ 875 116 Assets Current assets Cash Accounts receivable.. Inventories.......... Prepaid expenses ........ Total current assets ....... Property, plant and equipment, net. Other assets.. Total assets .... . Liabilities and Shareholders' Equity Current liabilities...

  • Use the following financial statement information for Stowe Enterprises to solve Prob- lems 2A.4 through 2A.7:...

    Use the following financial statement information for Stowe Enterprises to solve Prob- lems 2A.4 through 2A.7: STOWE ENTERPRISES Statement of Comprehensive Income $4,500 2,400 500 Earnings before interest and taxes $1,600 480 $1,120 380 S 740 $ 186 554 2015 Sales Cost of goods sold Depreciation Interest paid Taxable income Taxes Net income Addition to retained earnings Dividends STOWE ENTER PRISES Abbreviated Statement of Financial Position, 2014-2015 2014 2015 Liabilities and 2014 2015 Assets shareholders' equity Current liabilities Current assets...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT