DecisionMakingProblems

# DecisionMakingProblems - rate Time NPV 10.00 Project 1...

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

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: To value: By changing cell: 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.

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

View Full Document
discount rate 39.23% book original price 1 \$5.99 2 \$14.99 3 \$8.99 4 \$12.99 5 \$18.99 original price total \$61.95 discount \$24.30 add sales tax \$2.35 final price \$40.00 Set cell: To value: By changing cell: 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.38 15 56 Total credits Cumm GPA 3.50 Set cell: To value: By changing cell: 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.

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

View Full Document
Original Price \$11,622 Downpayment 1000 Loan Amount \$10,622 Term in Months 24 Interest Rate 12.00% Payment (\$500.00) Set cell: To value: By changing cell:
This is the end of the preview. Sign up to access the rest of the document.

## This document was uploaded on 11/22/2011.

### Page1 / 11

DecisionMakingProblems - rate Time NPV 10.00 Project 1...

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

View Full Document
Ask a homework question - tutors are online