Forum Discussion
"Reverse FV" function? Or?
Hi all, I need some help please. I would like formula for excel, where I have known inputs: A1 = 30 (number of years) A2 = 500000 (needed capital) A3 = 8% (known yearly return of investment p.a...
Hello Hans,
thank you for your reply. I have tried it with that exact numbers from my example, but it returns wrong number (4267,78). Also when I enter initial investment to zero (0 to A4), result only change to 4274,49.
What am I doing wrong please?
Thank you! D.
Sorry, my bad - I switched two arguments.
=PMT(A3/12, 12*A1, A4, -A2)
Thank you!