After upskilling myself in financial modeling I have created the Dynamic Three Statement Financial model of Amazon.com INC ( based on 2022 Annual Report )
This model contain
- 6 year forecast
- Projected Income Statement , Balance Sheet and Cash Flow Statement .
- Scenario Selector for Revenue
- PP&E Schedule
- Debt Schedule
- Line of Credit(Revolver) Schedule
- Shareholder Equity Schedule
When watching the course videos I was like it is simple you just have to plugin in number but after doing a real case study of the company and building the Financial Model from scratch , I came to understand that you have to read almost all part of annual reports ,especially notes to financial statement to understand about different account, create assumptions and projections based on that .
I now think best way to analyze a financial statement of a company is to create its financial model then you will be forced understand about the company instead of just reading annual report .
Had lots of fun creating this model . Although it took 2 days , I was in flow state most of the time .