# Question: Expand the capital budgeting model in Figure 14 40 so that

Expand the capital budgeting model in Figure 14.40 so that there are now 20 possible investments. You can make up the data on cash requirements, NPVs, and the budget. However, use the following guidelines:

The cash requirements and NPVs for the various investments can vary widely, but the ratio of NPV to cash requirement should be between 2.5 and 3.5 for each investment. The budget should allow somewhere between 5 and 10 of the investments to be selected.

The cash requirements and NPVs for the various investments can vary widely, but the ratio of NPV to cash requirement should be between 2.5 and 3.5 for each investment. The budget should allow somewhere between 5 and 10 of the investments to be selected.

## Answer to relevant Questions

Suppose in the capital budgeting model in Figure 14.40 that each investment requires $2000 during year 2 and only $5000 is available for investment during year 2.a. Assuming that available money un-invested at the end of ...In the optimal solution to the Great Threads model, no pants are produced. Suppose Great Threads has an order for 300 pairs of pants that must be produced. Modify the model appropriately and use Solver to find the new ...In the Great Threads model, we found an upper bound on production of any clothing type by calculating the amount that could be produced if all of the resources were devoted to this clothing type.a. What if you instead use a ...In many cases you can assume that the portfolio return is at least approximately normally distributed. Then you can use Excelâ€™s NORMDIST function as in Chapter 5 to calculate the probability that the portfolio return is ...An automobile company produces cars in Los Angeles and Detroit and has a warehouse in Atlanta. The company supplies cars to customers in Houston and Tampa. The costs of shipping a car between various points are listed in the ...Post your question