Excel AssessmentA company is considering three mutually exclusive projects for its expansion plans. The initialinvestment in the project is OMR 400000. The finance director thinks that the project with thehigher NPV should be chosen, whereas the managing director believes that the higher IRR shouldbe undertaken, especially as projects have the same initial outlay and length of life. The companyanticipates a cost of capital of 10.5%, and the net after-tax cash flows of the projects are asfollows:YearCash Flow ACash Flow BCash Flow C1700004360009000016000020000149000180000200005120041500008000100000540000600049400(All amounts are in OMR)Required:(b) Which project will you advise to undertake to the company? Explain your answer(c) What deficiencies in IRR can be overcome by using MIRR?2.

Given information : Year Cash flow A Cash flow B Cash flow C 0 -400000 -400000 -400000 1…

A company is considering three mutually exclusive projects for its expansion nvestment in the project is OMR 400000. The finance director thinks that the nigher NPV should be chosen, whereas the managing director believes that the be undertaken, especially as projects have the same initial outlay and length of I anticipates a cost of capital of 10.5%, and the net after-tax cash flows of th Follows:

A company is considering three mutually exclusive projects for its expansion nvestment in the project is OMR 400000. The finance director thinks that the nigher NPV should be chosen, whereas the managing director believes that the be undertaken, especially as projects have the same initial outlay and length of I anticipates a cost of capital of 10.5%, and the net after-tax cash flows of th Follows:

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter12: Capital Budgeting: Decision Criteria

Section: Chapter Questions

Problem 13P

See similar textbooks

Similar questions

Staten Corporation is considering two mutually exclusive projects. Both require an initial outlay of 150,000 and will operate for five years. The cash flows associated with these projects are as follows: Statens required rate of return is 10%. Using the net present value method and the present value table provided in Appendix A, which of the following actions would you recommend to Staten? a. Accept Project X and reject Project Y. b. Accept Project Y and reject Project X. c. Accept Projects X and Y. d. Reject Projects X and Y.
Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,000 per year for 5 years. Project L costs $25,000 and is expected to produce cash flows of $7,400 per year for 5 years. Calculate the two projects’ NPVs, IRRs, MIRRs, and PIs, assuming a cost of capital of 12%. Which project would be selected, assuming they are mutually exclusive, using each ranking method? Which should actually be selected?
The Pinkerton Publishing Company is considering two mutually exclusive expansion plans. Plan A calls for the expenditure of 50 million on a large-scale, integrated plant that will provide an expected cash flow stream of 8 million per year for 20 years. Plan B calls for the expenditure of 15 million to build a somewhat less efficient, more labor-intensive plant that has an expected cash flow stream of 3.4 million per year for 20 years. The firms cost of capital is 10%. a. Calculate each projects NPV and IRR. b. Set up a Project by showing the cash flows that will exist if the firm goes with the large plant rather than the smaller plant. What are the NPV and the IRR for this Project ? c. Graph the NPV profiles for Plan A, Plan B, and Project .
Clearcast Communications Inc. is considering allocating a limited amount of capital investment funds among four proposals. The amount of proposed investment, estimated operating income, and net cash flow for each proposal are as follows: The companys capital rationing policy requires a maximum cash payback period of three years. In addition, a minimum average rate of return of 12% is required on all projects. If the preceding standards are met, the net present value method and present value indexes are used to rank the remaining proposals. Instructions 1. Compute the cash payback period for each of the four proposals. 2. Giving effect to straight-line depreciation on the investments and assuming no estimated residual value, compute the average rate of return for each of the four proposals. Round to one decimal place. 3. Using the following format, summarize the results of your computations in parts (1) and (2). By placing the computed amounts in the first two columns on the left and by placing a check mark in the appropriate column to the right, indicate which proposals should be accepted for further analysis and which should be rejected. 4. For the proposals accepted for further analysis in part (3), compute the net present value. Use a rate of 12% and the present value table appearing in Exhibit 2 of this chapter. 5. Compute the present value index for each of the proposals in part (4). Round to two decimal places. 6. Rank the proposals from most attractive to least attractive, based on the present values of net cash flows computed in part (4). 7. Rank the proposals from most attractive to least attractive, based on the present value indexes computed in part (5). 8. Based on the analyses, comment on the relative attractiveness of the proposals ranked in parts (6) and (7).
Your division is considering two investment projects, each of which requires an up-front expenditure of 25 million. You estimate that the cost of capital is 10% and that the investments will produce the following after-tax cash flows (in millions of dollars): a. What is the regular payback period for each of the projects? b. What is the discounted payback period for each of the projects? c. If the two projects are independent and the cost of capital is 10%, which project or projects should the firm undertake? d. If the two projects are mutually exclusive and the cost of capital is 5%, which project should the firm undertake? e. If the two projects are mutually exclusive and the cost of capital is 15%, which project should the firm undertake? f. What is the crossover rate? g. If the cost of capital is 10%, what is the modified IRR (MIRR) of each project?
Postman Company is considering two independent projects. One project involves a new product line, and the other involves the acquisition of forklifts for the Materials Handling Department. The projected annual operating revenues and expenses are as follows: Required: Compute the after-tax cash flows of each project. The tax rate is 40 percent and includes federal and state assessments.
There are two projects under consideration by the Rainbow factory. Each of the projects will require an initial investment of $35,000 and is expected to generate the following cash flows: Use the information from the previous exercise to calculate the internal rate of return on both projects and make a recommendation on which one to accept. For further instructions on internal rate of return in Excel, see Appendix C.