How to Create a Mortgage Calculator With Microsoft Excel West Islip 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 - Dix Hills SS
631-425-9520
1100 East Jericho Turnpike
Dix Hills, NY
Nationwide Insurance Cos
(631)588-2624
290 Hawkins Avenue
Ronkonkoma, NY
Mr. Michael H. Fliegelman (RFC®), CHFC, CLU
631 806 3568
5 Harborfields Ct
Greenlawn, NY
Mr. Albert F. Coletti (RFC®), CHFC, CLU
631 979 6161 x102
P.O. Box 728
Smithtown, NY
First NY Inc
(631)863-6600
143 East Main Street
SMITHTOWN, NY
Capital One
631-724-3400
143 Alexander Ave
Lake Grove, NY
Bank of America - Greenlawn
800.432.1000
47 Broadway
Greenlawn, NY
Jeffrey Lewis, CFP, ChFC
7 White Deer Court
Huntington, NY
Mr. Michael J. Goldsmith (RFC®), LUTCF
516 541 0111
549 Broadway Street Suite 201
Massapequa, NY
Mr. Richard A. Fallica (RFC®), CEP
631 979 6161
P.O. Box 728
Smithtown, NY
Data Provided by: