Future Value Problem, right?



#2

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


#3

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.


#4

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.

#5

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

#6

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.

#7

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

#8

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.

#9

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

#10

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.

#11

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.

#12

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 233 11-13-2013, 10:03 PM
Last Post: BruceTTT
  is a 50g worth buying with future in mind FORTIN Pascal 20 817 10-26-2013, 05:04 PM
Last Post: Michael de Estrada
  The HP Calculator Future Matt Agajanian 20 623 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 260 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 153 11-16-2010, 05:23 AM
Last Post: Mike (Stgt)
  The Future of Graphing Calculators bill platt 20 611 03-29-2010, 05:20 PM
Last Post: Han
  [OT] Future Calculator Nut? Tim Wessman 13 448 02-23-2010, 10:50 PM
Last Post: db (martinez, ca.)
  the future of programmable calculators? Herbert Crepaz (UK) 9 313 10-28-2009, 06:54 AM
Last Post: Thomas Radtke
  Units Localisation request for future HPs Mark Edmonds 24 758 08-05-2008, 03:15 AM
Last Post: ncrook(UK)
  Prognosticating about HP's future plans Martin Pinckney 2 126 06-11-2008, 10:37 AM
Last Post: Manatee

Forum Jump: