PV of Irregular Cash Flow Stream

K

Ken

Hi,

Does anyone know how to discount an irregular stream of
cash flows?
Example,
Over the next five years I expect to receive payments
which will be irregular in amount and I'd like to discount
them back to present value dollars using a predetermined
discount rate.

Any help would be greatly appreciated.
Best regards,
Ken
 
H

Harlan Grove

Does anyone know how to discount an irregular stream of
cash flows?
Example,
Over the next five years I expect to receive payments
which will be irregular in amount and I'd like to discount
them back to present value dollars using a predetermined
discount rate.
Click to expand...

Try XNPV. You'd need the Analysis ToolPak loaded. Directions to do so may be
found in online help for the XNPV function.
 
B

Bill

That worked great. I had just written a custom function to
do PV calculations for individual values, which I then
added up. This is much better.

Thanks,
Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XIRR vs. IRR Function 11
Excel TVM functions of RATE, NPER, PMT, PV, and FV fail to produceresults that are known about Geome 0
NPV of Cash Flow Payments 2
Better Understanding of XIRR 4
pv of annuity 4
"variable interest rate" 1
PV of uneven stream of cash flows 8
How do I sum cashflows within date range given dates and cash flow 1

Top