Evaluate Stock Price With Reverse-Engineering DCF (2024)

If you've ever thumbed through a stock analyst's report, you will have probably come across a stock valuation technique called the discounted cash flow (DCF) analysis. DCF entails forecasting future company cash flows, applying a discount rate according to the company's risk, and coming up with a precise valuation or "target price" for the stock.

The trouble is that the job of predicting future cash flows requires a healthy dose of guesswork. However, there is a way to get around this problem. By working backward—starting with the current share price—we can figure out how much cash flow the company would be expected to make to generate its current valuation. Depending on the plausibility of the cash flows, we can decide whether the stock is worth its going price.

Key Takeaways

  • A reverse-engineered discounted cash flow (DCF) removes the guesswork of trying to estimate future cash flows.
  • Both the DCF and ratio analysis (i.e. comparable company analysis) yield imperfect valuations.
  • Reverse-engineering allows an analyst to remove some uncertainty—notably, this type of analysis starts with the share price (which is a known) rather than starting with estimating cash flows.
  • For a reverse-engineered DCF, if the current price assumes more cash flows than what the company can realistically produce, the stock is overvalued. If the opposite is the case, the stock is undervalued.

DCF Sets a Target Price

There are basically two ways of valuing a stock. The first, "relative valuation," involves comparing a company with others in the same business area, often using a price ratio such as price/earnings, price/sales, price/book value, and so on. It is a good approach for helping analysts decide whether a stock is cheaper or more expensive than its peers. However, it's a less reliable method of determining what the stock is really worth on its own.

As a consequence, many analysts prefer the second approach, DCF analysis, which is supposed to deliver an "absolute valuation" or bona fide price on the stock. The approach involves explaining how much free cash flow the company will produce for investors over, say, the next 10 years, and then calculating how much investors should pay for that stream of free cash flows based on an appropriate discount rate. Depending on whether it is above or below the stock's current market price, the DCF-produced target price tells investors whether the stock is currently overvalued or undervalued.

In theory, DCF sounds great, but like ratio analysis, it has its fair share of challenges for analysts. Among the challenges is the tricky task of coming up with a discount rate, which depends on a risk-free interest rate, the company's cost of capital, and the risk its stock faces.

But an even bigger problem is forecasting reliable future free cash flows. While trying to predict next year's numbers can be hard enough, modeling precise results over a decade is next to impossible. No matter how much analysis you do, the process usually involves as much guesswork as science. What's more, even a small, unexpected event can alter cash flows and make your target price obsolete.

Reverse-Engineering DCF

Discounted cash flow, however, can be put to use in another way that gets around the tricky problem of accurately estimating future cash flows. Rather than starting your analysis with an unknown, a company's future cash flows, and trying to arrive at a target stock valuation, start instead with what you do know with certainty about the stock: its current market valuation. By working backward, or reverse-engineering the DCF from its stock price, we can work out the amount of cash that the company will have to produce to justify that price.

If the current price assumes more cash flows than what the company can realistically produce, then we can conclude that the stock is overvalued. If the opposite is the case, and the market's expectations fall short of what the company can deliver, then we should conclude that it's undervalued.

Reverse-Engineered DCF Example

Here's a very simple example: Consider a company that sells widgets. We know for certain that its stock is at $14 per share and, with a total share count of 100 million, the company has a market capitalization of $1.4 billion. It has no debt, and we assume that its cost of equity is 12%. This year the company delivered $5 million in free cash flow.

What we don't know is how much the company's free cash flow will have to grow year after year for 10 years to justify its $14 share price. To answer the question, let's employ a simple 10-year DCF forecast model that assumes the company can sustain a long-term annual cash flow growth rate (also known as the terminal growth rate) of 3.0% after 10 years of more rapid growth. Of course, you can create multistage models that incorporate varying growth rates through the 10-year period, but for the purpose of keeping things simple, let's stick to a single-stage model.

Instead of setting up the DCF calculations yourself, spreadsheets that only require the inputs are usually already available. So using a DCF spreadsheet, we can reverse-engineer the necessary growth back to the share price. Lots of websites provide a free DCF template that you can download, including Microsoft.

Take the inputs that are already known: $5 million in initial free cash flow, 100 million shares, 3% terminal growth rate, 12% discount rate (assumed) and plug the appropriate numbers into the spreadsheet. After entering the inputs, the goal is to change the growth rate percentage in years 1-5 and 6-10 that will give you an intrinsic value per share (IV/share) of approximately $14. After a bit of trial and error, we come up with a 50% growth rate for the next 10 years, which results in a $14 share price. In other words, pricing the stock at $14 per share, the market is expecting that the company will be able to grow its free cash flow by about 50% per year for the next 10 years.

