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

Bank of America - Williamsburg
718.599.3078
47 Graham Ave
Brooklyn, NY
Helen Beichel
1133 Park Place
Brooklyn, NY
Mr. Michael H. Fliegelman (RFC®), CHFC, CLU
631 806 3568
5 Harborfields Ct
Greenlawn, NY
Mr. Michael J. Goldsmith (RFC®), LUTCF
516 541 0111
549 Broadway Street Suite 201
Massapequa, NY
H S & M Realty
(718)940-8440
1451 Nostrand Ave
BROOKLYN, NY
Capital One
516-354-7310
1999 Marcus Ave
Lake Sucess, NY
Washington Mutual Bank Locations Queens Bayside
(718)428-0261
3839 Bell Boulevard
Bayside, NY
Jeffrey Lewis, CFP, ChFC
7 White Deer Court
Huntington, NY
Mr. Monroe M. Diefendorf (RFC®), CFP, CHFC, CLU
516 759 3900
152 Forest Ave.
Locust Valley, NY
Household Finance Corporation
(718)597-1300
68 Westchester Square
BRONX, NY
Data Provided by: