Mission College Finance Lease Worksheet

Question Description

I’m working on a business project and need an explanation to help me learn.

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

^{"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you "A" results."}