This question is designed to give you practice in accessing the SEC website, obtaining data in Excel form, and using that data.

Follow the steps below:

A. Go to the SEC website, and get an Excel version of the financial statements on Form 10-K for Dunkin’ Brands for the year ended December 28, 2013. To do this:

a. Go to www.sec.gov.

b. Click on “Filings” and then “Search for Company Filings.”

c. When asked for search tools, click on “Company or fund name, ticker symbol…”

d. For company name, insert Dunkin Brands and click Search.

e. There is more than one company listed starting with “dunkin.” You should click on the one whose name includes Dunkin Brands.

f. On the EDGAR search screen, for filing type, type in 10-K.
g. You will see that one of the forms was filed in early 2014.
This is the form that contains data for the year ended December, 2013. If you wanted the whole text, you would click on “Documents” but for this exercise, click on “Interactive Data.”
h. Now, click on “View Excel Document.” You should be able to download an Excel workbook with various tabs.
i. Open that workbook. It is protected from editing, but you should click on the “Enable Editing” tab.

B. Go to the tab that has the balance sheet. Your task is to create common size balance sheets for the two years shown. This means that every item in the balance sheet for any one year must be shown as a percentage of total assets for that year. You should be able to do this relatively quickly, using the copy command. (Note—when using Excel, you are going to want Excel to look at the figure for 2013 total assets a lot. If you want Excel to always look at the same cell for this item when you copy formulas, then you need to use an “absolute” cell address. If, for example, total assets was in cell b19, to tell Excel you want to use an absolute address you would type in $b$19.)
C. Go to the tab that has the income statement. Create common size income statements for the three years by expressing all the items as a percentage of total revenues.