I don't know what "mid period discounting" is, but if it results in irregular
cash flows, the answer is no. In this case, XNPV is the function which would
work for you. You may need to install the Analysis TookPak to make this
accessible (ToolsAddins)

--
Regards,
Fred


"apubapu82" wrote in
message ...

I am building a discounted cash flow model and was wondering if there
was a way to incorporate mid-period discounting using the NPV function.
Any assistance regarding this matter would be greatly appreciated.
Thanks!


--
apubapu82
------------------------------------------------------------------------
apubapu82's Profile:
http://www.excelforum.com/member.php...o&userid=33201
View this thread: http://www.excelforum.com/showthread...hreadid=541622