Run finance and operating lessee schedules without blending them

Problem

Cedar Trail has supplied classification and rate memoranda for two leases. The controller wants a commencement entry, five-year rollforward, first-year entries, current-liability support, and a separate remeasurement workpaper. The job is arithmetic control under those supplied judgments, not a second classification opinion.

If the recomputation exposes a fact inconsistent with the supplied classification memo, record the exception and return it to the classification owner. Do not silently change the memo or force its schedule to pass.

First measure the unpaid payment streams

For the finance equipment lease:

PV = $25,000 × ordinary-annuity factor(8%, 5)
   = $99,817.75092695221

There are no commencement payments, incentives, or qualifying direct costs, so the initial ROU asset equals the liability: $99,817.75092695221.

For the operating warehouse lease:

liability = $40,000 × ordinary-annuity factor(6%, 5)
          = $168,494.5514226287

ROU asset = $168,494.5514226287 + $3,000 − $5,000
          = $166,494.5514226287

The $2,000 difference preserves the qualifying direct cost and incentive in the ROU asset bridge.

One liability mechanism

In each row, liability principal reduction is cash less interest. The displayed final rows show both liabilities settling at the fifth payment without a rounded plug; the linked lab and workbook expose all intervening periods.

The $5,000 incentive exceeds the $3,000 direct costs by $2,000. Spreading that net benefit over five years lowers level annual cost $400 below cash. The operating lease's $29,890.33 principal reduction and $29,490.33 ROU reduction are therefore both intentional:

liability principal = $40,000 cash − $10,109.67 interest = $29,890.33
ROU reduction       = $39,600 lease cost − $10,109.67 interest = $29,490.33

The two near-matching reductions are not interchangeable. Across operating leases, liability principal remains cash minus liability interest, while ROU reduction is period lease cost minus that interest. The amounts coincide only when period lease cost equals cash under the supplied facts; their labels identify different rollforwards. A finance lease also carries a separate ROU amortization schedule; the liability table does not display that asset rail.

Two ROU and expense patterns

The finance ROU asset amortizes at $19,963.550185390442 per year. Year 1 total lease cost is $7,985.420074156177 interest plus $19,963.550185390442 amortization, or $27,948.97025954662.

The operating lease's total cost is:

($40,000 × 5 + $3,000 − $5,000) ÷ 5 = $39,600 per year

Year 1 ROU reduction is $39,600 single cost minus $10,109.673085357721 liability interest, or $29,490.32691464228. The preceding liability-versus-ROU bridge shows the reason this differs from principal.

Entries at the first year-end

For the finance lease, debit interest expense $7,985.42, debit lease liability $17,014.58, and credit cash $25,000; separately debit ROU amortization expense and credit accumulated ROU amortization $19,963.55.

For the operating lease, first record the $40,000 payment by debiting the lease liability and crediting cash. Then debit lease cost $39,600, credit lease liability $10,109.67 for interest accretion, and credit the ROU asset $29,490.33. Across the two entries, the liability falls by $29,890.33. An equivalent compound entry debits lease cost $39,600 and lease liability $29,890.33, then credits cash $40,000 and the ROU asset $29,490.33. The schedule, not a memorized entry shape, controls the amounts.

Remeasure only from the change date

The supplied non-separate extension begins with a $120,000 liability. Four $36,000 year-end payments discounted at the revised 7-percent rate produce $121,939.60523270137. With no scope reduction, the liability increases by $1,939.605232701375 and the corresponding ROU adjustment follows the supplied modification conclusion. Historical rows remain untouched.

Reconciliation and interpretation

Both liability schedules settle. Both ROU schedules reduce to zero under the stated assumptions. Finance cost falls as interest declines; operating single cost remains $39,600. Those arithmetic results do not establish lease scope, classification, rate, direct-cost eligibility, impairment, modification status, or disclosure completeness.

{
  "finance_equipment": {
    "amortization_periods": 5,
    "annual_discount_rate": 0.08,
    "classification": "finance",
    "initial_direct_costs": 0,
    "lease_incentives": 0,
    "payment_amount": 25000,
    "payment_timing": "arrears",
    "payments_per_year": 1,
    "total_periods": 5
  },
  "operating_warehouse": {
    "amortization_periods": 5,
    "annual_discount_rate": 0.06,
    "classification": "operating",
    "initial_direct_costs": 3000,
    "lease_incentives": 5000,
    "payment_amount": 40000,
    "payment_timing": "arrears",
    "payments_per_year": 1,
    "total_periods": 5
  }
}

{
  "warehouse_extension": {
    "opening_lease_liability": 120000,
    "payments_per_year": 1,
    "remaining_periods": 4,
    "revised_annual_discount_rate": 0.07,
    "revised_payment_amount": 36000,
    "scope_reduction_fraction": 0
  }
}