$3.$ Liam also wants to use defined names in other calculations to help him interpret the formulas.

In the Loan Payment Calculator section, create defined names in column D based on the values in column C$.$

$4.$ 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.

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.