Forum Discussion
Question related to Goal Seek
Hello Everyone,
I have tried Goal Seek. I write this formula -
Then i i have set in Term in Months in Goal Seek.
like -
After click in OK, it will give wrong answer in Term in Months
like -
So, what should i do which it will give right answer in TERM IN MONTHS with the help of Goal Seek?
Please help..???
Here is a attach file...
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.
13 Replies
Here is an example, you can expand as you like.
Can even open a bank:)))
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
- Unfortunately, I can understand your project even less than Mr. Riny_van_Eekelen.
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.
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.
- So, sir is this correct solution which i got 7953 in Term of Month?
Excel I guess not, because you can't get any lower that 1466.67. 100000 months will give you the same amount. My point was that you can never get down to 1100.
