Question
In: Finance
(Related to Checkpoint 11.6) (Calculating MIRR) The Dunder Muffin Company is considering purchasing a new commercial...
(Related to Checkpoint 11.6) (Calculating MIRR) The Dunder Muffin Company is considering purchasing a new commercial oven that costs $320 comma 000. This new oven will produce cash inflows of $165 comma 000 at the end of Years 1 through 10. In addition to the cash inflows, at the end of Year 5 there will be a net cash outflow of $245 comma 000. The company has a weighted average cost of capital of 11.8 percent. What is the MIRR of the investment? Would you make the investment? Why or why not? Note that we discounted the project's negative cash flows back to the present using the project's required rate of return and then computed the MIRR from the modified cash flows.
The MIRR of the investment with a discount rate of 11.8% is Round to two decimal places.)
Would you make the investment? Why or why not? (Select the best choice below.)
A.
Yes, the project is worthwhile based on this measure because the MIRR is greater than the discount rate.
B.
Yes, the project is worthwhile based on this measure because the MIRR is less than the discount rate.
C.
No, the project is not worthwhile based on this measure because the MIRR is greater than the discount rate.
D.
No, the project is not worthwhile based on this measure because the MIRR is less than the discount rate.
Solutions
Expert Solution
MIRR = 21.57%
A. Yes, the project is worthwhile based on this measure because the MIRR is greater than the discount rate.
The net cash flows are
| Year | Initialcost | Cash flow | Cash outflow | Net Cash flows |
| 0 | -320000 | -320000 | ||
| 1 | 165000 | 165000 | ||
| 2 | 165000 | 165000 | ||
| 3 | 165000 | 165000 | ||
| 4 | 165000 | 165000 | ||
| 5 | 165000 | -245000 | -80000 | |
| 6 | 165000 | 165000 | ||
| 7 | 165000 | 165000 | ||
| 8 | 165000 | 165000 | ||
| 9 | 165000 | 165000 | ||
| 10 | 165000 | 165000 |
MIRR is computed using MIRR function in excel as below
jeff jeffy answered 1 year agoRelated Solutions
(Related to Checkpoint 11.6) (MIRR calculation) Emily's Soccer Mania is considering building a new plant. This...
(Related to Checkpoint 11.6) (MIRR calculation) Emily's
Soccer Mania is considering building a new plant. This project
would require an initial cash outlay of $10 million and would
generate annual cash inflows of $3 million per year for years one
through four. In year five the project will require an investment
outlay of $5 million. During years 6 through 10 the project will
provide cash inflows of $5 million per year. Calculate the
project's MIRR, given a discount rate of...
(Related to Checkpoint 11.1 and Checkpoint 11.4) (Calculating NPV, PI, and IRR) Fijisawa, Inc. is considering...
(Related to Checkpoint 11.1 and Checkpoint 11.4) (Calculating
NPV, PI, and IRR) Fijisawa, Inc. is considering a major
expansion of its product line and has estimated the following cash
flows associated with such an expansion. The initial outlay would
be $11 comma 300 comma 000, and the project would generate cash
flows of $1 comma 150 comma 000 per year for 20 years. The
appropriate discount rate is 6.8 percent.
a. Calculate the NPV.
b. Calculate the PI.
c. Calculate...
Dunder Mifflin Paper Company is considering purchasing a new stamping machine that costs $450,000. This new...
Dunder Mifflin Paper Company is considering purchasing a new
stamping machine that costs $450,000. This new machine will
produce cash inflows of $150,000 each year at the end of years 1
through 5, then at the end of year 7 there will be a cash
outflow of $200,000 The company has a weighted average
cost of capital of 14 percent (use this as the reinvestment
rate). What is the MIRR of the investment?
(Related to Checkpoint 12.1) (Calculating project cash flows and NPV) You are considering expanding your product...
(Related to Checkpoint
12.1) (Calculating project cash flows and
NPV) You are considering expanding your product line that
currently consists of skateboards to include gas-powered
skateboards, and you feel you can sell
12 comma 00012,000
of these per year for
1010
years (after which time this project is expected to shut down
with solar-powered skateboards taking over). The gas skateboards
would sell for
$130130
each with variable costs of
$4545
for each one produced, and annual fixed costs associated with...
Related to Checkpoint 12.1) (Calculating project cash flows and NPV) You are considering expanding your product...
Related to Checkpoint 12.1) (Calculating project cash flows
and NPV) You are considering expanding your product line that
currently consists of skateboards to include gas-powered
skateboards, and you feel you can sell 8 comma 000 of these per
year for 10 years (after which time this project is expected to
shut down with solar-powered skateboards taking over). The gas
skateboards would sell for $120 each with variable costs of $25
for each one produced, and annual fixed costs associated with...
(Related to Checkpoint 12.1) (Calculating project cash flows and NPV) You are considering expanding your product...
(Related to Checkpoint 12.1) (Calculating project cash flows
and NPV) You are considering expanding your product line that
currently consists of skateboards to include gas-powered
skateboards, and you feel you can sell 9 000 of these per year for
10 years (after which time this project is expected to shut down
with solar-powered skateboards taking over). The gas skateboards
would sell for $80 each with variable costs of $35 for each one
produced an annual fixed cost associated with production...
(Related to Checkpoint 12.1) (Calculating project cash flows and NPV) You are considering expanding your product...
(Related to Checkpoint 12.1) (Calculating project cash flows
and NPV) You are considering expanding your product line that
currently consists of skateboards to include gas-powered
skateboards, and you feel you can sell 9 comma 000 of these per
year for 10 years (after which time this project is expected to
shut down with solar-powered skateboards taking over). The gas
skateboards would sell for $130 each with variable costs of $30
for each one produced, and annual fixed costs associated with...
(Related to Checkpoint 12.1)(Calculating project cash flows and NPV)You are considering expanding your product line that...
(Related to Checkpoint 12.1)(Calculating project cash flows
and NPV)You are considering expanding your product line that
currently consists of skateboards to include gas-powered
skateboards, and you feel you can sell 11,000 of these per year for
10 years (after which time this project is expected to shut down
with solar-powered skateboards taking over). The gas skateboards
would sell for $110 each with variable costs of $35 for each one
produced, and annual fixed costs associated with production would
be $180,000....
(Related to Checkpoint 18.2) (Calculating the cost of short-term financing) The R. Morin Construction Company needs...
(Related to Checkpoint 18.2) (Calculating the cost of
short-term financing) The R. Morin Construction Company needs to
borrow $90,000 to help finance the cost of a new $135,000
hydraulic crane used in the firm's commercial construction
business. The crane will pay for itself in one year, and the firm
is considering the following alternatives for financing its
purchase: Alternative A. The firm's bank has
agreed to lend the $90,000 at a rate of 12 percent. Interest would
be discounted, and...
Related to Checkpoint 13.5) (Real options and capital budgeting) You are considering introducing a new...
Related to Checkpoint 13.5) (Real
options and capital budgeting) You are considering
introducing a new Tex-Mex-Thai fusion restaurant. The initial
outlay on this new restaurant is
$6.96.9
million and the present value of the free cash flows (excluding
the initial outlay) is
$5.35.3
million, such that the project has a negative expected NPV
of
$1.61.6
million. Upon closer examination, you find that there is a
5555
percent chance that this new restaurant will be well received
and will produce...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Write a function that tells whether a hailstone sequence contains a number that is greater than...
- 1D List Practice Could you write the code to solve the following problem that uses 1D...
- How the concept of moral hazard can be applied to the 2008 financial crisis?
- Write a program that prints and calls two methods. 1. Compute and return the future value...
- Assume you have been selected to lead your team in the development of a quality management...
- java You are creating an array where each element is an (age, name) pair representing guests...
- Joni is a financial planner for ABC firm. She provided all of her clients with the...
ADVERTISEMENT