Question

In: Finance

​​ Considering the following projects. Project Year 0 1 2 3 4 A Cash flows -$100...

​​

  1. Considering the following projects.

Project

Year

0

1

2

3

4

A

Cash flows

-$100

$35

$35

$35

$35

B

Cash flows

-$100

$60

$50

$40

$30

If project B is risker than project A, in which project A has WACC = 6.00% while project B has WACC = 8.50%. If these two projects are mutually exclusive, which project should the company accept?

Compute: NPV, IRR, MIRR, payback, and discounted payback period for each project.

# please with details.

Solutions

Expert Solution

Solution:-

To Calculate NPV of the Project-

In Mutually Exclusive Project, Project is accepted huge NPV is higher. Project B is accepted.

To Calculate IRR of the Project-

To Calculate Payback Period of Project A-

Payback Period =

Payback Period =

Payback Period = 2.86 years

Payback Period of Project B-

Payback Period =

Payback Period of Project B
Year Cash Flow Cummulative Cash Flow
0 -100
1 60 60
2 50 110
3 40 150
4 30 180

Payback Period =

Payback Period = 1.80 years

To Calculate MIRR-

MIRR Formula =

Project A-

Future Value
Year Deposit Amount WACC @ 6% Future Value
1 35 1.191 41.69
2 35 1.124 39.33
3 35 1.060 37.10
4 35 1.000 35.00
Future Value 153.11

MIRR =

MIRR = 11.24%

MIRR of Project B-

Future Value
Year Deposit Amount WACC @ 8.50% Future Value
1 60 1.277 76.64
2 50 1.177 70.63
3 40 1.085 54.25
4 30 1.000 40.00
Future Value 241.52

MIRR =

MIRR = 24.66%

If you have any query related to question then feel free to ask me in a comment.Thanks. Please rate.


Related Solutions

You have 3 projects with the following cash​ flows: Year 0 1 2 3 4 Project...
You have 3 projects with the following cash​ flows: Year 0 1 2 3 4 Project 1 -$ 152 $22 $39 $58 $82 Project 2          −826 0 0 7,010 −6,506 Project 3 21 41 61 80   −247 a. For which of these projects is the IRR rule​ reliable? b. Estimate the IRR for each project​ (to the nearest1%​). c. What is the NPV of each project if the cost of capital is 5%​?20 %50%​? a. For which of these...
You have 3 projects with the following cash​ flows: Year 0 1 2 3 4 Project...
You have 3 projects with the following cash​ flows: Year 0 1 2 3 4 Project 1 −$151 $ 21 $ 39 $ 59 $ 80 Project 2                                                −824 00 00 6,999 −6,501 Project 3 2020 40 62 81 −245 a. For which of these projects is the IRR rule​ reliable? b. Estimate the IRR for each project​ (to the nearest 1%​). c. What is the NPV of each project if the cost of capital is 5%​? 20%​? 50%​? a....
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...
Projects A and B have the following cash flows respectively: Year 0 1 2 3 4...
Projects A and B have the following cash flows respectively: Year 0 1 2 3 4 CFA −$2,050    $750    $760    $770    $780 CFB −$4,300 $1,500 $1,518 $1,536 $1,554 Both projects have a required return of 10.25%. What are NPV and IRR of the two projects? If project A and B are mutually exclusive, what is your decision with regard to accepting vs. rejecting each project? Why? What is the crossover rate?
You have 3 projects with the following cash​ flows: Year    0       1   2     ...
You have 3 projects with the following cash​ flows: Year    0       1   2      3         4 Project 1   -$149   $19   $42   $61      $79 Project 2   -827      0   0   7,002   -6,508 Project 3   18          39   62   81      -247 a. For which of these projects is the IRR rule​ reliable?_______. b. Estimate the IRR for each project​ (to the nearest 1 %​).________. c. What is the NPV of each project if the cost of capital is 5...
There are two projects with the following cash flows. Years: 0 1 2 3 4 5...
There are two projects with the following cash flows. Years: 0 1 2 3 4 5 Project 1: -210 125 125 175 175 -400 Project 2:  300 -95 -75 -125 -400 600 a. What are the NPVs of these two projects if market interest rate is 3%? b. With the interest rate of 6%, please modified these two projects to let them have only one IRR for each one of them. (That means the sign of cash flows of each project...
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.
The following are the cash flows of two projects: Year Project A Project B 0 ?$...
The following are the cash flows of two projects: Year Project A Project B 0 ?$ 380 ?$ 380 1 210 280 2 210 280 3 210 280 4 210 If the opportunity cost of capital is 11%, what is the profitability index for each project? (Do not round intermediate calculations. Round your answers to 4 decimal places.)
The following are the cash flows of two projects: Year Project A Project B 0 ?$...
The following are the cash flows of two projects: Year Project A Project B 0 ?$ 280 ?$ 280 1 160 180 2 160 180 3 160 180 4 160 If the opportunity cost of capital is 10%, what is the profitability index for each project? (Do not round intermediate calculations. Round your answers to 4 decimal places.) Project A Profitability Index Project B
The following are the cash flows of two projects: Year Project A Project B 0 −$...
The following are the cash flows of two projects: Year Project A Project B 0 −$ 290 −$ 290 1 170 190 2 170 190 3 170 190 4 170 If the opportunity cost of capital is 11%, what is the profitability index for each project? (Do not round intermediate calculations. Round your answers to 4 decimal places.)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT