Loan amortization schedule excel

broken image
broken image
broken image

Suppose you are considering making a purchase funded by a loan, such as taking out a mortgage to buy a house.

broken image

Functions are fully VB-compliant and may be used in any VBA or VB project (including, but not only, Excel) Two functions that return an array with the amortization schedule for a loan, based on loan terms and payment style. Functions to return a loan amortization schedule in an array

broken image