Business Finance Homework Help

Mission College Finance Lease Worksheet

 

Please use the information below to calculate on Excel. Don’t just simply enter the amount, he wants to see the calculation on Excel. Make an Excel that’s formatted the same way as the “Sample Project” (attachment below), but instead of inputting numbers and stuff, you’re creating formulas within the Excel that will help calculate for the Amortization Schedule (it has to work and do the correct calculations if the numbers change). I will need to submit the Excel file not a pdf.

Lease term (years): 10

Discount rate: 10%

Annual lease payment: 90,000

Bargain Purchase Options: 20,000