Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Functions
How do I calculate the present worth of $1 utilizing an Excel function?
With the correct formula, the present worth of $1, at a 10% discount rate for 5 periods (or years) would equal: yr1 .9091, yr2 .8264, yr3 .7513, yr4 ..6831, yr5 .6209. This unknown functions is different from the PV and FV functions. If I just wanted the sum of those figures, I could use the NPV function but I want to calculate the present worth of $1 each period. Thanks. |
#2
|
|||
|
|||
Not sure what's "different from the PV" function...
=PV(10%,1,0,-1) ==== 0.9091 =PV(10%,2,0,-1) ==== 0.8264 =PV(10%,3,0,-1) ==== 0.7513 ... In article , "sjsexcel" wrote: How do I calculate the present worth of $1 utilizing an Excel function? With the correct formula, the present worth of $1, at a 10% discount rate for 5 periods (or years) would equal: yr1 .9091, yr2 .8264, yr3 .7513, yr4 .6831, yr5 .6209. This unknown functions is different from the PV and FV functions. If I just wanted the sum of those figures, I could use the NPV function but I want to calculate the present worth of $1 each period. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Can I use variables for workheet name references in Excel functions? | Excel Discussion (Misc queries) | |||
Can I use variables for workheet name references in Excel functions? | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |