Assume that the following facts pertain to a non-cancelable lease agreement between Fifth-Third Leasing Company and Bob Evans Farms, a lessee.

Inception date	January 1 2014
Annual lease payment due at the beginning of each year, beginning with January 1, 2014	$81,365
Residual value of equipment at end of lease term, guaranteed by the lessee	$50,000
Lease term	6 years
Economic life of leased equipment	6 years
Fair value of asset at January 1, 2014	$400,000
Lessors implicit rate	12%
Lessees incremental borrowing rate	12%

The lessee assumes responsibility for all executory costs, which are expected to amount to $4,000 per year. The asset will revert to the lessor at the end of the lease term. The lessee has guaranteed the lessor a residual value of $50,000. The lessee uses the straight-line depreciation method for all equipment.

Using the Excel Template spreadsheet linked at the bottom of this page, prepare an amortization schedule that would be suitable for the lessee for the lease term.

				Bob Evans Farms - Lease Amortization Schedule
Date		Lease Payment		Interest Expense		Reduction of Lease Liability		Balance of Lease Liability
January 1 2014								$400,000
January 1 2014
January 1 2015
January 1 2015
January 1 2017
January 1 2018
January 1 2019
December 31 2019