Company’s Finance Assingment Help With Solution

Posted on April 11, 2017

Company’s Finance Assingment Help With Solution

 

Our final objective is to take the information we analyzed in the first homework assignment and attempt to value Starbucks to determine whether it would make sense to invest in the stock today (2/24/15). Use the excel template provided to assess any historical and forecasted data.99% of your quantitative information will come from your calculations but if you have downloaded anything, i.e. ERP, it must be sourced appropriately. Print screens can be downloaded directly into your excel worksheet. Lack of sourcing will result in point deductions.
 
Quantitative Analysis(60 pts)
 
a. Fill in all highlighted items on the Assumptions, ROIC, Operating Lease, Ratios, and WACC tabs starting with the historical data through the forecasted data
 
i. Do NOT assume “other assets/liabilities” are operating. You must look into the 10k and see exactly what these values represent. This is one of your assumptions and print screens can be used to back up your opinion.
 
ii. For the WACC, calculate all three methods of cost of debt
 
iii. In addition to revenue and margins, you also need to forecast the components of invested capital and lastly data such as acquisitions for the FCF calculation
 
iv. For changes in NWC, use your forecasts of operating CA – operating CL calculating AR, Inventory and AP using DSO, DIO, DPO
 
b. Fill in the Forecast tab. Revenue growth and profit margins determine the value of the investment according to this model. Forecast revenue growth, gross and operating margin (all operating expenses as a % of sales or PP&E). In making your forecasts, take into account both management’s assessment of the future, analyst projectionsand your evaluation of the economy over the next five years. (Source all expectations unless they are your own opinion) In assumptions explain your reasoning
 
i. Analyst evaluations are good to read but remember you have to understand their thought process. If you are using data from a private source, provide a print out of the report you are utilizing.
 
ii. You CANNOT just take averages nor should you assume stable growth until at least five years from now.
 
iii. You must show several valuation approaches for the CV/TV – the continuing value formula using NOPLAT*(1-g/ROIC), the exit multiple approach showing the implied growth rate, using the implied growth rate for FCF*(1+g) and the 0% excess approach
 
iv. Calculate a sensitivity analysis for your exit multiple, growth rate and WACC
 
c. You MUST make sure all your valuations connect and are not just inputs that do not connect to the other sections of the balance sheet, income statement, FCF
 
d. Fill in all remaining values on the excel template and calculate your equity value. Based on this calculation, should you buy, sell or hold SBUX stock.
 
e. As we discussed in class, capital is historically cheap today and given our WACC includes yield to maturity and the risk free rate, the calculation may underestimate the Company’s required rate of return. I have spoken with some current SBUX employees, and they say their “hurdle rate” for the company varies between 8 – 10% based on the risk of the investment they are making with the typical rate = 8%. Value your company at this rate.

 

How it Works

How It works ?

Step 1:- Click on Submit your Assignment here or shown in left side corner of every page and fill the quotation form with all the details. In the comment section, please mention product code mentioned in end of every Q&A Page. You can also send us your details through our email id support@assignmentconsultancy.com with product code in the email body. Product code is essential to locate your questions so please mentioned that in your email or submit your quotes form comment section.
 
Step 2:- While filling submit your quotes form please fill all details like deadline date, expected budget, topic , your comments in addition to product code . The date is asked to provide deadline.
 
Step 3:- Once we received your assignments through submit your quotes form or email, we will review the Questions and notify our price through our email id. Kindly ensure that our email id assignmentconsultancy.help@gmail.com and support@assignmentconcultancy.com must not go into your spam folders. We request you to provide your expected budget as it will help us in negotiating with our experts.
 
Step 4:- Once you agreed with our price, kindly pay by clicking on Pay Now and please ensure that while entering your credit card details for making payment, it must be done correctly and address should be your credit card billing address. You can also request for invoice to our live chat representatives.
 
Step 5:- Once we received the payment we will notify through our email and will deliver the Q&A solution through mail as per agreed upon deadline.
 
Step 6:-You can also call us in our phone no. as given in the top of the home page or chat with our customer service representatives by clicking on chat now given in the bottom right corner.

Features

Features for Assignment Help

Zero Plagiarism
We believe in providing no plagiarism work to the students. All are our works are unique and we provide Free Plagiarism report too on requests.

 

Relevancy
We believe in providing perfect, relevant and 100% accurate solutions to the student as per questions asked. All our experts are perfect in providing that so as to give unique experience to the students.

 

Three Stage Quality Check
We are the only service providers boasting of providing original, relevant and accurate solutions. Our three stage quality process help students to get perfect solutions.

 

 

100% Confidential
All our works are kept as confidential as we respect the integrity and privacy of our clients.

Related Services

 
Qualitative Assessmentin a WORD document (40 pts)
 
1) Start your paper with a buy, sell or hold recommendation stating the level of valuation as compared to the current market price as of 2/24/15.Include both the current and forecasted growth strategy of SBUX and how these plans have been incorporated into your forecasts. This should incorporate both domestic and international plans.
 
2) You do NOT need to reiterate what you already wrote in your homework assignment but should evaluate the first quarter for SBUX as we did not include that in our original assignment.
 
3) How did the sensitivity analysis impact your overall decision? Did the re-calculation of equity value at 8% as compared to your WACC impact your decision?
 
4) In the ratio and segment tab you have an overall review of the company historically as well as the top two competitors. How did this information impact your assessment?
 
5) Did operating leases have a big impact on your valuation? How important is it to consider this type of off-balance sheet financing for a company like SBUX?
 
6) OUTLINE FORMAT: Explain the inputs into your DCF model. When I say “explain” I do not want a reiteration of the number or the formula but rather what determined the number in your analysis.You must have support for your thought process and cannot just look at the history of the company and assume that will continue.Explain the full five year time frame. DO NOT just assume everything remains the same b/c that is completely unreasonable.
 
a. Revenue growth, gross and operating profit margin projections over the time period. Even if you read an analyst report you still need to explain what is behind their evaluation of PG’s growth. This includes your thoughts about all operating expenses. Include how the macro -economic environment impacted your estimates. Keep in mind PG is a global company.
 
b. What did you decide about the “other” assets and liability categories including LT investments,
Equity investments, Minority Interest?
 
c. Growth rate, ROIC and Exit multiple, you used in the continuing value.
 
d. Evaluation of operating versus excess cash.
 
e. Invested and non-operatingcapital projections – include your assessment of working capital, PP&E, goodwill and intangible assets – For example, did you include continued acquisition as part of SBUX ongoing growth strategy?
 
f. What ERP did you use and why? What method of cost of debt did you use and why?

 

 

Product Code :Fin269

To get answer for this question, kindly click here (Note: Don’t forget to write the product code in comment section)

You can also email us at assignmentconsultancy.help@gmail.com but please mentioned product code in the mail body while sending emails.You can browse more questions to get answer in our Q&A sections here.

Summary