Brinker International Financial Analysis

Review the requirements of the Chapter 3 Mini-Case (attached), parts b through j. Then apply those requirements to do an analysis of Brinker International, which is a real company. DON’T COMPLETE THE MINICASE ITSELF, just an analysis of Brinker. Do the analysis on the basis of the figures for the most recent year. For part g, use the 2 most recent years.

Download 10K financial statements for the most recent year for Brinker. A good source is the company’s home page. Also compare the Brinker ratios to the industry averages and comment on significant differences.

You’ll note that some of the company’s ratios you calculate won’t agree with those found on the web page. Ratios are calculated in different ways, however, you should use the formulas in the text. Also, you won’t find all of the industry averages, but you will find most of them. You’ll need the company’s stock price for several of the ratios; use the fiscal year end price. The company’s stock symbol is EAT.

(Visit Brinker web site) http://www.brinker.com/
(Access industry averages) http://www.investing.com/equities/brinker-international-inc-ratios

Note:

Complete problems and other quantitative work in Excel; Word is not acceptable.
Show how you derive each answer. If you use a formula, I can place the cursor over your answer and see how you derived the answer. If you do a calculation manually, enter each input, result and solution in a separate cell. Alternatively, you may use a financial calculator, but must show the keystrokes on your Excel worksheet and enter each input, result, and solution in a separate cell. Narrative may be completed in Excel (use text boxes or merge cells) or Word.
Include the balance sheet and income statement on the same worksheet as the ratio calculations.