---
title: "Building a simple financial model | Optimize All Academy"
description: "Why founders need a model A financial model is a structured way to turn assumptions into forecasts of revenue, costs, profit and cash. It helps you make…"
url: https://optimizeall.com/learn/entrepreneurship-and-business-models/simple-financial-model
updated: 2026-10-05
---

Entrepreneurship & Business Models · Financial modelling and fundraising basics · lesson 13 of 18 · 15 min

# Building a simple financial model

## Why founders need a model

A financial model is a structured way to turn assumptions into forecasts of revenue, costs, profit and cash. It helps you make decisions (hiring, pricing, marketing spend), understand how long your money will last, and explain your plan to partners and investors. The goal is not perfect prediction; it is clear thinking about drivers and risks.

## Structure: drivers, not guesses

Build forecasts from **drivers** you can reason about and test, not from arbitrary growth percentages.

```
Assumptions sheet (illustrative, monthly)
Marketing spend: 200,000
CAC: 2,000 → new customers = marketing / CAC = 100
Monthly churn: 4%
Price: 3,000 per month
Variable cost per customer: 600
Fixed costs: salaries 900,000; rent 150,000; software 50,000
```

Then calculate month by month:

```
Customers(t) = Customers(t−1) × (1 − churn) + New customers(t)
Revenue(t) = Customers(t) × price
Variable costs(t) = Customers(t) × variable cost
Contribution(t) = Revenue − variable costs
Operating profit(t) = Contribution − marketing − fixed costs
Cash(t) = Cash(t−1) + operating cash flow ± financing
```

## A three-part model

1. **Assumptions** (inputs), clearly labelled and sourced ("CAC from 3-week ad test").
2. **Calculations** (customers, revenue, costs, headcount plan).
3. **Outputs**: monthly profit and loss summary, cash flow, key metrics (customers, CAC, LTV, burn, runway) and charts.

Keep inputs separate from formulas so you can change assumptions easily.

## Worked example: first six months

*Illustrative.* Using the assumptions above (in PKR), starting with zero customers:

| Month | New | Customers (end) | Revenue | Contribution | Marketing | Fixed | Operating result |
|---|---|---|---|---|---|---|---|
| 1 | 100 | 100 | 300,000 | 240,000 | 200,000 | 1,100,000 | −1,060,000 |
| 2 | 100 | 196 | 588,000 | 470,400 | 200,000 | 1,100,000 | −829,600 |
| 3 | 100 | 288 | 864,000 | 691,200 | 200,000 | 1,100,000 | −608,800 |
| 4 | 100 | 376 | 1,128,000 | 902,400 | 200,000 | 1,100,000 | −397,600 |
| 5 | 100 | 461 | 1,383,000 | 1,106,400 | 200,000 | 1,100,000 | −193,600 |
| 6 | 100 | 543 | 1,629,000 | 1,303,200 | 200,000 | 1,100,000 | +3,200 |

(Customers rounded; revenue assumes customers pay for the full month.) With these assumptions, the business reaches operating break-even around month 6. Cumulative losses before then are about 3.1 million, which is the minimum funding needed, plus a buffer for things going worse than planned.

## Scenarios

Build at least three scenarios:

- **Base case:** most likely assumptions.
- **Downside:** higher CAC, higher churn, slower sales.
- **Upside:** better conversion or pricing.

For example, if CAC is 3,000 instead of 2,000, new customers fall to about 67 per month and break-even moves much later. The downside case determines how much buffer you need.

## Model hygiene

- One assumption per cell, labelled with units and source.
- No hard-coded numbers inside formulas.
- Consistent monthly timeline.
- Checks: cash balance matches cash flow; customers never negative.
- Version control: date and label each version.

## 2026 update: modelling with AI (and modelling AI costs)

**Using AI assistants to build models.** Spreadsheet assistants built into tools such as Google Sheets and Microsoft Excel, and general assistants such as Claude or ChatGPT, can draft formulas, explain someone else's model and spot inconsistencies. They can also produce plausible formulas that are subtly wrong. Keep control:

- Ask the assistant to **explain each formula in plain English**, then check two rows by hand.
- Never paste confidential financials into a tool whose terms allow training on your data; use business plans with appropriate data controls.
- Keep the **driver structure** yourself. AI is good at syntax; it does not know your business.

**Modelling AI costs as drivers.** If your product uses model APIs, add these assumptions and calculate them per customer per month rather than as a fixed "software" line:

```text
Tasks per customer per month        (driver, from usage data or pilot)
Cost per task                       (tokens x price + retries + tools; see unit economics)
Human review minutes per task       (driver) x loaded cost per minute
AI COGS(t) = Customers(t) x tasks per customer x (cost per task + review cost per task)
Contribution(t) = Revenue(t) - AI COGS(t) - other variable costs(t)
```

