In: Accounting
The Ithaca Company is considering leasing a machine for a period of four years. The cost to buy the machine outright today is $90,000 and the machine has a normal expected economic life of 5 years. The lease payment that is required is based on an annual interest rate of 12% and a residual of $18,000 at the end of the lease. Find the following for year 1 and year 2
Beginning Balance of Lease Liability
Annual Lease Payment
Interest Portion of Lease Payment
Principal Portion of Lease Payment
Ending Balance of Lease Liability
| Year | PV factor @ 12% | Remarks |
| 1 | 0.89286 | = 1 / 1.12 |
| 2 | 0.79719 | = 0.89286 / 1.12 |
| 3 | 0.71178 | = 0.79719 / 1.12 |
| 4 | 0.63552 | = 0.71178 / 1.12 |
| Total | 3.03735 |
| Cost of New Machine | $ 90,000 |
| Less: Present value of purchase option value (18000*0.63552) | $ 11,439 |
| Amount recover through annual lease payments | $ 78,561 |
| Divided : Total Present Value Factor (as above) | 3.03735 |
| Annual lease payments | $ 25,865 |
| Initial lease liability (25865*3.03735) | 78,561 |
| Interest on Liability = Beginning Lease Liability * 12% |
| Reduction of Lease Liability = Annual Lease Payment Plus BPO - Interest on Liability |
| Lease Liability = Beginning Lease Liability - Reduction of Lease Liability |
| Lessee | ||||
| Lease Amortization Schedule | ||||
| Date | Annual Lease Payment | Interest on Liability | Reduction of Lease Liability | Lease Liability |
| Year 0 | $ 78,561 | |||
| Year 1 | $ 25,865 | $ 9,427 | $ 16,438 | $ 62,123 |
| Year 2 | $ 25,865 | $ 7,455 | $ 18,410 | $ 43,713 |
| Year 3 | $ 25,865 | $ 5,246 | $ 20,619 | $ 23,094 |
| Year 4 | $ 25,865 | $ 2,771 | $ 23,094 | $ - |
| Year | Year 1 | Year 2 |
| Beginning Balance of Lease Liability | 78,561 | 62,123 |
| Annual Lease Payment | 25,865 | 25,865 |
| Interest Portion of Lease Payment | 9,427 | 7,455 |
| Principal Portion of Lease Payment | 16,438 | 18,410 |
| Ending Balance of Lease Liability | 62,123 | 43,713 |