The Math Behind Excel’s CUMIPMT() & CUMPRINC() Functions

I published the math behind the CUMIPMT() & CUMPRINC() functions at the bottom of my spreadsheet for the post Annuity – Excel Functions and Math. I think it got lost in all the annuity math. When I Google the math for these two functions, my blog doesn’t show up until the 6th or 7th page, depending on the wording of the search. I see the question asked without a real answer, so I am posting the formulas again by themselves. I am also doing it because it is my blog and I can.

Download “CUM

 

cum1

Also the math for a single row of a simple amortization schedule:

cum2Download “CUM

Comments

    1. Don Pistulka Don Pistulka says:

      You’re welcome Shawnta,

      This post may be helpful also:
      Math for amortization rows with CPR, Servicing, CDR, & Loss SeverityMath for amortization rows with CPR, Servicing, CDR, & Loss Severity

  1. dsfsdsdfsfd says:

    Exactly what I was looking for. Thanks!

    1. Don Pistulka Don Pistulka says:

      Glad I could help

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*

WordPress spam blocked by CleanTalk.