Future Value Problem, right? « Next Oldest | Next Newest »

 ▼ Anthony Baldwin Junior Member Posts: 1 Threads: 1 Joined: Jan 1970 01-25-2010, 07:45 PM I'm trying to understand how to approach this problem using an HP12C. Suppose you deposit \$2,500 at the end of year 1, nothing at the end of year 2, \$750 at the end of year 3, and \$1,300 at the end of year 4. Assuming that these amounts will be compounded at an annual rate of 9 percent, how much will you have on deposit at the end of five years? When I enter CF0 as 0 n=5 I=9 CFj1 as 2500 CFj2 as 0 CFJ3 as 750 CFJ4 as 1300 CFj5 as 0 (since it in year 5 there's no mention of a deposit). Shouldn't I be able to solve for FV? I'm not getting a result (other than 0, even if I don't enter CFj5 at all). Please advise. Thanks. AB ▼ Don Shepherd Posting Freak Posts: 1,392 Threads: 142 Joined: Jun 2007 01-25-2010, 08:41 PM Anthony, I'm certainly no expert in these things, but reviewing the 12c manual, it seems that cash flows (CF0, CF1-) are related to NPV, not the TVM functions. I'd read the manual on NPV, it seems like that's what you want to use, not FV. ▼ Dave Britten Member Posts: 247 Threads: 26 Joined: Oct 2007 01-25-2010, 10:04 PM After your enter your cash flows and calculate NPV, just store that value in PV and solve for FV as usual. I get -5,837.03 as expected. (Make sure PMT is 0.) Disclaimer: I majored in computer science, not finance! This approach might not work in all cases. Peter A. Gebhardt Member Posts: 174 Threads: 20 Joined: Sep 2006 01-25-2010, 08:53 PM Anthony, I can't resist: "At least enough money to buy an HP 17b+ ..." ;-)) Now for the serious part of my answer: Because your trusty 12c doesn't have a routine for calculating NFV directly (thats the FV counterpart in he world of irregular cash-flows), you should be able to help yourself, by calculating NFV == NPV*(1+9/100)^5 Best regards, Peter A. Gebhardt Chuck Senior Member Posts: 320 Threads: 59 Joined: Dec 2006 01-25-2010, 09:20 PM Here's a possible, albeit inelegant way (I've only used the 12C about 5 times so dont know the "business" way to do it). ```2500 STO 1 1.09 STO x 1 1.09 STO x 1 750 STO + 1 1.09 STO x 1 1300 STO + 1 1.09 STO x 1 RCL 1 ``` I'm sure there's a better way. However, on the Casio 9860, put {2500, 0, 750, 1300,0} into List1, 9% into I% and press NFV; Voila. I'm still getting used to the Casio (versus HP's), but it's a pretty versatile little bugger. Chuck Edited: 25 Jan 2010, 9:22 p.m. David Hayden Senior Member Posts: 528 Threads: 40 Joined: Dec 2008 01-25-2010, 09:25 PM I know barely enough finance to balance my checkbook, but it seems to me that you can calculate this one by hand. You just have to consider the deposits individually. Note that everything is deposited at the *end* of the year, so we're really talking about a 4 year span (from the end of year 1 to the end of year5). Also I'm assuming that the compounding period is 1 year. The problem states the rate, but not the compounding period. ```\$2,500 earns 9% for 4 years. 2500*1.09^4 = 3528.95 \$750 earns 9% for 2 years. 750*1.09^2 = 891.08 1300 earns 9% for 1 year. 1300*1.09 = 1417 ``` Summing to totals gives \$5837.03 at then end of 5th year. Dave Vieira, Luiz C. (Brazil) Posting Freak Posts: 4,027 Threads: 172 Joined: Aug 2005 01-25-2010, 11:01 PM Hi; some years ago I was asked about how to compute the net future value in an HP12C, as the NFV is available in almost all other financial calcs after the HP12C and with more computing power: HP18C, 19B, 17B, 19BII, 17BII, and so. (I am not sure if the HP27S has it). The solution is trivial and already mentioned: compute NPV (net present value) with the given cash flow data and apply compound interest rate to the computed NPV (as PV) given that [n] (number of periods) matches the summation of all Nj. So, after entering all cash flow data and given [i] (interest rate), the program should automatically compute NPV, store the summation of all Nj in [n] then compute [FV], thus NFV. The program computes the summation of all Nj in the stack prior to store it in [n]. Then [PMT] is set to zero prior to compute FV. Here is the listing:```f [NPV] RCL [n] 0 RCL g [Nj] + RCL g [CFj] Rv RCL [n] g [x=0] g [GTO] 13 if 12C Platinum: GTO 013 Rv g [GTO] 04 if 12C PLatinum: GTO 004 + STO [n] 0 [PMT] [FV] x<>y [n] Rv CHS g GTO 00 if 12C Platinum: GTO 000 Obs: Rv - roll-down key x<>y - x exchange y key Key the program in starting at step #01, otherwise [GTO] data should be adjusted.```If everything is fine, last step is #22. To compute NFV, just follow the cash flow routine to store data, key the interst rate and press [i], then press```[GTO] 00 [R/S]``` The expected NFV should be in the display. Please, let me know if it works as expected. Cheers. Luiz (Brazil) Edited: 25 Jan 2010, 11:30 p.m. cyrille de Brébisson Member Posts: 193 Threads: 10 Joined: Mar 2008 01-26-2010, 09:23 AM hello, this is not a FV, but a NFV (Net Future Value) Problem. you can either move to a calcualtor that suports NFV, may I propose the 20 or 30b? if you are dead set on using the 12c, you can calculate the NPV (Net Present Value). then plug the NPV as PV in the TVM calculation, and use the TVM functions to calcualte FV. regards, cyrille Eddie W. Shore Posting Freak Posts: 764 Threads: 118 Joined: Aug 2007 01-26-2010, 09:45 AM I confirm with the others: enter the cash flow, compute the NPV, use the result for PV (I change signs first), then compute the FV. I used the 17BII+ (silver) to verify the results of \$5,837.03. Vieira, Luiz C. (Brazil) Posting Freak Posts: 4,027 Threads: 172 Joined: Aug 2005 01-26-2010, 01:01 PM Hi, all; just to remind that computing TVM´s [FV] as for NFV right after entering cash flow data with [CFo] and [CFj] and computing [NPV] is only valid when none of the cash flow repeats. If at least one of the cash flows has [Nj] > 1, than [n] must be adjusted prior to compute NFV with [FV]. Cheers. Luiz (Brazil) Edited: 26 Jan 2010, 8:44 p.m. tony (nz) Member Posts: 93 Threads: 2 Joined: Jul 2005 01-26-2010, 03:57 PM Hi this just worked on my trusty Victor 12c clone: 0 CF0 1300 CFj 750 CFj 0 CFj 2500 CFj 9 ENTER 1.09 / CHS i NPV = 5837.029025 Should work on a genuine 12c The method is general: string the payments out in the past, so the present is future wrt the payments, and use a negative discount rate equivalent to the interest rate. Then NPV becomes NFV. Cheers Tony Edited: 26 Jan 2010, 9:25 p.m.

 Possibly Related Threads... Thread Author Replies Views Last Post HP Prime: Recommendation for future RPN Program Mode BruceTTT 3 926 11-13-2013, 10:03 PM Last Post: BruceTTT is a 50g worth buying with future in mind FORTIN Pascal 20 2,798 10-26-2013, 05:04 PM Last Post: Michael de Estrada The HP Calculator Future Matt Agajanian 20 2,243 07-04-2012, 02:02 PM Last Post: ClausB Future I/O capabilities in WP-34S v3.x Andrés C. Rodríguez (Argentina) 7 1,032 10-28-2011, 11:40 AM Last Post: Andrés C. Rodríguez (Argentina) Future of HP-IL with PIL-Box and TCP/IP? Christoph Giesselink 1 600 11-16-2010, 05:23 AM Last Post: Mike (Stgt) The Future of Graphing Calculators bill platt 20 2,270 03-29-2010, 05:20 PM Last Post: Han [OT] Future Calculator Nut? Tim Wessman 13 1,680 02-23-2010, 10:50 PM Last Post: db (martinez, ca.) the future of programmable calculators? Herbert Crepaz (UK) 9 1,239 10-28-2009, 06:54 AM Last Post: Thomas Radtke Units Localisation request for future HPs Mark Edmonds 24 2,489 08-05-2008, 03:15 AM Last Post: ncrook(UK) Prognosticating about HP's future plans Martin Pinckney 2 559 06-11-2008, 10:37 AM Last Post: Manatee

Forum Jump: