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

Bank of America - Camillus Commons
315.487.0772
5345 West Genesee Street
Camillus, NY
Cayuga Lake National Bank - Aurora Ofc
315-364-8071
Aurora, NY
Solvay Bank
(315)487-2013
2318 West Genesee Street Stop 7
SYRACUSE, NY
Community Bank NA
(607)387-7580
105 Main Street
MORAVIA, NY
Nvr Mortgage Finance Inc
(315) 451-1839
159 Dwight Park Cir
Syracuse, NY
HSBC Bank
1.800.975.HSBC (4722)
Corner Of Beverly Dr 4401 W Genessee St
Syracuse, NY
Citizens Bank - Camillus/Wal-Mart
315-468-8622
5399 West Genesee St.
Camillus, NY
Solvay Bank Insurance Agency Inc
(315)484-2249
1537 Milton Avenue
SYRACUSE, NY
Geddes Federal Savings & Loan Association
(315)468-6281
2208 West Genesee Street
SYRACUSE, NY
Phh Mortgage Corporation
(866) 899-8380
15 W Main St
Waterloo, NY

Related Articles