Make a excel spreadsheet (numbers are same with the attachment) to provide a schedule of lease payments (amortization schedule) for a five-period lease with payments made once each year at the beginning of the year with the option of including a bargain purchase option amount or guaranteed residual value. The spreadsheet general enough that I could input any new numbers for the annual lease payment, bargain purchase option amount or guaranteed residual value, and interest rate (cells E5, E7, and E8 in the attachment) and automatically have an updated amortization schedule for any five-period capital lease with payments at the beginning of the period. Have to use the functions to calculate the numbers, NOT the result of simply typing numbers into the spreadsheet cells.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 A B C Schedule of Lease Payments (Amortization Schedule) Five-Year Lease--Beginning-of-Year Payments D Annual Lease Payment Bargain Purchase Option Amount or Guaranteed Residual Value Interest Rate for the Lease Life of the Lease (# of annual payments) $60,000 $75,000 10.00% 5 Initial Lease Obligation (Payable) Date Initial Balance Beg of Year 1 Beg of Year 2 Beg of Year 3 Beg of Year 4 Beg of Year 5 End of Year 5 Amount $60,000 $60,000 $60,000 $60,000 $60,000 $75,000 E $296,761.03 Interest Expense 0 $23,676.10 $20,043.71 $16,048.08 $11,652.89 $6,818.18 Principal $60,000 $36,324 $39,956 $43,952 $48,347 $68,182 Lease Obligation $296,761.03 $236,761.03 $200,437.13 $160,480.84 $116,528.93 $68,181.82 $0.00