investment formula help

Greetings,

I am working on a spreadsheet to better understand my retirement finances.

I plan on retiring at 65, and lets say the following assumptions are true:

I will have $1,000,000 saved up when i retire.

I plan on living until I am 90 years old.

I plan on living only on this $1M savings until I die.

When I retire I put my $1,000,000 into a savings fund that earns 6% return annually until I die.

I am trying to build a formula to help me answer the following question:

How much money do I have to live on each year until I die?


Thank you in advance for any help on this.

Hello,

Nice savings

Well, this was the calculus I have come to.

Please have in mind the following assumption:

. Your annually return tax will be fixed at 6% (not decrease) even deducting your yearly expenses with your retire, which is odd - usually this doesn't happens, at least it doesn't I where live

. Probably what would happen is that you will be get less than those 6% in the following years which will modify these calculus.


Kind Regards,
FCarv

bump bump bump

Wow, I really loved your feedback. (sarcasm)
It was so gentle, with a detailed explanation on which requirements were not fulfilled.

Anyway, compiling all of the calculus I have made in the previous file into one unique formula was tougher than I thought at the beginning. And so far I have not reached a solution.

I know how to get the future value, but can't figure it out on how to add the necessary variables to that value.

Future Value as FV

Please Login or Register  to view this content.

PV as Present Value
R as Interest Rate
N as Number of periods

The necessary Variables are:

• Yearly Expenditures
• Decreased Countdown of years (from 26 to 1)

If anyone could help with the rest of the formula or a totally different approach/solution, it would be awesome.


Rgds,
FCarv