ave LAB 7 ACC Insert Draw Page Layout Formulas >> Tell me Share A % ard E G Conditional Formatting Format as Table Font Alignment Number Calls Editing Cell Styles ex v fx D F Name: Your score: 0% Average al tabs: wants to buy a car and is considering several financing options. The car Kian wants to buy costs $25,000. 1) Calculate the amount of each monthly car payment using the PMT function. 2) Calculate the total amount of the car payments and 3) the total amount of interest paid over the term of the loan under the following financing options Enter a valid Excel formula or function in each of the yellow cells below. Formulas must refer to cel address(es). Entering a value will be marked as incorrect. $25,000 12 Amount financed Payments per year Financing Option Term (years) Annual interest rate 1) Monthly payment 2) Total payments over term 3) Total interest paid over term 1 2 3 4 5 3 6 4 6.0% 5.0% 5.5% 7.0% save LAB 7 ACC Insert Draw Page Layout Formulas >> Tell me Share A. 5 % ard Calls Editing Conditional Formatting Format as Table Font Alignment Number Cell Styles xv fc =+@'Loans PMTIC1:01 B F Name: Your score: 0% wants to buy a home, and is considering several financing options. Kian plans to borrow $270,000 with monthly payments. 1) Calculate the amount of each mortgage payment using the PMT function. 2) Calculate ithe total amount of mortgage payments and 3) the total amount of interest paid over the term of the mortgage under the following financing options. Enter a valid Excel formula or function in each of the yellow cells below. Formulas must refer to cel address(es). Entering a value will be marked as incorrect. $270,000 12 Mortgage amount Payments per year Financing Option Term (years) Annual interest rate 1) Monthly payment 2) Total payments over term 3) Total interest paid over term 1 2 3 4 25 20 30 25 10.0% 9.09 9.5% 11.0% +