How to Create a Mortgage Calculator With Microsoft Excel Lancaster 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

Citizens Bank - Grand Island / Tops
716-775-3344
2140 Blvd
Grand Island, NY
Allstate Insurance Bob White
(716)631-0030
1325 Millersport Hwy
Williamsville, NY
Multi Source Funding
(716)633-6050
247 Cayuga Rd
BUFFALO, NY
Cross State Funding Corporation
(716)691-7000
455 Commerce Drive
BUFFALO, NY
Hsbc Bank Usa Na
(800) 622-7759
95 Washington St
Buffalo, NY
Citizens Bank - South Park Hamburg/Tops
716-646-6281
6150 South Park Ave
Hamburg, NY
Bank of America - Williamsville South
800.432.1000
5529 Main St
Williamsville, NY
Allstate Insurance Bryan J Ripellino
(716)565-0100
442 Evans Rd
Williamsville, NY
Fleet Private Clients Group
(716)847-4432
10 Fountain Plz
BUFFALO, NY
Associates Mortgage Company of New York Inc - West Seneca
(716)674-4948
1102 Union Road
BUFFALO, NY