Question

Excel Fie Eat View Insert Format Tools Data Window Helo Complbity Mode Take home problemais · Home Insert Page Layout Formulas Data ReviawVe Formutsing sable Style Denald Jamlson was brought in as an assistant to Freida Pance, Electotron's chalrman, who had the task of getting he company back inte a sound financial pesition. Electotron's 2016 and 2017 balance sheets and income statements together with projections for 2018, are shown in the fellewing tables. A laancial ratios along with Industry average dats. The 2018 projected financial statement data represent Jamison's and Panco's best guess for 2018 results, assuming that some new financing is arranged to get the company "over the hump." 2016 and 2017 balance sheets and income statements put Data: 2016 58.50 100,000 40% $40,000 2017 2.25 100,000 40% 540,000 201 S12.17 250,000 10 Year-end common stock price 2Year-end shares outstanding 13 40% Tax rate $40,000 14 15 ease payments Required sinking fund payments 16 17 Balance Sheets 18 19 2017 $7,282 lssets Cash and equivalents Short-term investments Accounts receivable Inventories 2016 $9.000 $48,600 S351,200 5715,200 2018 $14,000 $71,632 21 $632,160 $1,287.360 878,000 24 $1,716.480 0

please need help on those blue space with answer.

thank you

Answer 1

	2016	2017	2018
Liquidity Ratio
current ratio	2.33	1.11	1.86
quick ratio	0.85	0.37	0.67
asset management ratio
inventory turnover	0.21	0.22	0.24
days sales outstanding	37.35	39.55	45.55
fixed asset turnover	0.10	0.16	0.12
total asset turnover	0.43	0.49	0.50
Debt management ratios
debt ratio	0.55	0.95	0.56
times interest ratio	3.35	(3.92)	6.28
ebidta coverage ratio	2.43	(3.01)	4.52
profitability ratio
profit margin	0.03	(0.09)	0.04
basic earning power	0.14	(0.24)	0.14
return on asset
return on equity
Market Value Tatio
price to earning ratio	9.66	(0.04)	12.00
price to cash flow ratio	8.50	2.25	12.17
market to book ratio
book value per share