80.2K

Verified Solution

Link Copied!

I need help on C20, 21&22

Formulas required

Double checking on my other answers is appreciated!

Thank you in advance!

12 WE Den 120 Excel Case 82. Texas Instruments, Inc Anwwer schedule Forma wema Market 31 de OSO motor w Marience of 050 ww/Detail werd in het wees ununi weiterentworth Wave Datab $421 dem ru, SET NO . 10 nec Mare DOM in care w ST www 14 dema www.LLIONS Wwwwwwww w way to cut the www w We heeforum wbrew LONG 100 2:01 OSE dilatado About ME 125 pe pertama per tema cu 2 decimal number 4 dec berdeen 090 We Weight for when 125 159 Tecpoint AS C D G H 2021-12 2020-12 2019-12 2018-12 2017-12 2016-12 9,799 1,701 1.910 335 13,585 6,568 1,414 1.955 302 10,239 5387 1074 2001 299 1,761 4233 1,207 2,217 440 1,097 4469 1.275 1,957 1,030 8.734 1.400 1.26% 1.790 910 7457 7.858 12,717) 4.362 345 1,140 10,991 24,676 5,781 12.512) 4362 617 564 9,112 19,351 5740 12.4371 4362 606 986 9,257 18.018 5,425 (2.2423 4.363 717 278 9,040 17,137 4,789 12.125) 4,362 1,056 826 8,90 17,642 4923 12.411) 4362 1,316 784 8,974 16,431 Teatruments Inc. N) BALANCE SHEET Flyer end in December. US in millions Assets 4 Current wets 3 Cash and cash equivalents treceivables 7 venti Other current assets 9 Total current assets 10 Non-current assets 11 Gross property, plant and equipment 12 Accumulated Depreciation Goodwill 14 Other intangible assets 15 other long-term assets 16 Total non-rentants 17 Totalets 10 10 Lates 20 Current lates 21 Short term debit 22 Accounts payable and other accruals 23 Other current liabilities 24 Total current Bites 3 Non-currenties 26 long term det 29 Deferred to slabilities Other long-term liabilities 29 Total non current liabilities 30 Total abilities 11 32 Medholdenequity 30 Common stock 34 Additional Paid in Capital 15 Bened earnings 36 Treasury stock Accumulated other comprehensive income a total stockholders' equity Totallites and stockholders'quil 500 1.428 641 2.569 550 1182 658 2,390 500 1,102 521 2,123 749 1001 726 2,474 500 1,036 722 2,25 631 923 710 7,241 87 1.446 724 11,141 6245 90 1.456 7,774 10,164 5,303 78 100 6,98 9,111 4319 42 1305 5,669 8.143 3,577 78 1 392 5,047 7,305 2.978 33 683 3,694 5.958 1.741 2.110 1,741 2.650 45919 36 800 115 13,335 24.676 1.741 2,333 42,051 (36.578) 360 187 19,351 1.741 1,950 37.905 (32,1300 (473) 1,994 17,137 1.741 1.776 34,662 127.458) 39 898 134.495) 1347) 3,907 18,018 1.741 1674 33.107 125 5231 1526) 10,473 14431 1384 10,337 17,642 2021-12 7070-12 2019-12 2018 12 2017-12 2016-12 41 12. Testaments inc. INCOME STATEMENT year ende in December, USD in million 14 15 Revenue Sales 46 Cast of revenue (Cost of goods sold) 4T Grow profit (Gross margin 41 Operating expenses 40 ERITDA 50 Deprecand amort 51 Operating income (IT) 57: Espense 11 Tesale income Income tax expense 55 Net Income 14463 5.192 9.769 2.00 15.754 5.50 10.27 1453 5,219 9,164 2.216 49 1050 13370 5130 9,240 2638 5,604 2,199 18,344 5.960 12,536 2319 10.057 954 9,103 184 1919 1.150 7.60 7,401 14961 5,347 1610 3212 6,397 939 SAS 28 S.580 1,690 1682 6207 150 4,017 170 5.22 711 5,017 125 486 900 5.50 4930 1335 3,595 5,595 Test income tax expense/Operating income Tax rated 1205 13 04 3111 2671N 6. ON 17 17 Average 17 17 Texas Instruments, Inc. yahoo finance data 112/31/21 year end) 2 Annual Annual Dividends Growth Rates 421 13.1720% Average Growth Rate 20.2635% Quarterly Dividends 115 1.02 1.02 1.02 1.02 0.90 3.7200 S 188.47 $ 176.41 billion 135 22.82 S 8.26 s 4.21 936.000 million 15.8879% 0.50 4 Current stock price 5 Market Cap (value) 6 Bers 7 PE Ratio 8 EPS 9 Annual dividend 10 # of shares outstanding 11 12 13 current price 14 outstanding shares 15 market value 16 17 3.2100 22.0532% 2.6300 24.0566% 5 188.47 936,000,000 $ 176,407,920,000 or 176.41 billion Date 10/29/21 07/21/21 04/30/21 01/29/21 10/29/20 07/30/20 05/01/20 01/30/20 10/30/19 07/30/19 05/01/19 01/30/19 10/30/18 07/30/18 05/04/18 01/30/18 10/30/17 07/27/17 04/27/17 01/27/17 11/03/16 07/28/16 04/28/16 01/28/16 10/28/15 07/29/15 04/28/15 01/28/15 21200 29.2683% 0.90 0.90 0.77 0.77 0.77 0.77 0.62 0.62 0.62 0.62 0.50 0.50 0.50 0.50 0.38 0.38 0.38 0.38 0.34 0.34 034 20 21 1 6400 17.1429% SENSAS 1.4000 24 25 26 27 28 29 30 0 TXN outstanding bonds as of 12/31/21 Face amounts are in millions Name Maturity Current Price Weight Senior Notes Senior Nos Senior Notes Senior No 10 Senior Notes 11 Senior Not 13 Senior Nos 1) Senior Not Senior Not 15 Senior Not Senior Notes 17 Senior Totals 05/15/22 05/01/23 05/15/24 03/12/25 05/31/26 11/03/27 09/04/20 05/04/30 06/30/31 03/15/39 05/15/4 07/31/53 Face Amount S(Mil) 500.00 500.00 300.00 750.00 500.00 500.00 750.00 750.00 500.00 750.00 1.500.00 500.00 7,800.00 or 7.800 billion 100.05 10050 101.00 9730 95 00 100 55 9560 91.40 90.35 105 20 104.75 78 00 Preta con Coupon % Yield to Maturity % 1850% 100619 2.250% 1.8077 2.625% 2 1895% 1375 22547 1.125% 23226% 2.900 2.7968% 2.250% 28931% 1.750X 29188% 1 9001 3.0020 3.875% 3.4708 4.150% 33611% 2.700% 3.9705 Market Value $ (MI) 50025 502 50 303.00 729.75 47500 50275 71700 685 50 454.75 789.00 1371 25 39000 7,620.75 or 7.621 billion 0.0656 00650 0.0990 0 0958 0.0623 00680 0.0941 0.0900 0.019 0.1035 0.2062 0.0512 1.000000 Weighted YTM % 0.1115% 0.123 00071 02159 0.14459 O 1945 02722 0.2625 0.17915 03593 0.79619 02032 2.939364% 20 FRA Pre-tax Cost of Debt 0.0294 Adjustment for tax rate 0.8283 -17.17% After tax Cost of Debt 2.4347% 12 WE Den 120 Excel Case 82. Texas Instruments, Inc Anwwer schedule Forma wema Market 31 de OSO motor w Marience of 050 ww/Detail werd in het wees ununi weiterentworth Wave Datab $421 dem ru, SET NO . 10 nec Mare DOM in care w ST www 14 dema www.LLIONS Wwwwwwww w way to cut the www w We heeforum wbrew LONG 100 2:01 OSE dilatado About ME 125 pe pertama per tema cu 2 decimal number 4 dec berdeen 090 We Weight for when 125 159 Tecpoint AS C D G H 2021-12 2020-12 2019-12 2018-12 2017-12 2016-12 9,799 1,701 1.910 335 13,585 6,568 1,414 1.955 302 10,239 5387 1074 2001 299 1,761 4233 1,207 2,217 440 1,097 4469 1.275 1,957 1,030 8.734 1.400 1.26% 1.790 910 7457 7.858 12,717) 4.362 345 1,140 10,991 24,676 5,781 12.512) 4362 617 564 9,112 19,351 5740 12.4371 4362 606 986 9,257 18.018 5,425 (2.2423 4.363 717 278 9,040 17,137 4,789 12.125) 4,362 1,056 826 8,90 17,642 4923 12.411) 4362 1,316 784 8,974 16,431 Teatruments Inc. N) BALANCE SHEET Flyer end in December. US in millions Assets 4 Current wets 3 Cash and cash equivalents treceivables 7 venti Other current assets 9 Total current assets 10 Non-current assets 11 Gross property, plant and equipment 12 Accumulated Depreciation Goodwill 14 Other intangible assets 15 other long-term assets 16 Total non-rentants 17 Totalets 10 10 Lates 20 Current lates 21 Short term debit 22 Accounts payable and other accruals 23 Other current liabilities 24 Total current Bites 3 Non-currenties 26 long term det 29 Deferred to slabilities Other long-term liabilities 29 Total non current liabilities 30 Total abilities 11 32 Medholdenequity 30 Common stock 34 Additional Paid in Capital 15 Bened earnings 36 Treasury stock Accumulated other comprehensive income a total stockholders' equity Totallites and stockholders'quil 500 1.428 641 2.569 550 1182 658 2,390 500 1,102 521 2,123 749 1001 726 2,474 500 1,036 722 2,25 631 923 710 7,241 87 1.446 724 11,141 6245 90 1.456 7,774 10,164 5,303 78 100 6,98 9,111 4319 42 1305 5,669 8.143 3,577 78 1 392 5,047 7,305 2.978 33 683 3,694 5.958 1.741 2.110 1,741 2.650 45919 36 800 115 13,335 24.676 1.741 2,333 42,051 (36.578) 360 187 19,351 1.741 1,950 37.905 (32,1300 (473) 1,994 17,137 1.741 1.776 34,662 127.458) 39 898 134.495) 1347) 3,907 18,018 1.741 1674 33.107 125 5231 1526) 10,473 14431 1384 10,337 17,642 2021-12 7070-12 2019-12 2018 12 2017-12 2016-12 41 12. Testaments inc. INCOME STATEMENT year ende in December, USD in million 14 15 Revenue Sales 46 Cast of revenue (Cost of goods sold) 4T Grow profit (Gross margin 41 Operating expenses 40 ERITDA 50 Deprecand amort 51 Operating income (IT) 57: Espense 11 Tesale income Income tax expense 55 Net Income 14463 5.192 9.769 2.00 15.754 5.50 10.27 1453 5,219 9,164 2.216 49 1050 13370 5130 9,240 2638 5,604 2,199 18,344 5.960 12,536 2319 10.057 954 9,103 184 1919 1.150 7.60 7,401 14961 5,347 1610 3212 6,397 939 SAS 28 S.580 1,690 1682 6207 150 4,017 170 5.22 711 5,017 125 486 900 5.50 4930 1335 3,595 5,595 Test income tax expense/Operating income Tax rated 1205 13 04 3111 2671N 6. ON 17 17 Average 17 17 Texas Instruments, Inc. yahoo finance data 112/31/21 year end) 2 Annual Annual Dividends Growth Rates 421 13.1720% Average Growth Rate 20.2635% Quarterly Dividends 115 1.02 1.02 1.02 1.02 0.90 3.7200 S 188.47 $ 176.41 billion 135 22.82 S 8.26 s 4.21 936.000 million 15.8879% 0.50 4 Current stock price 5 Market Cap (value) 6 Bers 7 PE Ratio 8 EPS 9 Annual dividend 10 # of shares outstanding 11 12 13 current price 14 outstanding shares 15 market value 16 17 3.2100 22.0532% 2.6300 24.0566% 5 188.47 936,000,000 $ 176,407,920,000 or 176.41 billion Date 10/29/21 07/21/21 04/30/21 01/29/21 10/29/20 07/30/20 05/01/20 01/30/20 10/30/19 07/30/19 05/01/19 01/30/19 10/30/18 07/30/18 05/04/18 01/30/18 10/30/17 07/27/17 04/27/17 01/27/17 11/03/16 07/28/16 04/28/16 01/28/16 10/28/15 07/29/15 04/28/15 01/28/15 21200 29.2683% 0.90 0.90 0.77 0.77 0.77 0.77 0.62 0.62 0.62 0.62 0.50 0.50 0.50 0.50 0.38 0.38 0.38 0.38 0.34 0.34 034 20 21 1 6400 17.1429% SENSAS 1.4000 24 25 26 27 28 29 30 0 TXN outstanding bonds as of 12/31/21 Face amounts are in millions Name Maturity Current Price Weight Senior Notes Senior Nos Senior Notes Senior No 10 Senior Notes 11 Senior Not 13 Senior Nos 1) Senior Not Senior Not 15 Senior Not Senior Notes 17 Senior Totals 05/15/22 05/01/23 05/15/24 03/12/25 05/31/26 11/03/27 09/04/20 05/04/30 06/30/31 03/15/39 05/15/4 07/31/53 Face Amount S(Mil) 500.00 500.00 300.00 750.00 500.00 500.00 750.00 750.00 500.00 750.00 1.500.00 500.00 7,800.00 or 7.800 billion 100.05 10050 101.00 9730 95 00 100 55 9560 91.40 90.35 105 20 104.75 78 00 Preta con Coupon % Yield to Maturity % 1850% 100619 2.250% 1.8077 2.625% 2 1895% 1375 22547 1.125% 23226% 2.900 2.7968% 2.250% 28931% 1.750X 29188% 1 9001 3.0020 3.875% 3.4708 4.150% 33611% 2.700% 3.9705 Market Value $ (MI) 50025 502 50 303.00 729.75 47500 50275 71700 685 50 454.75 789.00 1371 25 39000 7,620.75 or 7.621 billion 0.0656 00650 0.0990 0 0958 0.0623 00680 0.0941 0.0900 0.019 0.1035 0.2062 0.0512 1.000000 Weighted YTM % 0.1115% 0.123 00071 02159 0.14459 O 1945 02722 0.2625 0.17915 03593 0.79619 02032 2.939364% 20 FRA Pre-tax Cost of Debt 0.0294 Adjustment for tax rate 0.8283 -17.17% After tax Cost of Debt 2.4347%

Answer & Explanation Solved by verified expert

See Answer