Easybucks

Instead of doing all this of going around, why dont' you just compound
interest concept to compute the value of the accrued amount at the end
of each day/week/month/year?

As you would know the accrued amount at the end of 'n' periods with an
annual interest rate of 'r'%' is generally given by the formula :-

P * (1 + r/(365 * 100)) ^ n

where P is the Principal amount
n is the number of periods after which the accured amount is desired
r is the annual interest rate (expressed as a fraction - a 10% rate
would be expressed as 0.1)


Hope this helps!


Best regards


Deepak Agarwal


--
agarwaldvk
------------------------------------------------------------------------
agarwaldvk's Profile: http://www.excelforum.com/member.php...o&userid=11345
View this thread: http://www.excelforum.com/showthread...hreadid=385435