Excel worksheet – Ratio analysis
Description
Read the Forge Group Ltd.Preview the document [PDF] case study (same case study from Unit 5) and complete the following requirements.
Quantitative Analysis:
For the years ending June 30, 2014, and June 30, 2011, compute:
the return on equity (ROE)
return on assets (ROA)
profit margin ratio
asset turnover ratio
current ratio
cash flow ratio
debt-to-equity ratio
interest coverage ratio
debt coverage ratio
NTAB
EPS
DPS
PER