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
Schedule of Lease Payments
Five-Year Lease--Beginning-of-Year Payments
Annual Lease Payment
Bargain Purchase Option Amount or
Guaranteed Residual Value
Interest Rate for the Lease
Life of the Lease (# of annual payments)
Initial Lease Obligation (Payable)
Beg of Year 1
Beg of Year 2
Beg of Year 3
Beg of Year 4
Beg of Year 5
End of Year 5
(Solution) Lab 7 Microbial Control" "BIO250L" Student Name: Click here to enter text. Kit Code (located on the lid of your lab kit): Click...
(Solution) The Athenian Acropolis and Greek Theater" Identify two (2) specific aspects of the Athenian Acropolis and its Parthenon, and explain their...
(Solution) The movie I choose is Thelma and Louise.These are my instructions make sure no plagirism and I will do my own title page.Thank you!...
(Solution) ####Standard ACE DB#####n#b` [email protected]?