Any 'Financial' bright sparks?

  • Thread starter Thread starter JethroUK©
  • Start date Start date
J

JethroUK©

"calculate the present value of a considered investment yielding £7,800,000
after 3 years at 5%"

which function will give me this?

winner gets a bag of peanuts :o)
 
If it's compounded yearly, this might be one way:

=PV(5%,3,,-7800000)

The PV function is the "Present Value" function.
 
thanks for that - i'm sure your right


Dana DeLouis said:
If it's compounded yearly, this might be one way:

=PV(5%,3,,-7800000)

The PV function is the "Present Value" function.
Click to expand...
 
thanx for that - your maths make a lot more sense than the financial jargon
(i didn't know what they were asking, but i do now), but i have to use a
function

for what it's worth both methods came up with the same answer - the bad news
is you have to share the bag of peanuts with dana :o)
 
Back
Top