can anybody answer all these questions? I will be providing with the financial content of the company Target.
Explore the annual report and financial statements to familiarize yourself with the company. 1. Provide a brief overview of the basic company information: history, primary products and services, primary markets, competitive situation and business strategy: 2. Who are the auditors and are there any concerns raised in the audit reports? Brief Balance Sheet Analysis: 3. What is the capital structure of the company: a) For the most recent year, what is the relative proportion of short-term assets to long-term assets? b) For the most recent year, what proportion of total assets is financed by owners? c) For the most recent year, what proportion of total assets is financed by non-owners? 4. For the most recent year, what are the company's largest assets and liabilities? 5. Examine Worksheet A common size and trend analysis, are there any major differences over time? Brief Income Statement Analysis: 6. is the company profitable? 11 Page 1 of 3 7. What are the company's major expenses? 8. Are there any transitory items (extraordinary or discontinued operations)? If so, are they large in magnitude? 9. Examine Worksheet B common size and trend analysis, are there any major differences over time? Statement of Cash Flows Analysis: 10. Operating Activities for the most recent year, is Net Cash Flow from Operating Activities (NCFOA) positive? a. b. Has there been an overall increase or decrease in NCFOA from the base year to the most recent year? C. Is NCFOA increasing, decreasing or variable over the three year period? d. For the most recent year, is NCFOA smaller or larger than Net Income? e. What are the major differences between NCFOA and Net Income? What are the amounts for depreciation expense? f. Is the trend for NCFOA consistent with the trend for Net Income over the last three years? It not, are there any significant differences between NCFOA and Net Income that explain this inconsistency le 8. impairments, restructuring charges, stock-based compensation, deferred taxes, etc.)? 8 Briefly discuss, and interpret the NCFOA to Current Liabilities ratio for the three years. 11. Investing Activities For the most recent year, did the company purchase new property, plant, and equipment (Capital Expenditures)? If so, what is the amount for these purchases? a b. What is the horizontal trend for Capital Expenditures? Are the expenditures increasing (generally a healthy sign), stable, or decreasing (generally a company in decline)? C. Briefly discuss, and interpret, the NCFOA to Capital Expenditures ratio for the three years. Page 2 of 3 d BWhat is the horizontal trend for net cash flow for investments only (short-term and long- term)? Calculate, and include, the net amounts for cash flows for investments for each year. e. Did the company acquire any businesses during the three years? If so, which year(s), and was it a significant amount? a. Financing Activities What is the horizontal trend for net cash flow for debt only (short-term and long-term)? Calculate, and include, the net amounts for cash flows from debt for each year. b During the three years, did the company issue new stock? If so, what type of stock (common and/or preferred) and what was the trend over the three years? c During the three years, did the company repurchase treasury stock? If so, what was the trend over the three During the three years, did the company pay any cash dividends? If so, what was the trend over the three years? 11 IN WER 1 BE ttain SE GE 4 NE RE * EL WE W SR G LE ELE SA 30 1 3 BIL VEL - HE H LE LL LE Gingham CONDENADINCOME TATIMENT Tecal winter BEBE 11 11 66205 LE HEZ 2 TO 1 V 245 11 nen 25 e 13 w 5 tors Recent 5 S SHE 3317 SR 11 15 Tamrodhury Decoder VERTICAL AREVUS Camry CONOINS COMMON SE INCOME STATEMENT warded Manch/Owl MA 2020 1000 ! 0 SRL P poti 20 292 DON 222 000 SIE Oro WOTE 41 Na 090 MOS WS SIE 000 12 LAN 11 Det eneste DON NO D VS MU 44 Ne et to compenyo 40 . 4 NOT NE 00 11 HORIZONTAL ANALYSIS 14 Conne CONDENSED TREND ANALYSES INCOME STATEMENT Fiscal Yearded that M 2011 2013 20 2010 2419 DS Odd 10000 100 ES TROR 1.000 1619 10 DO TI TE 13 300 16 RE NOR 1000 10 15 from 1 Trans SHOP ONOR NODOC 214 111 WI TLAN IL TIN WOOL 100 1000 BI CH NOR Mine Code AN 15 TODO La NEWS 10.50 Draw Insert Home Formulas Data Review View ME M Calibri (Body) 11 B 1 be x D 3 4 1 2 Worksheet C: Statement of Cash Flows Analysis Use your company's 10K's to complete the following Statement of Cash Flows for the most recent year end and the previous year ends 3 4 S 6 7 Company Name CONDENSED STATEMENT OF CASH FLOW Fiscal Year Ended (Month/Day) Year-end 30-Jan 1-Feb 8 2-Feb 9 (5 in millions) 2019 10 $ S $ 2021 10,525 (2,591) s 12.000) 2020 7.117 S (2,944) $ (3,152) 5.973 (3.416) (3,644) 11 Net cash from operating activities 12 Net cash from investing activities 13 Net cash from financing activities 14 Effect of exchange rate on cashif applies 15 Net change in cash 5.934 S 1,0215 $ (1,087) 16 17 2-Feb 2019 100.00 18 HORIZONTAL ANALYSIS 19 Company Name 20 CONDENSED TREND ANALYSIS STATEMENT OF CASH FLOWS 21 Fiscal Year Ended (Month/Day) 22 30-Jan 1.Feb Year-end 23 2021 2020 24 Net cash from operating activities 76.219 19.15% 25 Net cash from investing activities -24.15% -13.82% 26 Net cash from financing activities -45:12% - 13.50% 27 Effect of exchange rate on cash #DIV/01 #DIV/0! 28 Net change in cash -645.91% - 193.93% 29 100.00 100.00 100.00 100.00 30 Year -1? Most recent year? 26 Year-2? 2019 2020 02 0.49 0.40 -3.97 -2.35 -1.70 31 32 Show the following ratio: 33 34 Operating Cash Flow to Current Liabilities 35 Operating Cash Flow to Capital Expenditures Net Cash from Operations to Net Income for 36 years net income is postive 37 38 Capital Expenditure 2.17 2.03 -2649 -3027 -3516 39 40 41 42 43 TARGET CONDOMANCE SHEET halded 2002 7 He Om Year 5S 2477 214 13 18 cah Accounts Rece Inn Ourent Total Current Auto 11 1.125 207565 2015 3275 3116 $1,245 02 13 12.303 26, 2011 123615 125 0227 5 5 5 5 5 5. US 12.3199 25515 LS 123 A 1905 17 18 1 1417 Good Olhar com as TA 20 21 Currenties 5 $ 5 20.125 16.68 16.00 1201 SOS 14.45 16499 30,465 5 15014 14291 1995 23 Tots M 53 1 5 25 6765 45 60SS 601715 20 27 20 Conte capital Betained The stock Other AG Total Company Stockholders'uty Nointer apples Total Storholdene Equity 5 os 14,440 R$ 11.8335 Posis 11.29715 11.200 29 14, 4105 11.8335 11.2975 11,709 31 2. 33 34 Total Labs Stockholders Tiquity 5 51.240 0.75 41.290.5 Other players that are not provided in the categories above Note Contributed Capital - indade Common stock, Preferred stock, and Additional Paid in Capital 15 Year-3 Most recent year? Year 27 3000 7018 38 Show the following rate CASCLabel Working Capital 2010 12:40 2031 615 103 SUS 39 DV 10 Current Ratio 41 42 41 45 16 Yea-17 47 BOER 2021 48 2012 3.77 0.OON 21.00 VERTICAL ANALYSIS TARGET CONDENSEO COMMON SIZE BALANCE SHEET Fiscal Year Ended than 10, 2021) Most recent year? Year? Year-end 2000 0.17 6:09 OOON GOON 20.79 2102 211% 3.12% 20, 50% 30.10 5241 61 445 521 ON 100.00 100 RON Cash Accounts Receivable Inventory Other Assets Total Current Assets SO 51 52 355 2012 67 0.00 22201 120 12.22 41 DOON BEN 100 OK 5 40 43 55 90 Goodwill intances Otherton Asunt Total Assets 21 100.00 58 59 30.22 UN 361 EN98 60 36 36 MR 72.6% 0.00% Noncurrent tables Total Liabilities 61 DON 210X 0.00% 12:41 17.22% 0.00 33 MON 3847 72 343 OOON 14.65 150 0.00 2015 27 N 14.74 14 57% 6 0.00% Contributed capital Retained earnings Treasury stock Other SACI Total Company Stockholders' Equity Noncontrollo interest applies Total Stockholders' Equity 1630 OOON 1925 20.00 65 57 -1999 27.36% DON 27-16 28 18% BOX 20 GOON 10 8 27.66 0001 0.02 ON 100 BOX 70 LOON 100.00 TARGET Year-37 2019 2018 6.78 3.72% Cash Accounts Receivable 0.00% 23.00% CONDENSED COMMON SIZE BALANCE SHEET Fiscal Year Ended Jan 30, 2021) Most recent year? Year end Year-17 2021 2030 0.17% 6.02% 0.00% 20.79% 21.02% 3.11% 3.12% 40.50% 30.16% 52.45% 61 44% 4.35% 5.23% 2. 70 3.17% 100.00% 100.00% 0.00% 22204 3.24% 3.55% 30.32% 61.84% 32.22% Inventory Other Current Assets Total Current Assets PPE, net Goodwill & Intangibles Other long term Assets Total Assets 4.76% 64.15% 0.00% 3.63% 3.08 100.00% 100.00% 36 36 39.27% 32 55% 33.86% 38.42% 72.34% Current liabilities Noncurrent Liabilities Total Liabilities 36,28% 33 85% 36 13% 69,98% 71.82% 0.00% 12.43% 0.00% 72.64% D.BOX 14.74% 14.57% 14.65% 15.04 DOON 15.14% 16 RON OOON Q.COM 17.22% 0.00% -1.48% 0.00% 192% -2,03% -1.95 Contributed capital Retained earnings Treasury stock Other SADA Total Company Stockholders' Equity Noncontrolling Interest, if applies Total Stockholders' Equity 30.02% 28.18% 27.36% 0.00% 0.00% 28 10 27.66% O. 27.66% 0.001 10.00 27.36 0.00% 100.00% 0.00% 100.00% 0.00 30.02% 0.00% 100.00% Total Liabilities & Stockholders' Equity HORIZONTAL ANALY TARGET CONDENSED TREND ANALYSISBNCE SHEET Fiscal Year Ended (lan 3021) Most recent year? Year-22 Base Year? Year-end 2018 2019 41.13% Cash Accounts Receivable 100.00 100.00 100.00 DIV/01 9.70% 15.9% -0.36% 100.00 100.00 206% 100.00 2021 22202% ON/OI 23.06% 25.95% 65 2046 7.46% DIV/01 2. 19% 31.41% DIV/01 52.45% 18.41% Inventory Other Current Assets Total Current Assets PPE, net Goodwill & Intangibles Other Long term Assets Total Assets 100.00 01/01 -10 16 5.87% 100 00 100.00 13.73% 6.32 Current babies Longterm Liabilities Total Liabilities DIV/0! 387% 5.46% 269% 5.06% #DIV/01 4.16% 9.69% #DIV/0! 976% 16 82 13.40% EDIV/01 6.18% 1 83% DIV/O 16 20% 1 06 DIV/01 1.06% DIV/ 9.69% 100.00 100.00 100.00 9.90% 34.8% DIV/01 HONV/01 3.08% 7.93% -8.18% 34 67% Contributed capital Retained earnings Treasury stock Other SE AOC Total Company Stockholders' Equity Non controlling Interest if applies Total Stockholders' Equity #DIV/01 120 23.32% DIV/0! 28 32 DIV/01 31.41 ON/O 7.76% -352 DIV/01 -352 DIVO 5.87% 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 Total Liabilities & Stockholders' Equity 6 7 B 2-Feb 9 (s in millions) Company Name CONDENSED INCOME STATEMENT Fiscal Year Ended (Month/Day) 30-lan Year end 2021 $ 93,561 $ $ 66,1775 $ 27,3845 2019 10 1 Feb 2020 78,1125 54,8645 23,2485 11 75,356 53,299 22,057 Sales revenue Cost of good sold Gross profit 12 13 14 15 Operating expenses Operating income $ $ 20,8455 6.539 S 18,5905 4,658$ 17.947 4,110 16 17 18 $ Nonoperating expenses and revenues 9935 5,546 S 4685 4 190$ 434 3,676 $ 19 Income before income taxes 20 746 21 Provision for income tax (Tax expense) Income from continuing operations $ s 1,1785 4,368 921 $ 3,2695 2.930 22 23 S 7 24 12S 3,281 S $ 25 4,368 2,937 Transitory/Nonrecurring items if applies Net Income Net income attributable to Noncontrolling Interests Net Income attributable to Company Stockholders 26 $ 4,368 S 3,2815 2,937 27 28 5.55 29 Earnings per share Earnings per share-Diluted $ $ 8.725 8.643 6.42 S 6.365 5.51 30 31 32 Note: Transitory/Nonrecurring items - includes Extraordinary items and/or Discontinued Operations 33 34 35 36 37 VERTICAL ANALYSIS Company Name CONDENSED COMMON SIZE INCOME STATEMENT Fiscal Year Ended (Month/Day) Most recent year? Year -17 Year-end 2021 2020 38 Year -22 39 2019 40 41 100.00% 100.00% 100.00% 42 70.73% 70.24% Sales revenue Cost of good sold Gross profit (Gross profit %) 43 70.73% 29.27% 0.00% 29.76% 29.27% 0.00% 23.82% 44 0.00% 45 22.28% 23.80% Operating expenses Operating income 46 6.99% 5,45% 47 0.00% 0.00% 48 1.06% 5.96% 0.00% 0.60% 5.36% 0.00% Nonoperating expenses and revenues Income before income taxes 0.58% 49 5.93% 4.88% 50 0.00% 0.00% 1.26% 1.18% 0.99% 51 52 Provision for Income tax (Tax expense) Income from continuing operations 4.67% 4.19% 3,89% 53 0.00% 0.00% 0.00% 54 Transitory/Nonrecurring items if applies 0.00% 0.02% 0.01% 55 Net Income 4.67% 4.20% 3.90% 35 VERTICAL ANALYSIS 36 37 38 Company Name CONDENSED COMMON SIZE INCOME STATEMENT Fiscal Year Ended (Month/Day) Most recent year? Year-12 Year-end 2021 2020 100.00% 100.00% Year -22 39 2019 40 100.00% 41 42 70.24% 70.73% Sales revenue Cost of good sold Gross profit Gross profit) 43 70.73% 29,27% 0.00% 29.76% 0.00% 23.80% 29.27% 0.00% 45 22.28% 23.82% Operating expenses Operating income 46 6.99% 5.96% 5.45% 47 0.00% 0.00% 48 1.06% 0.00% 0.60% 5.36% Nonoperating expenses and revenues Income before income taxes 0.58% 49 5.93% 4.88% 50 0.00% 0.00% 0.00% 51 1.26% 0.99% Provision for income tax (Tax expense) Income from continuing operations 1.18% 4.19% 52 4.67% 3.89% 53 0.00% 0.00% 0.00% 54 Transitory/Nonrecurring items if applies 0.00% 0.02% 0.01% 55 Net Income 4.67% 3.90% 0.00% 56 0.00% 4.20% 0.00% 4.20% Net Income attributable to Noncontrolling Interests Net Income attributable to Company Stockholders 57 4.67% 3.90% 58 59 60 HORIZONTAL ANALYSIS 62 Company Name CONDENSED TREND ANALYSIS INCOME STATEMENT 63 64 65 Fiscal Year Ended (Month/Day) Most recent year? Year-end 2021 24.16% 24.16% .66 67 Year-17 2020 3.66% Base Year? 2019 100.00 68 Sales revenue Cost of good sold Gross profit 2.94% 100.00 69 24.15% 5.40% 100.00 70 68B%888 SENARES #DIV/0! 16.15% #DIV/0! 3.58% 100.00 71 72 Operating expenses Operating income 59.10% 100,00 13,33% NDIV/0! 73 #DIV/0! 74 128.80% Nonoperating expenses and revenues Income before income taxes 100.00 100.00 75 76 50,87% #DIV/0! 77 57.91% 7.83% 13.9836 #DIV/0! 23.46% 11.57% DIV/0! 71.43% Provision for income tax Tax expense) Income from continuing operations 100.00 78 49.08% 100.00 #DIV/0! 79 80 Transitory/Nonrecurring items if applies -100.00% 100.00 B1 Net Income 48.72% 11.71% 100.00 B2 Net Income attributable to Noncontrolling Interests Net Income attributable to Company Stockholders 83 100.00 84 #DIV/0! 48.72% #DIV/01 57.12% 56.81% #DIV/0! 11.71% #DIV/0! 15.68% BS 100.00 Earnings per share Earnings per share Diluted B6 15.43% 100.00 fx B D 4 1 - Worksheet C: Statement of Cash Flows Analysis Use your company's 10K's to complete the following Statement of Cash Flows for the most recent year end and the 2 previous year ends. 3 5 Company Name CONDENSED STATEMENT OF CASH FLOW Fiscal Year Ended (Month/Day) Year-end 30-Jan 5 2-Feb (S in millions) 2019 2021 $ $ $ 10,525 $ (2,591) $ (2.000) 1-Feb 2020 7,117 s (2.944) S (3,152) $ 5.973 (3,416) (3.644 1 Net cash from operating activities 2 Net cash from investing activities Net cash from financing activities Effect of exchange rate on cash - if applies Net change in cash 5 $ 5,934 S (1,087) 1,021 S 3 3 3 2-Feb 2019 HORIZONTAL ANALYSIS Company Name CONDENSED TREND ANALYSIS STATEMENT OF CASH FLOWS Fiscal Year Ended (Month/Day) 30-Jan 1-Feb Year-end 2021 2020 Net cash from operating activities 76.21% 19.15% Net cash from investing activities -24.15% -13.8296 Net cash from financing activities -45.12% - 13.50% Effect of exchange rate on cash #DIV/0! #DIV/0! Net change in cash -645.91% - 193.93% 100.00 100.00 100.00 100.00 100.00 Year -12 Year -22 Show the following ratio: Most recent year? 2011 02 2020 2019 0.49 0.40 -2.35 -3.97 -1.70 Operating Cash Flow to Current Liabilities Operating Cash Flow to Capital Expenditures Net Cash from Operations to Net Income for years net income is postive 2.17 2.03 1 -2649 -3027 -3516 Capital Expenditure 8:15 Files Assign 1 Spreadsheet copy m 8:16 Files Assign 1 Spreadsheet copy m 8:16 Files Assign 1 Spreadsheet copy
