Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
NPV calculations at the end of future years
Do I use the net present value function (PV) to get an answer of (negative)
-37,565 if we have a cash outflow of $50,000 at the end of the 3rd year at a 10% factor? I am using a text book and chart, but Id like to be able to use excel to calculate it. Once again, the texts answer is (37,565). Thank you for your help. -- das |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
NPV calculations at the end of future years
NPV is for a series of payments.
Use =50000/(1+10%)^3 -- Kind regards, Niek Otten "das" wrote in message ... Do I use the net present value function (PV) to get an answer of (negative) -37,565 if we have a cash outflow of $50,000 at the end of the 3rd year at a 10% factor? I am using a text book and chart, but I'd like to be able to use excel to calculate it. Once again, the text's answer is (37,565). Thank you for your help. -- das |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
NPV calculations at the end of future years
Yes, use PV: =PV(10%,3,0,50000). The PV function arguments are the periodic
rate, the number of periods, the payment made each period (none, since you have a single cash outflow), and the future value (50000, since that's the value at the end). "das" wrote: Do I use the net present value function (PV) to get an answer of (negative) -37,565 if we have a cash outflow of $50,000 at the end of the 3rd year at a 10% factor? I am using a text book and chart, but Id like to be able to use excel to calculate it. Once again, the texts answer is (37,565). Thank you for your help. -- das |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating the years | Excel Worksheet Functions | |||
Convert years to years and days | Excel Discussion (Misc queries) | |||
Data Range Mess | Charts and Charting in Excel | |||
To create formula to add 3 years and subtract 1 day from a date? | Excel Worksheet Functions | |||
I need the difference between two dates expressed as 4 years 3 mo. | Excel Discussion (Misc queries) |