🏦Financial Model
Also known as Financial Modeling, Financial Modelling, Three-Statement Model, Spreadsheet Model
A spreadsheet of guesses that shows a firm's future cash and profit.
Think of it like
It is like a toy copy of the business on paper. Change one thing and watch what happens.
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.
Why it matters
It shows which guesses matter most before you bet money on them. Investors expect one before they fund a firm.
Definition
Example code
excel
B1 10%
B2 100000
B3 =B2*(1+B1)
110000Common mistake
Key takeaways
- 1Guesses in. Growth, prices and costs go in.
- 2Statements out. Income, cash and debts come out.
- 3Test the guesses. Change one and see what moves.