Problems. Problem 1. A division in a large company has been allocated $160 million for capital projects this year. Managers have proposed five projects for the budgeting committee to consider. The committee would like to maximize the total NPV. What projects should be selected? • There is one project of each type, each project has an estimated NPV (net present value, a measurement of profit) and each requires a capital expenditure (this comes out of the budget above). • At least 2 projects must be done. • If Project 5 is chosen, Project 1 must be done as well. Project 1 Project 2 Project 3 Project 4 Project 5 NPV (in millions of $) 10 17 16 8 14 Expenditure (millions of $) 48 96 80 32 64 a. What are your decision variables (x)? State the units for each. b. Write down your objective function (include min/max with the equation) and constraints below, include descriptions/explanations/calculations on the right. Delete/add rows as needed. (objective function above, constraints below)

Problems. Problem 1. A division in a large company has been allocated $160 million for capital projects this year. Managers have proposed five projects for the budgeting committee to consider. The committee would like to maximize the total NPV. What projects should be selected? • There is one project of each type, each project has an estimated NPV (net present value, a measurement of profit) and each requires a capital expenditure (this comes out of the budget above). • At least 2 projects must be done. • If Project 5 is chosen, Project 1 must be done as well. Project 1 Project 2 Project 3 Project 4 Project 5 NPV (in millions of $) 10 17 16 8 14 Expenditure (millions of $) 48 96 80 32 64 a. What are your decision variables (x)? State the units for each. b. Write down your objective function (include min/max with the equation) and constraints below, include descriptions/explanations/calculations on the right. Delete/add rows as needed. (objective function above, constraints below)

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 21P: Your division is considering two investment projects, each of which requires an up-front expenditure...

See similar textbooks

Similar questions

