Hi Tutor,

Please find the attached document. I think you can choose the company for Coca-Cola, because the company information is everywhere.

Page 0 of 42 Your Name Here Your Company Name Here Annual Report Workbook Getting under the hood of an Annual Report and knowing what's inside by Donald Bittar Copyright DA Bittar 2009, 2010, 2012 Page 1 of 42 Your Name Here Your Company Name Here Introduction You can use this workbook for analyzing many companies and saving your analysis for each one, like many professionals. Just like them, over time, you can compare a company's actual performance to your analysis and predictions. Saving your analysis sheets can help sharpen you analytical skills. The questions in the workbook are numbered the same way as they are in the book, 'Getting Under the Hood of an Annual Report'. As there are no questions in the first chapter of the book, the workbook starts with Chapter 2. It will make it easier for you to relate the questions in the workbook to those in the book. Your input to the workbook will appear in a dark green font while the questions appear in blue. The different font colors can make it easier for you to see your work. You'll need to do some number crunching to complete your annual report analysis. The Big Calculating Tool, located on your CD, can save you a great deal of time and make the number crunching nearly painless. Every ratio and calculation for the book is included in the Big Calculating Tool. You'll have more time for analysis if you use the Big Calculating Tool. Copyright DA Bittar 2009, 2010, 2012 Page 2 of 42 Your Name Here Your Company Name Here Table of Contents Questions for Chapter 2........................................................................................................... 4 Question 2.0 - What do you want to learn about company and why?............................................4 Question 2.1 - Fundamental Information Set For Your Company...................................................4 Question 2.2 - The Marketplace Context........................................................................................ 5 Question 2.3 - Challenges and Success for Your Company...........................................................6 Questions for Chapter 3........................................................................................................... 8 Question 3.1 - What is Management saying about your company?...............................................8 Question 3.2 - What did the Chairman say?..................................................................................9 Question 3.3 - Internal Controls and Auditors..............................................................................10 Questions for Chapter 4.........................................................................................................11 Question 4.0 - What is your company's fiscal year.......................................................................11 Question 4.1 - Current Assets...................................................................................................... 11 Question 4.2 - Property, Plant and Equipment.............................................................................11 Question 4.3 - How good is the Goodwill.....................................................................................12 Question 4.4 - Current Liabilities.................................................................................................. 13 Question 4.5 - How much stock is there and who owns it?..........................................................13 Question 4.6 - Who owns the stock?............................................................................................ 13 Question 4.7 - First look at the company's strength.....................................................................14 Question 4.8 - Significant changes in the balance sheet..............................................................15 Question 4.9 - Significant changes in the cash account...............................................................15 Question 4.10 - Debt to equity and the competition.....................................................................15 Question 4.11 - 'Income statement'. What's in a name?.............................................................16 Question 4.12 - How does your company report the core business?...........................................16 Question 4.13 - How does your company describe its business income?....................................17 Question 4.14 - Irregular items. Good or Bad?...........................................................................17 Question 4.15 - The big questions. Are they makin' money? Are they lookin' good?..................18 Question 4.16 - Which trend is important and why?.....................................................................19 Question 4.17 - How strong is your company's cash position?....................................................19 Question 4.18 - How well can your company pay its bills?...........................................................20 Question 4.19 - How leveraged is your company?.......................................................................21 Question 4.20 - How well does your company invest in its future?..............................................22 Question 4.21 - Capital and Treasury Stock.................................................................................22 Question 4.21 -Basic information about your company not found on the financial statement?....23 Question 4.22 -Other significant information about your company not found on the financial statement?.................................................................................................................................... 23 Questions for Chapter 5.........................................................................................................25 Question 5.1 - Working Capital Balance......................................................................................25 Question 5.2 - Acid Test or Quick Ratio........................................................................................ 25 Question 5.3 - Current Ratio........................................................................................................ 26 Question 5.4 - Cash Ratio............................................................................................................ 27 Question 5.5 - Return on Sales Ratio........................................................................................... 28 Question 5.6 - Return on Equity Ratio..........................................................................................28 Question 5.7 - Return on Assets Ratio......................................................................................... 29 Question 5.8 - Asset Turn Ratio................................................................................................... 30 Question 5.9 - Gross Profit Margin Ratio.....................................................................................30 Question 5.10 - Inventory Turnover Ratio....................................................................................31 Question 5.11 - Days in Inventory Ratio.......................................................................................32 Question 5.12 - Accounts Receivable Turnover Ratio..................................................................33 Question 5.13 - Average Collection Period..................................................................................33 Copyright DA Bittar 2009, 2010, 2012 Page 3 of 42 Your Name Here Your Company Name Here Question 5.14 - Accounts Payable Turnover Ratio.......................................................................34 Question 5.15 - Net Working Capital Turnover Ratio...................................................................35 Question 5.16 - Debt to Equity Ratio............................................................................................36 Question 5.17 - Debt to Asset Ratio............................................................................................. 37 Question 5.18 - Gearing Ratio or Long Term Debt to Shareholders' Equity Ratio........................37 Question 5.19 - Interest Coverage Ratio or Debt Service Ratio...................................................38 Question 5.20 -Earnings per Share.............................................................................................. 39 Question 5.21 - Price/Earnings Ratio........................................................................................... 40 Question 5.22 -Dividend per Share..............................................................................................40 Question 5.23 - Dividend Payout Ratio........................................................................................41 Questions for Chapter 6.........................................................................................................43 Question 6.0 - Calculate the Altman Z-Score...............................................................................43 Question 6.1 - What did you learn about your company...............................................................43 Question 6.2 - Would you buy, sell, hold or stay away..................................................................43 Copyright DA Bittar 2009, 2010, 2012 Page 4 of 42 Your Name Here Your Company Name Here Questions for Chapter 2 Question 2.0 - What do you want to learn about company and why? 2.0 - What You Want To Learn About the Company and Why? Priority What do you want to learn? Why do you want to learn it? A B C D Question 2.1 - Fundamental Information Set For Your Company The answer to the following questions may be found in either the Annual Report to Stockholders or on the SEC Form 10-K. It may also be necessary for you to use other sources. To fully answer the questions, you must identify the source for your information and also include the answer. If the question is not applicable to your company, place \"NA\" as the answer. To identify the source use \"AR\" for Annual Report to Stockholders and \"10K\" for the SEC Form 10-K. If something else, use \"Other\" and include the identification at the end of your answer. 2.1 - Fundamental Information Set For Your Company A B C D E F G H I J K L Question What is the official company name? What is Company headquarters address? What is the Executive Office telephone number? What is the Investor Relations telephone number? What is the official company website? What is the fiscal year ending date? State of incorporation What government agency, other than the SEC, has a significant impact on your Company? What is the trading symbol for your Company's common stock? Which stock exchange lists the common stock for your Company? What is the name of the stock transfer agent for your Company? What is the Par Value for the common shares of your Company? Source Answer Copyright DA Bittar 2009, 2010, 2012 Page 5 of 42 Your Name Here Your Company Name Here M N O P Q R S T U What is the number of common shares outstanding? In the past 3 years what is the highest trading price for the common stock for your company. In the past 3 years what is the lowest trading price for the common stock for your company? How many members are on the Board of Directors? How many Board Members are present or past employees of the Company? How many are Board Members are from outside your Company? Which companies or institutions do the outside Board Members represent? How many subsidiaries are directly or indirectly controlled by your Company? How many subsidiaries have jurisdictions outside the United States? Question 2.2 - The Marketplace Context If analyzing a company's performance were only about the numbers, predicting the performance of a company would be easy. Performance, success and failure are outcomes that are affected by the marketplace. Your company does not exist inside a vacuum. It lives alongside other companies actively struggling to protect existing customer relationships and working to create new customers. Often companies will compete for the same customers. For some companies the competitors are easily identifiable. Your company's SIC code can help you identify its competitors. They will have the same SIC code. Other companies compete indirectly with alternative products or technologies making it difficult to identify competitors. Consider FedEx with both direct and indirect competitors. The answer to the following questions may be found in either the Annual Report to Stockholders or on the SEC Form 10-K. It may also be necessary for you to use other sources. To fully answer the questions, you must identify the source for your information and also include the answer. If the question is not applicable to your company, place \"NA\" as the answer. To identify the source use \"AR\" for Annual Report to Stockholders and \"10K\" for the SEC Form 10-K. If something else, use \"Other\" and include the identification at the end of your answer. 2.2 - The Marketplace Context A B C D E F G H Question What is the Standard Industrial Classification and the SIC Code for your company? List all that may apply? What is the company's primary product, product group or business segment? Is there a single customer that accounts for more than 10% of total net sales? What is the major customer profile for your company? Is there a competitor larger than your Company? Which company is the most significant competitor for your Company? What is the country of origin for this competitor? During the past 2 years, has your Company launched a significant new product or Source Answer Copyright DA Bittar 2009, 2010, 2012 Page 6 of 42 Your Name Here Your Company Name Here I J K service? If yes, what is the product or service? During the past 2 years, has your company entered a new market? If yes, what is the market and where is located? During the past 2 years, has your Company launched a new technology? If yes, what is it? What are the technological issues for your Company? How are they described? Question 2.3 - Challenges and Success for Your Company Review the Annual Report for Stockholders and the Form 10-K for your company. Using the above list of Marketplace Issues, identify the marketplace issues affecting your company. Your company is large enough to be newsworthy. Most likely, the issue you identified in the Annual Report for Stockholders or the Form 10-K might be reported elsewhere. With research apart from the Annual Report for Stockholders and the Form 10-K you may be able to find additional information about the issue. There are several print media research sources available in the library: 1. Wall Street Journal 2. New York Times 3. Barron's 4. Moody's Complete Corporate Index 5. Standard and Poor's Industry Guide The Internet makes a vast universe of material available to you. It is fast and convenient. The chances are remote that you will not be able to discover sufficient information to satisfy your needs. Use your favorite search tool and start digging. Your company is a good place to start. Their website may have relevant press releases about the issue. Some of the officers may have made speeches or written articles about it. Describe the significant marketplace issues identified in the Annual Report for Stockholders and the Form 10-K for your company. For each issue: 1. Include the marketplace category. 2. The description of the issue as it appeared in the Annual Report for Stockholders and the Form 10-K for your company. 3. Your interpretation of its significance to the company, what the importance is to the company and if management is capable of creating a positive outcome. 2.3 - Challenges and Success for Your Company Marketplace Issue Description of the Issue Significance A B C D Copyright DA Bittar 2009, 2010, 2012 Page 7 of 42 Your Name Here Your Company Name Here Questions for Chapter 3 Question 3.1 - What is Management saying about your company? When reading the Management's Discussion and Analysis of Operations and Financial Condition (MD&A) asking each of the following questions will help to identify a significant fact that will help you understand your annual report. Pick an item reported in the MD&A which you believe to be significant and ask yourself: What is it? When did it occur? Where did the action take place? Who was involved? Why did this happen? How did it happen Answer as much of the five Ws and one H as you can from the annual report. Next, use the internet and other printed media sources to get additional information about the item. From the combined sources you should be able gather a reasonably complete assessment of the item. Identify the source of your outside material. Use the following template to complete your answers. 3.1.1 - What is Management saying about your company? Copy the item from the MD&A and paste it below. 3.1.2 Five Ws and One H A In your own words describe the item? B When did it occur? C Where did the action take place? D Who was involved? E Why did this happen? Form 10-K MD&A Outside Source Material Paste information from the 10K in this column. Paste information from outside sources in this column. Include the source link. Copyright DA Bittar 2009, 2010, 2012 Page 8 of 42 Your Name Here Your Company Name Here F How did it happen? G In your opinion, what do you believe is the importance of this item to your company? How will it impact the company? Question 3.2 - What did the Chairman say? Read the Chairman's Message in the Annual Report to Stockholders for your company. You might also find the Chairman's message in the company's annual proxy statement. Identify the issues and events outlined in the Message. Highlighting the text of the issues and events can help assess their significance and prioritize them. 3.2.1 - What did the Chairman say? A In your opinion, what is the most significant issue in the Message? B Quote the Chairman's description of the issue? C What is the significance of the issue for the company? D Did the Message include a solution for the issue? If yes, what was it? E Did the solution instill confidence in you? F If yes, why? If no, why? The Chairman's Message is read by a wide and diverse constituency. Select a group of constituents excluding stockholders, investors and financial analyst. Write your opinion of how you believe they will react to the Chairman's message. Select one from the following constituents. Creditors Regulatory agencies Competitors Employees Local and state governments Suppliers Salespeople Foreign governments Vendors Franchisees Environmental activists Distributors Unions Consumer advocates Customers Human rights advocates Press and media Regulatory agencies Copyright DA Bittar 2009, 2010, 2012 Page 9 of 42 Your Name Here Your Company Name Here 3.2.2 - What did the Chairman say? A Constituent's name B With respect to the company, is the constituency supportive, neutral or adversarial? C What issue in the Chairman's message will cause the greatest reaction? D How do you believe the constituency will react to the issue? E Why do you believe they will react that way? F Will their reaction create a positive or negative impact on the Company? What will be the impact and why? Question 3.3 - Internal Controls and Auditors Information about the company's compliance with SOX can be found in SEC Form 10-K. The section called Controls and Procedures includes information about how the company is complying with the SOX reporting requirements. Generally preceding the section on Controls and Procedures is the Report of Independent Registered Public Accounting Firm. It will also contain information about internal controls and auditors. Review these sections of your company's SEC Form 10-K and answer the following questions. 3.3 - Internal Controls and Auditors A Who in your company is responsible for the internal disclosure controls and procedures? B Who are members of the Audit Committee? C What is the name of the independent auditor for your company? D What was the auditor's opinion of the consolidated financial statement? E What was the auditor's opinion of the internal disclosure controls and procedures? Copyright DA Bittar 2009, 2010, 2012 Page 10 of 42 Your Name Here Your Company Name Here Questions for Chapter 4 Question 4.0 - What is your company's fiscal year 4.0 - What is your company's fiscal year? A When does your company's fiscal year end? B In your opinion, why did your company select this date to end its fiscal year? C Do competitors use the same fiscal year as your company? Question 4.1 - Current Assets Some companies have current assets other than Cash, Short Term Investments, Accounts Receivables and Inventories. Locate the Current Asset section of the Balance Sheet for your company and review the current asset categories. What categories of current assets, other than Cash, Short Term Investments, Accounts Receivables and Inventories are reported by your company? What is their significance to the company? Mark your answer \"NA\" if your company does not report current asset categories other than Cash, Short Term Investments, Accounts Receivables and Inventories. 4.1 - Current Assets Current Asset Category Significance A B C D Question 4.2 - Property, Plant and Equipment Some companies have categories for Property, Plant and Equipment other than land, buildings, factories, furniture and equipment. What categories of Property Plant and Equipment other than land, buildings, factories, furniture and equipment are reported by your company? What is it their significance to the company? Mark your answer \"NA\" if your company does not report categories of Property Plant and Equipment other than land, buildings, factories, furniture and equipment. Copyright DA Bittar 2009, 2010, 2012 Page 11 of 42 Your Name Here Your Company Name Here 4.2 - Property, Plant and Equipment? Property Plant and Equipment Category Significance A B C D Question 4.3 - How good is the Goodwill Goodwill is a balance sheet item reported by many companies. The details of the Goodwill are generally described in the Notes to the Financial Statement. Goodwill should reflect the strategic future value of an acquisition. Mark your answer \"NA\" if your company does not report Goodwill. 4.3 - How good is the Goodwill? A Does your company report Goodwill? B What is the value of the Goodwill? C What is the ratio of Goodwill to Total Assets (Goodwill Total Assets)? D In your opinion why is the ratio of Goodwill to Total Assets significant or insignificant? E What was the source of the Goodwill? F In your opinion why was the acquisition justified or not justified? Question 4.4 - Current Liabilities Some companies have current liabilities other than Accounts Payable, Accrued Salaries and Wages and Accrued Income Tax. Locate the Current Liabilities section of the Balance Sheet for your company and review the current liability categories. What categories of current liabilities other than Accounts Payable, Accrued Salaries and Wages and Accrued Income Tax are reported by your company? What is it their significance to the company? Mark your answer \"NA\" if your company does not report current liability categories other than Accounts Payable, Accrued Salaries and Wages and Accrued Income Tax. Copyright DA Bittar 2009, 2010, 2012 Page 12 of 42 Your Name Here Your Company Name Here 4.4 - Current Liabilities Current Liability Category Significance A B C D Question 4.5 - How much stock is there and who owns it? The equity structure is a significant aspect of a public company. It can have a dramatic impact on stock price movement and appreciation. Review the SEC Form 10-K and Annual Report to Stockholders and answer the following questions. 4.5 - How much stock is there and who owns it? A What is the par value of the common stock? B What is the number of shares outstanding? C What is the current listed market price for the common stock? D What is the number of common shares authorized? E What is the number of treasury shares? Question 4.6 - Who owns the stock? Knowing who owns large blocks of stock can be useful information when assessing the investment value of a company. The percent ownership of a company will determine the amount of control a shareholder has over the company. In a democratic election, each citizen has only one vote. In a corporate election, each shareholder gets one vote for each share of stock the shareholder owns. A shareholder with 1million share gets 1million votes while a shareholder with 10 shares gets only 10 votes. In a company with 3million shares outstanding, the shareholder with 1million shares has much more influence and power than the shareholder with 10 shares. Proxy Statement The company's annual proxy statement will disclose the number of shares owned by the each member of the Board of Directors. It will also identify all shareholders who own 5% or more of the common stock and voting stock of the company. The annual proxy statement must be filed with the Securities Exchange Commission using Form DEF 14a, the definitive annual proxy statement. Copyright DA Bittar 2009, 2010, 2012 Page 13 of 42 Your Name Here Your Company Name Here 4.6 - Who owns the stock? A How many shares are held by Officers and Directors? What does this tell you? B Who is the largest stockholder? What does this tell you about the company? C What other classes of stock are outstanding? Question 4.7 - First look at the company's strength The balance sheet is a snapshot of the company financial strength. Endurance and strength are important when attempting to assess an athlete's ability and it is the same for a public company. The first place to look for a company's endurance and strength are the current and previous year balance sheets. Calculate the percent increase or decrease in each of the following balance sheet accounts. Place the percentage in parenthesis if it is negative. 4.7 - First look at the company's strength Current Year A Cash and cash equivalents B Accounts Receivable C Inventory D Property, plant & equipment E Accounts Payable F Accrued Salaries G Accrued Income Tax H Long term debt I Common Stock J Treasury Stock K Retained Earnings Previous Year Percent Change Question 4.8 - Significant changes in the balance sheet In your opinion, what were the two most significant changes in the company's balance sheet between the current year and the previous year? What were the two balance sheet accounts? Why do you believe they are significant? Copyright DA Bittar 2009, 2010, 2012 Page 14 of 42 Your Name Here Your Company Name Here 4.8 - Significant changes in the balance sheet Balance Sheet Account Why the change was significant? A B Question 4.9 - Significant changes in the cash account Cash is an important part of a business. Some people say, \"Cash is king.\" Describe the change in the Cash and Cash Equivalent account between the current year and the previous year. In your opinion why was it or was it not significant? 4.9 - Significant changes in the cash account Change in the account Why the change was significant? Question 4.10 - Debt to equity and the competition The debt load for a company may or may not be a burden. It can become a competitive detriment when the debt service it too large or when the company's ability to borrow is too retrained. It could also create vulnerability if the company's chief competitor has the borrowing strength to \"buy market share.\" What is the current ratio of total debt to total stockholder's equity for your company's most significant competitor? What is the current ratio of total debt to total stockholder's equity for your company? Has the ratio changed between the current year and the previous year for your company? Why or why not was the change in the ratio significant? 4.10 - Debt to equity and the competition A What is the current ratio of total debt to total stockholder's equity for your company's most significant competitor? B What is the current ratio of total debt to total stockholder's equity for your company? C Has the ratio changed between the current year and the previous year for your company? D Why or why not was the change in the ratio significant? Copyright DA Bittar 2009, 2010, 2012 Page 15 of 42 Your Name Here Your Company Name Here Question 4.11 - 'Income statement'. What's in a name? The income statement is a report of the company's revenue and expenses. Companies have been using the report for almost a hundred years. Over the years, accountants have adopted different names for the income statement. What name does your company use for the income statement? In your opinion why do they use it instead of 'income statement'? 4.11 - 'Income statement'. What's in a name? A What name does your company use for the 'income statement'? B In your opinion, why do they use it? Question 4.12 - How does your company report the core business? Often, a company will use terms closely related to their core business when describing the line items in the operational section of the income statement. Some standard descriptions for the line items in the operational section of the income statement are: net sales cost of goods sold gross profit general administrative expense operating income How does your company describe the items in its operating section of the income statement? Does the company use descriptions other than net sales, cost of goods sold, gross profit, general administrative expense and operating income? Why do you believe they use them? What does it tell you about the core business for the company? Mark your answer \"NA\" if your company did not unique operating section descriptions. 4.12 - How does your company report the core business? Item descriptions In your opinion, why is it used? A B C D E F What does it tell you about the core business for the company? Copyright DA Bittar 2009, 2010, 2012 Page 16 of 42 Your Name Here Your Company Name Here Question 4.13 - How does your company describe its business income? The way a company reports its income can help to better understand how the company prioritizes its revenue streams and how it perceives its core business. Does your company report revenues by business segment? What segments are individually identified? In your opinion, does the most significant business appear first? What is the most significant business segment and why? Mark your answer \"NA\" if your company did not report revenue by business segment. 4.13 - How does your company describe its business income? Revenue segment descriptions Identify the most significant segment and explain why it is the most significant. A B C D E Question 4.14 - Irregular items. Good or Bad? While the term \"irregular\" is not intended as a value judgment, these items can have a positive or negative impact on the company. Review the income statement. Select the one irregular item on the income statement or in the notes section you believe is the most significant. Mark your answer \"NA\" if your company did not report an irregular item. 4.14 - Irregular items. Good or Bad? A How many irregular items were reported individually on the income statement? B Describe the irregular item you believe is most significant? Use the description as it appears on the income statement or in the notes. C What was the dollar value of the item? D Was the item reported individually as a separate line item on the income statement or in the notes section? In your opinion, why was it reported in the notes or as a line item? E Did the item have a positive, negative or neutral impact on the company? F In your opinion, why does the item have a positive, negative or neutral impact on the company? Copyright DA Bittar 2009, 2010, 2012 Page 17 of 42 Your Name Here Your Company Name Here G In your opinion, will the impact be short term, ongoing or long term. Why? Question 4.15 - The big questions. Are they makin' money? Are they lookin' good? The answer to Benny's question \"Are they makin' money?\" cannot always be answered with a \"yes\" or a \"no\". Whether your company is \"lookin' good\" may be difficult to answered with a \"yes\" or a \"no\". Understanding the income and expense trends will generally reveal enough information to answer \"the big questions\". Review the three year period reported in your company's income statement. Describe the trend for each of the major accounts on your company's income statement. Describe the trend direction. Use phrases like: up only this year but level in previous years, consistently up, down only this year, consistently down or level for all years. Also, in your opinion is the trend positive, negative, insignificant? Your company may have different account descriptions and additional significant accounts. Modify the accounts to fit your company's income statement. Enter the amounts in millions of dollars from the SEC Form 10K, for the current year, the previous year and the next previous year. Question 4.15 - The big questions. Are they makin' money? Are they lookin' good? Accounts A Net Sales B Cost of Goods Sold C Gross Profit D Operating Expense E Operating Income (loss) F Non-operating income (loss) G Income Tax H Net Income Current Yr Previous Yr Next Previous Yr Trend Description I J K L M Question 4.16 - Which trend is important and why? The account with largest declining or increasing trend is not always the most significant trend on a company's income statement. Of the trends you identified in the previous question, which Copyright DA Bittar 2009, 2010, 2012 Page 18 of 42 Your Name Here Your Company Name Here account, in your opinion, has the most significant trend for your company? Why do you believe it to be the most significant? Trends generally do not remain constant forever. What might reverse the significant trend and how might the reversal affect your company? 4.16 - Which trend is important and why? A What account has the most significant trend for your company? B Why do you believe it is the most significant trend? C What might reverse this trend and how would the reversal impact the company? Question 4.17 - How strong is your company's cash position? Enter the amounts for each cash flow account from your company's Statement of Cash Flow. Review the three year period reported in your company's Statement of Cash Flow. Describe the trend for each of the major accounts. Describe the trend direction. Use phrases like: up only this year but level in previous years, consistently up, down only this year, consistently down or level for all years. Also, in your opinion is the trend positive, negative, insignificant? Your company may have different account descriptions and additional significant accounts. Modify the accounts to fit your company's Statement of Cash Flow. Enter the amounts in millions of dollars from the SEC Form 10K, for the current year, the previous year and the next previous year. Question 4.17 - How strong is your company's cash position? Accounts A Net cash from operating activity B Net cash from investing activity C Net cash from financing activity D Net increase (decrease) in cash and cash equivalents E Cash and cash equivalents at beginning of year F Cash and cash equivalents at end of year Current Yr Previous Yr Next Previous Yr Trend Description Question 4.18 - How well can your company pay its bills? Enter the amounts, for all three periods, for the Net Cash from Operating Activity account from your company's Statement of Cash Flow. Enter the amounts, for all three periods, for the Copyright DA Bittar 2009, 2010, 2012 Page 19 of 42 Your Name Here Your Company Name Here Current Liabilities from your company's Balance Sheet. For each period, calculate the Operating Cash Flow Ratio using the following formula. Net Cash from Operating Activity Current Liabilities Enter the amounts in millions of dollars from the SEC Form 10K, for the current year, the previous year and the next previous year. Describe the trend for each of the major accounts. Describe the trend direction. Use phrases like: up only this year but level in previous years, consistently up, down only this year, consistently down or level for all years. Also, in your opinion is the trend positive, negative, insignificant? Question 4.18 - How well can your company pay its bills Accounts A Net cash from operating activity B Current Liabilities C Operating Cash Flow Ratio Current Yr Previous Yr Next Previous Yr Trend Description The operating cash flow ratio can gauge a company's liquidity in the short term. Using cash flow as opposed to income is sometimes a better indication of liquidity simply because, as we know, cash is how bills are normally paid off. If the operating cash flow ratio is less than one, it means that the company has generated less cash over the year than it needs to pay off short term liabilities as at the year end. This may signal a need to raise money to meet liabilities. Question 4.19 - How leveraged is your company? Enter the amounts, for all three periods, for the Net Cash from Operating Activity account from your company's Statement of Cash Flow. Enter the amounts, for all three periods, for the Interest Expense from your company's Income Statement. For each period, calculate the Cash Interest Coverage Ratio using the following formula. Net Cash from Operating Activity Income Expense Enter the amounts in millions of dollars from the SEC Form 10K, for the current year, the previous year and the next previous year. Describe the trend for each of the major accounts. Describe the trend direction. Use phrases like: up only this year but level in previous years, consistently up, down only this year, consistently down or level for all years. Also, in your opinion is the trend positive, negative, insignificant? Question 4.19 - How leveraged is your company? Accounts A Net cash from operating activity B Interest Expense C Cash Interest Coverage Ratio Current Yr Previous Yr Next Previous Yr Trend Description Copyright DA Bittar 2009, 2010, 2012 Page 20 of 42 Your Name Here Your Company Name Here The Cash Interest Coverage Ratio is an indicator of how well your company will be able to make the interest payments on its entire debt load. A highly leveraged company will have a low ratio, and a company with a strong financial position will have a high ratio. Any company with a cash interest ratio less than 1.0 is in risk of potential default. The company must raise cash outside its core business to make its current interest payments. A ratio of 1.5 is generally considered the bare minimum level of comfort for any company in any industry. Interest coverage is the equivalent of a person taking the combined interest expense from their mortgage, credit cards, automobile loans and education loans and calculating the number of times they can pay it with their annual pre-tax income. For bondholders, the Cash Interest Coverage Ratio might act as a safety gauge. It might give the bondholder a sense of how far a company's earnings can fall before the company will start defaulting on its bond payments. For stockholders, the Cash Interest Coverage Ratio is important because it gives a clear picture of the short-term financial health of a business. Question 4.20 - How well does your company invest in its future? Enter the amounts, for all three periods, for the Retained Earnings per share and the Stockholders' Equity per share from your company's Statement of Stockholders' Equity. For each period, calculate the Retained Earnings Ratio using the following formula. Retained Earnings Per Share Stockholders' Equity per share Enter the amounts in dollars from the SEC Form 10K, for the current year, the previous year and the next previous year. Describe the trend for each of the major accounts. Describe the trend direction. Use phrases like: up only this year but level in previous years, consistently up, down only this year, consistently down or level for all years. Also, in your opinion is the trend positive, negative, insignificant? Dividends paid to stockholders from earnings cannot be used to help the company grow. One way for the company to grow is to invest the earnings in the core business for the company. Generally, companies will retain their earnings to invest in growth opportunities, such as buying new equipment, investing in research and development or acquisitions. Last, explain why your company is or is not investing adequately in its future. Question 4.20 - How well does your company invest in its future? Accounts A Retained Earnings per share B Stockholders' Equity per share C Retained Earnings Ratio D Is your company investing adequately in its future and why? Current Yr Previous Yr Next Previous Yr Trend Description Copyright DA Bittar 2009, 2010, 2012 Page 21 of 42 Your Name Here Your Company Name Here Question 4.21 - Capital and Treasury Stock Enter the amounts, for all three periods, for number of shares outstanding for common stock and preferred stock outstanding and treasury stock. List the addition 'classes' of capital stock which you company may have. Enter the amounts in millions of shares from the SEC Form 10K, for the current year, the previous year and the next previous year. Enter \"NA\" if your company has no preferred stock or treasury stock. Describe the trend for each of the major accounts. Describe the trend direction. Use phrases like: up only this year but level in previous years, consistently up, down only this year, consistently down or level for all years. Also, in your opinion is the trend positive, negative, insignificant? Question 4.21 - Capital and Treasury Stock Accounts A Common stock B Preferred stock C Treasury stock Current Yr Previous Yr Next Previous Yr Trend Description D E F Question 4.21 -Basic information about your company not found on the financial statement? How is information about the following items disclosed by your company in the Notes to the Financial Statement? Generally, this information can be found in Note 1. The titles may not be identical to the title in the question. Enter \"NA\" if your company has no notes for a question. Question 4.21 -Basic information about your company not found on the financial statement? A Description of Business B Consolidation C Foreign Currency D Cash and Cash Equivalents E Inventories Copyright DA Bittar 2009, 2010, 2012 Page 22 of 42 Your Name Here Your Company Name Here Question 4.22 -Other significant information about your company not found on the financial statement? How is information about the following items disclosed by your company in the Notes to the Financial Statement? The titles may not be identical to the title in the question. Enter the information disclosed about each of the items in the Notes for your company. Additionally, enter the note number in which the information was disclosed. Last, explain why you believe this disclosure is or is not significant. Enter \"NA\" if your company has no notes for a question. Question 4.22 -Other information about your company not found on the financial statement? Accounts A Discontinued Operations B Related Parties C Contingencies Note # Disclosure Importance Copyright DA Bittar 2009, 2010, 2012 Page 23 of 42 Your Name Here Your Company Name Here Questions for Chapter 5 Question 5.1 - Working Capital Balance The working capital balance compares current assets to current liabilities. It can also demonstrate the amount of liquid reserve the company has available to handle contingencies. A high working capital balance is necessary if your company might have difficulty borrowing on short notice. A low working capital balance might mean your company may have difficulty meeting its short-term obligations. Enter the amounts, for all three periods, for the Current Assets and the Current Liabilities from your company's Balance Sheet. For each period, calculate the Working Capital Balance using the following formula. Current Assets - Current Liabilities Enter the amounts in millions of dollars from the SEC Form 10K, for the current year, the previous year and the next previous year. Describe the trend direction for the Working Capital Balance. Use phrases like: up only this year but level in previous years, consistently up, down only this year, consistently down or level for all years. Also, in your opinion is the trend positive, negative, insignificant? Last, in your opinion, explain why the Working Capital Balance for your company is or is not adequate for its future. Question 5.1 - Working Capital Balance Accounts A Current Assets B Current Liabilities C Working Capital Balance D Why is or is not the Working Capital Balance adequate for your company? Current Yr Previous Yr Next Previous Yr Trend Description Question 5.2 - Acid Test or Quick Ratio This ratio will help you measure the degree of liquidity for your company. The quick ratio compares the company's cash, cash equivalents and accounts receivable to the current liabilities. The primary difference between the current ratio and the quick ratio is the quick ratio does not include inventory and prepaid expenses in the calculation. The company's quick ratio should be lower than its current ratio. It is a severe test of liquidity. Copyright DA Bittar 2009, 2010, 2012 Page 24 of 42 Your Name Here Your Company Name Here Enter the amounts, for all three periods, for the Cash, Accounts Receivable, Short-term investments and the Current Liabilities from your company's Balance Sheet. For each period, calculate the Acid Test Ratio using the following formula. (Cash + Accounts Receivable + Short-term Investments) Current Liabilities Enter the amounts in millions of dollars from the SEC Form 10K, for the current year, the previous year and the next previous year. Describe the trend direction for the Acid Test Ratio. Use phrases like: up only this year but level in previous years, consistently up, down only this year, consistently down or level for all years. Also, in your opinion is the trend positive, negative, insignificant? Last, in your opinion, explain why the Acid Test Ratio for your company is or is not adequate for its future. Question 5.2 - Acid Test or Quick Ratio Accounts A Cash B Accounts Receivable Current Yr Previous Yr Next Previous Yr Industry Ratio Short term investments Current Liabilities C Acid Test Ratio D Why is or is not the Acid Test Ratio adequate for your company? E Acid Test trend Description Question 5.3 - Current Ratio This is another ratio to help you measure the degree of liquidity for your company. The Current Ratio compares the company's current assets to its current liabilities. Enter the amounts, for all three periods, for the Current Assets and the Current Liabilities from your company's Balance Sheet. For each period, calculate the Current Ratio using the following formula. Current Assets Current Liabilities Enter the amounts in millions of dollars from the SEC Form 10K, for the current year, the previous year and the next previous year. Describe the trend direction for the Current Ratio. Use phrases like: up only this year but level in previous years, consistently up, down only this year, consistently down or level for all years. Also, in your opinion is the trend positive, negative, insignificant? Last, in your opinion, explain why the Current Ratio for your company is or is not adequate for its future. Copyright DA Bittar 2009, 2010, 2012 Page 25 of 42 Your Name Here Your Company Name Here Question 5.3 - Current Ratio Accounts A Current Assets B Current Liabilities C Current Ratio D Why is or is not the Current Ratio adequate for your company? E Current Ratio trend description Current Yr Previous Yr Next Previous Yr Industry Ratio Question 5.4 - Cash Ratio This is ratio to help you measure the degree of short term liquidity for your company. The Cash Ratio compares the company's cash to its current liabilities. The ratio is particularly useful if the company's receivables and its inventory are pledged or if there may be liquidity problems with inventory and receivables. Enter the amounts, for all three periods, for the Cash and the Current Liabilities from your company's Balance Sheet. For each period, calculate the Cash Ratio using the following formula. Cash Current Liabilities Enter the amounts in millions of dollars from the SEC Form 10K, for the current year, the previous year and the next previous year. Describe the trend direction for the Cash Ratio. Use phrases like: up only this year but level in previous years, consistently up, down only this year, consistently down or level for all years. Also, in your opinion is the trend positive, negative, insignificant? Last, in your opinion, explain why the Cash Ratio for your company is or is not adequate for its future. Question 5.4 - Cash Ratio Accounts A Cash B Current Liabilities C Cash Ratio D Why is or is not the Cash Ratio adequate for your company? E Cash Ratio trend description Current Yr Previous Yr Next Previous Yr Industry Ratio Copyright DA Bittar 2009, 2010, 2012 Page 26 of 42 Your Name Here Your Company Name Here Question 5.5 - Return on Sales Ratio This ratio will help you measure the net income generated by each dollar of sales. It is an effective gauge for determining the rate of profit returned on sales. The Return on Sales Ratio can be useful for estimating how well the company can handle price wars, sales declines and rising costs. Enter the amounts, for all three periods, for the Net Income and the Net Sales from your company's Income Statement. For each period, calculate the Return on Sales Ratio using the following formula. Net Income Net Sales Enter the amounts in millions of dollars from the SEC Form 10K, for the current year, the previous year and the next previous year. Describe the trend direction for the Return on Sales Ratio. Use phrases like: up only this year but level in previous years, consistently up, down only this year, consistently down or level for all years. Also, in your opinion is the trend positive, negative, insignificant? Last, in your opinion, explain why the Return on Sales Ratio for your company is or is not adequate for its future. Question 5.5 - Return on Sales Ratio Accounts A Net Income B Net Sales C Return on Sales Ratio D Why is or is not the Return on Sales Ratio adequate for your company? Current Yr Previous Yr Next Previous Yr Trend Description Question 5.6 - Return on Equity Ratio This ratio is widely used by many investors. It is an effective measure for the income earned on the shareholder's investment in the business. The Return on Equity Ratio can be useful for making a value judgment on how well management is create profits with the investment shareholders have in the company. The higher the Return on Equity Ratio, the better it is. Enter the amounts, for all three periods, for the Net Income from your company's Income Statement and Stockholders' Equity from the balance sheet. For each period, calculate the Return on Equity Ratio using the following formula. Net Income Stockholders' Equity Enter the amounts in millions of dollars from the SEC Form 10K, for the current year, the previous year and the next previous year. Describe the trend direction for the Return on Equity Ratio. Use phrases like: up only this year but level in previous years, consistently up, down only this year, consistently down or level for all years. Also, in your opinion is the trend positive, negative, insignificant? Copyright DA Bittar 2009, 2010, 2012 Page 27 of 42 Your Name Here Your Company Name Here Last, in your opinion, explain why the Return on Equity Ratio for your company is or is not adequate for its future. Question 5.6 - Return on Equity Ratio Accounts A Net Income B Stockholders' Equity C Return on Equity Ratio D Why is or is not the Return on Equity Ratio adequate for your company? Current Yr Previous Yr Next Previous Yr Trend Description Question 5.7 - Return on Assets Ratio This ratio is used to measure how well a company is turning its assets into profit. It may sound like the total assets turnover ratio but it is different. The total assets turnover ratio measures how effectively a company's assets generate revenue. It is a useful tool to measure how well management is turns the company's assets into profit. The higher the value for the Return on Assets Ratio, the better the company is performing. Enter the amounts, for all three periods, for the Net Income from your company's Income Statement and Total Assets from the balance sheet. For each period, calculate the Return on Assets Ratio using the following formula. Net Income Total Assets Enter the amounts in millions of dollars from the SEC Form 10K, for the current year, the previous year and the next previous year. Describe the trend direction for the Return on Assets Ratio. Use phrases like: up only this year but level in previous years, consistently up, down only this year, consistently down or level for all years. Also, in your opinion is the trend positive, negative, insignificant? Last, in your opinion, explain why the Return on Assets Ratio for your company is or is not adequate for its future. Question 5.7 - Return on Assets Ratio Accounts A Net Income B Total Assets C Return on Assets Ratio D Why is or is not the Return on Assets Ratio adequate for your company? E Return on Asset Ratio trend description Current Yr Previous Yr Next Previous Yr Industry Ratio Copyright DA Bittar 2009, 2010, 2012 Page 28 of 42 Your Name Here Your Company Name Here Question 5.8 - Asset Turn Ratio This ratio is used to measure how well a company is using its assets to create revenues. The higher the value for the Asset Turn Ratio, the better the company is performing. Enter the amounts, for all three periods, for the Net Sales from your company's Income Statement and Total Assets from the balance sheet. For each period, calculate the Asset Turn Ratio using the following formula. Net Sales Total Assets Enter the amounts in millions of dollars from the SEC Form 10K, for the current year, the previous year and the next previous year. Describe the trend direction for the Asset Turn Ratio. Use phrases like: up only this year but level in previous years, consistently up, down only this year, consistently down or level for all years. Also, in your opinion is the trend positive, negative, insignificant? Last, in your opinion, explain why the Asset Turn Ratio for your company is or is not adequate for its future. Question 5.8 - Asset Turnover Ratio Accounts A Net Sales B Total Assets C Asset Turn Ratio D Why is or is not the Assets Turn Ratio adequate for your company? E Asset Turnover Ratio trend description Current Yr Previous Yr Next Previous Yr Industry Ratio Question 5.9 - Gross Profit Margin Ratio This ratio is used to measure the relationship between net sales revenue and the cost of goods sold. It shows the amount of each dollar of sales your company turns into profit. The higher the value for the Gross Profit Margin Ratio, the better your company is performing. It is also important to note different industries may have very different gross margins. Enter the amounts, for all three periods, for the Gross Profit and Net Sales from your company's Income Statement. For each period, calculate the Gross Profit Margin Ratio using the following formula. Gross Profit Net Sales Enter the amounts in millions of dollars from the SEC Form 10K, for the current year, the previous year and the next previous year. Describe the trend direction for the Gross Profit Margin Ratio. Use phrases like: up only this year but level in previous years, consistently up, down only this year, consistently down or level for all years. Also, in your opinion is the trend positive, negative, insignificant? Copyright DA Bittar 2009, 2010, 2012 Page 29 of 42 Your Name Here Your Company Name Here Last, in your opinion, explain why the Gross Profit Margin Ratio for your company is or is not adequate for its future. Question 5.9 - Gross Profit Margin Ratio Accounts A Gross Profit B Net Sales C Gross Profit Margin Ratio D Why is or is not the Gross Profit Margin Ratio adequate for your company? E Gross Profit Margin Ratio trend description Current Yr Previous Yr Next Previous Yr Industry Ratio Question 5.10 - Inventory Turnover Ratio This ratio is used to measure how effectively your company converts its inventory into cash. It shows how well your company manages its inventory levels. If inventory turnover is too low, it may indicate the company is overstocking inventory. It may also indicate the company is having issues selling products. The higher the value for the Inventory Turnover Ratio, the better your company is performing. It is also important to note different industries may have very different inventory turn ratios. For some industries, the Inventory Turnover Ratio is not a significant as it is for other industries. Enter the amounts, for all three periods, for the Cost of Goods Sold from your company's Income Statement and Inventory from the balance sheet. For each period, calculate the Inventory Turn Ratio using the following formula. Cost of Goods Sold Inventory Enter the amounts in millions of dollars from the SEC Form 10K, for the current year, the previous year and the next previous year. Describe the trend direction for the Inventory Turn Ratio. Use phrases like: up only this year but level in previous years, consistently up, down only this year, consistently down or level for all years. Also, in your opinion is the trend positive, negative, insignificant? Last, in your opinion, explain why the Inventory Turnover Ratio for your company is or is not adequate for its future. Question 5.10 - Inventory Turnover Ratio Accounts A Cost of Goods Sold B Inventory C Inventory Turn Ratio Current Yr Previous Yr Next Previous Yr Industry Ratio Copyright DA Bittar 2009, 2010, 2012 Page 30 of 42 Your Name Here Your Company Name Here D Why is or is not the Inventory Turn Ratio adequate for your company? E Inventory Turnover Ratio trend description Question 5.11 - Days in Inventory Ratio This ratio is used to measure how effectively your company holds its inventory before it is sold. Generally, the longer inventory is remains unsold, the greater the chance it may not be sold or sold at less than its value. The Days in Inventory Ratio more important for companies with inventory that is perishable or subject to obsolescence. Companies with short product life cycles like high technology, automobile, toys and fashion might find this ratio important. Enter the value, for all three periods, for the Inventory Turnover Ratio. For each period, calculate the Days In Inventory Ratio using the following formula. 365 Inventory Turnover Ratio Enter the amounts in millions of dollars from the SEC Form 10K, for the current year, the previous year and the next previous year. Describe the trend direction for the Days In Inventory Ratio. Use phrases like: up only this year but level in previous years, consistently up, down only this year, consistently down or level for all years. Also, in your opinion is the trend positive, negative, insignificant? Last, in your opinion, explain why the Days In Inventory Ratio for your company is or is not adequate for its future. Question 5.11 - Days In Inventory Ratio Accounts A 365 B Inventory Turn Ratio C Days In Inventory Ratio D Why is or is not the Days In Inventory Ratio adequate for your company? Current Yr Previous Yr Next Previous Yr 365 365 365 Trend Description Question 5.12 - Accounts Receivable Turnover Ratio This ratio is used to measure how effectively your company is able to collect from its customers. A high turnover value is better. It shows your company is collecting revenues effectively and customers pay bills on time. A high figure also suggests that a firm's credit and collection policies are sound. Accounts receivable turnover may differ between different industries. For some industries, the Accounts Receivable Turnover Ratio is not a significant as it is for other industries. Copyright DA Bittar 2009, 2010, 2012 Page 31 of 42 Your Name Here Your Company Name Here Enter the amounts, for all three periods, for the Net Sales from your company's Income Statement and Accounts Receivable from the balance sheet. For each period, calculate the Accounts Receivable Turnover Ratio using the following formula. Net Sales Accounts Receivable Enter the amounts in millions of dollars from the SEC Form 10K, for the current year, the previous year and the next previous year. Describe the trend direction for the Accounts Receivable Turnover Ratio. Use phrases like: up only this year but level in previous years, consistently up, down only this year, consistently down or level for all years. Also, in your opinion is the trend positive, negative, insignificant? Last, in your opinion, explain why the Accounts Receivable Turnover Ratio for your company is or is not adequate for its future. Question 5.12 - Accounts Receivable Turnover Ratio Accounts A Net Sales B Accounts Receivable C Accounts Receivable Turnover Ratio D Why is or is not the Accounts Receivable Turnover Ratio adequate for your company? E Accounts Receivable Turnover Ratio trend description Current Yr Previous Yr Next Previous Yr Industry Ratio Question 5.13 - Average Collection Period This ratio is used to measure how effectively your company collects money from customers. The Average Collection Period shows the average number of days the company must wait for its Accounts Receivable to be paid. Comparing the days in the average collection period to the payment terms generally available to customers can help describe how quickly the company is collecting its money. Often, the longer receivables remain unpaid the more difficult they are to collect. Enter the value, for all three periods, for the Accounts Receivable Turnover Ratio. For each period, calculate the Average Collection Period using the following formula. 365 Accounts Receivable Turnover Ratio Enter the amounts in millions of dollars from the SEC Form 10K, for the current year, the previous year and the next previous year. Describe the trend direction for the Average Collection Period. Use phrases like: up only this year but level in previous years, consistently up, down only this year, consistently down or level for all years. Also, in your opinion is the trend positive, negative, insignificant? Last, in your opinion, explain why the Average Collection Period for your company is or is not adequate for its future. Copyright DA Bittar 2009, 2010, 2012 Page 32 of 42 Your Name Here Your Company Name Here Question 5.13 - Average Collection Period Accounts A 365 B Accounts Receivable Turnover Ratio C Average Collection Period D Why is or is not the Average Collection Period adequate for your company? Current Yr Previous Yr Next Previous Yr 365 365 365 Trend Description Question 5.14 - Accounts Payable Turnover Ratio This ratio is used to measure the length of time needed for your company to repay its vendors. A high turnover value is better than a low turnover value. Generally, it shows your company is paying bills on time. The ratio might be a good barometer of your company's financial stability. A high Account Payable Turnover ratio indicates your company produces cash quickly. A low ratio might infer your company may have cash flow issues. Enter the amounts, for all three periods, for the Cost of Goods Sold from your company's Income Statement and Accounts Payable from the balance sheet. For each period, calculate the Accounts Payable Turnover Ratio using the following formula. Cost of Goods Sold Accounts Payable Enter the amounts in millions of dollars from the SEC Form 10K, for the current year, the previous year and the next previous year. Describe the trend direction for the Accounts Payable Turnover Ratio. Use phrases like: up only this year but level in previous years, consistently up, down only this year, consistently down or level for all years. Also, in your opinion is the trend positive, negative, insignificant? Last, in your opinion, explain why the Accounts Payable Turnover Ratio for your company is or is not adequate for its future. Question 5.14 - Accounts Payable Turnover Ratio Accounts A Cost of Goods Sold B Accounts Payable C Accounts Payable Turnover Ratio D Why is or is not the Accounts Payable Turnover Ratio adequate for your company? Current Yr Previous Yr Next Previous Yr Trend Description Copyright DA Bittar 2009, 2010, 2012 Page 33 of 42 Your Name Here Your Company Name Here Question 5.15 - Net Working Capital Turnover Ratio The company's operations and inventory generate sales. This ratio is used to measure how well the money your company uses to support its operations generates sales. Generally, a higher ratio means the company is generating more sales for each dollar spent on operations. A high turnover value is better than a low turnover value. Working capital is the difference between current assets and current liabilities. To calculate working capital for your company use the following formula: Current Assets - Current Liabilities Working Capital Calculation Accounts Current Yr Previous Yr Next Previo