Instructions to access financial statements: The financial statements are to be downloaded from www.Morningstar.com 1. Enter each company's stock symbol in the "Search" field. Select the correct company (Disney and Tyson Foods) 2. On the company's landing page, click on the "Key Ratios" link to the right of, or below, the stock price chart. 3. Click on the "Full Key Ratios Data" link. 4. Click on the "Financials" tab. a. The Income Statement will be displayed. Specify the level of rounding at dollars (vs. thousands, millions, etc). Select "Export" to download the data to a spreadsheet. Once downloaded, you will need to paste the Income Statement data from the most recent four years into the data case template. You should not include the earliest year of data or the TTM data in the pasted data prior to pasting into the template. It is easiest to delete these columns prior to copying and pasting into the template. b. Now select the Balance Sheet and export the Balance Sheet data to a spreadsheet, then paste the Balance Sheet data for the four most recent years into the data case template. c. Repeat the process for the Statement of Cash Flows. 5. Instructions for finding historical stock prices for the final day of each fiscal year can be found on page 68 of the text. 6. All calculated values must be calculated within the spreadsheet using either formulas or Excel functions. 7. Questions to be answered can be found on page 69 of the text. It is unnecessary to find the Industry Averages (Question 4A) or to compare each company's performance in Question 4b to the Industry Average. Instead, comment on each company's performance over the four year period for Question 4B. 8. Remember to answer Questions 5, 6 and 7 for each company on the first company worksheet. INSERT DISNEY INCOME STATEMENT AS ORIGINALLY REPORTE Ratios Sep 17 Sep 10 Sep 19 Sep-20 04 Industry Stock Price EBITDA Total Debt EPS Valuation Price Earings Use basic EPS WA Use diluted EPS Market to Book Use Capital Stock and Basic WASO NIA Enterprise / EBITDA Profitability Operating Margin Gross Proft Margin NA Net Proft Margin NA Based on Net Income from Continuing INSERT BELOW DES BALANCE SHEET AS ORIGINALLY STATED Retum on Equity NA Based on Net Income from Continuing Operations & Total Stockholder Equity Financial Strength Current Ratio NA Book Debt-Equity NA Mit Debt Equity Interest Coverage NIA Enterprise Value Question 4b: Question 5: INSERT BELOW DIS CASH FLOW STATEMENT AS ORIGINALLY STATED Question 6: Question 7: INSERT BELOW TSN INCOME STATEMENT AS ORIGINALLY STATED Radios Dec-17 Dec 18 Dec 18 Dec 19 04 Industry Dec 19 Dec 20 Stock Price EBITDA Total Debt EPS Valuation Price Emminge MA Use diluted earnings Market to Book NA Use Basic Shares (WASO) Enterprise EBITDA Profitability Operating Margin Gross Prof Margin NA Net Proft Morgan NA Return on Equity Based on Total Equity to Parent Shareholders INSERT BELOW TSN BALANCE SHEET AS ORIGINALLY STATED WA Financial Strength Current Ratio NA NA Book Dell Euty Mit Euty WC NA Entivprise Value INSERT BELOW TSN CASH FLOW STATEMENT AS ORIGINALLY STATED Question ab INSERT BELOW TSN INCOME STATEMENT AS ORIGINALLY STATED Ratios Dec-17 Door Dec 18 04 Industry Dec-19 Dec 20 Stock Price EBITDA Total Debt EPS Valuation Price Earnings NA Use diluted earning Market to Book NA Use Basic Shares (WASO) Enterprise / EBITDA Profitability Operating Marin Gross Prolt Margin NA Net Profit Margin NA Return on Equity Based on Total Equity to Parent Shareholders INSERT BELOW TSN BALANCE SHEET AS ORIGINALLY STATED NA Financial Strength Current Ratio NA NA Book Date Equity Mit Diety Meront Coverage NA Entre Value INSERT BELOW ISN CASH ROW STATEMENT AS ORIGINALLY STATED Question : Instructions to access financial statements: The financial statements are to be downloaded from www.Morningstar.com 1. Enter each company's stock symbol in the "Search" field. Select the correct company (Disney and Tyson Foods) 2. On the company's landing page, click on the "Key Ratios" link to the right of, or below, the stock price chart. 3. Click on the "Full Key Ratios Data" link. 4. Click on the "Financials" tab. a. The Income Statement will be displayed. Specify the level of rounding at dollars (vs. thousands, millions, etc). Select "Export" to download the data to a spreadsheet. Once downloaded, you will need to paste the Income Statement data from the most recent four years into the data case template. You should not include the earliest year of data or the TTM data in the pasted data prior to pasting into the template. It is easiest to delete these columns prior to copying and pasting into the template. b. Now select the Balance Sheet and export the Balance Sheet data to a spreadsheet, then paste the Balance Sheet data for the four most recent years into the data case template. c. Repeat the process for the Statement of Cash Flows. 5. Instructions for finding historical stock prices for the final day of each fiscal year can be found on page 68 of the text. 6. All calculated values must be calculated within the spreadsheet using either formulas or Excel functions. 7. Questions to be answered can be found on page 69 of the text. It is unnecessary to find the Industry Averages (Question 4A) or to compare each company's performance in Question 4b to the Industry Average. Instead, comment on each company's performance over the four year period for Question 4B. 8. Remember to answer Questions 5, 6 and 7 for each company on the first company worksheet. INSERT DISNEY INCOME STATEMENT AS ORIGINALLY REPORTE Ratios Sep 17 Sep 10 Sep 19 Sep-20 04 Industry Stock Price EBITDA Total Debt EPS Valuation Price Earings Use basic EPS WA Use diluted EPS Market to Book Use Capital Stock and Basic WASO NIA Enterprise / EBITDA Profitability Operating Margin Gross Proft Margin NA Net Proft Margin NA Based on Net Income from Continuing INSERT BELOW DES BALANCE SHEET AS ORIGINALLY STATED Retum on Equity NA Based on Net Income from Continuing Operations & Total Stockholder Equity Financial Strength Current Ratio NA Book Debt-Equity NA Mit Debt Equity Interest Coverage NIA Enterprise Value Question 4b: Question 5: INSERT BELOW DIS CASH FLOW STATEMENT AS ORIGINALLY STATED Question 6: Question 7: INSERT BELOW TSN INCOME STATEMENT AS ORIGINALLY STATED Radios Dec-17 Dec 18 Dec 18 Dec 19 04 Industry Dec 19 Dec 20 Stock Price EBITDA Total Debt EPS Valuation Price Emminge MA Use diluted earnings Market to Book NA Use Basic Shares (WASO) Enterprise EBITDA Profitability Operating Margin Gross Prof Margin NA Net Proft Morgan NA Return on Equity Based on Total Equity to Parent Shareholders INSERT BELOW TSN BALANCE SHEET AS ORIGINALLY STATED WA Financial Strength Current Ratio NA NA Book Dell Euty Mit Euty WC NA Entivprise Value INSERT BELOW TSN CASH FLOW STATEMENT AS ORIGINALLY STATED Question ab INSERT BELOW TSN INCOME STATEMENT AS ORIGINALLY STATED Ratios Dec-17 Door Dec 18 04 Industry Dec-19 Dec 20 Stock Price EBITDA Total Debt EPS Valuation Price Earnings NA Use diluted earning Market to Book NA Use Basic Shares (WASO) Enterprise / EBITDA Profitability Operating Marin Gross Prolt Margin NA Net Profit Margin NA Return on Equity Based on Total Equity to Parent Shareholders INSERT BELOW TSN BALANCE SHEET AS ORIGINALLY STATED NA Financial Strength Current Ratio NA NA Book Date Equity Mit Diety Meront Coverage NA Entre Value INSERT BELOW ISN CASH ROW STATEMENT AS ORIGINALLY STATED