# Question: In the capital budgeting model in Figure 14 40 we supplied

In the capital budgeting model in Figure 14.40, we supplied the NPV for each investment. Suppose instead that you are given only the streams of cash inflows from each investment shown in the file S14_49.xlsx. This file also shows the cash requirements and the budget. You can assume that

(1) All cash outflows occur at the beginning of year 1;

(2) All cash inflows occur at the ends of their respective years; and

(3) The company uses a 10% discount rate for calculating its NPVs. Which investments should the company make?

(1) All cash outflows occur at the beginning of year 1;

(2) All cash inflows occur at the ends of their respective years; and

(3) The company uses a 10% discount rate for calculating its NPVs. Which investments should the company make?

**View Solution:**## Answer to relevant Questions

Solve the previous problem using the input data in the file P14_50.xlsx.In the capital budgeting model in Figure 14.40, we supplied the NPV for each investment. Suppose instead that you are given only the streams of cash ...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 original Western Airlines set-covering model in Figure 14.52, we used the number of hubs as the objective to minimize. Suppose instead that there is a fixed cost of locating a hub in any city, where these fixed costs ...In the peak-load pricing model, we assumed that the capacity level is a decision variable. Assume now that capacity has already been set at 30 kwh. Change the model appropriately and run Solver. Then use SolverTable to see ...A fertilizer company blends silicon and nitrogen to produce two types of fertilizers. Fertilizer 1 must be at least 40% nitrogen and sells for $70 per pound. Fertilizer 2 must be at least 70% silicon and sells for $40 per ...Post your question