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