Light Sweet Petroleum, Inc., is trying to evaluate a generation project with the following cash flows.If the company requires a return of 12 percent on its investments, what is the project's NPV? Whatare the IRRS for the project?Year 0Year 1Year 2Required returnSA SA SA$(45,000,000)$71,000,000$ (15,000,000)12%Complete the following analysis. Do not hard code values in your calculations. Use a"Guess" of .99 to calculate the higher IRR and -.99 to calculate the lower IRR. You must usethe built-in Excel functions to answer this question.NPVHigher IRRLower IRR

Name: Light Sweet Petroleum, Inc., is trying to evaluate a generation proje
Uploaded: 2024-03-20T06:50:59.000Z
Channel: Bartleby
Description: Light Sweet Petroleum, Inc., is trying to evaluate a generation project with the following cash flows.If the company requires a return of 12 percent on its investments, what is the project's NPV? Whatare the IRRS for the project?Year 0Year 1Year 2Re

Capital budgeting is a process of analyzing, evaluating, and allocating resources in the various…

Business

Finance

Light Sweet Petroleum, Inc., is trying to evaluate a generation project with the following cash flows. If the company requires a return of 12 percent on its investments, what is the project's NPV? What are the IRRS for the project? Year 0 Year 1 Year 2 Required return EA EA EA $ (45,000,000) $ 71,000,000 $ (15,000,000) 12% Complete the following analysis. Do not hard code values in your calculations. Use a "Guess" of .99 to calculate the higher IRR and -.99 to calculate the lower IRR. You must use the built-in Excel functions to answer this question. NPV Higher IRR Lower IRR

Light Sweet Petroleum, Inc., is trying to evaluate a generation project with the following cash flows. If the company requires a return of 12 percent on its investments, what is the project's NPV? What are the IRRS for the project? Year 0 Year 1 Year 2 Required return EA EA EA $ (45,000,000) $ 71,000,000 $ (15,000,000) 12% Complete the following analysis. Do not hard code values in your calculations. Use a "Guess" of .99 to calculate the higher IRR and -.99 to calculate the lower IRR. You must use the built-in Excel functions to answer this question. NPV Higher IRR Lower IRR

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

Falkland, Inc., is considering the purchase of a patent that has a cost of $50,000 and an estimated revenue producing life of 4 years. Falkland has a cost of capital of 8%. The patent is expected to generate the following amounts of annual income and cash flows: A. What is the NPV of the investment? B. What happens if the required rate of return increases?
Jasmine Manufacturing is considering a project that will require an initial investment of $52,000 and is expected to generate future cash flows of $10,000 for years 1 through 3, $8,000 for years 4 and 5, and $2,000 for years 6 through 10. What is the payback period for this project?
Mason, Inc., is considering the purchase of a patent that has a cost of $85000 and an estimated revenue producing lite of 4 years. Mason has a required rate of return that is 12% and a cost of capital of 11%. The patent is expected to generate the following amounts of annual income and cash flows: A. What is the NPV of the investment? B. What happens if the required rate of return increases?
Buena Vision Clinic is considering an investment that requires an outlay of 600,000 and promises a net cash inflow one year from now of 810,000. Assume the cost of capital is 10 percent. Required: 1. Break the 810,000 future cash inflow into three components: a. The return of the original investment b. The cost of capital c. The profit earned on the investment 2. Now, compute the present value of the profit earned on the investment. 3. Compute the NPV of the investment. Compare this with the present value of the profit computed in Requirement 2. What does this tell you about the meaning of NPV?
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?
The Ulmer Uranium Company is deciding whether or not to open a strip mine whose net cost is $4.4 million. Net cash inflows are expected to be $27.7 million, all coming at the end of Year 1. The land must be returned to its natural state at a cost of $25 million, payable at the end of Year 2. Plot the project’s NPV profile. Should the project be accepted if r = 8%? If r = 14%? Explain your reasoning. Can you think of some other capital budgeting situations in which negative cash flows during or at the end of the project’s life might lead to multiple IRRs? What is the project’s MIRR at r = 8%? At r = 14%? Does the MIRR method lead to the same accept-reject decision as the NPV method?
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.
Roberts Company is considering an investment in equipment that is capable of producing more efficiently than the current technology. The outlay required is 2,293,200. The equipment is expected to last five years and will have no salvage value. The expected cash flows associated with the project are as follows: Required: 1. Compute the projects payback period. 2. Compute the projects accounting rate of return. 3. Compute the projects net present value, assuming a required rate of return of 10 percent. 4. Compute the projects internal rate of return.
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)?
Consolidated Aluminum is considering the purchase of a new machine that will cost $308,000 and provide the following cash flows over the next five years: $88,000, 92,000, $91,000, $72,000, and $71,000. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return in Excel, see Appendix C.
Gina Ripley, president of Dearing Company, is considering the purchase of a computer-aided manufacturing system. The annual net cash benefits and savings associated with the system are described as follows: The system will cost 9,000,000 and last 10 years. The companys cost of capital is 12 percent. Required: 1. Calculate the payback period for the system. Assume that the company has a policy of only accepting projects with a payback of five years or less. Would the system be acquired? 2. Calculate the NPV and IRR for the project. Should the system be purchasedeven if it does not meet the payback criterion? 3. The project manager reviewed the projected cash flows and pointed out that two items had been missed. First, the system would have a salvage value, net of any tax effects, of 1,000,000 at the end of 10 years. Second, the increased quality and delivery performance would allow the company to increase its market share by 20 percent. This would produce an additional annual net benefit of 300,000. Recalculate the payback period, NPV, and IRR given this new information. (For the IRR computation, initially ignore salvage value.) Does the decision change? Suppose that the salvage value is only half what is projected. Does this make a difference in the outcome? Does salvage value have any real bearing on the companys decision?
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 .