20140220, 15:34  #1 
Aug 2012
New Hampshire
2·13·31 Posts 
need some math help.
Sorry for this, but you guys are the only ones that I know that can really help me organize this matrix into an accurate mathematical formula.
The person who put this matrix together does not have a formula, they just manually carry values over from one month to the other. The goal is to calculate the Base Fee + Penalty compounded 1.5% for each month late. I know it is probably simple, but MATH and I just are not friends. 
20140220, 15:51  #2 
Account Deleted
"Tim Sorbera"
Aug 2006
San Antonio, TX USA
4267_{10} Posts 
Attached is an Excel spreadsheet that comes up with the same final number you have. The main formulas are:
Fee = last Total INTEREST = Fee * Percent Total = Fee + INTEREST If you want to calculate the interest for n months at a time (compounded monthly), calculate (1+Percent)^n, e.g. 1.015^12=1.1956..., and 200*1.1956... = 239.12 (the total at 16 Apr 2011) If there's some other mathematical formula you're looking for, I'm not sure what it is exactly. Last fiddled with by MiniGeek on 20140220 at 15:56 
20140220, 16:33  #3  
Aug 2012
New Hampshire
326_{16} Posts 
Quote:


Thread Tools  
Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
I am so sorry for being bad at math.  Aramis Wyler  Math  40  20141218 11:15 
Math  ET_  Operazione Doppi Mersennes  4  20120920 19:33 
Math  JohnFullspeed  Forum Feedback  1  20110711 16:42 
math help pls!  DSC  Miscellaneous Math  2  20050911 04:53 
help with math  DSC  Homework Help  13  20050831 07:16 