Share this
Automatic Discount Rate Matching for Lease Accounting
by Matt Waters, CPA on May 13, 2021
There’s no need to manually enter a discount rate for new or modified leases with lease accounting software from CoStar. Just upload your company’s discount rate tables, and the software automatically identifies which rate to use for each lease.
If you don’t upload your table of discount rates, you’ll end up wasting hours of time looking up and entering rates for each new or modified lease. And you’ll be prevented from using other automations in the software that are contingent upon discount rate matching.
The Need for the Discount Rate
A discount rate is needed each time you create an amortization schedule for a lease or remeasure the ROU asset and lease liability. As you create amortization schedules for new leases and remeasure your current ones, CoStar Lease Accounting will automatically match each lease to the appropriate discount rate. This enables a consistent method for matching leases to correct discount rates, reducing the risk of human error.
The Need for Remeasurement
You need to remeasure the lease upon one of the following events:
- Reducing or increasing lease terms or payments
- Exercising the option to purchase a leased property or to renew a lease
- Terminating or partially terminating a lease
- Adding or reducing space you’re leasing
- Subleasing an asset for a period beyond the end of the current lease term
- Significantly modifying an asset
- Assessing that you are reasonably certain to exercise a lease option
- Impairing a property (However, this does not require a new discount rate.)
Automating the Discount Rate
You probably already periodically obtain from your treasury department an updated list of borrowing rates, which are used as your discount rates. Rather than having your staff manually look up the rate for each new or modified lease, all you need to do is periodically upload your most recent discount rate tables to CoStar Real Estate Manager. Your company should create a policy that states the frequency discount rates are to be updated. Each country should have its own discount rate tables: one for properties and one for equipment. Tables should include the country, currency, lease terms, and discount rate. (See Figure A)
All you need to do is create tables like the ones below and use the Extract, Transform, and Load (ETL) tool to upload the discount rates to CoStar’s Lease Accounting software. It will then automatically assign the correct discount rate to each lease based on the criteria in the tables.
Figure A
Real Estate | Location | Currency | Min time | Max time | Discount Rate |
U.S. | $ | 1 day | < 1 year | 4% | |
U.S. | $ | 1 year | < 3 years | 3.5% | |
U.S. | $ | 3 years | <5 years | 3% | |
U.S. | $ | 5 years | >5 years | 2.9% |
Equipment | Location | Currency | Min time | Max time | Discount Rate |
UK | GBP | 1 day | < 1 year | 6% | |
UK | GBP | 1 year | < 3 years | 4.5% | |
UK | GBP | 3 years | <5 years | 4% | |
UK | GBP | 5 years | >5 years | 3% |
*More Automations Coming Soon
To partake in future automations, you’ll need to have in place automated discount rate matching. In Q3, we expect to roll out batch accounting, which will allow you to perform remeasurements in bulk with just a few clicks. When you go to your accounting dashboard and click Batch Accounting, you’ll be presented with a list of all the modified leases that your lease administrative team has input into the system. At the top of the list, you’ll click Select All to add them to your batch of leases to be remeasured in one swoop. Then, you’ll confirm the default parameters you’ve defined for the portfolio’s Measure Events and Classifications. Then click the Queue for Validation and Processing button. The application will perform a data validation for quality control. Records that pass validation will automatically be remeasured. You’ll be presented with a list of records that fail validation along with a reason, such as “missing data.” Once you correct the validation issues, click Batch Accounting and repeat the above instructions.
Every year, about 20 percent of a company’s leases are up for renewal and about 10 percent are modified for other events like terminations or partial terminations. All these events require remeasurement and the application of a new discount rate. In one year, a company with 1,000 leases might need the discount rate 300 times — 200 times for renewals and 100 times for other remeasurement events. And that doesn’t even account for new leases, which all also need a discount rate.
Make your work routine a lot easier by importing discount rate tables into transaction management software from CoStar.
Share this
- ASC 842 (81)
- Lease Accounting Software (74)
- Accounting Teams (39)
- Lease Administration Software (25)
- Retail Tenants (15)
- Commercial Real Estate (12)
- Lease Management (11)
- Market Data and Analytics (7)
- Real Estate Teams (7)
- ESG (5)
- Success Stories (5)
- News and Media Coverage (4)
- Transaction Management Software (2)
- Customer Success (1)
- Office Tenants (1)
- November 2024 (2)
- October 2024 (4)
- September 2024 (2)
- August 2024 (5)
- July 2024 (3)
- June 2024 (3)
- May 2024 (4)
- April 2024 (1)
- February 2024 (1)
- December 2023 (4)
- November 2023 (6)
- October 2023 (4)
- September 2023 (2)
- August 2023 (2)
- July 2023 (3)
- May 2023 (2)
- March 2023 (1)
- February 2023 (3)
- January 2023 (1)
- December 2022 (3)
- November 2022 (4)
- October 2022 (4)
- September 2022 (1)
- August 2022 (4)
- June 2022 (1)
- May 2022 (4)
- April 2022 (8)
- March 2022 (3)
- February 2022 (1)
- January 2022 (2)
- November 2021 (2)
- October 2021 (2)
- September 2021 (3)
- August 2021 (15)
- July 2021 (3)
- June 2021 (1)
- May 2021 (1)
- April 2021 (3)
- March 2021 (1)
- January 2021 (1)
- December 2020 (3)
- November 2020 (1)
- October 2020 (2)
- September 2020 (2)
- August 2020 (3)
- July 2020 (2)
- June 2020 (3)
- May 2020 (1)
- April 2020 (1)
- March 2020 (1)
- February 2020 (1)
- December 2019 (1)
- October 2019 (1)
- September 2019 (2)
- August 2019 (3)
- July 2019 (2)
- April 2019 (69)
- October 2018 (1)
- August 2018 (1)
- July 2018 (1)
- June 2018 (1)
- May 2018 (1)
- April 2018 (2)
- March 2018 (3)
- February 2018 (2)
- December 2017 (1)
- August 2017 (3)
- June 2017 (2)
- May 2017 (2)
- April 2017 (1)
- March 2017 (2)
- January 2017 (2)
- November 2016 (2)
- July 2016 (1)
- June 2016 (1)
- July 2015 (1)
- March 2015 (1)
- June 2014 (1)
- April 2014 (11)
- October 2011 (1)
You May Also Like
These Related Stories