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 are:

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.