Forum Discussion
Question on Calculations
Hi Joe,
for clarification the premise is January 1, 2008 a deposit is made of 300k, and a withdrawal done the same day of 4%. Then the full calendar year would result in a lose of 30%.
Each corresponding year, 4% is withdrawn on the 1st day of the calendar year.
you are also correct, I meant the account loses 3% in value.
would that change the overall formulas being used?
phairiston wrote: ``[initially] a deposit is made of 300k, and a withdrawal done the same day of 4%``
That seems unlikely. More likely: the starting balance is 300,000 (i.e. previous-year ending balance).
In any case, you want withdrawals at the beginning of the year; and the year-end gain/loss is based on the net balance after the withdrawal.
Formulas:
C3: =ROUND(G2*B3,2)
D3: =ROUND(G2+C3,2)
F3: =ROUND(D3*E3,2)
G3: =ROUND(D3+F3,2)
See the attached Excel file.