Question

X cut 11 - General AA == A 2 Wrap Test Merge & Center WE ormat Painter Clipboard $ % -98 Conditional Formatas Cell Formatting Table Styles Insert Delete format 199 D E G H B C LAKE OF EGYPT MARINA, INC Balance Sheet as of December 31, 2018 and 2017 in millions of dollars) 2017 Current assets: Cash and marketable securities 2018 liabilities and Equity Current liabilities: Accrued's Accounts payable Notes payable 100 $ 8 ACCO 104 424 9 Inventory 10 11 Total 12 Fixed assets 13 Gross plant and equipment 14 Less: Depreciation 120 Long term debt: 435 Stockholders' equity Preferres 8S Common stock and 72 surplus (72 million shares) Retained earnings 275 72 1 3455 17! Net plant and equipment 18 Other long-term assets 20 Total Total $ 355 S 22 Total assets S 1,000 $ Total abils 1,000 $ LAKE OF EGYPT MARINA, INC. Income Statement for Years Ending December 31, 2018 and 2017 Sheet1 Select destination and press ENTER or choose Paste Type here to search о н е н $

Answer 1

	Formula
Current ratio	Current assets / Current liability	=605/210	2.88	Times
Quick ratio	(Current assets - inventory) / Current liability	=(605-415)/210	0.90	Times
Cash ratio	Cash & equivalent / Current liability	=100/210	0.48	Times
Inventory turnover	Sales / average inventory	=700/((415+208)/2)	2.25	Times
Days sales in inventory	365 / inventory turnover	=365/2.25	162.43	Days
Receivable turnover	Sales / average receivable	=700/((90+104)/2)	7.22	Times
Average collection period	365 / Receivable turnover	=365/7.22	50.58	Days
Payable turnover	COGS / average payables	=392/((70+88)/2)	4.96	Times
Average payment period	365 / Payable turnover	=365/4.96	73.56	Days
Fixed asset turnover	Sales / average fixed assets	=700/((345+328)/2)	2.08	Times
Sales to working capital	Sales / (current assets - current liabilities)	=700/(605-210)	1.77	Times
Total asset turnover	Sales / average total assets	=700/((1000+800)/2)	0.78	Times
Capital intensity	Total assets / Total revenue	=1000/700	1.43	Times
Debt ratio	Total liabilities / Total assets	=(435+210)/1000	64.50%	%
Debt to equity ratio	(ST debt + LT debt) / Equity	=(435+60)/355	1.39	Times
Equity multiplier ratio	Total assets / (Common equity + retained earnings)	=1000/(275+72)	2.88	Times
Times interest earned	EBIT / Interest	=231/21	11.00	Times
Cash cover	Cash / Total liabilities	=100/(435+210)	15.50%
Profit margin	Net income / Sales	=147/700	21.00%
Gross Profit margin	Gross profit / Sales	=308/700	44.00%
Basic earning power	EBIT / Total assets	=231/1000	23.10%
ROA	Net income / Total assets	=147/1000	14.70%
ROE	Net income after preferred dividend / (Common equity + retained earnings)	=139/(72+275)	40.06%
Dividend pay-out	Dividend / EPS	=1/1.931	51.79%
Market to book	Market price per share / Book value per share	=15.45/4.819	3.21	Times
P/E	Market price per share / Earnings per share	=15.45/1.931	8.00	Times