INFSassign11

INFSassign11 - INFS 3250- Assignment 11 Use Goal Seek. Use...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
INFS 3250- Assignment 11 Use Goal Seek. Use Solver. Manage Scenarios 1. Open XmasCakes and save it as [your initials]16-23 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 What-If 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 What-If 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.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

INFSassign11 - INFS 3250- Assignment 11 Use Goal Seek. Use...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online