Airlines follow ASPE. The equipment's normal selling price is $210,482 and its unguaranteed residual value at the end of the lease term is estimated to be $15,000. Provincial Airlines will make annual payments of $25,000 at the beginning of each year and pay for all maintenance and insurance. CHL incurred costs of $105,000 in manufacturing the equipment and $7,000 in negotiating and closing the lease. CHL has determined that the collectibility of the lease payments is reasonably predictable, that no additional costs will be incurred, and that the implicit interest rate is 8%. Instructions Answer the following questions, rounding all numbers to the nearest dollar. a. Using tables, a financial calculator, or Excel functions, calculate the PV of the lease payments and unguaranteed residual value under the lease. b. Discuss the nature of this lease in relation to the lessor and calculate the amount of each of the following items: 1. Gross investment 2. Unearned interest income 3. Sale price 4. Cost of goods sold c. Prepare a 10-year lease amortization schedule for the lease obligation using Excel. d. Prepare all of the lessor's journal entries for the first year of the lease, assuming the lessor's fiscal year end is five months into the lease. Reversing entries are not used. e. Determine the current and non-current portions of the net investment at the lessor's fiscal year end, which is five months into the lease. f. Assuming that the $15,000 residual value is guaranteed by the lessee, what changes are necessary to parts (a) to (e)? g. Assume that, as an alternative, CHL would consider leasing the equipment for 12 years if it could recover the normal selling price of $210,482. How much would CHL charge the lessee annually for a 12-year lease? Assume the residual value at the end of 12 years would be $o, and that lease payments would be due at the start of each year. Show calculations using any of the following methods: (1) factor tables, (2) a financial calculator, or (3) Excel functions