1. Perform vertical analysis on the income statements and balance sheet information for fiscal periods 2011 and 2010. (Hint: The Excel format of the income statement and balance sheet can be downloaded from the SEC website by selecting "View Excel Documents" in the interactive data area.)
2. Perform horizontal analysis on the income statements and balance sheet information to show the dollar and percentage change between fiscal periods 2011 and 2010. (Hint: The Excel format of the income statement and balance sheet can be downloaded from the SEC website by selecting "View Excel Documents" in the interactive data area.)
3. Compute a selection of financial ratios relevant for evaluating Staples' LIQUIDITY, SOLVENCY, PROFITABILITY and MARKET INDICATORS for fiscal 2011 and 2010. For some of the ratios you may need to access fiscal 2009 balance sheet numbers which can be found on the 2010 Annual Report. (Historical stock price information for the fiscal year ends can be found on the Staples website under Investor Information.) Show calculations.