need some math help.

[swl551]

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.

[Mini-Geek]

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.

[swl551]

Originally Posted by Mini-Geek

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.

Thanks. I am working on the formula now in my SQL code. I'll let you know the results...