{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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: 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.

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

View Full Document
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.
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.

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

View Full Document
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
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern