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
585-442-2090
1900 Clinton Avenue S.
Rochester, NY
Dollars And Sense Mortgage Inc
(585)262-3200
180 Office Park Way Suite 2000
Pittsford, NY
Mr. Gregory Lee Schaffer (RFC®), CFP
585-621-3300
3205 Mount Read Blvd.
Rochester, NY
First Funding Network
(585)482-0100
2164 Hudson Avenue
ROCHESTER, NY
Rochester Home Equity Inc
(585) 263-4353
180 Office Park Way Ste 2000
Pittsford, NY
HSBC Bank
1.800.975.HSBC (4722)
Just West Of 390 2362 Lyell Ave
Rochester, NY
Citizens Bank - Panorama Plaza
585-586-1231
715 Panorama Trail
Rochester, NY
Thomas J. Antinora Jr. Agency
(585)723-8770
2230 Ridge Rd W
Rochester, NY
American General Financial Services
585-865-1130
Rochester, NY
Fairport Savings Bank - Mortgage Line
(585)223-7043
45 South Main Street
FAIRPORT, NY
Data Provided by: