A B 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 20 Year 15 Year 9 10 Year NO 7 Rate as low as 3.500% as low as 3.375% as low as 3.150% as low as 3.000% 00 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. 12 How should the PMT function be formulated to calculate the monthly payment on a $500,000 mortgage? O PMT(RIGHT(B11,2)*12,LEFT(VLOOKUP(B11,A6:B9,2,0),6)/12,-500000) O PMT(RIGHT(VLOOKUP(B11,A6:39,2,0),6)/12,LEFT(B11,2)*12,-500000) O PMT(LEFT(VLOOKUP(B11,A6:B9,2,0),2)/12,RIGHT(B11,6)*12,-500000) O PMT(VLOOKUP(B11, A6:39,2,0)/12,LEFT(B11,2)*12,-500000) O PMT(VLOOKUP(B11, A6:B9,2,0/12,B11*12,-500000)