I know that deep down and very well hidden the Duke is a decent skin - so he will in time, like the financial advisory community, share his full wisdom with us all!
On a serious note Duke, can you use the "upload a file" facility to share either your previous or current spreadsheet?
The point I'd like to make now is a bit peripheral to Sarenco's question but probably worth mentioning. If I understand Sarenco's situation correctly, he "has" an ARF of €600k and "needs" €10k p.a. to cover required expenses.
On the one hand, the "Authorities" are trying to promote pension provision (e.g. the introduction of mandatory PRSAs) but on the other hand, they are placing unwelcome hurdles on Mr. Normal in the form of imputed distributions. I accept that Mr. Normal does need to take money from his ARF during his decumulation phase. However, it's the almost compulsory requirement to withdraw funds on an annual basis that is problematic.
The problem is that these forced withdrawals increase sequence of returns risks and associated concerns.
In Sarenco's case, with €600k in an ARF, presumably he could take €150k as a tax free lump sum thereby providing him with multiple years of guaranteed income with the number of such guaranteed years being a function of his preferred asset allocation, i.e. investing in cash, more or less, gives him 15 years.
If Sarenco had this security (that his base needs were covered for many years and that he wasn't forced to withdraw funds at "the wrong time"), he would be so much freer to be more expansive in the asset allocation of his residual ARF investment of €450k. In simple terms, sequence of return risk would have a significantly diminished impact if Sarenco was afforded greater freedom in the timing of withdrawals in his decumulation phase.
There is a lot of data showing that the asset allocation of ARFers is too conservative given the probable long-term lifespan of such investments. It is possible that the introduction of the 3% distribution requirement in 2008 (and subsequent increases) has not been of helpful in this regard. Whatever the case, if you were to try to find a worse time to introduce this requirement, you'd be hard pressed to do so!