Software skills: Spreadsheet downloading, formatting, and formulas Business skills: Financial statement analysis

In this assignment you will pick one e-commerce company on the Internet i.e. Ashford, Yahoo, Amazon, Google, Yahoo, Priceline). Study the web pages that describe the company and explain its purpose and structure. Use the web to find articles that comment on the company. Search for your company's Ticker Symbol.

Assignment Steps:

1.Watch the video tutorial entitled, "Downloading financial statements in Excel from SEC EDGAR database (https://www.youtube.com/watch?v=1C5MOfn1cZg).

2.Visit the Securities and Exchange Commission's website at www.sec.gov to access the company's 10-K (annual report) form showing income statements and balance sheets. Search using the company's Ticker Symbol.

3.Select the annual report (10-K) by selecting the Interactive Data link. Select the View Excel Document link located at top of the left column.

4.There are many reports; you only need the company's balance sheet and income statement. Either delete the unwanted tabs in this spreadsheet or copy/paste the balance sheet and income statement into a new spreadsheet. You should have only two tabs; one for the balance sheets and one for the income statements. Either way, save the file as MIS16ch10_spsh_(your_name).

5.Go back to the SEC website and find 2 other annual reports that are consecutive years for the same company. Move this information into the two sheets by adding columns to the information that is already there.

6.You will still only have one spreadsheet with two sheets; one for balance sheets and one for income statements that includes information for 3 consecutive years.

7.Using a Word document, create a short report that answers the following questions:

Is the company a dot-com success, borderline business, or failure?

What information provides the basis of your decision? Why?

When answering these questions, pay special attention to the company's three- year trends in revenues, costs of sales, gross margins, operating expenses, and net margins.

8.Report Formatting: 1-inch margins, 2.0 spacing. Include your name and date at the top of the report. Save the file as MISch10_excelreport_(your_name) and submit it in the online course.