Your CEO Has Come To You Requesting a Report

Your CEO has come to you requesting a report surrounding certain accounting issues. Further, after finishing the report he would like you to verbally present him with highlights of your findings. You are to recreate a series of several Financial Statements with appropriate footnotes. You will select a publicly traded company from the S & P 500 (Standard and Poor’s 500 Index) to use as the source for your data and information, or if you work for a publicly-traded company you may instead choose to select that company for your project. (Reports for most publicly-traded companies can be found on the company’s website, or through Edgar Search Tools through Filings at www.sec.gov

In an Excel document, first you will recreate the Balance Sheet, then on the next sheet Income Statement, then on the next sheet develop the Cash Flow Statement. After the Financial Statements, develop the following as parts of the project:

Using selected data from the Financial Statements, exhibit how examples of Time Value of Money concepts such as PV, FV, & Annuities may be important over the next several years.

Show and explain Cash & Receivables using actual numeric data from your chosen company.

Discuss and display any perceived inventory issues as shown in the data, with any recommendations you might make.

Explain the relevance, or lack of relevance of other additional valuation issues to your company by showing and using the actual numeric data.

Provide commentary and an analysis on the acquisition or disposition of property, plant, and equipment using numeric data.

Report on depreciation methods used by the company. Compare the chosen method with other possible methods of depreciation that could have been used using the numeric data.

Segregate any intangible assets. Report on the intangibles (if any) and how they are valued and reported.

Lastly, record a short Screencast or video that presents and highlights some of the key findings in approximately 5 minutes or less, and then provide a link to that video in your excel file. (YouTube, Jing, or Screencast-o-matic are a few suggested methods, or you may use another method).

The Final Project is to be prepared entirely on one Excel Workbook. However, each item requested should be located on a separate sheet of that Workbook. (Also see the Dr H Video on Final Project Procedures). Assumed values may occasionally be necessary, but you should provide footnoted or other explanations as is typical in examples used throughout the textbook. The Final Project will be due on the last day of our course.