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 |