Company leased a machine from Lagatha Leasing Company

Company leased a machine from Lagatha Leasing Company. The lease is for 4 years. The life of the asset is 4 years. The terms of the lease require 4 payments of $100,000 at the beginning of the year, beginning on January 1, 2019. The lease is non-cancelable. Ragnar's incremental borrowing rate is 8%. Lagatha's earnings rate is 6%, but Ragnar does not know Lagatha's rate. There is an unguaranteed residual value of $10,000 at the end of year 4. The returned equipment was worth $7,500. 
-Help me make a table to amortize the Lease Liability for Ragnar.







Using the updated Lease for changes in lease accounting, on the books of Ragnar,

- Help me Record the inception of the lease and first payment on January 1, 2019.

- Help me Record the interest accrual at the end of the first year and any amortization expense required.
- Help me Record the return of the equipment to Lagatha Leasing at the end of year 4 if necessary.