Question

In: Finance

There is a project with the following cash flows: CF0 = -850; CF1 = 300; CF2...

There is a project with the following cash flows: CF0 = -850; CF1 = 300; CF2 =320; CF3 = 340; CF4 = 360. If the appropriate discount rate is 10%, what is the project's MIRR? (Assume the same reinvestment rate)

14.08%

15.65%

17.21%

18.29%

19.15%

Solutions

Expert Solution

Compute the present value of cash flows, using MS-excel as shown below:

The result of the above excel table is as follows:

Hence, the present value of cash flows is $1038.52195888.

Compute the future value of cash inflows, using the equation as shown below:

Future value = Present value*(1 + Rate)Time

                     = $1,038.52195888*(1 + 0.10)4

                     = $1,038.52195888*1.4641

                     = $1,520.49999999

Hence, the future value of cash flows is $1,520.49999999.

Compute the modified internal rate of return (MIRR), using the equation as shown below:

MIRR = (Future value of cash inflows/ Present value of outflows)1/ Time – 1

           = ($1,520.49999999/ $850)1/4 – 1

          = (1.7888235294)1/4 – 1

           = 1.156489981 – 1

           = 15.6489981%

Hence, the MIRR is 15.65%.


Related Solutions

A potential CB project has the following cash flows: CF0 = -$500, CF1 = $300, CF2...
A potential CB project has the following cash flows: CF0 = -$500, CF1 = $300, CF2 = $200, CF3 = $150. WACC = 6%. Compute the following: A. Payback Period B. NPV C. IRR
Match up the payback period with the cash flows.    CF0: -1800 CF1: 930 CF2: 130...
Match up the payback period with the cash flows.    CF0: -1800 CF1: 930 CF2: 130 CF3: 830 CF4: 420 CF0: -1900 CF1: 800 CF2: 350 CF3: 720 CF4: 120    CF0: -2000 CF1: 820 CF2: 170 CF3: 830 CF4: 320 CF0: -1750 CF1: 700 CF2: 350 CF3: 520 CF4: 450 CF0: -1550 CF1: 500 CF2: 170 CF3: 840 CF4: 320 A. About 3.56 years B. About 3.40 years C. About 3.13 years D. About 2.89 years E. About 3.25...
QUESTION Match up the payback period with the cash flows. CF0: -1360 CF1: 560 CF2: 330...
QUESTION Match up the payback period with the cash flows. CF0: -1360 CF1: 560 CF2: 330 CF3: 820 CF4: 200 CF0: -530 CF1: 500 CF2: 100 CF3: 970 CF4: 130 CF0: -900 CF1: 680 CF2: 110 CF3: 950 CF4: 180 CF0: -1675 CF1: 580 CF2: 240 CF3: 700 CF4: 180 CF0: -1230 CF1: 590 CF2: 240 CF3: 550 CF4: 410 A. About 2.73 years B. About 2.12 years C. About 3.86 years D. About 2.57 years E. About 1.30 years
An investment project has the following cash flows: CF0 = -1,000,000; CF1 – CF8 = 200,000...
An investment project has the following cash flows: CF0 = -1,000,000; CF1 – CF8 = 200,000 each. If the required rate of return is 12%: a.       What decision should be made using NPV? (5%) b.      How would the IRR decision rule be used for this project? What decision would be reached? (10%)              c.       How are the above two decisions related? (10%)
Calculate the IRR(s) for a 10-year project with the following cash flows: CF0 = -30, CF1...
Calculate the IRR(s) for a 10-year project with the following cash flows: CF0 = -30, CF1 = 10 = CF2 = CF3 = CF4 = CF5 = CF6 = CF7 = CF8 = CF9, and CF10 = -65. In Excel, plot the NPV against r (= discount rate), using r = 0%, 2%, 4%, 6%, 8%, 10%, 12%, 14%, 16%, 18%, 20%, 22%, 24%, 26%, 28%, and so on until you find all IRRs on the horizontal axis. Approximately, what...
Your company is considering the following three projects. CF0 CF1 CF2 CF3 CF4 Project Whiskey -100...
Your company is considering the following three projects. CF0 CF1 CF2 CF3 CF4 Project Whiskey -100 80 20 80 20 Project Tango -100 20 80 20 80 Project Foxtrot -100 50 50 50 50 1) What is Project Foxtrot’s MIRR? And, should the project be accepted if we used MIRR as the basis of decision? Assume that the cost of capital is 8%. Show your calculator inputs (CF0=?, CF1=?, CF2=?, CF3=?, CF4=?, etc.) to receive full credit. 2) What is...
a. Find present value of the following cash flows at 3% rate: CF0 = -1000; CF1...
a. Find present value of the following cash flows at 3% rate: CF0 = -1000; CF1 = 300; CF2 = 560; CF3 = -90; CF4 = 250. b. What is the future value of these cash flows?
There are two projects: Project A and Project B a. Project A: CF0 = -6000; CF1-5...
There are two projects: Project A and Project B a. Project A: CF0 = -6000; CF1-5 = 2000; I/YR = 14. Calculate NPV, IRR, MIRR, Payback period, and discounted payback period for Project A. Project B: CF0 = -18000; CF1-5 = 5600; I/YR = 14. Calculate NPV, IRR, MIRR, Payback period, and discounted payback period for Project B. b. If the two projects are independent, which project(s) would be accepted? c. If the two projects are mutually exclusive, which project...
You have the chance to participate in a project that produces the following cash flows. CF0=?...
You have the chance to participate in a project that produces the following cash flows. CF0=? CF1=$0 CF2=$11,000 The NPV of the project is $4,090.91. If the opportunity cost of capital is 10%, a) you would accept the project, if the IRR is greater than the required return. b) you would not accept the project, as the largest cash inflow occurs at the end of the project. c) you would not be able to decide whether to accept the project,...
An investment project has the following cash flows: CF0 = -1,200,000; C01 – C05 = 300,000...
An investment project has the following cash flows: CF0 = -1,200,000; C01 – C05 = 300,000 each If the required rate of return is 12%, calculate IRR= (   )%.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT