Discounted Cash Flow Calculator: DCF, NPV & PV Tool

Discounted Cash Flow Calculator

Discount a stream of future yearly cash flows back to present value, add an optional terminal value, and read net present value, discount factors, and discount-rate sensitivity from the standard DCF formula.

🎯Real DCF Presets

📝Cash Flow Inputs

Ignored in custom mode; that list sets the year count.

Year 1 amount for equal and growing modes.

Applied in growing mode: CF grows each year.

Cash out at time zero. Set 0 for pure PV.

Optional exit or residual value in the last year.

Used only in custom mode. Example: 12000, 15000, -4000, 30000.

Net present value $0 PV of flows minus cost today
Total PV of cash flows $0 sum of discounted yearly CF
Sum of undiscounted CF $0 nominal total, no discounting
Terminal value PV $0 discounted exit value

🔢Formula Snapshot

CFCash flow year t
rDiscount rate
tYear number
NPVNet present value

📊Year-by-Year Discounting

Year (t)Cash FlowDiscount FactorPresent ValueCumulative PV
Enter values above to build the year-by-year discounting schedule.

📉NPV vs Discount Rate Sensitivity

Discount RatePV of Cash FlowsTerminal PVNet Present ValueVerdict
The sensitivity table appears after calculation.

The rate where net present value crosses zero is the internal rate of return (IRR) for this cash flow stream.

đź—‚Discount Factor Reference by Rate & Year

Year (t)4% Rate6% Rate8% Rate10% Rate12% Rate15% Rate
10.96150.94340.92590.90910.89290.8696
20.92460.89000.85730.82640.79720.7561
30.88900.83960.79380.75130.71180.6575
50.82190.74730.68060.62090.56740.4972
70.75990.66510.58350.51320.45230.3759
100.67560.55840.46320.38550.32200.2472

đź—‚DCF Scenario Comparison Grid

ScenarioCF PatternYearsRate (r)Initial CostTerminal
5-year businessGrowing 8%/yr5 yr12%$120k$150k exit
Rental propertyRent minus costs10 yr8%$250kResale value
Startup valuationSteep growth7 yr25%$500kExit multiple
Bond cash flowsFixed coupons10 yr6%Price paidFace value
Equal annuityLevel $10k/yr5 yr10%$35kNone
Project NPVUneven per year6 yr10%$60kSalvage value

⚙Full Formula Breakdown

Discount rater = discount rate / 100. A 10% WACC becomes r = 0.10 for every period in the model.
Discount factorDF for year t = 1 / (1 + r)^t. It falls each year, so cash further out is worth less today.
Cash flow year tEqual mode: CF_t = CF. Growing mode: CF_t = CF × (1 + g)^(t – 1). Custom mode reads your list.
Present valuePV_t = CF_t Ă— DF_t. Total PV = sum of PV_1 through PV_n across all years.
Terminal valueTerminal PV = TV / (1 + r)^n, discounting the exit or residual value from the final year n.
Net present valueNPV = total PV + terminal PV – initial investment. Positive NPV clears the discount-rate hurdle.
Mid-year optionMid-year timing uses t – 0.5 in the exponent, assuming cash arrives across the year, not only at year end.

đź“‹DCF Terms Reference

TermMeaningHow It Is UsedEffect on NPV
Discount rate (r)Required annual returnDrives 1 / (1 + r)^tHigher rate lowers NPV
Present value (PV)Today value of one CFCF Ă— discount factorAdds into total PV
Net present valuePV of flows minus costTotal PV – initial costSign is the accept rule
Terminal value (TV)Exit or residual valueTV / (1 + r)^nCan dominate long models
Growth rate (g)Yearly CF growthCF × (1 + g)^(t – 1)Raises later cash flows
WACCBlended cost of capitalCommon choice for rSets the hurdle rate

đź’ˇPractical DCF Tips

Discount rate tip: The discount rate does the heavy lifting. A move from 8% to 12% can cut a ten-year present value sharply, so test a range of rates before you trust one NPV.
Terminal value tip: In long models the terminal value can be most of the answer. Discount it back with 1 / (1 + r)^n and sanity-check it against the discounted operating cash flows.

When you spend versus save today, you might have a hunch that one dollar today is worth more than one dollar tomorrow. That’s because the dollar today has more buying power than the dollar you’ll be paid tomorrow. To quantify this difference, we convert time into numbers. Discounted cash flow analysis calculates a single present value figure which eliminates uncertainty about what lies ahead. It answers: Is this a good use of my capital right now?

This all depends on one key factor: the discount rate. This is what we call the weighted average cost of capital or WACC. It are the interest rate you would expect if you took on same amount of risk but received different returns. If an investment is very speculative, requiring a 10% per year return, then receiving cash in Year Five is worth less now than getting cash tomorrow. Conversely, a small shift in that rate can cause massive swings in value.

How Discounted Cash Flow Works

Fortunately, the calculator makes these calculations for you without forcing you to fiddle with fractional powers and exponents. Because of compound growth, slight variations in discount rate make huge differences in outcome. Switching from an eight percent to a twelve percent discount over ten years won’t merely lower profits; it will wipe them out completely.

The second aspect is speed. How fast are those cashflows? Generally, they don’t come steadily at all but gradually ramp up from small amounts then stabilize. This is where the tool realy shines, you’re able to input actual cashflow streams, either in annuity fashion or something wild like this: high-low-high-peak-plateau-slow-decline-steady-bang! Add a terminal value for period beyond your project horizon.

Over time, that exit number will dominate the total outcome, so remain skeptical to keep your analysis true. Future promises are converted into present value. Each predicted dollar is multiplied by decreasing factor that decreases with increasing time horizon. At a modest interest rate, it’s only about one-half of the original factor by year ten. You can see the decline yourself in the yearly breakdown presented by the calculator… The weights applied to each period sits right there on the table.

That’s what you’ll notice when you look at those numbers and understand why real-world valuation so frequently favor short-term cash over long-term promise. That’s the final verdict, net present value. It simply takes your initial cost and discounts it into the future. Then, it subtracts that figure from total amount of money you’ll receive in the future. If the answer is positive, that means the deal adds theoretical wealth and meets your personal hurdle rate. If the answer is negative, that means required return is too high to be worth those future payouts.

The binary signal eliminates emotion from your investment decisions. It forces you to define “success” before spending a single penny. The second mistake is choosing an overly-optimistic discount rate or failing to account for the fact that a model will be highly sensitive to a variable’s change. The interface includes a sensitivity table that plots out how fast net present value goes negative at higher rates.

This is helpful feedback on whether you have a project with some margin for error if, say, financing costs are suddenly higher then expected, or inflation spikes. Think of this as risk mapping more than fortune telling. It’s not that you’re trying to predict what will happen exactly. You’re outlining what needs to be true for it to become okay to move forward. Force yourself to be specific about these variables (opportunity cost, growth expectations, exit strategy). These details would of otherwise hide beneath fuzzy emotions.

Once you do this, the math take over and does the heavy lifting without any hesitation or bias. But that’s fine, making a better decision doesn’t require perfect information. It only requires consistently applying some logic to similar choices. If it’s a startup equity investment, a corporate expansion proposal, or a rental property, it all follows the same framework. Discount future cash back to present-day terms. Subtract immediate costs. Whatever’s left tells you whether the risk is worth taking.

And as long as math adds up in-between, the one dollar in your hand will beat the far-off promise.

Discounted Cash Flow Calculator: DCF, NPV & PV Tool