Business, 14.12.2019 07:31 lcoronilla96

Your division is considering two projects with the following cash flows (in millions):

0 1 2 3
col1 project a -$29 $15 $13 $3
col2 project b -$16 $8 $3 $6

1. what are the projects' npvs assuming the wacc is 5%? round your answer to two decimal places. enter your answer in millions. for example, an answer of $10,550,000 should be entered as 10.55.
project a $ million
project b $ million

2. what are the projects' npvs assuming the wacc is 10%? round your answer to two decimal places. enter your answer in millions. for example, an answer of $10,550,000 should be entered as 10.55.
project a $ million
project b $ million

3. what are the projects' npvs assuming the wacc is 15%? round your answer to two decimal places. enter your answer in millions. for example, an answer of $10,550,000 should be entered as 10.55.
project a $ million
project b $ million

4. what are the projects' irrs assuming the wacc is 5%? round your answer to two decimal places.
project a %
project b %

5. what are the projects' irrs assuming the wacc is 10%? round your answer to two decimal places.
project a %
project b %

6. what are the projects' irrs assuming the wacc is 15%? round your answer to two decimal places.
project a %
project b %

7. if the wacc were 5% and a and b were mutually exclusive, which would you choose? (hint: the crossover rate is 5.9%.)
-select-project aproject bneither a, nor bitem 13

8. if the wacc were 10% and a and b were mutually exclusive, which would you choose? (hint: the crossover rate is 5.9%.)
-select-project aproject bneither a, nor bitem 14

9. if the wacc were 15% and a and b were mutually exclusive, which would you choose? (hint: the crossover rate is 5.9%.)
-select-project aproject bneither a, nor bitem 15

Answers: 3

Show answers

Answers

Answer from: svarner2001

Explanation:

1.If WACC = 5%

Project A

Year Cash Flow PV factor @5% (a)* (b)

(b)

0 -$29 1 - $29

1 $15 0.952 $14.28

2 $13 0.907 $11.791

3 $3 0.864 $2.592

NPV = - $ 0.337 millions

Project B

Year Cash Flow PV factor @5% (a)* (b)

(b)

0 -$16 1 - $16

1 $8 0.952 $7.616

2 $3 0.907 $2.721

3 $6 0.864 $5.184

NPV = - $ 0.479 millions

2. If WACC = 10 %

Project A

Year Cash Flow PV factor @10% (a)* (b)

(b)

0 -$29 1 - $29

1 $15 0.909 $13.635

2 $13 0.826 $10.738

3 $3 0.751 $2.253

NPV = - $ 2.374 millions

Project B

Year Cash Flow PV factor @10% (a)* (b)

(b)

0 -$16 1 - $16

1 $8 0.909 $7.272

2 $3 0.826 $2.478

3 $6 0.751 $4.506

NPV = - $ 1.744 millions

3. If WACC = 15%

Project A

Year Cash Flow PV factor @ 15% (a)* (b)

(b)

0 -$29 1 - $29

1 $15 0.870 $13.05

2 $13 0.756 $9.828

3 $3 0.658 $1.974

NPV = -$ 4.148 millions

Project B

Year Cash Flow PV factor @15% (a)* (b)

(b)

0 -$16 1 - $16

1 $8 0.870 $6.96

2 $3 0.756 $2.268

3 $6 0.658 $3.948

NPV = -$ 2.824 millions

4. If WACC = 5% , IRR = ?

Project A

Year Cash Flow PV factor @5% PV factor @ 4% (a)* (b) (a) *(c)

(b) (c)

0 -$29 1 1 - $29 -$29

1 $15 0.952 0.962 $14.28 $14.43

2 $13 0.907 0.925 $11.791 $12.025

3 $3 0.864 0.889 $2.592 $2.667

NPV = - $ 0.337 m NPV = -$0.122 m

Since NPV is fairly close to zero at 4% value of r, therefore IRR ≈ 4%

Project B

Year Cash Flow PV factor @5% PV factor @ 3% (a)* (b) (a) * (c)

(b) (c)

0 -$16 1 1 - $16 -$16

1 $8 0.952 0.971 $7.616 $7.768

2 $3 0.907 0.943 $2.721 $2.829

3 $6 0.864 0.915 $5.184 $5.49

NPV = -$ 0.479 m NPV= - $ .087

Since NPV is fairly close to zero at 3% value of r, therefore IRR ≈ 3%

5. If WACC = 10% , IRR = ?

Project A

Year Cash Flow PV factor @10% PV factor @ 8% (a)* (b) (a) *(c)

(b) (c)

0 -$29 1 1 - $29 -$29

1 $15 0.909 0.926 $13.635 $13.89

2 $13 0.826 0.857 $10.738 $11.141

