Monthly NPV

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.

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
edwintam@vonixx.com
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
>
>

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" <Robo.26lx6m_1145610604.579@excelforum-nospam.com> wrote in message
news:Robo.26lx6m_1145610604.579@excelforum-nospam.com...
>
> 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
>