Net Present Value (NPV) Calculator

What Net Present Value Tells You

Net present value calculates whether an investment creates or destroys value relative to your required rate of return. It discounts all future cash flows back to today's dollars using a discount rate that represents your cost of capital or the return you could earn elsewhere. If NPV is positive, the investment earns more than your required return and creates value. If NPV is negative, the investment fails to meet your required return and destroys value relative to the alternative use of that capital.

For real estate investors, NPV is particularly useful for evaluating buy-and-hold strategies where cash flows span multiple years and include a sale event at the end. Unlike simpler metrics like cash-on-cash return or cap rate that look at a single year, NPV accounts for the time value of money and evaluates the entire investment lifecycle from purchase through sale.

How This Calculator Works

Enter your initial investment at Year 0, which represents total cash out of pocket including down payment, closing costs, and initial repairs. Set your discount rate to your required annual return or cost of capital. Then enter the expected cash flow for each year of the hold period. The final year should include both the operating cash flow and the net sale proceeds after selling costs and mortgage payoff.

The calculator discounts each year's cash flow to present value using the formula PV = CF / (1 + r)^n, where r is the discount rate and n is the year number. The present value of each cash flow appears in the PV column next to the input. NPV is the sum of all discounted cash flows minus the initial investment.

Choosing the Right Discount Rate

The discount rate is the most important assumption in an NPV calculation. For real estate investors, common approaches include using your weighted average cost of capital, the return available from alternative investments with similar risk, or a personal hurdle rate that reflects your minimum acceptable return. Most residential real estate investors use discount rates between 8% and 12%.

A higher discount rate makes future cash flows worth less in present value terms, which lowers NPV. A lower discount rate makes future cash flows worth more, which raises NPV. The rate sensitivity section shows NPV at your chosen rate plus and minus 2 percentage points so you can see how sensitive the result is to this assumption. If NPV stays positive across all three rates, the deal is resilient. If it flips negative at the higher rate, the investment is marginal.

Profitability Index and Discounted Payback

The profitability index divides the present value of all future cash flows by the initial investment. A PI of 1.20 means every dollar invested returns $1.20 in present value, creating $0.20 of value per dollar. PI above 1.0 means the investment is worth pursuing. PI below 1.0 means it is not. PI is useful for comparing investments of different sizes because it normalizes returns per dollar invested.

The discounted payback period shows how many years it takes for the cumulative present value of cash flows to equal the initial investment. Unlike simple payback, discounted payback accounts for the time value of money. A shorter discounted payback means faster capital recovery and less exposure to long-term projection risk. If the discounted payback exceeds the hold period, the investment never recoups on a present-value basis within the projected timeline.

Structuring Cash Flows for Real Estate

For a typical rental property investment, annual cash flows represent net operating income minus debt service (the same as after-mortgage cash flow). The final year's cash flow should include the expected sale price minus selling costs, remaining mortgage balance, and any capital gains considerations, plus that year's operating cash flow. This approach captures the full lifecycle return including both income and equity realization.

For properties with planned renovations, early years may show negative or reduced cash flows during the improvement period followed by higher cash flows once rents increase. The dynamic year table with add and remove buttons lets you model any hold period from 1 to 30 years with different cash flows each year.

Frequently Asked Questions

What is a good NPV for a rental property?

Any positive NPV means the investment exceeds your required return. Higher NPV means more value created. A $50,000 NPV on a $200,000 investment means you earn your required return plus $50,000 of additional value in today's dollars.

What discount rate should I use?

Use your required return, cost of capital, or best alternative investment return at similar risk. Most residential investors use 8 to 12 percent. Higher rates set a tougher bar. The sensitivity section shows impact of rate changes.

How is NPV different from IRR?

NPV tells you the dollar amount of value created at a specific discount rate. IRR tells you the actual percentage return the investment generates. NPV requires choosing a discount rate. IRR calculates the rate that makes NPV equal zero.

What should I include in the final year cash flow?

Operating cash flow for the year plus net sale proceeds. Net proceeds equal the sale price minus selling costs (agent fees, closing costs) and remaining mortgage balance. This captures total equity returned at exit.

What does profitability index tell me?

PI shows present value returned per dollar invested. PI of 1.25 means $1.25 in PV per $1 invested, creating $0.25 of value per dollar. PI above 1.0 means the deal exceeds your required return. Useful for ranking deals by capital efficiency.

Can NPV be negative even if the property cash flows positive?

Yes. A property can generate positive cash flow every year but still produce negative NPV if the total returns fall below your discount rate. This means the property earns less than your required return or best alternative.