Question

OPTIMIZING A RESULT WITH GOAL SEEK
Excel gives you a powerful tool for finding a way to reach your goals. For example, if you need a
loan for a new home, your goal might be to pay a specific monthly payment. You can use the Goal
Seek feature to show how you can reach your goal by adjusting one of the loan terms such as
interest rate or loan amount.
2
1. Click the cell that contains the value
3
you want to reach.
2. Click on the Data tab.
3. Click on What-If Analysis.
4
1
A menu appears.
4. Click on Goal Seek.
D
E
H
00000
5.00%
A
1 Principal
2 interest
3 Number of Months
Monthly Payment
-3.774 25
The Goal Seek dialog box appears.
5. Type the value you want to reach.
6. Click or type the cell address of the
cell whose value you want to change
to reach your goal, e.g., B2.
7. Click on OK.
F
G
H
5
1 Principal
2 interest
3 Number of Months
4 Monthly Payment
5
200000
5.0096
60
+-3,774.25
SO
6
7
D
С
H
G
The result appears in the worksheet.
8. Click on OK to accept the change.
Alternatively, you can click on Cancel to
restore the original values.
In this example, principal is kept the
same and the 3000 monthly payment
can be reached by finding an interest
rate of 4.07 percent.
1 Principal
200000
2 interest
-4.07%
3 Number of Months
60
4 Monthly Paym *-3,000.00
5
8​

Answer 1

Answer:

.mkolpijnbhutgvctfcdgsdgtfcdcvh

Explanation:

..

..