Given the following income statements and Balance sheet, find the following financial ratios Income Statement Sales revenue 30,000,000 Less cost of goods 21,000,000 Gross profit 9,000,000 Less operating expenses 6,000,000 Operating profit (EBIT) 3,000,000 Less interest expenses 1,000,000 Net profit before taxes 2,000,000 Less taxes (40%) 800,000 Net profit after tax 1,200,000 Less preferred stock dividends 100,000 Earnings available for common 1,100,000 Stock holders Balance Sheet Assets Liabilities Cash 1,000,000 Account payable 8,000,000 Marketable securities 3,000,000 Notes payable 8,000,000 Account receivable 12,000,000 Accruals 500,000 Inventory 7,500,000 Total Current Liab 16,500,000 Total current assets 23,500,000 long term debt 20,000,000 Net fixed assets 26,,500,000 Total Liab. 36,500,000 Total assets 50,000,000 Total equity 13,500,000 Total Liab. And equity 50,000,000 Purchases are .80 of cost of goods Number of shares are 2,500,000 shares Stock price is $35 per share Given the above information calculate the following rations. Write the formula for each ratio and plug the numbers in each formula and the unit that is used to measure the ratio, as time, $ of no unit. Current ratio = Quick( acid test) ratio = Inventory ratio = Average age of inventory = Average Collection period = Average payment period = Total assets turnover = Debt ratio = Time interest earned ratio Gross profit margin = Operating profit ratio = Net profit ratio = Earnings per share (EPS) = Return on Assets (ROA) = Return on Equity (ROE) = Price/Earnings (P/E) = Market/book (M/B) ratio =
Given the following income statements and Balance sheet, find the following financial ratios
Income Statement
Sales revenue 30,000,000
Less cost of goods 21,000,000
Gross profit 9,000,000
Less operating expenses 6,000,000
Operating profit (EBIT) 3,000,000
Less interest expenses 1,000,000
Net profit before taxes 2,000,000
Less taxes (40%) 800,000
Net profit after tax 1,200,000
Less
Earnings available for common 1,100,000
Stock holders
Balance Sheet
Assets Liabilities
Cash 1,000,000 Account payable 8,000,000
Marketable securities 3,000,000 Notes payable 8,000,000
Account receivable 12,000,000 Accruals 500,000
Inventory 7,500,000 Total Current Liab 16,500,000
Total current assets 23,500,000 long term debt 20,000,000
Net fixed assets 26,,500,000 Total Liab. 36,500,000
Total assets 50,000,000 Total equity 13,500,000
Total Liab. And equity 50,000,000
Purchases are .80 of cost of goods
Number of shares are 2,500,000 shares
Stock price is $35 per share
Given the above information calculate the following rations. Write the formula for each ratio and plug the numbers in each formula and the unit that is used to measure the ratio, as time, $ of no unit.
- Current ratio =
- Quick( acid test) ratio =
- Inventory ratio =
- Average age of inventory =
- Average Collection period =
- Average payment period =
- Total assets turnover =
- Debt ratio =
- Time interest earned ratio
- Gross profit margin =
- Operating profit ratio =
- Net profit ratio =
- Earnings per share (EPS) =
Return on Assets (ROA) =
Return on Equity (ROE) =
- Price/Earnings (P/E) =
- Market/book (M/B) ratio =
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 6 images
