Serving the Quantitative Finance Community

 
User avatar
mit
Topic Author
Posts: 0
Joined: February 5th, 2005, 4:52 pm

future value

February 22nd, 2005, 4:30 am

a couple is saving $ in one account. husband puts 1000 into the account every two monthswife puts 500 into every two months toobut thier payments do not overlap, they alternatively pay every two months for 5 years.so a glance at the cashflows is like this1000 500 1000 500 1000 500 .......jan feb mar apr may junewhat is the future value after 5 years? Thank you
 
User avatar
Hens
Posts: 0
Joined: November 9th, 2004, 6:49 pm

future value

February 22nd, 2005, 9:19 am

Do you want to include interest rates?
 
User avatar
mit
Topic Author
Posts: 0
Joined: February 5th, 2005, 4:52 pm

future value

February 22nd, 2005, 9:20 am

sorry, interest rate is 0.5% coumpounded monthley.
 
User avatar
Hens
Posts: 0
Joined: November 9th, 2004, 6:49 pm

future value

February 22nd, 2005, 10:56 am

Hmmm, Well I think it's something like this, unless I'm missing something major:Sum over the 1000's payments with appropriate interest, plus the same for the 500's, so:This assumes that you only get interest on januray's money in feb. (increment the power by +1 to get interest for the whole month).This works out as $52371 (or $52720.3)I think....
 
User avatar
energydude
Posts: 0
Joined: January 21st, 2005, 6:08 pm

future value

February 22nd, 2005, 6:21 pm

= 52632.876Discount 500 one month backwards and then just do a geometric sum for periods given by t = 2n, n = 1 to 30.
 
User avatar
mensa0
Posts: 0
Joined: January 20th, 2004, 8:56 am

future value

March 8th, 2005, 11:14 am

Another fun way to do this is using a financial calculator and recognizing that there is an embedded annuity of $500 every month. Calculate the future value (FV) of this, assuming deposits are made at the beginning of each month. The FV of the entire series of deposits is:FV + FV/(1/(1.005)+1)Answer is, as others have said: $52,632.87551Just a neat way to get the solution on a financial calculator.Mike
 
User avatar
conocieur
Posts: 0
Joined: December 4th, 2004, 5:28 pm

future value

March 9th, 2005, 6:38 pm

It would be also good to take in consideration when was the first deposit done, if it was on period zero the FV would be $52,632, if it would be done on period one $52,371
 
User avatar
conocieur
Posts: 0
Joined: December 4th, 2004, 5:28 pm

future value

March 9th, 2005, 6:40 pm

I mean is it beggining or ending payment?