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

Chase Bank
(914) 251-3302
2900 Westchester Avenue
Purchase, NY
Washington Mutual Bank Locations Franklin Square North Franklin Sq
(516)328-1742
186 New Hyde Park Road
Franklin Square, NY
Jared Cutler
611 Pondside Drive
White Plains, NY
Mr. Michael H. Fliegelman (RFC®), CHFC, CLU
631 806 3568
5 Harborfields Ct
Greenlawn, NY
Rkm Mortgage
(201)244-9000
111 Washington Avenue
Dumont, NJ
Bank of America - East Hills
800.432.1000
1 Old Westbury Rd
Roslyn Heights, NY
P Phillips
(718)545-4700
Phillips Brokerage Inc
Astoria, NY
Jeffrey Lewis, CFP, ChFC
7 White Deer Court
Huntington, NY
Mr. Jonathan P. Delo (RFC®), CFP
845 893 0073
200 Business Park Dr Ste 308
Armonk, NY
Mr. Monroe M. Diefendorf (RFC®), CFP, CHFC, CLU
516 759 3900
152 Forest Ave.
Locust Valley, NY
Data Provided by: