Question

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

Stockco 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. Currently, $14,000 is available for investment. Formulate an appropriate linear programming model clearly defining the decision variables, objective function and constraints and solve the model using Excel. Upload your file. You have only one attempt so upload the correct file please!

Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
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
Similar Questions
Capital Budgeting BioMed Engineering is considering two mutually exclusive investments. The projects' expected net cash flows...
Capital Budgeting BioMed Engineering is considering two mutually exclusive investments. The projects' expected net cash flows are as follows:                                                                                                                               Expected Net Cash Flows                                                                                                Time     Project A          Project B                                                                                    0          ($405)                ($705)                                                                            1          ($285)              $200                                                                              2          ($205)              $205                                                                              3          ($105)              $210                                                                              4          $605                 $215                                                                              5          $650                 $220                                                                              6          $925                 $225                                                                              7          ($200)              $230                                                                  In your report, identify which project would be selected (assuming they are mutually exclusive) for each investment criterion. Note that cash outflows (costs) are given in parenthesis. Employ the Excel file to answer the following questions Part 1: Net Present Value Use the Excel NPV function...
. A manufacturing company produces diesel engines in four factories located in Tucson, Seattle, Baltimore, and...
. A manufacturing company produces diesel engines in four factories located in Tucson, Seattle, Baltimore, and Detroit. Three trucking firms purchase these engines for their plants located in Nashville, Miami, and Charleston. The supplies and demands, along with the per engine transportation costs in dollars are given below:                                                                           Plant                                                               Nashville             Miami         Charleston         Supply              __________________________________________________________________                         Tucson                800               1100                400                  35    Factory            Seattle                 550               950                 600                  35                        ...
Average Rate of Return Method, Net Present Value Method, and Analysis The capital investment committee of...
Average Rate of Return Method, Net Present Value Method, and Analysis The capital investment committee of Nature’s Portrait Landscaping Company is considering two capital investments. The estimated income from operations and net cash flows from each investment are as follows: Front-End Loader Greenhouse Fixtures Year Income from Operations Net Cash Flow Income from Operations Net Cash Flow 1 $25,000 $ 40,000 $11,250 $ 26,250 2   20,000    35,000   11,250    26,250 3   7,000    22,000   11,250    26,250 4   3,000    18,000   11,250    26,250 5...
Net Present Value Method On Time Delivery Inc. is considering the purchase of an additional delivery...
Net Present Value Method On Time Delivery Inc. is considering the purchase of an additional delivery truck for $32,000 on January 1, 20Y4. The truck is expected to have a five-year life with an expected residual value of $5,000 at the end of five years. The expected additional revenues from the added delivery capacity are anticipated to be $68,000 per year for each of the next five years. A driver will cost $50,000 in 20Y4, with an expected annual salary...
Net Present Value—Unequal Lives Project 1 requires an original investment of $76,700. The project will yield...
Net Present Value—Unequal Lives Project 1 requires an original investment of $76,700. The project will yield cash flows of $12,000 per year for seven years. Project 2 has a calculated net present value of $16,500 over a five-year life. Project 1 could be sold at the end of five years for a price of $56,000. Use the Present Value of $1 at Compound Interest and the Present Value of an Annuity of $1 at Compound Interest tables shown below. Present...
Net Present Value—Unequal Lives Project 1 requires an original investment of $50,300. The project will yield...
Net Present Value—Unequal Lives Project 1 requires an original investment of $50,300. The project will yield cash flows of $12,000 per year for five years. Project 2 has a calculated net present value of $14,600 over a three-year life. Project 1 could be sold at the end of three years for a price of $49,000. Use the Present Value of $1 at Compound Interest and the Present Value of an Annuity of $1 at Compound Interest tables shown below. Present...
*Round all values to 4 decimal places. 1. What is the present value of $10,000 paid...
*Round all values to 4 decimal places. 1. What is the present value of $10,000 paid at the end of each of the next 71 years if the interest rate is 8% per​ year? The present value is $______. ​(Round to the nearest​ cent.) 2. Assume that your parents wanted to have $110,000 saved for college by your 18th birthday and they started saving on your first birthday. They saved the same amount each year on your birthday and earned...
1- Please use the information for this question and the following. A- A bank is considering...
1- Please use the information for this question and the following. A- A bank is considering two securities: a 30-year Treasury bond yielding 7% and a 30-year municipal bond yielding 5%. If the bank's tax rate is 30%, what is the tax-equivalent yield of the municipal bond? Please express as a %. B- Which bond gives the investor a better tax-equivalent yield? 2- Please use the information in this question for the next four questions, including this one. Below is...
Late in 2018, Felix Machine Company (FMC) management was considering expansion of the company’s international business...
Late in 2018, Felix Machine Company (FMC) management was considering expansion of the company’s international business activities. FMC is a South Carolina–based manufacturer of compound machines for use in industrial equipment. FMC’s worldwide market was supplied from subsidiaries in France, Brazil, and Taiwan, as well as from the United States. The company was particularly successful in Asia, mainly due to the high quality of its products, its technical expertise, and excellent after-sale service. This success led corporate management to consider...
Portfolio Project Option #1 is for accounting students who are sensing learners, and learn best from...
Portfolio Project Option #1 is for accounting students who are sensing learners, and learn best from concrete materials and examples. If this is your learning style preference, you are practical and careful with detail. For this assignment, you are required to complete all three accounting cases: Arizona Consultants Inc., Power and Demolition Company, and Warnerwood. You will then present Parts 1, 2, and 3 of the Portfolio Project in Excel as journal entries, following the exact instructions that accompany each...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT