Using MS Excel, create an amortization schedule for a car loan. Open MS
Excel and click New, in the templates search for “car loan” and then
choose loan amortization schedule from the options presented. Fill out the form
with data from a car purchase you may have been thinking about recently. Answer
the following questions:
What is your payment? 650$
What is your total paid in interest?
How long is your loan? 48months
Why did you choose this term length? affordable
What interest rate did you use? 5% Why? approval rate
Is this car affordable in your budget? YES
Create this assignment using Microsoft Excel. Answer the questions on a new worksheet in the same workbook.
Do you need help with this assignment? Or a different one? We got you covered.