Questions: Crowell Company is considering two capital investments. Both investments have an initial cost of $9,000,000 and total net cash inflows of $17,000,000 over 10 years. Crowell requires a 15% rate of return on this type of investment. Expected net cash inflows are as follows: Requirements - X 1. Use Excel to compute the NPV and IRR of the two plans. Which plan, if any, should the company pursue? 2. Explain the relationship between NPV and IRR. Based on this relationship and the company's required rate of return, are your answers as expected in Requirement 1? Why or why not? 3. After further negotiating, the company can now invest with an initial cost of $8,100,000. Recalculate the NPV and IRR. Which plan, if any, should the company pursue? Print Done - X Data Table Year Plan Alpha Plan Beta 1 1,700,000 $ 1,700,000 1,700,000 2,400,000 1,700,000 3,100,000 4 1,700,000 2,400,000 1,700,000 1,700,000 6 1,700,000 1,600,000 7 1,700,000 1,300,000 1,700,000 1,000,000 1,700,000 700,000 1.700.000 1,100,000 10 17,000,000 $ 17,000,000 Total

Questions: Crowell Company is considering two capital investments. Both investments have an initial cost of $9,000,000 and total net cash inflows of $17,000,000 over 10 years. Crowell requires a 15% rate of return on this type of investment. Expected net cash inflows are as follows: Requirements - X 1. Use Excel to compute the NPV and IRR of the two plans. Which plan, if any, should the company pursue? 2. Explain the relationship between NPV and IRR. Based on this relationship and the company's required rate of return, are your answers as expected in Requirement 1? Why or why not? 3. After further negotiating, the company can now invest with an initial cost of $8,100,000. Recalculate the NPV and IRR. Which plan, if any, should the company pursue? Print Done - X Data Table Year Plan Alpha Plan Beta 1 1,700,000 $ 1,700,000 1,700,000 2,400,000 1,700,000 3,100,000 4 1,700,000 2,400,000 1,700,000 1,700,000 6 1,700,000 1,600,000 7 1,700,000 1,300,000 1,700,000 1,000,000 1,700,000 700,000 1.700.000 1,100,000 10 17,000,000 $ 17,000,000 Total

Financial And Managerial Accounting

15th Edition

ISBN:9781337902663

Author:WARREN, Carl S.

Publisher:WARREN, Carl S.

Chapter26: Capital Investment Analysis

Section: Chapter Questions

Problem 3CMA

See similar textbooks

Similar questions

