Discounted Cash Flow Calculator
Calculate Net Present Value (NPV), approximate IRR, payback period, and profitability index from projected cash flows.
Results
Visualization
How It Works
This calculator helps you evaluate whether an investment or project is worth pursuing by computing its Net Present Value (NPV), Internal Rate of Return (IRR), payback period, and profitability index. These metrics together show you the total profit potential, speed of cost recovery, and return efficiency of your investment in today's dollars. This tool is designed for both quick estimates and detailed planning scenarios. Results update instantly as you adjust inputs, making it easy to compare different approaches and understand how each variable affects the outcome. For best accuracy, use precise measurements rather than rough estimates, and consider running multiple scenarios to establish a realistic range of expected results.
The Formula
Variables
- Initial Investment — The upfront cash outlay required to start the project or purchase the asset (e.g., $50,000 for equipment)
- Discount Rate (r) — The annual percentage rate used to convert future cash flows to present value, reflecting your required return or cost of capital (e.g., 10% annually)
- Annual Cash Flows — The net cash inflows (or outflows) expected each year from the investment, entered as comma-separated values (e.g., 15000, 18000, 20000)
- NPV — Net Present Value — the total profit in today's dollars; positive NPV means the investment exceeds your required return
- IRR — Internal Rate of Return — the annualized percentage return the investment actually generates; compare this to your discount rate to assess attractiveness
- Payback Period — The number of years needed to recover your initial investment from cash flows; shorter periods indicate faster capital recovery
- Profitability Index — The ratio of present value of future cash flows to initial investment; ratios above 1.0 indicate value creation
Worked Example
Suppose you're considering a $100,000 solar panel installation for your business with a 12% discount rate (your required annual return). You expect cash flows of $20,000 in Year 1, $22,000 in Year 2, $25,000 in Year 3, $28,000 in Year 4, and $30,000 in Year 5. The calculator discounts each year's cash flow: Year 1 is $20,000 ÷ 1.12¹ = $17,857; Year 2 is $22,000 ÷ 1.12² = $17,509; continuing through Year 5 gives a total present value of about $87,232. The NPV is $87,232 − $100,000 = −$12,768 (negative, so this investment doesn't meet your 12% return requirement). The approximate IRR might be around 8%, which is below your 12% threshold, confirming the project's lower attractiveness at this discount rate. However, if your required return were 6% instead, the NPV would turn positive, changing your investment decision.
Practical Tips
- Use your company's weighted average cost of capital (WACC) or your personal required return as the discount rate—this ensures apples-to-apples comparison with other opportunities that also require that same return threshold
- A positive NPV doesn't always mean 'invest'—consider non-financial factors like strategic fit, risk, and timing before committing capital
- The IRR is most useful when comparing two projects; if IRR exceeds your discount rate, the project typically adds value, but always validate assumptions driving the cash flow estimates
- Payback period is an incomplete metric on its own because it ignores profits beyond the payback year and doesn't account for the time value of money—use it alongside NPV for a complete picture
- Stress-test your cash flow assumptions by running the calculator with optimistic, realistic, and pessimistic scenarios to understand how sensitive your decision is to forecast errors
Frequently Asked Questions
What's the difference between NPV and IRR, and which one matters more?
NPV tells you the absolute dollar profit in today's money; IRR tells you the percentage return rate. For decision-making, NPV is generally more reliable because it directly answers 'How much richer will I be?' However, IRR is useful for comparing projects of different sizes. If NPV is positive and IRR exceeds your required return, proceed; if they conflict (rare), trust NPV because IRR can be misleading when cash flows change sign multiple times.
What discount rate should I use?
Use your cost of capital or required rate of return. For a business, this is often the weighted average cost of capital (WACC). For personal investments, use your expected annual return from other opportunities (e.g., stock market returns at 8-10%, or a business loan rate). If unsure, start with a conservative rate like 8-10% and see if your project clears that hurdle.
Can the payback period be longer than the project's life?
Yes, and that's a red flag. If your project only runs 5 years but the payback period is 7 years, you never fully recover your investment during the project's life. This doesn't automatically disqualify the project (especially if NPV is positive), but it signals high risk and slow capital recovery.
What does a profitability index of 1.5 mean?
A profitability index of 1.5 means that for every $1 invested, you get $1.50 back in present value terms. Ratios above 1.0 indicate the investment creates value; higher ratios are better. It's especially useful when choosing between projects with different initial costs—rank them by profitability index to maximize bang for your buck.
Why might my cash flow estimates be wrong, and how do I handle that?
Estimates are wrong because markets change, competition shifts, costs rise unexpectedly, or customers behave differently than predicted. Build in a buffer by using conservative projections, sensitivity analysis (recalculate with ±10% cash flow changes), and scenario planning. If small changes in assumptions flip your NPV from positive to negative, the decision is risky and warrants deeper investigation before committing capital.
Sources
- Corporate Finance Institute: Net Present Value (NPV)
- Investopedia: Internal Rate of Return (IRR)
- U.S. Small Business Administration: Financial Analysis for Small Business
- Financial Accounting Standards Board (FASB): Capital Investment Guidance
- Harvard Business Review: Making Smart Capital Allocation Decisions