Lease Liability Calculation: Formula & ASC 842 Example

A lease liability calculation determines the present value of the future lease payments a lessee is required to make over the lease term. Under ASC 842, both operating and finance leases generally require a lease liability and corresponding right-of-use (ROU) asset to be recorded on the balance sheet.

The calculation depends primarily on the lease payment schedule, lease term, payment timing, and applicable discount rate.

What is the lease liability calculation formula?

At lease commencement, the lease liability is calculated as the present value of the remaining lease payments.

The basic lease liability calculation can be expressed as:

Lease Liability = Present Value of Future Lease Payments

When payments are equal and made at the end of each period, the present value of an ordinary annuity can be expressed as:

PV = Payment × [1 − (1 + r)^-n] ÷ r

Where:

• PV = Present value of the lease payments
• Payment = Periodic lease payment
• r = Discount rate per period
• n = Number of payment periods

Under ASC 842, the interest rate implicit in the lease should generally be used when it is readily determinable. If it is not, the lessee typically uses its incremental borrowing rate.

Private companies may also be able to use a risk-free rate practical expedient in certain circumstances.

What is a lease liability calculation example under ASC 842?

Consider a company entering into a five-year office lease with the following terms:

• Annual lease payment: $50,000
• Lease term: 5 years
• Payments: End of each year
• Discount rate: 5%

The company calculates the present value of the five annual payments using the lease liability formula:

Lease Liability = $50,000 × [1 − (1 + 0.05)^-5] ÷ 0.05

The initial lease liability is approximately:

$216,474

This means that although the company will make $250,000 in total undiscounted payments over the five-year lease term, the amount initially recognized as the lease liability is approximately $216,474 because future payments are discounted to their present value.

For a basic lease without prepaid rent, initial direct costs, or lease incentives, the initial ROU asset may be equal to the initial lease liability.

Once the liability is established, the balance is adjusted each period as interest accrues and lease payments are made.

How can you calculate lease liability in Excel?

Excel can be used to calculate the present value of lease payments and build the related amortization schedule.

Finance teams can use the PV function when payments remain consistent throughout the lease term. For the example above, the calculation would use:

=PV(5%,5,-50000,0,0)

This produces a present value of approximately $216,474.

The timing input is important. A payment made at the beginning of a period is discounted differently from a payment made at the end of the period, which can materially affect the initial lease liability.

Download the Lease Liability Excel Template

Use Occupier’s present value calculator to calculate the present value of future lease payments in Excel using the lease term, payment amount, discount rate, and payment timing.

You can also use Occupier’s lease amortization schedule to track the lease liability and ROU asset throughout the lease term.

What payments are included in a lease liability calculation under ASC 842?

The lease liability generally includes fixed payments and other payments that the lessee is reasonably expected to make during the lease term.

Depending on the lease agreement, this may include:

• Fixed lease payments
• In-substance fixed payments
• Certain variable payments tied to an index or rate
• Amounts expected to be paid under residual value guarantees
• Purchase option payments when exercise is reasonably certain
• Certain termination penalties when the lease term assumes the termination option will be exercised

Payments that depend entirely on future usage or performance are generally not included in the initial lease liability calculation.

Correctly identifying the payment stream is important because the amount included directly determines the liability recognized on the balance sheet.

How does a lease liability affect the balance sheet under ASC 842?

After years of delays, ASC 842 is now in effect for companies in the United States. One of its most significant changes is that most leases must now be reported as assets and liabilities on the balance sheet.

Many businesses have also gone through their first audit under the new leasing standard, making the impact of lease liabilities on the balance sheet much clearer.

Under ASC 842 and IFRS 16, lease liabilities are recognized because prior standards allowed many operating leases to remain outside the balance sheet and appear primarily in financial statement footnotes.

Under the previous standard, ASC 840, operating leases were generally reported through disclosures rather than being recognized as lease liabilities on the balance sheet.

ASC 842 changed this approach by requiring companies to recognize a right-of-use asset and corresponding lease liability for most leases.

What is a right-of-use asset and how is it calculated?

A right-of-use asset represents the lessee's right to occupy or use a leased asset during the lease term.

The ROU asset generally begins with the initial lease liability and is then adjusted for items such as prepaid lease payments, initial direct costs, and lease incentives.

The basic calculation can be expressed as:

ROU Asset = Initial Lease Liability + Initial Direct Costs + Prepaid Lease Payments − Lease Incentives

For example, if your company leases a dump truck, the asset represented on the balance sheet is the right to use that truck rather than ownership of the truck itself.

For basic leases without these additional adjustments, the initial lease liability and ROU asset may be the same amount.

The recognition of these amounts is one of the most significant changes introduced by ASC 842.

How does the ASC 842 balance sheet compare to the ASC 840 balance sheet?

Under ASC 840, operating leases were generally reflected through financial statement disclosures and rent expense rather than through a recognized operating lease liability and ROU asset.

ASC 842 brings these amounts onto the balance sheet.

Reports must also include several qualitative and quantitative disclosures. These can include:

• Weighted average discount rate
• Weighted average remaining lease term
• Cash paid for lease liabilities
• Lease maturity information

All of this information must be supported by the amounts recorded in the underlying lease schedules.

What happens to the lease liability after initial recognition?

The initial lease liability calculation establishes the opening balance. After that, the liability changes during each accounting period.

In general, the liability:

1. Increases as interest or liability accretion is recognized.
2. Decreases when lease payments are made.

