Calculating required rate of return for an income-generating savings account
Line one shows your 1M, a return with a given rate, and year end withdrawal starting at 25,000.  So Line 2 starts with that balance, applies the rate again, and shows the higher withdrawal, by 3%/yr.  In Column one, I show the cumulative effect of the 3% inflation, and the last number in this column is the final balance (903K) but divided by the cumulative inflation.  To summarize - if you simply get the return of inflation, and start by spending just that amount, you'll find that after 20 years, you have half your real value.  The 1.029 is a trial and error method, as I don't know how a finance calculator would handle such a payment flow. I can load the sheet somewhere if you'd like.  Note: This is not exactly what the OP was looking for. If the concept is useful, I'll let it stand. If not, downvotes are welcome and I'll delete.
Below is an instruction that describes a task. Write a response that appropriately completes the request.

### Instruction:
Calculating required rate of return for an income-generating savings account

### Response:
Line one shows your 1M, a return with a given rate, and year end withdrawal starting at 25,000.  So Line 2 starts with that balance, applies the rate again, and shows the higher withdrawal, by 3%/yr.  In Column one, I show the cumulative effect of the 3% inflation, and the last number in this column is the final balance (903K) but divided by the cumulative inflation.  To summarize - if you simply get the return of inflation, and start by spending just that amount, you'll find that after 20 years, you have half your real value.  The 1.029 is a trial and error method, as I don't know how a finance calculator would handle such a payment flow. I can load the sheet somewhere if you'd like.  Note: This is not exactly what the OP was looking for. If the concept is useful, I'll let it stand. If not, downvotes are welcome and I'll delete.