How to Create a Mortgage Calculator With Microsoft Excel Hilton 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
(585) 637-3946
66 Main St
Brockport, NY
Citizens Bank - Franklin Street NY
585-258-3105
40 Franklin Street
Rochester, NY
First Choice Funding Westside
(585)865-0615
34 Buckman Road
Rochester, NY
Mr. Gregory Lee Schaffer (RFC®), CFP
585-621-3300
3205 Mount Read Blvd.
Rochester, NY
The Bank of Castile
(585)889-0170
3252 Chili Avenue
CHURCHVILLE, NY
HSBC Bank
1.800.975.HSBC (4722)
Marketplace Mall 3740 West Henrietta Rd
Rochester, NY
Chase Bank
(585) 247-5840
6 Spencerport Rd
Rochester, NY
Equtele Enterprises Inc
(585)428-9080
39 West Main Street
Rochester, NY
The Cray Agency
(716)383-8420
1040 University Ave
Rochester, NY
American General Financial Services
585-865-1130
Rochester, NY
Data Provided by: