Question

Microwave Oven​ Programming, Inc. is considering the construction of a new plant. The plant will have...

Microwave Oven​ Programming, Inc. is considering the construction of a new plant. The plant will have an initial cash outlay of

​$14 million, and will produce cash flows of $5 million at the end of year​ 1, $6 million at the end of year​ 2, and $4

million at the end of years 3 through 5. What is the internal rate of return on this new​ plant?

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

Bookl - Microsoft Exce Home Insert Page Layout Formulas Data Review View ,@ _ 히 X Cut Copy Σ Autosum Condittonal asor bat Styles Insert Delete Format Fite & Find& Paste Format Painter Blu - Merge & Cer ter- , t Sort &Find & Filter Select- r Clear , Clear▼ Formatting as Table Styles Clipboard Alignment Cells Editing 0 YearCash flows ($ in m 14 unction Arguments IRR Values 33 B3 -14:5:6:4:4:4 蔨 0.20636621 Returns the intenal rate of return for a senes of cash flows. Values is an array or a reference to cels that contain numbers for which you want to 10 IRR 11 IRR -IRR(B3:B8) caloulate the intemal rate of retun. 20.64%, 13 Formula result= 20.64% 15 17 19 21 11 Sheet1/Sheet2(Sheet3 (u 17:50 13-01-2019Internal rate of return on this new​ plant is 20.64%

Add a comment
Know the answer?
Add Answer to:
Microwave Oven​ Programming, Inc. is considering the construction of a new plant. The plant will have...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • (IRR of uneven​ cash-flow stream​) Microwave Oven​ Programming, Inc. is considering the construction of a new...

    (IRR of uneven​ cash-flow stream​) Microwave Oven​ Programming, Inc. is considering the construction of a new plant. The plant will have an initial cash outlay of ​$12 ​million, and will produce cash flows of ​$4 million at the end of year​ 1, $ 5 million at the end of year​ 2, and ​$3 million at the end of years 3 through 5. What is the internal rate of return on this new​ plant? The internal rate of return on this...

  • (IRR of uneven cash-flow stream) Microwave Oven Programming, Inc. is considering the construction of a new...

    (IRR of uneven cash-flow stream) Microwave Oven Programming, Inc. is considering the construction of a new plant. The plant will have an initial cash outlay of $15 million, and will produce cash flows of $5 million at the end of year 1, $6 million at the end of year 2, and $4 million at the end of year 3 through 5. What is the internal rate of return on this new plant?

  • Emily's Soccer Mania is considering building a new plant. This project would require an initial cash...

    Emily's Soccer Mania is considering building a new plant. This project would require an initial cash outlay of $10.5 million and would generate annual cash flows of $2 million per year for years one through four. In year five the project will require an investment outlay of $6 million.During years 6 through 10 the project will provide cash inflows of $ million. Calculate the project's MIRR, given a discount rate of 13 percent. The MIRR of the project with discount...

  • 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...

  • 88. Americo Corp is considering construction a manufacturing plant in Turkey. The initial invest will cost...

    88. Americo Corp is considering construction a manufacturing plant in Turkey. The initial invest will cost 15 million Turkish Lira (L). The company plans to keep the plant open for 3 years during which cash flows from operations will be 5million, 5million and 4 million Liras respectively at end each of the three years. At end of the third year Americo plans to sell the plant for 10 million liras. Americo’s required rate of return is 15% and the current...

  • 10. LO 11.5 The Ham and Egg Restaurant is considering an investment in a new oven...

    10. LO 11.5 The Ham and Egg Restaurant is considering an investment in a new oven that has a cost of $60,000, with annual net cash flows of $9.950 for 8 years. The required rate of return is 6%. Compute the net present value of this investment to determine whether or not you would recommend that Ham and Egg invest in this oven. Solution Year Cash Flows Factor NPV Initial investment Years 1-8 NPV The Ham and Egg should Page...

  • (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

  • DYI Construction Co. is considering a new inventory system that will cost $1.25 million

    DYI Construction Co. is considering a new inventory system that will cost $1.25 million. The system is expected to generate positive cash flows over the next six years in the amounts of $375,000 in year one, $325,000 per year during years two through four, $150,000 in year five, and $180,000 in year six. DYI's required rate of return is 8%. What is the internal rate of return of this project? 6.56% 10.64% 11.36% 9.93%

  • Mass Distribution Inc. is considering the construction of a facility at a cost of $25 million....

    Mass Distribution Inc. is considering the construction of a facility at a cost of $25 million. The project will produce positive cash flows of $10 million per year for the next 4 years but the 5th and final year will have a net negative cash flow of $6 million. If the reinvestment rate is 6% and the cost of capital is 9%, the MIRR of this project is ________ and the project should be ________ (accepted/rejected) Show all work and...

  • New equipment purchase, income taxes. Ella's Bakery plans to purchase a new oven for its store....

    New equipment purchase, income taxes. Ella's Bakery plans to purchase a new oven for its store. The oven has an estimated useful life of 4 years. The estimated pretax cash flows for the oven are as shown in the table that follows, with no anticipated change in working capital. Ella's Bakery has a 14% after-tax required rate of return and a 35% income tax rate. Assume depreciation is calculated on a straight-line basis for tax purposes using the initial investment...

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