Add a scenario where cost per task rises (a better model is needed) and one where usage per customer doubles (a heavy-user segment grows).

## Hands-on: build the six-month model in a spreadsheet

1. Create three tabs: **Inputs**, **Calcs**, **Outputs**.
2. In Inputs, one assumption per row with a label, unit and source column ("CAC: 2,000 PKR, from 3-week ad test, checked 2026-09").
3. In Calcs, months across columns. Row formulas (Google Sheets / Excel syntax, month 2 in column C):

```text
New customers      =Inputs!$B$2/Inputs!$B$3                 (marketing / CAC)
Customers (end)    =B5*(1-Inputs!$B$4)+C4                   (previous x (1-churn) + new)
Revenue            =C5*Inputs!$B$5                          (customers x price)
Variable costs     =C5*Inputs!$B$6
Contribution       =C6-C7
Operating result   =C8-Inputs!$B$2-Inputs!$B$7              (contribution - marketing - fixed)
Cumulative result  =B10+C9
```

4. In Outputs, show monthly customers, revenue, operating result, cumulative cash need and a chart.
5. Add a **check row** (for example, customers must never be negative) and a scenario switch (base / downside / upside) that selects a different column of inputs.
6. Ask an AI assistant: "Explain every formula in the Calcs tab and flag any that reference the wrong row or mix units." Then verify its claims yourself.

## Common mistakes

- Top-down revenue ("1% of a huge market") instead of driver-based forecasts.
- Forgetting taxes, payment fees, refunds or hiring lags.
- Assuming hires are productive from day one.
- Ignoring churn.
- No downside scenario.

## Quick self-check

Can you explain, for each line in your forecast, which driver determines it and what evidence supports that driver? If a number is just a guess, mark it and plan a test.

## Comparing forecast with actuals

Once you have real data, compare each month's actual results with the forecast. Where did you differ, and why? Update assumptions with evidence: if actual CAC is higher than modelled, change it in the model rather than hoping it will improve. This turns your model into a learning tool and makes future forecasts more credible to partners and investors.

## Presenting your model

When sharing a model with investors or partners, lead with a one-page summary: key assumptions, customers, revenue, burn, runway and funding need under base and downside cases. Be ready to explain every assumption and how you tested it. Investors often care more about the quality of your reasoning than the precise numbers.

## Video lecture: Building a simple financial model

Lecture coming soon · 12 chapters · about 9 minutes. Read the full transcript below.

1. Building a simple financial model
2. Why it matters
3. Recipe, not photograph
4. Three tabs
5. Worked example 1: six months (illustrative, PKR)
6. Scenarios
7. AI costs as drivers
8. Worked example 2: AI bookkeeping (illustrative)
9. Watch me: core formulas
10. AI as a model checker
11. Common mistakes
12. Recap and try this now

## Lecture transcript

### Building a simple financial model

An investor asks you a simple question. If your customer acquisition cost goes up by half, when do you run out of money? If you have to say, I'll get back to you, you don't have a model. You have a spreadsheet of hopes. In this lecture, you'll learn to build a driver-based financial model, the kind where every number traces back to an assumption you can explain and test. You'll build six months of forecasts, add scenarios, include AI costs properly, and use AI assistants to check your work without handing over control.

### Why it matters

Why does this matter? A model isn't about predicting the future perfectly. Nobody can. It's about thinking clearly. It shows which assumptions matter most, how long your money lasts, and what has to be true for the plan to work. It helps you decide when to hire, how much to spend on marketing and what price you need. And it makes conversations with partners, lenders and investors far easier. Here's the key idea. Every number in your forecast should trace back to a driver you can explain and test.

### Recipe, not photograph

Here's an analogy. A good model is like a recipe, not a photograph of a cake. A photograph shows the result, but you can't change anything. A recipe shows the ingredients and the method, so if you want a bigger cake or less sugar, you change the ingredients and the result follows. Top-down forecasts, like we'll capture one percent of a huge market, are photographs. Driver-based models are recipes. Marketing spend divided by CAC gives new customers. Last month's customers, minus churn, plus new customers, gives this month's customers. Customers times price gives revenue. Change an ingredient, and everything downstream updates.

### Three tabs

Now the structure. Three parts. First, an Inputs tab: one assumption per row, with a label, a unit and a source, like CAC two thousand rupees, from a three-week ad test. Second, a Calcs tab with months across the columns and the formulas: new customers, customers at the end of the month, revenue, variable costs, contribution, marketing, fixed costs and operating result. Third, an Outputs tab: a monthly summary, cumulative cash need, key metrics and a chart. The golden rule is never to type a raw number inside a formula. Always point to an input. That's what makes the model a recipe you can adjust.

### Worked example 1: six months (illustrative, PKR)

