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

Answer

Get Essay Answer
1,200,000+ Questions
Satisfaction guaranteed
(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]?