Published financial statements provide information to a diverse group of users, such as stockholders, potential stockholders, creditors, and managers. Financial statement analysis is the process of interpreting and evaluating financial statements by using the data in the statements to compare current period results with previous periods and to investigate relationships within and among the various components of the statements.

This project requires students to obtain a company's annual report, find specific information from the report, and calculate selected ratios for the company. This semester we will study the 2017 annual report of Columbia Sportswear Company.

PLEASE READ ALL OF THE INSTRUCTIONS CAREFULLY BEFORE BEGINNING THE PROJECT.

Project overview and brief instructions:

1. Obtain the Fiscal Year 2018 financial statements for Columbia Sportswear.
2. Print out these instructions, and answer the questions below about the company.
3. AFTER you have answered the questions, open and complete the online quiz. Your
4. project grade is determined by the eCampus quiz. This quiz is timed; DO NOT OPEN the online quiz until you have answered the questions on paper. (See details below)

Detailed instructions:

1. Obtain the Fiscal Year 2018 financial statements for Columbia Sportswear.

Publicly traded companies are required to make regular financial reports to the Securities and Exchange Commission. The required annual report is known as the 10-K, and the SEC makes these 10K reports available on their website. Many publicly traded companies also post their financial results on the company's web site; it may be included as part of the company's annual report to investors.

Columbia's statements can be found on both the SEC website and the company's website. You can obtain Columbia's statements from either site:

(a) Using the SEC's website

To find the statements on the SEC website, go to www.sec.gov. At the top right of the page, click on "company filings"; under company name type in Columbia Sportswear. When the company's filings list appears, click on the 10-K. The statements are found as Item 8 of the 10-K report.

(b) Go to the company's own website at www.Columbia.com. At the bottom of the page, click "Investor relations". Then click "financial information" and you'll see the latest annual report (the 10-K).

The entire 10-K is more than 100 pages long! You do not need to print out the entire 10-K or annual report. All of the questions can be answered by reading the statements online. However, for those who prefer to work from a hard copy of the statements, I suggest you print

only the four financial statements since the answers to most of the questions can be found there.

2. Answer the questions below using information found in the Fiscal Year 2018 statements.

3. Complete the on-line quiz.

The online quiz consists of a selection of the questions below. Once you have answered all of the questions and checked your work, you are ready to submit your work for grading on-line, using the project quiz. The project quiz is similar to our weekly homework assignments, but there are two important differences

a. The project quiz is TIMED. Once opened, you will have only one hour to answer the questions.

Again, DO NOT OPEN the online quiz until you have answered the questions, checked your work, and are ready to submit. The one hour time limit is not a problem for students who have answered the questions on paper first.

b. Students will be able to check their work before submitting the project quiz, but the answers will not be publicly posted on the bulletin board with the homework quiz solutions. Instead, answers will be available at the 209 help desk and in the instructor's office for those students who have completed the question packet.

Students may work with classmates in completing this project, but simply giving out answers to others who have not participated is considered a violation of the honor code!

The project is due on Monday, August 5th at midnight. Students are to complete and submit the online quiz in eCampus. NO QUIZ SUBMISSIONS WILL BE ACCEPTED AFTER THE MIDNIGHT AUGUST 5th DEADLINE!

COLUMBIA SPORTSWEAR COMPANY - FINANCIAL STATEMENT ANALYSIS QUESTIONS

Note: Columbia's financial statements show amounts in thousands, except per share amounts. The questions and answers here and in the project quiz will follow the same format. (In other words, you do NOT need to add 3 zeros to all of your answers.)

