Please answer correct and show your solution, appreciate if using BA plus calculator if possible.

Thank you!

A18-8 Lessee Accounting; Amortization Table: (LO 18-2) On 31 December 20X0, Columbia Inc. entered into an agreement with Scotia Ltd. to lease equipment with a useful life of 6 years. Columbia Inc. will make four equal payments of $148,000 at the beginning of each lease year. Columbia Inc. anticipates that the equipment will have a residual value of $86,400 at the end of the lease, net of removal costs. Columbia Inc. has the option of extending the lease by (1) paying $86,400 to retain the equipment or (2) allowing Scotia Ltd. to remove it. Scotia Ltd.'s implicit interest rate in this lease is 6%. Columbia Inc.'s incremental borrowing rate is 7%. Columbia Inc. depreciates the leased equipment on a straight-line basis. The lease commences on 1 January 201. Assume that the fair value of the equipment on the open market is greater than the present value of the lease payments. (PV of $1, PVA of $1, and PVAD of $1.) (Use appropriate factor(s) from the tables provided.) Required: 1. Prepare a lease liability amortization table for this lease for Columbia Inc. (Round your final answers to the nearest whole dollar amount. Leave no cell blank. Be certain to enter "0" wherever required.) 2. Prepare all entries that Columbia Inc. will record for this lease for 201 and 202. (Round your intermediate calculations and final answers to the nearest whole dollar amount. If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) X Answer is comblete but not entirelv correct. 1 PRESENT VALUE OF AN ORDINARY ANNUITY OF n PAYMENTS OF 1: (P/A,i,n) D/A1(1+i)n1 PRESENT VALUE OF AN ORDINARY ANNUITY OF n PAYMENTS OF 1: (P/A,i,n) D/A1(1+i)n1