Discounted Cash Flow Calculator for Business Valuation

How a Discounted Cash Flow Calculator Values a Business

A discounted cash flow calculator rests on one idea: a company is worth the cash it will generate for its owners, adjusted for the time value of money. A dollar received in six years is worth less than a dollar in your account today, so every projected payment gets shrunk by a discount rate before you add the payments together. The sum is the fair value of the business right now. The balance sheet analysis online uses the same plain-English approach, so you can compare results side by side.

Professional appraisers describe three families of business valuation: the income approach, the asset approach and the market approach. DCF valuation belongs to the income approach, and it is the one to reach for when cash flows are expected to change from year to year rather than stay flat. A simpler cousin, income capitalization, divides one year of earnings by a single rate and works only when performance is stable.

What the calculator returns

Run your assumptions through the tool and it reports four numbers: the total of the discounted forecast-year cash flows, the discounted terminal value, the combined enterprise value, and, once you subtract debt and add cash, the equity value that belongs to shareholders. If you also enter the number of shares outstanding, you receive the per share figure too.

Who uses a DCF business valuation

Business owners use it before selling or bringing in a partner, investors use it to test a stock against its market quote, and a financial analyst builds it into a model for mergers and acquisitions. Founders of a startup with little revenue lean on it because comparable sales do not yet exist, which makes startup valuation a natural fit for forward-looking cash flow work.

Business Valuation (Discounted Cash Flow) Calculator Inputs and Assumptions

Every DCF analysis is only as good as its assumptions. The calculator asks for a handful of inputs, and the table below shows the exact values used in the worked example later on this page. Try the free cash flow calculator to run your own numbers — everything is calculated in your browser and nothing you enter is stored or sent anywhere.

Free cash flow: the base of the forecast

Free cash flow is the money a business has left after it pays operating costs, taxes and the investment needed to keep growing. Pull the figure from your income statement and cash flow statement, then take the average of a few recent years if one year looks unusual. Revenue and profit alone are not enough, because profit ignores the cash tied up in equipment and inventory.

Growth rate and forecast period

Two fields shape the forecast. The projection years field sets the forecast period, and the annual growth rate field decides how fast each year's cash flow rises across it; the calculator applies that rate to the starting figure year by year and begins the terminal value after the last one. In the example, 9% over six years is followed by 2.5%, so the pace fades toward the economy's. Entering a steady rate in one run and a fading rate in another, as two scenarios, is more honest than trusting a single path.

Discount rate, WACC and cost of capital

The discount rate is the yearly return a buyer demands for taking this particular risk. For a company with both debt and equity it is usually the WACC, the weighted blend of your borrowing cost and your owners' expected return, which is why it is also called the cost of capital. For a small private firm, a required rate of return built from a risk-free rate plus a size and company-specific premium is common. A higher rate means a lower value, so this is the input that moves the answer most.

Terminal growth rate and exit multiple

Beyond the last forecast year, the calculator assumes the business keeps growing at a low, constant terminal growth rate, typically close to long-run inflation. Keep it below the discount rate and below the growth of the economy. Some analysts replace this step with an exit multiple, applying an industry multiple to the final year's EBITDA; both routes need conservative numbers to avoid overvaluation.

DCF Valuation Formula: From Free Cash Flow to Equity Value

The method has five steps. You can work through them by hand or in a spreadsheet such as Excel, which is a good way to learn how the calculator reaches its answer.

Step 1: project free cash flow to the firm (FCFF)

FCFF is the cash available to everyone who funds the company, lenders and owners alike. Start from operating profit (EBIT), apply the tax rate, add back depreciation and other non-cash charges, then subtract capital expenditure and the increase in working capital:

$$FCFF = EBIT \times (1 - \text{tax rate}) + \text{non-cash charges} - \text{CapEx} - \Delta\text{working capital}$$

The net investment figure is simply capital expenditure minus depreciation. Working capital, meaning current assets minus current liabilities, rises as a company expands because more cash is locked up in stock and receivables.

Step 2: estimate the terminal value with the Gordon growth model

