Investors can use the Net Present Value (NPV) function in Microsoft Excel to compute the value of properties. The first step is to make an estimate of the expected annual cash flows over your expected holding period. You will also have to select an appropriate discount rate. See our What is Cap Rate? page for more details on discount rate selection.
It takes just four minutes