Hello
I read that using PMT you calculate your instalment/EMI on particular amount
of Loan.
GoalSeek on the other hand finds out the max loan you can get if you have x
amount to spare per month.
So I spared 5000 per month at 9% interest how much it accumulates as
GoalSeek, I was told does exactly opposite of working with PMT. I am not
against using FV, but while learning Excel, I found goalseek not working
correctly. with 5k per month = 60K in a year. in 5 yrs it is 300K, plus
interest. How can that be around 240k? is the question
Thanks