Forum Discussion
Question related to Goal Seek
Excel I guess this is a pure mathematical issue. At 8% per year the minimum monthly payment (interest only) is 1466.67. Thus, you will never get anything lower than that. You will thus never get down to 1100, no matter how many periods.
Maybe it's the translation, but what exactly do you want to achieve?
I sent you the example because it might fit into your project.
Thank you for your understanding and patience.
- Ok sir...
Can you please explain me in details which you have given file? PleasePerhaps this will help. Scroll down the worksheet and you'll see that as you increase the number of months further and further, the monthly payment more or less stops decreasing: it never gets below $1,466.67 (8% of $220,000 divided by 12).
So you will never reach a monthly payment of $1100 with this initial value and interest rate - not in 100 years, not in 1,000 years, not in 10,000 years: NEVER.
So, as all of us have pointed out several times now, there is no solution to your problem. Not because we don't want to tell you, but because it does not exist.
- now i am understand the concept of Goal Seek. Thank you very very very much sir...
- In the cells where there are only numbers, you can change them. So you can see the values in the formulas and how they behave.
- Thank you very much sir
