Defin Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Function Creat Used Time Reference Trig Functions D12 x v ROUND(D11/12,0) Home Loan Payment Home Price $ Monthly Payment Down Payment$ Amount of Loan $ Period (years) 230,000 46,000 184,000 30 4.25% 905.17 141,860.98 325,860.98 Total Interest $ Total Cost $ Interest rate (years) Other Financing Options 10 Increase the monthly payment to: Loan will be paid off in how many months? Approximate years? 1,100.00 253.868299 21 12 13 Rental Options 15 16 Arlington County One Bedroom Two Bedroom 18 19 20 21 In cell D16 on the Loan Terms sheet, enter a nested formula using MATCH and INDEX to find the fair market rent for a one bedroom rental unit in the county listed in cell D15. We've already defined two named ranges for you to use. FMR 2017 is the named range to use for the INDEX function Arnay argument. This range includes all the data in cells A3:H137 in the Final FY2017 Virginia FMR worksheet. The one bedroom rent data is in column 4. The second named range, Counties, can be used as the MATCH Lookup_armay argument. This range is the column of county names, cells G3:G137, in the Final FY2017 Viginia FMR worksheet. Require an exact match for the MATCH function. Defin Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Function Creat Used Time Reference Trig Functions D12 x v ROUND(D11/12,0) Home Loan Payment Home Price $ Monthly Payment Down Payment$ Amount of Loan $ Period (years) 230,000 46,000 184,000 30 4.25% 905.17 141,860.98 325,860.98 Total Interest $ Total Cost $ Interest rate (years) Other Financing Options 10 Increase the monthly payment to: Loan will be paid off in how many months? Approximate years? 1,100.00 253.868299 21 12 13 Rental Options 15 16 Arlington County One Bedroom Two Bedroom 18 19 20 21 In cell D16 on the Loan Terms sheet, enter a nested formula using MATCH and INDEX to find the fair market rent for a one bedroom rental unit in the county listed in cell D15. We've already defined two named ranges for you to use. FMR 2017 is the named range to use for the INDEX function Arnay argument. This range includes all the data in cells A3:H137 in the Final FY2017 Virginia FMR worksheet. The one bedroom rent data is in column 4. The second named range, Counties, can be used as the MATCH Lookup_armay argument. This range is the column of county names, cells G3:G137, in the Final FY2017 Viginia FMR worksheet. Require an exact match for the MATCH function