Calorie Courier Business Loan Request Option 1 Option 2 Option 3 Loan Amount $ 150,000 $ 150,000 $ 150,000 Annual Interest Rate 6.25% 5.75% 5.45% Payments per Year 12 12 12 Interest Rate per Period 0.52% 0.48% 0.45% Number of Years 10 15 20 Total Payments 120 180 240 Monthly Payments Annual Payments $ $ - $ 14. 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:011. New Perspectives Excel 2016 | Module 4: SAM Project lb Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project