You must use formulas to compute these ratios and show the numbers out to 2 decimal points.
A B 2015 C % D 2016 E % F 2017 G % H 2018 I % J 2019 K % 1 Lululemon Athletica Inc. 2 Historical and Common Size 1/S and B/S here 3 INSERT B/s from 10-Ks 4 -add as many rows as necessary 5 6 INSERT 1/s from 10-Ks 7 -add as many rows as necessary 8 9 10 Additional Information/Calculations Needed for Ratios: 11 EBITDA 12 Shares Outstanding (thousands) 13 Share price 14 MV Equity 15 Enterprise Value 16 17 Ratio Analysis: 18 Liquidity ratios 19 Current ratio 20 Quick ratio 21 Cash ratio 22 NWC / Assets 23 Interval mesure 24 25 Leverage ratios 26 Debt ratio 27 Debt/Equity 28 Equity multiplier 29 LT debt ratio 30 Times interest earned 31 Cash coverage 32 33 Assets turnover ratios 34 Inventory turnover 35 Days' sales in inventory 36 Receivables turnover 37 Days' sales in receivables 38 NWC turnover 39 Fixed Asset turnover 40 Total asset turnover 41 42 Profitability ratios 43 Profit Margin (PM) 44 Return on Assests (ROA) 45 Return on Equity (ROE) 46 47 Market value ratios 48 Price / Sales per share 49 MV / BV 50 EV / EBITDA 51 52 Du Pont Identity 53 Profit Margin 54 TAT = Sales / Assets 55 EM = Assets / Equity 56 ROE 57 58 Additional Ratios: 59 YoY Sales Growth 60 YOY Net Income Growth 61 lululemon athletica inc. CONSOLIDATED BALANCE SHEETS Amounts in thousand, except per Share amounts) 2017 ASSETS Current assets Cash and cash equivalents Accounts receivable.. Inventories ................................... Prepaid and receivable income taxes.................. Other prepaid expenses and other current assets .. 881,320 $ 990,501 35,786 19,173 404,842 329,562 49,385 48.948 57,949 48,098 1,429,282 1,436.282 567,237 473,642 24,239 24.679 26,549 32,491 37,404 31,389 $ 2,084,711 $ 1,998,483 lululemon athletica inc. CONSOLIDATED STATEMENTS OF OPERATIONS AND COMPREHENSIVE INCOME (Amounts in thousands, except per share amounts) Fiscal Year Ended February 3, January 28, January 29, 2019 Net revenue $ 3,288,319 $ 2,649,181 $ 2,344,392 Cost of goods sold... 1,472,032 1,250,391 1.144.775 Gross profit ................. 1,816,287 1,398,790 1.199,617 Selling, general and administrative expenses... 1,110,451 904,264 778,465 Asset impairment and restructuring costs...... 38,525 Income from operations........... 705,836 456,001 421,152 Other income expense), net .............. 9,414 3,997 1,577 Income before income tax expense.......... 715.250 459,998 422,729 Income tax expense 201 336 119,348 Net income. 483,801 $ 258,662 $ 303,381 Property and equipment, net.... Goodwill and intangible assets, net.......... Deferred income tax assets Other non-current assets ............. Other comprehensive income (loss), net of tax: Foreign currency translation adjustment... Comprehensive income.... (73,885) 409,916 58,577 317,239 $ 36,703 340,084 $ $ LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities Accounts payable .......... Accrued inventory liabilities .................... Accrued compensation and related expenses........... Current income taxes payable Unredeemed gift card liability .... Other current liabilities. ... $ $ $ $ $ $ Basic earnings per share ........... Diluted earnings per share.......... Basic weighted average number of shares outstanding.................... Diluted weighted average number of shares outstanding .................. 3.63 3.61 133,413 133.971 1.90 1.90 135,988 136,198 2.21 2.21 137,086 137,302 95,533 $ 16,241 109,181 67,412 99,412 112,698 500,477 42,099 14,249 81,911 638,736 24,646 13,027 70.141 15,700 82,668 86,416 292,598 48,268 1,336 59.321 401,523 See accompanying notes to the consolidated financial statements Non-current income taxes payable ........... Deferred income tax liabilities ..................... Other non-current liabilities ............ Commitments and contingencies Stockholders' equity Undesignated preferred stock, $0.01 par value: 5,000 shares authorized: none issued and outstanding..... Exchangeable stock, no par value: 60,000 shares authorized: 9,332 and 9,781 issued and outstanding................ Special voting stock $0.000005 par value: 60,000 shares authorized: 9,332 and 9,781 issued and outstanding Common stock, $0.005 par value: 400,000 shares authorized: 121,600 and 125,650 issued and outstanding ... Additional paid-in capital. ......... Retained earnings............. Accumulated other comprehensive loss.......... 608 628 315,285 284,253 1,346,890 1,455,002 (216,808) (142,923) 1,445,975 1,596,960 $ 2,084,711 S 1,998,483 lululemon athletica inc. CONSOLIDATED BALANCE SHEETS Amounts in thousands, except per share amount January 28, January 29, ASSETS Current assets Cash and cash equivalents Accounts receivable.................. ...... Inventories ..................................................... Prepaid and receivable income taxes.................... Other prepaid expenses and other current assets ............ 990,501 $ 734.846 19,173 9,200 329,562 298,432 48,948 81,190 48,098 39,069 1,436,282 1,162,737 473,642 423,499 24,679 24,557 32,491 26.256 31,389 20,492 $ 1,998,483 $ 1,657,541 Property and equipment, net............ Goodwill and intangible assets, net................. Deferred income tax assets .... Other non-current assets $ LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities Accounts payable Accrued inventory liabilities ........... Accrued compensation and related expenses....... Current income taxes payable .......... Unredeemed gift card liability... Lease termination liabilities.......... Other current liabilities..... 24,846 8,601 55.238 30,290 70,454 24,646 13,027 70,141 15,700 82,668 6,427 79,989 292,598 48,268 1,336 59,321 401,523 52,561 241,990 income taxes payable 7,262 Calc LLLLLLL LA Launu s . . . . . . . . . . . . . . . . . . . . . . . . Deferred income tax liabilities ..... Other non-current liabilities .......................... 48,316 297,568 Stockholders' equity Undesignated preferred stock $0.01 par value: 5,000 shares authorized: none issued and outstanding Exchangeable stock, no par value: 60,000 shares authorized: 9,781 and 9,781 issued and outstanding.... Special voting stock, $0.000005 par value: 60,000 shares authorized: 9,781 and 9,781 issued and outstanding ....... Common stock $0.005 par value: 400,000 shares authorized: 125,650 and 127,304 issued and outstanding ... Additional paid-in capital.. Retained eamings Accumulated other comprehensive loss......... 284,253 1,455,002 (142,923) 1,596,960 1,998,483 637 266,622 1,294,214 (201,500) 1,359,973 $1,657,541 $ lululemon athletica inc. CONSOLIDATED BALANCE SHEETS (Amounts in thousands, except per share amounts) January 31, 2016 February 1, 2015 ASSETS Current assets Cash and cash equivalents... Accounts receivable. Inventories .................. ................ Prepaid and receivable income taxes................... Other prepaid expenses and other current assets .................... ... $ 501.482 $ 664,479 13,108 13,746 284,009 208,116 91,453 40,547 26,987 24,124 917,039 951,012 349,605 296,008 24,777 26,163 11,802 16,018 10,854 $ 1,314,077 $ 1,296,213 Property and equipment, net........ Goodwill and intangible assets, net...................... Deferred income tax assets ............................ Other non-current assets ................. ...... 7,012 ...... $ LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities Accounts payable............................. Accrued inventory liabilities ..................... Accrued compensation and related expenses........... Income taxes payable....................... Unredeemed gift card liability .............. ... Other accrued liabilities ................................ 10,381 $ 25,451 43,524 37,736 57,736 50,676 225,504 10,759 50,332 286,595 9,339 22,296 29,932 20,073 46,252 31,989 159,881 3,633 43,131 206,645 Deferred income tax liabilities .......... Other non-current liabilities ........ Stockholders' equity Undesignated preferred stock, $0.01 par value: 5,000 shares authorized; none issued and outstanding....... .. Exchangeable stock, no par value: 60,000 shares authorized; 9,804 and 9,833 issued and outstanding...... . Special voting stock, S0.000005 par value: 60,000 shares authorized; 9,804 and 9,833 issued and outstanding. Common stock, S0.005 par value: 400,000 shares authorized; 127,482 and 132,112 issued and outstanding ........ Additional paid-in capital............ Retained earnings. Accumulated other comprehensive loss............ 637 245,533 1,019,515 (238,203) 1,027,482 1,314,077 241,695 1,020,619 (173,407) 1,089,568 $ 1,296,213 $ Net revenue ... Cost of goods sold....... Gross profit............. ........... Selling, general and administrative expenses ...... Asset impairment and restructuring costs ............ Income from operations.......... Other income (expense), net...... Income before income tax expense......... Income tax expense............ Net income......... Fiscal Year Ended February 3, January 28, January 29, 2019 2018 2017 In showana) $ 3,288,319 $ 2,649,181 $ 2,344,392 1,472,032 1.250,391 1,144,775 1,816,287 1,398,790 1.199,617 1,110,451 904,264 778,465 38,525 705,836 456,001 421,152 9,414 3.997 1.577 715,250 459.998 422,729 231,449 201,336 119,348 $ 483,801 $ 258,662 $ 303,381 February 3, January 29, 2019 2017 100.0% 44.8 55.2 Fiscal Year Ended January 28, 2018 Percentages 100.0% 47.2 52.8 34.1 1.5 100.0% 488 33 Net revenue ........ Cost of goods sold. Gross profit ................ Selling, general and administrative expenses ...... Asset impairment and restructuring costs ............. Income from operations.. Other income (expense), net........ Income before income tax expense......... Income tax expense Net income....... .. 17.2 14.7% Fiscal Year Ended January 29, January 31, February 1, February 2, February 3, 2017 2016 2015 2014 (In thousands, except per share data) Consolidated statement of operations and comprehensive income data: Net revenue ...............$ 2,344,392 $ 2.060,523 $ 1,797,213 $ 1,591,188 $ 1,370,358 Cost of goods sold............ 1,144,775 1,063,357 883,033 751,112 607,532 Gross profit........... 1,199,617 997,166 914,180 840,076 762,826 Selling, general and administrative expenses... 778,465 628,090 538,147 448,718 386,387 Income from operations ................... 421,152 369,076 376,033 391,358 376,439 Other income (expense), net................ 1,577 (581) 7,102 5,768 4,957 Income before income tax expense........... 422,729 368,495 383,135 397,126 381,396 Income tax expense. ........... 119,348 102,448 144,102 117,579 109,965 Net income ............. 303,381 266,047 239,033 279,547 271,431 Net income attributable to non-controlling interest ................ 875 Net income attributable to lululemon athletica inc.. $ 303,381 $ 266,047 $ 239,033 $ 279,547 $ 270,556 Other comprehensive income (loss): Foreign currency translation adjustment....... Comprehensive income.................... $ 36,703 340,084 (64,796) 201,251 $ (105,339) 133,694 $ (89,158) 190,389 $ (459) 270,097 $ $ 1.93 $ 1.88 2.21 $ 2.21 $ 1.90 1.89 $ $ 1.66 1. Basic eamings per share ................... S Diluted earnings per share.................. $ Basic weighted average number of shares outstanding Diluted weighted average number of shares outstanding ... 137,086 140,365 143,935 144.913 144,000 137,302 140,610 144,298 146,043 145,806 January 29, January 31, As of February, (In thousands) February 2, February 3, 2014 2013 $ Consolidated balance sheet data: Cash and cash equivalents. ... Total assets Total stockholders' equity.. ................ 734,846 $ 1.657,541 1,359,973 501,482 $ 1,314,077 1,027,482 664,479 $ 1.296,213 1,089,568 698,649 $ 1.252,388 1,096,682 590,179 1,052,678 887,299 A B 2015 C % D 2016 E % F 2017 G % H 2018 I % J 2019 K % 1 Lululemon Athletica Inc. 2 Historical and Common Size 1/S and B/S here 3 INSERT B/s from 10-Ks 4 -add as many rows as necessary 5 6 INSERT 1/s from 10-Ks 7 -add as many rows as necessary 8 9 10 Additional Information/Calculations Needed for Ratios: 11 EBITDA 12 Shares Outstanding (thousands) 13 Share price 14 MV Equity 15 Enterprise Value 16 17 Ratio Analysis: 18 Liquidity ratios 19 Current ratio 20 Quick ratio 21 Cash ratio 22 NWC / Assets 23 Interval mesure 24 25 Leverage ratios 26 Debt ratio 27 Debt/Equity 28 Equity multiplier 29 LT debt ratio 30 Times interest earned 31 Cash coverage 32 33 Assets turnover ratios 34 Inventory turnover 35 Days' sales in inventory 36 Receivables turnover 37 Days' sales in receivables 38 NWC turnover 39 Fixed Asset turnover 40 Total asset turnover 41 42 Profitability ratios 43 Profit Margin (PM) 44 Return on Assests (ROA) 45 Return on Equity (ROE) 46 47 Market value ratios 48 Price / Sales per share 49 MV / BV 50 EV / EBITDA 51 52 Du Pont Identity 53 Profit Margin 54 TAT = Sales / Assets 55 EM = Assets / Equity 56 ROE 57 58 Additional Ratios: 59 YoY Sales Growth 60 YOY Net Income Growth 61 lululemon athletica inc. CONSOLIDATED BALANCE SHEETS Amounts in thousand, except per Share amounts) 2017 ASSETS Current assets Cash and cash equivalents Accounts receivable.. Inventories ................................... Prepaid and receivable income taxes.................. Other prepaid expenses and other current assets .. 881,320 $ 990,501 35,786 19,173 404,842 329,562 49,385 48.948 57,949 48,098 1,429,282 1,436.282 567,237 473,642 24,239 24.679 26,549 32,491 37,404 31,389 $ 2,084,711 $ 1,998,483 lululemon athletica inc. CONSOLIDATED STATEMENTS OF OPERATIONS AND COMPREHENSIVE INCOME (Amounts in thousands, except per share amounts) Fiscal Year Ended February 3, January 28, January 29, 2019 Net revenue $ 3,288,319 $ 2,649,181 $ 2,344,392 Cost of goods sold... 1,472,032 1,250,391 1.144.775 Gross profit ................. 1,816,287 1,398,790 1.199,617 Selling, general and administrative expenses... 1,110,451 904,264 778,465 Asset impairment and restructuring costs...... 38,525 Income from operations........... 705,836 456,001 421,152 Other income expense), net .............. 9,414 3,997 1,577 Income before income tax expense.......... 715.250 459,998 422,729 Income tax expense 201 336 119,348 Net income. 483,801 $ 258,662 $ 303,381 Property and equipment, net.... Goodwill and intangible assets, net.......... Deferred income tax assets Other non-current assets ............. Other comprehensive income (loss), net of tax: Foreign currency translation adjustment... Comprehensive income.... (73,885) 409,916 58,577 317,239 $ 36,703 340,084 $ $ LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities Accounts payable .......... Accrued inventory liabilities .................... Accrued compensation and related expenses........... Current income taxes payable Unredeemed gift card liability .... Other current liabilities. ... $ $ $ $ $ $ Basic earnings per share ........... Diluted earnings per share.......... Basic weighted average number of shares outstanding.................... Diluted weighted average number of shares outstanding .................. 3.63 3.61 133,413 133.971 1.90 1.90 135,988 136,198 2.21 2.21 137,086 137,302 95,533 $ 16,241 109,181 67,412 99,412 112,698 500,477 42,099 14,249 81,911 638,736 24,646 13,027 70.141 15,700 82,668 86,416 292,598 48,268 1,336 59.321 401,523 See accompanying notes to the consolidated financial statements Non-current income taxes payable ........... Deferred income tax liabilities ..................... Other non-current liabilities ............ Commitments and contingencies Stockholders' equity Undesignated preferred stock, $0.01 par value: 5,000 shares authorized: none issued and outstanding..... Exchangeable stock, no par value: 60,000 shares authorized: 9,332 and 9,781 issued and outstanding................ Special voting stock $0.000005 par value: 60,000 shares authorized: 9,332 and 9,781 issued and outstanding Common stock, $0.005 par value: 400,000 shares authorized: 121,600 and 125,650 issued and outstanding ... Additional paid-in capital. ......... Retained earnings............. Accumulated other comprehensive loss.......... 608 628 315,285 284,253 1,346,890 1,455,002 (216,808) (142,923) 1,445,975 1,596,960 $ 2,084,711 S 1,998,483 lululemon athletica inc. CONSOLIDATED BALANCE SHEETS Amounts in thousands, except per share amount January 28, January 29, ASSETS Current assets Cash and cash equivalents Accounts receivable.................. ...... Inventories ..................................................... Prepaid and receivable income taxes.................... Other prepaid expenses and other current assets ............ 990,501 $ 734.846 19,173 9,200 329,562 298,432 48,948 81,190 48,098 39,069 1,436,282 1,162,737 473,642 423,499 24,679 24,557 32,491 26.256 31,389 20,492 $ 1,998,483 $ 1,657,541 Property and equipment, net............ Goodwill and intangible assets, net................. Deferred income tax assets .... Other non-current assets $ LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities Accounts payable Accrued inventory liabilities ........... Accrued compensation and related expenses....... Current income taxes payable .......... Unredeemed gift card liability... Lease termination liabilities.......... Other current liabilities..... 24,846 8,601 55.238 30,290 70,454 24,646 13,027 70,141 15,700 82,668 6,427 79,989 292,598 48,268 1,336 59,321 401,523 52,561 241,990 income taxes payable 7,262 Calc LLLLLLL LA Launu s . . . . . . . . . . . . . . . . . . . . . . . . Deferred income tax liabilities ..... Other non-current liabilities .......................... 48,316 297,568 Stockholders' equity Undesignated preferred stock $0.01 par value: 5,000 shares authorized: none issued and outstanding Exchangeable stock, no par value: 60,000 shares authorized: 9,781 and 9,781 issued and outstanding.... Special voting stock, $0.000005 par value: 60,000 shares authorized: 9,781 and 9,781 issued and outstanding ....... Common stock $0.005 par value: 400,000 shares authorized: 125,650 and 127,304 issued and outstanding ... Additional paid-in capital.. Retained eamings Accumulated other comprehensive loss......... 284,253 1,455,002 (142,923) 1,596,960 1,998,483 637 266,622 1,294,214 (201,500) 1,359,973 $1,657,541 $ lululemon athletica inc. CONSOLIDATED BALANCE SHEETS (Amounts in thousands, except per share amounts) January 31, 2016 February 1, 2015 ASSETS Current assets Cash and cash equivalents... Accounts receivable. Inventories .................. ................ Prepaid and receivable income taxes................... Other prepaid expenses and other current assets .................... ... $ 501.482 $ 664,479 13,108 13,746 284,009 208,116 91,453 40,547 26,987 24,124 917,039 951,012 349,605 296,008 24,777 26,163 11,802 16,018 10,854 $ 1,314,077 $ 1,296,213 Property and equipment, net........ Goodwill and intangible assets, net...................... Deferred income tax assets ............................ Other non-current assets ................. ...... 7,012 ...... $ LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities Accounts payable............................. Accrued inventory liabilities ..................... Accrued compensation and related expenses........... Income taxes payable....................... Unredeemed gift card liability .............. ... Other accrued liabilities ................................ 10,381 $ 25,451 43,524 37,736 57,736 50,676 225,504 10,759 50,332 286,595 9,339 22,296 29,932 20,073 46,252 31,989 159,881 3,633 43,131 206,645 Deferred income tax liabilities .......... Other non-current liabilities ........ Stockholders' equity Undesignated preferred stock, $0.01 par value: 5,000 shares authorized; none issued and outstanding....... .. Exchangeable stock, no par value: 60,000 shares authorized; 9,804 and 9,833 issued and outstanding...... . Special voting stock, S0.000005 par value: 60,000 shares authorized; 9,804 and 9,833 issued and outstanding. Common stock, S0.005 par value: 400,000 shares authorized; 127,482 and 132,112 issued and outstanding ........ Additional paid-in capital............ Retained earnings. Accumulated other comprehensive loss............ 637 245,533 1,019,515 (238,203) 1,027,482 1,314,077 241,695 1,020,619 (173,407) 1,089,568 $ 1,296,213 $ Net revenue ... Cost of goods sold....... Gross profit............. ........... Selling, general and administrative expenses ...... Asset impairment and restructuring costs ............ Income from operations.......... Other income (expense), net...... Income before income tax expense......... Income tax expense............ Net income......... Fiscal Year Ended February 3, January 28, January 29, 2019 2018 2017 In showana) $ 3,288,319 $ 2,649,181 $ 2,344,392 1,472,032 1.250,391 1,144,775 1,816,287 1,398,790 1.199,617 1,110,451 904,264 778,465 38,525 705,836 456,001 421,152 9,414 3.997 1.577 715,250 459.998 422,729 231,449 201,336 119,348 $ 483,801 $ 258,662 $ 303,381 February 3, January 29, 2019 2017 100.0% 44.8 55.2 Fiscal Year Ended January 28, 2018 Percentages 100.0% 47.2 52.8 34.1 1.5 100.0% 488 33 Net revenue ........ Cost of goods sold. Gross profit ................ Selling, general and administrative expenses ...... Asset impairment and restructuring costs ............. Income from operations.. Other income (expense), net........ Income before income tax expense......... Income tax expense Net income....... .. 17.2 14.7% Fiscal Year Ended January 29, January 31, February 1, February 2, February 3, 2017 2016 2015 2014 (In thousands, except per share data) Consolidated statement of operations and comprehensive income data: Net revenue ...............$ 2,344,392 $ 2.060,523 $ 1,797,213 $ 1,591,188 $ 1,370,358 Cost of goods sold............ 1,144,775 1,063,357 883,033 751,112 607,532 Gross profit........... 1,199,617 997,166 914,180 840,076 762,826 Selling, general and administrative expenses... 778,465 628,090 538,147 448,718 386,387 Income from operations ................... 421,152 369,076 376,033 391,358 376,439 Other income (expense), net................ 1,577 (581) 7,102 5,768 4,957 Income before income tax expense........... 422,729 368,495 383,135 397,126 381,396 Income tax expense. ........... 119,348 102,448 144,102 117,579 109,965 Net income ............. 303,381 266,047 239,033 279,547 271,431 Net income attributable to non-controlling interest ................ 875 Net income attributable to lululemon athletica inc.. $ 303,381 $ 266,047 $ 239,033 $ 279,547 $ 270,556 Other comprehensive income (loss): Foreign currency translation adjustment....... Comprehensive income.................... $ 36,703 340,084 (64,796) 201,251 $ (105,339) 133,694 $ (89,158) 190,389 $ (459) 270,097 $ $ 1.93 $ 1.88 2.21 $ 2.21 $ 1.90 1.89 $ $ 1.66 1. Basic eamings per share ................... S Diluted earnings per share.................. $ Basic weighted average number of shares outstanding Diluted weighted average number of shares outstanding ... 137,086 140,365 143,935 144.913 144,000 137,302 140,610 144,298 146,043 145,806 January 29, January 31, As of February, (In thousands) February 2, February 3, 2014 2013 $ Consolidated balance sheet data: Cash and cash equivalents. ... Total assets Total stockholders' equity.. ................ 734,846 $ 1.657,541 1,359,973 501,482 $ 1,314,077 1,027,482 664,479 $ 1.296,213 1,089,568 698,649 $ 1.252,388 1,096,682 590,179 1,052,678 887,299
