How to Create a Mortgage Calculator With Microsoft Excel Lockport 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 - Harlem Rd
800.432.1000
3842 Harlem Road Suite 1500
Cheektowaga, NY
Paul Bauer Insurance Agcy
(716)773-3901
2634 Baseline Rd
Grand Island, NY
Funding Made Easy Inc.
(716)438-2692
6823 Erica Lane
Lockport, NY
Household Finance Corporation
(716)684-2485
3729 Union Road
BUFFALO, NY
Devere Mortgage Corporation
(716) 633-3700
5400 Broadway St
Lancaster, NY
Bank of America - Depew Transit
800.432.1000
6041 Transit Rd
Depew, NY
Tonawanda Community Federal Credit Union
(716)873-4688
257 Highland Pkwy
Buffalo, NY
Allstate Insurancethomas Finn Agency
(716)873-9528
3493 Delaware Ave
Kenmore, NY
M & M Resources Unlimited
(716)873-5500
30 Military Road
BUFFALO, NY
Alden State Bank
(716)685-5090
5802 Broadway Street
LANCASTER, NY