Suppose a company has the following three project and limits it capital budget to $50,000. Project Present Value of Cash Initial Investment A. $40,000. $25,000B. 37,500. 25,000C. 70,000. 50,0001. Calculate the projects' NPVs.2. Calculate the projects' PIs.3. Which project (s) should the company choose? Why?
Suppose a company has the following three projects and limits it capital budget to $50,000. Projects Present Value of Cash Inflows Initial Investment A $40,000 $25,000 B 37,500 25,000 70,000 50,000 1. Calculate the projects' NPVSS. 2. Calculate the projects' Pls. 3. Which project(s) should the company choose? Why?
Required information [The following information applies to the questions displayed below.] The following capital expenditure projects have been proposed for management's consideration at Scott Inc. for the upcoming budget year: Use Table 6-4 and Table 6-5. (Use appropriate factor(s) from the tables provided. Round the PV factors to 4 decimals.) Project Year (s) D E $ (25,000) 5,000 5,000 5,000 5,000 5,000 5,000 $ 1,081 $ (25,000) $ (50,000) $ (50,000) 5,000 10,000 15,000 20,000 25,000 Initial investment $(100,000) 30,000 30,000 Amount of net cash return 16,000 16,000 16,000 16,000 16,000 10,000 15,000 10,000 10,000 6,000 15,000 15,000 5 Per year 6-10 15,000 NPV (14% discount rate) $ 2,942 Present value ratio 1.04 b. Calculate the present value ratio for projects B, C, D, and E. (Round your answers to 2 decimal places.) Project Present Value Ratio B D E
An investment center in Shellforth Corporation was asked to identify three proposals for its capital budget. Details of those proposals are as follows. Capital Budget Proposals Capital required Annual operating return $ 96,000 $ 60,000 20,400 $ 180,000 16,200 24,960 Shellforth uses residual income to evaluate all capital budgeting projects. Its minimum required return is 10 percent. a-1. Assume you are the investment center manager. Calculate the residual income for each project? a-2. Which project do you prefer? b-1. Assume your investment center's current ROI is 18 percent and that the president of Shellforth is thinking about using ROI for the investment center's evaluation. Calculate the ROI for each project? b-2. Would your preferences for the projects listed change? Complete this question by entering your answers in the tabs below. Reg A1 Req A2 Req B1 Req B2 Assume you are the investment center manager. Calculate the residual income for each project? Project A Project B Project…
Required information [The following information applies to the questions displayed below.] The following capital expenditure projects have been proposed for management's consideration at Scott Inc. for the upcoming budget year: Use Table 6-4 and Table 6-5. (Use appropriate factor(s) from the tables provided. Round the PV factors to 4 decimals.) Project Year(s) B D $ (25,000) $(50,000) 16,000 16,000 16,000 16,000 16,000 $ (50,000) 5,000 10,000 15,000 20,000 25,000 Initial investment $(25,000) 5,000 5,000 5,000 5,000 5,000 5,000 $ 1,081 $(100,000) 30,000 30,000 Amount of net cash return 1 2 3. 10,000 10,000 10,000 6,000 15,000 15,000 15,000 15,000 2,942 4 5 Per year 6-10 NPV (14% discount rate) 2$ $ Present value ratio 1.04 Required: a. Calculate the net present value of projects indicated by a minus sign.) and D, using as the cost of capital for Scott Inc. (Negative amounts should be Project Net Present Value B D
Your employer is trying to select from a list of possible capital projects. The projects, along with their cost and benefits, are listed below. The capital budget available is $1 million. In addition to spending constraints, your employer would like to select at least 2 projects. Projects 4 and 5 cannot both be selected together. Formulate the problem as a linear program and determine the optimal solution. Project Cost Net Present Value $260,000 $210,000 $720,000 $590,000 2 $570,000 $470,000 $235,000 $215,000 $220,000 $490,000 Which projects should be selected? Project 1 will Project 2 will Project 3 will Project 4 will Project 5 will What is the total net present value of these projects? Total net present value
NEED ASAP!!! This involves evaluation of (and decision about) projects a) Capital budgeting b) Net present value c) Initial investment outlay The cost of alternative 'A' is $25.000 and the cost of alternative 'B' is $20,000. In managerial accounting, the difference of $5,000 in costs of two alternatives would be termed as: a)differential cost b)extra cost c) additional cost
Your employer is trying to select from a list of possible capital projects. The projects, along with their cost and benefits, are listed below. The capital budget available is $1 million. In addition to spending constraints, your employer would like to select at least 2 projects. Projects 4 and 5 cannot both be selected together. Formulate the problem as a linear program and determine the optimal solution. Project 1 Cost Net Present Value $260,000 $210,000 $720,000 $590,000 $570,000 $470,000 $490,000 3 $235,000 $215,000 4. $220,000 Which projects should be selected? Project 1 will Project 2 will Project 3 will Project 4 will Project 5 will
OPPfel Hospitality Consulting Inc. has two similar financial projects to offer one of its corporate clients in the hospitality industry. OPPfel wants to evaluate a set of capital budgeting projects and come up with the best decision according to the project’s IRR and PI for the client. NINV and NCF data for both of the projects are shown in the data table below: Year Project AR Project BF 0 -$100,000 -$100,000 1 $70,000 $20,000 2 $60,000 $50,000 3 $20,000 $100,000 If the minimum required rate of return is 10.00% for both of the capital budgeting projects, which one of the projects provides a better investment decision that OPPfel can consult to the its client?
Part 3: Capital Budgeting and Project Evaluation Case Study: Assume that the company, where you are working as a team in Financial Department, is considering a potential project with a new product. It will require the company to buy a new equipment that will generate the same revenue for the company each year. The table below shows the initial and annual costs for each option. 3.1. Capital Budgeting Decision Making: Perform capital budgeting technique based on Equivalent Annual Cost (EAC) to advise the Company Management which option should be chosen if the relevant discount rate is 9%? Costs Option A Option B Initial Investment 1,400,000 1,500,000 Year 1 35,000 25,000 Year 2 35,000 25,000 Year 3 35,000 25,000 Year 4 35,000 25,000 Year 5 25,000 3.2. Risk Analysis and Project evaluation: Assume that the company finally chose Option B. It expects to sell 600,000 units of the new product for an average price of $15 per unit. The…
Assume that the manager faces a capital budget constraint with respect to total dollars available today to invest in new projects, $46 million. Assume same WACC for each project. All else equal, which project or set of otherwise independent projects should the manager choose? Project NPV (in $millions) IRR Required Investment today A $ 10 14.0% $ 22 B $ 9 12.9% $ 23 C $ 11 14.1% $ 23
Andrew Oxnard, chief financial officer, has been asked by Harry Pendel, chief executive officer and co-founder of Pendel & Braithwaite, Ltd. (P&B), to analyze two capital investment projects (projects A and B), which are expected to generate the following profit (p)streams: Profit Streams for Projects A and B period ?? ($) ?? ($) 1 100,000 350,000 2 200,000 300,000 3 250,000 200,000 4 300,000 100,000 5 325,000 100,000 Total 1,175,000 1,050,000 Profits are realized at the end of each period. Assuming that P&B is a profit maximizer if the discount rate for both projects is 12%, which of the two projects should be adopted?