The portfolio of investment projects below has been proposed for a company for next year. Project...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The portfolio of investment projects below has been proposed for a company for next year. Project ABCDEFGHIL J Net Present Value (M£) 100 60 70 65 50 50 45 40 40 30 Cost (M£) 61 28 33 30 25 17 25 12 16 10 a. Develop a spreadsheet optimisation program to select the optimal portfolio of projects to maximise total portfolio net present value (NPV), given a total budget of £100 M (This is a simple MILP). b. How would the portfolio and NPV change if the budget was increased to £110 M? c. Because of corporate cost-cutting, the budget is reduced to £80 M. Which projects are now funded and what is the new NPV? d. Based on your answers to parts (a) and (c), can you draw any conclusions on which projects are likely to be funded regardless of the financial situation? e. Can you see any problems with this project selection strategy? If so, how would your recommend they should be addressed? The portfolio of investment projects below has been proposed for a company for next year. Project ABCDEFGHIL J Net Present Value (M£) 100 60 70 65 50 50 45 40 40 30 Cost (M£) 61 28 33 30 25 17 25 12 16 10 a. Develop a spreadsheet optimisation program to select the optimal portfolio of projects to maximise total portfolio net present value (NPV), given a total budget of £100 M (This is a simple MILP). b. How would the portfolio and NPV change if the budget was increased to £110 M? c. Because of corporate cost-cutting, the budget is reduced to £80 M. Which projects are now funded and what is the new NPV? d. Based on your answers to parts (a) and (c), can you draw any conclusions on which projects are likely to be funded regardless of the financial situation? e. Can you see any problems with this project selection strategy? If so, how would your recommend they should be addressed?
Expert Answer:
Answer rating: 100% (QA)
Develop a spreadsheet optimisation program to select the optimal portfolio of projects to maximise total portfolio net present value NPV given a total budget of 100 M This is a simple MILP Formulate t... View the full answer
Related Book For
Posted Date:
Students also viewed these general management questions
-
The following system of components has been proposed for a new product. Determine the reliability of thesystem. R 0.85 R 0.90 R- 0.90R 0.85 R 0.90R 0.95
-
The following mechanism has been proposed for the gas-phase reaction of chloroform (CHCl3) and chlorine: Step 1: Step 2: Step 3: (a) What is the overall reaction? (b) What are the intermediates in...
-
A triage system has been proposed for the ER described in Exercise 3.4. Under the proposed triage plan, entering patients will be registered as before. They will then be quickly examined by a nurse...
-
What are the income-distribution consequences of fashion? Can the need to be seen driving a new car by the rich be a boon to those with lower incomes who will ultimately purchase a better,...
-
Mauve Supplies, Inc., reports total income of $120,000. The corporation's taxable income is $105,000. What are Mauve's marginal, average, and effective tax rates?
-
1. Help Jenny to forecast dividend payments for Reeby Sports and to estimate the value of the stock. You do not need to provide a single figure. For example, you may wish to calculate two figures,...
-
Table B. 22 contains data on 1916 team performance for Major League Baseball. Use all possible regressions to build a model for this data. Perform a residual analysis on the final model and comment...
-
Mark Decker has identified four stocks for his portfolio, and he wants to determine the percentage of his total available funds he should invest in each stock. The alternative stocks include an...
-
Constants The aurora is caused when electrons and protons, moving in the earth's magnetic field of 5.0 x 105T, collide with molecules of the atmosphere and cause them to glow. Part B What is the...
-
A year ago, Rebecca purchased 100 shares of Havad stock for $25 per share. Yesterday, she placed a limit order to sell her stock at a price of $30 per share before the market opened. The stocks price...
-
How useful or informative do you think psychologicaland honesty tests are? Is their use a reasonable business policy? Assuming that tests like those described are valid and reliable, are they fair?...
-
What are the different types of nuclear bodies found within the nucleus, and what roles do they play in cellular function and organization?
-
When faced with a moral decision, employees should follow the two-step process of identifying the relevant obligations, effects, and ideals, and then try to decide where the emphasis should lie among...
-
Explain how Domestic management of Human Resource differs from International Human Resource Management
-
Look at the table of working age population. the number of working population and the number of unemployed in Country "A" in 2010-2015 below. Calculate: a) number of labor force b) labor force...
-
How does the Deferral method handle an unrestricted contribution received for the current year?
-
A ball rolls across a lab table at 1.80 m/s, eventually rolling over the edge of the table. It hits the floor 0.55 s later. a) Draw a motion diagram for the ball. Include a few points where it is...
-
What are three disadvantages of using the direct write-off method?
-
Compare the two standards calculated in Problems 6 and 8. What other factors should be considered in selecting the method for determining the allowancefactor? Mean Observed Time minutes 1.20 1.00...
-
Fill in the partially completed inventory record shownhere. Item: AB500 Lot Size Rule: POQ Lead Time: 2 weeks Parent: None Children: AB501, AB511, 521 3 Gross Requirements Schedtuled Receipts: 150...
-
Bob Bristol, your boss at CII, just called to tell you that he was impressed with your progress thus far in familiarizing yourself with operations at CIIboth the strategic details pertaining to its...
-
Scuba divers are warned that if they must make a rapid ascent, they should exhale on the way up. If a diver rapidly ascends to the surface with lungs full of air, his lungs could be damaged. Explain...
-
A higher level of hemoglobin in the blood increases the bloods density. This is the basis for a simple test that can be used to see if a prospective blood donor has a high enough hemoglobin level to...
-
Freshwater fish tend to have larger swim bladders than saltwater fish. Explain why you would expect this to be true.
Study smarter with the SolutionInn App