DecisionMakingProblems

- rate Time NPV 10.00 Project 1 Project 2 0-50-100 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 $240.36

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

View Full Document Right Arrow Icon
rate 10.00% Time Project 1 Project 2 NPV1 - NPV 2 0 -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: E3 To value: 0 By changing cell: B1 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.
Background image of page 1

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

View Full DocumentRight Arrow Icon
discount rate 10.00% book original price 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: B11 To value: 40 By changing cell: B1 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.
Background image of page 2
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 3.60 Set cell: B7 To value: 3.5 By changing cell: B5 In order for Anna to have a good shot at being admitted to the Accounting program, she must maintain a 3.5 cumulative average. Figure out what GPA Anna must earn in Fall 2010.
Background image of page 3

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

View Full DocumentRight Arrow Icon
Loan Amount $25,000 Term in Months 24 Interest Rate 12.00% Payment ($1,176.84) Set cell: b4 To value: -500 By changing cell: b1
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 11/01/2011 for the course I SYS 201 at BYU.

Page1 / 11

- rate Time NPV 10.00 Project 1 Project 2 0-50-100 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 $240.36

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

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