ROU Amortization Table: Lease Liability Schedule

An ROU amortization table shows how a lease’s liability and right-of-use (ROU) asset change over time. Enter the lease liability, annual discount rate, and term to estimate a monthly liability schedule, total interest, and straight-line ROU asset amortization; this calculator models a simplified lease, not every accounting adjustment.

Formula

This schedule uses a level-payment loan-style calculation to illustrate the lease liability. It is not a complete lease-accounting measurement. Let P be the initial lease liability in dollars, a the annual discount rate in percent, r = a / 1200 the monthly rate as a decimal, and n = 12 × years the number of monthly periods.

• Illustrative monthly payment: M = round[P × r / (1 − (1 + r)⁻ⁿ), 2].
• Estimated total interest: I = M × n − P, using the rounded monthly payment.
• Monthly ROU asset amortization in this simplified example: A = P / n.

The first result is total interest because the requested subject is an amortization table: it is followed by the payment and asset-amortization figures needed to construct a basic schedule. Calculations use monthly periods and round the illustrative payment to cents. Actual lease accounting can use different payment timing, payment amounts, discount-rate conventions, and asset adjustments.

Worked Example

Using the calculator’s defaults—an initial liability of $20,000, an 8% annual rate, and a five-year term—there are 60 monthly periods. The monthly rate is 8 ÷ 1,200 = 0.0066667.

1. Monthly payment: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] = $405.53 after rounding.
2. Total of rounded payments: $405.53 × 60 = $24,331.80.
3. Estimated total interest: $24,331.80 − $20,000 = $4,331.80.
4. Straight-line ROU asset amortization: $20,000 ÷ 60 = $333.33 per month, rounded to cents.

For a simplified first-month illustration, interest is $20,000 × 0.0066667 = $133.33. Subtracting that from the $405.53 payment gives about $272.20 of liability reduction, leaving an estimated liability of $19,727.80. The asset’s $333.33 amortization is a separate calculation; it is not the same as the liability reduction.

How to Read an ROU Amortization Table

A detailed schedule usually has one row for each payment period. It tracks the opening lease liability, interest accretion, cash payment, liability reduction, and closing liability. A separate asset column tracks the ROU asset’s opening amount, amortization or other adjustment, and closing amount. A basic fixed-payment illustration can use this sequence:

• Calculate period interest as opening liability × periodic discount rate.
• Subtract the period’s cash payment from opening liability plus interest to find the closing liability.
• Calculate ROU asset amortization separately according to the lease’s accounting pattern and applicable guidance.

In the example, the liability declines by roughly $272.20 in the first month, while the ROU asset declines by roughly $333.33. The figures differ because liability interest is recognized in the liability roll-forward, while asset amortization follows a separate measurement. Rounding each period can also make a final schedule row differ by a few cents; a real schedule may adjust its last row to reach the required ending balance.

What the Table Represents

ROU means “right of use”: the lessee’s accounting asset representing the right to use an underlying item during a lease term. The lease liability represents the obligation to make lease payments. At commencement, a lease model generally measures these items using lease-specific inputs and applicable accounting rules. The liability then changes as interest accrues and payments are made; the ROU asset is reduced or otherwise adjusted over the lease term.

These are related but distinct balances. A common misconception is that the ROU asset must equal the lease liability throughout the term. They may begin at related amounts, but their subsequent balances can differ because interest, amortization, initial direct costs, prepayments, incentives, impairment, and other adjustments may affect them differently. Exact treatment depends on the applicable accounting framework and the contract.

Inputs, Uses, and Limitations

Use this estimate to understand the mechanics of a level-payment schedule or to make a rough comparison with a separately prepared lease schedule. Enter a starting liability, annual discount rate, and term in years. The rate is an assumption, not a current-rate estimate; use the figure relevant to the lease from the appropriate source or accounting workpaper. The calculator does not determine that rate.

The model assumes the entire initial liability is repaid by equal end-of-month payments over the entered term, with monthly compounding at the annual rate divided by 12. Real lease cash flows may be due at the beginning of a period, occur quarterly or annually, vary over time, include a residual-value guarantee or purchase option, or have rent-free periods. Those differences change the schedule.

It also treats the starting liability as the amount to amortize straight-line for the illustrative asset figure. That is a simplifying assumption, not a conclusion about the recorded ROU asset. The actual asset’s initial carrying amount and later expense pattern may require adjustments. The calculator does not model taxes, insurance, fees, incentives, prepayments, variable payments, foreign exchange, impairment, modifications, or renewal and termination options.

Common Errors and Checks

• Confusing asset and liability: They require separate roll-forwards; do not use liability reduction as ROU amortization.
• Mixing rate units: An annual percentage such as 8 is converted to a monthly decimal by dividing by 1,200, not by 12 alone.
• Assuming every lease has equal payments: This calculator does; contractual cash flows may not.
• Ignoring timing: A payment at the start of a month reduces the liability differently from an end-of-month payment.
• Rounding too early: Cent rounding can accumulate across many periods. For a formal schedule, retain adequate precision internally and apply the required accounting presentation and rounding conventions.

To check a full schedule, confirm that every period’s closing liability becomes the next period’s opening liability, payments and interest reconcile to the liability movement, and the final balance follows the contract and measurement assumptions. A negative ending liability or a large unexplained final adjustment can signal inconsistent dates, payment amounts, or rounding.

Assumptions

• The discount rate is fixed throughout the term.
• Payments are equal, monthly, and made at the end of each period.
• Interest compounds monthly at the entered annual rate divided by 12.
• The illustration excludes fees, taxes, insurance, incentives, prepayments, variable payments, and other lease-specific adjustments.

Frequently Asked Questions

What is an ROU amortization table?
A period-by-period schedule showing changes in a right-of-use asset and the related lease liability. The two balances are connected but are not interchangeable.

How do you calculate ROU asset amortization?
In this simplified example, divide the starting asset amount by the number of monthly periods for straight-line amortization. Actual asset measurement and expense treatment may require other adjustments.

Is ROU amortization the same as lease liability amortization?
No. The asset schedule tracks the ROU asset, while the liability schedule tracks the payment obligation and interest. Their balances and period-to-period changes can differ.

Why does an ROU asset not equal the lease liability?
They can differ because of interest accretion, asset amortization, and lease-specific items such as prepayments or incentives. The contract and applicable accounting framework determine the full treatment.

Can this calculator create a formal accounting schedule?
No. It provides a level-payment estimate. A complete schedule needs lease dates, actual payment timing and amounts, the applicable discount rate, and any relevant adjustments.

This result is an estimate for educational purposes; the lender’s disclosure gives the exact figures.

Related

• HELOC Amortization Table: Estimate Payments and Balance
• Amortization Table Calculator and Payment Schedule
• Amortization Table by Month Calculator

in p | Initial lease liability | $ | 20000 | 1 | 100000000
in apr | Annual discount rate | % | 8 | 0.01 | 100
in yrs | Lease term | years | 5 | 0.0833 | 50
out int | Total interest over term | $ | round((p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) * yrs * 12, 2) - p | 2
out pmt | Illustrative monthly liability payment | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out amort | Monthly ROU asset amortization | $ | p / (yrs * 12) | 2