Liam needs to calculate the monthly payment for a loan to purchase the Charles Street property. Calculate the monthly payment as follows:

a$.$ Divide the Rate by $12$ to use the monthly interest rate.

$\frac{0}{2}$

b$.$ Use the Term$\_$in$\_$Months to specify the number of periods.

c$.$ Use the Loan$\_$Amount to include the present value.

d$.$ Insert a negative sign to display the result as a positive amount.

$$ Create a formula using a function.

In the Loan Calculator worksheet, the formula in cell D$6$ should contain the PMT function.

Determine The Total Interest using a formula that multiples the monthly payment by the term in months and then subtracts the loan amount from the result.

$\frac{0}{2}$

X Create a formula.

In the Loan Calculator worksheet, the formula in cell D$7$ should calculate the total interest of the loan.

Determine the Total Cost using a formula that adds the price to the total interest.

$\frac{0}{2}$

X Create a formula.

In the Loan Calculator worksheet, the formula in cell D$8$ should calculate the total cost of the loan.