# Do I use the FV function in Excel correctly?

Calculate what the revenues of e-trading will be after five years at 15 percent interest rate if we now have 15 000 EUR. Use the FV function from the Financial Group in Excel.

My resolution: =FV( 15%; 5; 0; -15000).

My question: Is it correct?

I know the task lacks information whether the interest rate is per month or per year. I calculate it as 'per year'. My question is orientated more on the usage of the FV function. I, for example, do not understand why '-15000' and not '15000'. Also why the third parameter has to be 0? Maybe I do it wrong.

-
Heh.. I would like to answer the question but I couldn't afford MS Office 2010. :( – Shiki Jun 10 '10 at 17:39
@Shiki The beta is still available until October I think – Jarvin Jun 10 '10 at 17:43
Oh ..well.. if no answer will come I'll install it and verify my answer if its correct or not. – Shiki Jun 10 '10 at 17:48
this is not about office-2010. I'm sorry for the wrong tag. I'm pretty sure it will work on 97 as well. I don't know whether I use the function the way I have to(the task). – John Jun 10 '10 at 18:27

Looks good to me. The answer is equal to `15000*1.15^5`, which is how I would calculate it by hand. In these types of functions (present value, future value, rate of return) a negative value generally denotes a payment into the investment, while a positive value indicates what you withdraw from the investment.
I noticed that you used semicolons (`;`) between your parameters. In my Excel 2007, I have to use commas (`,`). Maybe that's a configuration or internationalization difference.