Forum Discussion
Solved
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...
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.
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.