1. In what state is Columbia incorporated? Where are the company's principal offices?
2. Based on Item 1 of the 10-K, briefly describe Columbia's business.
3. What are Columbia's four geographic segments?
4. Statements of publically traded companies must be audited, and the audit report, or "Report of the Independent Registered Public Accounting Firm", is included as part of the annual report. Columbia includes the audit report right before the financial statements. Who is the company's auditor? To whom is the auditor's report addressed?
5. According to the first paragraph of the auditor's report, who is responsible for the information found in the financial reports? What is the auditor's responsibility?
6. When does Columbia's fiscal year end?
7. Assets: On the balance sheet, what amount does Columbia report for (a) current assets?
8. (b) total assets?
9. Current assets make up what percentage of total assets?
10. What is the largest current asset shown on the balance sheet?
11. What is the largest non-current asset shown on the balance sheet?
12. Columbia's Fiscal Year 2018 balance sheet shows Accounts Receivable of $449,382, which represents the amount the company actually expects to collect from its customers. What is the company's estimate of the amount of receivables that will NOT be collected? (That is, what is the allowance for uncollectible accounts? See Note 5)
13. Columbia's Fiscal Year 2018 balance sheet shows Inventories of $521,827. According to Note 2, what inventory cost flow method does Columbia use to report inventory cost?
14. What depreciation method does Columbia use for financial reporting for its Property, plant, and equipment? (See Note 2)
15. The balance sheet reports Property, Plant, and Equipment, net of $291,596. According to Note 7, what is the largest component of PP&E?
16. How much is the company's accumulated depreciation as of December 31, 2018?
17. Liabilities: On the balance sheet, what amount does Columbia report as (a) current liabilities?
18. (b) total liabilities?
19. Current liabilities make up what percentage of total liabilities?
20. What is the largest current liability shown on the balance sheet?
21. What is the largest non-current liability shown on the balance sheet?
22. Is Columbia authorized to issue preferred stock? How many shares are authorized?
23. have been issued?
24. What is the par value of the company's common stock?
25. As of December 31, 2018, how many shares of common stock are (a) authorized?
26. (b) issued?
27. (c) outstanding?
28. (d) held in the treasury?
29. What is the average issue price per share for the common stock?
30. What is Columbia Sportswear Company shareholders' equity as of December 31, 2018? How much is total equity?
31. What accounts for the difference between Columbia Sportswear Company shareholders' equity and total equity?
32. What specific name does Columbia use for its income statement?
33. How much net sales revenue did Columbia report for 2018? Did this amount increase or decrease from the 2017 amount?
34. According to Note 2, when does Columbia recognize sales revenue?
35. What is Columbia's largest expense reported on the income statement?
36. On its income statement, Columbia reports income tax expense of $85,796 for 2018. However, companies often actually pay a different amount for taxes than is reported. Sometimes there are differences between accounting income determined using GAAP and taxable income, which is determined using tax rules. Sometimes there are differences in the timing of recognition of revenues and expenses. Either of these can lead to a company's reporting one amount as tax expense and actually paying a different amount.
37. Using information provided at the bottom of the Statement of Cash Flows, how much did Columbia actually pay (in cash) for income taxes in 2018?
38. On the income statement, companies report their net income, and also provide information about net income on a per share basis. What was Columbia's basic earnings per common share for 2018? Did this amount increase or decrease from the previous year? By how much?
39. What was Columbia's diluted earnings per common share for 2018? Did this amount increase or decrease from last year? By how much?
40. Did Columbia pay dividends during 2018? If so, how much in total? Per share?

28. The statement of cash flows shows sources and uses of cash in three categories: operating, investing, and financing activities. For Columbia, which category(ies) reported net cash provided? Which reported net cash used?

1. On the statement of cash flows, which investing activity caused the largest cash inflow during 2018? The largest cash outflow?
2. On the statement of cash flows, which financing activity caused the largest cash inflow of cash during 2018? The largest cash outflow?

Companies use ratios to express relationships between items on the financial statements; these ratios can identify or highlight important financial results. For the next questions, you are asked to compute various ratios for Columbia. Some of these ratios have already been discussed in class; others will be new to you. Formulas are provided to help you with these calculations.

Note that whenever a formula asks for an average amount (such as average assets), add

the beginning of the year amount (which is the same as the ending amount last year) and the end of the year amount, then divide the total by 2.

Calculate the following ratios for Columbia for 2018, or as of December 31, 2018:

1. working capital
2. current ratio
3. acid test ratio
4. accounts receivable turnover
5. days' sales in receivables
6. inventory turnover

current assets - current liabilities

current assets current liabilities

cash + short-term investments + receivables current liabilities

net sales average AR

average AR net sales/365

cost of goods sold average inventory

36. return on common net income - preferred dividends

equity

average total equity (see Notes 1 and 2 below)

1. # times interest earned
2. debt to equity ratio
3. gross profit percentage

net income + interest exp + income tax exp interest expense

total liabilities

total stockholders' equity

gross profit sales

Note 1: Use Net income, not "net income attributable to Columbia Sportswear Company" Note 2: Since Columbia has no preferred stock issued, there are no preferred dividends.