Skip to content
Edition NigeriaGlobal
Country: Türkiye

You are in the Türkiye edition. Type your country to switch.

Set up your profile

You are learning in the Türkiye edition, with examples in lira and from Türkiye.

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