+ . . . . . . At the present time, the beginning of year 1,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
+ . . . . . . At the present time, the beginning of year 1, the Barney-Jones Investment Corporation has $100,000 to invest for the next 4 years. There are five possible investments, labeled A through E. The timing of cash outflows and cash inflows for these investments is somewhat Irregular. - Investment A: Invest at the beginning of year 1, and for every dollar invested, there are returns of $0.50 and $1.00 at the beginning of year 2 and 3. . - We assume that any amounts can be invested in these strategies and that the returns are the same for each dollar invested. Investment B: Invest at the beginning of year 2, receive returns of $0.50 and $1.00 at the beginning of year 3 and 4. Investment C: Invest at the beginning of year 1, receive returns of $1.20 at the beginning of year 2. Investment D: Invest at the beginning of year 4, receive returns of $1.90 at the beginning of year 5. Investment E: Invest at the beginning of year 3, receive returns of $1.50 at the beginning of year 4. However, to create a diversifled portfolio, Barney-Jones decides to limit the amount put into any Investment to $75,000. The company wants an investment strategy that maximizes the amount of cash on hand at the beginning of year 5. At the beginning of any year, it can invest only cash on hand, which includes returns from previous investments. Any cash not investment in any year can be put in a short-term money market account that earns 3% annually. Objective: To develop an LP spreadsheet model that relates investment decisions to total ending cash, and to use Solver to find the strategy that maximizes ending cash and invests no more than a given amount in any one investment. + . . . . . . At the present time, the beginning of year 1, the Barney-Jones Investment Corporation has $100,000 to invest for the next 4 years. There are five possible investments, labeled A through E. The timing of cash outflows and cash inflows for these investments is somewhat Irregular. - Investment A: Invest at the beginning of year 1, and for every dollar invested, there are returns of $0.50 and $1.00 at the beginning of year 2 and 3. . - We assume that any amounts can be invested in these strategies and that the returns are the same for each dollar invested. Investment B: Invest at the beginning of year 2, receive returns of $0.50 and $1.00 at the beginning of year 3 and 4. Investment C: Invest at the beginning of year 1, receive returns of $1.20 at the beginning of year 2. Investment D: Invest at the beginning of year 4, receive returns of $1.90 at the beginning of year 5. Investment E: Invest at the beginning of year 3, receive returns of $1.50 at the beginning of year 4. However, to create a diversifled portfolio, Barney-Jones decides to limit the amount put into any Investment to $75,000. The company wants an investment strategy that maximizes the amount of cash on hand at the beginning of year 5. At the beginning of any year, it can invest only cash on hand, which includes returns from previous investments. Any cash not investment in any year can be put in a short-term money market account that earns 3% annually. Objective: To develop an LP spreadsheet model that relates investment decisions to total ending cash, and to use Solver to find the strategy that maximizes ending cash and invests no more than a given amount in any one investment.
Expert Answer:
Answer rating: 100% (QA)
To develop an LP spreadsheet model that relates investment decisions to total ending cash we can set ... View the full answer
Related Book For
Fundamentals Of Corporate Finance
ISBN: 9780135811603
5th Edition
Authors: Jonathan Berk, Peter DeMarzo, Jarrad Harford
Posted Date:
Students also viewed these finance questions
-
1. A ridge beam 1 ft wide by 2 ft deep in a roof system carries beams which are 36 in. apart o.c. The roof carries a uniform dead load in the direction of gravity of 30 psf (along the inclined...
-
THE SHOPPES AT RIVERSIDE Fonda L. Carter, Columbus State University Kirk Heriot, Columbus State University CASE DESCRIPTION This case asks the students to recommend a decision to a group of...
-
What are the income-distribution consequences of fashion? Can the need to be seen driving a new car by the rich be a boon to those with lower incomes who will ultimately purchase a better,...
-
When a sinusoidal wave crosses the boundary between two sections of cord as in Fig. 11-33 the frequency does not change (although the wavelength and velocity do change). Explain why.
-
Work through the revised simplex method step by step to solve the model given in Prob. 4.7-5.
-
Determine the number of ideal stages required in Example 7.4 if the solvent rate used is twice the minimum. Data From Example 7.4:- A solution of acetic acid (C) in water (A) is to be extracted using...
-
Statement of Legal Debt Margin. In preparation for a proposed bond sale, the city manager of the City of Appleton requested that you prepare a statement of legal debt margin for the city as of...
-
Find the range of the function defined by the equation and the given domain. f(x) = 4x3; domain= {0, 1, 2, 3}
-
Unicom is a regulated utility serving Northern Illinois. The following table lists the stock prices and dividends on Unicom from 1989 to 1998. a. Estimate the average annual return you would have...
-
Discuss two components of a multi-step income statement and why having those components being reported separately would be useful to a financial statement user. Recall that the six components of a...
-
(RiskReturn) An investor currently holds the following portfolio: 8,000 shares of Stock A, worth $18,000; Beta = 1.2 15,000 shares of Stock B, worth $50,000; Beta-1.81 25,000 shares of Stock C, worth...
-
Investment A is an equity (stock) investment in an American company. Returns on this Investment for the past 6 years are detailed in the table below, and Carlo expects the returns of the next 6 years...
-
Learning what constitutes ethical behavior in project management allows those new to the career to understand expectations from the start. Understanding that not all professionals are ethical,...
-
calculate the following KPIs for their investment funds: Annual Portfolio Return Portfolio Variance Portfolio Standard Deviation Sharpe Ratio Frugal Tim has $1.25M Invested (broken down seen below)...
-
What is the MIRR of a project that costs $725, generates free cash inflows of $233 at the end of each of the first 4 years and an outflow of 111 at the end of Year 5? The reinvestment rate is 7.6%....
-
3. IR spectra of both the (E)-Stilbene starting material and the meso-stilbene dibromide product were also obtained. Those spectra are shown below. Show complete analysis of the IR spectra 0.8 0.6 IR...
-
Parkin Industries, a U.S. company, acquired a wholly-owned subsidiary, located in Italy, at the beginning of the current year, for 200,000. The subsidiary's functional currency is the euro. The...
-
Laurel, Inc., has debt outstanding with a coupon rate of 6% and a yield to maturity of 7%. Its tax rate is 35%. What is Laurels effective (after-tax) cost of debt?
-
You have just deposited $1000 in an unusual bank account that pays interest biannually (once every 2 years). If the 2-year interest rate is 8% (total interest over 2 years is 8%, not 8% per year),...
-
For 2018, Walmart and Target had the following information (all values are in millions of dollars): a. What is each companys accounts receivable days? b. What is each companys inventory turnover? c....
-
There is another possible explanation for purchased goodwill appearing in a sole proprietor's statement of financial position. What do you think it might be?
-
Why do the assets need to be revalued in these cases? The business has not been sold.
-
The shown partners have always shared profits and losses in the ratio: Holt 4; Stott 2: Young 1. From 1 January the assets were to be revalued as the profit sharing ratios are to be altered soon. The...
Study smarter with the SolutionInn App