Accounting

Acc 230 - Final Project Template Instructions 1 2 3 Use this template to complete the "Financial Analysis" assignment located on Page 708 of Chapter 12 of the "Financial Accounting" textbook by Kemp & Waybright. You may also create your own separate documents to complete this assignment. Please be sure to keep a copy for your records. A spreadsheet should be used for each requirement and is shown as worksheet tabs. Certain information is given. Please calculate trends and ratios where indicated. Acc 230 - Final Project Template Requirement #1 Columbia Sportswear Financial Analysis (Instructions: Please calculate the percentage trends in the table below): Consolidated Results of Operations (in thousands) Net Sales Cost of Sales Gross Profit Selling, general and administrative expenses Impairment of acquired intangible assets Net licensing income Income from opeartions Interest income, net Income before income tax Income tax expense Net income 2010 % 2009 % 100% $1,244,023 719,945 524,078 100% $1,317,835 750,024 567,811 534,068 444,715 430,350 7,991 103,327 1,564 104,891 (27,854) $77,037 8,399 87,762 2,088 89,850 (22,829) $67,021 24,742 5,987 118,706 7,537 126,243 (31,196) $95,047 Provide analytical comments here: Consolidated Statements of Financial Position (Instructions: Please calculate net changes in the table below): Change (in thousands) Current Assets: Cash and cash equivalents Short-term investments Accounts receivable, net Inventories Deferred income taxes Prepaid expenses and other current assets Total current assets Property, plan and equipment (net) Intangible assets Goodwill Other non-current assets Total assets Current Liabilities: Accounts payable Accrued liabilities Income taxes payable Deferred income taxes Total current liabilities Income taxes payable Deferred income taxes Other long-term liabilities Total liabilities Stockholder's Equity: Preferred stock Common stock Retained earnings Accumulated other comprehensive income Total shareholders' equity Total liabilities and shareholders equity Provide analytical comments here: 2008 $1,483,524 854,120 629,404 2010 $234,257 68,812 300,181 314,298 45,091 28,241 2009 $ % $386,664 22,759 226,548 222,161 31,550 32,030 990,880 921,712 221,813 235,440 40,423 27,127 14,470 12,659 27,168 15,945 $1,294,754 $1,212,883 - $130,626 102,810 16,037 2,153 251,626 19,698 21,456 292,780 $102,494 67,312 6,884 2,597 179,287 19,830 1,494 15,044 215,655 5,052 950,207 836 952,948 46,715 1,001,974 43,444 997,228 - $1,294,754 $1,212,883 - - % 100% Acc 230 - Final Project Template Requirement #2 Please answer the questions asked in the textbook for requirement #2 in the lines below: Acc 230 - Final Project Template Requirement #3 Please compute the ratios for requirement #3 here and show your calculations. Answer the questions asked in the assignment: Acc 230 - Final Project Template Requirement #4 Please compute the ratios for requirement #4 here and show your calculations. Answer the questions asked in the assignment