I'm not sure about the timing your cash flows from your question. But
normally, using the annual discount rate and divide it by 12 is a correct
approach for most questions.

If you need additional help, maybe you can share with us your exact finance
question.

Regards,
Edwin Tam

http://www.vonixx.com


"Robo" wrote:


If I wanted to do a monthly NPV model rather than an annual one, do I
just divide the discount rate by 12?


I think the long hand formula would be ((1+r)^(1/12))

What data would I need to calculate a monthly NPV? Any help please.


--
Robo
------------------------------------------------------------------------
Robo's Profile: http://www.excelforum.com/member.php...o&userid=12058
View this thread: http://www.excelforum.com/showthread...hreadid=534889