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

Citizens Bank - Poughkeepsie SS
845-431-6870
2540 South Rd.
Poughkeepsie, NY
M And T Bank Branches Hopewell Junction
(845)221-9161
424 Route 376
Hopewell Junction, NY
General Advisory & Funding Corp
(914)245-0046
505 Manchester Rd
YORKTOWN HEIGHTS, NY
CTX Mortgage CO Inc
(845)564-5500
6 Jeanne Drive
NEWBURGH, NY
Citifinancial
(845)297-3920
1839 South Road
WAPPINGERS FALLS, NY
HSBC Bank
1.800.975.HSBC (4722)
Across- Clocktower Common 1505 Rt 22
Brewster, NY
Wells Fargo - Peekskill
914-737-3100
920 South St
Peekskill, NY
Horizon Financial Groupinc.
(845)485-1853
45 Clark St
Poughkeepsie, NY
Diamond Candle CO Inc
(845)562-5000
70 John Street
NEW WINDSOR, NY
Citifinancial
(845)896-0290
738 Route 9
FISHKILL, NY