In: Accounting
Sheridan Leasing Limited, which has a fiscal year end of October
31 and follows IFRS 16, signs an agreement on January 1, 2020, to
lease equipment to Irvine Limited. The following information
relates to the agreement.
1. | The term of the non-cancellable lease is six years, with no renewal option. The equipment has an estimated economic life of eight years. | |
2. | The asset’s cost to Sheridan, the lessor, is $309,000. The asset’s fair value at January 1, 2020, is $309,000. | |
3. | The asset will revert to the lessor at the end of the lease term, at which time the asset is expected to have a residual value of $45,488, which is not guaranteed. | |
4. | Irvine Limited, the lessee, assumes direct responsibility for all executory costs. | |
5. | The agreement requires equal annual rental payments, beginning on January 1, 2020. | |
6. |
Collectibility of the lease payments is reasonably predictable. There are no important uncertainties about costs that have not yet been incurred by the lessor |
Assuming that Sheridan Leasing desires a 8% rate of return on
its investment, use time value of money tables, a financial
calculator, or Excel functions to calculate the amount of the
annual rental payment that is required. (Round factor
values to 5 decimal places, e.g. 1.25124 and final answer to 0
decimal places, e.g. 5,275.)
Annual rental payment |
Prepare an amortization schedule using a spreadsheet that would be suitable for the lessor for the lease term
Prepare all of the journal entries for the lessor for 2020 and 2021 to record the lease agreement, the receipt of lease payments, and the recognition of income. Assume that Sheridan prepares adjusting journal entries only at the end of the fiscal year.
Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you. | |||||
Part 1 | |||||
PV | $ -309,000 | Fair Value | |||
I | 8% | Rate | |||
N | 6 | Period | |||
PMT | ? | ||||
FV | $ 45,488 | Non Guranteed Residual Value | |||
Type | 1 | Type | |||
Periodic Lease Payment | $ 56,149 | ||||
Part 2 | |||||
Date | Annual Lease Payment | Interest 8% | Net Recovery | Balance | |
1/1/2020 | $ 309,000 | ||||
1/1/2020 | $ 56,149 | $ 56,149 | $ 252,851 | ||
1/1/2021 | $ 56,149 | $ 20,228 | $ 35,921 | $ 216,930 | |
1/1/2022 | $ 56,149 | $ 17,354 | $ 38,794 | $ 178,136 | |
1/1/2023 | $ 56,149 | $ 14,251 | $ 41,898 | $ 136,238 | |
1/1/2024 | $ 56,149 | $ 10,899 | $ 45,250 | $ 90,988 | |
1/1/2025 | $ 56,149 | $ 7,279 | $ 48,870 | $ 42,119 | |
31/12/2025 | $ 45,488 | $ 3,369 | $ 42,119 | $ - | |
Total | $ 382,381 | $ 73,381 | $ 309,000 | ||
Part 3 | |||||
Date | Account | Debit | Credit | ||
1/1/20 | Lease Receivable | $ 382,381 | |||
Equipment on Lease | $ 73,381 | ||||
Unearned Interest Income | $ 309,000 | ||||
1/1/20 | Cash | $ 56,149 | |||
Lease Receivable | $ 56,149 | ||||
31/10/17 | Unearned Interest Income | $ 16,857 | |||
Interest Income | $ 16,857 | ||||
$20,228/12*10 | |||||
1/1/21 | Cash | $ 56,149 | |||
Lease Receivable | $ 56,149 | ||||
31/10/21 | Unearned Interest Income | $ 17,833 | |||
Interest Income | $ 17,833 | ||||
($20,228/12*2)+($17,354/12*10) | |||||