Answer:
See Sheet1 of the attached excel file for the lease amortization schedule; and its Sheet2 for the journal entries.
Explanation:
Note: See Sheet1 of the attached excel file for the lease amortization schedule; and its Sheet2 for the journal entries.
In the lease amortization schedule, the following formula are used:
Number of quarters in a year = 4
Effective Interest = Previous Outstanding Balance * (Implicit interest rate / Number of quarters in a year)
Decrease in Balance = Lease Payments - Effective Interest
Outstanding Balance = Previous Outstanding Balance - Current Decrease in Balance