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...
-
Maxine is retiring in 3 months. She is in great health and is expecting to live a long and healthy retired life. Maxine has always been a conservative investor and is concerned that she may outlive...
-
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...
-
Obtain the complex power delivered to the 10-k Ω resistor in Fig. 11.77 below. 02/0 Vrms 20I
-
Assume the country of Sluban ties its currency (the slu) to the dollar and the exchange rate will remain fixed. Sluban has frequent trade with countries in the eurozone and the United States. All...
-
James Ferguson operates Jims 11-E Auto Sales in Jonesborough, Tennessee, as a sole proprietorship. In 1999, Consumers Insurance Co. issued a policy to Jim Ferguson, Jims 11E Auto Sales covering Owned...
-
ECON2005 2022 CWA3 QU4 [30 marks] DATA FOR PREPARING STANDARD PRESENTATION OF THE BALANCE OF PAYMENTS 4a Use the data to prepare a Standard Presentation of the Balance of Payments 4b Show how you...
-
1. Which process should VBB choose to produce?? 2. How much would VBP be willing to pay for the testing that is currently offered, for each batch?? 3. Would we be considered a perfect test, at twice...
-
Go online and research the Lodging and Tourism industry to seek answers to the questions that follow. You may want to use the resources listed in Section 4.1a: Gathering Secondary Sources of Industry...
-
You make a $60,000 investment that gives you a cash flow of $5,900 in year one, $3,200 in year two, $15,800 in year three, and $50,500 in year four. What annual rate of return has your investment...
-
How do deontological and teleological ethical frameworks inform decision-making processes in complex socio-technological landscapes ?
-
Destiny Products uses a job-costing system with two direct-cost categories (direct materials and direct manufacturing labor) and one manufacturing overhead cost pool. Destiny allocates manufacturing...
-
When considering an eportfolio tool usage to showcase your work and achievement. What does this provide to potential employers? Would a short blog or video be necessary to capture the attention of...
-
Assistant Sculptor A sculptor and his assistant stop for a break as they carry a marble slab of length L = 0.803 m and mass 73.3 kg up the steps, as shown in the figure. The mass of the slab is...
-
Exercise 2-1 (Algo) The Effect of Changes in Sales Volume on Net Operating Income [LO2-1] Whirly Corporation's contribution format income statement for the most recent month is shown below: Sales...
-
Establish identity. cos( + k) = (-1)k cos , k any integer
-
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....
-
Assume that Reebok has developed two new types of athletic shoes. One is designed for distance runners, and the other has been developed for skateboarders. As a marketer, you need to evaluate the...
-
Sinason Tool & Die begins operations on January 1. Because all work is done Prepare a flowchart of a job to customer specifications, the company decides to use a job cost accounting system. Pre-...
-
How might consumer behavior be influenced by digital networks?
Study smarter with the SolutionInn App