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...
Sorry, my bad - I switched two arguments.
=PMT(A3/12, 12*A1, A4, -A2)
Thank you!