# Financial Model

> A spreadsheet of guesses that shows a firm's future cash and profit.

**Field:** Business & Startups  
**Category:** Corporate Finance  
**Also known as:** Financial Modeling, Financial Modelling, Three-Statement Model, Spreadsheet Model

## Think of it like

It is like a toy copy of the business on paper. Change one thing and watch what happens.

## Definition

A financial model is a spreadsheet that shows how a business makes and spends money. It starts with guesses, like how fast sales will grow. It turns those guesses into future income, cash and debts. You can change one guess and see the effect on everything else. Models are used to plan, to raise money and to value a firm.

## Example

Lucy's model says her shop makes $40,000 next year if sales grow 10%. She changes growth to 5%, and the profit drops to $25,000.

## Example code

```excel
B1  10%
B2  100000
B3  =B2*(1+B1)
    110000
```

B1 holds the growth guess. Change it, and next year's sales in B3 change with it.

## Why it matters

It shows which guesses matter most before you bet money on them. Investors expect one before they fund a firm.

## Common mistake

Trusting the output because the sheet looks exact. A model is only as good as the guesses typed into it.

## Three principles

- **Guesses in.** Growth, prices and costs go in.
- **Statements out.** Income, cash and debts come out.
- **Test the guesses.** Change one and see what moves.

## Related terms

- [Financial Forecast](https://learn.benibix.com/term/business/financial-forecast)
- [Discounted Cash Flow (DCF)](https://learn.benibix.com/term/business/discounted-cash-flow)
- [Business Budget](https://learn.benibix.com/term/business/business-budget)
- [Business Valuation](https://learn.benibix.com/term/business/business-valuation)
- [Terminal Value](https://learn.benibix.com/term/business/terminal-value)

![Five bars for years 1 to 5. Each has a faint outline of 100 dollars, and a shaded part that gets shorter each year, because cash further away is worth less today. On the right, a much taller bar in the accent colour labelled terminal value, standing for every year after year 5. A note says add every shaded bar together, and that sum is the value.](https://learn.benibix.com/diagrams/biz3-dcf.svg)

---

Source: https://learn.benibix.com/term/business/financial-model
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-19
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
