Date money is gone function

[feldkatc]

Hi! I am hoping someone can help me with a function. I have a sheet that has a dollar amount. I withdrawal a certain amount each month, but the account does have a rate of return. An example is below. I want to have the F1 cell populate with the date the money runs out. I am completely lost!Attachment 698344

[alansidman]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[MrShorty]

How much of your question is Excel programming (you know how to perform this calculation in other ways, but need help programming in Excel) and how much is generic finance (you don't know how to do this in any way)?

It looks like a basic present value/future value type problem solving for nper (present value = 10000, rate = 0.06, payment = 210, future value = 0, nper = ??). Assuming that a basic present value model is the correct financial model for this, you could use the NPER() function for this (=NPER(0.06,210,10000,0)) to get the number of periods. I'm assuming that your 6% interest rate is monthly (if it is annual, then you need to convert it to a monthly rate however you typically do that).

If this is mostly about Excel programming, the PV() function help file describes the equation that is used: https://support.microsoft.com/en-us/...rs=en-us&ad=us
The NPER() function help file: https://support.microsoft.com/en-us/...rs=en-us&ad=us

There are several places with more information about the present value/future value financial model, if you need more help understanding the financial model.