![]() The mathematical alternatives work without relying upon this add-in using no more than the standard operators plus the LOG function on occasion.įor simplicity, the discussion below focuses on scenarios where payments are made at the end of each period (ie, payments are “in arrears”). This is because some of the useful functions (eg, CUMPRINC) are not in the “basic” Excel function directory for some versions of Excel. It addresses three common calculations using Excel’s financial functions for the last item.įor completeness, my examples include the seemingly more convoluted mathematical formulas that arrive at the same answer. This article considers how to model debt repayment calculations from a practical perspective. The start of a new year is a time for planning, renewal, and figuring out how to pay off that holiday debt. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |