Complete the lululemon athletica, inc. 2015-2020 spreadsheet with your calculations of the indicated financial ratios (green...

Transcribed Image Text:

Complete the lululemon athletica, inc. 2015-2020 spreadsheet with your calculations of the indicated financial ratios (green boxes). Calculate your financial ratios for Fiscal 2018 and Fiscal 2019 from the attached income statements and balance sheets for lululemon athletica. NOTE: Use the attached formulas for your financial ratio calculations. Do not use financial ratio formulas from other sources for this assignment. NOTE: lululemon's Fiscal 2015 ended 01/31/2016. Next, estimate (forecast) lululemon's Fiscal 2020 Revenues, Net Income and Earnings Per Share (EPS). Assumptions for your forecast: 1. All of lululemon's physical retail operations worldwide will be either partially or completely closed between March 1, 2020 and August 31, 2020. 2. Lululemon will continue to pay the salaries for all current employees during Fiscal 2020. 3. Lululemon will continue to remain current on all physical property leases worldwide for Fiscal 2020. 4. Year End Stock Share Outstanding remains constant from Fiscal 2019 to Fiscal 2020. NOTE: lululemon's Fiscal 2020 forecast is subject to forecasting error. 7 A 8 1 lululemon athletica, inc. 2 Financial Analysis Fiscal Years 2015-2020 3 Numbers in Thousands, Except where Indicated 4 NOTE: These are Fiscal Years. For example, Fiscal 2015 ends 01-31-2016 5 NOTE: Fiscal 2020 is a Forecast, and is subject to forecast error. 6 9 INCOME STATEMENT 10 11 Total Revenue ($ actual) 12 Total Revenue (in thousands) 13 Total Revenue (in millions) 14 Total Revenue (in billions) 15 Revenue 1 Year Growth Rate 16 17 Total Revenue CAGR 2015-2019 18 19 Gross Profit 20 Gross Margin 21 22 Selling, General & Admin Expens 23 24 Operating Income 25 Operating Margin 26 27 Net Income (NI) 28 NI 1 Year Growth Rate 29 30 Return on Sales (ROS) 31 B 32 Return on Assets (ROA) 33 Fiscal 2015 $2,060,523,000 $2,060,523 $2,061 $2.06 14.65% $997,166 48.39% $628,090 $369,076 17.91% $266,047 11.30% 12.91% C 20.25% Fiscal 2016 $2,344,392,000 $2,344,392 $2,344 $2.34 13.78% $1,199,617 51.17% $778,465 $421,152 17.96% $303,381 14.03% 12.94% D 18.30% Fiscal 2017 $2,649,181,000 $2,649,181 $2,649 $2.65 13.00% $1,398,790 52.80% $904,264 $456,001 17.21% $258,662 -14.74% 9.76% 12.94% E Fiscal 2018 FL Fiscal 2019 G Fiscal 2020 A 29 30 Return on Sales (ROS) 31 32 Return on Assets (ROA) 33 34 Return on Equity (ROE) 35 36 Year End Stock Shares Outstandi 37 38 EPS-Diluted ($ per share) 39 40 41 42 BALANCE SHEET 43 44 Current Assets 45 Inventories 46 Current Liabilities 47 48 Current Ratio. 49 50 Quick Ratio 51 52 Total Debt (Liabilities) 53 Total Assets 54 Total Shareholder Equity 55 56 Debt to Asset Ratio (D/A) 57 58 Debt to Equity Ratio (D/E) 59 60 Total Revenues 61 Total Assets 62 Fixed Assets (PP&E, Net) 63 64 Total Asset Turnover (TAT) 65 66 Fixed Asset Turnover (FAT) B 12.91% 20.25% 25.89% 137,286 $1.89 2015 $917,039 $284,009 $225,504 4.07 2.81 21.81% 27.89% $2,060,523 $1,314,077 $349,605 1.57 с 5.89 12.94% 18.30% 22.31% 137,085 $2.21 $286,595 $297,568 $1,314,077 $1,657,541 $1,027,482 $1,359,973 2016 $1,162,737 $298,432 $241,449 4.82 3.58 17.95% 21.88% $2,344,392 $1,657,541 $423,499 1.41 5.54 D 9.76% 12.94% 16.20% 135,431 2017 $1.90 $1,436,282 $329,562 $292,598 4.91 3.78 $401,523 $1,998,483 $1,596,960 20.09% 25.14% $2,649,181 $1,998,483 $473,642 1.33 5.59 E 2018 F 2019 G 2020 H Complete the lululemon athletica, inc. 2015-2020 spreadsheet with your calculations of the indicated financial ratios (green boxes). Calculate your financial ratios for Fiscal 2018 and Fiscal 2019 from the attached income statements and balance sheets for lululemon athletica. NOTE: Use the attached formulas for your financial ratio calculations. Do not use financial ratio formulas from other sources for this assignment. NOTE: lululemon's Fiscal 2015 ended 01/31/2016. Next, estimate (forecast) lululemon's Fiscal 2020 Revenues, Net Income and Earnings Per Share (EPS). Assumptions for your forecast: 1. All of lululemon's physical retail operations worldwide will be either partially or completely closed between March 1, 2020 and August 31, 2020. 2. Lululemon will continue to pay the salaries for all current employees during Fiscal 2020. 3. Lululemon will continue to remain current on all physical property leases worldwide for Fiscal 2020. 4. Year End Stock Share Outstanding remains constant from Fiscal 2019 to Fiscal 2020. NOTE: lululemon's Fiscal 2020 forecast is subject to forecasting error. 7 A 8 1 lululemon athletica, inc. 2 Financial Analysis Fiscal Years 2015-2020 3 Numbers in Thousands, Except where Indicated 4 NOTE: These are Fiscal Years. For example, Fiscal 2015 ends 01-31-2016 5 NOTE: Fiscal 2020 is a Forecast, and is subject to forecast error. 6 9 INCOME STATEMENT 10 11 Total Revenue ($ actual) 12 Total Revenue (in thousands) 13 Total Revenue (in millions) 14 Total Revenue (in billions) 15 Revenue 1 Year Growth Rate 16 17 Total Revenue CAGR 2015-2019 18 19 Gross Profit 20 Gross Margin 21 22 Selling, General & Admin Expens 23 24 Operating Income 25 Operating Margin 26 27 Net Income (NI) 28 NI 1 Year Growth Rate 29 30 Return on Sales (ROS) 31 B 32 Return on Assets (ROA) 33 Fiscal 2015 $2,060,523,000 $2,060,523 $2,061 $2.06 14.65% $997,166 48.39% $628,090 $369,076 17.91% $266,047 11.30% 12.91% C 20.25% Fiscal 2016 $2,344,392,000 $2,344,392 $2,344 $2.34 13.78% $1,199,617 51.17% $778,465 $421,152 17.96% $303,381 14.03% 12.94% D 18.30% Fiscal 2017 $2,649,181,000 $2,649,181 $2,649 $2.65 13.00% $1,398,790 52.80% $904,264 $456,001 17.21% $258,662 -14.74% 9.76% 12.94% E Fiscal 2018 FL Fiscal 2019 G Fiscal 2020 A 29 30 Return on Sales (ROS) 31 32 Return on Assets (ROA) 33 34 Return on Equity (ROE) 35 36 Year End Stock Shares Outstandi 37 38 EPS-Diluted ($ per share) 39 40 41 42 BALANCE SHEET 43 44 Current Assets 45 Inventories 46 Current Liabilities 47 48 Current Ratio. 49 50 Quick Ratio 51 52 Total Debt (Liabilities) 53 Total Assets 54 Total Shareholder Equity 55 56 Debt to Asset Ratio (D/A) 57 58 Debt to Equity Ratio (D/E) 59 60 Total Revenues 61 Total Assets 62 Fixed Assets (PP&E, Net) 63 64 Total Asset Turnover (TAT) 65 66 Fixed Asset Turnover (FAT) B 12.91% 20.25% 25.89% 137,286 $1.89 2015 $917,039 $284,009 $225,504 4.07 2.81 21.81% 27.89% $2,060,523 $1,314,077 $349,605 1.57 с 5.89 12.94% 18.30% 22.31% 137,085 $2.21 $286,595 $297,568 $1,314,077 $1,657,541 $1,027,482 $1,359,973 2016 $1,162,737 $298,432 $241,449 4.82 3.58 17.95% 21.88% $2,344,392 $1,657,541 $423,499 1.41 5.54 D 9.76% 12.94% 16.20% 135,431 2017 $1.90 $1,436,282 $329,562 $292,598 4.91 3.78 $401,523 $1,998,483 $1,596,960 20.09% 25.14% $2,649,181 $1,998,483 $473,642 1.33 5.59 E 2018 F 2019 G 2020 H

Answer rating: 100% (QA)

To calculate the financial ratios for Fiscal 2018 and Fiscal 2019 we will use the information provid... View the full answer