How to Calculate the NPV of a Rental Property

How to Calculate the NPV of a Rental Property
Using a spreadsheet to calculate NPV allows you to easily update your calculations and change major assumptions.

Identifying Cash Flows

Identify the expected cash inflows and outflows associated with the rental property. Costs already incurred prior to the analysis are ignored, as they are considered sunk costs. The primary inflow would be derived from rent, although you may also need to factor in late or other sundry fees. Outflows may include mortgage costs, property tax expenses and repairs and maintenance costs. It is important that you accurately estimate the cash flow amounts as well as the timing of the inflows and outflows.

Net Present Value Calculation

Use a spreadsheet to prepare your net present value calculation, beginning with a section summarizing your assumptions, such as your discount rate. This allows you to link to the assumptions within the spreadsheet formulas you input, so you don't have to repeatedly enter them manually for each calculation. In an orderly manner, enter in your cash flow estimates so they reflect the proper time frame. The present value factor for all cash flows is calculated as: 1/(1+r)^n, where "r" is the discount rate and "n" is the time period, which you can enter as months. Therefore, if a cash flow is received at month 6, "n" would equal 0.5. If r equals 10 percent, and n equals 0.5, the present value factor equals 0.9534. Multiply this present value factor by the applicable cash inflow and outflow, and take the sum of all present values. The result is your net present value.