Please open the attached screenshots and use them as a guideline to complete the Microsoft Excel template. Once you are finished, upload the completed Microsoft Excel template and I will mark your answer as "most helpful."

Financial Analysis Requirement 1 Perform a vertical analysis on the income statements (Consolidated Statements of Operations) for years. Discuss your results. What benefit do you see in performing this analysis? Perform a horizo analysis of the balance sheets (Consolidated Balance Sheets) for both years. Discuss your results benefit do you see in performing this analysis? CONSOLIDATED RESULTS OF OPERATIONS (Vertical Analysis) (in thousands) 2012 2011 What benefit do you see in performing the above analysis? CONSOLIDATED STATEMENTS OF FINANCIAL POSITION (Horizontal Analysis) Change (in thousands) 2012 2011 $ Current Assets: Current Liabilities: Shareholders' Equity Discuss your results. What benefit do you see in performing the above analysis? ements of Operations) for all three nalysis? Perform a horizontal ears. Discuss your results. What 2010 Horizontal Analysis) Change % g the above analysis? Requirement 2 Look at the income statements (Consolidated Statements of Operations). Can you find the Basic EPS for each fiscal year presented? Has the Basic Earnings per Share increased or decreased each year? Why do you think the Basic EPS has been changing? Requirement 3 Determine the liquidity of Columbia Sportswear by computing the net working capital, current ratio, and quick ratio at December 31, 2012, and December 31, 2011. Has Columbia Sportswear's liquidity improved or deteriorated? Compute the return on sales and the return on equity ratio for 2012 and 2011. Use ending equity balance instead of average for 2011. Has Columbia Sportswear's profitability improved or deteriorated? Requirement 4 The market price for a share of Columbia Sportswear's common stock was $53.36 on December 31, 2012. Using this price, determine the price-earnings ratio and the dividend yield at December 31, 2012 (the dividends per share can be found on the Consolidated Statements of Stockholders' Equity). What do your results mean? Assume that the industry average PE ratio was 20 times earnings and the dividend yield was 1.8% for the industry. Evaluate your results against the industry averages.