Finance homework need use excel not paper
The questions start on page 33 of the pdf/reading titled: FinancialStmtReading
Minicase: Review the requirements of the Chapter 3 Mini-Case, parts b through j. Then apply those same requirements to do an analysis of Brinker International, which is a real company. 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. 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. On the Brinker assignment, answer parts b through j for Brinker on the basis of the figures for the most recent year. Disregard references to 2011E. For part g, use the two most recent years for analysis, 2014 and 2015.
Download financial statements (income statement and balance sheet) from the Internet (www.brinker.com) Refer to the mini case at the end of Chapter 3 and do Parts b, c, d, e, f, g, h, I for Brinker for the most recent year. Ignore 2011e. Only use 2014 and 2015.
