The Excel function PV(rate, number_period, payment) calculate the present value of a constant payment. For example, PV(15%,15,-10)
Fantastic news! We've Found the answer you've been seeking!
Question:
- The Excel function PV(rate, number_period, payment) calculate the present value of a constant payment. For example, PV(15%,15,-10) = 58.47. (Note that we have put the payment as a negative number; otherwise, Excel return a negative value!). Use Data Table to graph the present value as a function of the discount rate. Use the rate as 15%, number of periods as 15 and payment as 10.
How to solve this?
Related Book For
Posted Date: