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

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

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

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

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

  • Sydra's Bakery plans to purchase a new oven for its store. The oven has an estimated...

    Sydra'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. Sydra's Bakery has an 8% after-tax required rate of return and a 34% income tax rate. Assume depreciation is calculated on a straight-line basis for tax purposes using the initial investment in the oven and its...

  • udicates problems in Excel Study Problems All Study Problems are available in MyLab Finance. The X...

    udicates problems in Excel Study Problems All Study Problems are available in MyLab Finance. The X icon indicates problems Mylab format available in MyLab Finance. LO2 10-1. (Payback Period) What is the payback period for the following set of cash flowe YEAR CASH FLOWS --- $11,300 3,400 4,300 3,600 4,500 3,500 x 10-2. (IRR calculation) Determine the IRR on the following projects: a. An initial outlay of $10,000 resulting in a single free cash flow of $17,182 after 8 years...

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
Active Questions
ADVERTISEMENT