Country: Burkina Faso
You are in the Burkina Faso edition. Type your country to switch.
Nigeria
Africa
Loading every country…
No country matches. Check the spelling, or choose "Any country" for the Global edition.
You are learning in the Burkina Faso edition, with examples in cfa francs and from Burkina Faso.
Your learning profile
Statistics and fundamental analytics · Lesson 8 of 8
Building a simple valuation model from data
A simple valuation model turns stated assumptions into a value range. Separate inputs, history, forecast, valuation and checks; derive a few drivers from cleaned data; value next year's free cash flow with a constant-growth formula; cross-check with peers; and show the sensitivity.
This lesson is complete in writing. A video for it is on its way.
What you will learn
- By the end you can lay out a simple valuation model with separate inputs, history, forecast, valuation and checks.
- You can turn historical data into a small set of forecast drivers and a year-one free cash flow.
- You can value the equity with a constant-growth formula and cross-check it with a peer multiple.
- You can build a sensitivity table and keep an assumptions log so the model can be reviewed.
Key terms in this lesson
- CAGR
- Compound annual growth rate: the steady yearly rate that would take a starting value to an ending value over a given number of years.
- Free cash flow
- Cash from operations minus spending on long-term assets; the cash a company can really use.
- Discounted cash flow
- A valuation method that adds up a business's expected future cash flows, each discounted back to today's value.
- Gordon growth model
- A valuation formula that assumes cash flow grows at a constant rate for ever: value equals next year's cash flow divided by the discount rate minus the growth rate.
- Sensitivity analysis
- Changing one or two inputs of a model at a time to see how much the result moves, often shown as a table.
- Scenario analysis
- Working out the effect on a portfolio of a set of linked market moves, either replayed from history or imagined.
- Assumptions log
- A record of each assumption in a model with its value, reason or source, date and author, so the model can be reviewed and updated.
- Step 1: The shape of a good model, not started
- Step 2: From history to drivers, not started
- Step 3: Next year's free cash flow, not started
- Step 4: From cash flow to a value per share, not started
- Step 5: Sensitivity: how much does each assumption matter?, not started
- Step 6: Sanity checks and the assumptions log, not started
About 10 min of reading
Step 1 of 6
The shape of a good model
Opening this step…
Step 2 of 6
From history to drivers
This step opens when you finish the one above.
Step 3 of 6
Next year's free cash flow
This step opens when you finish the one above.
Step 4 of 6
From cash flow to a value per share
This step opens when you finish the one above.
Step 5 of 6
Sensitivity: how much does each assumption matter?
This step opens when you finish the one above.
Step 6 of 6
Sanity checks and the assumptions log
This step opens when you finish the one above.
Key takeaways
The key takeaways open when you finish every step.
Lesson quiz
6 questions. You need 85% to pass.
The quiz opens when you finish every step.
Read first
Stockertim Learn is education. It explains how investing works and never recommends buying or selling anything.
Popular this week: Basics: BeginnerBurkinabè markets: Beginner