R
rebeat
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.
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.