Skip to content
Edition NigeriaGlobal
Country

You are in the Global edition. Type your country to switch.

Set up your 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.

Intermediate10 min read6 steps

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 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.

Up next

Financial data & analyticsLab 1: reading CSV files in Pyth…Read nowLab 1: reading CSV files in Python and SQLFinancial data & analytics · Advanced · 15 minFinancial data & analyticsLab 2: computing returns in codeRead nowLab 2: computing returns in codeFinancial data & analytics · Advanced · 15 minFinancial data & analyticsLab 3: plotting prices and returnsRead nowLab 3: plotting prices and returnsFinancial data & analytics · Advanced · 15 minFinancial data & analyticsLab 4: SQL on a price tableRead nowLab 4: SQL on a price tableFinancial data & analytics · Advanced · 15 minValuation & company analysisDiscounted cash flow (DCF) valua…Read nowDiscounted cash flow (DCF) valuationValuation & company analysis · Advanced · 15 minFinancial data & analyticsPeer comparisonRead nowPeer comparisonFinancial data & analytics · Intermediate · 15 minFinancial data & analyticsRegression and betaRead nowRegression and betaFinancial data & analytics · Intermediate · 15 minValuation & company analysisMargin of safetyRead nowMargin of safetyValuation & company analysis · Advanced · 5 minFinancial data & analyticsBuilding a three-statement modelRead nowBuilding a three-statement modelFinancial data & analytics · Advanced · 15 minFinancial data & analyticsScenarios and sensitivities in a…Read nowScenarios and sensitivities in a modelFinancial data & analytics · Advanced · 15 minFinancial data & analyticsBuilding a DCF in a modelRead nowBuilding a DCF in a modelFinancial data & analytics · Advanced · 15 minFinancial data & analyticsPresenting a financial modelRead nowPresenting a financial modelFinancial data & analytics · Advanced · 15 min
English