Future Value of a daily savings account

%3CLINGO-SUB%20id%3D%22lingo-sub-1492043%22%20slang%3D%22en-US%22%3EFuture%20Value%20of%20a%20daily%20savings%20account%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492043%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20work%20out%20the%20future%20value%20of%20a%20daily%20savings%20plan%20in%201%2C%205%2C%2010%2C%2015%2C%20and%2020%20years.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20the%20%3DFV%20function%20but%20the%20trouble%20is%20this%3A%3C%2FP%3E%3CP%3EIt%20is%20based%20on%20the%2010c%20saving%20challenge%20where%20you%20multiply%20the%20day%20of%20the%20year%20by%2010c%20and%20that%20is%20what%20you%20put%20away%20that%20day.%20I%20have%20a%20savings%20account%20that%20allows%20me%20to%20do%20this%20pretty%20easily%20through%20the%20app.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DFV%20doesn't%20really%20work%20because%20it%20bases%20itself%20on%20the%20same%20amount%20for%20the%20period%20of%20investment.%20So%20the%20variables%20are%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDay%201%20-%2010c%2C%20day%202%20-%2020c%20and%20so%20on%20for%20365%20days%20then%20you%20start%20from%2010c%20again%3C%2FP%3E%3CP%3E7%25%20interest%20per%20annum%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20will%20the%20Future%20Value%20be%20in%201%2C%205%2C%2010%2C%2015%2C%20and%2020%20years.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20it%20is%20a%20combination%20of%20%3DFV(rate%2C%20nper%2C%20pmt%2C%20%5Bpv%5D%2C%20%5Btype%5D)%20and%26nbsp%3B%3CSPAN%3E%3DPMT%20*%20((1%2Bi)%5En%20-%20(1%2Bj)%5En)%20%2F%20(i-j)%20but%20I%20don't%20know%20how%20to%20adjust%20it%20to%20a%20daily%20increase%20of%20an%20amount%20and%20not%20a%20percentage.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EAny%20help%20would%20be%20appreciated.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1492043%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1492889%22%20slang%3D%22en-US%22%3ERe%3A%20Future%20Value%20of%20a%20daily%20savings%20account%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492889%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F711270%22%20target%3D%22_blank%22%3E%40Beanis%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20you%20end%20your%20request%20with%20the%20statement%20%3CEM%3E%22Any%20help%20would%20be%20appreciated%22%3C%2FEM%3E%20I'm%20going%20to%20take%20you%20at%20your%20word%20and%20not%20try%20to%20actually%20solve%20it%20(although%20I'll%20be%20interested%20in%20the%20solution)...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20were%20in%20your%20place%2C%20I'd%20look%20at%20one%20of%20the%20cash%20flow%20functions.%20%3CSTRONG%3EIRR%3C%2FSTRONG%3E%20and%20%3CSTRONG%3EXIRR%3C%2FSTRONG%3E%20in%20particular%20seem%20suited.%20I%20use%20the%20latter%20in%20calculations%20involving%20an%20irregular%20series%20of%20returns%20for%20some%20investment%20strategies%20where%20there%20are%20cash%20transactions%20both%20in%20and%20out%20to%20consider%2C%20varying%20amounts.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20not%20a%20simple%20or%20single%20formula%20that%20it%20relies%20on%2C%20but%20a%20series%20of%20transactions%2C%20and%20given%20your%20situation%2C%20you%20may%20need%20(absent%20some%20formula%20based%20on%20calculus%20perhaps)%20to%20just%20set%20forth%20a%20daily%20%22deposit%22%20next%20to%20a%20series%20of%20dates....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOK%2C%20as%20I%20said%2C%20I'll%20be%20interested%20and%20now%20that%20I've%20responded%20I'll%20be%20able%20to%20see%20what%20other%20Excel%20folks%20come%20up%20with.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20fun!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi All

 

I want to work out the future value of a daily savings plan in 1, 5, 10, 15, and 20 years.

 

I have tried the =FV function but the trouble is this:

It is based on the 10c saving challenge where you multiply the day of the year by 10c and that is what you put away that day. I have a savings account that allows me to do this pretty easily through the app.

 

=FV doesn't really work because it bases itself on the same amount for the period of investment. So the variables are this:

 

Day 1 - 10c, day 2 - 20c and so on for 365 days then you start from 10c again

7% interest per annum

 

What will the Future Value be in 1, 5, 10, 15, and 20 years.

 

I know it is a combination of =FV(rate, nper, pmt, [pv], [type]) and =PMT * ((1+i)^n - (1+j)^n) / (i-j) but I don't know how to adjust it to a daily increase of an amount and not a percentage.

 

Any help would be appreciated.

1 Reply

@Beanis 

 

Since you end your request with the statement "Any help would be appreciated" I'm going to take you at your word and not try to actually solve it (although I'll be interested in the solution)...

 

If I were in your place, I'd look at one of the cash flow functions. IRR and XIRR in particular seem suited. I use the latter in calculations involving an irregular series of returns for some investment strategies where there are cash transactions both in and out to consider, varying amounts.

 

It's not a simple or single formula that it relies on, but a series of transactions, and given your situation, you may need (absent some formula based on calculus perhaps) to just set forth a daily "deposit" next to a series of dates....

 

OK, as I said, I'll be interested and now that I've responded I'll be able to see what other Excel folks come up with.

 

Have fun!