Your browser does not support JavaScript!

Leasing

Lessee

Basic lease, implicit rate

1/1/X1, XYZ leased a production machine for five years. Annual payments (in arrears) were 2,927 and XYZ retained the asset. Prices of comparable machines were readily available. On this basis, XYZ determined the machine's fair value was 12,000 and rate implicit in the lease was 7%. XYZ intended to use the machine 6 years, then sell it for 1,200. It actually sold it for 1,250 on 3/31/X7.

Put simply, the rate implicit in the lease is the rate that will cause the present value of the lease payments to equal the asset's fair value.

IFRS 16.Appendix A: [The] interest rate implicit in the lease [is] the rate of interest that causes the present value of (a) the lease payments and (b) the unguaranteed residual value to equal the sum of (i) the fair value of the underlying asset and (ii) any initial direct costs of the lessor.

ASC 842-20-20: The rate of interest that, at a given date, causes the aggregate present value of (a) the lease payments and (b) the amount that a lessor expects to derive from the underlying asset following the end of the lease term to equal the sum of (1) the fair value of the underlying asset minus any related investment tax credit retained and expected to be realized by the lessor and (2) any deferred initial direct costs of the lessor.

A rate implicit in the lease can thus be (readily) determined if, and only if, the asset's fair value can be (readily) determined.

The simplest way to calculate an implicit rate is using Excel's =rate function:

7.0039771424884% =RATE(5,-2927,12000,0,0,10%).

The syntax for the function is =RATE(number of periods, -payment, present value, future value, type of payment (0 beginning of period, 1 arrears), initial guess.

A collection of other useful Excel formulas and functions can also be downloaded on our formula page.

Dr/Cr

1/1/X1 | 1.1.X1

 

 

Production machine (right-of-use asset)

12,000

 

 

Lease liability

 

12,000


Current common practice is to recognize leased tangible assets as PP&E. This practice is expected to continue under IFRS 16 | ASC 842 even though right-of-use assets are, technically speaking, intangible assets.

IFRS 15 Appendix A | ASC 842-20-20 define a right-of-use asset as "An asset that represents a lessee's right to use an underlying asset for the lease term".

12/31/X1 | 31.12.X1

 

 

Interest expense (leasing)

840

 

Lease liability

2,087

 

 

Cash

 

2,927

Depreciation expense (right-of-use asset)

1,800

 

 

Accumulated depreciation (right-of-use asset)

 

1,800



P

Liability

Discount rate

Interest expense

Payment

Liability amortization

A

B (B+1) = B - F

C

D = B x C

E

F = E - D

1

12,000

7.00%

840

2,927

2,087

2

9,913

7.00%

694

2,927

2,233

3

7,681

7.00%

538

2,927

2,389

4

5,292

7.00%

370

2,927

2,556

5

2,735

7.00%

191

2,927

2,735

 

 

 

 

 

12,000

 

 

 

 

 

 


31/3/X7 | 3.31.X7

 

 

Accumulated depreciation (right-of-use asset)

10,800

 

Cash

1,250

 

 

Production machine (right-of-use asset)

 

12,000

 

Asset disposal gain

 

50


Upfront payments

Same facts except payments of 2,735 were paid up front.

1/1/X1 | 1.1.X1

 

 

Production machine

12,000

 

 

Cash

2,735

 

 

Lease liability

 

9,265


12/31/X1 | 31.12.X1

 

 

Interest expense

649

 

Lease liability

2,087

 

Depreciation expense

1,800

 

 

Accrued lease payment

 

2,735

 

Accumulated depreciation

 

1,800


P

Liability

Discount rate

Interest expense

Payment

Liability amortization

A

B (B+1) = B - F

C

D = B x C

E

F = E - D

0

12,000

7.00%

0

2,735

2,735

1

9,265

7.00%

649

2,735

2,087

2

7,178

7.00%

502

2,735

2,233

3

4,945

7.00%

346

2,735

2,389

4

2,556

7.00%

179

2,735

2,556

 

 

 

 

 

12,000

 

 

 

 

 

 


7.00%=RATE(5,-2735,12000,0,1,10%)

A collection of other useful Excel formulas and functions can be downloaded on our formula page.

Principal and interest can also be recognized separately:

 

Accrued lease payment: Principal

 

2,087

 

Accrued lease payment: Interest

 

649


1/1/X2 | 1.1.X2

 

 

Accrued lease payment

2,735

 

 

Cash

 

2,735


Interim entries

Same facts except XYZ made quarterly accruing entries.

3/31/X1 | 31.3.X1

 

 

Interest expense

162

 

Lease liability

522

 

Depreciation expense

450

 

 

Accrued lease payment

 

684

 

Accumulated depreciation

 

450


Text only

To view the remainder of this page, please or register for basic view or get professional view.

Log in - Basic view - Professional view

Basic view is free and allows up to 3 page views per month.
Professional view has no page limit and allows downloads of all files.