This formula goes to column D, beginning in D8: The syntax and arguments are exactly the same as in the IPMT formula discussed above: To calculate the principal part of each periodic payment, use this PPMT formula: This formula goes to C8, and then you copy it down to as many cells as needed: This argument is supplied as a relative cell reference (A8) because it is supposed to change based on the relative position of a row to which the formula is copied. To find the interest part of each periodic payment, use the IPMT(rate, per, nper, pv,, ) function:Īll the arguments are the same as in the PMT formula, except the per argument that specifies the payment period. Please pay attention, that we use absolute cell references because this formula should copy to the below cells without any changes.Įnter the PMT formula in B8, drag it down the column, and you will see a constant payment amount for all the periods: Putting the above arguments together, we get this formula:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |