Rosella wants to calculate the monthly payments for each loan option that she is considering. Switch to the Loan Options worksheet. In cell B11, create a formula using the PMT function to calculate the monthly payments for loan Option 1. Use the values in cells B7, B9, and B4 for the Rate, Nper, and Pv arguments, respectively, and do not enter any values for the optional arguments. Copy the formula you created in cell B11 into the range C11:D11.

It should look like the picture below. but my formula is wrong.