could u plz help me with 19-24?
Common Size Balancesheet &Income statement Big Apple Enterprises 2016 2017 2016 Big Apple Enterprises Assets 2017 Cash 4500 6000 Assets Accounts Recievable 21000 21000 Cash 7.25% 8.57% Inventory 7500 8000 Accounts Recievable 33.87% 30% Current Assets 33000 35000 Inventory 12.09% 11.42% Current Assets 53.22% 50% Other Non current Assets 10500 9000 Net Fixed Assets 18500 26000 Other Non current Assets 16.93% 12.85% Total Assets 62000 70000 Net Fixed Assets 29.83% 37.14% Total Assets 100% 100% Liabilities Current Liabilities 20000 11000 Liabilities Debt 22000 29000 Current Liabilities 32.25% 15.71% Equity 20000 30000 Debt 35.48% 41.42% Total Liabilities & Equity 62000 70000 Equity 32.25% 42.85% Total Liabilities & Equity 100% 100% Income Statement Revenue 125000 145000 Income Statement Cost of Goods Sold 85000 110000 Revenue 100% 100% Gross Profit 40000 35000 68% Cost of Goods Sold 75.86% Gross Profit SG&A 20000 27000 Operating Profit (EBIT) 20000 8000 SG&A 16% 18.62% Operating Profit (EBIT) Interest expense 2800 3450 Earnings before taxes (EBT) 17200 4550 Interest expense 2.24% 2.38% Taxes 5160 1365 Earnings before taxes (EBT) Net Income After Tax 12040 3185 Taxes Net Income After Tax 3. Gross profit in 2017 Gross Profit = Revenue- COGS= 145000-110000= 35000 4. Gross margin Ratio=Gross profit/ Revenue Gross margin ratio in 2017= 35000/145000 = 24.13% 5. Operating profit= Gross profit- Operating Expenses Operating profit in 2017= 35000-27000= 8000 6. Pretax income EBIT-tax EBT in 2017= 8000-3450=4550 7. Income tax paid in 2017= 4550 x 30%= 1365 8. Net income after tax= EBT-Tax NIAT in 2017= 4550-1365= 3185 9. Net operating profit after tax= Operating income (1-tax rate) NOPAT in 2017 = 8000-30%= 5600 10. Times interest earned= EBIT/ Interest expenses TIE in 2017= 8000/3450= 2.32 times 11. Profit margin ratio= Net income Net sales Profit margin ratio in 2017= 3185/145000= 2.19% 12. Return on Assets = Net Income/ Average total assets ROA in 2017= 3185/66000= 4.82% 13. Return on equity= Net income/Shareholder's equity Return on equity in 2017= 3185/(2000x6)= 26.54% 14.Current ratio= current assets/ current liabilities current ratio in 2017= 35000/11000= 3.18 times 15. Quick ratio=Quick assets/ Current liabilities Quick ratio in 2017= 27000/11000= 2.45 time Yr. 2017 [19] What was the company's Debt-to-Equity ratio in 2017? Debt-to-Equity Ratio - Debt/Equity 96.67% [20] What was the company's Earnings Per Share (EPS) in 2017? EPS = (Net income - Preferred Dividens) /Weighted average common share outstanding 9.25% [21] What was the company's Price-Earnings (P/E) ratio in 2017? P/E Ratio = Market values per share / EPS [22] What was the company's Dividend Payout ratio (DPR) in 2017? DPR = Total dividend / Net income [23] What were the Dividends Per Share paid in 2017? Dividend Per Share = Dividens/Number of shares 94.19% [24] What was the Dividend Yield in 2017? Dividend Yield = Dividend per share / Market values per share Other Information Tax Rate Shares Outstanding Dividends paid Yr 2016 30% 2,000 3,000 Yr 2017 30% 2,000 3,000 Share Price $8.00 $6.00
