Apple Inc. Corporate Finance Modeling & DCF Valuation

Description
A realistic corporate financal model for a corporate organization with historical financial model.
The model includes:
1. Historical extract and analysis.
2. Historical financial statement restructuring.
3. Model inputs, drivers & assumptions.
4. Schedules & calculations.
5. Margin Analysis, Ratio Analysis, Scenarios & sensitivity of specific line item.
6. Valuation: DCF.
7. Dynamic summary worksheet with best practice of data visualization of IBCS.

Building a corporate model has a different concept, approach and methodology as compared to building for a startup business. Following this model can help you understand how to build a model for a corporate organization that has historical financials.
Assumptions in the data were gotten through research to make the model look realistic and follow the business trend.

This corporate financial model incorporate the best practise of building financial model as described by FAST standard.
Every model must be flexible, appropriate, structured and transparent, the model has been built with the standard and can be updated, adjusted and easy to understand.
On the summary worksheet, we have charts, tables, scenarios switch and financial summary to give and overview of the whole model to enable decision making.
The model cover a 3 year period historical financials and 5 year forecast period.