How to Create a Mortgage Calculator With Microsoft Excel Mastic 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 - Riverhead
800.432.1000
499 Old Country Rd.
Riverhead, NY
Suffolk County National Bank Consumer Loan
(631)208-2222
4 West 2nd Street
Riverhead, NY
Mr. Albert F. Coletti (RFC®), CHFC, CLU
631 979 6161 x102
P.O. Box 728
Smithtown, NY
Custom Capital Corporation
(631)737-9300
1615 9 Av
BOHEMIA, NY
1st Premium Funding
(631)471-5135
20 Peachtree Ct
HOLBROOK, NY
Capital One
631-206-2930
290 Main Street
Islip, NY
Washington Mutual Bank Bohemia
(631)588-1905
3755 Veterans Memorial Hw
Bohemia, NY
JOSEPH CONBOY
P. O. BOX 449
SHOREHAM, NY
Mr. Richard A. Fallica (RFC®), CEP
631 979 6161
P.O. Box 728
Smithtown, NY
All Members Mortgage
(631)585-1360
407 Halbert
HOLBROOK, NY
Data Provided by:
    

Related Articles