How to Create a Mortgage Calculator With Microsoft Excel Babylon 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. Monroe M. Diefendorf (RFC®), CFP, CHFC, CLU
516 759 3900
152 Forest Ave.
Locust Valley, NY
Mr. Albert F. Coletti (RFC®), CHFC, CLU
631 979 6161 x102
P.O. Box 728
Smithtown, NY
Su Casa Real Estate
(631)271-3030
1927 New York Avenue
HUNTINGTON STATION, NY
American Dream Mortgage Bankers
(516)626-0040
1800 Northern Boulevard Suite 114
ROSLYN, NY
Bank of America - Bethpage
800.432.1000
521 Stewart Ave
Bethpage, 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
Mr. Richard A. Fallica (RFC®), CEP
631 979 6161
P.O. Box 728
Smithtown, NY
Security Atlantic Credit Corporation
(516)932-7800
420 Jericho Turnpike Suite 333
JERICHO, NY
Data Provided by:
    

Related Articles