HomeworkLib
Question

SUinvestments is considering four investments. Investment 1 will yield a net present value (NPV) of $16,000;...

SUinvestments is considering four investments. Investment 1 will yield a net present value (NPV) of $16,000; investment 2, an NPV of $22,000; investment 3, an NPV of $12,000; and investment 4, an NPV of $8,000. Each investment requires a certain cash outflow at the present time: investment 1, $5,000; investment 2, $7,000; investment 3, $4,000; and investment 4, $3,000. Note that no partial investments are allowed. Currently, $14,000 is available for investment. Formulate an integer linear programming model that will help SUinvestments maximize the total NPV obtained from investments 1–4. Solve this problem using Excel Solver. **I understand the constraints and objective function, but how would you formulate it excel?

math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Answer:

Formulation of the problem:-

Xj(j =1,2.3,4) = 1 (if investment j is made   ; 0 otherwise)

Objective function:-

Z= 16x1 +22x2 +12x3 +8x4

Subject to:-

5x1 +7x2 +4x3 +3x4≤ 14

Xj=0 or 1 (j=1,2,3,4)

0 0
Add a comment
Know the answer?
Add Answer to:
SUinvestments is considering four investments. Investment 1 will yield a net present value (NPV) of $16,000;...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • SUinvestments is considering four investments. Investment 1 will yield a net present value (NPV) of $16,000;...

    SUinvestments is considering four investments. Investment 1 will yield a net present value (NPV) of $16,000; investment 2, an NPV of $22,000; investment 3, an NPV of $12,000; and investment 4, an NPV of $8,000. Each investment requires a certain cash outflow at the present time: investment 1, $5,000; investment 2, $7,000; investment 3, $4,000; and investment 4, $3,000. Note that no partial investments are allowed. Currently, $14,000 is available for investment. Formulate an integer linear programming model that will...

  • SUinvestments is considering four investments. Investment 1 will yield a net present value (NPV) of $16,000;...

    SUinvestments is considering four investments. Investment 1 will yield a net present value (NPV) of $16,000; investment 2, an NPV of $22,000; investment 3, an NPV of $12,000; and investment 4, an NPV of $8,000. Each investment requires a certain cash outflow at the present time: investment 1, $5,000; investment 2, $7,000; investment 3, $4,000; and investment 4, $3,000. Note that no partial investments are allowed. Currently, $14,000 is available for investment. Formulate an integer linear programming model that will...

  • SUinvestments is considering four investments. Investment 1 will yield a net present value (NPV) of $16,000;...

    SUinvestments is considering four investments. Investment 1 will yield a net present value (NPV) of $16,000; investment 2, an NPV of $22,000; investment 3, an NPV of $12,000; and investment 4, an NPV of $8,000. Each investment requires a certain cash outflow at the present time: investment 1, $5,000; investment 2, $7,000; investment 3, $4,000; and investment 4, $3,000. Note that no partial investments are allowed. Currently, $14,000 is available for investment. Formulate an integer linear programming model that will...

  • QUESTION 3 Analyzing the investment problem shown below, one advisor recommended buying a combination of investments...

    QUESTION 3 Analyzing the investment problem shown below, one advisor recommended buying a combination of investments 2 3. and 6... Input data on potential investments Investment 2 3 4 5 6 Year 1 cost $5,000 $2,500 $3,500 $6,500 $7,000 $4,500 $3,000 Year 2 cost $2,000 $1,500 $2,000 50 $500 $1,500 $0 NPV $ 16,000 $8,000 $10,000 $20,000 $22.000 $12,000 $8,000 Decisions: whether to invest Investment levels 0 0 0 0 0 0 0 Budget constraints Budget Amount invested SO 50...

  • 3a, b and c please help 3. (30pt) A company considers the following 4 projects: Project...

    3a, b and c please help 3. (30pt) A company considers the following 4 projects: Project Capital Investment in year 0$10,000$6,000 A В С D $4,000 $8,000 -$2,000 $5,000 $1,600 $1,300$1,500 $4,000 $5,000 $8,000 $1,200 Net Cash Flow in 1 year Net Cash Flow in year 2 $4,000 $8,000 $10,200 Net Cash Flow in year The MARR is 10% per year. The company has a $20,000 budget for the capital investment in year 0. a) (10pt) Find NPV8 of 4...

  • Determine Value of Investment Nu Things, Inc., is considering investing in a business venture with the...

    Determine Value of Investment Nu Things, Inc., is considering investing in a business venture with the following anticipated cash flow results: EOY Cash Flow 0 $70,000 $20,000 $19,000 $18,000 $17,000 $16,000 $15,000 $14,000 $13,000 $12,000 $11,000 $10,000 $9,000 $8,000 $7,000 $6,000 $5,000 $4,000 $3,000 $2,000 $1,000 Assume MARR is 20 percent per year. Based on an internal rate of return analysis:

  • (Present value of an uneven stream of payments) You are given three investment alternatives to analyze....

    (Present value of an uneven stream of payments) You are given three investment alternatives to analyze. The cash flows from these three investments are as follows: Investment End of Year $1,000 2,000 3,000 (4,000) 4,000 $3,000 3,000 3,000 3,000 5,000 $ 4,000 4,000 (4,000) (4,000) 14,000 4 What is the present value of each of these three investments if the appropriate d iscount rate is 13 percent?

  • M4_A5. Porter Investments needs to develop an investment portfolio from the following list of possible investments...

    M4_A5. Porter Investments needs to develop an investment portfolio from the following list of possible investments COST ($) INVESTMENTS EXPECTED RETURN ($) A 1,700 15,000 17,000 1,850 8,500 1,400 10,000 1,500 E 13,500 1,750 13,000 1,650 9,000 1,500 H 9,500 1,700 The client can invest up to $100,000. The following conditions should be met: (1) If investment C is chosen, then investment D must also be part of the portfolio, (2) at least four investments should be chosen, (3) of...

  • (Present value of an uneven stream of payments) You are given three investment alternatives to analyze....

    (Present value of an uneven stream of payments) You are given three investment alternatives to analyze. The cash flows from these three investments are as follows: Investment End of Year A C 2,000 $1,000 1,000 1,000 1 4,000 4,000 (4,000) (4,000) 14,000 2 3,000 4,000 (5,000) 5,000 3 1,000 3,000 5 What is the present value of each of these three investments if the appropriate discount rate is 13 percent? a. What is the present value of investment A at...

  • You are given three investment alternatives to analyze. The cash flows from these three investments as...

    You are given three investment alternatives to analyze. The cash flows from these three investments as followed: End of the year A B C 1 $3,000 $3,000 4,000 2 4,000 3,000 4,000 3 5,000 3,000 (4,000) 4 (6,000) 3,000 (4,000) 5 6,000 5,000 14,000 What is the present value of Investment A at an annual discount rate of 11 percent?

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT