need help with compounding and accumulating formula...
 

Hi, :)

I am trying to do a compounding formula, 75% compounding daily and 25%
is accumulating profit daily, the thing i am finding difficult is
working out the accumulated profit as it is not being compounded... but
is derived from the daily compounded amount.

my data:
$1000
0.5% daily interest
calculated daily for 180 days
daily compounding 75%
daily profit 25%

The formulas i am using a

75% compounding
1000 * (1 + (0.5*0.75) / 365) ^ 180

and for the 25% accumulating, i am using

1000 * (1 + (120*25%) / 365) ^ 90

however this is incorrect as it is also compounding the 25% which is
not the case ( it is placed in a holding account daily and based on the
previous days compounded total), so it is accumulating daily, not
compounding daily.

Does anyone have a formula i could use to calculate the compounded and
accumulated figures for any given day after the invest, example 25
days, 45 days etc?

example after 30 days:
total compounded =
total paid (accumulated) =


Any help is much appreciated :)

Thank you, Wayne.


--
rebeat
------------------------------------------------------------------------
rebeat's Profile: http://www.excelforum.com/member.php...o&userid=24299
View this thread: http://www.excelforum.com/showthread...hreadid=379059