INFS 3250 Assignment 11
Use Goal Seek. Use Solver. Manage Scenarios
1.
Open
XmasCakes
and save it as [your initials]1623
2.
Use Goal Seek by following these steps:
a.
In the
CreditUnion
worksheet, select cell B9. The formula uses the
PMT function to determine the monthly car payment.
b.
Click the
Data tab
. Click the WhatIf analysis button
c.
Choose Goal Seek. In the
To value
box, key
350.
This is the
desired car payment.
d.
Select cell B6 for the
By changing cell box
. This is the amount that
would have to be borrowed.
e.
Click
OK
to find a solution Click
OK
to keep the solution
f.
Select cell F9. The formula uses the FV function to determine what
the savings account will be worth in four years.
g.
Click the WhatIf analysis button. Choose
Goal Seek.
h.
In the
To Value box,
key
7000
the amount you would like to have
in four years.
i.
Use cell F8
By changing cell box
. This is the interest rate.
j.
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
This is the end of the preview.
Sign up
to
access the rest of the document.
 Fall '11
 Gordon
 Constraint, 30 hours, M.

Click to edit the document details