Excel Project: Part I Instructions

Company Information (Tab 1), and 

Historical Income Statements, Balance Sheets, and Cash Flows (Tabs 2-4)

Can you please complete it for Walt Disney (DIS)

· Choose one of the 3 companies listed in your Instructor’s Week 1 Announcement.

· Go to the Securities and Exchange Commission’s EDGAR database and access your chosen company’s most recent Form 10-K (annual report). (For help with this process, see the Module/Week 1 presentation, “Downloading Financial Statements from the SEC EDGAR Database.”)

· Create an Excel workbook, including data for your chosen company as follows:

o The 1st tab (worksheet) in your Financial Statement Analysis Template must be labeled Company Information. The following information must be included:

§ Company Name and ticker symbol

§ Industry

§ Products or services offered

§ Major competitors

§ An example of this tab is provided in Exhibit A.

o The 2nd tab in your Financial Statement Analysis Template must be labeled Historical Income Statements.

§ Include the latest three years based on SEC filings.

§ Ensure that the worksheet includes a header with:

· Company Name

· Financial Statement Name (Income Statements)

· Financial Statement Dates

· Denomination level ($s in millions or thousands, etc.)

o The 3rd tab in your Financial Statement Analysis Template must be labeled Historical Balance Sheets.

§ Include the latest three years based on SEC (10-K) filings. (Note: Some 10-Ks only provided 2 years of balance sheet data. You may need to download the second most recent 10-K for your company in order to obtain 3 years of balance sheet data.)

§ Ensure that the worksheet includes a header with:

· Company Name

· Financial Statement Name

· Financial Statement Dates

· Denomination level ($s in millions or thousands, etc.)

§ A partial balance sheet example is provided in Exhibit B.

o The 4th tab in your Financial Statement Analysis Template must be labeled Historical Statement of Cash Flows.

§ Include the latest three years based on SEC (10-K) filings.

§ Make sure that the Income Statement, Balance Sheet, and Cash Flows Statement tie in as follows:

· Net Income from Income Statement agrees with Net Income on the Statement of Cash Flows.

· Ending Cash Balance from Statement of Cash Flows agrees with Cash in the Balance Sheet.

§ Ensure that the worksheet includes a header with:

· Company Name

· Financial Statement Name

· Financial Statement Dates

· Denomination level ($s in millions or thousands, etc.)

o Other instructions:

§ The Excel workbook should be professionally formatted. Professional formatting includes:

· All numbers are formatted similarly. The use of decimals, commas for thousands, and other formatting is consistent.

· Dollar signs are included in the first and last numbers of each column.

· Subtotals and totals are preceded by a single underline. Totals are followed by a double underline.

· All extraneous information is removed from the spreadsheet. Sometimes, files downloaded from the SEC website contains extra characters or other things that need to be deleted.

· Line descriptions are indented/bolded in a manner that makes the spreadsheet easy to read.

§ All totals and subtotals should be calculated using formulas.  For an example of which cells may need formulas, please see Exhibit B.

This assignment is due by 11:59 p.m. (ET) on Monday of Module/Week 2.

Exhibit A: Example Company Information Tab

 

Exhibit B: Example Historical Balance Sheets Tab

(IMPORTANT NOTE: Only Partial Balance Sheet shown. Your Balance Sheet should include Liabilities and Stockholders’ Equity as well.)

 

Assignment 1

Conduct research on an event of your choice, either online or by attending a local event. Prepare a report of approximately of 700-1000 words related to this event. Make sure to describe the three aspects of event management presented in this Module.

 Event Objective (10 points)

 Food and Beverage (10 points)

 Strategic Planning (10 points)

Assignment 2

A Fortune 500 Corporation has selected your company to create their 100th anniversary celebration. This history-making event will be held on one day, and encompass three-different activities and venues – an employee business meeting, celebration activities and a gala dinner. Prepare a report of approximately of 1000 words describing how you will plan this event. Use the following topics as guidelines:

 Understanding objectives (10 points)

 Selecting venues (10 points)

 Catering for the gala dinner (10 points)

 Ground transportation to and from events (10 points)

 Assessment of any risks associated with the event (10 points)

Assignment 3

Attend a local event (social or corporate). Write a brief report on the event describing details such as event type, venue, décor, invitations and food. State your impressions of the event, in terms of the following:

 Things that were well planned and things that were not well organized (10 points)

 Explain in detail the elements that were not planned well and describe how you would improve on them to make the event better (10 points)

See attachment