| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
future value
I am getting a negative return on my answer. The question was,
I have a PV now of £10,500.00 Leaving in as an investment for 15 years Interest rate per anum 5% I get a return FV of minus £21,829.00 ???? Shouldnt this be Plus? Formula I used was =FV(5%/1,15,,10500) Is this correct regards Steve |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
future value
your 10,500 should be -10,500 (a negative amt)
"K11ngy" wrote: I am getting a negative return on my answer. The question was, I have a PV now of £10,500.00 Leaving in as an investment for 15 years Interest rate per anum 5% I get a return FV of minus £21,829.00 ???? Shouldnt this be Plus? Formula I used was =FV(5%/1,15,,10500) Is this correct regards Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Future Value | New Users to Excel | |||
| future value | Excel Discussion (Misc queries) | |||
| Future Value (FV) | Excel Discussion (Misc queries) | |||
| Future Value | Excel Worksheet Functions | |||
| Future Value | Excel Worksheet Functions | |||
Linear Mode
