Question 1.

Chapter 1 - questions on page 21 Chapter 2 - Case of KELLY'S BOUTIQUE page 50 (submit ch2-05.xlsx)

This excel table is the exercise 1

Excel learn-us-east-1-prod-fleet02-xythos.content.blackboardcdn.com - View-only ~ Search (Alt + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Viewing Comments Book Antiqua 12 B I V V A v ... Ev ab Merge $ v -o Conditional Formatting v Styles v Format As Table ~ [ Format > > ATV Ov ... E6 fx A C D E F G H K L M N O P Q R S T U V W Kelly's Boutique Income Statement AWN For the Year Ended 31-Dec-14 31-Dec-15 % of Sales % Change 6 Sales Revenue $ 345,274.22 $420,755.88 Less: Cost of Goods Sold 164,217.74 225,154.87 8 Gross Margin 181,056.48 195,601.01 9 Expenses: 10 Advertising 25,871.45 $ 28,741.55 Depreciation 8,431.22 8,000.00 12 Interest 15,574.15 19,412.51 13 Payroll 105,487.51 99,413.44 14 Supplies expense 4,732.84 4,561.11 15 Utilities 10,847.00 8,424.71 16 Net income before taxes 10,112.31 27,047.69 17 Income taxes 3,784.44 10,847.55 18 Net income S 6,327.87 $ 16,200.14 19 20 21 22 23 24 25 26 27 28 29 30 31 32 E Income Statement Balance Sheet Ratio Analysis + Workbook Statistics Give Feedback to Microsoft - 100% +\fpage 105 CRITERIA FOR EVALUATING THE TASK OF CHAPTER 3 - WEEK 2 Kelly's Boutique case, page 80 ch3-04.xlsx (50 points) The following list contains the requirements of the Chapter 3 exercise in Excel. If the box on the left is marked, it has errors or did not. Each criterion has a value of 6.25, if it has errors but did it accumulates 3 and if it did not do it or is totally incorrect it accumulates 0. _ 1-Perform the vertical analysis of the Income Statement (% Sales) for 2014 and 2015 _2- Perform the vertical analysis of the Balance Sheet (% Assets) for 2014 and 2015 3- Perform the horizontal analysis of the Income Statement (% Change) for 2015 4- Perform the horizontal analysis of the Balance Sheet (% Change) for 2015 5- Prepare a pie chart for 2015 expenses 6- Prepare a bar graph (column) that compares the expenses of 2014 and 2015 7- Prepare the analysis of ratios for 2015 _ 8- Timely entrga no later than Sunday at midnight You don't have to print anything, just hand over the Excel file Chapter 4 -- Questions page 105 (50 points)Excel learn-us-east-1-prod-fleet02-xythos.content.blackboardcdn.com - View-only ~ Search (Alt + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Viewing Comments Book Antiqua 12 BIG Av .. . Ev ab Merge General $ v 40 Conditional Formatting v Styles ~ Format As Table ~ [ Format > > Ary Ov ... A1 fx Kelly's Boutique, Inc. C D E F G H K M N O P Q R S T U V W X Kelly's Boutique, Inc. Discount: 15% Book List W N Dept Product Author List Price Sales Price 6 Adult Angela's Ashes McCourt 7.99 Children Betsy - Tacy Lovelace 12.95 8 Children Blueberries for Sal Mccloskey 16.99 9 Children Caddie Woodlawn Brink 17.00 10 Adult Deep End of the Ocean Mitchard 12.95 Divine Secrets of the 11 Adult YaYa Sisterhood Wells 24.00 Children Green Eggs and Ham Seuss 7.99 Harry Potter and the 13 Children Chamber of Secrets Rowling 17.95 Harry Potter and the 14 Children Prisoner of Azkaban Rowling 17.95 Harry Potter and the 15 Children Sorcerer's Stone Rowling 17.95 16 Children Hop on Pop Seuss 7.99 17 Adult Horse Whisperer Evans 24.95 18 Children Lentil Mccloskey 16.99 19 Adult Memoirs of a Geisha Golden 26.95 20 Adult Message in a Bottle Sparks 20.00 21 Children One Morning in Maine Mccloskey 16.99 22 Children The Cat in the Hat Seuss 7.99 23 Adult The Notebook Sparks 16.95 24 25 26 27 28 Sheet1 Sheet2 Sheet3 + Workbook Statistics Give Feedback to Microsoft - 100% +