Liam needs to calculate the monthly payment for a loan to purchase the Charles Street property. Calculate the payment as follows:a$.$ In cell D$6,$ start to enter a formula using the PMT function.b$.$ For the rate argument, divide the Rate by $12$ to use the monthly interest rate.C$.$For the per argument, use the Term$\_$in$\_$Months to specify the number of periods.d$.$For the pv argument, use the Loan$\_$ Amount to include the present value.Insert a negative sign $(-)$ after the equal sign in the formula to display the result as a positive amount.