Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Monthly NPV
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Monthly NPV
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate total interest earned on a loan and monthly payment | Excel Worksheet Functions | |||
Is there a way to add monthly message to excel | Excel Discussion (Misc queries) | |||
Updating links monthly... | Excel Worksheet Functions | |||
spread sheet template for monthly business for a year | Excel Discussion (Misc queries) | |||
Z Chart i.e. top rolling annual bottom rolling monthly middle cum. | Excel Worksheet Functions |