I got it!

=PMT((PV(inflation,1,-(interest rate-inflation rate)*100,0)/100),years to
last,-current value,0,1)



"Ted Metro" wrote:

Thanks, yeah I'm tired it is ---- 12,560.

Something is very close, but not quite right because the error in that
formula becomes magnified as I use longer time horizons in the calculator.
That gives me a place to experiment though, thanks for the lead.

"JE McGimpsey" wrote:

Not sure how you got 12,805 - the web calculator gives me 12,560.

Which would correspond (approximately) with

=PMT((5%-4%),2,-25000,0,1) === 12,562.19



In article ,
Ted Metro wrote:

I can't figure out the formula to get this calculator to work
http://www.smartmoney.com/retirement...tory=moneylast

I've tried combining the payment and PV functions and I can get it to work
if return is 0% with some inflation rate, but I can't figure out hot to
factor the two together.

If a portfolio is equal to 25,000 and it has to last 2 years (24 periods)
given a rate of return of 5% and an inflation rate of 4% the maximum yearly
withdrawal is
$12,805.

What is the formula in Excel to generate this number?