Case - Coffee Shop Chain

Assignment Help Finance Basics
Reference no: EM131756110

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) 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

Small Coffee

$2.50

500,000

Large Coffee

$3.50

350,000

Small Tea

$2.00

120,000

Large Tea

$2.70

100,000

Small Hot Chocolate

$3.00

100,000

Large Hot Chocolate

$3.70

80,000

Breakfast Sandwich

$4.50

50,000 (estimate)

Chicken Nuggets

$5.00

60,000 (estimate)

2) 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.

3) 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.

4) Looking at the financial statements of the company you estimate that average production cost (raw material, labor and ...) is 40% of the revenue.

5) 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.

6) The company pays $100,000 rent for its branches. The rent will increase by inflation rate every year.

7) 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.

8) 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.

9) 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.

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 yahoo finance, 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!!!

Reference no: EM131756110

Questions Cloud

What journal entry would have been recorded in third quarter : What journal entry would have been recorded in the third quarter of 2013 to record the issuance of the Series M Notes
Practises for assigning static ip addresses : What is considered the best practises for assigning static IP addresses in DHCP, Exclusions or Reservations, why?
Write a two-page essay that investigates the ways : Write a two-page essay that investigates the ways in which a union can increase employment for its members. For example, when unions pay television time
Journalize all depreciation entries for the equipment : Disick Limited sold a piece of equipment July 1,2017 for proceeds of 24000.The equipment had an original vanlue of 53000 and was purchased on January 1,2015.
Case - Coffee Shop Chain : 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
Compute the gross profit and the gross profit percentage : Compute the gross profit and the gross profit percentage for each company
What is the legislation or policy that will be analyzed : What is the legislation/policy that will be analyzed in this paper? Has (or will) the legislation been effective in addressing the problem or issue?
Discuss the strategies by which susan glaspells trifles meet : Discuss the strategies by which Susan Glaspell's Trifles meets the credentials for THE UNITIES OF ACTION, TIME, AND PLACE and THE WELL-MADE PLAY,.
Distinction between operating and nonoperating income : The distinction between operating and nonoperating income relates to: Primary activities of the reporting entity.

Reviews

len1756110

12/8/2017 2:41:29 AM

Instructions: The case is 10% of your final grade. Turn in the case in one report (hard copy) on the exam date. 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. The case should be done individually. 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.

Write a Review

Finance Basics Questions & Answers

  Winner of a breakfast cereal competition

(A) As the winner of a breakfast cereal competition, you can choose one of the following prizes:

  Discuss a financial ratio

Discuss a financial ratio, its primary users (i.e., management, creditors, investors, etc.) and what the financial ratio indicates.

  A money market security which consists of a par value of

question 1 you paid 98000 for a 100000 t-bill maturing in 120 days. if you hold it until maturity what is the t-bill

  How can you write covered calls

You have inherited some stock from a wealthy relative.- How can you write covered calls and minimize the likelihood of exercise?

  What is the percentage change in the bond price

A(n) eight-year bond has a yield of 10% and a duration of 7.208 years. If the bond's yield changes by 50 basis points, what is the percentage change in the bond's price?

  Analyze the profit and loss possibilities inherent

1. To analyze the profit and loss possibilities inherent in the option investment strategies, please perform the following analyses for call and put options on Lotus's common stock that mature in February 1994 and that have an exercise price of $..

  Failure of fi different from failure of a video rental store

How is the failure of an FI different from the failure of a video rental store? -What do these differences imply about the need for regulation?

  Capacity and automation levels

Installs For each year and by each segment, how many products will appear in the segment (When will new products be introduced)? For each year, what will your capacity and automation levels be in each product?

  What would your balanced four years

Suppose you deposited the $1000 in 4 payments of $250 each at year 1, year 2, year 3, and year 4. How much would you have in your account at year 4, based on 8 percent annual compounding?

  What is dollar profit or loss

If that option costs you $5 and the stock reaches $75, at which time you sell it, what was your dollar profit? Did you exercise the option? Why or why not? Was buying the option a "waste of money"? If the price of the stock falls to $7, what is yo..

  What is the price of the bond

A $1,000 par bond with an annual coupon has only one year until maturity. Its current yield is 6.713%, and its yield to maturity is 10%. What is the price of the bond?

  Are us ethical standards applicable worldwide explain your

1. what are the international and regional institutions that comprise the global monetary and financial system? what

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd