If possible please include what numbers you inputted for FV, PV, PMT, n and i when using the financial calculator.
Date | Account Title and Explanation | Debit | Credit |
Dec 31, 2019 | Right of use Asset | $ 488,420 | |
Lease liability | $ 488,420 | ||
Dec 31, 2019 | Lease liability | $ 67,199 | |
Cash | $ 67,199 | ||
Dec 31, 2020 | Amortization Expense | $ 48,842 | |
Right of use Asset | $ 48,842 | ||
Dec 31, 2020 | Lease liability | $ 33,501 | |
Interest expense | $ 33,698 | ||
Cash | $ 67,199 | ||
Dec 31, 2021 | Amortization Expense | $ 48,842 | |
Right of use Asset | $ 48,842 | ||
Dec 31, 2021 | Lease liability | $ 36,181 | |
Interest expense | $ 31,018 | ||
Cash | $ 67,199 |
1 | Amount | PV factor | Present value | |
Lease | 67,199 | 7.24689 | $ 486,984 | |
Difference in Residual value (10500-7400) | 3100 | 0.4632 | $ 1,436 | |
Right of use Asset Amortisation expenses will be Right to Use Assets Value=488,420/10 years=48,842 |
$ 488,420 |
Date | Lease payable | Lease payment | Interest expense @ 8% | Reduction in lease payable | Lease payable |
Dec 31, 2016 | $ 488,420 | $ 67,199 | $ 67,199 | $ 421,221 | |
Dec 31, 2017 | $ 421,221 | $ 67,199 | $ 33,698 | $ 33,501 | $ 382,720 |
Dec 31, 2018 | $ 382,720 | $ 67,199 | $ 31,018 | $ 36,181 | $ 346,539 |
2 | Amount | PV factor | Present value | |
Lease | 67,199 | 7.24689 | $ 486,984 | |
Legal Fees | 5000 | 1 | $ 5,000 | |
Incentive | -1000 | 1 | $ -1,000 | |
Difference in Residual value (10500-7400) | 3100 | 0.46319 | $ 1,436 | |
Lease liability | $ 492,420 | |||
if any doubts please mention in comment
If possible please include what numbers you inputted for FV, PV, PMT, n and i when...
Please show all your work! Thank you. 121-4 (L02,4) EXCEL (Lessee Entries; Finance Lease and Unguaranteed Residual Value) Assume that on December 31, 2016, Kimberly-Clark Corp. signs a 10-year, non-cancelable lease agreement to lease a storage building from Sheffield Storage Company. The following information pertains to this lease agreement. 1. The agreement requires equal rental payments of $71,830 beginning on December 31, 2016. 2. The fair value of the building on December 31, 2016, is $525,176. 3. The building has...
Assume that on December 31, 2019, Kimberly-Clark Corp. signs a 10-year, non-cancelable lease agreement to lease a storage building from Sheffield Storage Company. The following information pertains to this lease agreement. 1. The agreement requires equal rental payments of $68,499 beginning on December 31, 2019. 2. The fair value of the building on December 31, 2019 is $501,036. 3. The building has an estimated economic life of 12 years, a guaranteed residual value of $10,000, and an expected residual value...
Assume that on December 31, 2019, Kimberly-Clark Corp. signs a 10-year, non-cancelable lease agreement to lease a storage building from Sheffield Storage Company. The following information pertains to this lease agreement. 1. The agreement requires equal rental payments of $67,299 beginning on December 31, 2019. 2. The fair value of the building on December 31, 2019 is $492,571. 3. The building has an estimated economic life of 12 years, a guaranteed residual value of $10,500, and an expected residual value...
E21-4 (L02,4) EXCEL (Lessee Entries, Finance Lease and Unguaranteed Residual Value) Assume that on December 31, 2016, Kimberly-Clark Corp. signs a 10-year, non-cancelable lease agreement to lease a storage building from Sheffield Storage Company. The following information pertains to this lease agreement. 1. The agreement requires equal rental payments of $71,830 beginning on December 31, 2016. 2. The fair value of the building on December 31, 2016, is $525,176. 3. The building has an estimated economic life of 12 years,...
Assume that on December 31, 2016, Kimberly-Clark Corp. signs a 10-year, non-cancelable lease agreement to lease a storage building from Sheffield Storage Company. The following information pertains to this lease agreement: The agreement requires equal rental payments of $68,299 beginning on December 31, 2016 The fair value of the building on December 31, 2016 is $500,513 1. 2. The building has an estimated economic life of 12 years, a guaranteed residual value of $12,000, and an expected residual value of...
(E21-4 L02.4) EXCEL 1-4 (L02,4) EXCEL (Lessee Entries, Finance Lease and Unguaranteed Residual Value) Assume that on December 31, 2010, Kimberly-Clark Corp. signs a 10-year, non-cancelable lease agreement to lease a storage building from Sheffield Storage Company. The following information pertains to this lease agreement. 1. The agreement requires equal rental payments of $71.830 beginning on December 31, 2016. 2. The fair value of the building on December 31, 2016, is $525.176. 3. The building has an estimated economic life...
(Lessee Entries; Finance Lease and Unguaranteed Residual Value) Assume that on December 31, 2016, Kimberly-Clark Corp. signs a 10-year, non-cancelable lease agreement to lease a storage building from Sheffield Storage Company. The following information pertains to this lease agreement. 1. The agreement requires equal rental payments of $71,830 beginning on December 31, 2016. 2. The fair value of the building on December 31, 2016, is $525,176. 3. The building has an estimated economic life of 12 years, a guaranteed residual...
Exercise 21A-4 a-d Assume that on December 31, 2016, Kimberly-Clark Corp. signs a 10-year, non-cancelable lease agreement to lease a storage building from Sheffield Storage Company. The following information pertains to this lease agreement: 1. The agreement requires equal rental payments of $66,499 beginning on December 31, 2016. 2. The fair value of the building on December 31, 2016 is $486,311. 3. The building has an estimated economic life of 12 years, a guaranteed residual value of $9,500, and an...
Assume that on December 31, 2019, Kimberly-Clark Corp. signs a 10-year, non-cancelable lease agreement to lease a storage building from Sheffield Storage Company. The following information pertains to this lease agreement. 1. The agreement requires equal rental payments of $66,599 beginning on December 31, 2019. 2. The fair value of the building on December 31, 2019 is $487,267. 3. The building has an estimated economic life of 12 years, a guaranteed residual value of $10,000, and an expected residual value...
Assume that on December 31, 2019, Kimberly-Clark Corp signs a 10 year, non-cancelable lease agreement to lease a storage building from Sheffield Storage Company The following information pertains to this lease agreement 1 The agreement requires equal rental payments of $67,199 beginning on December 31, 2019. 2 The fair value of the building on December 31, 2019 is $491.847 3 The building has an estimated economic life of 12 years, a guaranteed residual value of $10,500, and an expected residual...