Question
In: Finance
Artie's Wrestling Stuff is considering building a new plant. This plant would require an initial cash...
Artie's Wrestling Stuff is considering building a new plant. This plant would require an initial cash outlay of $ 8 million and would generate annual free cash inflows of $ 1 million per year for 8 years. Calculate the project's MIRR given: a. A required rate of return of 9 percent b. A required rate of return of 12 percent c. A required rate of return of 15 percent
Solutions
Expert Solution
a
| Combination approach | |||||||||
| All negative cash flows are discounted back to the present and all positive cash flows are compounded out to the end of the project’s life | |||||||||
| Thus year 8 modified cash flow=(1.83)+(1.68)+(1.54)+(1.41)+(1.3)+(1.19)+(1.09)+(1) | |||||||||
| =11.04 | |||||||||
| Thus year 0 modified cash flow=-8 | |||||||||
| =-8 | |||||||||
| Discount rate | 9.000% | ||||||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| Cash flow stream | -8.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 |
| Discount factor | 1.000 | 1.090 | 1.188 | 1.295 | 1.412 | 1.539 | 1.677 | 1.828 | 1.993 |
| Compound factor | 1.000 | 1.828 | 1.677 | 1.539 | 1.412 | 1.295 | 1.188 | 1.090 | 1.000 |
| Discounted cash flows | -8.000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Compounded cash flows | -0.125 | 1.83 | 1.68 | 1.54 | 1.41 | 1.3 | 1.19 | 1.09 | 1 |
| Modified cash flow | -8.000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11.040 |
| Discounting factor (using MIRR) | 1.000 | 1.041 | 1.084 | 1.128 | 1.175 | 1.223 | 1.273 | 1.326 | 1.380 |
| Discounted cash flows | -8.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 7.999 |
| NPV = Sum of discounted cash flows | |||||||||
| NPV= | 0.00 | ||||||||
| MIRR is the rate at which NPV = 0 | |||||||||
| MIRR= | 4.11% | ||||||||
| Where | |||||||||
| Discounting factor = | (1 + discount rate)^(Corresponding period in years) | ||||||||
| Discounted Cashflow= | Cash flow stream/discounting factor | ||||||||
| Compounding factor = | (1 + reinvestment rate)^(time of last CF-Corresponding period in years) | ||||||||
| Compounded Cashflow= | Cash flow stream*compounding factor | ||||||||
b
| All negative cash flows are discounted back to the present and all positive cash flows are compounded out to the end of the project’s life | |||||||||
| Thus year 8 modified cash flow=(2.21)+(1.97)+(1.76)+(1.57)+(1.4)+(1.25)+(1.12)+(1) | |||||||||
| =12.28 | |||||||||
| Thus year 0 modified cash flow=-8 | |||||||||
| =-8 | |||||||||
| Discount rate | 12.000% | ||||||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| Cash flow stream | -8.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 |
| Discount factor | 1.000 | 1.120 | 1.254 | 1.405 | 1.574 | 1.762 | 1.974 | 2.211 | 2.476 |
| Compound factor | 1.000 | 2.211 | 1.974 | 1.762 | 1.574 | 1.405 | 1.254 | 1.120 | 1.000 |
| Discounted cash flows | -8.000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Compounded cash flows | -0.125 | 2.21 | 1.97 | 1.76 | 1.57 | 1.4 | 1.25 | 1.12 | 1 |
| Modified cash flow | -8.000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12.280 |
| Discounting factor (using MIRR) | 1.000 | 1.055 | 1.113 | 1.174 | 1.239 | 1.307 | 1.379 | 1.455 | 1.535 |
| Discounted cash flows | -8.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 8.000 |
| NPV = Sum of discounted cash flows | |||||||||
| NPV= | 0.00 | ||||||||
| MIRR is the rate at which NPV = 0 | |||||||||
| MIRR= | 5.50% | ||||||||
| Where | |||||||||
| Discounting factor = | (1 + discount rate)^(Corresponding period in years) | ||||||||
| Discounted Cashflow= | Cash flow stream/discounting factor | ||||||||
| Compounding factor = | (1 + reinvestment rate)^(time of last CF-Corresponding period in years) | ||||||||
| Compounded Cashflow= | Cash flow stream*compounding factor | ||||||||
c
jeff jeffy answered 1 year agoRelated Solutions
Emily’s Soccer Mania is considering building a new plant. This project would acquire an initial cash...
Emily’s Soccer Mania is considering building a new plant. This
project would acquire an initial cash outlay of $10 million and
would generate annual cash inflows of $3million per year for Years
1 through 4.In year 5 the project will acquire an investment outlay
of $5,000,000. During Years 6 through 10 the project will provide
cash inflows of $5million per year. Calculate the Project’s MIRR
given a discount rate of 14 percent
I want the answer in details not on...
Your firm is considering extending its operations by building a new plant, which will require an...
Your firm is considering extending its operations by building a
new plant, which will require an initial investment of $500M. You
have determined that the new division will have a 50% chance of
generating an annual free cash flow of $120M in perpetuity, a 40%
chance of an annual cash flow of $75M in perpetuity and a 10%
chance that the division will generate zero (0) cash. Your firm
uses 30% debt and 70% equity to finance its operations. Its...
The manager of Keebee, Inc. is considering a new project that would require an initial investment...
The manager of Keebee, Inc. is considering a new project that
would require an initial investment of $1,197,810. The
cost of capital or the required rate of return of this company is
10 percent. This project will generate an annual cash
inflow of $300,000 in the following five years.
Calculate the net present value (NPV) of this
project. Indicate whether or not this project is
acceptable.
Calculate the internal rate of return (IRR) of this
project.
You are the CFO and are considering introducing a new product that will require an initial...
You are the CFO and are considering introducing a new product
that will require an initial investment in equipment of $6 million.
The equipment will be depreciated straight line over 3 years to a
value of zero, and can be sold after 3 years for $500,000. Working
capital at each date must be maintained at a level of 10% of the
following year’s forecast sales. You estimate production costs at
$1.50 /unit and the sales price at $4/unit. Sales forecasts...
Kuhn Corporation is considering a new project that will require an initial investment of $4,000,000. It...
Kuhn Corporation is considering a new project that will require
an initial investment of $4,000,000. It has a target capital
structure consisting of 45% debt, 4% preferred stock, and 51%
common equity.
Kuhn has noncallable bonds outstanding that mature in five years
with a face value of $1,000, an annual coupon rate of 10%, and a
market price of $1,050.76. The yield on the company’s current bonds
is a good approximation of the yield on any new bonds that it...
Cooper Industries is considering a project that would require an initial investment of $101,000. The project...
Cooper Industries is considering a project that would require an
initial investment of $101,000. The project would result in cost
savings of $62,000 in year 1 and $70,000 in year two. What is the
internal rate of return?
Kuhn Co. is considering a new project that will require an initial investment of $4 million....
Kuhn Co. is considering a new project that will require an
initial investment of $4 million. It has a target capital structure
of 45% debt, 4% preferred stock, and 51% common equity. Kuhn has
noncallable bonds outstanding that mature in five years with a face
value of $1,000, an annual coupon rate of 10%, and a market price
of $1,050.76. The yield on the company’s current bonds is a good
approximation of the yield on any new bonds that it...
Kuhn Co. is considering a new project that will require an initial investment of $45 million....
Kuhn Co. is considering a new project that will require an
initial investment of $45 million. It has a target capital
structure of 45% debt, 4% preferred stock, and 51% common equity.
Kuhn has noncallable bonds outstanding that mature in five years
with a face value of $1,000, an annual coupon rate of 10%, and a
market price of $1,050.76. The yield on the company’s current bonds
is a good approximation of the yield on any new bonds that it...
Kuhn Co. is considering a new project that will require an initial investment of $4 million....
Kuhn Co. is considering a new project that will require an
initial investment of $4 million. It has a target capital structure
of 35% debt, 2% preferred stock, and 63% common equity. Kuhn has
noncallable bonds outstanding that mature in five years with a face
value of $1,000, an annual coupon rate of 10%, and a market price
of $1,050.76. The yield on the company’s current bonds is a good
approximation of the yield on any new bonds that it...
Kuhn Co. is considering a new project that will require an initial investment of $4 million....
Kuhn Co. is considering a new project that will require an
initial investment of $4 million. It has a target capital structure
of 45% debt, 4% preferred stock, and 51% common equity. Kuhn has
noncallable bonds outstanding that mature in 15 years with a face
value of $1,000, an annual coupon rate of 11%, and a market price
of $1555.38. The yield on the company’s current bonds is a good
approximation of the yield on any new bonds that it...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- With four Boolean inputs mentioned in the first four columns of the following table, report the...
- a. In your own words, define the concept of "Recursion" in terms of C++ programming. b....
- Write a program that creates a two-dimensional array initialized with test data. Use any primitive data...
- Write a java project that reads a sequence of up to 25 pairs of names and...
- The basic purpose of the United States legal system is to ensure fairness in balancing individual...
- How has the digital age changed culture? Apply one of the basic sociological perspectives to support...
- Complete drug card- Generic /brand name Category class expected Pharmacological Action Complications Contraindications/Precautions Interactions Medication Administration...
ADVERTISEMENT