please review instructions and make sure each answer is put in a formula. the formula must contain cell adresses.

Click on the "Loans PMT" tab and enter your name in Cell C1. If Cell C1 is left blank, you will not be able to see your score. Each yellow cell requires a formula. The formula must only contain cell addresses. Each correct formula will begin with =+, , or - The basic mathematical operators are,+, and / Addition: To add the values in cells A1 and B4, the formula is =A1+B4 Subtraction: To subtract the value in cell B4 from the value in cell A1, the formula is =A1-B4 Multiplication: To multiply the values in cells A1 and B4, the formula is =A1B4 Division: To divide the value in cell A1 by the value in cell B4, the formula is =A1/B4 Using the PMT function: The PMT function has the following syntax: = PMT(Rate, Nper, Pv, Fv,TyPpe ) Note: To return the payment as a positive value, you must include a negative sign, either before the PMT or as a negative PV amount. On January 1,2023 the Company borrows $270,000 cash by signing a 9-year, 6\%, installment note, with annual interest payments. 1) Calculate the amount of each payment using the PMT function. 2) Prepare the amortization schedule for the loan. Enter a valid Excel formula or function in each of the yellow cells below. Formulas must refer to cell address(es). Entering a value will be marked as incorrect. 1) What is the amount of each annual loan payment?. The PMT function must be used, and formula must return a positive value. Click on the "Loans PMT" tab and enter your name in Cell C1. If Cell C1 is left blank, you will not be able to see your score. Each yellow cell requires a formula. The formula must only contain cell addresses. Each correct formula will begin with =+, , or - The basic mathematical operators are,+, and / Addition: To add the values in cells A1 and B4, the formula is =A1+B4 Subtraction: To subtract the value in cell B4 from the value in cell A1, the formula is =A1-B4 Multiplication: To multiply the values in cells A1 and B4, the formula is =A1B4 Division: To divide the value in cell A1 by the value in cell B4, the formula is =A1/B4 Using the PMT function: The PMT function has the following syntax: = PMT(Rate, Nper, Pv, Fv,TyPpe ) Note: To return the payment as a positive value, you must include a negative sign, either before the PMT or as a negative PV amount. On January 1,2023 the Company borrows $270,000 cash by signing a 9-year, 6\%, installment note, with annual interest payments. 1) Calculate the amount of each payment using the PMT function. 2) Prepare the amortization schedule for the loan. Enter a valid Excel formula or function in each of the yellow cells below. Formulas must refer to cell address(es). Entering a value will be marked as incorrect. 1) What is the amount of each annual loan payment?. The PMT function must be used, and formula must return a positive value