Please complete each cell with the correct answer and numbers used to calculate
ID: 2424418 • Letter: P
Question
Please complete each cell with the correct answer and numbers used to calculate that cell. Example: 4+8=12
Profitability Ratios Gross Margin Operating Margin Return on Sales Return on Assets Return on Equity Earnings per Share (Sales-Cost of Goods Sold) ÷ (Sales)-GM (Profits Before Interest and Taxes) ÷ (Sales-OM (Net Income) ÷ (Sales) = ROS (Net Income ) ÷ (Total Assets) = ROA (Net Income) (Total Shareholder's Equity) ROE (Net Income-(# ofCommon Shares Outstanding,-EPS Liquidity Ratios Current Ratio Quick Ratio Times Interest Earned Current Assets) ÷(Current Liabilities)-current (Current Assets - Inventory)(Current Liabilities)-Quick (Profits Before Interest and Taxes) (Interest Expense)-TIE Leverage Ratios Debt to Assets Ratio Debt to Equity Ratio (Total Debt) ÷(Total Assets)-D/A (Total Debt) ÷(Total Shareholder's Equity,-D/E Activity Ratios Fixed Asset Turnover Total Asset Turnover Inventory Turnover (Sales-Property, Plant & Equipment, Net,-FAT (Sales) + (Total Assets) TAT (Cost ofGoods Sold) ÷ (inventory-Inventory Turn Valuation Ratio Price/Earnings Ratio (Market Price per Share) ÷ (Earnings per Share-P/E RatioExplanation / Answer
Income Statement Data 1990 1991 1992 1993 1994 Net Sales 77 97.00 133.74 144.21 116.18 Sales Growth N/A 25.97% Gross margin 29.61% 29.61% 29.61% 29.61% 29.61% Gross Profit 22.80 28.7 39.6 42.7 34.4 (Operating Margin + Gen. & Admn. Exp.) =77 X 29.61% Gross Margin ratio 29.61 29.61 29.61 29.61 29.61 Cost of Goods Sold 54.20 68.30 94.14 101.51 81.78 = 77 - 54.20 General & Admn. Exp. 17.6 21.3 26.2 28.3 36.3 Operating Margin 6.75% Operating Margin 5.20 7.4 13.4 14.4 -1.9 =77 X 6.75% Less: Tax 2.60 3.7 6.7 7.2 0 (50% of Operating Margin) = 5.20 -2.60 (Net Income) Net Income 2.6 3.7 6.7 7.2 -1.9 Net Income Growth N/A 42.31% 81.08% 7.46% -126.39% Balance Sheet Data Current ratio 2 2 2 2 2 Current Liabilities 8.54 10.75 14.83 15.99 12.88 = 17.07 / 2 (Current Ratio) Debt/Asset Ratio 53.06% 53.06% 53.06% 53.06% 53.06% Debt 18.24 22.98 31.68 34.16 27.52 = 34.38 X 53.06% Debt Equity Ratio 113.04% 113.04% 113.04% 113.04% 113.04% Equity 16.14 20.33 28.02 30.22 24.34 = 18.24 / 113.04% Total Liabilities 34.37 43.30 59.70 64.38 51.86 TAT 2.24 2.24 2.24 2.24 2.24 Total Assets 34.38 43.30 59.70 64.38 51.86 = 77 / 2.24 (TAT) FAT 4.45 4.45 4.45 4.45 4.45 Fixed Assets 17.30 21.80 30.05 32.41 26.11 = 77 / 4.45 Income Statement Data 1990 1991 1992 1993 1994 Net Sales 77 97.00 133.74 144.21 116.18 Sales Growth N/A 25.97% Gross margin 29.61% 29.61% 29.61% 29.61% 29.61% Gross Profit 22.80 28.7 39.6 42.7 34.4 (Operating Margin + Gen. & Admn. Exp.) =77 X 29.61% Gross Margin ratio 29.61 29.61 29.61 29.61 29.61 Cost of Goods Sold 54.20 68.30 94.14 101.51 81.78 = 77 - 54.20 General & Admn. Exp. 17.6 21.3 26.2 28.3 36.3 Operating Margin 6.75% Operating Margin 5.20 7.4 13.4 14.4 -1.9 =77 X 6.75% Less: Tax 2.60 3.7 6.7 7.2 0 (50% of Operating Margin) = 5.20 -2.60 (Net Income) Net Income 2.6 3.7 6.7 7.2 -1.9 Net Income Growth N/A 42.31% 81.08% 7.46% -126.39% Balance Sheet Data Current ratio 2 2 2 2 2 Current Liabilities 8.54 10.75 14.83 15.99 12.88 = 17.07 / 2 (Current Ratio) Debt/Asset Ratio 53.06% 53.06% 53.06% 53.06% 53.06% Debt 18.24 22.98 31.68 34.16 27.52 = 34.38 X 53.06% Debt Equity Ratio 113.04% 113.04% 113.04% 113.04% 113.04% Equity 16.14 20.33 28.02 30.22 24.34 = 18.24 / 113.04% Total Liabilities 34.37 43.30 59.70 64.38 51.86 TAT 2.24 2.24 2.24 2.24 2.24 Total Assets 34.38 43.30 59.70 64.38 51.86 = 77 / 2.24 (TAT) FAT 4.45 4.45 4.45 4.45 4.45 Fixed Assets 17.30 21.80 30.05 32.41 26.11 = 77 / 4.45 Current Assets 17.07 21.51 29.65 31.97 25.76 Assuming - 1. All Ratio are same for all the year Current Assets 17.07 21.51 29.65 31.97 25.76 Assuming - 1. All Ratio are same for all the year
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.