If your model assumes monthly compounding, then, yes, you simply divide the
discount rate by 12. If you want annual compounding, you would have to convert
your rate, using, for example, the EFFECT function.

--
Regards,
Fred


"Robo" wrote in message
...

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