In: Finance
Use the following information to calculate the ratios listed
below:
Total Assets 650,000
Total Liabilities 300,000
Current Assets 60,000
Current Liabilities 20,000
Net Income 70,000
Shares Outstanding 12,000
Accounts Receivable 55,000
Sales 439,000
Inventory 25,000
Dividends 10,000
Quick Ratio ____________________
Earnings Per Share ___________________
Return on Assets _________________
Debt/Equity Ratio _______________
Days Sales in Receivables ______________
View keyboard shortcuts12pt
Paragraph
Ratio | Formula | Ratio |
Quick Ratio | Liquid asset/ current liability | 1.75 |
Earnings Per Share | (Net Income - Preferred Dividend) / No of shares outstanding | 5.00 |
Return on Assets | Net Icome / Total Assets | 10.77% |
Debt Equity Ratio | Debt/Equity | 0.80 |
Days Sales in Receivables | No of Days in the Period/Receivables Turnover Ratio | 45.11 |
Calculation:- | ||
1) Quick ratio= Liquid Current asset/ current liability | ||
Where, | ||
Liquid Current is Current Assets - Inventories | ||
Now, | ||
Liquid Current Assets | 60000 - 25000 = 35000 | |
Current liabilities | 20000 | |
Quick Ratio | Liquid Current asset/ current liability | |
Quick Ratio | 1.75 | |
2) Earnings Per Share = (Net Income - Preferred Dividend) / No of shares outstanding | ||
Net Income | 70000 | |
Dividend | 10000 | |
No of Share Outstanding | 12000 | |
Earnings Per Share | (70000 - 10000) / 12000 = 5 | |
3) Return on Assets = Net Income / Total Assets | ||
Net Income | 70000 | |
Total Assets | 650000 | |
Return on Assets | 10.77% | |
4) Debt Equity Ratio = Debt / Equity | ||
where, | ||
Debt = Total Liabilities - Current Liabilities | ||
Equity = Total Assets - Total Liabilities | ||
Debt | 300000 - 20000 = 280000 | |
Equity | 650000 - 300000 = 350000 | |
Debt Equity Ratio | 0.80 | |
5) Receivables Turnover Ratio = Net Credit Sales/ Average Accounts Receivable | ||
Now, | ||
Net Credit Sales | 439,000 | |
Average Accounts Receivable | 55000 | |
Receivables Turnover Ratio | Net Credit Sales/ Average Accounts Receivable | |
Receivables Turnover Ratio | 7.98 | |
Days Sales in Receivables = No of days in a Period/ Receivable Turnover Ratio | ||
Now, | ||
No of Days | 360 | |
Receivables Turnover Ratio | 7.98 | |
Days Sales Outstanding | 45.11 |