Question

1 Approved Answer

Posted on Jul 14, 2024

A E F 2 Worksheet A: Balance Sheet Analysis Use your company's 10K's to complete the following abbreviated Balance Sheet for the most recent year

A E F 2 Worksheet A: Balance Sheet Analysis Use your company's 10K's to complete the following abbreviated Balance Sheet for the most recent year end and the 3 previous year ends. 3 4 5 6 7 8 9 (in millions) Year-end 10 Company Name CONDENSED BALANCE SHEET Fiscal Year Ended (Month/Day) host recent year Year - 12 Year -2? Year-3? 2020 2019 2018 2017 $ 3.216.752 $ 3.030,229 $ 2.758,477 $ 2,929,849 $ 386,261 $ 346,298 $ 327,166 $ 258,831 $ 4,872,592 $ 4,579,033 $ 4.187.243 $ 3,644,959 $ 415,017 $ 513,662 $ 706,6765 373,893 $ 8,890,622 $ 8,469,222 $ 8,485,727 $ 7,750,774 11 12 13 14 15 Cash Accounts Receivable Inventory Other Current Assets Total Current Assets PPE, net Goodwill & Intangibles Other Longterm Assets Total Assets 16 17 18 19 $ 95,546 $ 97,552 $ 100,069 $ 195,871 $ 761,323 $ 497,580 $ 14,058,015 $ 12,883,808 $ 24,145,003 $ 14,326,029 $ 14,058,015 $ 12,883,808 20 21 22 23 24 Current liabilities Longterm Liabilities Total Liabilities $ 7,150,247 $ 5,531,374 $ 5,125,537 $4,757,656 $ 11,046,544 $3,746,049 $ 3,784,169 $ 3,615,553 $ 18,196,791 $ 9,277,423 $ 8,909,706 $ 8,373,209 25 $ 26 27 28 Contributed capital $ 1.199.100 $ 1.217.183 $ 628,009 646,319 Retained earnings $ 5.422.283 $ 4,461,744$ 4,962,159 $ 4,558,506 Treasury stock Other SE/AOCI $ (673.171) $ (630,321) $ (441,859) $ (694,226) Total Company Stockholders' Equity $ 5,948,212 $ 5,048,606 $ 5,148,309 $ 4,510,599 Noncontrolling Interest - if applies Total Stockholders' Equity $ 5,984,212 5,048,606 $5,148,309 $ 4,510,599 29 30 31 32 33 34 Total Liabilities & Stockholders' Equi $ 24,145,003 $ 14,326,029 $ 14,058,015 $ 12,883,808 Other plus any items that are not provided in the categories above. Note: Contributed Capital - include common stock, Preferred stock, and Additional Paid in Capital 35 36 37 Most recent year Year -1? Year -2? Year-3? 2017 Show the following ratio: (use CA & CL above) Working Capital Current Ratio 39 2020 2019 2018 $ 1.740.375 $ 1.318.975 $ 1,335,480 $ 1.24 1.18 1.19 600,527 1.08 40 41 42 3:49 41 43 45 VERTICAL ANALYSIS Company Name CONDENSED COMMON SIZE BALANCE SHEET Fiscal Year Ended (Month Day Most recent year Year-end 2020 2017 13.3 2115 19. 42 43 40 Cash Accounts Receivable 201 319 29. 608 Other Current Total Current Assets PPT Goodwill Intangibles Other long-term Arts 2018 172 36.82% 59.00 0401 21 100.00% 55 59125 36 06 10% 100.00 0 71 100.00% 9000 Current abilities 22.01 38 615 36.46 40 Total Las 75.35% 64.765 63.8 3 Contributed capital Treasury stock Other WIADCI 67 Total Company Stockholders' Equity 22.46 0.00 31 14 35.0 DO 24.64 35.24% 35.0 Total Stockholders' Equity 2465 3520 35078 14 71 Total Labies 6 Stockholders' 100.00% 100.00% 12 73 HORIZONTAL ANALYSIS 15 Company Name CONDENSED TREND ANALYSIS BALANCE SHEET Fiscal Year Ended (Month Day Most recent year Year-end 2020 2012 Cash 6.16% Accounts Receivable 2.33% Inventory 9.6 18.51 13 Other Current M Total Current Anet 13.995 0.50 Perret 301.49% 9:09 16.16% Goodwill stangibles 000 -0.00 -3.27 8.70 Other long term Assets 2.101 124. 9774 * 14.7IN 12.50% 11 Longterm Liabilities 240.92 5.76% Total Landes 90 Contributed capital -0.60 21 95 31.70% -18.14 1378% Treasury stock 0.00% 0.00% 0.00% Other SE AOCI -1.419 6. 8.51% * Total Company Stockholders' Equity 29.69% 3.61% 2177% No controlling Internet-it applies 100 Total Stockholders' Equity 29.69% 21.77% 10000 100.00 10000 w 3000 10000 1 Total abilities & Stockholders' Equ 324.03% 9.72% 1000 903 94 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? 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? Worksheet A: Balance Sheet Analysis B D E Worksheet A: Balance Sheet Analysis Use your company's 10K's to complete the following abbreviated Balance Sheet for the most recent year end and the 3 previous year ends. (in millions) Year-end Company Name CONDENSED BALANCE SHEET Fiscal Year Ended (Month/Day) Most recent year? Year -1? 2020 2019 $ 3,216,752$ 3,030,229 $ $ 386,261 $ 346,298 $ $ 4,872,592 $ 4,579,033 $ $ 415,017 $ 513,662 $ $ 8,890,622 $ 8,469,222 $ Cash Accounts Receivable Inventory Other Current Assets Total Current Assets PPE, net Goodwill & Intangibles Other Longterm Assets Total Assets Year-2? 2018 2,758,477 $ 327,166 $ 4,187,243 $ 706,676 $ 8,485,727 $ Year-3? 2017 2,929,849 258,831 3,644,959 373,893 7,750,774 $ 95,546 $ 97,552 $ 100,069 $ 195,871 $ 761,323 $ 497,580 $ 14,058,015 $ 12,883,808 $ 24,145,003 $ 14,326,029 $ 14,058,015 $ 12,883,808 . 1 Current liabilities Longterm Liabilities Total Liabilities $ 7,150,247 $ $ 11,046,544 $ $ 18,196,791 $ 5,531,374 $ 3,746,049 $ 9,277,423 $ 5,125,537 $ 3,784,169 $ 8,909,706 $ 4,757,656 3,615,553 8,373,209 . 5 6 7 $ $ 1,199,100 $ 5,422,283$ 1,217,183 $ 4,461,744 $ 628,009 $ 4,962,159 $ 646,319 4,558,506 Contributed capital Retained earnings Treasury stock Other SE/AOCI Total Company Stockholders' Equity Noncontrolling Interest - if applies Total Stockholders' Equity $ $ (673,171) $ 5,948,212 (630,321) $ 5,048,606 $ (441,859) $ 5,148,309 $ (694,226) 4,510,599 9 0 1 2 13 $ 5,984,212 $ 5,048,606 $ 5,148,309 $ 4,510,599 Total Liabilities & Stockholders' Equity $ 24,145,003 $ 14,326,029 $ 14,058,015 $ 12,883,808 *Other plus any items that are not provided in the categories above. Note: Contributed Capital - include Common stock, Preferred stock, and Additional Paid in Capital 85 Most recent year? Year -17 Year -27 Year-37 Show the following ratio: (use CA & CL above) Working Capital 39 2020 1,740,375$ $ 2019 1,318,975$ 2018 1,335,480 $ 2017 600,527 Wksht A Balance Sheet Wksht B Inc Stmt Wksht C Ca. Default (Ca... 12 75% $ % 0 .00 123 Worksheet A: Balance Sheet Analysis X D E Note: Contributed Capital - include common stock, Preferred stock, and Additional Paid in Capital Most recent year: Year -1? Year -27 Year -3? Show the following ratio: (use CA & CL above) Working Capital Current Ratio 2020 1,740,375$ 1.24 $ 2019 1,318,975$ 1.18 2018 1,335,480$ 2017 600,527 1.08 1.19 2 3 4 5 6 7 Year -37 3 -9 0 VERTICAL ANALYSIS Company Name CONDENSED COMMON SIZE BALANCE SHEET Fiscal Year Ended (Month/Day) Most recent year Year -17 Year-22 Year-end 2020 2019 2018 13.32% 21.15% 19.62% 1.60% 2.42% 2.33% 20.18% 31.96% 29.79% 1.72% 3.59% 5.03% 36.82% 59.12% 60.36% 59.63% 36.73% 35.66% 0.40% 0.68% 0.71% 3.15% 3.47% 3.27% 100.00% 100.00% 100.00% Cash Accounts Receivable Inventory Other Current Assets Total Current Assets PPE, net Goodwill & Intangibles Other Long-term Assets Total Assets 52 2017 22.74% 2.01% 28.29% 2.90% 60.16% 35.23% 1.52% 3.09% 100.00% 55 56 57 58 59 60 Current liabilities Noncurrent Liabilities Total Liabilities 29.61% 45.75% 75.36% 38.61% 26.15% 64.76% 36.46% 26.92% 63.38% 36.93% 28.06% 64.99% 61 62 Contributed capital Retained earnings Treasury stock Other SE/AOCI Total Company Stockholders' Equity Noncontrolling Interest - if applies Total Stockholders' Equity 4.97% 22.46% 0.00% -2.79% 24.64% 8.50% 31.14% 0.00% -4.40% 35.24% 4.47% 35.30% 0.00% -3.14% 36.62% 5.02% 35.38% 0.00% -5.39% 35.01% 65 66 67 68 69 70 71 72 73 74 24.64% 35.24% 36.62% 35.01% Total Liabilities & Stockholders' Equity 100.00% 100.00% 100.00% 100.00% HORIZONTAL ANALYSIS File Edit View Insert Format Data Tools Help Last edit was me Default (Ca... 12 75% $ % . .00 123 Worksheet A: Balance Sheet Analysis B D E Total Liabilities & Stockholders' Equity 100.00% 100.00% 100.00% 100.00% Base Year? Cash Accounts Receivable Inventory Other Current Assets Total Current Assets PPE, net Goodwill & Intangibles Other Long-term Assets Total Assets HORIZONTAL ANALYSIS Company Name CONDENSED TREND ANALYSIS BALANCE SHEET Fiscal Year Ended (Month/Day) Most recent year Year-end Year -1? Year -22 2020 2019 2018 6.16% 9.85% -5.85% 1.32% 0.69% 2.33% 9.69% 14.20% 18.51% -3.26% -7.00% 11.36% 13.91% -0.60% 25.09% 301.49% 9.03% 16.16% -0.07% -0.09% -3.27% 8.70% 1.38% 2.10% 324.03% 9.72% 40.08% 2017 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 Current liabilities Longterm Liabilities Total Liabilities 53.42% 240.92% 294.35% 14.71% -1.38% 13.33% 12.56% 5.76% 18.31% 100.00 100.00 100.00 -0.60% 31.70% 0.00% -1.41% 29.69% 21.36% -18.14% 0.00% -6.83% -3.61% -0.62% 13.78% 0.00%% 8.61% 21.77% Contributed capital Retained earnings Treasury stock Other SE/AOCI Total Company Stockholders' Equity Noncontrolling Interest - If applies Total Stockholders' Equity 1 2Total Liabilities & Stockholders' Equity 3 4 5 100.00 100.00 100.00 100.00 100.00 100.00 100.00 29.69% -3.61% 21.77% 324.03% 9.72% 40.08% 100.00 16 37 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? 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