How to Create a Mortgage Calculator With Microsoft Excel Elmont 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 - Jamaica Estates
800.432.1000
17557 Hillside Ave
Jamaica, NY
Helen Beichel
1133 Park Place
Brooklyn, NY
Mr. Monroe M. Diefendorf (RFC®), CFP, CHFC, CLU
516 759 3900
152 Forest Ave.
Locust Valley, NY
I-City Home Loans
(212)631-4242
313 E 14th St Unit 8
NEW YORK, NY
Bill Gallo Realty
(516)825-2000
224 West Merrick Road
VALLEY STREAM, NY
Bank of America - Riverdale
718.548.2824
3508 Johnson Ave
Bronx, NY
Ideal Mortgage Bankers Limited
(631)396-2181
225 Broadhollow Road
Melville, 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
Guaranteed Home Mortgage Company
(718)319-9845
3111 East Tremont Avenue
BRONX, NY
Data Provided by: