Business Policy & Strategy
Assignment Requirements:
-Excel or Word Spreadsheet
-Must Show Formulas
-Based on the information shown in Walt Disney's Income Statement and Balance Sheet (found on pages 26 and 27 in the Cohesion Case) calculate all the fiscal year 2010 ratios shown in Table 4-4 of the text (see pages 110 "?o 111). Don't forget to calculate the four growth ratios shown at the end of the table. As Disney's financial statements show data for three years, calculate the one-year growth ratios (from 2009 to 2010) for sales, net income, earnings per share, and dividends per share. Before attempting this assignment, you are strongly encouraged to review and study the PowerPoint slides and the notes for this chapter. There may be some ratios for which you do not have enough information to calculate the ratios. In these cases, instead of calculating the ratios, explain why you are unable to calculate the ratio (i.e., what required information is not included in the financial statements. Finally, indicate the following when you calculate the ratios: (1) the formula used, (2) the numbers and formula used in the calculation, (3) the answer or calculation and (4) a brief analysis of each ratio and what it means. You may use Excel or Word to complete this assignment: whichever is more convenient for you.
Website to text book showing financial statements required for assignment:
Assignment Requirements:
-Excel or Word Spreadsheet
-Must Show Formulas
-Based on the information shown in Walt Disney's Income Statement and Balance Sheet (found on pages 26 and 27 in the Cohesion Case) calculate all the fiscal year 2010 ratios shown in Table 4-4 of the text (see pages 110 "?o 111). Don't forget to calculate the four growth ratios shown at the end of the table. As Disney's financial statements show data for three years, calculate the one-year growth ratios (from 2009 to 2010) for sales, net income, earnings per share, and dividends per share. Before attempting this assignment, you are strongly encouraged to review and study the PowerPoint slides and the notes for this chapter. There may be some ratios for which you do not have enough information to calculate the ratios. In these cases, instead of calculating the ratios, explain why you are unable to calculate the ratio (i.e., what required information is not included in the financial statements. Finally, indicate the following when you calculate the ratios: (1) the formula used, (2) the numbers and formula used in the calculation, (3) the answer or calculation and (4) a brief analysis of each ratio and what it means. You may use Excel or Word to complete this assignment: whichever is more convenient for you.
Website to text book showing financial statements required for assignment:
0 comments:
Post a Comment