yes you are right. No doubt I could not work out, I was trying to use NPER.

Hi umesh,

I may well have used the wrong function (FV would probably have been better than PV) and I probably used some different assumptions. For example, whether interest is calculated monthly, whether the super gurantee is taxed, etc. The whole point of the exercise was to show that the calculations can be done in a single cell - you just need to choose the right function(s) and combine the inputs the right way.

As I said before, I'm not an actuary. I also don't have any data to evaluate my results against. Neither do I know anything of how your system is programmed, how the tax rates apply to the different components. Without such info, I'm unlikely to end up with the same results or, just as importantly, to be able to explain why mine differ.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]