Question

Emily's Soccer Mania is considering building a new plant

(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 $11 million and would generate annual cash inflows of $3.5 million per year for years one through four. In year five the project will require an investment outlay of $4.2 million. During years 6 through 10 the project will provide cash inflows of $4.2 million per year. Calculate the project's MIRR, given a discount rate 9 percent. 


The MIRR of the project with a discount rate of 9% is %_______ . (Round to two decimal places.)


1 0
Add a comment Improve this question Transcribed image text
✔ Recommended Answer
Answer #1

=MIRR(B111 : B121,9%,9%) B123 A B C D E F 110 Cash flows Year (11.00) 1 $ 2 $ 3 $ 4 $ 5 $ 6 $ 7 $ 8$ 9 $ 10$ 111 112 3.50 113

Add a comment
Know the answer?
Add Answer to:
Emily's Soccer Mania is considering building a new plant
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • This Test: 100 pts possible All EQuestion Help (Related to Checkpoint 11.6) (MIRR calculation) Emily's Soccer...

    This Test: 100 pts possible All EQuestion Help (Related to Checkpoint 11.6) (MIRR calculation) Emily's Soccer Mania is con million and would generate annual cash infows of $3. million. During years 6 through 10 the project wl provide cash infows of $4 2 million per year. Caiculate the projecr's MIRR. given a The MIRR of the project with a discount rate of 12%»D%.(Round to two decimal places) sidering building a new piant. This project would require an intial cash outlay...

  • (MIRR calculation) Artie's Wrestling Stuff is considering building a new plant. This plant would require an...

    (MIRR calculation) 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 $3 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 11 percent c. A required rate of return of 16 percent

  • Dowling Sportswear is considering building a new factory to produce aluminum baseball bats

    (Related to Checkpoint 11.1) (Net present value calculation) Dowling Sportswear is considering building a new factory to produce aluminum baseball bats. This project would require an initial cash outlay of $5,500,000 and would generate annual net cash inflows of $900,000 per year for 6 years. Calculate the project's NPV using a discount rate of 5 percent. If the discount rate is 5 percent, then the project's NPV is $_______ (Round to the nearest dollar)

  • Dowling Sportswear is considering building a new factory to produce aluminum baseball bats.

    (Related to Checkpoint 11.1) (Net present value calculation) Dowling Sportswear is considering building a new factory to produce aluminum baseball bats. This project would require an initial cash outlay of $4,000,000 and would generate annual net cash inflows of $900,000 per year for 7 years. Calculate the project's NPV using a discount rate of 5 percent. If the discount rate is 5 percent, then the project's NPV is _______ $ . (Round to the nearest dollar.)

  • Dowling Sportswear is considering building a new factory to produce aluminum baseball bats

    (Related to Checkpoint 11.1) (Net present value calculation) Dowling Sportswear is considering building a new factory to produce aluminum baseball bats. This project would require an initial cash outlay of $5,000,000 and would generato annual net cash inflows of $1,000,000 per year for 8 years Calculate the project's NPV using a discount rate of 9 percent. If the discount rate is 9 percent, then the project's NPV is _______  (Round to the nearest dollar)(Net present value calculation) Carson Trucking is considering...

  • Dowling Sportswear is considering building a new factory to produce aluminum baseball bats

    (Net present value calculation) Dowling Sportswear is considering building a new factory to produce aluminum baseball bats. This project would require an initial cash outlay of $4,000,000 and would generate annual net cash inflows of $900,000 per year for 9 years. Calculate the project's NPV using a discount rate of 8 percent. If the discount rate is 8 percent, then the project's NPV is $ _______ (Round to the nearest dollar.)

  • Question Help (Calculating MIRR) OTR Trucking Company runs a fleet of long-haul trucks and has recently...

    Question Help (Calculating MIRR) OTR Trucking Company runs a fleet of long-haul trucks and has recently expanded into the Midwest, where it has decided to build a maintenance facility. This project will require an initial cash outlay of $19.5 million and will generate annual cash inflows of $3.5 million per year for Years 1 through 3. In Year 4, the project will provide a net negative cash flow of $4.5 million due to anticipated expansion of and repairs to the...

  • Dowling Sportswear is considering building a new factory to produce aluminum baseball bats. This project would...

    Dowling Sportswear is considering building a new factory to produce aluminum baseball bats. This project would require an initial cash outlay of ​$5 comma 000 comma 0005,000,000 and would generate annual net cash inflows of ​$1 comma 000 comma 0001,000,000 per year for 88 years. Calculate the​ project's NPV using a discount rate of 99 percent.

  • Dowlings Sportswear is considering building a new factory to produce aluminum baseball bats. This project would...

    Dowlings Sportswear is considering building a new factory to produce aluminum baseball bats. This project would require an initial cash outlay of $6,000,000 and would generate annual net flows of $1,200,000 per year for 9 years. Calculate the project's NPV using a discount rate of 3 5 percent. If the discount rate is 5 percent, then the project's NPV is $

  • ​(NPV with varying required rates of return​) Gubanich Sportswear is considering building a new factory to...

    ​(NPV with varying required rates of return​) Gubanich Sportswear is considering building a new factory to produce aluminum baseball bats. This project would require an initial cash outlay of ​$4,000,000 and would generate annual free cash inflows of ​$1,200,000 per year for 7 years. Calculate the​ project's NPV ​given: a. A required rate of return of 9 percent b. A required rate of return of 11 percent c. A required rate of return of 13 percent d. A required rate...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT