How to Create a Mortgage Calculator With Microsoft Excel Penfield 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 - Chili Center
585-247-0900
800 Paul Road
Rochester, NY
National Bank Of Geneva Victor
(585)742-2000
3 West Main Street
Victor, NY
Territory Inc - Mainline
(585)223-7777
7374 Pittsford Palmyra Road
FAIRPORT, NY
Citibank (New York State)
(585)473-9080
1441 Monroe Avenue
ROCHESTER, NY
Nothnagle Home Securities Corp
(585) 461-4110
217 W Main St Ste 200
Rochester, NY
HSBC Bank
1.800.975.HSBC (4722)
1829 Chili Ave
Rochester, NY
The Cray Agency
(716)383-8420
1040 University Ave
Rochester, NY
Mr. Gregory Lee Schaffer (RFC®), CFP
585-621-3300
3205 Mount Read Blvd.
Rochester, NY
Citibank (New York State)
(585)586-8953
3330 Monroe Avenue
EAST ROCHESTER, NY
Prospect Mortgage Llc
(585) 419-4103
80 Office Park Way
Pittsford, NY
Data Provided by: