Future Value Formula: Calculate monthly payment with given interest rate & payment periods

[flippp]

Hi,

I have a crack nut. Let's see if anyone can help with that

I would like to calculate the monthly payment that is needed to achieve a future value. Example:

• Interest Rate: 5% per year
• Period in Years: 10 years
• Future Value: 10,000 Euro
• Current Value: 0 Euro

How can I calculate the monthly payment that is needed to achieve the future value of 10,000 Euro?

I figured out that there is a formula in Excel for calculating the future value but not the monthly payment: =FV (rate, nper, pmt, [pv], [type])

I would really appreciate your feedback.

Thank you,

Philip