Results 1 to 8 of 8
  1. #1
    3 Star Lounger baumgrenze's Avatar
    Join Date
    Feb 2001
    Location
    California, USA
    Posts
    262
    Thanks
    6
    Thanked 0 Times in 0 Posts

    IRA Minimum Distrubtion Calculator (MRD) (2000 (9.

    (Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

    I set out to create a spread sheet that would allow me to calculate the minimum required distribution on my IRA. I'm not a macro programmer, so I entered the needed values the hard way. I took the actuarial table of divisors that generate the MRD from the IRS Publication 590. I wanted to provide for the possibility of also making partial Roth IRA conversions. I've attached a copy I created using a capital nest egg of $100,000 for illustrative purposes.

    To check my results, I entered the same capital nest egg at:

    http://personal.fidelity.com/retirement/re.../mrdframe.shtml

    My results differ from theirs. I can't see how they do their calculation. I did mine by adding 5% and 4% to the initial capital in compound fashion. Since I was born in March 1940, I begin distributions in 2010. Once distributions commence, I subtract them from the new balance before calculating the next distribution. The example contains no Roth conversions. Were they there, they would be subtracted out just like the distribution.

    Can anyone see if I've done anything wrong? I'd like to share this calculator with others, but I'd like to know that I am doing it right.

    Thanks,
    Baumgrenze
    Hier sind wir tief eingewurzelt.

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: IRA Minimum Distrubtion Calculator (MRD) (2000

    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17>Nobody will be able to see what you might have done wrong until you attach the file. A link to IRS Pub 590 would also be helpful.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    3 Star Lounger baumgrenze's Avatar
    Join Date
    Feb 2001
    Location
    California, USA
    Posts
    262
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: IRA Minimum Distrubtion Calculator (MRD) (2000

    I could have sworn I browsed for the spreadsheet before I posted last time. Perhaps I forgot and did a last preview and lost it. I'll try to do better this time.

    I tried extracting the first page and the table page from Pub 590 as an Acrobat file, but it is still 897 kb so I cannot attach that.

    It is found here:

    http://www.irs.gov/formspubs/lists/0,,id=97819,00.html

    but one must scroll down to it, select it, and then download it.

    To save people the bother, I copied the table and relevant instructions and pasted them into a Word document. I'll attach that, too.

    Thanks again,
    Baumgrenze
    Hier sind wir tief eingewurzelt.

  4. #4
    3 Star Lounger baumgrenze's Avatar
    Join Date
    Feb 2001
    Location
    California, USA
    Posts
    262
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: IRA Minimum Distrubtion Calculator (MRD) (2000

    It was not clear if I could attach two files to one post. I did not see where the attachments were recorded until I edited the above post and attached only one file. The Word document is attached to this post.

    Thanks,
    Baumgrenze
    Hier sind wir tief eingewurzelt.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: IRA Minimum Distrubtion Calculator (MRD) (2000

    You can specify only one attachment to a post. If you want to attach multiple files, you can create a zip file containing them, and attach the zip file.

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: IRA Minimum Distrubtion Calculator (MRD) (2000

    it's easy to lose the attachment on initial posting.

    It would be less load on the Lounge to provide a reference to the publication: http://www.irs.gov/pub/irs-pdf/p590.pdf , rather than an attachment. Loungers, be warned that this is a large document.

    The instructions for calculation of the MRD seem simple, though it's not very clear which table to use.
    -John ... I float in liquid gardens
    UTC -7ąDS

  7. #7
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: IRA Minimum Distrubtion Calculator (MRD) (2000

    <P ID="edit" class=small>(Edited by JohnBF on 30-Jul-07 08:35. )</P>OK, the answer is simple:

    1. Your calcs have an error in that the first required distribution is at age 70.5, yours begin in year 71.
    2. The Fidelity Calculations are based on using Table III, which most frequently applies. (Their calculation in cell J9 is cell D8
    -John ... I float in liquid gardens
    UTC -7ąDS

  8. #8
    3 Star Lounger baumgrenze's Avatar
    Join Date
    Feb 2001
    Location
    California, USA
    Posts
    262
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: IRA Minimum Distrubtion Calculator (MRD) (2000

    Thank you John,

    The answer is that I was tired and made another major error. I copied and pasted values from the IRS table starting at age 86 and pasted them starting at age 70. I must have been scrolled part way down the worksheet with the IRS table in it.

    Lesson #1, just like in skiiing, do not try another run if you are tired. You can get into trouble!

    Thanks,
    Baumgrenze
    Hier sind wir tief eingewurzelt.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •