Warren Buffett famously said, “Price is what you pay. Value is what you get.” But how do you actually calculate that value?
If you look at a stock ticker, you see the current market price. This price is driven by emotion, news cycles, and algorithmic trading. However, the true, fundamental worth of a business—its intrinsic value—is driven by only one thing: how much cash the business will generate in the future.
To figure out what those future cash flows are worth today, analysts use a valuation method called Discounted Cash Flow (DCF). Here is exactly how it works, the math behind it, and how you can use it to build institutional-grade investment models.
The Core Concept: Time Value of Money
The entire foundation of a Discounted Cash Flow model rests on a financial principle called the Time Value of Money.
Simply put: A dollar today is worth more than a dollar tomorrow.
If someone offers to pay you $100 today or $100 five years from now, you will always take the money today. Why? Because you can take that $100 today, invest it at a 5% interest rate, and have $127.63 in five years. Therefore, if you are forced to wait five years to receive that $100, its present value to you right now is significantly less than $100.
When you buy a stock, you are buying the right to a portion of that company’s future cash flows. Because you have to wait years for the company to generate that cash, you must “discount” those future cash flows back to their present value.
The DCF Formula Explained
The mathematical formula to discount future cash flows looks like this:
- CF (Cash Flow): The projected Free Cash Flow the company will generate in a specific year.
- r (Discount Rate): The rate used to discount the future cash back to today. This is typically the company’s Weighted Average Cost of Capital (WACC), which represents the risk of the investment.
- n (Period): The specific year in the future (Year 1, Year 2, etc.).
The 3 Steps of Building a DCF Model
- Project the Future Cash Flows: You look at a company’s historical financial data and project how much Free Cash Flow they will generate over the next 5 to 10 years.
- Determine the Discount Rate: You calculate the WACC based on the risk-free rate, the volatility of the stock (Beta), and the company’s debt levels. A higher risk company gets a higher discount rate, which lowers its present value.
- Calculate the Terminal Value: A company doesn’t stop existing after 10 years. You must calculate a “Terminal Value” to account for all cash flows generated from Year 11 into perpetuity, and then discount that massive number back to today.
Finally, you add up the present value of the 5-year projections and the present value of the Terminal Value. Divide that total sum by the number of shares outstanding, and you have your Intrinsic Value per Share.
The Problem with Spreadsheets
Understanding the theory of DCF is easy. Executing it accurately in Microsoft Excel is a nightmare.
A standard DCF template requires pulling historical data, manually linking WACC formulas, projecting terminal values, and building clunky data tables for sensitivity analysis. A single broken #REF! error or a misplaced decimal can result in a wildly inaccurate buy target, costing you money.
The Solution: Purpose-Built Valuation Software
You don’t need to be a Wall Street quant to run a perfect DCF. You just need the right tools.
Aperite was engineered from the ground up to replace the fragile Excel spreadsheet. Built as a lightning-fast native desktop application, Aperite automates the heavy mathematical lifting.
- Instantly calculate historical growth baselines.
- Dynamically adjust your WACC and growth rates with visual sliders.
- Export professional, error-free PDF valuation reports in a single click.
Stop guessing your buy targets. Find the true intrinsic value today.