For example, assume the opening liability is $216,474 and the annual discount rate is 5%.

The first year's interest would be approximately:

$216,474 × 5% = $10,824

After a $50,000 lease payment, the approximate ending liability would be:

$216,474 + $10,824 − $50,000 = $177,298

The same process continues throughout the lease term until the liability reaches zero.

This roll-forward is normally captured through a lease amortization schedule.

What journal entries are required under ASC 842?

Under ASC 842, lease accounting entries reflect lease payments, changes in the lease liability, and changes in the ROU asset.

The exact journal-entry presentation depends on whether the lease is classified as an operating or finance lease.

For lease liability purposes, each payment reduces the outstanding obligation after accounting for the applicable interest or accretion for the period.

The ROU asset is also reduced throughout the lease term based on the appropriate accounting treatment for the lease classification.

The lease expense for an operating lease is generally recognized on a straight-line basis over the lease term.

How do you determine the discount rate for calculating lease liability present value?

The discount rate can have a significant effect on the lease liability calculation.

ASC 842 requires the rate implicit in the lease to be used when that rate is readily determinable.

In many commercial lease arrangements, however, the information necessary to determine the implicit rate is not available to the lessee. In those situations, the lessee generally uses its incremental borrowing rate.

The incremental borrowing rate represents the rate the lessee would have to pay to borrow funds on a collateralized basis over a similar term and in a similar economic environment.

For private companies, ASC 842 also provides a practical expedient that may allow the use of a risk-free rate.

A lower discount rate generally creates a higher present value of the future lease payments and therefore a larger initial lease liability. A higher rate generally produces a lower present value.

Because of this, the method used to determine the discount rate can materially affect the amounts reported on the balance sheet.

How does ROU asset impairment affect the balance sheet and financial reporting?

When an ROU asset becomes impaired, its carrying value may need to be reduced, which can affect net income and future financial statement presentation.

Since ASC 842 introduced ROU assets for operating leases, companies must include these assets when evaluating long-lived assets for impairment where applicable.

If a business experiences a significant change in circumstances, certain assets may require further impairment analysis.

A period involving material impairments can create volatility across comparative financial statements because the carrying amount of the asset has changed.

How do lease liabilities under ASC 842 affect EBITDA and financial ratios?

Adding lease liabilities and ROU assets to the balance sheet can affect a number of financial ratios.

For example, an operating lease may produce a long-term ROU asset while the corresponding lease liability is divided between current and non-current portions.

Compared with prior accounting standards, this increases reported assets as well as current and long-term liabilities.

The result can affect measurements such as the current ratio, debt-to-equity ratio, and other leverage calculations.

Lease classification can also affect how lease-related expenses flow through the income statement and therefore how stakeholders evaluate metrics such as EBITDA.

Understanding the lease liability calculation is therefore important not only for ASC 842 compliance but also for understanding the broader financial impact of a company's lease portfolio.

What should finance teams know about lease liability calculations under ASC 842?

An accurate lease liability calculation starts with three things: the correct payment stream, the correct lease term, and an appropriate discount rate.

Once those inputs are established, the future lease payments are discounted to determine the initial liability.

From there, the liability is rolled forward as interest accrues and payments are made.

For companies with a small number of straightforward leases, these calculations may be manageable in Excel. As lease portfolios grow, however, modifications, reassessments, payment escalations, and multiple discount rates can make manual lease schedules difficult to maintain.

The time and effort required to manage these calculations can also create added pressure during month-end close and audit preparation.

How does lease accounting software help manage lease liabilities correctly?

Purpose-built lease accounting software can automate the calculations behind ROU assets, lease liabilities, amortization schedules, journal entries, and reporting.

Occupier calculates lease liability amortization, ROU asset activity, and related accounting entries based on lease terms and the organization's accounting calendar.

This helps real estate and finance teams reduce dependence on manually maintained spreadsheets while maintaining the schedules and supporting documentation needed for ASC 842 reporting.

If you're ready to see how Occupier can streamline the lease accounting lifecycle, schedule a demo.

Frequently Asked Questions

What is a lease liability under ASC 842?

A lease liability is the present value of the future lease payments a lessee is required to make over the lease term. It is recorded on the balance sheet along with a corresponding right-of-use asset.

How do you calculate a lease liability?

Identify the qualifying future lease payments and discount them to present value using the applicable discount rate. The resulting amount becomes the initial lease liability recorded at commencement.

What discount rate is used for a lease liability calculation?

ASC 842 generally requires the interest rate implicit in the lease when it can be readily determined. If it cannot, the lessee typically uses its incremental borrowing rate. Certain private companies may elect to use a risk-free rate practical expedient.

Can you calculate lease liability in Excel?

Yes. Excel's PV function can calculate the present value of a fixed series of lease payments. Finance teams can also use a lease amortization schedule to track interest, payments, and the remaining balance throughout the lease term.

Are operating and finance lease liabilities calculated differently under ASC 842?

The initial lease liability for operating and finance leases is generally calculated using the same present value approach. The main differences arise in subsequent accounting and expense recognition.

Why does the lease liability decrease over time?

The liability decreases as lease payments are made. Each period, the balance is increased by interest or accretion and then reduced by the payment made during that period.

Does a lower discount rate increase the lease liability?

Yes. A lower discount rate generally increases the present value of future lease payments, which results in a higher initial lease liability. A higher discount rate generally produces a lower present value.

‍