# Project Evaluation Problems

UNIT 3: TEXTBOOK PROBLEMS

CHAPTER 7: PROBLEM 1b

Project A Project B
Discount Rate 15% 15%
Year 0 (\$14,500) (\$9,800)
Year 1 \$8,500 \$4,700
Year 2 \$6,800 \$4,200
Year 3 \$2,800 \$4,100
NPV = #NAME? #NAME? (Note: You will choose the project that has the highest NPV since it creates the most wealth)

CHAPTER 7: PROBLEM 2

Year A. B. C.
0 \$3,200 \$4,600 \$7,900
1 \$825 \$825 \$825
2 \$825 \$825 \$825
3 \$825 \$825 \$825
4 \$825 \$825 \$825
5 \$825 \$825 \$825
6 \$825 \$825 \$825
7 \$825 \$825 \$825
8 \$825 \$825 \$825
Payback Period = #NAME? #NAME? #NAME?

CHAPTER 7: PROBLEM 8

Year Project A Project B
0 (\$5,200) (\$3,600)
1 1,800 1,300
2 3,200 2,100
3 2,200 1,800
IRR = #NAME? #NAME?

CHAPTER 7: PROBLEM 9

Discount Rate 15%
Year
0 (Initial Cost) (\$185,000) \$185,000
1 62,000
2 62,000
3 62,000
4 62,000
5 62,000
6 62,000
7 62,000
First find the NPV #NAME? (Use the built-in NPV formula in Excel but exclude using the Year 0 cash outflow)
Now calculate the Profitability Index #NAME? (Use the positive amount of the initial cost in cell C44 in the formula. You would only accept the project if the Profitability Index is above 1)

CHAPTER 8: PROBLEM 1

Cost of Souffle Maker \$27,000 (\$27,000)
Economic Life 6 years
# of Souffles produced per year 2,300
Cost to make each Souffle \$2
Price of each Souffle \$7
Discount Rate 14%
Tax Rate 34%

Step 1: First calculate the Operating Cash Flow #NAME?

Step 2: Place the answer you get for your Operating Cash Flow in the year 1 thru year 6 cells below
Year 1 #NAME?
Year 2 #NAME?
Year 3 #NAME?
Year 4 #NAME?
Year 5 #NAME?
Year 6 #NAME?

Step 3: Now find the NPV. Be sure to include the initial cost by using cell C58 as it is negative
NPV = #NAME? (You will accept the project if the NPV is positive)