Any 'Financial' bright sparks?

[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 )

 

[Dana DeLouis]

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

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

The PV function is the "Present Value" function.

 

[John Drummond]

7800000/1.05^3

 

[JethroUK©]

thanks for that - i'm sure your right

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

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

The PV function is the "Present Value" function.

 

[JethroUK©]

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 )