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

Chase Bank
(845) 897-2104
15 Merritt Blvd
Fishkill, NY
Citizens Bank - Red Oaks Mill
845-462-7300
32 Vassar Road
Poughkeepsie, NY
Truran Agency Insurance
(845)279-2064
1006 Route 22
Brewster, NY
Gold Mortgages Services Inc
(845)534-6800
264 Main Street
CORNWALL, NY
Metlife Bank, National Association
(845) 897-6555
725 Route 9
Fishkill, NY
HSBC Bank
1.800.975.HSBC (4722)
Across From Chilis Routes 6 & 118
Baldwin Place, NY
Bank of America - Wappinger Falls
845.297.5915
1469 Route 9
Wappingers Falls, NY
Citizens Bank - Highland
845-691-8101
3650 US Highway 9W
Highland, NY
Allied Mortgage Capital Corp
(203)790-5853
26 Covered Bridge Ln
Danbury, CT
Evolve Bank & Trust
(845) 363-1333
155 Main St Ste 309
Brewster, NY