Quiz 3 Just as reminder, here are two quick references: LEFT Function and RIGHT Function Rate A D E 1 A11Y 2 Back to Index 3 MSUFCU mortgage rates 4 Table 1 - Rates as of last Friday 5 Loan maturity 6 30 Year as low as 3.500% 7 20 Year as low as 3.375% 8 15 Year as low as 3.150% 9 10 Year as low as 3.000% 10 11 What maturity do you wish to select? 30 Year 12 There is a Data Validation List in B11 to toggle among the different loan maturities. 13 How should the PMT function be formulated to calculate the monthly payment on a $500,000 mortgage? O PMT(RIGHT(VLOOKUP(B11,A6:B9,2,0),6)/12,LEFT(B11,2)*12,-500000) O PMT(VLOOKUP(B11,A6:B9,2,0)/12,B11*12,-500000) O PMT(LEFT(B11,2)/12,RIGHT(VLOOKUP(B11,A6:39,2,0),6)*12,-500000) O PMT(LEFT(B11,2)/12, VLOOKUP(B11,A6:39,2,0)*12,-500000) O PMT(VLOOKUP(B11,A6:B9,2,0)/12,LEFT(B11,2)*12,-500000)