Expand and then solve the capital budgeting model in Figure 6.5 so that 20 investments are now
Question:
Expand and then solve the capital budgeting model in Figure 6.5 so that 20 investments are now possible. You can make up the data on cash requirements, NPVs, and the budget, but use the following guidelines:
• The cash requirements and NPVs for the various investments can vary widely, but the ROIs should be between 10% and 15% for each investment.
• The budget should allow somewhere between 5 and 10 of the investments to be selected.
Figure 6.5
Transcribed Image Text:
A B D. G H 1 Capitalbudgeting model Range names used Budget =Model!$D$14 3 Input data on potential investments ($ millions) 4 Investrment 5 ICost Decisions =Modell$B$10:SH$10 Total cost =Modell$B$14 Total_NPV =Modell$B$17 2 4 $5.0 $4 5 $2.4 $2.7 $3.5 $5.9 $6.9 $3.0 6 NPV $5.6 $5.1 13.3% $3.9 $6.8 $7.7 $3.3 7 ROI 12.0% 12.5% 11.4% 15.3% 11.6% 10.0% 9 Decisions: whether to invest 10 1 if yes, O if no 1 11 12 Budget constraint Total cost Budget 13 14 $14.9 $15 15 16 Objective to maximize 17 Total NP $16.7
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 73% (15 reviews)
Answer Assuming that we have 20 investment opportunities the following table shows a sample of the ...View the full answer
Answered By
Muhammad Mujtaba
I have done Btech in civil from I k Gujral Punjab technical university with 8.15 cgpa out of 10.i have a vast knowledge about civil engineering i am able to solve numerical with high precision. I've had a good teaching experience. Tutoring is something that I enjoy and find it rewarding.
0.00
0 Reviews
10+ Question Solved
Related Book For
Practical Management Science
ISBN: 978-1305250901
5th edition
Authors: Wayne L. Winston, Christian Albright
Question Posted:
Students also viewed these Business questions
-
Make up an example, as described in the previous problem, with 20 possible investments. However, do it so the ROIs are in a very tight range, such as from 12% to 13%. Then use Solver to find the...
-
Change the capital budgeting model in Figure 6.5 so that 80% of each cost in row 5 is incurred right now, at the beginning of year 1, and the other 20% is incurred a year from now, at the beginning...
-
In the capital budgeting model in Figure 6.5, investment 4 is tied for the largest ROI, but it is not selected in the optimal solution. How much NPV will be lost if Tatham is forced to select...
-
Consider the heat pump described in Example 9.14. The heat pump now operates between 0.60 MPa and 1.4 MPa. Plot the vapor-compression cycle in Ts coordinates (use NIST) and determine the cycle...
-
In Exercises 25 and 26, find the best approximation to a solution of the given system of equations. 1. x + y - z = 2 - y + 2 z = 6 3x + 2y - z = 1 1 -x + z = 0 2. 2x + 3y + z = 2 1 x + y + z = 7 - x...
-
A school and three others in your area have underperformed in the national social studies examinations, for the past six years, discuss how would you select a sample of students that would allow you...
-
Question: A federal statute prohibits the broadcasting of lottery advertisements, except by stations located in states permitting lotteries. The purpose of the statute is to support efforts of states...
-
The following cost data relate to the manufacturing activities of Black Company during the just completed year: Manufacturing overhead costs: Property taxes, factory . . . . . . . . . . . . . . . . ....
-
(Q4 A) The single index model has been estimated for stock A and Stock B with the results shown in the table below, and where ?M =0.35, ?(Ea) =0.20, and ?(Eb)=0.10 Calculate the covariance between ...
-
The Kreeger Grocery Store chain has bought out a competing grocery store chain. However, it now has too many stores in close proximity to each other in certain cities. In Roanoke the chain has 10...
-
Solve the previous problem using the input data in the file P06_02.xlsx. Previous problem In the capital budgeting model in Figure 14.40, we supplied the NPV for each investment. Suppose instead that...
-
In the Great Threads model, we didnt constrain the production quantities in row 16 to be integers, arguing that any fractional values could be safely rounded to integers. See whether this is true....
-
Dexter Shuman owns a bowling alley called Ten Pin Alley. Each night, Dexter counts the cash in the two cash registers and makes a night deposit at the local bank. For the month of May, Dexter made...
-
Address all three of the following writing prompts. Your responses to your three chosen prompts should be at least 350 words each. No title page is needed, but be sure to indicate which writing...
-
10 kg ideal air goes through a polytropic process where n=1.3. The initial temperature of the air is 300 K. The final temperature of the air is 600 K. Determine the work during the process (in kJ) if...
-
1. The ball is thrown off the top of the building. If an initial velocity is VA and angle BA- 45 degrees find the time of travel from A to B. Also, find the magnitude of the ball's velocity...
-
Write (aim, equipment, meth, hypothesis, conclusions, use of the independent variable, the dependent variable, controlled variables, the control) for the experiment of a back titration by yourself to...
-
These questions relate to the Integrated Analytics Case: Bene Petit. Select the appropriate eBook link to open the Case Overview, Case Background, and Part 3: Managerial Decision Making. The...
-
Give an example that clearly illustrates the difference between positions and interests? Why is the difference important to integrative bargaining?
-
What are the three kinds of research types? Explain each type.
-
Refer to Problem C:13-24. Explain the negative tax considerations (if any) with respect to Balas making gifts of the assets that you recommended. In problem C: 13-24 Bala desires to freeze the value...
-
Annie James died early in 2017. All her property passed subject to her will, which provides that her surviving husband, Dave James, is to receive all the property outright. Her will further states...
-
Jeung Hong, a widower, died in March 2017. His gross estate was $6.5 million and, at the time of his death, he owed debts of $60,000. His will made a bequest of $200,000 to his undergraduate alma...
-
California Civil Code section 1584.5 provides that not only does not constitute acceptance of the obligation to pay for unsolicited merchandise, the merchandise can be kept by the offeree without any...
-
D Question 3 Match the example given to the correct scale. Nominal Scale Ratio Scale Ordinal Scale [Choose] [Choose ] Education Level Hair Color Measuring Tape Clock on the Wall [Choose] Interval...
-
Problem 2 (60%): NACA 4-series Airfoils. The camberline of the NACA four-digit series of airfoils is given by the following two parabolas: Y(x) = EX x 1 (2p-) for 0 < < p x E(c-x) for p
Study smarter with the SolutionInn App