Tom Douglas is a famous Seattle restaurant entrepreneur. He has been so successful that he now...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Tom Douglas is a famous Seattle restaurant entrepreneur. He has been so successful that he now just angel invests into new concepts that approach him. Recently a slew of entrepreneurs have reached out asking for his partnership. He has hired you on to determine which restaurant concepts he should invest in and at what level. The four he is considering are: Bitcoin Boba, Fancy French, Sushi Yum, and FroYolo. Each project requires a different level of investment over the next few years and will be sold within five years. Below are the projected cash flows ($M). Year 1 2 3 4 5 Bitcoin Boba -12 -8 -10 -4 44 Fancy French -4 -4 -7 26 0 Sushi Yum -6 -7 17 0 0 FroYolo -9 -8 -7 -7 38 He currently has $10M to invest and expects to have an additional $4M each year to invest in these concepts at the start of each year (1 through 5). Thus for year 1 he'll have a total of $14M to invest. Assume that the money not spent in a given year is available for future years and also earns 2% interest. For example, if the ending balance in year 1 is $1M, then $1.02M will be available for projects in year 2 (along with the $4M in additional investment funds for year 2). Assume that all cash flows occur simultaneously at the start of the year (e.g., income in a given year can be used for investment in that same year). Tom needs to decide how much to invest in each project - fully, fractionally (with other investors), or not at all. If he participates at less than 100%, then all the cash flows associated with that project are reduced proportionally. For example, if Tom Douglas invests in FroYolo at 50%, the cash flows associated with that project would be -4.5, -4, -3.5, -3.5, and 17.5 respectively at the start of years 1 through 5. Tom further has a policy that he would like to end each year with a cash balance of at least $1M. Interest is earned on all remaining cash including the $1M minimum balance. Which projects should you tell Tom Douglas to take part in and at what % level of investment so as to end year 5 with as much cash as possible? Formulate and solve a linear programming spreadsheet model. Clearly indicate your final values and total cash value. Provide a screenshot of your model and a screenshot of your solver screen prior to solving. You do not need to write the algebraic equation. Tom Douglas is a famous Seattle restaurant entrepreneur. He has been so successful that he now just angel invests into new concepts that approach him. Recently a slew of entrepreneurs have reached out asking for his partnership. He has hired you on to determine which restaurant concepts he should invest in and at what level. The four he is considering are: Bitcoin Boba, Fancy French, Sushi Yum, and FroYolo. Each project requires a different level of investment over the next few years and will be sold within five years. Below are the projected cash flows ($M). Year 1 2 3 4 5 Bitcoin Boba -12 -8 -10 -4 44 Fancy French -4 -4 -7 26 0 Sushi Yum -6 -7 17 0 0 FroYolo -9 -8 -7 -7 38 He currently has $10M to invest and expects to have an additional $4M each year to invest in these concepts at the start of each year (1 through 5). Thus for year 1 he'll have a total of $14M to invest. Assume that the money not spent in a given year is available for future years and also earns 2% interest. For example, if the ending balance in year 1 is $1M, then $1.02M will be available for projects in year 2 (along with the $4M in additional investment funds for year 2). Assume that all cash flows occur simultaneously at the start of the year (e.g., income in a given year can be used for investment in that same year). Tom needs to decide how much to invest in each project - fully, fractionally (with other investors), or not at all. If he participates at less than 100%, then all the cash flows associated with that project are reduced proportionally. For example, if Tom Douglas invests in FroYolo at 50%, the cash flows associated with that project would be -4.5, -4, -3.5, -3.5, and 17.5 respectively at the start of years 1 through 5. Tom further has a policy that he would like to end each year with a cash balance of at least $1M. Interest is earned on all remaining cash including the $1M minimum balance. Which projects should you tell Tom Douglas to take part in and at what % level of investment so as to end year 5 with as much cash as possible? Formulate and solve a linear programming spreadsheet model. Clearly indicate your final values and total cash value. Provide a screenshot of your model and a screenshot of your solver screen prior to solving. You do not need to write the algebraic equation.
Expert Answer:
Answer rating: 100% (QA)
To solve this problem well set up a linear programming model using a spreadsheet The decision variab... View the full answer
Related Book For
Accounting Principles Part 3
ISBN: 978-1118306802
6th Canadian edition Volume 1
Authors: Jerry J. Weygandt, Donald E. Kieso, Paul D. Kimmel, Barbara Trenholm, Valerie Kinnear, Joan E. Barlow
Posted Date:
Students also viewed these finance questions
-
You are given the following data by Ecosneak: Their annual promotional budget (of 300,000) The cost of each Billboard advert (2,000) and the cost of each Magazine advert (5,000); The estimated...
-
answer all questions as instructed below. attend all questions. 4 Computer Vision (a) Explain why such a tiny number of 2D Gabor wavelets as shown in this sequence are so efficient at representing...
-
Posting the entries from the sales journal to the accounts receivable subsidiary ledger should be done ______. a). at the end of each month b). on a weekly basis c). on a daily basis d). only at the...
-
Belinda spent the last 60 days of 2016 in a nursing home. The cost of the services provided to her was $18,000 ($300 per day). Medicare paid $8,500 toward the cost of her stay. Belinda also received...
-
A random sample of 500 adult residents of Maricopa County found that 385 were in favor of increasing the highway speed limit to 75 mph, while another sample of 400 adult residents of Pima County...
-
Percival Pharmaceuticals manufactures an over-the-counter allergy medication called Breathe. Percival is trying to win market share from Sudafed and Tylenol. The company has developed several...
-
Swisscom AG, the principal provider of telecommunications in Switzerland, prepares consolidated financial statements in accordance with International Financial Reporting Standards (IFRS). Until 2007,...
-
(a) The Treasury desk of a global bank incorporated in UK wants to invest GBP 200 million on 1st January, 2019 for a period of 6 months and has the following options: (1) The Equity Trading desk in...
-
How does the natural imagery of the wilderness in the works of Henry David Thoreau and John Muir reflect their transcendentalist beliefs and environmental advocacy?
-
Which of the following class types cannot be marked final or abstract? A. static nested class. B. Local class. C. Anonymous class. D. Member inner class. E. All of the above can be marked final or...
-
Which of the following statements compile and create infinite loops at runtime? (Choose two.) A. while (! false) {} B. do {} C. for() {} D. do {} while (true); E. while {} F. for(;;) {}
-
What can fill in the blank so the play() method can be called from all classes in the com. mammal package, but not the com.mammal.gopher package? A. Leave it blank. B. private C. protected D. public...
-
Which statements about static interface methods are correct? (Choose three.) A. A static interface method can be final. B. A static interface method can be declared private. C. A static interface...
-
Which of the following lines of code are not permitted as the first line of a Java class file? (Choose two.) A. import widget. *; B. // Widget Manager C. int facilityNumber; D. package sprockets; E....
-
Let's define the following quantity, f(x +h) f(x h) Dr %3D 2h
-
Use the information given about the angles and to find the exact value of: (a) sin( + ) (b) cos( + ) (c) sin( - ) (d) tan ( + ) (e) sin(2) (f) cos (2) (g) sin /2 (h) cos/2 cos = 4/5, 0 < < /2; cos =...
-
Before preparing financial statements for the current year, the chief accountant for Patel Ltd. discovered the following errors in the accounts: 1. Patel has 20,000, $4 noncumulative preferred shares...
-
Fresh Foods Inc. uses the indirect method to report cash provided from operating activities. Vijaya, the company president, argues, "Depreciation should not be reported as a cash inflow in the...
-
Here are some of the terms discussed in the chapter: 1. Retained earnings 2. Issued shares 3. Legal capital 4. Liquidation preference 5. Authorized shares 6. Public corporation 7. Convertible 8....
-
How does each of the following variables behave over the business cycle? Develop graphs to show your results and give economic explanations. a. Real imports b. Federal government receipts c. Housing...
-
Graph the levels of real GDP for the United States, Canada, and Germany (data can be found at www.oecd.org under Statistics and then under National Accounts). Are U.S. and Canadian business cycles...
-
Which school of economists, classical or Keynesian, supports government intervention in the face of economic shock? Explain your answer based on the underlying assumptions.
Study smarter with the SolutionInn App