View the step-by-step solution to:

Coffee Shop Chain Case A chain coffee shop company is considering adding a new line of business of offering small foods and snacks. You have spent...

should the company add food business?

Please provide step by step on how to solve excel table and the final solutioncase-2.pngcase-1.png

case-1.png

Coffee Shop Chain Case A chain coffee shop company is considering adding a new line of business of offering small foods and
snacks. The CEO of the company hired you as a financial analyst to help the company decide if it is
economical to add foods and snacks to its business or not. You have spent some time gathering information and talking to people in the company and you collected
following information. 1) 2) 3)
4) 5) 6)
7) 3) 9) The coffee shop chain already offers 3 types of drinks, each comes in 2 sizes. The coffee shop
wants to add a breakfast sandwich and chicken nuggets. Current sales information of the existing
drinks and estimated sales information for new foods according to the marketing consultant are: Unit Price sales
500,000
350,000
120,000
100,000 100,000
80,000
50,000 (estimate)
60,000 (estimate) Marketing consultant thinks that the market for the existing drinks is mature and the unit sales
will not grow anymore. However, he believes that the sales of the 2 new products will grow by
5% per year for the next 10 years. The company plans to increase the prices (for both the existing and new products) at the inflation
rate which is estimated to be 2% over the next 10 years. Looking at the financial statements of the company you estimate that average production cost
(raw material, labor and ...) is 40% of the revenue. To add the food business line, the company has to hire a food manager whose salary will be
$90,000 for the first year plus %28 overhead costs (insurance, retirement, benefits, ...). Her
salary will increase by inflation rate over the next 10 years. The company pays $100,000 rent for its branches. The rent will increase by inflation rate every
year. The company paid $45,000 to its marketing consultant for providing all the marketing related
information. You’ll also charge the company $60,000 for your financial advice. The company needs to buy new equipment for its branches to lunch the food business. The
equipment plus the installation costs would sum up to $1,000,000. The company uses MACRS
depreciation and the salvage value of the equipment after 10 years is estimated to be $50,000. The company also has to invest 10% of its estimated first year production cost in working capital
which will be recovered at the end of the 10—year period. Page 1 of 2.

case-2.png

10) Looking at the financial information of the company you realize that he company’s capital
structure consists of 40% equity, 20% preferred stock and 40% common stock. All figures were
calculated using market value. 11) The company has only one bond outstanding that matures in 10 years. It has 8% coupon rate with
annual coupon payment and $1000 face value. The bond currently trades at $920. 12) The company’s preferred stock pays $4 dividend per year and currently trades at $40 per share.
Assume there is no floatation costs. 13) Looking at yahoofinancecom, you see that the beta of the company is 0.9. As a financial analyst,
your estimate for the risk free rate and the expected return on the market are 3% and 12%
respectively. 14) The company has a 30% marginal tax rate. Should the company add food business? Give your advice!!! Instructions: 0 The case is 10% of your final grade. 0 Turn in the case in one report (hard copy) on the exam date. 0 Do everything in one word or pdf file. You OBVIOUSLY need to do the case in excel. Copy and
paste excel tables into your report, if needed. 0 The case should be done individually. 0 Use the “cash flow estimation” excel file as a guide. It is on Blackboard. Be careful, this project
will last 10 years. . You are welcome to stop by my office during office hours and ask questions about the case. Page 2 of 2.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question