Review the requirements of the Chapter 3 Mini-Case, parts b through j. Then apply those requirements to an analysis of Brinker International, which is a real company. Don't complete the minicase itself, just 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)(Links to an external site.)Links to an external site.

(Access industry averages)(Links to an external site.)Links to an external site.

Note:

Complete problems and other quantitative work in Excel; Word is not acceptable.

Show how you deriveeach answer.If you use a formula, I can place the cursor over your answer and see how you derived the answer.If you doa 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 solutionin 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.

Late submissions will be penalized unless pre-approved by the instructor.

Submit the entire assignment at the same time.