See attached spreadsheet for problem.Please explain any calculations

The following facts pertain to a noncancelable lease agreement between December Leasing Company and Fayett Electronics, a lessee, for a computer system. Inception date: Lease term: Economic life of lease equipment: Fair value of asset at October 1, 2007: Residual value at end of lease term: Lessor's implicit rate: Lessee's incremental borrowing rate: Annual lease payment due at the beginning of each year, beginning with October 1, 2007: October 1, 2007 6 years 6 years $901,149 0 10% 10% $188,100 The collectibility of the lease payments is reasonably predictable, and there are no important uncertainties surrounding the costs yet to be incurred by the lessor. The lessee assumes responsibility for all executory costs, which amount to $16,500 per year, and are paid each October 1, beginning October 1, 2007. (This $16,500 is not included in the rental payment of $188,100.) The asset will revert to the lessor at the end of the lease term. The straight-line depreciation method is used for all equipment. The following amortization schedule has been prepared correctly for use by both the lessor and the lessee in accounting for this lease. The lease is to be accounted for properly as a capital lease by the lessee and as a direct-finance lease by the lessor. Date: Annual lease Payment / Receipt: 10/01/07 10/01/07 10/01/08 10/01/09 10/01/10 10/01/11 10/01/12 188,100.00 188,100.00 188,100.00 188,100.00 188,100.00 188,100.00 1,128,600.00 Interest (10%) on Unpaid Liability / Receivable: 71,304.90 59,625.39 46,777.93 32,645.72 17,097.06 227,451.00 Reduction of Balance of Lease Liability / Lease Liability / Receivable: Receivable: 188,100.00 116,795.10 128,474.61 141,322.07 155,454.28 171,002.94 901,149.00 901,149.00 713,049.00 596,253.90 467,779.29 326,457.22 171,002.94 0.00 Instructions: (a) Assuming the lessor's accounting period ends on September 30, answer the following questions with respect to this lease agreement: (1) What items and amounts will appear on the lessor's income statement for the year ending September 30, 2008? Interest revenue Amount (2) What items and amounts will appear on the lessor's balance sheet at September 30, 2008? Current assets: Lease receivable Interest receivable Amount Amount Noncurrent assets: Lease receivable (net investment in lease) Amount (3) What items and amounts will appear on the lessor's income statement for the year ending September 30, 2009? Account Title Amount (4) What items and amounts will appear on the lessor's balance sheet at September 30, 2009? Current assets: Account Title Account Title Amount Amount Noncurrent assets: Lease receivable (net investment in lease) Amount (b) Assuming the lessor's accounting period ends on December 31, answer the following questions with respect to this lease agreement: (1) What items and amounts will appear on the lessor's income statement for the year ending December 31, 2007? Interest revenue Amount (2) What items and amounts will appear on the lessor's balance sheet at December 31, 2007? Current assets: Lease receivable Lease receivable Amount Amount Noncurrent assets: Lease receivable Amount (3) What items and amounts will appear on the lessor's income statement for the year ending December 31, 2008? Interest revenue Amount (4) What items and amounts will appear on the lessor's balance sheet at December 31, 2008? Current assets: Lease receivable Interest receivable Noncurrent assets: Lease receivable $128,474.61 Amount Amount M13E_Problem 02 + Data, Page 1 of 1, 08/06/2012 , 21:09:28