Discounted Project ROI Calculator
Discounted Project ROI Calculator
| Discounted Return Breakdown | Amount |
|---|---|
| Initial Investment | $200,000 |
| Year 1 Cash Flow ($70,000) | $70,000 |
| Cash Flow Growth (3.0%/yr) | $371,640 total |
| Undiscounted Total Cash Flow | $371,640 |
| Discounted Total @ 14.0% | $253,215 |
| Discounted Terminal Value | $12,984 |
| Net Present Value (NPV) | $66,199 |
| Discounted ROI | 33.1% |
Summary
What Is a Discounted Project ROI Calculator?
A discounted project ROI calculator estimates the return on a project investment after accounting for the time value of money, the growth of cash flows over the project's life, and the erosion of value from inflation. Undiscounted return calculations treat a dollar earned in year five as equal to a dollar invested today, which overstates the attractiveness of long projects because capital tied up today could have earned a return elsewhere, and future dollars buy less as prices rise. The discounted approach converts every future cash flow into its present value, then compares the total against the investment to produce a net present value and a discounted ROI that reflect the project's true economic contribution. This calculator adds cash flow growth and an inflation adjustment to the standard discounting framework, giving finance teams the version of project ROI that belongs in capital approval processes.
How It Works
The four core inputs are the initial investment, the year-one annual cash flow, the discount rate, and the project life in years. The model projects the cash flow forward year by year, growing it at the growth rate, and accumulates the undiscounted total for comparison. With the default inputs, a $200,000 investment with $70,000 of year-one cash flow growing at 3% a year produces roughly $372,000 of undiscounted cash flow over five years. The advanced options add the cash flow growth rate, the inflation adjustment, and the terminal value. The effective discount rate adds the inflation adjustment to the stated discount rate, and each year's cash flow is divided by one plus the effective rate raised to the year, producing the discounted total. The terminal value is discounted back from the final year, and the net present value subtracts the investment from the sum of the discounted cash flows and discounted terminal value. The discounted ROI divides the NPV by the investment, the simple ROI uses the undiscounted figures for comparison, and the discounted payback counts the years until discounted cumulative cash flow first covers the investment.
Understanding Your Results
The discounted ROI is the metric to use in capital approval, because it accounts for everything the simple ROI ignores: the timing of cash flows, the growth assumption, and the erosion of future value. The gap between the discounted and simple ROI is the cost of the discounting itself, and a large gap signals a project whose benefits arrive late. A positive NPV means the project clears the cost of capital; a negative one means it destroys value even if the undiscounted numbers look healthy. The discounted payback is the conservative version of the payback period, and if it stretches past the project life, the project is not viable under the stated assumptions. Re-run the model with a higher discount rate and slower growth to test whether the project survives a conservative case, and keep the inflation adjustment consistent with your organization's planning assumptions.
Related Calculators
Home Loan Calculator
Calculate home loan EMI, total interest, and amortization schedule.
Auto Loan Calculator
Detailed auto loan with trade-in, taxes, fees, and amortization.
Bike Loan Calculator
Calculate bike loan EMI, total cost, and repayment breakdown.
Boat Loan Calculator
Estimate boat financing payments, interest, and amortization.
Student Loan Calculator
Calculate student loan payments with income-driven repayment plans.
Gold Loan Calculator
Calculate gold loan amount based on gold weight, purity, and LTV ratio.
USDA Loan Calculator
Calculate USDA loan payments with guarantee fee and income eligibility.
Loan Against Property Calculator
Calculate LAP EMI based on property value and loan-to-value ratio.