Company Name: William Sonoma Imc

Edgar works VERY well for common size financial statements bc it will download the f/s into an Excel file for you. I HIGHLY recommend using Edgar for this assignment. You can access it www.sec.gov (Links to an external site.) or using the database links at our Connelly Library homepage

Internet Assignment #2 Preparation and Analysis of Common Size Financial Statements Objective: Compare your company's Common Size Financial Statements over the two most recent fiscal years to draw conclusions about how the company's performance. 1. In good form, prepare common-size balance sheets and income statements for your company's most recent fiscal year-end using Excel. (50 points) 2. Using the common-size income statements, complete the following table: (5 points each) Date COGS Gross Profit Profit Margin (also Margin called Net Income percentage) 3. Compare & analyze the common-size statements. Discuss changes in financial structure and profit margin over the past 2 years. (20 points) Note: Assignment should be professionally prepared and well-written with no spelling grammatical errors. Excel spreadsheet should be properly formatted using S-signs and %-signs as appropriate. Points will be deducted for unprofessional submissions. Internet Assignment #2 Preparation and Analysis of Common Size Financial Statements Objective: Compare your company's Common Size Financial Statements over the two most recent fiscal years to draw conclusions about how the company's performance. 1. In good form, prepare common-size balance sheets and income statements for your company's most recent fiscal year-end using Excel. (50 points) 2. Using the common-size income statements, complete the following table: (5 points each) Date COGS Gross Profit Profit Margin (also Margin called Net Income percentage) 3. Compare & analyze the common-size statements. Discuss changes in financial structure and profit margin over the past 2 years. (20 points) Note: Assignment should be professionally prepared and well-written with no spelling grammatical errors. Excel spreadsheet should be properly formatted using S-signs and %-signs as appropriate. Points will be deducted for unprofessional submissions