| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Net Present Value Question
I need to be able to determine what the net present value would be for a list
of months with varying dollar amounts (For example: Jan 120000, Feb 35000, March 55000, etc). What would the values be worth today? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Net Present Value Question
You didn't specify a rate so I'll assume 5%... You can do this in 2 ways,
first use NPV(): =NPV(0.05,120000,35000,55000) Or you can choose to understand what the NPV() formula is doing by calculating manually: =120000/(1.05)+35000/(1.05^2)+55000/(1.05^3) -- Regards, Dave "ktbull" wrote: I need to be able to determine what the net present value would be for a list of months with varying dollar amounts (For example: Jan 120000, Feb 35000, March 55000, etc). What would the values be worth today? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Net Present Value Question
Thank you for your response! Very helpful.
"David Billigmeier" wrote: You didn't specify a rate so I'll assume 5%... You can do this in 2 ways, first use NPV(): =NPV(0.05,120000,35000,55000) Or you can choose to understand what the NPV() formula is doing by calculating manually: =120000/(1.05)+35000/(1.05^2)+55000/(1.05^3) -- Regards, Dave "ktbull" wrote: I need to be able to determine what the net present value would be for a list of months with varying dollar amounts (For example: Jan 120000, Feb 35000, March 55000, etc). What would the values be worth today? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Net Present Value Question
"David Billigmeier" wrote: You didn't specify a rate so I'll assume 5%... You can do this in 2 ways, first use NPV(): =NPV(0.05,120000,35000,55000) Or you can choose to understand what the NPV() formula is doing by calculating manually: =120000/(1.05)+35000/(1.05^2)+55000/(1.05^3) -- Regards, Dave "ktbull" wrote: I need to be able to determine what the net present value would be for a list of months with varying dollar amounts (For example: Jan 120000, Feb 35000, March 55000, etc). What would the values be worth today? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
| Another question about IF(COUNTIF) checks in Excel | Excel Discussion (Misc queries) | |||
| Newbie With A Question | Excel Worksheet Functions | |||
| Anybody Help with previous question | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Linear Mode
