 Quote:
Originally Posted by jIMOh
Bumping this with a question.
Using this formula:
([starting value-.5*deposits]/[ending value+.5*desposits])-1
My 401k IRR is -29.6%
According to my 401k provider my loss was twice that (-58.8%).
**edit** this 401k transferred custodians from Vanguard (old employer) to current employer (self maintained plan with institutional funds)- could this be causing the issue?
Thoughts?
|
I think your formula is wrong. I just tried your formula on my 401k data for the year and compared it with my 401k website and also my own IRR calculation (using the Excel function).
Using your calculation I get a number wildly different from mine.
Am I using your formula wrong?
Starting value = $373,467, Ending value = $287,890.
Total deposits = $25,383
your calculation gives 20% while website gives -29%
__________________
Age and treachery will usually overcome youth and ability
Countown clock is at 9 weeks to be SIRE'd
|