# Question: Solve the previous problem using the input data in the

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 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?

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?

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

Solve Problem 49 with the extra assumption that the investments can be grouped naturally as follows: 1–4, 5–8, 9–12, 13–16, and 17–20.a. Find the optimal investments when at most one investment from each group can ...How difficult is it to expand the Great Threads model to accommodate another type of clothing? Answer by assuming that the company can also produce sweatshirts. The rental cost for sweatshirt equipment is $1100, the variable ...Set-covering models such as the original Western Airlines model in Figure 14.52 often have multiple optimal solutions. See how many alternative optimal solutions you can find. Of course, each must use three hubs because we ...For each of the following, answer whether it makes sense to multiply the matrices of the given sizes. In each case where it makes sense, demonstrate an example in Excel, where you make up the numbers. a. AB, where A is 3 x 4 ...LP models are used by many Wall Street firms to select a desirable bond portfolio. The following is a simplified version of such a model. A company is considering investing in four bonds; $1 million is available for ...Post your question