A private equity firm is considering five competing projects in which to invest in the upcoming...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A private equity firm is considering five competing projects in which to invest in the upcoming quarter. The firm needs to decide how to allocate its available capital based upon the combination of projects (denoted as A to E) selected to maximize returns (based upon net present value (NPV)). Table 1 below presents the capital requirements and the NPV for each project, along with the associated risk (given as a percentage of the initial investment). The company has $43 million in capital to allocate, with the goal of having an average associated risk of no more than 5%. There are some additional constraints to be met: (i) if project B is selected, then project E is also selected; (ii) one of the two projects A and C must be selected but not both; (iii) at least one of projects A, B, and D is selected. Table 1: Project Data Project A B с D E NPV (MS) 19 22 24 27 21 Risk (%) 4 5 6 7 5 Grading Rubric Points for Integer Programming Formulation 1 point for correctly defining decision variables Capital (M$) 14 10 12 15 13 2 points for the objective function equation 1 point for selecting it as the correct type i.e. max or min 3 points for constraint 1 3 points for constraint 2 3 points for constraint 3 3 points for constraint 4 3 points for constraint 5 1 point for the binary integer constraints Please, submit answer to all questions and Excel solution to this problem. A private equity firm is considering five competing projects in which to invest in the upcoming quarter. The firm needs to decide how to allocate its available capital based upon the combination of projects (denoted as A to E) selected to maximize returns (based upon net present value (NPV)). Table 1 below presents the capital requirements and the NPV for each project, along with the associated risk (given as a percentage of the initial investment). The company has $43 million in capital to allocate, with the goal of having an average associated risk of no more than 5%. There are some additional constraints to be met: (i) if project B is selected, then project E is also selected; (ii) one of the two projects A and C must be selected but not both; (iii) at least one of projects A, B, and D is selected. Table 1: Project Data Project A B с D E NPV (MS) 19 22 24 27 21 Risk (%) 4 5 6 7 5 Grading Rubric Points for Integer Programming Formulation 1 point for correctly defining decision variables Capital (M$) 14 10 12 15 13 2 points for the objective function equation 1 point for selecting it as the correct type i.e. max or min 3 points for constraint 1 3 points for constraint 2 3 points for constraint 3 3 points for constraint 4 3 points for constraint 5 1 point for the binary integer constraints Please, submit answer to all questions and Excel solution to this problem.
Expert Answer:
Related Book For
Valuation The Art and Science of Corporate Investment Decisions
ISBN: 978-0133479522
3rd edition
Authors: Sheridan Titman, John D. Martin
Posted Date:
Students also viewed these economics questions
-
The Fibonacci sequence is a famous sequence of numbers whose elements commonly occur in nature. The terms in the Fibonacci sequence are 1, 1, 2, 3, 5, 8, 13, 21, . . . . The ratio of consecutive...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Boeing Company was scheduled to deliver several of its 747-400 jumbo jetliners to Northwest Airlines by December 31, 1988. Northwest set that deadline because it needed the $16 million in investment...
-
Assume you are the manager of a retail store and need to hire a CIO to run your new computer system. What characteristics would you want in a new CIO?
-
A capacitor has a plate area of \(0.0045 \mathrm{~m}^{2}\) and a charge of magnitude \(q\) on each plate. The space between plates has been filled with a dielectric that has a bound surface charge of...
-
E.I. DuPont de Nemours & Company (DuPont) manufactured and sold Teflon. The plaintiff, F&F, purchased Teflon from DuPont and used it as the primary ingredient in a product (Tufoil) it manufactured...
-
Cortez Company is planning to introduce a new product that will sell for $96 a unit. The following manufacturing cost estimates have been made on 20,000 units to be produced the first year: Direct...
-
You are planning a 30-day vacation in Malaysia in one year's time. The present charge for a luxury suite plus meals is RM760.00 per day and the RM is presently trading at RM 3.8000/$. Hence the $...
-
Jacksonville LLP is working on its Cash Budget for next year. It collected the following information from Quarter 1: Beginning Cash Balance $50,000, Cash Collections from Customers $40,000, and Total...
-
information is available for XYZ Company for the current quarter: Sales Selling price per unit Variable selling expense per unit Variable admin expense per unit Total fixed selling expense Total...
-
The objective of this homework is to reinforce the scale space response extrema concept in key points detection, and ask you to compute a LoG pyramid for scale space extrema detection, and compare...
-
4) Consider the position control of an inertial load with a proportional controller of gain Kp. A tachometer is built- in the electric motor and provides a feedback proportional to the angular...
-
Print off a copy of the Schedule 8 form found in the Content->Resources folder and fill it out by hand. Use the sheet to make the following CCA calculations. Use column 1 for the year instead of the...
-
Sarah is self-employed. On January 15, she borrowed $10,000 at 5 percent annual interest for the purpose of purchasing equipment for her business. The funds were credited directly into her checking...
-
The corporation was established in 1968 - it was growing rapidly under the leadership of Mr. Kawasaki until he retired. since then, All the general managers that succeeded him failed to keep the...
-
On February 1, Rinehart Company purchased 500 shares (2% ownership) of Givens Company common stock for $32 per share. On March 20, Rinehart Company sold 100 shares of Givens stock for $2,900....
-
(a) Water flows through the nozzle of a garden hose. Find an expression for m in terms of line pressure P 1 , ambient pressure P 2 , inside hose diameter D 1 , and nozzle outlet diameter D 2 . Assume...
-
Morrison Oil and Gas is faced with an interesting investment opportunity. The investment involves the exploration for a significant deposit of natural gas in southeastern Louisiana near Cameron. The...
-
Google Inc. of Mountain View, California, operates the most popular and power-ful search engine on the Web. The company went public using an unconventional Dutch auction method on August 19, 2004....
-
This chapter demonstrated that the requirement that new projects be accretive to firm EPS sometimes results in accepting negative NPV projects and rejecting positive NPV projects. Under more...
-
You hold a puck at the top of an ice-covered ramp inclined at \(60^{\circ}\) with respect to the vertical. Your friend stands nearby on level ground and holds a ball at the same height \(h\) above...
-
A particle moves in the \(x\) direction according to the equation \(x(t)=b t^{3}+c t^{2}+d\), where \(b=4.0 \mathrm{~m} / \mathrm{s}^{3}\), \(c=-10 \mathrm{~m} / \mathrm{s}^{2}\), and \(d=20...
-
The position of a cart on a low-friction track can be represented by the equation \(x(t)=b+c t+e t^{2}\), where \(b=4.00 \mathrm{~m}, c=6.00 \mathrm{~m} / \mathrm{s}\), and \(e=0.200 \mathrm{~m} /...
Study smarter with the SolutionInn App