The 5 building blocks
- Assumptions sheetPut every input (growth rate, price, cost %) in one place.
- Revenue forecastUnits x price, by month or year.
- CostsFixed and variable costs separately.
- StatementsProfit and loss, cash flow, balance sheet linked by formulas.
- ScenariosBest, base and worst case switch.
A tiny worked example
A coffee cart sells 100 cups a day at Rs 60 for 30 days. Revenue = 100 x 60 x 30 = Rs 1,80,000 a month. Variable cost is Rs 25 a cup = Rs 75,000. Fixed cost is Rs 40,000. Profit before tax = 1,80,000 - 75,000 - 40,000 = Rs 65,000. (Illustrative numbers.) Now change cups per day to 70 and see profit fall. That is a scenario.
| Item | Formula | Result (Rs) |
|---|---|---|
| Revenue | 100 x 60 x 30 | 1,80,000 |
| Variable cost | 100 x 25 x 30 | 75,000 |
| Fixed cost | Input | 40,000 |
| Profit before tax | Revenue - costs | 65,000 |
Excel habits that make you look professional
- Blue for inputs, black for formulas
- One formula per row, copy across
- No hard-coded numbers inside formulas
- Add checks (balance sheet must balance)
- Label units and periods
Pro tipPractise on real data
Pick a listed company's public annual report and model one year ahead. Compare your assumptions with management commentary.
Strengthen the basics: Excel skills and financial statements.