+ . . . . . . 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
-
Blossom Corporation began operations on January 1, 2022. During its first 3 years of operations, Blossom reported net income and declared dividends as follows: Net income Dividends declared 2022...
-
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,...
-
Refer to Exercise 4.139. In E 4.139 a. Construct a joint probability distribution. b. Determine the probability distribution of weight for rookies; that is, construct a table showing the conditional...
-
Lex Cop is expected to generate a free cash flow (FCF) of $11,275.00 million this year (FCF1 = $11,275.00 million), and the FCF is expected to grow at a rate of 20.20% over the following two years...
-
Prepare a document flowchart to reflect how ANGIC Insurance Company processes its casualty claims. The process begins when the claims department receives a notice of loss from a claimant. Claims...
-
Amy Austin established an insurance agency on March 1 of the current year and completed the following transactions during March: a. Opened a business bank account with a deposit of $50,000 in...
-
Common stock value-Variable growth Personal Finance Problem Home Place Hotels, Inc., is entering into a 3-year remodeling and expansion project. The construction will have a limiting effect on...
-
The dean of a school of nursing (SON) and the associate deans of undergraduate and graduate programs have experienced increasing frustration with a lack of clinical placements for the students. The...
-
You are looking to invest in two assets, asset 1 and asset 2, and CAPM is true. We know that E[r] = 5% E[r2] = 6.5% 1 B = 0.6 = 0.9 Sharpe ratio market portfolio = 0.455 What would be the variance...
-
When working with gas mixtures we often use the approximation that the gas mixture is ideal. However, when studying condensed phases, the simple solution model is often inappropriate. 1. Dene what is...
-
please respond to each post adding viable information and continuing the conversation post 1 Studying gender can make someone more aware of how implicit assumptions influence the structure of...
-
Determine whether the set of vectors in M2,2 is linearly independent or linearly dependent. 2-1 4 3 -7 A = B= C = 4 5 20 23
-
At December 31, Bramble Corporation reports net income of $403,200. Prepare the entry to close net income. (List all debit entries before credit entries. Credit account titles are automatically...
-
Considering the readings Fried "Legal, But Inaccesible" and Cooney "The Way It Was", What are some of the ways (described in both readings) that women's access to reproductive healthcare is being...
-
A company used a 19% nominal discount rate toevaluate a new project. However, their advisor said that the normal discount rate for this industry is 13% but because of the different characteristics of...
-
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....
-
Wilmot Real Estate Co. had the following balance sheet at year-end 2015: In early 2016, the company took out a \($200,000\) two-year bank loan to finance new real estate investments. The loan...
-
Presented below is selected financial data for Apple !nc., for the five-year period 2010 to 2014. Required 1. Comment on the relationship between the growth in net sales and the growth in net income...
-
Presented below are the consolidated balance sheets and income statements for Tesco, PLC, the worlds third largest retailer, for the years 2016 and 2015. Tesco is based in the United Kingdom....
Study smarter with the SolutionInn App