Become Financial Analyst
12 weeks · 4 milestones
Milestone map
Milestone map
3 milestones
Build a full three-statement financial model (income statement, balance sheet, and cash flow statement) for a real company using its public filings (annual report / 10-K / 20-F), or for a real business you have access to (your employer, a client, or your own). The model must be integrated — changes to revenue assumptions flow through to net income, to the balance sheet, and to the cash flow statement. It must also include a 3-year forecast with at least 3 clearly named and documented assumptions (revenue growth rate, gross margin, capex).
Proof required
Submit a Google Sheets or Excel file with the three statements, the integration checks (cash flow from balance sheet movement matches balance sheet change), and a separate assumptions tab naming and explaining the basis for each forecast assumption. Submit a 150-word note explaining which company you modelled and where you sourced the historical figures.
What gets checked
- Integration check passes — the ending cash balance on the cash flow statement matches the cash balance on the balance sheet for each period modelled
- Assumptions tab names the basis for each assumption ('revenue growth of 8% based on 3-year average CAGR from FY2021–FY2023') not just the value
- Historical figures match the published financial statements — pick 2 line items and verify them against the source filing