Hi Curious.
I have tried to do similar calculations, but I have found that NPV is extremely sensitive to the necessary ASSUMPTIONS about earnings rates on the IRA and future inflation. Have you tried the calculations with varying earnings rates and inflation (discount) rates?
Also, many advisers recommend more conservative investments as we age and are less able to manage our financial affairs, and this would lead us to expect a lower rate of return as we get older.
I know that the inflation adjustment in SS is extremely valuable, but I don't know how to factor it into the NPV equation
I also believe that since we are concerned more with after tax spendable income than about gross income, and since SS income is still partially tax sheltered, that we also need to make assumptions about future tax rates and rules.
Bryan