4. Liam needs to calculate the monthly payment for a loan to purchase the Charles Street property. Calculate the payment as follows: a. b. In cell D6, start to enter a formula using the PMT function. For the rate argument, divide the Rate (cell D4) by 12 to use the monthly interest rate. For the nper argument, use the Term_in_Months (cell D5) to specify the number of periods. For the pv argument, use the Loan_Amount (cell BB) to include the present value. Insert a negative sign (-) after the equal sign in the formula to display the result as a positive amount