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.

Transcribed Image Text:

Figure 14.40 Capital Budgeting Model A B C F G 1 Tatham capital budgeting model 2 3 Input data on potential investments 4 Investment 5 Investment cost 6 |NPV 7 NPV per investment dollar 8. 9 Decisions: whether to invest 10 Investment levels 11 12 Budget constraints 13 14 15 16 Objective to maximize 17 Total NPV 18 19 Range names used: 20 Amount_invested 21 Budget 22 Investment levels 23 Total NPV 3 4 5 $5,000 $16,000 3.20 $2,500 $8,000 $3,500 $10,000 2.86 $6,500 $19,500 $7,000 $22,000 $4,500 $12,000 $3,000 $7,500 3.20 3.25 3.14 2.67 2.50 Budget $15,000 Amount invested $14,500 $46,000 =Modell$B$14 =Modell$D$14 =Modell$B$10:$H$10 =Modell$B$1