Please find attached below the facts for this problem:
Use this financial data to tell a story visually about the financial growth of Apple using graphs.
- Compute relevant ratios like inventory turnover or return on assets or equity.
- You are welcome to add to this data by obtaining share price data, segment data, or comparing this data to data of other companies in their industry or industry averages.
- Using the calculations andinformation you prepared above,prepare 5 graphs that tell a story.Be sure to label each graph.
If the growth trendis going higher make sure you reorganize the data so yourgraphgoes up on the right side --looking like a favorable trend. Sometimes simple is better.
Arial LA 10 AA ab General Insert BIUT - CA- 2% 2 100 -20 Conditional Format as Cell Delete ~ Formatting Table Styles Format Sort & Find & Ideas Sensitivity ard Font IS Filter ~ Select Alignment Number Styles Cells Editing Ideas X - fx Sensitivity B C D G H K Apple Statement of Operations Sep. 26, 2015 Sep. 27, 2014 Sep. 28, 2013 Net sales Sep. 29, 2012 Sep. 24, 2011 Sep. 24, 2011 Sep. 25, 2010 Sep. 26, 2009 233,715 182,795 170,910 156,508 108,249 108,249 66,225 42,905 Cost of sales 140,089 112,258 106,606 87,846 64,431 64,431 39,541 25,683 Gross margin 93,626 70,537 64,304 68,662 43,818 43,818 25,684 17,222 Operating expenses: Research and development 8,067 6,041 4,475 3,381 2,429 2,429 1,782 1,333 Selling, general and administrative 14,329 11,993 10,830 10,040 7,599 7,599 5,517 4,149 Total operating expenses 22,396 18,034 15,305 13,421 10,028 10,028 7,299 5,482 33,790 18,385 11,740 17 Operating income 71,230 52,503 48,999 55,241 33,790 Other income/(expense), net 980 1,156 522 415 415 326 18 1,285 155 19 20 Income before provision for income taxes 72,515 53,483 50,155 55,763 34,205 34,205 18,540 12,066 19,121 13,973 13,118 14,030 8,283 8,283 4,527 3,831 21 Provision for income taxes Income Statement Balance Sheet Sheet3 + 9:22 PM O qb W qb X 11/4/2020 Type here to search LGA B C D E G H Sep. 26, 2015 Net sales Sep. 27, 2014 Sep. 28, 2013 Sep. 29, 2012 233,715 Sep. 24, 2011 182,795 Sep. 24, 2011 170,910 Sep. 25, 2010 156,508 Sep. 26, 2009 Cost of sales 108,249 140,089 108,249 112,258 106,606 66,225 87,846 42,905 64,431 64,431 39,541 25,683 Gross margin 93,626 70,537 64,304 68,662 43,818 0 43,818 25, 684 17,222 11 Operating expenses: 12 Research and development 8,067 6,041 4,475 3,381 2,429 2,429 1,782 1,333 13 Selling, general and administrative 14,329 11,993 10,830 10,040 7,599 7,599 5,517 4,149 14 15 Total operating expenses 22,396 18,034 15,305 13,421 10,028 10,028 7,299 5,482 16 17 Operating income 71,230 52,503 48,999 55,241 33,790 33,790 18,385 11,740 18 Other income/(expense), net 1,285 980 1,156 522 415 415 155 326 19 20 Income before provision for income taxes 72,515 53,483 50,155 55,763 34,205 34,205 18,540 12,066 21 Provision for income taxes 19,121 13,973 13, 118 14,030 8,283 8,283 4,527 3,831 22 23 Net income 53,394 39,510 37,037 41,733 25,922 25,922 14,013 8,235 24 Income Statement Balance Sheet Sheet3 + 9:22 Type here to search O qb W qb X 11/4/2Clipboard Font Alignment Number Styles Cells Editing Ideas Sensi 122 =+B22/B41 D E F G H K M N O P Q 10 11 12 Sep. 28, 2013 Sep. 29, 2012 Sep. 24, 2011 Sep. 25, 2010 13 14 $14,259 $10,746 $ 9,815 $ 11,261 15 26,287 18,383 16,137 14,359 16 13,102 10,930 5,369 5,510 17 1,764 791 776 1,051 18 3,453 2,583 2,014 1,636 19 7,539 7,762 6,348 4,414 20 6,882 6,458 4,529 3,447 21 22 73,286 57,653 44,988 41,678 111% 108% 168% 150% 161% 201% 23 106,215 92,122 55, 618 25,391 2015 2014 2013 2012 2011 2010 24 16,597 15,452 7,777 4,768 25 1,577 1,135 896 741 26 4,179 4,224 3,536 342 27 5,146 5,478 3,556 2,263 28 Current Ratio 29 207,000 176,064 116,371 75,183 250% Income Statement Balance Sheet Sheet3 + Average: 100700% Count: 12 Sum: 1208398% Type here to search O qb W 9 qb X OLG122 X =+B22/B41 D 0 , 340 G tittit H M N O P Q 20 R 6,882 6,458 4,529 3,447 21 22 73,286 57,653 44,988 41,678 111% 108% 168% 150% 161% 201% 23 106,215 92,122 55,618 25,391 2015 2014 2013 2012 2011 24 2010 16,597 15,452 7,777 4,768 25 1,577 1,135 896 741 26 4,179 4,224 3,536 342 27 5,146 5,478 3,556 2,263 28 Current Ratio 29 207,000 176,064 116,371 75,183 30 250% 31 32 200% 33 150% 34 35 22,367 21,175 14,632 12,015 100% 36 13,856 11,414 9,247 5,723 37 7,435 5,953 4,091 2,984 50% 38 39 Income Statement Balance Sheet Sheet3 + Average: 100700% Count: 12 Sum: 1208398% 9:2 Type here to search O qb 9 qb X 11/4 OLG R122 X Y fx =+B22/B41 D 31 E F G H 200% M N O P 32 Q R 33 34 150% 35 22,367 21,175 14,632 12,015 36 13,856 11,414 9,247 5,723 100% 37 7,435 5,953 4,091 2,984 38 50% 39 40 0% 2015 41 43,658 38,542 27,970 2012 20,722 2011 2010 42 2,625 2,648 1,686 1,139 43 16,960 44 20,208 16,664 10,100 5,531 45 46 83,451 57,854 39,756 27,392 47 48 49 Income Statement Balance Sheet Sheet3 + Average: 100700% Count: 12 Sum: 1208398% Type here to search O qb W qb X 9:22 11/4/2 OLG00 0 Format Sort & Find & Ideas Formatting Table Styles v Filter ~ Select v Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity M32 A B C D E F G H K M N O P Q R 7 111% 108% 168% 150% 161% 201% 8 2015 2014 2013 2012 2011 2010 9 10 11 12 13 Current Ratio 14 15 16 17 201% 18 168% 150% 161% 19 20 111% 108% 21 22 23 24 2012 25 2015 2014 2013 2011 2010 Income Statement Balance Sheet Sheet3 + 9:22 PI Type here to search O gb W 9 qb X 11/4/20 OLG