![]() The next thing you do is to create an amortization table with the labels ( Period, Payment, Interest, Principal, Balance) in A7:E7. Set up the amortization tableįor starters, define the input cells where you will enter the known components of a loan: Now, let's go through the process step-by-step. ![]() IPMT function - finds the interest part of each payment that goes toward interest.This amount increases for subsequent payments. PPMT function - gets the principal part of each payment that goes toward the loan principal, i.e.This amount stays constant for the entire duration of the loan. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |