please answer in excel

Manufacturers Southern leased high-tech electronic equipment from Edison Leasing on January 1, 2021. Edison purchased the equipment from International Machines at a cost of $136,768. (FV of $1. PV of $1. FVA of $1. PVA of $1. FVAD of $i and PVAD of $1) (Use appropriate factor(s) from the tables provided.) Related Information: Lease term 2 years (8 quarterly periods) Quarterly rental payments $18,000 at the beginning of each period Economic life of asset 2 years Fair value of asset $136,768 Implicit interest rate 61 (Also lessee's incremental borrowing rate) Required: Prepare a lease amortization schedule and appropriate entries for Manufacturers Southern from the beginning of the lease through January 1, 2022. Amortization of the right-of-use asset is recorded at the end of each fiscal year (December 31) on a straight-line basis. Complete this question by entering your answers in the tabs below. Amort General Schedule Journal Prepare a lease amortization schedule for the term of the lease for Manufacturers Southern. (Round your intermedi calculations and final answers to the nearest whole dollar) Payment Date Lease Effective Decrease in Payments Interest Balance Lease Balance $ 136,768 01/01/2021 04/01/2021 18,000 $ 1,782 $ 16.218 (16,218) 07/01/2021 18,000 10/01/2021 01/01/2022 04/01/2022 07/01/2022 10/01/2022 Total $ 36,000 $ 1,782 $ 16,218 Amor Boule General Journal