The next step is to apply your own knowledge and intuition to judge whether a 50% growth performance is reasonable. Looking at the company's past performance, does that growth rate make sense? Can we expect a widget company to more than double its free cash flow output every two years? Will the market be big enough to support that level of growth? Based on what you know about the company and its market, does that growth rate seem too high, too low, or just about right? The trick is to consider as many different plausible conditions and scenarios until you can say with confidence whether the market's expectations are correct and whether you should invest in it.

The Bottom Line

Reverse-engineered DCF doesn't eliminate all the problems of DCF, but it sure helps. Instead of hoping that our free cash flow projections are correct and struggling to come up with a precise value for the stock, we can work backward using information that we already know to make a general judgment about the stock's value.

Of course, the technique doesn't completely free us from the job of estimating cash flows. To assess the market's expectations, you still need to have a good sense of what conditions are required for the company to deliver them. That said, it is a much easier task to judge the plausibility of a set of forecasts rather than having to come up with them your own.

Evaluate Stock Price With Reverse-Engineering DCF (2024)

FAQs

Evaluate Stock Price With Reverse-Engineering DCF? ›

By working backward, or reverse-engineering the DCF from its stock price, we can work out the amount of cash that the company will have to produce to justify that price. If the current price assumes more cash flows than what the company can realistically produce, then we can conclude that the stock is overvalued.

How to determine stock price from DCF? ›

How to Value Stocks Using DCF? Valuing stocks using DCF is pretty much the same method when valuing a company but you just take one extra step. Once you have added all your future discounted cash flows together, you get the value of the business today. Then you simply divide this figure by the number of shares.

How do you value a company through DCF? ›

The following steps are required to arrive at a DCF valuation:
  1. Project unlevered FCFs (UFCFs)
  2. Choose a discount rate.
  3. Calculate the TV.
  4. Calculate the enterprise value (EV) by discounting the projected UFCFs and TV to net present value.
  5. Calculate the equity value by subtracting net debt from EV.
  6. Review the results.

How to do reverse DCF in Excel? ›

Reverse Discounted Cash Flow Example
  1. Step #1: Calculate Current Free Cash Flow (FCF0)
  2. Step #2: Determine the Number of Years in the Forecast Period.
  3. Step #3: Estimate FCF Growth Over the Forecast Period.
  4. Step #4: Estimate the Discount Rate.
  5. Step #5: Estimate Terminal Value.
  6. Step #6: Calculate the Intrinsic Value.
Jul 11, 2024

What is the DCF method of valuation of shares? ›

Discounted cash flow (DCF) is a method of valuation that's used to determine the value of an investment based on its return or future cash flows. The weighted average cost of capital (WACC) is typically used as a hurdle rate. The investment's return must outperform the hurdle rate.

How do you know if a stock is undervalued DCF? ›

For a reverse-engineered DCF, if the current price assumes more cash flows than what the company can realistically produce, the stock is overvalued. If the opposite is the case, the stock is undervalued.

What is the formula for predicting stock price? ›

This method of predicting future price of a stock is based on a basic formula. The formula is shown above (P/E x EPS = Price). According to this formula, if we can accurately predict a stock's future P/E and EPS, we will know its accurate future price.

Is DCF the best valuation method? ›

DCF Valuation is extremely sensitive to assumptions related to perpetual growth rate and discount rate. Any minor tweaking here and there, and the DCF Valuation will fluctuate wildly and the fair value so generated won't be accurate. It works best only when there is a high degree of confidence about future cash flows.

When would you not use a DCF in a valuation? ›

Also, since the very focus of DCF analysis is long-term growth, it is not an appropriate tool for evaluating short-term profit potential. Besides, as an investor, it's wise to avoid being too reliant on one method over another when assessing the value of stocks.

Can you use a DCF to value a private company? ›

The discounted cash flow method of valuing a private company, the discounted cash flow of similar companies in the peer group is calculated and applied to the target firm. The first step involves estimating the revenue growth of the target firm by averaging the revenue growth rates of the companies in the peer group.

How to value stocks like a professional? ›

Price-to-earnings (P/E) multiples are one of the most commonly used valuation metrics and are based on company earnings, a.k.a. profit. You simply take the company in question's share price and divide that by its earnings per share (EPS). Or you can just go to – you guessed it – Yahoo Finance.

What is reverse factor modeling in the stock market? ›

The Reverse DCF model is a backward-looking valuation method that calculates the market's implied expectations for a company's potential future growth. The DCF model calculates the present value of a company's future cash flows prospectively.

How to use DCF to calculate stock price? ›

How to Use DCF to Value Stocks
  1. Take the average last three years of the company's cash flow.
  2. Multiply the FCF with the expected growth rate to get the FCF for the future.
  3. Calculate the value of that cash flow by dividing it by the discount factor.
Aug 10, 2022

How to value a company using DCF? ›

