{"id":127797,"date":"2018-02-20T23:50:30","date_gmt":"2018-02-20T23:50:30","guid":{"rendered":"https:\/\/writemyessayfree.com\/company-analysis-project-rubric-acct-2200"},"modified":"2017-08-16T06:22:40","modified_gmt":"2017-08-16T06:22:40","slug":"company-analysis-project-rubric-acct-2200","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/company-analysis-project-rubric-acct-2200\/","title":{"rendered":"Company Analysis Project Rubric ACCT 2200"},"content":{"rendered":"
\n

Company Analysis Project Rubric<\/p>\n

ACCT 2200<\/p>\n

 <\/p>\n

Student Name: ______________________________________________<\/p>\n

 <\/strong><\/p>\n

    \n
  1. Writing: (10points)<\/strong><\/li>\n<\/ol>\n

    Grammar, free of typos, etc.:_______________________________________________________________________________<\/p>\n

     <\/p>\n

    Overall format, clarity, understandability, etc. (Excel formulas are appropriate): ________________________________________________________________________________________________________________<\/p>\n

     <\/p>\n

      \n
    1. Part I: (15 points)<\/strong><\/li>\n<\/ol>\n

      Company\u2019s operations description:        __________<\/p>\n

      Interesting fact                :                                               __________<\/p>\n

       <\/p>\n

        \n
      1. Part II: (35 points) Ratios Analysis Ratios Analysis<\/strong><\/li>\n
      2. Net Profit Margin _______ __________            E. Current Ratio               ______    __________<\/li>\n
      3. Gross Profit Margin _______  \u00ad__________            F. Days to Collect            ______    __________<\/li>\n
      4. Fixed Asset Turnover _______ __________ G. Days to Sell                   ______    __________<\/li>\n
      5. ROE                 _______  __________            H. Debt to Assets             ______    __________<\/li>\n<\/ol>\n

         <\/p>\n

        Overall Company Analysis \u00ad\u00ad\u00ad\u00ad\u00ad\u00ad\u00ad\u00ad\u00ad\u00ad\u00ad\u00ad\u00ad____________<\/p>\n

         <\/strong><\/p>\n

          \n
        1. Part III: (20 points)<\/strong><\/li>\n<\/ol>\n

          Revenue recognition policy and impact on management decision-making: _____________________________<\/p>\n

           <\/p>\n

          __________________________________________________________________________________________________________________<\/p>\n

           <\/p>\n

          Secondaccounting policy and impact on management decision making: ________________________________<\/p>\n

           <\/p>\n

          __________________________________________________________________________________________________________________<\/p>\n

           <\/strong><\/p>\n

            \n
          1. Part IV: (20 points)<\/strong><\/li>\n<\/ol>\n

            Operating section analysis ___________________________________________________________________________________<\/p>\n

             <\/p>\n

            __________________________________________________________________________________________________________________<\/p>\n

             <\/p>\n

            Investing section analysis ____________________________________________________________________________________<\/p>\n

             <\/p>\n

            __________________________________________________________________________________________________________________<\/p>\n

             <\/p>\n

            Financing section analysis ___________________________________________________________________________________<\/p>\n

             <\/p>\n

            __________________________________________________________________________________________________________________<\/p>\n

             <\/p>\n

             <\/p>\n

             <\/p>\n

             <\/p>\n

             <\/p>\n

            ACCT 2200 Company Analysis Project \u2013 100 points<\/p>\n

             <\/p>\n

            Due Date:6\/1\/2017 at the beginning of class. Submit your Excel file on Canvas and turn in a hard copy of the rubric during class.<\/p>\n

             <\/p>\n

            The purpose of this assignment is to analyze a company and make an informed decision about the company\u2019s past performance and its potential, while utilizing the basic functionality of Excel to complete your analysis.Each student will pick a different public company (except companies in the Financial Services industry). Companies will be given based on a first come, first serve basis. The earlier you select a company, the more likely you are to get the company you want. You must email me the name of your company and the ticker symbol (how companies are identified on stock exchanges). Your job is to find the most recent annual report (10-K) from the following website, searching by the company\u2019s name or ticker symbol: https:\/\/www.sec.gov\/edgar\/searchedgar\/companysearch.html<\/a>. You will download the Excel version of the financial statements (or copy them into Excel) and perform all of your ratios using Excel (you will also need the PDF version for Parts 1 and 3). See steps below.<\/p>\n\n\n\n
            Click on \u201cDocuments\u201d to obtain PDF version of 10K (needed for Parts 1 and 3)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n
            Click on \u201cInteractive Data\u201d by most recent 10K, scroll until you find it<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

             <\/p>\n\n\n\n
            Click on \u201cView Excel Document\u201d<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

             <\/p>\n

             <\/p>\n

             <\/p>\n

            All parts below are documented within the Excel file you downloaded from above. Label each section accordingly. <\/strong><\/p>\n

             <\/p>\n

            PART I<\/p>\n

            Scan Items 1-4 in the 10-K and discuss the company\u2019s operations (what do they do, what is their industry, etc.) in a short paragraph using your own words. Additionally, include one fact about the company that you found interesting\/did not know beforehand (make sure you state what you found interesting).<\/p>\n

             <\/p>\n

            PART II<\/p>\n

            Using Excel formulas that utilize the exported financial data from above, calculate each of the ratios listed below for the most recent year and the prior year, on a separate tab within Excel. All numbers in the ratio calculations must be linked to the financial statement tabs. No numbers can be hard coded in the formula.<\/p>\n