The Gordon growth model values every cash flow after the forecast period as one lump sum:

$$TV = \frac{FCFF_{n} \times (1 + g)}{r - g}$$

Here \(FCFF_{n}\) is the final forecast-year cash flow, \(g\) the terminal growth rate and \(r\) the discount rate. The formula only works when \(r\) is larger than \(g\); if the two come close, the result explodes, which is why a margin of safety in your growth input matters.

Step 3: discount each cash flow to present value

Each year's cash flow is divided by one plus the discount rate, raised to the year number:

$$PV = \frac{FCFF_{t}}{(1 + r)^{t}}$$

Summing these gives the present value of future cash flows for the explicit years. The terminal value is discounted with the same factor as the last forecast year.

Step 4: add the parts to reach enterprise value

$$EV = \sum_{t=1}^{n} \frac{FCFF_{t}}{(1 + r)^{t}} + \frac{TV}{(1 + r)^{n}}$$

The result is the enterprise value, the worth of the operating business before you consider how it is financed.

Step 5: subtract net debt for equity value and per-share value

$$\text{Equity value} = EV - \text{net debt}, \qquad \text{Value per share} = \frac{\text{Equity value}}{\text{shares outstanding}}$$

The net debt adjustment is what separates the value of the whole firm from the slice owned by shareholders.

Worked Example: Intrinsic Value of a Company with the DCF Calculator

Take a regional packaging company whose latest free cash flow is $386,500. You expect it to grow 9% a year for six years, you apply an 11.5% discount rate, and you assume 2.5% growth after year six. The business carries $1,150,000 of net debt and has 250,000 shares. The table shows how each year's cash flow is projected and discounted.

The final-year cash flow of $648,199 feeds the terminal value: $648,199 × 1.025 ÷ (0.115 − 0.025) gives about $7,382,269, which discounts to $3,841,852 today. Adding that to the $2,143,666 of forecast-year value produces an enterprise value of $5,985,518. After subtracting the $1,150,000 of net debt, the equity value is $4,835,518, or $19.34 per share.

Reading Your Result: Fair Value, Undervalued or Overvalued

Compare the intrinsic value the calculator returns with the current market price or with the price a seller is asking. If the asking price sits well below your equity value, the business looks undervalued; if it sits above, it looks overvalued. Buyers often demand a discount of 20% or more between the calculator's output and their offer as a built-in cushion against forecast errors.

Check how much comes from the terminal value

In the example above, 64.2% of the enterprise value comes from the terminal value. That is normal for a six-year forecast, but it means the answer depends heavily on two assumptions you cannot observe. If the share climbs past roughly three quarters, shorten your reliance on it, lower the terminal growth rate or lengthen the explicit period.

Run a sensitivity analysis

A sensitivity analysis changes the discount rate and terminal growth one step at a time and records the enterprise value. The grid below uses the same example and shows how a one-point move in the discount rate shifts the answer by hundreds of thousands of dollars.

The cheapest corner of the grid is about 16% below the base case, and the most generous is about 25% above it. A fair summary for a buyer is a range, not a point.

Pricing a Two-Shop Bakery with a DCF Valuation Calculator

Dana Okafor is weighing an offer to buy a two-shop bakery whose owner wants $1,650,000. The seller's books show an average free cash flow of $148,200 over the last three years, after paying a manager a market salary. Before the asking price is discussed again, Dana opens the calculator to see what a discounted cash flow valuation says the business is worth.

Dana enters $148,200 as the starting cash flow and 6.5% growth for 5 years, because a third shop would take about that long to fill. The discount rate is 13.5%, Dana's own hurdle for a single-region food business. Terminal growth is set to 2.0%, matching the Federal Reserve's long-run inflation target, and net debt is the $212,000 equipment loan that stays with the company.

After pressing the calculate button, the page shows year-five cash flow of $203,047, a discounted forecast total of $614,664 and a discounted terminal value of $956,135. The enterprise value is $1,570,799, and the equity value after the loan is $1,358,799. The terminal value supplies 60.9% of the total, which is lower than most businesses carry, so Dana trusts the figure a little more.