The 8 steps to completing a DCF valuation are listed below (and on the table of contents), and will be covered after the next section.
  1. Step 1: Free Cash Flow.
  2. Step 2: Discount Rate.
  3. Step 3: Perpetual Growth Rate.
  4. Step 4: Terminal Value.
  5. Step 5: Shares Outstanding.
  6. Step 6: Discount Back and Find Intrinsic Value.

How to do DCF in Excel? ›

To calculate the DCF in Excel, follow these steps:
  1. Step 1: Organize Your Data. ...
  2. Step 2: Calculate Present Value for Each Cash Flow. ...
  3. =CashFlow / (1 + DiscountRate)^Year. ...
  4. =B2 / (1 + $F$2)^A2. ...
  5. Step 3: Calculate the Present Value of Terminal Value. ...
  6. =TerminalValue / (1 + DiscountRate)^LastYear. ...
  7. Step 4: Sum the Present Values.
Oct 9, 2023

What is the equation to determine stock price? ›

We can calculate the stock price by simply dividing the market cap by the number of shares outstanding. Let's now think about why we can calculate it this way. The Market Cap (aka Market Capitalization) reflects the market value of the equity of the company.

How do you find the intrinsic value of a stock using DCF? ›

To perform a DCF analysis, you'll need to follow three steps:
  1. Estimate all of a company's future cash flows.
  2. Calculate the present value of each of these future cash flows.
  3. Sum up the present values to obtain the intrinsic value of the stock.

What is the best way to calculate stock price? ›

The most common way to value a stock is to compute the company's price-to-earnings (P/E) ratio. The P/E ratio equals the company's stock price divided by its most recently reported earnings per share (EPS).

How do you calculate cost of equity using DCF? ›

We calculate the cost of equity using the formula Rs = RRF + (RPM * b), where,
  1. RRF: the risk-free rate or 10-year Treasury Rate.
  2. RPM: the return that the market expects or Risk Premium.
  3. b: the stock's beta (systemic risk)
Jun 15, 2022

Top Articles
Does the Settlement Date Have to Occur Before the Ex-Dividend Date to Receive a Dividend? | The Motley Fool
Tier 3 Capital: Definition, Examples, vs. Tier 1 and Tier 2
Katie Pavlich Bikini Photos
Gamevault Agent
Hocus Pocus Showtimes Near Harkins Theatres Yuma Palms 14
Free Atm For Emerald Card Near Me
Craigslist Mexico Cancun
Hendersonville (Tennessee) – Travel guide at Wikivoyage
Doby's Funeral Home Obituaries
Vardis Olive Garden (Georgioupolis, Kreta) ✈️ inkl. Flug buchen
Select Truck Greensboro
Things To Do In Atlanta Tomorrow Night
How To Cut Eelgrass Grounded
Pac Man Deviantart
Alexander Funeral Home Gallatin Obituaries
Craigslist In Flagstaff
Shasta County Most Wanted 2022
Energy Healing Conference Utah
Testberichte zu E-Bikes & Fahrrädern von PROPHETE.
Aaa Saugus Ma Appointment
Geometry Review Quiz 5 Answer Key
Walgreens Alma School And Dynamite
Bible Gateway passage: Revelation 3 - New Living Translation
Yisd Home Access Center
Home
Shadbase Get Out Of Jail
Gina Wilson Angle Addition Postulate
Celina Powell Lil Meech Video: A Controversial Encounter Shakes Social Media - Video Reddit Trend
Walmart Pharmacy Near Me Open
Dmv In Anoka
A Christmas Horse - Alison Senxation
Ou Football Brainiacs
Access a Shared Resource | Computing for Arts + Sciences
Pixel Combat Unblocked
Cvs Sport Physicals
Mercedes W204 Belt Diagram
Rogold Extension
'Conan Exiles' 3.0 Guide: How To Unlock Spells And Sorcery
Teenbeautyfitness
Weekly Math Review Q4 3
Facebook Marketplace Marrero La
Nobodyhome.tv Reddit
Topos De Bolos Engraçados
Gregory (Five Nights at Freddy's)
Grand Valley State University Library Hours
Holzer Athena Portal
Hampton In And Suites Near Me
Stoughton Commuter Rail Schedule
Bedbathandbeyond Flemington Nj
Free Carnival-themed Google Slides & PowerPoint templates
Otter Bustr
Selly Medaline
Latest Posts
Article information

Author: Ray Christiansen

Last Updated:

Views: 6055

Rating: 4.9 / 5 (69 voted)

Reviews: 92% of readers found this page helpful

Author information

Name: Ray Christiansen

Birthday: 1998-05-04

Address: Apt. 814 34339 Sauer Islands, Hirtheville, GA 02446-8771

Phone: +337636892828

Job: Lead Hospitality Designer

Hobby: Urban exploration, Tai chi, Lockpicking, Fashion, Gunsmithing, Pottery, Geocaching

Introduction: My name is Ray Christiansen, I am a fair, good, cute, gentle, vast, glamorous, excited person who loves writing and wants to share my knowledge and understanding with you.