Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Calculate the current ratio, quick ratio, receivable turnover, inventory turnover, payout ratio, profit margin, return on assets and debt to total assets of the
1. Calculate the current ratio, quick ratio, receivable turnover, inventory turnover, payout ratio, profit margin, return on assets and debt to total assets of the Samsung company in the years from 2017 to 2020. Samsung data: Balance sheet Assets 2020 2019 2018 2017 2016 Fiscal year is January-December. All values KRW Millions Cash & Short Term Investments 124,652,843 108,779,703 100,939,943 83,184,201 88,182,313 Cash Only 29,382,578 26,885,999 30,340,505 30,545,130 32,132,983 Short-Term Investments 95,270,265 81,893,704 70,599,438 52,639,071 56,049,330 14.59% 7.77% 21.35% -5.67% Cash & Short Term Investments Growth Cash & ST Investments/Total Assets 32.96% 30.85% 29.74% 27.57% 33.63% Total Accounts Receivable 34,569,597 39,310,463 36,948,466 31,804,956 27,800,408 Accounts Receivables, Net 30,965,058 35,131,343 33,867,733 27,695,995 24,279,211 Accounts Receivables, Gross 31,343,276 35,530,419 34,470,342 28,362,523 24,725,603 (378,218) (399,076) (602,609) (666,528) (446,392) Bad Debt/Doubtful Accounts Other Receivables 3,604,539 4,179,120 3,080,733 4,108,961 3,521,197 Accounts Receivable Growth -12.06% 6.39% 16.17% 14.40% 6.85 5.86 6.60 7.53 7.26 Accounts Receivable Turnover Inventories 32,043,145 26,766,464 28,984,704 24,983,355 18,353,503 Finished Goods 10,434,289 9132,720 9,870,054 7,304,437 5,905,339 Work in Progress 11,818,090 9,886,634 11,066,511 7,113,901 5,017,384 Raw Materials 9,790,766 7,747,110 8,048,139 10,565,017 7,430,780 Other Current Assets 9,789,024 9,654,317 10,594,527 9,289,603 10,160,057 2,266,100 3,833,053 5,497,974 5,588,892 4,942,021 5,821,264 5,096,553 3,700,711 5,218,036 Prepaid Expenses Miscellaneous Current Assets Total Current Assets Net Property, Plant & Equipment Property, Plant & Equipment - Gross 7,522,924 201,054,609 184,510,947 177,467,640 149,262,115 144,496,281 128,952,892 119,825,474 115,416,724 111,665,648 91,473,041 328,606,313 304,075,769 279,158,166 256,528,604 225,172,654 Buildings 55,026,369 48,839,439 45,033,843 41,639,045 36,474,462 Land & Improvements 9,850,942 9,828,309 9,346,285 9,409,276 7,869,679 Machinery & Equipment 233,056,501 211,416,021 206,407,913 184,392.999 155,285,378 20,175,917 23,930,019 9,705,056 13,910,749 18,773,986 Construction in Progress Other Property, Plant & Equipment Accumulated Depreciation 10,496,584 10,061,981 8,665,069 7,176,535 6,769,149 199,653,421 184,250,295 163,741,442 144,862,956 133,699,613 Buildings 20,474,365 18,369,819 15,687,933 13,580,889 12,098,636 78,786 53,755 172,062,371 159,266,085 142,591,682 126,477,201 116,983,323 Land & Improvements Machinery & Equipment Other Property, Plant & Equipment Total Investments and Advances 7,037,899 6,560,636 5,461,827 4,804,866 4,617,654 21,854,964 17,561,328 15,628,293 14,661,282 12,642,160 8,076,779 7,591,612 7,313,206 6,802.351 5,837,884 LT Investment-Affiliate Companies Other Long-Term Investments Intangible Assets 13,778,185 9,969,716 8,315,087 7,858,931 6,804,276 18,468,502 20,703,504 14,891,598 14,760,483 5,344,020 Net Goodwill 5,673,642 6,250,439 5,833,678 5,703,138 1.343,580 Net Other Intangibles 12,794,860 14,453,065 9,057,920 9,057,345 4,000,440 Other Assets 6,468,781 8,583,882 13,255,203 8,620,526 5,963,949 Deferred Charges 1,355,502 589,832 5,572,035 4,260,267 4,391,922 Tangible Other Assets 5,113,279 7,994,050 7,683,168 4,360,259 1,572,027 Total Assets 378,235,718 352,564,497 339,357,244 301,752,090 262,174,324 7.28% 3.89% 12.46% 15.10% Assets - Total - Growth Asset Turnover Return On Average Assets 0.65 7.14% Liabilities & Shareholders' Equity 2020 2019 2018 2017 2016 All values KRW Millions ST Debt & Current Portion LT Debt Short Term Debt 17,269,528 15,239,558 13,620,046 16,046,238 13,979,606 16,553,429 14,393,468 13,586,660 15,767,619 12,746,789 Current Portion of Long Term Debt 716,099 846,090 33,386 278,619 1,232,817 Accounts Payable 9,739,222 8,718,222 8,479,916 9,083,907 6,485,039 11.71% 2.81% -6,65% 40.07% 4,430,272 1,387,773 8,720,050 7,408,348 2,837,353 Accounts Payable Growth Income Tax Payable Other Current Liabilities Miscellaneous Current Liabilities Total Current Liabilities 44,165,329 38,437,211 38,261,498 34,636,621 31,402,097 44,165,329 38,437,211 38,261,498 34,636,621 31,402,097 75,604,351 63,782,764 69,081,510 67,175,114 54,704,095 Current Ratio 2.66 2.89 2.57 2.22 2.64 Quick Ratio 2.24 2.47 2.15 1.85 2.31 Cash Ratio 1.65 1.71 1.46 1.24 1.61 Long-Term Debt 2,947,853 3,172,479 1,047,057 2,767,807 1,302,780 948,137 975,298 996,935 2,710,269 1,237,653 Long-Term Debt excl. Capitalized Leases Non-Convertible Debt Capitalized Lease Obligations 948,137 975,298 996,935 2,710,269 1,237,653 50,122 57538 65,127 Provision for Risks & Charges 1,515,886 1,081,880 1,167,683 854,246 531,782 Deferred Taxes 17,374,875 15,674,446 12,464,737 8,928,745 5,038,641 Deferred Taxes - Credit 18,810,845 17,053,808 15,162,523 11,710,781 7,293,514 Deferred Taxes - Debit 1,435,970 1,379,362 2,697,786 2.782,036 2,254,873 Other Liabilities 3,408,767 4,593,145 5,145,294 4,752.714 5,379,120 Other Liabilities (excl. Deferred Income) 3,408,767 4,593,145 5,145,294 4,752,714 5,379,120 Total Liabilities 102,287,702 89,684,076 91,604,067 87,260,662 69,211,291 27.04% 25.44% 26,99% 28.92% 26.40% 267,670,331 254,915,472 240,068,993 207,213,416 186,424,328 897,514 897,514 897,514 897,514 897,514 Total Liabilities/Total Assets Common Equity (Total) Common Stock Par/Carry Value Additional Paid-In Capital/Capital Surplus Retained Earnings Cumulative Translation Adjustment/Unrealized For. Exch. Gain 4,403,893 4,403,893 4,403,893 4,403,893 4,403,893 96,328,646 86,260,026 91,179,305 76,182,005 50,079,125 (10,989,715) (5,645,769) (8,612,742) (9,192,002) (2,930,886) Unrealized Gain/Loss Marketable Securities 4,975,756 2.573,530 1,462,266 1,879,774 1,390,624 (2,712,054) (1,957,019) (840,775) (364,812) 142,195,663 Other Appropriated Reserves Unappropriated Reserves 174,766, 291 168,383,297 151,579,532 139,635,231 138,721 (6,228,187) (9,750,326) 70.77% 72.30% 70.74% 68.67% 71.11% Treasury Stock Common Equity/Total Assets Total Shareholders' Equity Total Shareholders' Equity/Total Assets Accumulated Minority Interest 267,670,331 254,915,472 240,068,993 207,213,416 186,424,328 70.77% 72.30% 70.74% 68.67% 71.11% 8,277,685 7,964,949 7,684,184 7,278,012 6,538,705 Total Equity 275,948,016 262,880,421 247,753,177 214,491,428 192,963,033 Liabilities & Shareholders' Equity 378,235,718 352,564,497 339,357,244 301,752,090 262,174,324 Cash flow 2020 2019 2018 2017 2016 26,407,832 21,738,865 44,344,857 42,186,747 22.726,092 21.48% -50.98% 5.12% 85.63% 30,335,616 29,597,638 26,482,037 22.117,392 20,712,965 Operating Activities Fiscal year is January-December. All values KRW Millions. Net Income before Extraordinaries Net Income Growth Depreciation, Depletion & Amortization Depreciation and Depletion Amortization of Intangible Assets Other Funds Funds from Operations Changes in Working Capital Receivables 27,115,735 26,573,816 25,167,112 20,593,616 19,312,520 3,219,881 3,023,822 1,314,925 1,523,776 1,400,445 8,421,137 (3,407,832) 6,129,335 8,478,449 5,127,540 65,164,585 47,928,671 76,956,229 72,782,588 48,566,597 122,424 (2,545,756) (9.924,366) (10,620,547) (1,180,953) 1,741,016 1,828,591 4,513,604 (7,676,175) 1,313,276 Inventories (7,540,656) 2,134,632 (5,979,475) (8,444,506) (2,830,602) Accounts Payable 3,885,742 (1.269,177) (533,609) 4,006,410 200,240 5,332,676 (1,707,265) 501,536 1,292,420 1,136,440 Other Accruals Other Assets/Liabilities Net Operating Cash Flow (3,296,354) (3,532,537) (8,426,422) 201,304 (1,000,307) 65,287,009 45,382,915 67,031,863 62,162,041 47,385,644 43.86% -32.30% 7.83% 31.18% 27.57% 19.70% 27.50% 2595% 23.47% 2020 2019 2018 2017 2016 Net Operating Cash Flow Growth Net Operating Cash Flow/ Sales Investing Activities All values KRW Millions Capital Expenditures Capital Expenditures (Fixed Assets) Capital Expenditures (Other Assets) Capital Expenditures Growth Capital Expenditures / Sales (40,271,813) (28,617,670) (30,576,923) (43,775,974) (25,190,641) (37,592,034) (25,367,756) (29,556,406) (42,792,234) (24,142,973) (2.679,779) (3,249,914) (1,020,517) (983,740) (1,047,668) -40.72% 6.41% 30.15% -73.78% -17.01% -12.42% -12.54% -18.27% -12.48% (49,420) (1,021,105) (99,108) (8,754,268) (622,050) 384,931 513,265 565,044 1,562,858 284,106 Net Assets from Acquisitions Sale of Fixed Assets & Businesses Purchase/Sale of Investments Purchase of Investments (13,633,932) (10,877,650) (22,131,041) 1,615,560 (4,143,738) (26,913,224) (16,236,889) (22.483,388) (1,569,896) (12,234,162) Sale/Maturity of Investments 13,279,292 5,359,239 352,347 3,185,456 8,090,424 (57,197) (2.289) (28,455) 7,027 53,289 11,935 733 26,880 (53,620,404) (39,949,871) (52,232.382) (49,379,546) (29,645,443) Other Uses Other Sources Net Investing Cash Flow Net Investing Cash Flow Growth Net Investing Cash Flow/ Sales Financing Activities -34.22% 23.52% -5.78% -66.57% -22.64% -17.34% -21.43% -20.61% -14.69% 2020 2019 2018 2017 2016 All values KRW Millions Cash Dividends Paid - Total 9,676,760) (9,639,202) (10,193,695) (6,804,297) (3,114,742) (9,676,760) (9,639,202) (10,193,695) (6,804,297) (3,114,742) (875,111) (8,350,424) (7,707,938) Common Dividends Change in Capital Stock Repurchase of Common & Preferred Stk. Issuance/Reduction of Debt, Net Change in Current Debt (875,111) (8,350,424) (7,707,938) 1,340,730 156,392 (4,029,490) 2,588,180 2,139,930 2,191,186 865,792 (2,046,470) 2,730,676 1,351,037 (850,452) (709,400) (1983,017) (142,492) 788,897 14,495 3,580 998,311 1,041,743 Change in Long-Term Debt Issuance of Long-Term Debt Reduction in Long-Term Debt Net Financing Cash Flow (864,947) (709,400) (1,986,597) (1.140,803) (252,846) (8,336,026) (9,482,810) (15,098,293) (12,566,537) (8,682,746) Net Financing Cash Flow Growth 12.09% 37.19% -20.15% -44.73% -3.52% -4.12% -6.19% -5.25% -4.30% Net Financing Cash Flow/ Sales Exchange Rate Effect (833,861) 595,260 94,187 (1,782,270) 417 243 2,496,718 (3,454,506) (204,625) (1,566,312) 9,474,698 Net Change in Cash Free Cash Flow 27,694,975 20,015,159 37,475,457 19,369,807 23,242,671 Free Cash Flow Growth 38.37% -46.59% 93.47% -16.66% Free Cash Flow Yield 3.27% Income statement 2020 2019 2018 2017 2016 Fiscal year is January-December. All values KRW Millions Sales/Revenue 236,806,988 230,400,881 243,771,415 239,575,376 201,866,745 2.78% -5.48% 1.75% 18.68% Sales Growth Cost of Goods Sold (COGS) incl. D&A COGS excluding D&A 148,612,196 151,017,841 135,277,299 132,072,774 122,682,833 118,276,580 121,420,203 108,795,262 109,955,382 101,969,868 30,335,616 29,597,638 26,482,037 22,117,392 20,712,965 Depreciation & Amortization Expense Depreciation 27,115,735 26,573,816 25,167,112 20,593,616 19,312,520 Amortization of Intangibles 3,219,881 3,023,822 1,314,925 1,523,776 1,400,445 COGS Growth -1.59% 11.64% 2.43% 7,65% 88,194,792 79,383,040 108,494,116 107,502,602 79,183,912 Gross Income Gross Income Growth 11.10% -26.83% 0.92% 35.76% 37.24% Gross Profit Margin SG&A Expense 52,200,916 51,614,531 49,607,447 53,857,564 49,943,240 Research & Development 19,073,269 18,169,761 16,918,882 14,910,119 12,708,079 Other SG&A 33,127,647 33,444,770 32,688,565 38,947,445 37,235,161 SGA Growth 1.14% 4,05% -7.89% 7.84% EBIT 35,993,876 27,768,509 58,886,669 53,645,038 29,240,672 Unusual Expense 1,575 366,705 872,985 (1,546,734) 277,052 112,497 1,757,371 1,409,977 1,974,458 2,660,024 2,297,139 1,614,223 1,504,318 Non Operating Income/Expense Non-Operating Interest Income Equity in Affiliates (Pretax) Interest Expense Interest Expense Growth 539,845 201.442 19,501 583,013 692,687 674,617 655,402 587,831 -15.83% 2.68% 2.93% 11.49% Gross Interest Expense 586,910 692.687 696,721 675,113 605,475 Interest Capitalized 3,897 22,104 19,711 17,644 Pretax Income 35,838,587 30,019,229 61,159,958 56,195,967 30,713,652
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started