CO4: Identify costs associated with purchasing major purchases and/or buying and selling a home Assignment Instructions: NOTE: There are 2 parts to this assignment. Submit the excel file (including answers to the 5 questions) to your e-portfolium for grading, make sure you give your instructor authority to review and edit by "authorizing" using their APUS/AMU email address. Part 1 Week 4: Major Purchases: Using MS Excel, create an amortization schedule for a car loan. Open MS Excel and select New, in the templates search for "car loan" and then choose loan amortization schedule from the options presented (see attached video). 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? What is your total paid in interest? How long is your loan? Why did you choose this term length? What interest rate did you use? Why? Is this car affordable in your budget? Create this assignment using Microsoft Excel. Answer the questions on a tab (worksheet) in the same workbook file.