Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate the ROE for 2018 and 2019. Calculate the ROA for 2018 and 2019. Calculate the Profit margin, Total Asset Turnover and Equity Multiplier for

image text in transcribedimage text in transcribedimage text in transcribed
  • Calculate the ROE for 2018 and 2019.
  • Calculate the ROA for 2018 and 2019.
  • Calculate the Profit margin, Total Asset Turnover and Equity Multiplier for 2018 and 2019.(Dupont Analysis)

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
2018 2019 Sales $ 1,157,300 $ 1,293,600 Depreciation 166,100 173,600 Cost of goods sold 397,900 470,700 Other expenses 94,600 82,400 Interest 77,600 92,600 Cash 606,700 646,600 Accounts receivable 803,400 942,700 Short-term notes payable 117,100 114,700 Long-term debt 2,032,000 2,463,600 Net fixed assets 5,088,800 5,427,300 Accounts payable 438,400 464,400 Inventory 1,428,300 1,528,800 Dividends 141,100 161,800 Tax rate 34% 34% Share Outstanding 10.000 10,000Financial Statements Balance sheet as of Dec. 31, 2018 Cash $ 606,700 Accounts payable $ 438,400 Accounts receivable 803,400 Notes payable 117,100 Inventory 1,428,300 Current liabilities $ 555,500 Current assets $ 2,838,400 Long-term debt $ 2,032,000 Net fixed assets $ 5,088,800 Owners' equity $ 5,339,700 Total assets $ 7,927,200 Total liab. & equity $7,927,200 Balance sheet as of Dec. 31, 2019 Cash 646,600 Accounts payable $ 464,400 Accounts receivable 942,700 Notes payable 114,700 Inventory 1,528,800 Current liabilities $ 579,100 Current assets $ 3,118, 100 Long-term debt $ 2,463,600 Net fixed assets $ 5,427,300 Owners' equity $ 5,502,700 Total assets 8,545,400 Total liab. & equity $ 8,545,4002018 Income Statement Sales $ 1, 157,300.00 Costs 397,900.00 Other expenses 94,600.00 Depreciation 166, 100.00 EBIT $ 498,700.00 Interest 77 600.00 EBT $ 421,100.00 Taxes 143,174.00 Net income $ 277,926.00 Dividends $ 141,100.00 Addition to retained earnings 136,826.002019 Income Statement Sales $ 1,293,600.00 Costs 470,700.00 Other expenses 82,400.00 Depreciation 173,600.00 EBIT $ 566,900.00 Interest 92,600.00 EBT $ 474,300.00 Taxes 161,262.00 Net income 313,038.00 Dividends $ 161,800.00 Addition to retained earnings 151,238.00Assumptions for 2020 Income Statement Sales increase 10.00% Costs/sales 35.00% Other expenses/sales 6.00% Depreciation $182,000 Interest $88,450 Taxes 34.00% Retention ratio 50% Assumptions for 2020 Balance sheet Cash increase of 1% Accounts receivable increase of 4% Inventory No change from 2019 Net fixed assets No change from 2019 Accounts payable decrease of 25% Notes payable decrease of 1% Long-term debt decrease of 2%

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

Contemporary Business Mathematics with Canadian Applications

Authors: S. A. Hummelbrunner, Kelly Halliday, K. Suzanne Coombs

10th edition

133052311, 978-0133052312

Students also viewed these Finance questions