| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
net present value
Excel stops calculating NPV at the end of 29 periods/years. How do I find
tables that go up to 40 years? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
net present value
This is not true. You can calculate NPV for hundreds of periods.
NPV will accept up to 29 *ranges* of cash flows. Each range can be as big as you want. So simply put your 40 years into one range, as in: =npv(rate,a1:a40) -- Regards, Fred "Frank D" <Frank wrote in message ... Excel stops calculating NPV at the end of 29 periods/years. How do I find tables that go up to 40 years? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use a pivot table to present data, not sum or count it. | Excel Worksheet Functions | |||
| calculating month of present date | Excel Discussion (Misc queries) | |||
| Automated task to present data in a graph form. | Charts and Charting in Excel | |||
| How do I calculate present value of a single sum? | Excel Worksheet Functions | |||
| Count for present & absent days | Excel Discussion (Misc queries) | |||
Linear Mode
