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: The fv and type arguments can be omitted since their default values work just fine for us (balance after the last payment is supposed to be 0 payments are made at the end of each period).For the pv argument, enter the loan amount ($C$5).Nper - multiply the number of years by the number of payment periods per year ($C$3*$C$4).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |