Wednesday, 27 July 2016

A lease agreement between Hebert Corporation and Russell Corporation

A lease agreement between Hebert Corporation and Russell Corporation is described in E20-17.
In E The following facts are for a non-cancellable lease agreement between Hebert Corporation and Russell Corporation, a lessee:
Inception date   July                                 1, 2011
Annual lease payment due at the
beginning of each year, starting July 1, 2011           $20,066.26
Bargain purchase option price at end of lease term            $ 4,500.00
Lease term                                        5 years
Economic life of leased equipment                        10 years
Lessor’s cost                                   $60,000.00
Fair value of asset at July 1, 2011                     $88,000.00
Lessor’s implicit rate                                           9%
Lessee’s incremental borrowing rate                                 9%

Instructions
Provide the following for Hebert Corporation, the lessor, rounding all numbers to the nearest cent.
(a) Calculate the amount of gross investment at the inception of the lease.
(b) Calculate the amount of net investment at the inception of the lease.
(c) Prepare a lease amortization schedule using a computer spreadsheet for Hebert Corporation for the five-year lease term.
(d) Prepare the journal entries to reflect the signing of the lease and to record the receipts and income related to this lease for the years 2011, 2012, and 2013. The lessor’s accounting period ends on December 31, and Hebert Corporation does not use reversing entries.


The lease agreement has a bargain purchase option. The collectability of the lease payments is reasonably predictable, and there are no important uncertainties surrounding the costs yet to be incurred by the lessor. The lease also qualifies as a capital lease from the viewpoint of the lessee.

Due to the fact that the initial amount of net investment (which in this case equals the present value of the minimum lease payments, $88,000) exceeds the lessor’s cost ($60,000), the lease is a sales-type lease.
(a) Gross investment = Minimum lease payments + any unguaranteed residual value.

    The minimum lease payments associated with this lease are the periodic annual rents plus the bargain purchase option. There is no residual value relevant to the lessor’s accounting in this lease.

    Calculation:                5 X $20,066.26 =$100,331.30
                                       + 4,500.00
    Gross investment at inception    $104,831.30  
(b) The net investment equals the present value of the components of the gross investment calculation.
    Net investment calculation:
        $20,066.26   Annual rental payment
        X 4.23972    PV of annuity due of 1 for n = 5, i = 9%
        $85,075.32   PV of periodic rental payments

        $4,500.00   Bargain purchase option
        X  .64993    PV of 1 for n = 5, i = 9%
        $2,924.69   PV of bargain purchase option

        $85,075.32      PV of periodic rental payments
        + 2,924.69    PV of bargain purchase option
        $88,000.01      Net investment at inception

Excel formula =PV(rate,nper,pmt,fv,type)

Using a financial calculator:

PV
 $     ?  
Yields $88,000
I
9%

N
                     5

PMT
 $ 20,066.26

FV
 $  4,500

Type
                     1


(c)
Herbert Leasing Corporation (Lessor)
               Lease Amortization Schedule
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         




Date

Annual
Lease
Payment
Plus BPO


Interest (9%)
on Net
Investment


Net Investment
Recovery


Balance
Net
Investment









7/1/11
7/1/11
7/1/12
7/1/13
7/1/14
7/1/15
6/30/16


$20,066.26
  20,066.26
  20,066.26
  20,066.26
  20,066.26
   4,500.00
$104,831.30



*$6,114.04*
*  4,858.34*
*  3,489.62*
*  1,997.73*
* 371.58*
*$16,831.30*


$20,066.26
13,952.22
15,207.92
16,576.64
18,068.53
  4,128.42
$88,000.00

$88,000.00
67,933.74
53,981.52
38,773.59
22,196.96
  4,128.42
      0.00
*Rounding error is $.02 cents.
(d)
7/1/11  Lease Payments
          Receivable................. 104,831.30
        Cost of Goods Sold........... 60,000.00
             Sales...................           88,000.00
             Unearned Interest
               Income—Leases..........           16,831.30
             Inventory...............           60,000.00

7/1/11  Cash ........................ 20,066.26
             Lease Payments
               Receivable.............           20,066.26

12/31/11 Unearned Interest Income—
          Leases.....................   3,057.02
             Interest Income—
               Leases.................           3,057.02
               ($6,114.04 X 6/12 = $3,057.02)

7/1/12  Cash ........................ 20,066.26
             Lease Payments
               Receivable.............           20,066.26

7/1/12  Unearned Interest Income—
          Leases..................... 3,057.02
             Interest Income—Leases..           3,057.02
               ($6,114.04 – $3,057.02)

12/31/12 Unearned Interest Income—
          Leases..................... 2,429.17
             Interest Income—Leases..           2,429.17
          ($4,858.34 X 6/12 = ($2,429.17)

7/1/13  Cash ........................ 20,066.26
             Lease Payments
               Receivable.............           20,066.26

        Unearned Interest Income—
          Leases..................... 2,429.17
             Interest Income—Leases..           2,429.17
               ($4,858.34 – $2,429.17)

12/31/13 Unearned Interest Income—
          Leases..................... 1,744.81
             Interest Income—Leases..           1,744.81

          ($3,489.62 X 6/12 =  $1,744.81)