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

Jeffrey Lewis, CFP, ChFC
7 White Deer Court
Huntington, NY
Mr. Michael H. Fliegelman (RFC®), CHFC, CLU
631 806 3568
5 Harborfields Ct
Greenlawn, NY
Mr. Richard A. Fallica (RFC®), CEP
631 979 6161
P.O. Box 728
Smithtown, NY
Long Island Commercial Bank
(631)851-8888
320 Carleton Avenue
CENTRAL ISLIP, NY
Ameristar Mortgage
(631)621-1200
534 Broadhollow Road
MELVILLE, NY
Capital One
631-254-2500
1383 Deer Park Ave
North Babylon, NY
JOSEPH CONBOY
P. O. BOX 449
SHOREHAM, NY
Mr. Albert F. Coletti (RFC®), CHFC, CLU
631 979 6161 x102
P.O. Box 728
Smithtown, NY
Wells Fargo Home Mortgage
(631)777-5900
1 Huntington Quadrangl
MELVILLE, NY
Great Source Mortgage LLC
(631)271-8123
790 New York Av
HUNTINGTON, NY
Data Provided by: