4. Look up the equivalent fair market rents in the same area. This data can be found in the Final FY2017 Virginia FMR worksheet. a. 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 Array 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_array argument. This range is the column of county names, cells G3:G137, in the Final FY2017 Virginia FMR worksheet. Require an exact match for the MATCH function. b. In cell D17 on the Loan Terms sheet, enter a nested formula using MATCH and INDEX to find the fair market rent for a two bedroom rental unit in the county listed in cell D15. You can use the same formula as in D16, but substitute column 5 for the INDEX Column_mum argument. B23 E Home Loan Payment Home Price $ Down Payment $ Amount of Loan $ Period (years) Interest rate (years) 230,000 46,000 184,000 30 4.25% Monthly Payment $ Total Interest $ Total Cost $ 905.17 141,860.98 325,860.98 Other Financing Options Increase the monthly payment to: 1,100.00 Loan will be paid off in how many months? Approximate years? Rental Options County Arlington County One Bedroom Two Bedroom B Paste 116 I U fx A. = Alignment 70' Number Formatas Table Cell Styles x A Final FY2017 Virginia FMR Local Area Summary Locality Name Metropolitan Area Name Eficien n e- Bedroom TWO Bedroom Three Bedroom Percent $546 $714 $618 $976 5713 $1.126 $892 $1.409 $1.063 $1.653 $1.440 $1,513 $1.746 $2,300 $2,855 5485 $509 5869 $873 $830 $575 5633 $1.00$ 5789 $1.332 51.623 1069 $1234 5871 5634 $634 $1,511 $575 $1.069 $1.234 $1.440 $1.746 $2.300 $2.855 $625 $640 $520 $824 $633 $1,116 $839 $1059 $575 $575 $634 $475 $692 $479 $605 $549 $595 $572 $453 $602 $485 $436 $789 $633 $876 $636 $805 $633 $687 $1,136 $1 019 $1234 512 $999 51 344 914 $1255 873 $1210 $803 $1,196 $835 $1.007 809 $95 $612 $706 5883 $1.244 $1234 3 Accomack County Accomack County, VA 4 Albemarle County Charlottesville, VA HUD Metro FMR Ares Washington Arlington Alexandria, DC-VA MO HUD 5 Alexandriacity Metro FMR Area Alleghany County-Clifton Forge city-Covington city, VA 6 Alleghany County HUD Nonmetro FMR Area 7 Amelia County Richmond, VAMSA 8 Amherst County Lynchburg, VA MSA 9 Appomattox County Lynchburg, VA MSA Washington Arlington-Alexandria, DC-VA-MO HUD 10 Arlington County Metro FMR Area 11 Augusta County Staunton-Waynesboro, VA MSA 12 Bath County Bath County, VA 13 Bedford city Lynchburg, VA MISA 14 Bedford County Lynchburg, VA MSA 15 Bland County Bland County, VA 16 Botetourt County Roanoke, VAHUD Metro FMR Are 17 Bristol City Kingsport Bristol Bristol, TN-VAMSA 18 Brunswick County Brunswick County, VA 19 Buchanan County Buchanan County, VA 20 Buckingham County Buckingham County, VA HUD Metro FMR Areo Rockbridge County-Buena Vista city-Lexington city, VA 21 Buena Vista city HUD Nonmetro FMR Area 22 Campbell County Lynchburg, VA MSA 23 Caroline County Richmond, VAMSA 24 Carroll County Carroll County-Galaxity, VAHUD Nonmetro FMR Area 25 Charles City County Richmond, VA MSA 26 Charlotte County Charlotte County, VA 27 Charlottesville city Charlottesville, VAHUD Metro FMR Are Virginia Beach Norfolk Newport News, VA-NCHUD 28 Chesapeake City Metro FMR Area 29 Chesterfield County Richmond, VA MSA Washington Arlington Alexandria, DC WA MD NUD 30 Clarke County Metro FMR Are Allegheny County Clifton Forge city Covington city, VA 31 Clifton Forge city HUO Nometro FMR Area 32 Colonial Heights city Richmond, VA MESA Alleghany County Clifton Forge city Covington City, VA MUD Nonmetro FMR MS 33 Covington city 34 Craig County Roanoke, VANUD Metro FMR Are 35 Culpeper County Culpeper County, VAHUD Metre FMR Are 36 Cumberland County Cumberland County, VA Pittsylvania County Danvillecit. VAHUD Nonmetro FMR Area 37 Darwille city 38 Dickenson County Dickenson County, VA Richmond, VA MSA 39 Dinwiddie County M R Greensville County Emporia city, VAHUD NO Savings Loan Torms Final FY2017 Virginia FMR Ready $575 $830 $485 $830 $634 $871 $549 871 $476 $976 579 $1.005 $633 $1.00 5633 $1,126 $1.069 $1.332 86 $1332 5 792 $1.409 $1.623 5905 $1.653 $939 $1.13 $1.577 $1.32 $1. $1.03 871 $1.00 $1.513 $1 $2.300 $2.855 SES 5633 $1.005 5890 $1,332 $509 587 5509 $682 $1.623 5873 $5.72 $1.16 $ $997 $597 $641 $633 $1.00 $0 $123 SERO $557 Annuities +