3 $3 0.751 0.792 $2.253 $2.376

NPV = - $ 2.374 m NPV = -$1.593 m

Since NPV is fairly close to zero at 8% value of r, therefore IRR ≈ 8%

Project B

Year Cash Flow PV factor @10% PV factor @ 8% (a)* (b) (a) * (c)

(b) (c)

0 -$16 1 1 - $16 -$16

1 $8 0.909 0.926 $ 7.272 $7.408

2 $3 0.826 0.857 $ 2.478 $2.571

3 $6 0.751 0.792 $ 4.506 $4.752

NPV = - $ 1.744 m NPV= - $1.269

Since NPV is fairly close to zero at 8% value of r, therefore IRR ≈ 8%

6. If WACC = 15% , IRR =?

Project A

Year Cash Flow PV factor @ 15% (a)* (b)

(b)

0 -$29 1 - $29

1 $15 0.870 $13.05

2 $13 0.756 $9.828

3 $3 0.658 $1.974

NPV = -$ 4.148 millions

NPV @ 8% = -$ 1.593

Since NPV is fairly close to zero at 8% value of r, therefore IRR ≈ 8%

Project B

Year Cash Flow PV factor @15% (a)* (b)

(b)

0 -$16 1 - $16

1 $8 0.870 $6.96

2 $3 0.756 $2.268

3 $6 0.658 $3.948

NPV = -$ 2.824 millions

NPV @ 8% = -$1.269

Since NPV is fairly close to zero at 8% value of r, therefore IRR ≈ 8%

7.If WACC = 5%

Project A

Year Cash Flow PV factor @5% (a)* (b)

(b)

0 -$29 1 - $29

1 $15 0.952 $14.28

2 $13 0.907 $11.791

3 $3 0.864 $2.592

NPV = - $ 0.337 millions

Project B

Year Cash Flow PV factor @5% (a)* (b)

(b)

0 -$16 1 - $16

1 $8 0.952 $7.616

2 $3 0.907 $2.721

3 $6 0.864 $5.184

NPV = - $ 0.479 millions

NPV of project B > project A than choose Project B

2. If WACC = 10 %

Project A

Year Cash Flow PV factor @10% (a)* (b)

(b)

0 -$29 1 - $29

1 $15 0.909 $13.635

2 $13 0.826 $10.738

3 $3 0.751 $2.253

NPV = - $ 2.374 millions

Project B

Year Cash Flow PV factor @10% (a)* (b)

(b)

0 -$16 1 - $16

1 $8 0.909 $7.272

2 $3 0.826 $2.478

3 $6 0.751 $4.506

NPV = - $ 1.744 millions

NPV of project A > project B than choose Project A

3. If WACC = 15%

Project A

Year Cash Flow PV factor @ 15% (a)* (b)

(b)

0 -$29 1 - $29

1 $15 0.870 $13.05

2 $13 0.756 $9.828

3 $3 0.658 $1.974

NPV = -$ 4.148 millions

Project BYear Cash Flow PV factor @15% (a)* (b)

(b)

0 -$16 1 - $16

1 $8 0.870 $6.96

2 $3 0.756 $2.268

3 $6 0.658 $3.948

NPV = -$ 2.824 millions

NPV of project A > project B than choose Project A

Answer from: markmeinberg

Below is attached the file containing answer of the above mention question

Explanation:

Answer from: Quest

answer(8,000.)

Answer from: Quest

answerall of the above;

Another question on Business

Business, 22.06.2019 04:00

Burberry is pursuing a focused differentiation strategy aimed at high-end luxury customers. however, the company is also employing a segmentation strategy to separate customers within that focus. the strategy offers items at an entry-level price point for customers who desire to be like celebrities such as sarah jessica parker as well as couture items for those richest and celebrity customers. what strategy is burberry pursuing?

Answers: 3

Answer

Business, 22.06.2019 10:40

What would happen to the equilibrium price and quantity of lattés if the cost to produce steamed milk

Answers: 1

Answer

Business, 23.06.2019 10:30

You've arrived at the pecan shellers conference—your first networking opportunity. naturally, you're feeling nervous, but to avoid seeming insecure or uncertain, you've decided to a. speak a little louder than you would normally. b. talk on your cell phone as you walk around. c. hold an empowered image of yourself in your mind. d. square your shoulders before entering the room.

Answers: 2

Answer

Business, 23.06.2019 23:00

Downing company issues $5,000,000, 6%, 5-year bonds dated january 1, 2017 on january 1, 2017. the bonds pay interest semiannually on june 30 and december 31. the bonds are issued to yield 5%. what are the proceeds from the bond issue?

Answers: 3

Answer

You know the right answer?

Your division is considering two projects with the following cash flows (in millions):

...

Questions