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

State Farm Insurance
(516)433-4275
391 South Broadway
Hicksville, 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
American Liberty Mortgage
(516)377-1995
2795 Milburn Av
BALDWIN, NY
Chase Bank
(914) 251-3302
2900 Westchester Avenue
Purchase, NY
P Geyer Co Inc
(718)821-1700
801 Woodward Ave
Ridgewood, NY
Jared Cutler
611 Pondside Drive
White Plains, 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
Data Provided by:
      

Related Articles