How to Create a Mortgage Calculator With Microsoft Excel Fairport 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 - S. Clinton Ave/Tops
1900 Clinton Avenue S.
Rochester, NY
Dollars And Sense Mortgage Inc
180 Office Park Way Suite 2000
Pittsford, NY
Mr. Gregory Lee Schaffer (RFC®), CFP
3205 Mount Read Blvd.
Rochester, NY
First Funding Network
2164 Hudson Avenue
Rochester Home Equity Inc
(585) 263-4353
180 Office Park Way Ste 2000
Pittsford, NY
1.800.975.HSBC (4722)
Just West Of 390 2362 Lyell Ave
Rochester, NY
Citizens Bank - Panorama Plaza
715 Panorama Trail
Rochester, NY
Thomas J. Antinora Jr. Agency
2230 Ridge Rd W
Rochester, NY
American General Financial Services
Rochester, NY
Fairport Savings Bank - Mortgage Line
45 South Main Street
Data Provided by: