How to Create a Mortgage Calculator With Microsoft Excel Suffern 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

The Bank Of New York Rockland Division Banking Offices West Nyack
(845)358-2324
1 Village Square
Nyack, NY
Jared Cutler
611 Pondside Drive
White Plains, NY
Commercial Funding Corporation
(973)471-2229
335 Clifton Avenue
Clifton, NJ
Parliament Equities Inc
(914)747-9400
57 Wheeler Avenue
PLEASANTVILLE, NY
Odyssey Funding Llc
(201) 343-6100
241 Hudson St
Hackensack, NJ
TD Bank
201-337-1421
160 Ramapo Valley Road
Oakland, NJ
Black Dirt Abstract Inc
(845)987-9666
311 State Rte 94 S
Warwick, NY
Mr. Salim George Salloum (RFC®), MBA
937 389 9593
35 Teak Rd
Wayne, NJ
Walden Federal - Monroe Office
(845)782-2949
288 Larkin Drive
MONROE, NY
B P G Mortgage Corporation
(914)827-9030
5 Baltic Place Suite 2
CROTON ON HUDSON, NY
Data Provided by: