Sunday, 5 January 2014

Formula and Derivation for CUMPRINC and CUMIPMT in excel

CUMIPMT and CUMPRINC  are two neat formulas that excel provides to calculate the cumulative Principal paid between two periods and cumulative  Interest paid between two periods respectively.

Now these formula are not available in all software we use. For example Tableau does not have it. So when I was writing the blog "Advantage; Homeloan" using the tool I had to derive the formulas myself. If you need to use them here are the formulas with derivation. (sorry did not have the patience to make re do this on the system)


                  

This is Appendix Just in case you need it


Posted by at
Labels: , , , , , , ,

4 comments:

  1. Smolkaville21 April 2014 at 12:49

    This would be so helpful...if only it was typed out...

    ReplyDelete
  2. Akshay Kadidal5 July 2014 at 12:13

    Thanks for the input....I know it could have been helpful i wish i was able to do it......but the time i would spend typing it out is way too much...
    let me know if there is a tool that makes writing math equations easy

    ReplyDelete
  3. Unknown25 April 2016 at 17:22

    Could you please tell me what is "a" in formula page 2 (In = ...). I am trying to figure it out but have a problem.

    Thanks
    -Seyed

    ReplyDelete

Subscribe to: Post Comments (Atom)

Was this useful Information?