A simple worked example, illustrative, in Pakistani rupees. Marketing spend is two hundred thousand a month and CAC is two thousand, so a hundred new customers a month. Churn is four percent. Price is three thousand a month, and variable cost six hundred, so contribution is two thousand four hundred per customer. Fixed costs are one point one million. Month one: a hundred customers, three hundred thousand revenue, a loss of about one point zero six million. By month six, with about five hundred and forty customers, the business roughly breaks even. Add up the losses before then and you get about three point one million. That's the minimum funding needed, before a buffer.

### Scenarios

Next, scenarios, because the base case is never what happens. Build at least three. A base case with your most likely assumptions. A downside case with higher CAC, higher churn and slower sales. And an upside case. In our example, if CAC rises from two thousand to three thousand, new customers fall to about sixty-seven a month, and break-even moves much later. That downside case is what decides how much buffer you need. A simple way to build this is a scenario switch: a cell where you choose base, downside or upside, and the Inputs tab picks the matching column of assumptions.

### AI costs as drivers

Now, if your product uses AI models, add AI costs as drivers, not as a fixed software line. The drivers are tasks per customer per month, cost per task, from the unit economics lesson, and human review minutes per task. AI cost of goods each month is customers times tasks per customer times the cost per task plus review. It flows straight into contribution. Then add two AI-specific scenarios. One where cost per task rises, because you need a better model for quality. And one where usage per customer doubles, because a heavy-user segment grows faster than you expected.

### Worked example 2: AI bookkeeping (illustrative)

Now a realistic scenario, illustrative. Sara runs an AI-assisted bookkeeping service in Manchester. Her first model had one line for software at two hundred pounds a month. When she rebuilt it with drivers, she found each client generated about four hundred AI tasks a month, and each task needed about half a minute of human review. At her team's loaded cost, the review time cost far more than the model usage. Her margin wasn't driven by technology at all. It was driven by review time. So she targeted her improvement work at reducing review, with better extraction and exception flags, instead of chasing a cheaper model.

### Watch me: core formulas

Watch me build the core formulas. In the Calcs tab, column C is month two. New customers equals marketing spend divided by CAC, both pointing to the Inputs tab with fixed references. Customers at the end equals last month's customers times one minus churn, plus this month's new customers. Revenue equals customers times price. Variable costs equal customers times variable cost. Contribution is revenue minus variable costs. Operating result is contribution minus marketing minus fixed costs. And a cumulative row adds each month to the last. Then I add a check row that turns red if customers ever go negative. The exact formulas are in the lesson text.

### AI as a model checker

Now, can an AI assistant help? Yes, with care. Spreadsheet assistants in tools like Google Sheets and Excel, and general assistants like Claude or ChatGPT, can draft formulas, explain someone else's model and spot inconsistencies. But they can also produce formulas that look right and are subtly wrong, like referencing the wrong row. So ask the assistant to explain every formula in plain English and flag anything that mixes units or references the wrong row. Then check two rows by hand. And don't paste confidential financials into a tool whose terms allow training on your data. AI is good at syntax. It doesn't know your business.

### Common mistakes

Let's run through common mistakes. Top-down revenue instead of drivers. Forgetting taxes, payment fees, refunds and hiring lags. Assuming new hires are productive from day one. Ignoring churn. Having no downside scenario. Hard-coding numbers inside formulas. Treating AI costs as a fixed software line. And trusting AI-drafted formulas without checking them. Finally, compare your forecast with actuals every month. The gaps are where your learning is. If CAC is always higher than you assumed, your model is telling you something important about your channels.

### Recap and try this now

Let's recap. A good model is a recipe: inputs with sources, calculations built from drivers, and clear outputs. Build base, downside and upside scenarios, and let the downside set your buffer. If you use AI models, treat usage and review time as drivers of cost of goods. Use AI assistants to explain and check formulas, then verify by hand. Your try this now: build the three-tab, six-month model from the lesson for your idea, add a scenario switch, and find the month you break even in the downside case. Next, we'll turn that into a cash plan: runway and break-even.

## Key takeaways

- Build forecasts from testable drivers (CAC, churn, price, costs), not arbitrary growth rates.
- Separate assumptions, calculations and outputs; label inputs with sources.
- Customers(t) = previous × (1 − churn) + new; cumulative losses to break-even show funding need.
- Model base, downside and upside scenarios and size buffers on the downside.
- Model AI usage and human review time as per-customer drivers of cost of goods, and use AI assistants to explain and check formulas, not to replace your judgement.

## Try it

Build a 12-month driver-based model for your idea with base and downside scenarios, and identify the cumulative funding needed in each.

- [Previous: Funnels, metrics and retention](https://optimizeall.com/learn/entrepreneurship-and-business-models/funnel-metrics-and-retention)
- [Next: Cash, runway and break-even](https://optimizeall.com/learn/entrepreneurship-and-business-models/cash-runway-breakeven)
- [All lessons of Entrepreneurship & Business Models](https://optimizeall.com/learn/entrepreneurship-and-business-models)