07.2_Goal_Seek_and_Solver_Problems

07.2_Goal_Seek_and_Solver_Problems - Name Courtland Astill...

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

View Full Document Right Arrow Icon
Name Courtland Astill Section _1_ _ Goal Seek and Solver Problems Print the answers (perhaps typed in Word) to the following problems to turn in at the start of class . Data for all the following problems are found in the worksheets in the file Goal_Seek_and_Solver_ Data.xls on the course website. Goal Seek 1. Using the “ Goal Seek-NPV ” worksheet, find the indifference point, which is the interest rate at which Projects 1 and 2 have the same NPV. In this instance, set cell $E$3 to 0 by changing cell $B$1. 12.26% 2. Sometimes the BYU Bookstore has a “progressive book sale.” This means that the books are 10% off the first day, 20% off the second day, and so on until they are 50% off on the fifth day. You would like to buy five particular books, but you only have $40. Because the books might get sold out, you would like to buy them as soon as you can afford it. Using the “ Goal Seek-Book Sale ” worksheet, calculate which day you will be able to buy your books. You will be able to buy the book on the Fourth day
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.

This homework help was uploaded on 04/17/2008 for the course ISYS 210 taught by Professor Ball during the Winter '08 term at BYU.

Page1 / 2

07.2_Goal_Seek_and_Solver_Problems - Name Courtland Astill...

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