Please provide step by step responses in excel, so I can fully grasp the concept and appropriate steps, here's the links, I do not plan or ever plan to submit a tutor's answer as my own, just to better understand the concepts and steps that need to be taken.

https://www.brinker.com/

https://www.investing.com/equities/brinker-international-inc-ratios

Case 1

Review the requirements of the Chapter 3 Mini-Case, 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 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.)
• (Access industry averages)
• (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.