Discounted Cash Flow Calculator: How to Use a DCF Tool to Value a Business
A discounted cash flow calculator is the fastest way to translate a five-year operating forecast, a discount rate, and a terminal-growth assumption into a defensible enterprise value, without rebuilding the math from scratch every time a deal lands on your desk. Whether you are an owner sizing up an unsolicited offer, a private-equity analyst pressure-testing a sponsor model, or an M&A advisor preparing a confidential information memorandum, a discounted cash flow calculator collapses the same five inputs (revenue growth, EBIT margin, capex, working capital, and WACC) into a single intrinsic value figure that you can sanity-check against trading comps and precedent transactions. This guide walks through the inputs a real discounted cash flow calculator demands, the formulas under the hood, a fully worked 5-year example, the common errors that produce a 30% mis-valuation, and how the same calculator output gets used in fairness opinions cited by the Delaware Court of Chancery (In re Appraisal of Dell Inc., C.A. No. 9322-VCL, 2016).
What a Discounted Cash Flow Calculator Actually Computes
A discounted cash flow calculator takes a stream of forecast free cash flows, applies a per-period discount factor of 1 divided by (1 + WACC) raised to the year, sums those present values, adds a discounted terminal value, and outputs enterprise value. Subtract net debt and you have equity value. Divide by diluted shares (treasury stock method, per ASC 260) and you have per-share value. McKinsey’s Valuation: Measuring and Managing the Value of Companies (Koller, Goedhart, Wessels, 7th edition, Wiley 2020) frames this as the “primary” valuation tool because it isolates the operating drivers from market noise, while the CFA Institute Level II Equity curriculum teaches DCF as the foundational technique that every other approach is benchmarked against.
What separates a good discounted cash flow calculator from a bad one is not the math (the formula has not changed since John Burr Williams published The Theory of Investment Value in 1938) but input discipline. Bankers at Goldman Sachs, Morgan Stanley, Lazard, and middle-market shops like Houlihan Lokey, Lincoln International, and William Blair all run the same equation; the differentiator is how the WACC was built, how terminal growth was justified, and how working capital tied to the revenue ramp. Aswath Damodaran’s NYU Stern teaching site maintains a free, continuously updated dataset of industry betas, ERPs, and country risk premiums that every working analyst eventually downloads.
Quick-Reference: The Six Inputs Every DCF Calculator Demands
Before you can run a discounted cash flow calculator, you need six numbers. Get any of them wrong by more than 100 basis points and the output can swing 20% to 40%.
| Input | Typical range | What it controls | Where it comes from |
|---|---|---|---|
| Year 1 free cash flow | 5% to 15% of revenue for mature businesses | The base from which every future year grows | Last twelve months (LTM) financials, normalized for one-time items |
| Revenue growth (Years 1-5) | 2% to 25%, fade to GDP+1% by Year 5 | Top-line trajectory | Management plan, vetted against industry CAGR (Pitchbook, IBISWorld) |
| EBIT margin (Years 1-5) | 5% to 30%, depends on industry | Operating gearing and cost discipline | Historical 3-year average plus margin expansion thesis |
| WACC (discount rate) | 7% to 12% for US mid-market | The risk-adjusted opportunity cost of capital | CAPM cost of equity + after-tax cost of debt, weighted |
| Terminal growth rate (g) | 2.0% to 3.0% (long-run nominal GDP) | The perpetual growth assumption after Year 5 | Federal Reserve long-run GDP projections (FOMC Summary of Economic Projections) |
| Net debt | Total debt minus cash and equivalents | Bridge from enterprise value to equity value | Most recent balance sheet, plus pension and operating lease adjustments |
The first five inputs feed enterprise value. The sixth (net debt) is the bridge to equity value. Both Wall Street Oasis and Mergers & Inquisitions publish hundreds of analyst interview transcripts confirming that this six-input structure does not vary between bulge bracket, elite boutique, and middle-market shops.
The Core Formula Inside Every DCF Calculator
A discounted cash flow calculator runs exactly two equations under the hood, then sums and bridges. The first is the present value of each explicit-period free cash flow. The second is the Gordon Growth terminal value.
| Equation | Formula | What it produces |
|---|---|---|
| Present value of Year t FCF | PV_t = FCF_t / (1 + WACC)^t | Today’s value of one forecast year |
| Sum of explicit period | PV(explicit) = sum from t=1 to N of [FCF_t / (1 + WACC)^t] | Today’s value of all forecast years |
| Terminal value (Gordon Growth) | TV = [FCF_N x (1 + g)] / (WACC – g) | Value of all cash flows past Year N |
| Present value of terminal value | PV(TV) = TV / (1 + WACC)^N | Today’s value of the perpetuity |
| Enterprise value | EV = PV(explicit) + PV(TV) | Total operating value |
| Equity value | Equity = EV – Net Debt + Cash + Non-op assets | What shareholders own |
Free cash flow here means unlevered free cash flow, sometimes written FCFF for “free cash flow to the firm”: EBIT times (1 minus tax rate), plus depreciation and amortization, minus capital expenditures, minus the increase in net working capital. This is the cash available to all capital providers (debt plus equity), which is why you discount it at the weighted average cost of capital and not at the cost of equity. The alternative (levered DCF, which discounts free cash flow to equity at the cost of equity) collapses to the same equity value when done correctly but is more error-prone for M&A work, which is why unlevered DCF is the default in every banking model template I have seen from Houlihan Lokey, Lazard, and the M&A advisors at CT Acquisitions’ M&A advisor practice.
Step 1: Build the Free Cash Flow Stream
The single biggest swing factor in any discounted cash flow calculator is not the discount rate. It is the year-by-year free cash flow forecast. Practitioners typically build five to ten explicit forecast years, with five being the M&A standard for mid-market deals and ten being the standard for capital-intensive or commodity businesses where the cycle has to be visible inside the explicit period. Damodaran teaches that the explicit period should run until the business reaches a steady state where return on invested capital (ROIC) converges toward WACC; any growth beyond that point destroys value or is captured in the terminal value.
The unlevered free cash flow formula is straightforward but every line item has to tie to a forecast schedule:
| Line | Formula or source | Common error |
|---|---|---|
| Revenue | Prior year x (1 + growth rate) | Confusing nominal vs. real growth; mismatching with WACC assumption |
| EBIT | Revenue x EBIT margin | Failing to normalize for stock-based compensation (SBC); SEC has flagged this in comment letters repeatedly since 2018 |
| Less: Taxes | EBIT x marginal effective tax rate (21% federal plus blended state, ~25% to 27% US) | Using effective book tax rate instead of marginal cash rate |
| NOPAT | EBIT x (1 – tax rate) | Forgetting that NOL carryforwards (IRC Section 172) reduce cash taxes for years |
| Plus: D&A | From depreciation schedule tied to capex and existing PP&E | Using book D&A in early years when tax bonus depreciation differs |
| Less: Capex | Maintenance plus growth capex, tied to revenue ramp | Letting capex/revenue drift below 1.5% for asset-heavy businesses |
| Less: Change in NWC | Days sales outstanding (DSO), days payable outstanding (DPO), days inventory on hand schedule | Assuming zero NWC investment as revenue grows 20%+ |
| = Unlevered FCF | Sum of above | Mixing levered and unlevered conventions |
An important convention: stock-based compensation (SBC) is a real cash cost and should be deducted from EBIT before tax, not added back as a “non-cash” item the way some retail-investor models still do. The Goldman Sachs equity research group, Houlihan Lokey, and Damodaran all moved to this convention by 2017 after a wave of SaaS IPOs (Slack, Snap, Uber) made the add-back assumption indefensible. Bloomberg’s May 10, 2019 Uber coverage documented the practitioner debate; the consensus now treats SBC as an operating expense.
Step 2: Calculate WACC the Way a Real Calculator Does
The weighted average cost of capital is the discount rate that goes into a discounted cash flow calculator’s denominator. Get it wrong by 100 basis points and the enterprise value swings 8% to 15%. The formula is:
| Component | Formula | Typical 2026 value (US mid-market) |
|---|---|---|
| Risk-free rate (Rf) | 20-year US Treasury yield (matching DCF horizon) | ~4.4% (per US Treasury long-term rates) |
| Equity risk premium (ERP) | Implied ERP from Damodaran or Duff & Phelps (now Kroll) annual study | 5.0% to 5.5% (Damodaran’s implied ERP series) |
| Beta | Unlevered industry beta, then relevered to target capital structure using Hamada | 0.7 to 1.4 depending on industry |
| Cost of equity (Ke) | Ke = Rf + Beta x ERP (CAPM) | 8% to 13% |
| Pre-tax cost of debt (Kd) | Yield to maturity on outstanding bonds, or synthetic spread from credit rating | 5% to 8% |
| After-tax cost of debt | Kd x (1 – tax rate) | 4% to 6% |
| Capital weights | Target debt/equity, not current (per CFA Level II Equity) | 20% to 40% debt for non-financial mid-market |
| WACC | (E/V) x Ke + (D/V) x Kd x (1 – t) | 8% to 11% typical mid-market |
Three input choices separate a defensible WACC from a number you will get torn apart on in a Q&A: use the 20-year Treasury (not the 10-year) when the DCF horizon includes a long terminal period; use the implied equity risk premium from forward-looking models, not the historical arithmetic average (which overstates ERP by 100 to 200 bps per Damodaran’s published critique); and use a relevered industry beta from at least 10 to 20 peers, not the company’s own regression beta (too noisy for mid-market). The Kroll Cost of Capital Navigator (formerly Duff & Phelps) is the standard subscription source for size premiums and industry risk premiums on smaller deals.
For privately held businesses below $50 million enterprise value, practitioners typically add a size premium of 200 to 400 basis points to the CAPM cost of equity, per Kroll’s annual study. This is one of the largest sources of valuation difference between public-comparable WACC and a real mid-market discount rate, and it is why a public-comparable DCF often overvalues a small private business by 20% to 30%.
Step 3: Pick a Terminal Value Method (Gordon Growth vs. Exit Multiple)
The terminal value typically represents 60% to 80% of total enterprise value in a five-year DCF, which means the terminal-value method is not a footnote. There are two standard approaches:
| Method | Formula | When to use | Trap to avoid |
|---|---|---|---|
| Gordon Growth (perpetuity) | TV = [FCF_N x (1 + g)] / (WACC – g) | Mature, low-growth businesses; default for academic and Delaware appraisal work | Setting g above long-run nominal GDP (~2.5% per FOMC SEP); produces math that implies the company will exceed global GDP eventually |
| Exit Multiple | TV = Year N EBITDA x Exit Multiple | M&A and sponsor LBO models; the standard at Kirkland & Ellis-papered private equity deals | Picking a multiple inconsistent with the implied growth rate; sanity-check by solving for implied g and confirming it is below 4% |
The Delaware Court of Chancery has leaned heavily on Gordon Growth in appraisal litigation because exit multiples are seen as relative-valuation contamination of an intrinsic DCF (see Vice Chancellor Laster’s reasoning in In re Appraisal of Dell Inc., 2016, and DFC Global v. Muirfield, 172 A.3d 346 Del. 2017). For an LBO sponsor model, exit multiple is the default because the actual exit will be a sale at a multiple. The practical compromise: present both methods and show the implied cross-check (Gordon Growth implies an exit multiple, exit multiple implies a g) per the Macabacus DCF templates that most banking analysts use.
Step 4: Discount Everything Back (Mid-Year Convention)
Once you have the explicit-period FCF and the terminal value, the discount step is mechanical. The one judgment call is whether to use end-of-year or mid-year convention. End-of-year assumes cash flows arrive on December 31; mid-year assumes they arrive on June 30, which is closer to economic reality because cash flows are spread across the year. Mid-year convention typically increases enterprise value by 4% to 6% versus end-of-year on a 10% WACC.
| Convention | Discount factor for Year t | When used |
|---|---|---|
| End-of-year | 1 / (1 + WACC)^t | Academic, simplest, conservative |
| Mid-year | 1 / (1 + WACC)^(t – 0.5) | Banking and private-equity standard; reflects cash flows arriving throughout the year |
For terminal value under mid-year convention, the formula adjusts to TV / (1 + WACC)^(N – 0.5), or equivalently you can compute the terminal value at year N + 0.5 to maintain consistency. Goldman Sachs, Morgan Stanley, Lazard, Houlihan Lokey, and Lincoln International all default to mid-year in M&A models per the templates that circulate on Wall Street Oasis. Use whichever convention your deal team uses, but be consistent: mixing end-of-year on explicit FCF with mid-year on terminal value is a classic analyst error and will get the model bounced back.
Step 5: Bridge Enterprise Value to Equity Value
A discounted cash flow calculator’s headline output is enterprise value. To get to equity value (what a buyer actually pays the seller), you have to walk the EV-to-equity bridge.
| Bridge item | Effect | Common adjustments |
|---|---|---|
| Enterprise value (from DCF) | Starting point | Sum of PV(FCF) + PV(TV) |
| Less: Total debt | (-) | Senior secured, term loans, subordinated notes, drawn revolver |
| Less: Pension underfunding | (-) | Net pension liability per ASC 715 disclosures (PBO minus plan assets) |
| Less: Operating lease liabilities | (-) if not capitalized in EBITDA already | Per ASC 842 right-of-use accounting; methodology must match EBITDA convention |
| Less: Preferred equity | (-) | At liquidation preference or current trading value, whichever higher |
| Less: Minority interest | (-) | At market value if traded, otherwise book |
| Plus: Cash & equivalents | (+) | Net of operating cash needed (typically 2% to 5% of revenue) |
| Plus: Non-operating assets | (+) | Marketable securities, idle real estate, JV investments |
| = Equity value | What gets divided by diluted shares |
Diluted share count uses the treasury stock method per ASC 260: basic shares outstanding, plus net new shares from in-the-money options and RSUs, minus shares the company can repurchase with the option proceeds. Restricted stock units (RSUs) are added at full count regardless of vesting. Performance share units (PSUs) are added at the achievement level disclosed in the most recent 10-Q. Wachtell, Lipton, Rosen & Katz’s annual M&A memo covers the dilution mechanics that get litigated when target boards approve a sale; for the deal-document mechanics of how this share count flows into a stock purchase agreement, see CT Acquisitions’ guide to stock purchase agreements.
Worked Example: A Discounted Cash Flow Calculator in Action
Here is the same math a real discounted cash flow calculator runs. Assume a mid-market manufacturing business with Year 0 revenue of $100 million, 12% EBIT margin, 25% tax rate, capex equal to D&A (steady state), 1.5% of revenue annual NWC investment, WACC of 9.5%, and terminal growth of 2.5%. End-of-year convention.
| Year | Revenue ($M) | Growth | EBIT ($M) | NOPAT ($M) | +D&A | -Capex | -NWC | FCF ($M) | Discount factor (9.5%) | PV of FCF ($M) |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 108.0 | 8.0% | 13.0 | 9.7 | 5.4 | (5.4) | (1.2) | 8.5 | 0.9132 | 7.8 |
| 2 | 115.6 | 7.0% | 13.9 | 10.4 | 5.8 | (5.8) | (1.1) | 9.3 | 0.8340 | 7.7 |
| 3 | 122.5 | 6.0% | 14.7 | 11.0 | 6.1 | (6.1) | (1.0) | 10.0 | 0.7617 | 7.6 |
| 4 | 128.6 | 5.0% | 15.4 | 11.6 | 6.4 | (6.4) | (0.9) | 10.7 | 0.6956 | 7.4 |
| 5 | 133.8 | 4.0% | 16.1 | 12.0 | 6.7 | (6.7) | (0.8) | 11.2 | 0.6354 | 7.1 |
| Sum of PV(explicit period) | $37.6M | |||||||||
Now the terminal value. Year 5 FCF is $11.2 million. Apply terminal growth of 2.5%, so Year 6 FCF is $11.5 million. Gordon Growth terminal value equals $11.5M divided by (9.5% minus 2.5%), which equals $164.3 million. Discount back to today using the Year 5 discount factor of 0.6354, which produces a present value of terminal value of $104.4 million.
| Component | Value ($M) | % of EV |
|---|---|---|
| PV of explicit period FCF (Years 1-5) | 37.6 | 26.5% |
| PV of terminal value | 104.4 | 73.5% |
| Enterprise value | 142.0 | 100.0% |
| Less: Net debt (Total debt $30M minus cash $5M) | (25.0) | |
| Equity value | 117.0 | |
| Diluted shares outstanding (M) | 10.0 | |
| Equity value per share | $11.70 |
That $142 million enterprise value implies an EV / Year 1 EBITDA multiple of roughly 7.8x (assuming D&A of $5.4M, so EBITDA is $18.4M), which is in the range for non-cyclical US mid-market manufacturing per Pitchbook’s annual valuation surveys. If trading comps and precedent transactions both clustered between 7.0x and 9.0x EBITDA, this DCF would slot cleanly inside the football field. For the mechanics of how this same valuation gets translated into a complete discounted cash flow business valuation presented to a board, see CT Acquisitions’ deep-dive on DCF in a sale-process context.
Sensitivity Tables: Why Every DCF Calculator Outputs a Range
A single point estimate of enterprise value is misleading. Every credible discounted cash flow calculator outputs a sensitivity table that shows EV across a grid of WACC and terminal growth assumptions, because both inputs have meaningful uncertainty and small changes produce large output swings. The standard “football field” presentation in a banker’s pitch book shows a +/-100 bps WACC range and a +/-50 bps terminal growth range.
| WACC | g = 2.0% | g = 2.5% | g = 3.0% |
|---|---|---|---|
| 8.5% | $163M | $176M | $192M |
| 9.0% | $151M | $162M | $176M |
| 9.5% | $140M | $142M | $162M |
| 10.0% | $131M | $140M | $151M |
| 10.5% | $123M | $131M | $141M |
That range, $123M to $192M, is a 56% spread on a single model with reasonable input bounds. This is why DCF is always presented in M&A as a range, and why a point estimate without a sensitivity table will get pushed back by any committee. Morgan Stanley Investment Management publishes white papers on valuation uncertainty that start from this observation. CT Acquisitions’ framework for how to determine the value of a business walks the same logic across DCF, comps, and precedents.
Common DCF Calculator Errors (and How to Avoid Them)
A DCF calculator that produces the wrong number usually does so for one of seven reasons. Here are the errors a sell-side analyst will catch in five minutes and what to check before you hand the model up the chain. For sellside analyst training that covers exactly this set of mistakes, see CT Acquisitions’ sell-side analyst career guide.
| Error | Symptom | Fix |
|---|---|---|
| Terminal growth above long-run GDP | g greater than 3.0% | Cap at FOMC long-run GDP projection (~2.5% nominal in 2026) |
| WACC below cost of debt | WACC less than after-tax cost of debt | Recheck CAPM beta and ERP; this is a sign of input error |
| Mid-year on FCF but not TV | Inconsistent discount factors | Apply mid-year convention to both explicit FCF and terminal value |
| Adding back stock-based comp | Inflated FCF in tech and SaaS | Treat SBC as cash operating expense per current banker convention |
| Forgetting NWC investment | FCF too high in revenue ramp years | Tie NWC to revenue using DSO, DPO, days inventory schedules |
| Using book tax rate instead of marginal | NOPAT too high or too low | Use ~25% to 27% blended US federal-plus-state marginal cash rate |
| Wrong share count for diluted EPS | Per-share value off by 5% to 15% | Treasury stock method per ASC 260; add RSUs at full count |
| WACC from a 50-stock public peer set applied to $30M private business | Discount rate 200 to 400 bps too low | Add Kroll size premium for sub-$500M EV businesses |
The most common error in M&A practice is the share-count error: an analyst forgets that out-of-the-money options also count when deal price exceeds strike, or applies basic shares instead of diluted. This got litigated in In re Appraisal of Solera Holdings (Del. Ch. C.A. No. 12080-CB, 2018) where the court rejected a DCF in part on a flawed share count. The 2024 Delaware Chancery opinion in In re Mindbody Stockholders Litigation (Vice Chancellor Will) walked through valuation methodology on a take-private. Skadden’s M&A memos cover the litigation pattern where DCF inputs become the central evidentiary battle.
How a DCF Calculator Output Gets Used in a Real Deal
The output of a discounted cash flow calculator does not sit on its own in any real M&A process. It feeds into a football field of valuation methodologies, gets compared to trading comps and precedent transactions, and the implied range gets handed to a board for fairness-opinion purposes. The Sullivan & Cromwell-papered take-privates of 2024-2025 (including the Reuters Deals coverage of multiple sponsor LBOs) all included DCF as one of three to five methodologies in the proxy fairness opinion.
| Use case | Who runs it | What the output does |
|---|---|---|
| Sell-side fairness opinion | Sell-side bank (e.g., Goldman, Lazard, Houlihan Lokey) | Establishes a “fair value” range that the board uses to vote on the deal |
| Buy-side LBO model | Private equity associate | Sanity-check on the IRR-driven entry price; if DCF is far below LBO entry, sponsor is overpaying for synergies or growth |
| Strategic acquirer review | Corporate development team | Stand-alone value as the base from which synergies are added |
| Appraisal litigation | Plaintiff and defendant expert witnesses | The court (often Delaware Chancery) builds its “fair value” from the experts’ DCFs |
| Owner-led valuation | Founder, exit-planning advisor | Pre-process benchmark before engaging an M&A advisor |
The mid-market sale process where a founder runs a DCF first, then hires an M&A advisor, is the most common workflow at CT Acquisitions and similar middle-market firms. The DCF gives the seller a baseline to stress-test the advisor’s range and avoid getting talked into a price 20% to 30% below intrinsic value. For an LBO-side cross-check, see the LBO model from scratch walkthrough and the LBO model step-by-step guide.
DCF Calculator Output vs. Trading Multiples: Reconciling the Two
A discounted cash flow calculator and a trading-multiple calculation should produce overlapping valuation ranges on a healthy business. When they diverge by more than 30%, one of three things is happening, and a competent analyst has to write down which.
| Divergence pattern | Diagnosis | Action |
|---|---|---|
| DCF >> comps | Either the explicit-period forecast is too optimistic, or the market is mispricing the sector, or the company has an idiosyncratic moat the comps lack | Stress-test growth and margin assumptions; check if comps include true peers |
| DCF << comps | Either WACC is too high, terminal growth is too low, or the comps include premium-priced acquisition targets that distort the multiple | Recheck WACC inputs (especially size premium); consider whether comp set is contaminated by deal speculation |
| DCF and comps in tight range | Both methods are anchored to similar economic assumptions | Present both with a tight range as the recommendation |
The standard M&A presentation puts DCF as the widest bar on the football field (most assumption-rich) and trading comps as one of the narrower bars. Precedent transactions sit in between. Lazard’s quarterly M&A perspectives and Lincoln International’s perspectives both publish quarterly multiple updates by sector.
Using the DCF Calculator for Equity Compensation and 409A
A discounted cash flow calculator is also the foundation of a 409A valuation, which IRC Section 409A requires for any private company issuing stock options to employees. The 409A specialist (firms like Carta, Pulley, Eqvista, and traditional valuation firms like Stout, BDO, and Aranca) typically runs three methods: market approach (trading comps), transaction approach (recent funding rounds backed into using OPM or PWERM), and income approach (DCF). The DCF output feeds the income approach with a weight of 20% to 50% depending on the stage of the business.
| Stage | DCF weight in 409A | Why |
|---|---|---|
| Pre-revenue | 0% | No reliable cash flow forecast |
| Early revenue (Series A/B) | 10% to 20% | Forecast horizon too speculative |
| Growth-stage (Series C+) | 25% to 40% | Forecasts become defensible |
| Pre-IPO | 40% to 60% | DCF carries comparable weight to public-comp method |
| Profitable mid-market private | 50% to 70% | DCF is the primary intrinsic methodology |
The DCF used in a 409A is identical in math to the DCF used in M&A, but the discount rate has to include a discount for lack of marketability (DLOM) of 15% to 30% per AICPA Practice Aid on Valuation of Privately Held Company Equity Securities Issued as Compensation (the standard reference for 409A practitioners). For the related founder-share mechanics, see CT Acquisitions’ founder shares deep dive.
How a DCF Calculator Output Shows Up in a Stock Purchase Agreement
Once the DCF range is agreed and a buyer and seller settle on a purchase price, that price becomes a single number inside the stock purchase agreement (SPA). The SPA does not relitigate the DCF; instead, it allocates the purchase price across the transaction’s economic terms (closing cash payment, escrow holdback, earn-out, rollover equity, working-capital adjustment). The DCF assumption that did the most damage in disputes is the working-capital assumption, because it drives the post-closing working-capital true-up.
| SPA term | How the DCF assumption shows up |
|---|---|
| Purchase price | The single number agreed; typically a blend of DCF, comps, and precedents |
| Working-capital target (“peg”) | The NWC level baked into the DCF forecast; deviations at closing trigger dollar-for-dollar adjustment |
| Earn-out | Often based on hitting the revenue or EBITDA forecast inside the DCF |
| Rollover equity | Implied per-share value comes from the same DCF equity-value-per-share output |
| Material adverse effect (MAE) clause | If post-signing events materially impair DCF forecast, MAE may be triggered (see CT Acquisitions’ MAE explainer) |
| Golden parachute (280G) | Triggered by change-of-control payments that interact with the per-share equity value; see CT Acquisitions’ Golden Parachute 280G guide |
This is why the discounted cash flow calculator’s output is not just an academic number. It propagates through the SPA into the working-capital peg, the earn-out targets, and the rollover-equity per-share price. For the full structure of how an SPA is built around these inputs, see CT Acquisitions’ guide to stock purchase agreements, and for the cash-versus-installment-sale tax mechanics that often determine which price the seller ultimately pockets, see the installment sale vs cash sale business deep dive.
DCF Calculator and Qualified Small Business Stock (QSBS)
For founders selling a C-corporation that qualifies as Qualified Small Business Stock (QSBS) under IRC Section 1202, the DCF output has a direct interaction with the federal capital-gains exclusion. Section 1202 allows up to $10 million or 10 times basis (whichever is greater) of gain to be excluded from federal capital-gains tax if the stock was held more than five years and the issuing company met the QSBS criteria (US C-corp, less than $50 million in aggregate gross assets at issuance, and qualified active trade or business).
| QSBS scenario | DCF interaction |
|---|---|
| Founder DCF = $50M, basis = $0.1M | Up to $10M of gain excluded; remaining $40M taxed at long-term capital gains rate (20% federal plus 3.8% NIIT) |
| Founder DCF = $20M, basis = $0.5M | Up to $10M of gain excluded (the greater of $10M or 10x basis = $5M) |
| Founder DCF = $100M, basis = $5M | Up to $50M excluded (10x basis); remaining $45M taxed at LTCG plus NIIT |
A higher DCF output increases the value of the QSBS exclusion in absolute dollars because the cap is fixed. Founders running an internal DCF should be tax-aware: a $20M to $30M range can mean the difference between fully excluding the gain and paying federal capital-gains tax on the marginal $10M to $20M. CT Acquisitions’ deep dive on QSBS Section 1202 small business stock walks the holding-period mechanics.
Interview-Ready: How to Walk Through a DCF Calculator
If you are interviewing for an investment-banking analyst, private-equity associate, or sell-side equity research seat, “walk me through a DCF” is a near-certain question. The structured answer that every bank’s recruiting team expects, validated by hundreds of transcripts on Wall Street Oasis and Mergers & Inquisitions, is the same five-step structure that a discounted cash flow calculator runs internally.
| Interview step | What to say | Time to spend |
|---|---|---|
| 1. Forecast FCF | “Project revenue, EBIT margin, taxes, D&A, capex, and NWC for five to ten years to get unlevered FCF” | 30 seconds |
| 2. Calculate WACC | “CAPM for cost of equity using risk-free rate, equity risk premium, and relevered industry beta. After-tax cost of debt. Weight by target capital structure” | 20 seconds |
| 3. Discount FCF | “Apply 1/(1+WACC)^t to each year, mid-year convention if banking standard” | 10 seconds |
| 4. Terminal value | “Gordon Growth or exit multiple. Present both. Sanity-check implied multiple from Gordon Growth and implied g from exit multiple” | 20 seconds |
| 5. Bridge to equity | “Sum PVs to get EV. Subtract debt, add cash, adjust for non-op assets and pension. Divide by diluted shares using treasury stock method” | 20 seconds |
The follow-up almost every interviewer asks: “What’s the biggest weakness of a DCF?” Sensitivity to WACC and terminal growth, with bonus points for citing that TV usually represents 60% to 80% of EV. For full interview prep, see CT Acquisitions’ private equity analyst career guide and the paper LBO example walkthrough.
Comparing DCF Output to Other Valuation Methods
A discounted cash flow calculator is one of five methods practitioners use to value a business. None of them is right in isolation; they are presented together in a football-field chart and the recommendation is built from the overlap.
| Method | Input | Output | When it dominates |
|---|---|---|---|
| Discounted cash flow (DCF) | Forecast FCF, WACC, terminal value | Intrinsic enterprise value | Stable forecastable businesses; required in Delaware appraisal cases |
| Trading comparables | Public peer EV/EBITDA, EV/Revenue, P/E multiples | Relative enterprise value | Publicly traded comparable set exists and is liquid |
| Precedent transactions | M&A multiples paid in similar deals | Acquisition-priced relative value | Active deal flow in the sector; includes control premium |
| LBO analysis | Sponsor IRR target solved for entry price | Floor price (what a financial buyer can pay) | Strong cash flow, levered capital structure feasible |
| Sum of the parts | Per-segment DCF or multiple, summed | Conglomerate or multi-business value | Diversified business where segments trade at different multiples |
For business owners who want a more accessible framing of the same five methods, CT Acquisitions’ business valuation formula, methods, and math guide walks each method with worked numbers, and the DCF valuation in a 2026 business sale deep dive covers the sale-process angle.
TLDR and Takeaways
- A discounted cash flow calculator takes six inputs (Year 1 FCF, 5-year growth, EBIT margin, WACC, terminal growth, net debt) and outputs enterprise value, then equity value, then per-share value.
- The two core formulas are PV(FCF) = FCF / (1 + WACC)^t and TV (Gordon Growth) = FCF_N+1 / (WACC – g). Sum the PVs, add the discounted TV, subtract net debt, divide by diluted shares.
- Terminal value typically represents 60% to 80% of total enterprise value in a 5-year DCF, which means the terminal-value method (Gordon Growth or exit multiple) is not a footnote.
- WACC of 8% to 11% is the mid-market US default; add 200 to 400 basis points size premium per Kroll Cost of Capital Navigator for sub-$500M EV private businesses.
- Use mid-year convention for both explicit FCF and terminal value; mixing conventions is a classic analyst error that biases output 4% to 6%.
- Treat stock-based compensation as a cash operating expense (the post-2017 banking standard), not a non-cash add-back.
- Present a sensitivity table with WACC +/-100 bps and terminal growth +/-50 bps; a single point estimate is misleading.
- For private companies under $50 million enterprise value, the public-comparable WACC will overvalue the business by 20% to 30% if the size premium is not added.
- The same DCF output feeds fairness opinions, Delaware appraisal cases, 409A valuations, LBO IRR cross-checks, and stock purchase agreement working-capital pegs.
- For founders selling QSBS-qualified C-corp stock per IRC Section 1202, a higher DCF directly increases the dollar value of the federal capital-gains exclusion cap.