Present Value of Lease Payments & NPV Calculator (PV of MLP & IFRS 16)
Calculate the present value of future lease payments (PV of MLP / PVMLP) and commercial rent schedules. Fully compliant with IFRS 16 / ASC 842 lease liability discounting and UK HMRC SDLT net present value calculation.
The project earns more than the required return at the selected discount rate. Value is expected to be added to the firm.
Bars: present value of each period (Year 0 is initial outlay). Polyline: running cumulative total. When the line crosses zero, the project achieves economic break-even in today's money.
| Year | Cash flow | Discount factor | Present value | Running total |
|---|---|---|---|---|
| Year 0 | $0 | 1.0000 | $0 | $0 |
| Year 1 | $120,000 | 0.9390 | $112,676 | $112,676 |
| Year 2 | $120,000 | 0.8817 | $105,799 | $218,475 |
| Year 3 | $125,000 | 0.8278 | $103,481 | $321,956 |
| Year 4 | $125,000 | 0.7773 | $97,165 | $419,122 |
| Year 5 | $130,000 | 0.7299 | $94,885 | $514,006 |
| Year 6 | $130,000 | 0.6853 | $89,093 | $603,100 |
| Year 7 | $135,000 | 0.6435 | $86,873 | $689,973 |
| Discount Rate | Scenario | Net Present Value | Variance vs Base | Viability |
|---|---|---|---|---|
| 2.5% | -400 bps | $801,180 | +$111,207 | Accept |
| 4.5% | -200 bps | $742,424 | +$52,451 | Accept |
| 5.5% | -100 bps | $715,466 | +$25,493 | Accept |
| 6.5%Active | Base Case (Active) | $689,973 | — (Base) | Accept |
| 7.5% | +100 bps | $665,847 | -$24,125 | Accept |
| 8.5% | +200 bps | $642,998 | -$46,975 | Accept |
| 10.5% | +400 bps | $600,796 | -$89,177 | Accept |
Sensitivity analysis reveals how NPV shifts when corporate borrowing costs or inflation vary. As the discount rate increases, present value decreases.
Formula & Calculation Logic
PV_lease = Σ [Lease Payment_t / (1 + r)^t] + [Guaranteed Residual Value / (1 + r)^n]This financial model applies precise periodic compounding to establish the exact present economic value of future cash inflows against the required initial investment.
Key Capabilities & Features
- Calculates PV of Minimum Lease Payments (PVMLP) for 90% capital lease test
- Step-by-step discounting schedule for IFRS 16 / ASC 842 lease liability recognition
- Evaluates UK HMRC Stamp Duty Land Tax (SDLT) NPV thresholds
- Supports fixed, escalating rent streams, and guaranteed residual value
Frequently Asked Questions
What is Net Present Value (NPV)?
Net Present Value (NPV) is a core financial metric used in capital budgeting to analyze the profitability of a projected investment or project. NPV calculations take into account the time value of money by discounting expected future cash flows back to their present value using a specified discount rate (such as WACC or required rate of return). If the NPV is positive, the project is projected to generate surplus value over and above its cost of capital.
What discount rate should I use for NPV?
Choosing the right discount rate depends on who is investing: 1. **Corporations:** Typically use the Weighted Average Cost of Capital (WACC), which blends the after-tax cost of debt and cost of equity. 2. **Individual Investors:** Use target required rate of return or the return available on alternative investments of similar risk (opportunity cost of capital). 3. **High-Risk Projects / Startups:** Adjust the hurdle rate using divisional CAPM beta calibration or formal cost-of-capital frameworks rather than ad-hoc additions. 4. **Public Infrastructure:** Often use government social discount rates (typically 3% to 8%).
How is the Net Present Value of a lease calculated for SDLT and IFRS 16?
For commercial leases, calculating the Net Present Value of lease payments serves two major purposes: 1. **IFRS 16 & ASC 842 Accounting:** Tenants must recognize the present value of future lease payments as a lease liability and Right-of-Use (ROU) asset on the balance sheet using the incremental borrowing rate. 2. **UK HMRC Stamp Duty Land Tax (SDLT):** When granting a new non-residential lease, SDLT is calculated based on the Net Present Value of the annual rent payable over the full lease term discounted at the statutory 3.5% rate.
How do you calculate the Present Value of lease payments under IFRS 16 & ASC 842?
Under international accounting standards (IFRS 16 and US GAAP ASC 842), lessees must recognize a Right-of-Use (ROU) asset and lease liability on their balance sheet. **Steps to Calculate Lease Present Value:** 1. **Identify the Lease Payments:** List all fixed rental payments across the non-cancellable lease term. 2. **Determine the Discount Rate:** Use the rate implicit in the lease; if not readily determinable, use the lessee’s **Incremental Borrowing Rate (IBR)**. 3. **Discount Each Period:** Apply the formula $\text{PV}_t = \text{Payment}_t / (1 + r)^t$. 4. **Sum Present Values:** The sum equals the initial lease liability recognized on day one of the lease.