Present Value calculation by single function 1

[Tonyjstone]

I have been asked to provide a single cell function that will enable a calculation to show "the Present Value of a Single Fixed Investment which will yeild a given sum after 'x' years at 'y'percent interest"
None of the usual 'functions' seems to achieve my goal. What would you learned practitioners suggest?

Thanx
Tony
The more I learn the less I seem to know

 

[Zathras]

Assuming compound interest, the formula you want is
[blue]

   =givensum/(1+y)^x

[/color]
So, for example, if the given sum is 10,000, the number of years is 15 and the interest rate is 8% per annum (compounded annually), the formula would look like this:
[blue]

   =10000/(1.08)^15

[/color]
and the answer would be [blue]

 3,152.42

[/color]

 

[Tonyjstone]

Many thanks. That seems to have solved the problem nicely.
Your generosity is much appreciated.

Tony
The more I learn the less I seem to know