• The asking price is $79,201, or 5.0%, above the calculated enterprise value.
• Re-running the same inputs at a 12.5% discount rate gives $1,725,113, so the seller's number only works if Dana accepts a lower required return.
• At 14.5% the value falls to $1,441,310, which is Dana's walk-away boundary.

The result gives Dana a specific next step: offer $1,570,000, state that the figure comes from the 13.5% rate, and ask the seller to justify any lower rate with the third-shop lease evidence. Dana now negotiates one named assumption rather than an unexplained price.

Business Valuation Methods Compared with DCF Analysis

No single method settles a price. The market approach looks at comparable companies and applies multiples of EBITDA, revenue or earnings; it is fast and rooted in what buyers actually pay, but it says little about a company that differs from its peers. The asset approach adds up what the balance sheet holds, which suits a holding company or a business about to be liquidated. DCF is the most detailed of the three because it models the business itself, and it does not require any comparable firm to exist.

• Pros of DCF: captures growth and risk explicitly, works for companies without peers, supports scenarios and a sensitivity analysis, and links directly to the internal rate of return an investor would earn.
• Cons of DCF: demands many assumptions, is dominated by the terminal value, and rewards overconfidence when inputs are rosy.
• Best practice: reconcile the answer with peer benchmarks before you rely on it.

Using a DCF Value Calculator to Find the Value of a Business

A DCF value calculator works the same way whether you want the value of a business you own, a company you plan to buy or a listed stock. What changes is the quality of the inputs. A business owner starts from the cash left after a fair salary for the owner; a stock investor starts from reported free cash flow; a startup with no profit starts from a revenue plan. Each route leads to the value of a business as a sum of discounted payments, and it helps to ask a plain question first: what would this investment pay me over six years if I then sold it?

Good cash flow projections begin with revenue growth. Estimate customers and price, apply the operating margin the company has earned before, then deduct expenses, tax and reinvestment. Check whether your figures describe net operating profit or pre-tax profit, because the two differ by the interest bill. Treat the result as projected cash flows, not as a promise.

Choose a projection period that ends once the company reaches stable growth. Every explicit year should carry its own revenue, margin and reinvestment assumption, and the last one feeds the terminal value. If the business is still expanding fast in year six, lengthen the period rather than forcing a low terminal rate. As a cross-check, the exit multiple method sells the company at the end of the period at an industry multiple of EBITDA; a large gap between that answer and the Gordon result tells you one assumption is off.

The enterprise value is a close relative of net present value: NPV subtracts the price you pay from it, and the discount rate that brings that difference to zero is the IRR. For stock valuation, set the per-share result beside the price target an analyst quotes. A company that pays dividends can also be valued by discounting them, though free cash flow is the better input when payouts are small. Because the discount factor is compounded yearly, a change in the rate bites harder on late years than early ones.

The calculator reports an absolute value, an amount in dollars, rather than a multiple of earnings, which is why finance teams, lenders and a seller weighing an acquisition can test an offer against what the cash flows support. Keep a short methodology note recording where each input came from, and weigh competition when you set growth, since rivals squeeze margins. To value a business credibly, show the value of a business as a range.

A free discounted cash flow calculator like this one removes the arithmetic but not the judgment. Use a DCF valuation calculator for a quick range, and move to a spreadsheet-based business valuation calculator model when you need every year's costs on view. Either way, the DCF calculator is a decision aid for an investment, not a replacement for an appraisal.

Common Mistakes When You Value a Company with DCF

• Terminal growth that is too high. A company growing forever at 6% would eventually outgrow the economy. Stay near inflation.
• A discount rate that ignores risk. Using a large-company rate for a small private firm overstates the answer.
• Forgetting working capital and capital spending. Profit growth that needs new machinery or stock is not free cash flow.
• Mixing enterprise and equity figures. Divide only the equity value, never the enterprise value, by shares outstanding.
• Treating one result as the truth. The output is an estimate built on stated assumptions, not an independent appraisal.