How to Create a Mortgage Calculator With Microsoft Excel Beacon 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
(845) 496-3636
74 E Main St
Washingtonville, NY
TD Bank
845-565-4001
800 Broadway
Newburgh, NY
Truran Agency Insurance
(845)279-2064
1006 Route 22
Brewster, NY
Stoneleigh Inc
(845)621-4251
559 Route 6
MAHOPAC, NY
American General Financial Services
(845)485-8881
2600 South Road
POUGHKEEPSIE, NY
HSBC Bank
1.800.975.HSBC (4722)
Across- Clocktower Common 1505 Rt 22
Brewster, NY
Citizens Bank - Wappinger Falls / SS
845-298-9468
1357 Rt 9
Wappinger Falls, NY
TD Bank
845-928-2332
260 Route 32
Central Valley, NY
Suntrust Mortgage Inc
(845)569-2195
5020 Route 9W
NEWBURGH, NY
Brookside Mortgage LLC
(845)928-9995
99 Edgewood Drive
CENTRAL VALLEY, NY