---
title: Calculate a Stock’s Intrinsic Value Fast – Free DCF Template
siteUrl: https://logzly.com/marketmomentum
author: marketmomentum (Market Momentum)
date: 2026-07-06T02:02:23.774524
tags: [valuation, dcf, investing]
url: https://logzly.com/marketmomentum/calculate-a-stocks-intrinsic-value-fast-free-dcf-template
---


Struggling to know whether a stock is a bargain or a trap? In the next few minutes you’ll learn **exactly how to calculate intrinsic value of a stock** with a lightweight discounted cash flow (DCF) model that works in Excel or Google Sheets—no finance PhD required. Download the [free template](/marketmomentum/calculate-a-stocks-intrinsic-value-fast-free-dcf-template), plug in a handful of numbers, and get a clear per‑share value you can compare to the market price right away.  

## Why Most DIY DCFs Miss the Mark  

When you pull a spreadsheet together from random articles, the **discount rate** and growth assumptions often feel like guesses, and the final figure looks like magic. That uncertainty makes you either ignore the model or rely on vague analyst “fair‑value” numbers that rarely help your decision‑making.  

**The fix?** Use a repeatable, five‑year projection with only two inputs you can verify: last year’s free cash flow (FCF) and a realistic growth rate. This keeps the math transparent and the result trustworthy.  

## A Simple 5‑Step DCF Template That Actually Works  

Below is the exact workflow I follow for every new stock. The steps are built into the **intrinsic value calculator spreadsheet free download** available on Market Momentum, so you can copy‑paste the formulas and let the sheet do the heavy lifting.  

### Step 1 – Gather the Basics  

Locate the most recent free cash flow (FCF) from the company’s cash‑flow statement (investor‑relations page or any major financial site). **Write this number down**; it becomes the starting point for the entire model.  

### Step 2 – Project Future Cash Flows  

Assume a modest annual growth rate (g) for the next five years.  
* Stable, mature firms: **3‑5 %**  
* Fast‑growing tech or biotech: **10‑12 %**  

Apply the growth rate year‑over‑year:

```
FCF₁ = FCF₀ × (1 + g)
FCF₂ = FCF₁ × (1 + g)
…
FCF₅ = FCF₄ × (1 + g)
```  

Only five simple lines—no complex forecasting needed.  

### Step 3 – Choose a Discount Rate  

The discount rate (r) reflects the risk you’re taking. A quick rule of thumb: use the company’s weighted average cost of capital (WACC) if available, otherwise **8‑10 %** works for most U.S. stocks. I default to **9 %** unless the business feels unusually risky.  

### Step 4 – Discount Each Year’s Cash Flow  

Convert each projected cash flow to present value (PV):

```
PV₁ = FCF₁ / (1 + r)¹
PV₂ = FCF₂ / (1 + r)²
…
PV₅ = FCF₅ / (1 + r)⁵
```  

Add the five PV figures together; that sum is the **present value of the projected cash flows**.  

### Step 5 – Estimate the Terminal Value  

Beyond year five, assume cash flows grow forever at a modest terminal growth rate (gₜ, typically **2‑3 %**).  

```
TV = (FCF₅ × (1 + gₜ)) / (r – gₜ)
```  

Discount the terminal value back to today the same way you did with the five years, then add it to the PV sum from Step 4.  

### Step 6 – Adjust for Debt and Cash  

Take the combined present value, **subtract net debt** and **add cash on hand**. The result is the firm’s **enterprise value**.  

### Step 7 – Derive Per‑Share Intrinsic Value  

Divide the enterprise value by the total shares outstanding:

```
Intrinsic Value per Share = Enterprise Value / Shares Outstanding
```  

If the current market price is well below this number, you may have found a bargain; if it’s above, proceed with caution.  

## Quick Start with the Free Spreadsheet  

1. **Download** the “Intrinsic Value Calculator” from Market Momentum.  
2. Paste the FCF, growth rate, discount rate, debt, cash, and share count into the highlighted cells.  
3. The sheet instantly outputs the five‑year PV, terminal value, enterprise value, and per‑share intrinsic value.  

I tested the template on a consumer staple, a mid‑cap tech firm, and a small utility. Each run took **15‑20 minutes** and produced a clear, repeatable valuation number—no guesswork, no spreadsheet panic.  

## Wrap‑Up: Your New Valuation Habit  

Stop guessing and start using this **simple, repeatable DCF model**:  

* Pull last year’s free cash flow.  
* Apply a realistic 5‑year growth rate.  
* Use a 9 % discount rate (or your company’s WACC).  
* Compute the terminal value with a 2‑3 % perpetual growth.  
* Adjust for debt and cash, then divide by shares.  

Give the Market Momentum spreadsheet a spin on a stock you’re watching this week. You’ll see the numbers line up, and you’ll gain confidence in every investment decision.  

If you found this guide useful, **subscribe to the Market Momentum newsletter** for more straight‑talk [swing trade tips](/marketmomentum/how-to-spot-highprobability-swing-trades-when-the-market-is-all-over-the-place), and share this post with anyone who’s tired of feeling lost in the numbers.