Forum Discussion
Question related to Solver
Hello Everyone,
As we calculate the Goal Seekcommand (What If analysis) Or Data Table(What If analysis)command, So
How to calculate more than input value with the help of Solver?
I want to calculate Mortage Amount and Interest Rate with the help of Solver?
Please help..??
Here is a attached file...
See for example https://www.solver.com/solver-tutorial-using-solver
6 Replies
What should be the target for Solver? If you want to minimize the monthly payment, the obvious solution would be Mortgage Amount = 0.
The Target value should be 1100.
So, how to calculate with the help of Solver?
That is a meaningless question. There is an infinite number of combinations of Mortgage Amount and Interest that will result in a Payment of $1,100.
For example:
amount = $100,000 and interest = 12.63%
amount = $200,000 and interest = 4.40%
amount = $300,000 and interest = 0.77%
etc.
