2012 Annual Report Financial Data Visualization By: Faith Jean Cariaga
COMPANY Ulta Beauty was created to be a unique retail approach that focuses on all aspects of how women prefer to shop for beauty products, thus providing customers with an uplifiting specialty retail experience. Today, Ulta is the largest beauty retailer that provides one-stop shopping for prestige, mass and salon products and salon services in the United States. PROBLEM Ulta Beauty is need of data visualization that visualizes the financial highlights chapter of their 2012 Annual Report. The lack of appeal prevents readers from gaining an interest or an understanding when reading through the content. OPPORTUNITY Ulta Beauty provides the opportunity for a well developed redesign that will enhance the appeal and interest of readers. SOLUTION Strategically, this project will consist of illustrated graphics to help convey the message and information a lot clearer. This project will be applied into the financial highlights chapter of Ulta Beauty's 2012 Annual Report.
PROJECT STATEMENT
INSPIRATION
INSPIRATION
PROCESS
COST OF SALES 2008 2009 = $50,000
2010 2011 2012
Gross Profit
FINANCIAL HIGHLIGHTS INCOME STATEMENT: Net sales Cost of sales Gross Profit Selling, general & administrative expenses Pre-opening expenses Operating income Interest expense Income before income taxes Income tax expense Net income Net income per common share: Basic Diluted
27
PROCESS
JANUARY 28, 2012
JANUARY 29, 2011
$ 1,776,151 1,159,311 616,840 410,658 9,987 196,195 587 195,608 75,344 $ 120,264
$ 1,454,838 970,753 484,085 358,106 7,095 118,884 755 118,129 47,099 $ 71,030
$ $
$ $
1.96 1.90
1.20 1.16
EXPENSES
Selling, General, & Administrative Pre-Opening Interest
4,0
Income Tax
JANUARY 30, 2010
JANUARY 31, 2009
$ 1,222,771 846,202 376,569 302,413 6,003 68,153 2,202 65,951 26,595 $ 39,356
$ 1,084,646 752,939 331,707 271,095 14, 311 46,301 3,943 42,358 17,090 $ 25,268
$
$
912,141 628,495 283,646 225,167 11,758 46,721 4,542 42,179 16,844 25,335
$ $
$ $
$ $
0.69 0.48
0.68 0.66
0.44 0.43
FEBRUARY 2, 2008
28
PROCESS
TOTAL COST OF SALES
EXPENSES
2008 2009 = $50,000
2010 2011
Selling, General, & Administrative Pre-Opening
2012
Interest
4,0
Gross Profit
Income Tax
FINANCIAL HIGHLIGHTS INCOME STATEMENT: Net sales Total cost of sales Gross Profit Selling, general & administrative expenses Pre-opening expenses Operating income Interest expense Income before income taxes Income tax expense Net income Net income per common share: Basic Diluted
27
JANUARY 28, 2012
JANUARY 29, 2011
JANUARY 30, 2010
JANUARY 31, 2009
$ 1,776,151 $ 1,159,311 $ 616,840 $ 410,658 $ 9,987 $ 196,195 $ 587 $ 195,608 $ 75,344 $ 120,264
$ 1,454,838 $ 970,753 $ 484,085 $ 358,106 $ 7,095 $ 118,884 $ 755 $ 118,129 $ 47,099 $ 71,030
$ 1,222,771 $ 846,202 $ 376,569 $ 302,413 $ 6,003 $ 68,153 $ 2,202 $ 65,951 $ 26,595 $ 39,356
$ 1,084,646 $ 752,939 $ 331,707 $ 271,095 $ 14,311 $ 46,301 $ 3,943 $ 42,358 $ 17,090 $ 25,268
$ $ $ $ $ $ $ $ $ $
912,141 628,495 283,646 225,167 11,758 46,721 4,542 42,179 16,844 25,335
$ $
$ $
$ $
$ $
$ $
0.69 0.48
1.96 1.90
1.20 1.16
0.68 0.66
0.44 0.43
FEBRUARY 2, 2008
28
TOTAL ASSETS
END OF THE YEAR STORE COUNT 2008 2009
$1,000,000
= 50 stores
2010
$900,000
2008
$800,000
2009
$700,000
2010
$600,000 $500,000
2011
$400,000
2012 $469,413
$568,932
$553,635
$730,488
2011 2012
$957,217
FINANCIAL HIGHLIGHTS OTHER OPERATING DATA: Comparable store sales increase (2) Number of stores end of year Net sales per average total square foot (3) Capital expenditures Depreciation & amortization BALANCE SHEET DATA: Cash & cash equivalents Working capital Property & equipment, net Total assets Total debt Total stockholders’ equity
29
JANUARY 28, 2012
JANUARY 29, 2011
JANUARY 30, 2010
JANUARY 31, 2009
FEBRUARY 2, 2008
$ $ $ $ $
10.9% 449 402 128,636 75,931
11.0% 389 $ 382 97,115 64,936
$ $ $ $ $
1.4% 346 353 68,105 62,166
$ $ $ $ $
0.2% 311 366 110,863 51,445
6.4% 249 $ 399 101,866 39,503
$ $ $ $
253,738 415,377 376,985 957,217 -----584,704
$ 111,185 241,032 326,099 730,488 -----402,533
$ $ $ $
4,017 136,417 290,861 553,635 -----292,608
$ $ $ $ $ $
3,638 159,695 292,224 568,932 106,047 224,968
$ 3,789 117,039 236,389 469,413 74,770 211,503
$
$
30
CASH & CASH EQUIVALENTS AT BEGINNING/END OF THE YEAR
NET INCOME 2010
2010 = $10,000
2011
2011
2012
= $10,000 2012 $20,000
$40,000
$40,000
$40,000
$100,000
$120,000
Cash & cash equivalents at the beginning of the year Cash & cash equivalents at the end of the year
$140,000
STATEMENTS OF CASH FLOWS JANUARY 28, 2012 OPERATING ACTIVITIES Net income Adjustments to reconcile net income to net cash provided by operating activities: Depreciation & amortization Deferred income taxes Non-cash stock compensation charges Excess tax benefits from stock-based compensation Loss on disposal of property & equipment Change in operating assets & liabilities: Receivables Merchandise inventories Prepaid expenses and other current assets Income taxes Accounts payable Accruied liabilities Deferred rent Net cash provided by operating activities 31
JANUARY 29, 2011
JANUARY 30, 2010
$
120,264
$
71,030
$
39,356
$ $ $ $ $
75,931 10,827 11,605 (25,899) 1,324
$ $ $ $ $
64,936 7,741 11,155 (10,640) (519)
$ $ $ $ $
62,166 3,143 5,949 (476) (51)
$ $ $ $ $ $ $ $
(3,861) (26,131) (10,640) 40,585 (651) (1,358) 28,891 220,887
$ $ $ $ $ $ $ $
(8,815) (11,568) (2,518) (10,354) 30,706 14,535 20,854 176,543
$ $ $ $ $ $ $ $
4,791 6,654 (5,978) 19,855 8,576 16,382 12,430 172,827
JANUARY 28, 2012 INVESTING ACTIVITIES Purchases of property & equipment Net cash used in investing activities FINANCING ACTIVITIES Stock options exercised Excess tax from stock-based compensation Common stock repurchased Proceeds on long-term borrowings Payments on long-term borrowings Net cash provided by financing activities Net increase in cash & cash equivalents Cash & cash equivalents at the beginning of the year Cash & cash equivalents at the end of the year SUPPLEMENTAL CASH FLOW INFORMATION Cash paid for interest Cash paid for income taxes Noncash investing & financing activities: Change in property & equipment Gain on interest rate swap hedge, net of tax
JANUARY 29, 2011
JANUARY 30, 2010
$ (128,636) $ (128,636)
$ $
(97,115) (97,115)
$ $
$ $ $
$ $
$ $
$ $ $ $
17,100 10,640 ---------------27,740 107,168 4,017 111,185
$
-----49,871
$ $
2,440 3,706
2,540 ------
$ $
(7,353) 631
$ $ $ $
27,639 25,899 (3,236) ----------50,302 142,553 111,185 253,738
$
-----24,162
$
(495) ------
$
(68,105) (68,105)
1,228 476 -----$ 1,161,673 $(1,267,720) $ (104,343) $ 379 $ 3,638 $ 4,017
32