Fenton, Inc., has established a new strategic plan that calls for new capital investment. The company has a 9.8% required rate of return and an 8.3% cost of capital. Fenton currently has a return of 10% on its other investments. The proposed new investments have equal annual cash inflows expected. Management used a screening procedure of calculating a payback period for potential investments and annual cash flows, and the IRR for the 7 possible investments are displayed in image. Each investment has a 6-year expected useful life and no salvage value. A. Identify which project(s) is/are unacceptable and briefly state the conceptual justification as to why each of your choices is unacceptable. B. Assume Fenton has $330,000 available to spend. Which remaining projects should Fenton invest in and in what order? C. If Fenton was not limited to a spending amount, should they invest in all of the projects given the company is evaluated using return on investment?
Your company is planning to purchase a new log splitter for is lawn and garden business. The new splitter has an initial investment of $180,000. It is expected to generate $25,000 of annual cash flows, provide incremental cash revenues of $150,000, and incur incremental cash expenses of $100,000 annually. What is the payback period and accounting rate of return (ARR)?
Assuming you are facing making a decision on a large capital investment proposal. the capital investment amount is $640,000, Estimated the study period is 8 years. The annual revenue at the end of each year is $180,000, and the estimated annual year-end expense is $42000starting in year one, Assuming a market value at the end year is $ 20,000, and the benchmark rate is 10%, Find the cash flow chart, the NPV, the dynamic payback period, and the IRR of this project.
Zachary Modems, Incorporated (ZMI) has several capital investment opportunities. The term, expected annual cash inflows, and the cost of each opportunity are outlined in the following table. ZMI has established a desired rate of return of 12 percent for these investment opportunities. (PV of $1 and PVA of $1) Note: Use appropriate factor(s) from the tables provided. Opportunity A B C D Investment term 4 years Expected cash inflow Cost of investment $ 3,800 $ 10,100 5 years $ 6,600 $ 19,800 3 years 5 years $ 3,300 $ 5,600 $ 8,000 $ 20,200 Required es a. Compute the net present value of each investment opportunity and record your answers in the following table. The results for Investment Opportunity A have been recorded in the table as an example. b. Determine the net present value and the internal rate of return for each investment opportunity. Record the results in the following table. The results for investment Opportunity A have been recorded in the following table as an example.…
Assume that a company is considering a capital investment project with a four-year time horizon and the following cash flows: Cost of new equipment Working capital required Annual net cash inflows Maintenance and repairs in third year Salvage value of equipment in fourth year Click here to view Exhibit 14B-1 and Exhibit 148-2. to determine the appropriate discount factor(s) using the tables provided. Assuming the company's required rate of return is 20%, the profitability index of the project is closest to: Multiple Choice $210,000 $ 50,000 $100,000 $ 40,000 $ 30,000 1.05 prog
Zachary Modems, Incorporated (ZMI) has several capital investment opportunities. The term, expected annual cash inflows, and the cost of each opportunity are outlined in the following table. ZMI has established a desired rate of return of 12 percent for these investment opportunities. (PV of $1 and PVA of $1) Note: Use appropriate factor(s) from the tables provided. Opportunity A B C D Investment term 4 years 5 years 3 years 5 years Expected cash inflow Cost of investment $ 3,800 $ 10,100 $ 6,600 $ 19,800 $ 3,300 $ 5,600 $ 8,000 $ 20,200 Required es a. Compute the net present value of each investment opportunity and record your answers in the following table. The results for Investment Opportunity A have been recorded in the table as an example. b. Determine the net present value and the internal rate of return for each investment opportunity. Record the results in the following table. The results for investment Opportunity A have been recorded in the following table as an example.…
Regarding the proposed investments, XYZ INC. gathers the following data: a cash cost of 13,000, net annual cash flows of 45,000, and a present value factor of 5.40 rounded for cash inflows over a ten-year period. Find out all the relevant details that will be important when choosing an investment. Please let me know whether you think our firm should receive an investment based on the following information:
Daymore plc is currently considering three investment opportunities. The following is the details of the investments:-Project A:-1. initial outlay $80m2. Future net inflows Year 1: $190mYear 2: $10mProject B:-1. initial outlay $140m2. Future net inflows Year 1: $180mYear 2: $120mProject C:-1. initial outlay $90m2. Future net inflows Year 1: $10mYear 2: $220mThe company has a capital budget that is restricted in the year of the investment and it will not be possible to undertake all three projects in full. The investment opportunities are independent of one another and each project is divisible (that is, it is possible to undertake part of an investment and to receive a pro-rata return). The cost of capital of the company is 12% and the company uses the net present value method of investment appraisal.Required:Calculate and determine the ranking of the three investment opportunities? (The ranking for the first choice, second choice, and third choice is 1, 2, and 3 respectively). Show…
A firm evaluates all of its projects by applying the NPV decision rule. A project under consideration has the following cash flows: Year Cash Flow $28,900 12,900 15,900 11,900 2. What is the NPV for the project if the required return is 11 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPV
Financial Manager of Timmy Company is considering two projects (project A and project H), which have cash flows as follows: Year Cash Flow of Project A (in $) Cash Flow of Project H (in $) 0 -100 -100 1 10 70 2 60 50 3 80 20 Timmy Company’s cost of capital is 10 percent. Calculate payback, NPV, IRR, and MIRR for both projects. (Please have a step by step format to your answer with explainations. Thanks (=)
A company is considering three alternative investment projects with different net cash flows. The present value of net cash flows is calculated using Excel and the results follow. Potential Projects Present value of net cash flows (excluding initial investment) Initial investment Project A $ 8,328 (10,000) Project B $ 10,809 (10,000) Project C $ 10,685 (10,000) a. Compute the net present value of each project. b. If the company accepts all positive net present value projects, which of these will it accept? c. If the company can choose only one project, which will it choose on the basis of net present value? Complete this question by entering your answers in the tabs below. Required A Required B Required C Compute the net present value of each project. Potential Projects Project A Project B Project C Present value of net cash flows Initial investment Net present value
A company is considering three alternative investment projects with different net cash flows. The present value of net cash flows is calculated using Excel and the results follow. Potential Projects Present value of net cash flows (excluding initial investment) Initial investment Project A $ 11,226 (10,000) Project B $ 10,568 (10,000) a. Compute the net present value of each project. b. If the company accepts all positive net present value projects, which of these will it accept? c. If the company can choose only one project, which will it choose on the basis of net present value? Complete this question by entering your answers in the tabs below. Required A Required B Required C Compute the net present value of each project. Potential Projects Project A Project B Project C Present value of net cash flows Initial investment Net present value $ $ $