I. Excel Model (5 pages)
- Research financial information
- Recreate financial statements for the most recent 6 years.
- Prepare financial analyses for the past 5 years.
- Assess the quality of the information.
- Calculate the value of the firm.
- Prepare forecasted financial statements for the next 3 years.
II. Narrative write-up (5 pages) - Background
- Profitability Analysis
- Risk Analysis
- Analysis of the Company
- Ethics & Faith Integration
- Recommendations