Back to Assignment Attempts: Keep the Highest: /12 1. 7: Analysis of Financial Statements: Tying the Ratios Together Tying the Ratios Together The DuPont equation shows the relationships among asset management, debt management, and -Select ratios. Management can use the DuPont equation to analyze ways of improving the firm's performance. Its equation is: ROE - Profit margin x Total assets turnover x Equity multiplier Ratio analysis is important to understand and interpret financial statements; however, sound financial analysis involves more than just calculating a interpreting numbers. Select factors also need to be considered. Quantitative Problem: Rosnan Industries' 2014 and 2013 balance sheets and income statements are shown below. Balance Sheets: 2014 2013 Cash and equivalents $70 $55 Accounts receivable 275 300 Inventories 375 350 Total current assets $720 $705 Net plant and equipment 2,000 1,490 Total assets $2,720 $2,195 Total assets $2,720 $2,195 $150 75 120 Accounts payable Accruals Notes payable Total current liabilities Long-term debt Common stock Retained earnings Total liabilities and equity $345 450 1,225 700 $85 50 145 $280 290 1,225 400 $2,720 $2,195 Income Statements: Sales Operating costs excluding depreciation EBITDA Depreciation and amortization EBIT Interest EBT Taxes (40%) Net income 2014 $2,000 1,250 $750 100 $650 62 $588 235 $353 2013 $1,500 1,000 $500 75 $425 45 $380 152 $228 Dividends paid Addition to retained earnings $53 $300 $48 $180 Shares outstanding Price WACC 100 $25.00 10.00% 100 $22.50 What is the firm's 2014 current ratio? Round your answer to two decimal places. The 2014 current ratio indicates that Rosnan has - Select current assets to meet its current obligations as they come due. What is the firm's 2014 total assets turnover ratio? Round your answer to four decimal places. Given the 2014 current and total assets turnover ratios calculated above, if Rosnan's 2014 quick ratio is 1.0 then an analyst might conclude that Rosnan's fixed assets are managed -Select- What is the firm's 2014 debt-to-capital ratio? Round your answer to two decimal places If the industry average debt-to-capital ratio is 30%, then Rosnan's creditors have a -Select- cushion than indicated by the industry average. What is the firm's 2014 profit margin? Round your answer to two decimal places % If the industry average profit margin is 12%, then Rosnan's lower than average debt-to-capital ratio might be one reason for its high profit margin. -Select- v What is the firm's 2014 price/earnings ratio? Round your answer to two decimal places. Using the DuPont equation, what is the firm's 2014 ROE? Round your answer to two decimal places. % Back to Assignment Attempts: Keep the Highest: /12 1. 7: Analysis of Financial Statements: Tying the Ratios Together Tying the Ratios Together The DuPont equation shows the relationships among asset management, debt management, and -Select ratios. Management can use the DuPont equation to analyze ways of improving the firm's performance. Its equation is: ROE - Profit margin x Total assets turnover x Equity multiplier Ratio analysis is important to understand and interpret financial statements; however, sound financial analysis involves more than just calculating a interpreting numbers. Select factors also need to be considered. Quantitative Problem: Rosnan Industries' 2014 and 2013 balance sheets and income statements are shown below. Balance Sheets: 2014 2013 Cash and equivalents $70 $55 Accounts receivable 275 300 Inventories 375 350 Total current assets $720 $705 Net plant and equipment 2,000 1,490 Total assets $2,720 $2,195 Total assets $2,720 $2,195 $150 75 120 Accounts payable Accruals Notes payable Total current liabilities Long-term debt Common stock Retained earnings Total liabilities and equity $345 450 1,225 700 $85 50 145 $280 290 1,225 400 $2,720 $2,195 Income Statements: Sales Operating costs excluding depreciation EBITDA Depreciation and amortization EBIT Interest EBT Taxes (40%) Net income 2014 $2,000 1,250 $750 100 $650 62 $588 235 $353 2013 $1,500 1,000 $500 75 $425 45 $380 152 $228 Dividends paid Addition to retained earnings $53 $300 $48 $180 Shares outstanding Price WACC 100 $25.00 10.00% 100 $22.50 What is the firm's 2014 current ratio? Round your answer to two decimal places. The 2014 current ratio indicates that Rosnan has - Select current assets to meet its current obligations as they come due. What is the firm's 2014 total assets turnover ratio? Round your answer to four decimal places. Given the 2014 current and total assets turnover ratios calculated above, if Rosnan's 2014 quick ratio is 1.0 then an analyst might conclude that Rosnan's fixed assets are managed -Select- What is the firm's 2014 debt-to-capital ratio? Round your answer to two decimal places If the industry average debt-to-capital ratio is 30%, then Rosnan's creditors have a -Select- cushion than indicated by the industry average. What is the firm's 2014 profit margin? Round your answer to two decimal places % If the industry average profit margin is 12%, then Rosnan's lower than average debt-to-capital ratio might be one reason for its high profit margin. -Select- v What is the firm's 2014 price/earnings ratio? Round your answer to two decimal places. Using the DuPont equation, what is the firm's 2014 ROE? Round your answer to two decimal places. %
