Join Early Retirement Today
Thread Tools Search this Thread Display Modes
Calculating rate of return
Old 01-03-2021, 02:18 PM   #1
Thinks s/he gets paid by the post
SumDay's Avatar
Join Date: Aug 2012
Posts: 1,843
Calculating rate of return

Seems I have seen a thread on calculating end of year rate of IRA return when you're also making withdrawals. Was it a spreadsheet, or just a simple formula? Search hasn't been any more helpful than my brain. Forgive my aging mind, but if someone would be willing to share I'd be very appreciative. TIA
FIRE Class of 2018 @ 61

Old men and women sit in the shade of trees they planted long ago
SumDay is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 01-03-2021, 02:55 PM   #2
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Join Date: Aug 2004
Location: Laurel, MD
Posts: 7,435
I think you’re looking for final balance minus additions divided by starting balance plus withdrawals. It assumes the withdrawals and additions occur evenly throughout the year. Some use an Excel formula (XIRR I think ) but some like the money chimp calculator.
...with no reasonable expectation for ER, I'm just here auditing the AP class.Retired 8/1/15.
jazz4cash is offline   Reply With Quote
Old 01-03-2021, 03:23 PM   #3
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
RunningBum's Avatar
Join Date: Jun 2007
Posts: 12,655
You might find that your holding company does it for you more accurately than a formula assuming evenly distributed withdrawals. Vanguard does it for me.

What's your purpose in knowing? I stick mostly with index funds, and don't try to beat the market. I make sure my funds are tracking closely to their index, and don't have high expenses. Other than that, I'm looking out of interest, not for anything to take action on. With VPW, I use my year end balance to set my new year's spending target. My investment return has a large bearing on whether my spending budget can increase or not, but I don't use the return to calculate it.
RunningBum is offline   Reply With Quote
Old 01-03-2021, 04:46 PM   #4
Full time employment: Posting here.
Join Date: Jul 2014
Location: Undisclosed
Posts: 948
I use the excel XIRR function.
N02L84ER is offline   Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How is Year to Date Return Different from 2016 Return? nico08 FIRE and Money 4 11-12-2016 09:44 AM
Kitces: / Managing Sequence Of Return Risk With Bucket Strategies Vs A Total Return macav933 FIRE and Money 21 12-06-2014 09:38 AM
Calculating withdrawal rate David1961 Life after FIRE 39 04-09-2014 07:45 AM
Need Help Calculating Nominal Rate of Return gyropilot FIRE and Money 4 11-30-2012 11:46 AM
Rookie Question - Calculating withdrawal rate shotgunner FIRE and Money 23 12-04-2009 07:27 PM

» Quick Links

All times are GMT -6. The time now is 10:34 PM.
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2023, vBulletin Solutions, Inc.