![]() =IPMT(rate, current period, number of total periods, initial loan value) Unlike the PMT() formula, it needs to know what period in the loan the formula is being applied for. IPMT() – This function calculates the portion of the payment applied to interest in a given period. =PMT(rate, number of total periods, initial loan value) This is the most complex financial function, and is described in further detail on another post. PMT() – This function calculates the payment on a loan for all periods in the loan. As a result, there will be more focus on the non-financial formulas. ![]() These formulas will already be set up on the spreadsheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |