Complete ratio analysis for the years 2010 through 2014, calculating the following ratios Use the unaudited data
Fantastic news! We've Found the answer you've been seeking!
Question:
Complete ratio analysis for the years 2010 through 2014, calculating the following ratios
Use the unaudited data for 2014. For any ratios that use an average of 2 years in the formula, you can assume that the 2010 ending balance approximates the 2010 average. (The ratios that use an average of 2 years in the formula include accounts receivable turnover, inventory turnover, return on assets, and return on equity.) You are not given the 2009 data to calculate the average for 2010, so you can assume that the average for 2010 is equal to the year-end balance. Show your calculations for each ratio or complete in Excel worksheet using formulas:
- Current ratio
- Receivables turnover
- Day’s sales in receivables
- Inventory turnover
- Inventory holding period
- Rate of return on net sales
- Rate of return on total assets
- Rate of return on stockholders’ equity
- Asset turnover
- EPS
- Debt ratio
- Times interest earned
- Provide a discussion of the company’s performance in terms of liquidity, profitability, and leverage. Be sure to discuss each ratio. In your discussion, identify the key indicators that showed the downfall of Forge Group.
Related Book For
Posted Date: