(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:
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.