Question: I need help in this question, Please do it on excel and do not make any mistake. Please do it correctly as required A B
I need help in this question, Please do it on excel and do not make any mistake. Please do it correctly as required

A B D E F H J K G A company faces capital budgeting decisions, and there are nine potential investments. Each has an investment cost and a corresponding stream of cash flows (including the investment cost) summarized by a net present value (NPV). The company must decide which of these nine investments to make. There are two constraints that affect the decisions. First, each investment is an all-or-nothing decision. The company either invests entirely in an investment, or it ignores the investment completely. It is not possible to go part way, incurring a fraction of the cost and receiving a fraction of the revenues. Second, the company is limited by a budget of $30 million. The total cost of the investments it chooses cannot exceed this budget. With these constraints in mind, the company wants to choose the investments that maximize the total NPV. Capital budgeting model 4. 5 5 8 - 1 $6.9 $8.0 15.9% 2 $2.4 $2.7 12.5% 3 $3.5 $3.9 11.4% $5.9 $6.8 15.3% $6.9 $7.7 11.6% 6 $4.8 $5.6 16.7% 7 $3.0 $3.3 10.0% $5.0 $5.9 17.0% 9 $3.7 $4.2 13.5% Input data on potential investments ($ millions) Investment Cost NPV . ROI o 1 Decisions: whether to invest 2 1 if yes, if no 3 3 4 Budget constraint 5 6 7 8 Objective to maximize 9 Total NPV (Objective Function) 0 1 Total cost Budget
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
