Real Estate NPV Calculator
Net present value of the deal at your required return for a property. Live calculator with worked steps and charts.
Calculator
The price you pay, before closing costs.
Investment loans typically require 20–30% down.
Gross scheduled rent before vacancy.
Share of scheduled rent lost to turnover and non-payment.
Share of effective income budgeted for repairs.
Share of collected rent charged by the manager.
Commission plus closing costs, as a share of sale price.
The annual return you require to tie up cash.
Advanced options (9)
Laundry, parking, storage, late fees, pet rent.
The non-depreciable land keeps the rest.
This property calculator runs on a full rental pro-forma: rent is annualised and reduced by vacancy, every operating expense is itemised to reach NOI, and the loan amortises monthly at the rate entered. Results update live as you type.
Amortization schedule
| Year | Interest | Principal | Ending Balance |
|---|---|---|---|
| 1 | $15,677.60 | $2,285.57 | $222,714.43 |
| 2 | $15,512.37 | $2,450.80 | $220,263.63 |
| 3 | $15,335.20 | $2,627.96 | $217,635.67 |
| 4 | $15,145.23 | $2,817.94 | $214,817.73 |
| 5 | $14,941.52 | $3,021.65 | $211,796.08 |
| 6 | $14,723.08 | $3,240.08 | $208,555.99 |
| 7 | $14,488.86 | $3,474.31 | $205,081.68 |
| 8 | $14,237.70 | $3,725.47 | $201,356.21 |
| 9 | $13,968.38 | $3,994.78 | $197,361.43 |
| 10 | $13,679.60 | $4,283.57 | $193,077.86 |
| 11 | $13,369.94 | $4,593.23 | $188,484.64 |
| 12 | $13,037.90 | $4,925.27 | $183,559.37 |
| 13 | $12,681.85 | $5,281.32 | $178,278.05 |
| 14 | $12,300.06 | $5,663.11 | $172,614.94 |
| 15 | $11,890.68 | $6,072.49 | $166,542.45 |
| 16 | $11,451.69 | $6,511.47 | $160,030.98 |
| 17 | $10,980.98 | $6,982.19 | $153,048.79 |
| 18 | $10,476.24 | $7,486.93 | $145,561.86 |
| 19 | $9,935.01 | $8,028.16 | $137,533.69 |
| 20 | $9,354.65 | $8,608.52 | $128,925.18 |
| 21 | $8,732.34 | $9,230.83 | $119,694.35 |
| 22 | $8,065.04 | $9,898.13 | $109,796.22 |
| 23 | $7,349.50 | $10,613.66 | $99,182.56 |
| 24 | $6,582.24 | $11,380.93 | $87,801.63 |
| 25 | $5,759.51 | $12,203.65 | $75,597.98 |
| 26 | $4,877.31 | $13,085.86 | $62,512.12 |
| 27 | $3,931.33 | $14,031.83 | $48,480.29 |
| 28 | $2,916.97 | $15,046.20 | $33,434.09 |
| 29 | $1,829.28 | $16,133.89 | $17,300.21 |
| 30 | $662.96 | $17,300.21 | $0.00 |
Results
Net Present Value
$38,050
Discounted at your 8.00% required return.
1000.00%
The rate at which NPV is zero.
$127,050
$89,000
$162,451
1.43x
PV of inflows ÷ cash invested.
$3,805
8.00%
Live results update as you type — currently showing net present value of $38,050. Replace the defaults with your own rent roll, tax bill and insurance quote for an exact comparison.
Visualizations
Present Value vs Cash Invested
Discounted Cash Flow by Year
NPV
Formula
Net present value discounts every future cash flow at your required return and subtracts what you pay today. Positive NPV means the deal beats your hurdle; negative means it does not.
Variables
| Symbol | Name | Unit | Description |
|---|---|---|---|
| r | Discount rate | %/yr | The annual return you require |
| CFt | Cash flows | $ | Everything the deal pays you |
| NPV | Net present value | $ | Value today minus cost today |
Explanation
NPV answers the question IRR cannot: not "what is the return?" but "is this deal worth more than it costs at the return I actually require?" — which makes it the cleanest accept/reject test.
Step-by-Step Calculation
Follow each step to understand how the result is calculated from your inputs.
Lay out the cash flows: cash in today, cash flow each year, sale proceeds at the end.
Discount every future amount back to today at the required return.
Subtract the cash invested today from that present value.
Worked Examples
See how the calculator works with different scenarios.
Scenario
The real estate npv calculator run on the values above, showing the full calculation path rather than only the answer.
Inputs
Calculation
1. Lay out the cash flows: cash in today, cash flow each year, sale proceeds at the end. → 10 years of cash flows 2. Discount every future amount back to today at the required return. → $127,050 present value 3. Subtract the cash invested today from that present value. → $38,050 NPV
Result
Net Present Value: $38,050
Interpretation
Discounting the projected stream at 8.00% gives a $38,050 NPV on $89,000 invested — a 1.43x profitability index.
Understanding Your Result
Your Result: Net Present Value: $38,050
Typical range: A positive NPV at an 8–10% discount rate means the deal beats a passive alternative of similar risk; the further above zero, the larger the margin for error.
What This Means
NPV answers the question IRR cannot: not "what is the return?" but "is this deal worth more than it costs at the return I actually require?" — which makes it the cleanest accept/reject test.
Why It Matters
Discounting the projected stream at 8.00% gives a $38,050 NPV on $89,000 invested — a 1.43x profitability index.
Professional Interpretation
Discounting the projected stream at 8.00% gives a $38,050 NPV on $89,000 invested — a 1.43x profitability index.
How this is calculated
Net present value discounts every future cash flow at your required return and subtracts what you pay today. Positive NPV means the deal beats your hurdle; negative means it does not.
What drives the result
Time value of money: cash received in later years is worth less than cash today, so discounted metrics (IRR, NPV, discounted payback) re-express the whole stream at today’s value. Simple metrics (cap rate, cash-on-cash, equity multiple) ignore timing but are faster to compute and communicate.
Recommendations
- •The discount rate is your opinion, so run it 2% higher and lower; a deal that only clears at 6% is fragile.
- •NPV answers "how much value", IRR answers "how fast" — check both before comparing deals.
Educational Content
Introduction
Return metrics compress a whole investment into one comparable number. Each answers a different question: cash-on-cash prices the first year, IRR prices the whole hold including the sale, equity multiple counts total distributions, and NPV tests the deal against your own hurdle rate.
Concept Explanation
Time value of money: cash received in later years is worth less than cash today, so discounted metrics (IRR, NPV, discounted payback) re-express the whole stream at today’s value. Simple metrics (cap rate, cash-on-cash, equity multiple) ignore timing but are faster to compute and communicate.
Applications
Benefits
- •Makes a multi-year, multi-cash-flow investment comparable with anything else you could buy
- •IRR and NPV capture the size and the timing of returns, not just their total
- •Equity multiple gives a quick, intuitive total-cash view for partners
Limitations
- •IRR assumes interim cash flows reinvest at the IRR itself, which overstates long holds; check the equity multiple alongside it
- •Exit assumptions — growth rate and selling costs — drive more of the answer than most operating inputs
- •None of the metrics price risk: a stable single-family rental and a speculative development can share an IRR
Best Practices
- •Pick a discount rate you actually require — 8–12% is common for leveraged rentals — and let NPV veto deals below it
- •Run the return at three exit scenarios: flat, +3% and −5% growth; the spread is the risk
- •Report cash-on-cash for year one, IRR for the hold, and equity multiple for the total picture
Common Misconceptions
Practical Tips
- •Set the discount rate to your true opportunity cost — index-fund return plus a risk premium is a defensible floor
- •A positive NPV with a thin margin is fragile; look for NPV that survives a worse exit scenario
Common Mistakes
Assumptions
This calculator makes the following assumptions to provide estimates:
Limitations
Be aware of these limitations when using this calculator:
Frequently Asked Questions
Answers to common questions about this calculator.
NPV or IRR — which should I use?
Who uses the real estate npv calculator?
How accurate is the real estate npv calculator?
Do I need to sign up or pay to use this calculator?
Can I use these numbers in a formal valuation or loan application?
How do I choose realistic inputs?
Related Calculators
Explore more calculators related to this topic.
Related Guides
Deepen your understanding with these educational resources.
How the pro-forma layers build from rent to cash flow, and where deals usually hide problems.
Which metric answers which question, and why none of them should be read alone.
Down payments, rate premiums and how lenders size income-property loans.
Glossary
Technical terms used in mortgage calculations explained in plain language.
- Net Present Value (NPV)
- The value today of the future cash flows minus the cash invested, discounted at your required return. Positive NPV clears your hurdle.
- Discount Rate
- The annual return you require, used to convert future cash into present value.
- Internal Rate of Return (IRR)
- The discount rate at which a project’s net present value is zero — the annualised, timing-aware return of the whole hold.
Authoritative References
Trusted sources and standards referenced by this calculator.
Applicable Standards
Was This Calculator Helpful?
Page Information
2026-09-21
2.0.0
Free to use for educational and professional purposes.