“World's Most Complete Neighborpedia”
Explore:   What's happening in your neck of the woods?

Mike Rosen

Franklin Farm in Oak Hill Virginia | Homes for Sale in Franklin Farm | Real Estate in Franklin Farm

04-12-10
Mike Rosen

Franklin Farm Neighborhood

Oak Hill/Herndon, Virginia 20171

Franklin Farm, located in western Fairfax County, is a community of 1,777 homes (single family and townhouse) on 850 acres. Franklin Farm is located just north of Fair Oaks, straddling the Fairfax County Parkway. This location provides fairly easy access to the Dulles high-technology corridor, the Dulles Toll Road, Reston Town Center, Fair Oaks mall, and Fairfax Corner center.

Built by NV Homes and Pulte in the early to mid-80s, Franklin Farm has a recreational feel with 182 acres of open space spread throughout the neighborhoods. Franklin Farm amenities include swimming pools, tennis courts, tot-lots, basketball courts, and hiking trails. Franklin Farm also has several community-sponsored events throughout the year, which aims to build a tight bond among its residents.

Franklin Farm Homes For Sale

Franklin Farm Real Estate

Franklin Farm Homes For Sale

Franklin Farm Foreclosures / Bank Owned

Franklin Farm Short Sales

Franklin Farm Neighborhood Info

Home Type
Single Family, Townhouse

Year Built
1980 - 1986

Price Range
$250,000 - $650,000

Lot Size
0.03 - 0.9

Number of Homes
1,750

Features
Tot lots, tennis courts, basketball courts, hiking trails, swimming pools

Builder
NV Homes, Pulte

Franklin Farm Schools

Elementary School
Crossfield, Navy, Oak Hill

Middle School
Carson, Franklin

High School
Chantilly, Oakton

Spreadsheet Formulas: Calculating Home Payments

05-05-08
Mike Rosen
For a lot of homebuyers, calculating a prospective mortgage payment is an online experience. For example, a search on Google for "mortgage calculator" returns 39 million options. Some people, however, prefer to plan on their local hard drive using spreadsheets. For these people, the hardest part is often figuring out what formulas to use. Interest Only Payments
Formula to calculate home loan payments with an interest only mortgage
Home loans with interest only payments are much more simple to calculate than amortizing loans. Using the graphic at right as a guide, enter your loan size and your interest rate into two separate spreadsheet cells. Then, create a third cell and input the following formula that calculates the "Monthly Payment". The formula is:
= (Loan Size) * (Interest Rate) / 12
Principal + Interest Payments
The spreadsheet formula for principal + interest home loan payments
For a home loan with (principal + interest) payments, the formula is a little bit more complicated than with an interest only home loan. Using the graphic at right as a guide, enter your loan size, your interest rate and the duration of your home loan into three separate spreadsheet cells. Then, create a fourth cell and input the following formula that calculates the "Monthly Payment". The formula is:
= - PMT(Interest Rate/12, Loan Term in Months, Loan Size)
For additional spreadsheet formulas and more in-depth reporting, explore your software's "Help" feature to see what you can find.