Quantitative Analysis and Excel

Read the Forge Group Ltd. attached below case study (same case study from before 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

Qualitative Analysis: 

In a 2 page report, discuss the results of your ratio analysis and what the analysis tells you about FGL.

Deliverables

• Quantitative Analysis (Excel Required): You are required to use the provided Excel workbook to complete the quantitative analysis for this assignment.
• Qualitative Analysis (Word Required): Prepare a 2- page summary addressing the required qualitative analysis as noted in the Student Workbook.  Your paper is required to be formatted according to APA requirements.  Be sure to incorporate key concepts from this unit's readings and properly cite your references according to APA requirements.  Do NOT embed the results of your quantitative analysis in your Word document.  You should only reference parts of your quantitative analysis in your written analysis.  Your written responses to the qualitative prompts should not to be presented in a question and answer format.