Bre wants to buy a home, and is considering several financing options. Bre plans to borrow $$180,000$

with monthly payments. $1)$ Calculate the amount of each mortgage payment using the PMT function. $2)$

Calculate the 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 cell address$($es$).$ Entering a value will be marked as incorrect.Bre wants to buy a home, and is considering several financing options. Bre plans to borrow $$180,000$ with monthly payments. $1)$ Calculate the amount of each mortgage payment using the PMT function. $2)$ Calculate the 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 cell address$($es$).$ Entering a value will be marked as incorrect.