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!
Homework Answers
Answer #1
Not the answer you're looking for?
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.
ADVERTISEMENT
Active Questions
asked 1 minute ago
asked 5 minutes ago
asked 6 minutes ago
asked 8 minutes ago
asked 23 minutes ago
asked 25 minutes ago
asked 29 minutes ago
asked 32 minutes ago
asked 32 minutes ago
asked 59 minutes ago
asked 1 hour ago
asked 1 hour ago