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

Paragon Mortgage
(516)334-2240
393 Old Country Rd
Carle Place, NY
Cntrywdefsl
(631)300-4390
100 Motor Pkwy
Hauppauge, NY
Allstate Insurance Anthony S. Furnari
(516)333-4300
160 Post Ave
Westbury, 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
HSBC Bank
1.800.975.HSBC (4722)
Corner Of S.Longbeach Rd 215 W. Merrick Rd.
Freeport, NY
Richard Downing And Sons
(516)922-0592
1057 Jericho Oyster Bay Rd
East Norwich, NY
Jenkins John B Insurance
(516)627-0001
21 George Street
Manhasset, 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
Data Provided by: