gg-1 - rate 10.00 Time Project 1 Project 2 NPV1 NPV $14.33...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: rate: 10.00% Time Project 1 Project 2 NPV1 - NPV 2-50-100 $14.33 1 10 90 2 20 80 3 30 70 4 40 60 5 50 50 6 60 40 7 70 30 8 80 20 9 90 10 10 100 5 NPV $240.36 $226.03 Set cell: $E$3 To value: By changing cell: $B$1 We want to find the indifference point, which is the interest rate at which Projects 1 and 2 have the same NPV. In this instance, we want to set cell $E$3 to 0 by changing cell $B$1. discount rate 10.00% book 1 $5.99 2 $14.99 3 $8.99 4 $12.99 5 $18.99 original price total $61.95 discount $6.20 add sales tax $3.48 final price $59.24 Set cell: $B$11 To value: 40 By changing cell: $B$1 original price 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. Term GPA Credits Fall 2009 3.75 16 Winter 2010 3.34 18 Spring 2010 3.60 7 Fall 2010 3.75 15 56 Total credits Cumm GPA...
View Full Document

This note was uploaded on 04/07/2011 for the course ISYS 200 taught by Professor Dean during the Winter '11 term at BYU.

Page1 / 12

gg-1 - rate 10.00 Time Project 1 Project 2 NPV1 NPV $14.33...

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

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