Thread: Monthly NPV
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robo
 
Posts: n/a
Default 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.


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