Financial Forecast
Lab 3.3: Financial Forecast
Section titled “Lab 3.3: Financial Forecast”24-month financial model with projections
Start the Lab
Section titled “Start the Lab” Create financial projections
/CC.m3.lb3 What You’ll Learn
Section titled “What You’ll Learn”- Explain the components of a 24-month financial model including revenue streams, cost structures, and scenario analysis
- Create a multi-sheet Excel forecast using Claude Code’s xlsx skill with working formulas
- Analyse different business scenarios using best-case, base-case, and worst-case projections
Key Concepts
Section titled “Key Concepts”| Concept | Description |
|---|---|
| Assumptions Sheet | A dedicated sheet containing all editable inputs in one place, keeping data separate from calculations. |
| Revenue Projections | Month-by-month forecasts of income across different revenue streams such as retainers, projects, and workshops. |
| Fixed vs Variable Costs | Fixed costs remain constant (salaries, rent) whilst variable costs scale with revenue (marketing, travel). |
| P&L Summary | Profit and loss overview showing monthly and cumulative financial performance. |
| Scenario Analysis | Comparing conservative, base, and aggressive cases to understand how different assumptions affect outcomes. |
| Break-even Calculation | The point at which cumulative profit turns positive, indicating when the business becomes self-sustaining. |
| Dashboard | A summary sheet showing key metrics at a glance for quick decision-making. |
What You’ll Create
Section titled “What You’ll Create”financial-forecast.xlsx- 24-month XLSX model
Eureka Moment
Section titled “Eureka Moment”“This would take me days to build from scratch - and I’d probably get the formulas wrong. This actually calculates correctly.”
Navigation: Lab 2: Proposal PowerPoint | Module Overview | Lab 4: Business Plan