y Cashman Excel 2019 | Module 4: SAM Project lb Miranda wants to calculate the monthly payment for a loan to purchase the Beecher Street house at the most favorable interest rate she found online. Calculate the payment as follows: a. b. In cell D5, start to enter a formula using the PMT function. For the rate argument, divide the Rate (cell D3) by 12 to use the monthly interest rate. For the nper argument, use the Term_in_Months (cell D4) to specify the number of periods. c. d. For the pv argument, use the Loan_Amt (cell B7) to include the present value. Insert a negative sign (-) after the equal sign in the formula to display the result 2019 | Module 4: SAM Project lb s to calculate the monthly payment for a loan to purch at the most favorable interest rate she found online. C 5, start to enter a formula using the PMT function. ate argument, divide the Rate (cell D3) by 12 to us per argument, use the Term_in_Months (cell 04 5. v argument, use the Loan_Amt (cell B7) to inclu egative sign (-) after the equal sign in the form