I have this following problem.

If a certain amount (P) is receivable after certain period, I would like to
know the present value (V) of that future receipt (P), discounted at a
certain percentage (R). The discounting has to be done on a monthly basis
(like we compound interest on a monthly basis in the reverse case..)

I am not able to find a worksheet function for this. Can someone please
help?

- Murthy