Loan Amortization Schedule Table 1 Enter values in the green cells below: Loan amount (between $15,000 and $90,000) Annual interest rate (between 4% and 8%) |Loan period in years (between 4 years and 7 years) |Number of payments per year stays 12 |Start date of loan (today's date) Optional extra payment per month $0.00 Loan Summary: Scheduled payment Scheduled number of payments Actual number of payments False Total early payments $0.00 Total interest $0.00 W4D: Discussion A When you borrow money to purchase a car (or home), one of the documents given to you by your lernder is an amortizatíon schedule. An amortization schedule outlines your loan payments each month and helps keep you on track. This is important because you've decided it is time to purchase a new car! Search for a new car you would like to purchase. Provide the year, make, and model in the title of your post. Open and complete the Loan Amortization Excel file beloww to compare how much interest is owed on your car loan when paying the minimum monthly payment versus paying more than the minimum required each month. Loan Amortization Schedule.xlsx Part 1 a. Enter your chosen values in the green