60.1K

Verified Solution

Link Copied!

Income Stmt info: Sales $ less Cost of Goods Sold: Gross Profit Operating Expenses Earnings before Interest & Taxes Interest exp earnings before Taxes Taxes Net Income $ 2018 1,000,000 $ 400,000 600,000 350,000 250,000 20,000 230,000 69,000 161,000 $ 2019 1,050,000 432,000 618,000 365,750 252,250 20,400 231,850 69,555 162,295 Balance Sheet info: Cash Accounts Receivable Inventory Total Current Assets Fixed Assets (Net) Total Assets 12/31/2018 25,000 $ 50,000 $ 125,000 $ 200,000 300,000 $ 500,000 $ 12/31/2019 30,000 54,000 130,000 214,000 318,000 532,000 $ Current Liabilities Long Term Liabilities Total Liabilities Stockholder's Equity Total Liab & Equity: 110,000 $ 180,000 $ 290,000 $ 210,000 500,000 $ 119,900 175,000 294,900 237,100 532,000 $ 210,000 to 2018 Compute each of the following ratios for 2018 and 2019 and indicate whether each ratio was getting "better" or "worse" from 2018 to 2019 and was "good" or "bad" compared to the Industry Avg in 2019 (round all numbers to 2 digits past the decimal place) "Good" or "Bad" Getting compared Better or 2019 Getting Industry Industry 2019 Worse? Avg Avg Profit Margin 0.11 Current Ratio 1.90 Quick Ratio 0.66 Return on Assets .28 Debt to Assets Receivables turnover 18.00 Avg. collection period* 15.50 Inventory Turnover** 9.25 Return on Equity 0.55 Times Interest Earned 13.20 .50 *Assume a 360 day year **Inventory Turnover can be computed 2 different ways. Use the formula listed in the text (the one the text indicates many credit reporting agencies generally use) Income Stmt info: Sales $ less Cost of Goods Sold: Gross Profit Operating Expenses Earnings before Interest & Taxes Interest exp earnings before Taxes Taxes Net Income $ 2018 1,000,000 $ 400,000 600,000 350,000 250,000 20,000 230,000 69,000 161,000 $ 2019 1,050,000 432,000 618,000 365,750 252,250 20,400 231,850 69,555 162,295 Balance Sheet info: Cash Accounts Receivable Inventory Total Current Assets Fixed Assets (Net) Total Assets 12/31/2018 25,000 $ 50,000 $ 125,000 $ 200,000 300,000 $ 500,000 $ 12/31/2019 30,000 54,000 130,000 214,000 318,000 532,000 $ Current Liabilities Long Term Liabilities Total Liabilities Stockholder's Equity Total Liab & Equity: 110,000 $ 180,000 $ 290,000 $ 210,000 500,000 $ 119,900 175,000 294,900 237,100 532,000 $ 210,000 to 2018 Compute each of the following ratios for 2018 and 2019 and indicate whether each ratio was getting "better" or "worse" from 2018 to 2019 and was "good" or "bad" compared to the Industry Avg in 2019 (round all numbers to 2 digits past the decimal place) "Good" or "Bad" Getting compared Better or 2019 Getting Industry Industry 2019 Worse? Avg Avg Profit Margin 0.11 Current Ratio 1.90 Quick Ratio 0.66 Return on Assets .28 Debt to Assets Receivables turnover 18.00 Avg. collection period* 15.50 Inventory Turnover** 9.25 Return on Equity 0.55 Times Interest Earned 13.20 .50 *Assume a 360 day year **Inventory Turnover can be computed 2 different ways. Use the formula listed in the text (the one the text indicates many credit reporting agencies generally use)

Answer & Explanation Solved by verified expert

See Answer