Hi Fred!

Thank you. It was unclear for me but as I understand your answer I can use
zero in payment and 5 which will represent yearperiod.

Best regards

Steffen

"Fred Smith" skrev:

The future value of your loan is:

=fv(10%,5,0,1000000)
=1,610,510 Euro

If the customer pays you in advance, for example, after 3 years, just put the
period into the formula, as in:

=fv(10%,3,0,1000000)
=1,331,000

FV will also accept non-integer periods, so if he pays you back after 3 years
and 8 months, use a period of 3.75 years.

--
Regards,
Fred


"Steffen" wrote in message
...
I have the following data. I do an investment (give a loan) of 1.000.000
Euro. The rate I want is 10%. The period is 5 years. What functions should I
use to calculate the sum the customer should pay me after 5 years. And if the
customer should pay me in advance what would the sum be then.

I have tried myself but I am not sure what to do. I can use the ordinary
functions if payment is regular (per month, year etc) but if the payment is
in the beginning or at the end of a 5 year period I do not know how to solve
the problem.

Steffen