Question

In: Finance

Year Project A Project B 0 −$330 −$330 1 160 230 2 160 230 3 160...

Year Project A Project B 0 −$330 −$330 1 160 230 2 160 230 3 160 230 4 160 a. If the opportunity cost of capital is 12%, calculate NPV for both projects? (Do not round intermediate calculations. Round your answers to 2 decimal places.) Project NPV A $ 485.98 B 552.42 b. Which of these projects is worth pursuing if you have enough funds and they are not mutually exclusive? Project A Project B Both

Solutions

Expert Solution

(a)-Net Present Value (NPV) for PROJECT-A & PROJECT-B

Net Present Value (NPV) for PROJECT-A

Period

Annual Cash Flow ($)

Present Value factor at 12.00%

Present Value of Cash Flow ($)

1

160

0.89286

142.86

2

160

0.79719

127.55

3

160

0.71178

113.88

4

160

0.63552

101.68

TOTAL

485.98

Net Present Value (NPV) for PROJECT-A = Present Value of annual cash inflows – Initial Investment

= $485.958 - $330

= $155.98

Net Present Value (NPV) for PROJECT-B

Period

Annual Cash Flow ($)

Present Value factor at 12.00%

Present Value of Cash Flow ($)

1

230.00

0.89286

205.36

2

230.00

0.79719

183.35

3

230.00

0.71178

163.71

TOTAL

552.42

Net Present Value (NPV) for PROJECT-B = Present Value of annual cash inflows – Initial Investment

= $552.42 - $330

= $222.42

(b)-DECISION

“BOTH”. The Both is worth pursuing. Since both the projects a positive Net Present Value are they are not mutually exclusive.

NOTE

The Formula for calculating the Present Value Factor is [1/(1 + r)n], Where “r” is the Discount/Interest Rate and “n” is the number of years.


Related Solutions

The following are the cash flows of two projects: Year Project A Project B 0 −$330...
The following are the cash flows of two projects: Year Project A Project B 0 −$330        −$330        1 160        230        2 160        230        3 160        230        4 160        a. Calculate the NPV for both projects if the opportunity cost of capital is 17%. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Project NPV         A $    B    b. Suppose that you can choose only one of...
Year Project A Project B 0 -$150,000 -$150,000 1 8,000 80,000 2 30,000 40,000 3 45,000...
Year Project A Project B 0 -$150,000 -$150,000 1 8,000 80,000 2 30,000 40,000 3 45,000 35,000 4 55,000 25,000 5 85,000 20,000 At what WACC would there be a break-even between the two projects? 7.23% 8.48% 7.57% 7.89% What is the NPV for Project A assuming the WACC is 10%? $5,653.94 $10,522.64 $6,219.33 $11,574.90 What is the IRR for Project B? 11.2% 13.9% 11.6% 10.9% What is the discounted payback period of Project A assuming the WACC is 10%?...
Year Project A Project B 0 -$150,000 -$150,000 1 8,000 80,000 2 30,000 40,000 3 45,000...
Year Project A Project B 0 -$150,000 -$150,000 1 8,000 80,000 2 30,000 40,000 3 45,000 35,000 4 55,000 25,000 5 85,000 20,000 At what WACC would there be a break-even between the two projects? 7.23% 8.48% 7.57% 7.89% What is the NPV for Project A assuming the WACC is 10%? $5,653.94 $10,522.64 $6,219.33 $11,574.90 What is the IRR for Project B? 11.2% 13.9% 11.6% 10.9% What is the discounted payback period of Project A assuming the WACC is 10%?...
Year Project A Project B 0 -425,000 -500,000 1 200,000 280,000 2 210,000 220,000 3 175,000...
Year Project A Project B 0 -425,000 -500,000 1 200,000 280,000 2 210,000 220,000 3 175,000 180,000 4 175,000 180,000 5 175,000 180,000 Use the IRR approach to determine which project to choose. Graph the NPV profiles for each project. At what rate will the two projects have the same NPV?
Consider cash flows for projects A and B Year: 0, 1, 2, 3, 4, 5 Project...
Consider cash flows for projects A and B Year: 0, 1, 2, 3, 4, 5 Project A: -$1000, 375, 375, 375, 375,-100 Project B: -$1000, 900, 700, 500, -200, 200 The cost of capital for both projects is 10% 1. Find the NPV and MIRR of projects A and B. If project A and B are mutually exclusive. 2. Find the crossover rate for projects A and B. 3. What is the profitability index for projects A and B? How...
Project Wind Power Year 0 Year 1 Year 2 Year 3 Costs $6,000,000 $4,000,000 $0 $0...
Project Wind Power Year 0 Year 1 Year 2 Year 3 Costs $6,000,000 $4,000,000 $0 $0 Benefits $18,000,000 $15,000,000 $12,000,000 $12,000,000 Project Hydroelectric power Year 0 Year 1 Year 2 Year 3 Costs $4,000,000 $2,000,000 $1,000,000 $0 Benefits $10,000,000 $14,000,000 $15,000,000 $16,000,000 If the interest rate is 3%, which project would you choose and why? Show your work using excel (15 points) If the interest rate is 15%, which project would you choose and why? Show your work using excel...
Year Project(A) Project (B) 0 -$30,000 -$30,000 1 13,000 5,000 2 11,000 5,000 3 9,000 5,000...
Year Project(A) Project (B) 0 -$30,000 -$30,000 1 13,000 5,000 2 11,000 5,000 3 9,000 5,000 4 7,000 5,000 5 0 5,000 6 7 8 9 10 0 0 0 0 0 5,000 5,000 5,000 5,000 5,000 The required rate of return is 10%. 3). What is the payback period for each of the projects? Which project should be accepted if the payback period method is applied? Assume that the target payback period is 4 years. Explain why. (4). What...
Project Year 0 Year 1 Year 2 Year 3 Year 4 A    -$ 49 $ 25...
Project Year 0 Year 1 Year 2 Year 3 Year 4 A    -$ 49 $ 25 $ 22 $ 22 $ 15 B -$ 101 $ 19 $ 39 $ 51 $ 61 a. What are the IRRs of the two​ projects? b. If your discount rate is 4.8%​, what are the NPVs of the two​ projects? c. Why do IRR and NPV rank the two projects​ differently?
Year   Project A   Project B 0 –$200   –$200    1 80   100    2 80 100...
Year   Project A   Project B 0 –$200   –$200    1 80   100    2 80 100    3 80 100    4 80       a)   If the opportunity cost of capital is 10%, which of these projects is worth pursuing? Explain. b)   Suppose that you can choose only one of these projects. Which would you choose? The discount rate is still 10%. Justify your reasoning. c)   Which project would you choose if the opportunity cost of capital were 16%?...
3. AICC is considering the following two projects: (2 pts) Project Year 0 1 2 3...
3. AICC is considering the following two projects: (2 pts) Project Year 0 1 2 3 A Cash flows -$50 $15 $25 $25 B Cash flows -$50 $20 $25 $30 a. If these projects are mutually exclusive, which project should the company invest in based on the NPV and IRR if the WACC = 10%? b. Calculate MIRR, payback period, and discounted payback period for the project you chose to invest in from part A only.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT