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

Wells Fargo - New Paltz
845-255-6600
29 Main St
New Paltz, NY
Infinity Home Furnishing
(845)534-4545
2 Mill Street
CORNWALL, NY
Countrywide Home Loans
(914)962-5004
36 Triangle Centre
YORKTOWN HEIGHTS, NY
Britchey Jerome RL Estate
(914)271-4758
50 Maple Street
CROTON ON HUDSON, NY
Metlife Bank, National Association
(845) 897-6555
725 Route 9
Fishkill, NY
Chase Bank
(845) 429-6051
56 W Ramapo Rd
Garnerville, NY
Allstate Insurancefuentes Ins Agency Inc
(914)736-3000
2241 Crompond Rd
Cortlandt Manor, NY
Gold Mortgage Services
(845)236-7722
1298 Route 9W
MARLBORO, NY
Citifinancial
(845)782-0998
300 Route 17M
HARRIMAN, NY
B P G Mortgage Corporation
(914)827-9030
5 Baltic Place Suite 2
CROTON ON HUDSON, NY

Related Articles