Purpose: The purpose of this assignments is for you to deepen your understanding of what kind of information is included in an amortization schedule by creating one of your own from scratch, using Excel Task: Please create an amortization schedule in Excel for the following loan: The loan term is 15 years, the payments are made monthly, the loan amount is $300,000 and the interest rate is 4.00% APR. Also include the "totals" over the loan term for the interest payment, the principal payment, as well as "total"payments Note: create your own financial model in an Excel file. Do NOT use a pre-existing Excel template (that you found on the internet)! Again, it is important that you watch all the chapter lectures first before you attempt this assignment Answer the following question include the answer in your spreadsheet) What is the total principal payment during the 4th year (e. year 4 only) of the loan. Enter your answer into your spreadsheet. Make sure you can also solve this question with your AMORT function on the calculator, When you are finished, save the Excel file with the file name: Ch1B.lastname.firstname.xlsx (for example Ch18.schmidt.nina.xlsx) and attach the file to the assignment in Canvas by the due date and time