Thread: future value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JMay JMay is offline
external usenet poster
 
Posts: 468
Default 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