Solution 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
Solution A B C Schedule of Lease Payments Amortization
Solution A B C Schedule of Lease
B C Schedule of Lease Payments Amortization Schedule Five Year Lease Beginning
Solution A B C Schedule of
Lease Payments Amortization Schedule Five Year Lease Beginning of Year
Solution A B C
Solution A
(Solution) 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...

 Category: General Words: 1050 Amount: \$12 Writer:

Paper instructions

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 D E Schedule of Lease Payments (Amortization Schedule) Five-Year Lease--Beginning-of-Year Payments Annual Lease Payment \$60,000 Bargain Purchase Option Amount or Guaranteed Residual Value \$75,000 Interest Rate for the Lease 10.00% Life of the Lease (# of annual payments) 5 Initial Lease Obligation (Payable) \$296,761.03 Interest Lease Date Amount Expense Principal Obligation Initial Balance \$296,761.03 Beg of Year 1 \$60,000 0 \$60,000 \$236,761.03 Beg of Year 2 \$60,000 \$23,676.10 \$36,324 \$200,437.13 Beg of Year 3 \$60,000 \$20,043.71 \$39,956 \$160,480.84 Beg of Year 4 \$60,000 \$16,048.08 \$43,952 \$116,528.93 Beg of Year 5 \$60,000 \$11,652.89 \$48,347 \$68,181.82 End of Year 5 \$75,000 \$6,818.18 \$68,182 \$0.00