This is the one thing you must be able to do under the new lease accounting rules:
The new lease accounting rules require the vast majority of leases to be capitalized. The capitalized amount is calculated as the present value of the lease payments. It goes without saying; therefore, that to comply with the new lease standard, you will need to know how to calculate the present value of lease payments. This is especially true if you do not plan on using any software and would prefer to use Excel spreadsheets to manage your leases.
However, if you prefer Excel, we can at least help you use it correctly. Here are your 2 simple options:
- Calculate the present value of lease payments only, using Excel
- Calculate the present value of lease payments AND amortization schedule using Excel.
This post will address how to calculate the present value of the lease payments using Excel. We also build an Excel template that performs this calculation for you automatically.
Read our follow-up blog that will show you how to calculate the present value of lease payments AND get the liability amortization schedule in ONE STEP, using Excel. With this method, you will have everything you need to comply with the new lease accounting rules powered only by an Excel spreadsheet. You’re welcome.
Now on to today’s blog.
Here are the steps to follow to calculate the present value of lease payments using Excel when the payment amounts are different. Let’s use an example:
Calculate the present value of lease payments for a 10-year lease with annual payments of $1,000 with 5% escalations annually, paid in advance. Assume the rate inherent in the lease is 6%.
Step 1) In an Excel spreadsheet, title three columns with the following headers: Period, Cash and Present Value, as shown below:
Step 2) Enter the number periods starting from 0 to 9. Note that if payments were made in arrears, the numbering would start from 1 to 9. See below for the step 2 illustration:
As always, we write detailed blogs like this to demonstrate that our experts at LeaseQuery are not just real estate professionals, but also lease accounting experts. If you need to comply with the new lease accounting standards, you’ll find LeaseQuery offers the premium solution.
Trust us, there’s a difference. We understand the challenges faced not just by real estate and equipment leasing professionals, but also the accounting departments supporting both groups. Our lease management software reflects our expertise.
- Here is a free tool you can use to determine if your lease is a Capital or Operating Lease. It goes through the 4 tests for capital leases.
- If you liked this post, consider watching our video on Accounting for Tenant Improvement Allowances.
- Visit our LinkedIn page – for regular updates on our blog to help you comply with the upcoming lease accounting changes.
Talk to One of Our Expert Lease Accountants Today.
Unlike other software vendors, we aren’t former real estate professionals trying to learn accounting on your dime. We’re accountants just like you.
Sign up for a demo today and let us prove it.
Request A Demo