need help in solving financials for Netflix case (Netflix's 2020 Strategy for Battling Rivals in the Global Market for Streamed Video Subscribers), exactly like Lululemon's
need help in solving financials for Netflix case (Netflix's 2020 Strategy for Battling Rivals in the Global Market for Streamed Video Subscribers), exactly like Lululemon's example below with explanations:
- Financial Analysis (4 pages max) D2L Financial Template (16 marks for all calculations; 4 marks for noting the relevant strategic impacts and stating a general conclusion.)
Evaluate the current financial health of the company by presenting your findings of relevant financial information based on a subset of the following:
Ratios: 1) liquidity 2) profitability, 3) leverage, 4) efficiency, 5) operating, and 6) market value and investment ratios. (See the template)
Also, using trend analysis, and/or common size analysis, and/or longitudinal analysis based on CAGR (Compound Annual Growth Rate see CAGR in Investopedia.com ) to either reinforce staying with the companys status quo or to suggest changes in strategy in light of the results.
If applicable, also include competitive financial analysis and/or other relevant financial findings by investigating all quantitative information provided.
For each of your calculations or observations note whether a trend is up, down or flat (see template) and note the strategic impact of each finding.
A concluding summary statement should address the strategic implications arising from your analysis of the financial health of the company.
Thank you
need help in solving financials for Netflix case (Netflix's 2020 Strategy for Battling Rivals in the Global Market for Streamed Video Subscribers), exactly like example below:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669a3a5c1d981_515669a3a5b7d08e.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669a3a5cdbad4_516669a3a5c4ae8a.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669a3a5dd388e_517669a3a5d41f76.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669a3a5eaa3a9_518669a3a5e20f2d.jpg)
Trend CAGR 2291 16% 17% 26% 1314.1 47% 18% 13% 22% 21% 25% Financial and Operational Highlights, Lululemon's athletica, Fiscal Years 2015-2019 (dollars in millions) Balance Sheet Balance Sheet in millions 2015 2016 2017 2018 2019 Cash and cash equivalents $ 501.5 $ 734.8 $ 990.5 $ 881.3 $ 1,093.5 Inventories 284 298.4 329.6 404.8 518.5 Stockholders' Equity 1027.5 1360 1597 1446 1952.2 Total Assets 1657.5 1998.5 2084.7 3281.4 Total Liabilities 286.6 297.5 401.5 638.7 1329.2 Selected Income Statement Data Selected Income Statement Data Net Revenues 2060.5 2344.4 2649.2 3288.3 3979.3 COGS 1063.4 1144.7 1250.4 1472 1755 Gross Profit 997.2 1199.6 1398.8 1816.3 2223.4 Selling, general and administrative expenses 628.1 778.5 904.3 1110.5 1334.3 Operating Profit 369.1 421.2 456 705.8 889.1 Net Profit (loss) $ 266.0 $ 303.4 $ 258.7 $ 483.8 $ 645.6 Foreign currency translation adjustment -64.8 36.7 58.6 -73.9 -7.8 Comprehensive Income $ 201.3 $ $ 340.1 $ 317.2 $ 409.9 $ 637.8 Earnings per share-basic $ 1.9 $ 2.2 $ 1.9 $ 3.6 $ 5.0 Earnings per share-diluted $ $ 1.9 $ 2.2 $ 1.9 $ 3.6 $ 4.9 Cash Flow and Other Data Cash Flow and Other Data Net Cash provided by Operating Activities $ 298.7 $ 385.1 $ 489.3 $ 742.8 $ 669.3 Capital Expenditures 143.5 149.5 157.9 225.8 283.1 Store Data Store Data Number of corporate-owned stores at the end of the period 363 404 440 491 Sales per gross square foot at corporate-owned stores open at leas $ 1,541.0 $ 1,521.0 $ 1,554.0 $ 1,579.0 $ 1,657.0 Average sales at Corporate-owned stores open at least one year 4.57 4.47 4.68 4.78 5.18 Quarterly E-Commerce Sales Quarterly E-commerce Sales million Q1 Q2 Q3 Q4 2018 157.8 167.4 189.4 344.2 2019 209.8 217.6 246.7 463.7 2020 352 Profitability Ratios 25% -41% 33% 27% 27% 22% 19% 406 8% 2% 3% 30% 30% Year 1 Year 2 Year 3 Year 4 Year 5 Trend 48% 18% 13% 20% 26% 51% 18% 13% 18% 22% 53% 17% 10% 13% 16% 55% 21% 15% 23% 33% 5696 2296 16% 20% 3396 Profitability Ratios Gross Profit Margin= Operating Profit Margin= Net Profit ROA Return on Total Assets = ROE Return on Equity = Efficiency Ratios Efficiency Ratios Sales Revenue per Number of Corporate-owned stores Inventory Turnover = Total Assets Turnover = Return on Capital Employed = $ 5.676 $ 5.774 $ 3.744 3.836 1.568 1.414 22% % 6.557 $ 3.794 1.326 16% 7.473 $ 3.636 1.577 33% 8.104 3.385 1.213 3396 MOTI 26% Liquidity Ratios Liquidity Ratios Current Ratio = 4.585 5.571 4.978 3.264 2.469 Acid or Quick Test = 3.594 4.568 4.157 2.630 2.079 Working Capital = $1,027.50 $ 1,360.00 $1,597.00 $1,446.00 $1,952.20 Leverage Ratios Leverage Ratios Total Liabilities to Total Assets = 22% 18% 20% 31% 41% Liabilities to Equity Ratio = 0.279 0.219 0.251 0.442 0.681 Operating Measures Operating measures General & Administrative Expenses 30% 33% 34% 34% 34% Lululemon's athletica's Revenues and Income from Operations, by Business Segment, Geographic Region, and Product Category, Fiscal Years 2015-2019 (dollars in millions) Revenues by Business Segment Revenues by Business Segment 2016 2017 2018 2019 2020 CAGR Trend Corporate-owned stores $ 1,516.3 $ 1,704.4 $ 1,837.1 $ 2,126.4 $ 2,501.1 13% Direct-to-consumer (e-commerce sales) 401.5 453.3 577.6 858.9 1137.8 30% All other channels 142.7 186.7 234.5 303.1 340.4 24% Total $ 2,060.5 $2,344.4 $ 2,649.2 $ 3,288.4 $ 3,979.3 18% Percentage Distribution of Revenues by Business Segment Percentage Distribution of Revenues by Business Segment Corporate-owned stores 73.6 72.7 69.3 64.7 62.9 -4% Direct-to-consumer (e-commerce sales) 19.5 19.3 21.8 26.1 28.6 All other channels 6.9 8 8.9 9.2 8.5 5% Income from Operations (before general corporate expenses), by Business Segment Income from Operations (before general corporate expenses), by Business Segment Corporate owned stores $ 346.8 $ 415.6 $ 464.3 $ 575.5 $ 689.3 19% Direct-to-consumer (E-commerce sales) 166.4 186.2 224.1 354.1 482.4 30% All other channels 5.8 22.3 35.6 62.6 72.6 88% Total Income from Operations before ... $ 519.0 $ 624.1 $ 724.0 $ 992.2 $ 1,244.3 24% Revenues by Geographic Region Revenues by Geographic Region United States 1508.8 1726.1 1911.8 2363.4 2854.4 17% Canada 416.5 447.2 491.8 565.1 649.1 12% Outside of North America 135.2 171.1 245.6 359.8 475.8 37% $ 2,060.5 $ 2,344.4 $ 2,649.2 $ 3,288.3 $ 3,979.3 18% Revenues by Product Category Revenues by Product Category Women's Product $ 1,892.6 $ 2,352.8 $ 2,791.0 21% Men's Product 526.5 694.9 933.8 33% Other Categories 230 240.6 254.5 5% 10% Total Analysis Balance Sheet Looking at the balance sheet and its data, all of the trends are positive indicating a good performance by Lululemon throughout the years. It shows good business growth and performance. Selected Income Statement Data Looking at the selected income statement data, I can see that almost all the trends are positive and are going up excluding foreign currency translation adjustment. This is good as Lululemon is spending more. They are also making more in return at almost a steady rate. Cash Flow and Other Data Both have good CAGRs but net cash provided by operating activities has gone down since last year, that is something to keep in mind as more years go by. Store Data The store data for Lululemon has shown that they have made significant growth with the number of stores growing at the sales going up as well with relation to the number of stores. Quarterly E-Commerce Sales The e-commerce sales have gone up each year on an upward trend. Every quarter has increased per year. The fourth quarter being the most popular, most likely due to the holiday season. Profitability Ratios All of the profitability ratios have positive trends indicating good financial performance from looking at the trends. Year 3 must not have been a good year but after that Lululemon has been doing well. Efficiency Ratios Looking at the trends of the efficiency ratios they all have varying trends. Sales revenue per store has a steady positive trend while inventory turnover has a negative trend but still kept relatively the same value. Total asset turnover also had the same trend except its gone positive this past year. ROCE also has gone positive in the past years as well. Liquidity Ratios The current ratio and the quick test for Lululemon is on a negative trend which is not a good indicator for their performance. However, they are still expanding as a company. Working Capital is still a positive trend. Leverage Ratios Both of the leverage ratios have positive trends indicating good company performance. Operating Measures The general and administrative expenses have gone up in the past years but only minimal increases, while having much larger economic growth relative to their expenses. Revenues by Business Segment The revenues by business segment has a positive trend with an emphasis on the e-commerce sales having a stronger positive trend. Percentage Distribution of Revenues by Business Segment For these trends we can see that the growth of e-commerce sales is growing much faster which is causing the trend for corporate-owned stores to have a negative trend. Income from Operations (before general corporate expenses), by Business Segment Looking at the income from operations we can see similar trends as the revenue by business segment trends. The trends are positive and the income from all other channels has seen enormous growth through the years. Revenues by Geographic Region Looking at the trends for the revenue by geographic region, all the trends are positive and the values show positive growth throughout the years, and the revenue outside of North America shows the successful expansion of Lululemon based on its CAGR. Revenues by Product Category Looking at the revenue by product category, all the trends are positive with a higher CAGR in men's products. Conclusion After analyzing all the financial data of Lululemon, it can be concluded that they are doing well and have good financial performances as well as succeeding in their efforts of expansion. Trend CAGR 2291 16% 17% 26% 1314.1 47% 18% 13% 22% 21% 25% Financial and Operational Highlights, Lululemon's athletica, Fiscal Years 2015-2019 (dollars in millions) Balance Sheet Balance Sheet in millions 2015 2016 2017 2018 2019 Cash and cash equivalents $ 501.5 $ 734.8 $ 990.5 $ 881.3 $ 1,093.5 Inventories 284 298.4 329.6 404.8 518.5 Stockholders' Equity 1027.5 1360 1597 1446 1952.2 Total Assets 1657.5 1998.5 2084.7 3281.4 Total Liabilities 286.6 297.5 401.5 638.7 1329.2 Selected Income Statement Data Selected Income Statement Data Net Revenues 2060.5 2344.4 2649.2 3288.3 3979.3 COGS 1063.4 1144.7 1250.4 1472 1755 Gross Profit 997.2 1199.6 1398.8 1816.3 2223.4 Selling, general and administrative expenses 628.1 778.5 904.3 1110.5 1334.3 Operating Profit 369.1 421.2 456 705.8 889.1 Net Profit (loss) $ 266.0 $ 303.4 $ 258.7 $ 483.8 $ 645.6 Foreign currency translation adjustment -64.8 36.7 58.6 -73.9 -7.8 Comprehensive Income $ 201.3 $ $ 340.1 $ 317.2 $ 409.9 $ 637.8 Earnings per share-basic $ 1.9 $ 2.2 $ 1.9 $ 3.6 $ 5.0 Earnings per share-diluted $ $ 1.9 $ 2.2 $ 1.9 $ 3.6 $ 4.9 Cash Flow and Other Data Cash Flow and Other Data Net Cash provided by Operating Activities $ 298.7 $ 385.1 $ 489.3 $ 742.8 $ 669.3 Capital Expenditures 143.5 149.5 157.9 225.8 283.1 Store Data Store Data Number of corporate-owned stores at the end of the period 363 404 440 491 Sales per gross square foot at corporate-owned stores open at leas $ 1,541.0 $ 1,521.0 $ 1,554.0 $ 1,579.0 $ 1,657.0 Average sales at Corporate-owned stores open at least one year 4.57 4.47 4.68 4.78 5.18 Quarterly E-Commerce Sales Quarterly E-commerce Sales million Q1 Q2 Q3 Q4 2018 157.8 167.4 189.4 344.2 2019 209.8 217.6 246.7 463.7 2020 352 Profitability Ratios 25% -41% 33% 27% 27% 22% 19% 406 8% 2% 3% 30% 30% Year 1 Year 2 Year 3 Year 4 Year 5 Trend 48% 18% 13% 20% 26% 51% 18% 13% 18% 22% 53% 17% 10% 13% 16% 55% 21% 15% 23% 33% 5696 2296 16% 20% 3396 Profitability Ratios Gross Profit Margin= Operating Profit Margin= Net Profit ROA Return on Total Assets = ROE Return on Equity = Efficiency Ratios Efficiency Ratios Sales Revenue per Number of Corporate-owned stores Inventory Turnover = Total Assets Turnover = Return on Capital Employed = $ 5.676 $ 5.774 $ 3.744 3.836 1.568 1.414 22% % 6.557 $ 3.794 1.326 16% 7.473 $ 3.636 1.577 33% 8.104 3.385 1.213 3396 MOTI 26% Liquidity Ratios Liquidity Ratios Current Ratio = 4.585 5.571 4.978 3.264 2.469 Acid or Quick Test = 3.594 4.568 4.157 2.630 2.079 Working Capital = $1,027.50 $ 1,360.00 $1,597.00 $1,446.00 $1,952.20 Leverage Ratios Leverage Ratios Total Liabilities to Total Assets = 22% 18% 20% 31% 41% Liabilities to Equity Ratio = 0.279 0.219 0.251 0.442 0.681 Operating Measures Operating measures General & Administrative Expenses 30% 33% 34% 34% 34% Lululemon's athletica's Revenues and Income from Operations, by Business Segment, Geographic Region, and Product Category, Fiscal Years 2015-2019 (dollars in millions) Revenues by Business Segment Revenues by Business Segment 2016 2017 2018 2019 2020 CAGR Trend Corporate-owned stores $ 1,516.3 $ 1,704.4 $ 1,837.1 $ 2,126.4 $ 2,501.1 13% Direct-to-consumer (e-commerce sales) 401.5 453.3 577.6 858.9 1137.8 30% All other channels 142.7 186.7 234.5 303.1 340.4 24% Total $ 2,060.5 $2,344.4 $ 2,649.2 $ 3,288.4 $ 3,979.3 18% Percentage Distribution of Revenues by Business Segment Percentage Distribution of Revenues by Business Segment Corporate-owned stores 73.6 72.7 69.3 64.7 62.9 -4% Direct-to-consumer (e-commerce sales) 19.5 19.3 21.8 26.1 28.6 All other channels 6.9 8 8.9 9.2 8.5 5% Income from Operations (before general corporate expenses), by Business Segment Income from Operations (before general corporate expenses), by Business Segment Corporate owned stores $ 346.8 $ 415.6 $ 464.3 $ 575.5 $ 689.3 19% Direct-to-consumer (E-commerce sales) 166.4 186.2 224.1 354.1 482.4 30% All other channels 5.8 22.3 35.6 62.6 72.6 88% Total Income from Operations before ... $ 519.0 $ 624.1 $ 724.0 $ 992.2 $ 1,244.3 24% Revenues by Geographic Region Revenues by Geographic Region United States 1508.8 1726.1 1911.8 2363.4 2854.4 17% Canada 416.5 447.2 491.8 565.1 649.1 12% Outside of North America 135.2 171.1 245.6 359.8 475.8 37% $ 2,060.5 $ 2,344.4 $ 2,649.2 $ 3,288.3 $ 3,979.3 18% Revenues by Product Category Revenues by Product Category Women's Product $ 1,892.6 $ 2,352.8 $ 2,791.0 21% Men's Product 526.5 694.9 933.8 33% Other Categories 230 240.6 254.5 5% 10% Total Analysis Balance Sheet Looking at the balance sheet and its data, all of the trends are positive indicating a good performance by Lululemon throughout the years. It shows good business growth and performance. Selected Income Statement Data Looking at the selected income statement data, I can see that almost all the trends are positive and are going up excluding foreign currency translation adjustment. This is good as Lululemon is spending more. They are also making more in return at almost a steady rate. Cash Flow and Other Data Both have good CAGRs but net cash provided by operating activities has gone down since last year, that is something to keep in mind as more years go by. Store Data The store data for Lululemon has shown that they have made significant growth with the number of stores growing at the sales going up as well with relation to the number of stores. Quarterly E-Commerce Sales The e-commerce sales have gone up each year on an upward trend. Every quarter has increased per year. The fourth quarter being the most popular, most likely due to the holiday season. Profitability Ratios All of the profitability ratios have positive trends indicating good financial performance from looking at the trends. Year 3 must not have been a good year but after that Lululemon has been doing well. Efficiency Ratios Looking at the trends of the efficiency ratios they all have varying trends. Sales revenue per store has a steady positive trend while inventory turnover has a negative trend but still kept relatively the same value. Total asset turnover also had the same trend except its gone positive this past year. ROCE also has gone positive in the past years as well. Liquidity Ratios The current ratio and the quick test for Lululemon is on a negative trend which is not a good indicator for their performance. However, they are still expanding as a company. Working Capital is still a positive trend. Leverage Ratios Both of the leverage ratios have positive trends indicating good company performance. Operating Measures The general and administrative expenses have gone up in the past years but only minimal increases, while having much larger economic growth relative to their expenses. Revenues by Business Segment The revenues by business segment has a positive trend with an emphasis on the e-commerce sales having a stronger positive trend. Percentage Distribution of Revenues by Business Segment For these trends we can see that the growth of e-commerce sales is growing much faster which is causing the trend for corporate-owned stores to have a negative trend. Income from Operations (before general corporate expenses), by Business Segment Looking at the income from operations we can see similar trends as the revenue by business segment trends. The trends are positive and the income from all other channels has seen enormous growth through the years. Revenues by Geographic Region Looking at the trends for the revenue by geographic region, all the trends are positive and the values show positive growth throughout the years, and the revenue outside of North America shows the successful expansion of Lululemon based on its CAGR. Revenues by Product Category Looking at the revenue by product category, all the trends are positive with a higher CAGR in men's products. Conclusion After analyzing all the financial data of Lululemon, it can be concluded that they are doing well and have good financial performances as well as succeeding in their efforts of expansion