in the attachment, I upload two files one of them word this what u should follow, and the other one is excel (that one is simple) I need u to do to me like that one on excel about my company which is (Buffalo Wild Wings) (BWLD). then right a paper as the word file mention
I need u to look at it, and tell me plz if u can do it or not. and if u have any question let me know or let me ask the instructor.
High Growth Period The questions below, especially the yes or no ones, can be confusing. Please read the comments on the input cells.
Length of high growth period = 10
Beta to use for high growth period for your firm= 1.14 You can use the cost of capital spreadsheet to compute this number
Do you want to keep the debt ratio computed from your inputs? Yes
If yes, the debt ratio that will be used to compute the cost of capital is 13.35%
If no, enter the debt ratio that you would like to use in the high growth period 7.00%
Do you want to keep the existing ratio of working capital to revenue? Yes
If yes, the working capital as a percent of revenues will be 6.90%
If no, enter the ratio of working capital to revenues to use in analysis 12%
Do you want to compute your growth rate from fundamentals? Yes
If no, enter the expected growth rate in operating income for high growth period 15%
If yes, the inputs to the fundamental growth calculation (based upon your inputs) are
Return on Capital = 53.20%
Reinvestment Rate = 32.05%
Do you want to change these inputs? No
Return on Capital = 33.00%
Reinvestment Rate = 32.05%
GSB 625: Financial Decision Making Assurance of Learning Project
AACSB’s Assurance of Learning (AOL) project for GSB 625 will help to accomplish the following learning objectives:
1. AOL-1: Learning Objective: Students will assess the financial strength of a company.
2. AOL-2: Learning Objective: Students will assess the impact of debt
In order to complete this assignment, each student is provided with a unique firm within the restaurant industry (Buffalo Wild Wings) (BWLD) and will write a paper assessing the financial health of that firm. In order to assess the firm’s health, each student will use the accompanying Excel worksheet to calculate the intrinsic value of each firm. The Excel worksheet is divided into several sub-sheets:
1. MASTER INPUTS: In this section, input your firm’s most recent operating income, interest expense, and other financial statement information. Students may also elect to capitalize R&D expenses and convert operating leases to debt. Each student is also asked to estimate how to compute beta and working capital. Be sure to save the assumptions made and include them in the paper.
2. EARNINGS NORMALIZER: Students may elect to normalize earnings based upon historical averages or sector averages.
3. VALUATION MODEL: The worksheet entitled Valuation Model provides information on your firm’s final cost of capital, percentage of debt and equity, and the intrinsic share price of the firm’s stock (Line F71).
Your AOL Assessment is a paper (single-spaced within paragraphs and double-spaced between paragraphs). Please use the following guidelines:
1. INTRODUCTION: Using the Initial Public Offering section from this course, introduce the restaurant. Include relevant information on (but not limited to) the following: brief history of the restaurant, initial public offering details(date it went public, which exchange, capital raised, lead underwriters), description of products offered.
2. LETTER TO THE SHAREHOLDER: Refer to the annual report (10K) and read the CEO’s letter to the shareholder. In addition to a brief biography of the CEO, briefly discuss what was learned from this letter regarding the firm’s financial health. Briefly summarize the main points of this letter.
3. MERGERS AND ACQUISITIONS: Refer to the annual report (10K) and outside research articles. Has the firm merged with another? Acquired a company? Created a joint alliance or patent agreements? Discuss findings here in relation to the growth potential of your company.
4. BANKRUPTCY: Refer to the bankruptcy discussions from this course. After reviewing the most recent annual report, discuss any recent litigation or news negatively impacting earnings and growth. Using the Altman Z bankruptcy calculators (http://www.investingcalculator.org/altman-z-score-calculator.html and http://www.creditguru.com/CalcAltZ.shtml, calculate the probability of the firm liquidating or reorganizing.