How to Create a Mortgage Calculator With Microsoft Excel Watervliet NY

An article describing how to create an Excel spreadsheet that calculates the monthly payment needed to pay off the loan and the total cost of the loan, assuming a constant yearly rate. The spreadsheet displays a table showing how much of the monthly payment is applied to interest and to principle. The workbook is also flexible enough to show how the loan and subsequent payments are affected if any extra money is put against the principle.

Local Companies

HSBC Bank
1.800.975.HSBC (4722)
Colonie Center/Sand Creek 95 Wolf Rd
Albany, NY
Allstate Insuranceflorence Insurance Agency Inc
(518)393-1338
1692 Central Ave
Albany, NY
Northeast Funding Svces
(518)782-1855
5 Herbert Dr
LATHAM, NY
eMortgage- LLC
(518)786-0900
6 Century Hill Dr
LATHAM, NY
A Financial Alternative
(518)765-5047
16 Grove St
VOORHEESVILLE, NY
Bank of America - Troy
518.266.0519
59 Third St
Troy, NY
Citizens Bank - Schoolhouse Road
518-464-6440
1516 Western Avenue
Albany, NY
Allstate Insurance David Lee
(518)477-2800
77 Troy Rd Rte 4
East Greenbush, NY
Nationwide Equities Corporation
(518)456-7500
6 British American Blvd
LATHAM, NY
Adirondack Funding Services
(518)347-1757
1380 Wendell Ave
SCHENECTADY, NY