Question

In: Finance

You are considering the following three projects. A & B are mutually exclusive while C is...

You are considering the following three projects. A & B are mutually exclusive while C is independent.

Question: On one graph, plot the NPV profile for Both projects, A&B.

please show how on excel

Following are their expected cash flows

year

project A

Project B

Project C

0

-60,000.00

-40,000.00

-20,000.00

1

0

40,000.00

35,000.00

2

                   82,000.00

                   40,000.00

                    30,000.00

3

                   60,000.00

                   20,000.00

                       2,000.00

4

20,000.00

10,000.00

-40,000.00

Solutions

Expert Solution

Here in question ask for NPV graphs for project A&B only. So i don't take project C cash flows in answer.

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

JPMorgan Chase is considering the following mutually exclusive projects: A, B, C, D, and E with...
JPMorgan Chase is considering the following mutually exclusive projects: A, B, C, D, and E with the following cash flows: A: Initial Investment = -$15,000, Year 1 = $20,000, Year 2 = $25,000 B: Initial Investment = -$10,000, Year 1 = $14,000, Year 2 = $20,000 C: Initial Investment = -$12,000, Year 1 = $18,000, Year 2 = $15,000 D: Initial Investment = -$13,000, Year 1 = $22,000, Year 2 = $12,000 E: Initial Investment = -$20,000, Year 1 =...
You are considering the following three mutually exclusive projects. The required rate of return for all...
You are considering the following three mutually exclusive projects. The required rate of return for all three projects is 14%. Year A B C 0 $ (1,000) $(5,000) $(50,000) 1 $ 300 $ 1,700 $ 0 2 $300   $ 1,700 $15,000 3 $ 600 $1,700 $ 28,500 4 $300 $1,700 $ 33,000 What is the IRR of the best project? % terms to 2 decimal places w/o % sign
You are considering the following two mutually exclusive projects. YEAR             PROJECT (A)         PROJECT (B)        0&
You are considering the following two mutually exclusive projects. YEAR             PROJECT (A)         PROJECT (B)        0                  -$35,000                  -$35,000     1                     22,000                     13,000     2                     20,000                     21,000     3                     13,000                     22,000 What is the internal rate of return of PROJECT A?
You are considering the following two mutually exclusive projects. YEAR             PROJECT (A)         PROJECT (B)        0&
You are considering the following two mutually exclusive projects. YEAR             PROJECT (A)         PROJECT (B)        0                  -$35,000                  -$35,000     1                     22,000                     13,000     2                     20,000                     21,000     3                     13,000                     22,000 What is the crossover point?
Swenson's is considering two mutually exclusive projects, Projects A and B, and has determined that the...
Swenson's is considering two mutually exclusive projects, Projects A and B, and has determined that the crossover rate for these projects is 11.7 percent and the required return for both projects is 9 percent. Given this you know that: Multiple Choice both projects have a zero NPV at a discount rate of 11.7 percent. neither project will be accepted if the discount rate is less than 11.7 percent. the project that is acceptable at a discount rate of 11 percent...
You are considering the following two mutually exclusive projects that will not be repeated. The required...
You are considering the following two mutually exclusive projects that will not be repeated. The required rate of return is 11.25% for project A and 10.75% for project B. Which project should you accept and why? Year      Project A Project B 0 -48,000 -126,900 1 18,400 69,700 2 31,300 80,900 3 11,700 0 project A; because its NPV is about $335 more than the NPV of project B project A; because it has the higher required rate of return project...
You are considering the following two mutually exclusive projects. Project A Project B Year 0 -$10,000...
You are considering the following two mutually exclusive projects. Project A Project B Year 0 -$10,000 -$20,000 Year 1 $ 3,000 $ 5,000 Year 2 $ 8,000 $ 7,000 Year 3 $ 4,000 $12,000 Year 4 $ 2,000 $10,000 The required return on each project is 12 percent. Which project should you accept and what is the best reason for that decision? a. Project B; because it has the higher net present value b. Project A; because it pays back...
You are considering two mutually exclusive projects, A and B. Project A costs $70,000 and generates...
You are considering two mutually exclusive projects, A and B. Project A costs $70,000 and generates cash flows of $10,000 for 10 years. Project B costs $80,000 and generates cash flows of $2,000 for six years and then cash flows of $28,000 for four years. Report rates in percentage form to two decimal places i.e. 10.03% not 10% At what discount rate would make you indifferent between choosing one project or another? What is the highest discount rate in which...
You are considering two mutually exclusive projects, A and B. Project A costs $70,000 and generates...
You are considering two mutually exclusive projects, A and B. Project A costs $70,000 and generates cash flows of $12,000 for 10 years. Project B costs $60,000 and generates cash flows of $2,000 for six years and then cash flows of $29,000 for four years. Which project would you accept if your discount rate was 10%? Which project would you accept if your discount rate was 5%?
Heller Airlines is considering two mutually exclusive projects, A and B. The projects have the same...
Heller Airlines is considering two mutually exclusive projects, A and B. The projects have the same risk. Below are the cash flows from each project: Project A Project B Year Cash Flow Cash Flow 0 -$2,000 -$10,000 1 6,000 15,000 a. Graph the NPV profile of each investment. b. Indicate the crossover point and calculate the crossover rate. c. If the cost of capital is 8%, which project should be chosen and why?
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT