DCF and NPV: The Investment Decision Framework
Last updated: February 10, 2026
The CFO slid two proposals across the table. Both required $400,000 upfront. Both promised strong returns. But one generated cash flows front-loaded in years one and two, while the other back-loaded returns into years four and five. Without discounting, both looked identical on paper. With NPV analysis, one clearly created more value. The timing of cash flows changed everything.
Net present value converts future cash flows into today's dollars by applying a discount rate. It answers a direct question: after accounting for the time value of money and your required return, does this investment create or destroy value? A positive NPV means the project earns more than your hurdle rate. A negative NPV means it falls short.
This evaluator takes your initial investment, projected cash flows, discount rate, and optional terminal value to calculate NPV and estimate internal rate of return. Use it to compare projects, validate acquisition targets, or pressure-test capital expenditure decisions before committing resources.
What NPV Tells You
NPV is a single number that summarizes the value an investment creates above your required return. It accounts for both the magnitude and timing of cash flows, which raw totals ignore.
NPV formula:
NPV = Sum of [Cash Flow / (1 + r)^t] for each year t
Where r = discount rate as a decimal, t = year number (0 for initial investment)
| NPV Result | What It Means | Decision |
|---|---|---|
| Positive | Returns exceed your required rate | Project creates value; consider accepting |
| Negative | Returns fall short of required rate | Project destroys value; generally reject |
| Zero | Returns exactly match required rate | Break-even; indifferent on pure returns |
NPV captures timing
$100,000 received in year one is worth more than $100,000 in year five. NPV discounts later cash flows more heavily, rewarding projects that generate returns sooner.
NPV is additive
Unlike percentage returns, you can sum NPVs across projects. A portfolio of three projects with NPVs of $50K, $30K, and $20K creates $100K in total value.
Picking a Discount Rate
The discount rate is your opportunity cost. It represents what you could earn by investing the same capital elsewhere at similar risk. Get this wrong and your entire analysis falls apart.
Weighted Average Cost of Capital (WACC)
For corporate projects, WACC blends the cost of debt and equity weighted by capital structure. Public companies disclose WACC in SEC filings; private companies estimate based on comparables. Typical WACC for large US corporations ranges from 7% to 12% according to NYU Stern data.
Risk-Free Rate Plus Premium
Start with the 10-year Treasury yield (currently around 4.2% as of early 2026) and add a risk premium based on project uncertainty. Low-risk corporate projects might add 3 to 5 percentage points; high-risk ventures might add 10 to 20 points.
Hurdle Rate
Many organizations set a fixed hurdle rate for all projects. This simplifies decisions but may reject good low-risk projects or accept bad high-risk ones. Common hurdle rates range from 10% to 15% for established businesses.
Match Risk to Rate
A safe equipment upgrade with predictable savings deserves a lower discount rate than a speculative product launch. Using one rate for all projects biases decisions toward high-risk ventures.
Terminal Value Option
Terminal value captures value that extends beyond your explicit forecast period. It matters most when the asset continues generating returns after your analysis horizon ends.
When to include terminal value
Real estate with resale potential, businesses you might exit, equipment with salvage value, or any investment that keeps producing after year five or ten. For projects with finite lives and no residual worth, leave terminal value at zero.
Perpetuity growth method
For ongoing businesses, terminal value often uses the Gordon Growth Model: Terminal Value = Final Year Cash Flow times (1 + growth rate) divided by (discount rate minus growth rate). Typical perpetuity growth rates range from 2% to 3%, roughly matching long-term inflation.
Exit multiple method
For acquisition targets, terminal value may be calculated as a multiple of EBITDA or revenue in the final year. Multiples vary by industry: software companies trade at 5x to 15x revenue; manufacturing at 4x to 8x EBITDA.
Terminal Value Warning
In many DCF models, terminal value accounts for 50% to 80% of total present value. This makes it the most sensitive assumption. Small changes in perpetuity growth rate or exit multiple dramatically swing NPV. Always stress-test terminal value assumptions.
Stress-Testing Assumptions
A single-point NPV estimate hides uncertainty. Real decisions require understanding how results change when assumptions shift. Stress testing reveals which inputs matter most.
| Test | Method | What It Reveals |
|---|---|---|
| Sensitivity analysis | Change one input at a time (+/- 20%) | Which assumptions have the biggest impact |
| Scenario analysis | Model best, base, and worst cases | Range of possible outcomes |
| Break-even analysis | Find the input value where NPV = 0 | Margin of safety on key assumptions |
Discount Rate Sensitivity
Run the model at 8%, 10%, and 12% to see how rate-sensitive your investment is. Long-duration projects with back-loaded cash flows are more sensitive than short projects with front-loaded returns.
Cash Flow Sensitivity
Reduce projected cash flows by 10%, 20%, and 30% to see when NPV turns negative. If a 15% reduction kills the project, your margin for error is thin.
Worked Examples
Example 1: Manufacturing Equipment Upgrade
Inputs: $280,000 initial investment for CNC machine. Expected annual savings of $65,000 for 6 years from reduced labor and scrap. Salvage value of $25,000 at end of life. Company WACC is 9%.
Calculation: Year 0: -$280,000. Years 1-6: $65,000 each. Terminal value: $25,000 in year 6.
Present values: PV of cash flows = $291,873. PV of terminal value = $14,905. Total PV = $306,778.
Result: NPV = $306,778 - $280,000 = +$26,778. IRR = 12.4%. The equipment creates value above the 9% hurdle rate. Proceed with purchase.
Example 2: Small Business Acquisition
Inputs: Asking price of $500,000 for local HVAC company. Owner-adjusted EBITDA of $120,000. Projected cash flows: Year 1: $95,000, Year 2: $105,000, Year 3: $115,000, Year 4: $120,000, Year 5: $125,000. Exit at 4x EBITDA = $500,000. Buyer uses 15% discount rate for small business risk.
Present values: PV of operating cash flows = $360,417. PV of exit value = $248,588. Total PV = $609,005.
Result: NPV = $609,005 - $500,000 = +$109,005. IRR = 22.3%. At 15% required return, acquisition creates significant value. Sensitivity: If exit multiple drops to 3x, NPV falls to $46,858, still positive.
Sources
For Educational Purposes Only - Not Financial Advice
This calculator provides estimates for informational and educational purposes only. It does not constitute financial, tax, investment, or legal advice. Results are based on the information you provide and current tax laws, which may change. Always consult with a qualified CPA, tax professional, or financial advisor for advice specific to your personal situation. Tax rates and limits shown should be verified with official IRS.gov sources.