I've already filled out the first half, I just need Average tax rate, Pre tax cost of debt (bonds), After tax cost of debt (bonds), Total Market value of equity and debt, weight for equity, weight for debt, and weighted average cost of capital. I've uploaded the data.

Format 1 Excel Case #2 - Texas Instruments, Inc. 2 3 Answer Schedule 4 5 Market value of equity (market cap) 6 Growth rate for equity 7 Market price of stock (per share) 8 Annual dividend 9 Beta of stock 10 Risk free rate 11 Market rate of return 12 DGM cost of equity (stock) 13 CAPM cost of equity (stock) 14 Average cost of equity 15 Market value of debt $176.41 billion 20.26% 188 $4.21 1.35 1.60% 10.80% 2.69% 14.02% 8.35% 500.25 billion currency, 2 decimal places percentage, 2 decimal places currency, 2 decimal places currency, 2 decimal places number, 2 decimal places percentage, 2 decimal places percentage, 2 decimal places percentage, 2 decimal places percentage, 2 decimal places percentage, 2 decimal places currency, 2 decimal places 16 Average tax rate 17 Pre tax cost of debt (bonds) 18 After tax cost of debt (bonds) 19 Total market value of equity and debt 20 Weight for equity 21 Weight for debt 22 Weighted average cost of capital billion percentage, 2 decimal places percentage, 2 decimal places percentage, 2 decimal places currency, 2 decimal places number, 4 decimal places number, 4 decimal places percentage, 2 decimal places 23 TXN outstanding bonds as of 12/31/21 Face amounts are in millions. Name Maturity Current Price Coupon % Yield to Maturity % Market Value $ (MI) 500.25 Weight Weighted YTM % 05/15/22 05/01/23 05/15/24 03/12/25 05/31/26 11/03/27 09/04/29 05/04/30 06/30/31 03/15/39 05/15/48 07/31/51 Face Amount $(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 100.50 101.00 97.30 95.00 100.55 95.60 9140 90.95 105,20 104.75 78.00 1.850% 2.250 2.625% 1.375% 1.125% 2.900% 2.250% 1.750X 1.900 3.875% 4.150% 2.700N Senior Notes 7 Senior Notes Senior Notes 9 Senior Notes 10 Senior Notes 11 Senior Notes 12 Senior Notes 13 Senior Notes 14 Senior Notes 15 Senior Notes 16 Senior Notes 17 Senior Notes 18 Totals 19 20 21 22 23 24 25 26 27 28 29 30 1.6981% 1.8677% 2 1895% 2 2547% 23226% 2.7968% 2 8931% 29188% 3.0020% 3.4708% 3.6611% 3.9705% or billion Pre-tax cost of Debt Adjustment for tax rate After tax Cost of Debt 32 C D Texas Instruments, Inc. yahoo finance data 1 12/31/21 year end) Annual Annual Growth Dividends Rates 4.21 13.17% Average Growth Rate 20.265 0.2026 0.2026 3.72 Quarterly Dividends 1.15 1.02 1.02 1.02 1.02 0.90 0.90 0.90 0.90 0.77 0.77 Current stock price Market Cap Value 6 Beta 7 PERatio EPS 9 Annual dividend 10 of shares outstanding 15.89% $ 188.47 $ 176.41 billion 1.35 22.82 826 $ 4.21 936.000 million wu 3.21 22.05% 0.71 2.63 24.06% 5 188.47 936,000,000 $ 176.407,920,000 or 5 176.41 billion Date 10/29/21 07/23/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 0.77 0.62 0.62 0.62 0.62 0.50 2.12 29.27% 12 13 current price 14 outstanding shares 15 market value 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 050 1.64 17.14% 0.50 0.50 0.38 0.38 0.38 0.38 0.34 0.34 0.34 1.40 2021-12 2020-12 2019-12 2018-12 2017-12 2016-12 42 Texas Instruments Inc. (TXN) INCOME STATEMENT 43 Fiscal year ends in December. USD in millions. 44 45 Revenue (Sales) 46 Cost of revenue (Cost of goods sold) 47 Gross profit (Gross margin) 48 Operating expenses 49 EBITDA 50 Deprecand amort 51 Operating income (EBIT) 52 Interest Expense 53 Taxable income 54 Income tax expense 55 Net income 56 57 58 59 60 61 18,344 5,968 12,376 2,319 10,057 954 9,103 184 8,919 1,150 7,769 14,461 5,192 9,269 2,070 7,199 992 6,207 190 6,017 422 5,595 14,383 5,219 9,164 2,216 6,948 1,050 5,898 170 5,728 711 5,017 15,784 5,507 10,277 2,876 7,401 790 6,611 125 6,486 906 5,580 14,961 5,347 9,614 3,217 6,397 939 5,458 78 5,380 1,698 3,682 13,370 5,130 8,240 2,636 5,604 605 4,999 69 4,930 1,335 3,595 Texas Instruments Inc. (TXN) BALANCE SHEET Fiscal year ends in December. USD in millions 2021-12 2020-12 2019-12 2018-12 2017-12 2016-12 Assets 9,739 1,701 1,910 335 13,685 6,568 1,414 1,955 302 10,239 5,387 1,074 2,001 299 8,761 4,233 1,207 2,217 440 8,097 4,469 1,278 1,957 1,030 8,734 3,490 1,267 1,790 910 7,457 Current assets Cash and cash equivalents Receivables Inventories Other current assets Total current assets Non-current assets Gross property, plant and equipment Accumulated Depreciation Goodwill Other intangible assets Other long-term assets Total non-current assets Total assets 7,858 (2,717) 4,362 348 1,140 10,991 24,676 5,781 (2,512) 4,362 617 864 9,112 19,351 5,740 (2,437) 4,362 606 986 9,257 18,018 5,425 (2,242) 4,362 717 778 9,040 17,137 4,789 12,125) 4,362 1,056 826 8,908 17,642 4,923 (2,411) 4,362 1,316 784 8,974 16,431 500 1,428 641 2,569 550 1,182 658 2,390 500 1,102 521 2,123 749 1,001 724 2,474 500 1,036 722 2,258 631 923 710 2,264 Liabilities Current liabilities Short-term debt Accounts payable and other accruals Other current liabilities Total current liabilities Non-current liabilities Long-term debt Deferred taxes liabilities Other long-term liabilities Total non-current liabilities Total liabilities 7,241 87 1,446 8,774 11,343 6,248 90 1,436 7,774 10,164 5,303 78 1,607 6,988 9,111 4,319 42 1,308 5,669 8,143 3,577 78 1,392 5,047 7,305 2,978 33 683 3,694 5,958 Stockholders' equity Common stock Additional Paid in Capital Retained earnings Treasury stock Accumulated other comprehensive income Total stockholders' equity Total liabilities and stockholders' equity 1,741 2,630 45,919 (36,800) (157) 13,333 24,676 1,741 2,333 42,051 (36,578) (360) 9,187 19,351 1,741 2,110 39,898 (34,495) (347) 8,907 18,018 1,741 1,950 37,906 (32,130) (473) 8,994 17,137 1,741 1,776 34,662 (27,458) (384) 10,337 17,642 1,741 1,674 33, 107 (25,523) (526) 10,473 16,431 Format 1 Excel Case #2 - Texas Instruments, Inc. 2 3 Answer Schedule 4 5 Market value of equity (market cap) 6 Growth rate for equity 7 Market price of stock (per share) 8 Annual dividend 9 Beta of stock 10 Risk free rate 11 Market rate of return 12 DGM cost of equity (stock) 13 CAPM cost of equity (stock) 14 Average cost of equity 15 Market value of debt $176.41 billion 20.26% 188 $4.21 1.35 1.60% 10.80% 2.69% 14.02% 8.35% 500.25 billion currency, 2 decimal places percentage, 2 decimal places currency, 2 decimal places currency, 2 decimal places number, 2 decimal places percentage, 2 decimal places percentage, 2 decimal places percentage, 2 decimal places percentage, 2 decimal places percentage, 2 decimal places currency, 2 decimal places 16 Average tax rate 17 Pre tax cost of debt (bonds) 18 After tax cost of debt (bonds) 19 Total market value of equity and debt 20 Weight for equity 21 Weight for debt 22 Weighted average cost of capital billion percentage, 2 decimal places percentage, 2 decimal places percentage, 2 decimal places currency, 2 decimal places number, 4 decimal places number, 4 decimal places percentage, 2 decimal places 23 TXN outstanding bonds as of 12/31/21 Face amounts are in millions. Name Maturity Current Price Coupon % Yield to Maturity % Market Value $ (MI) 500.25 Weight Weighted YTM % 05/15/22 05/01/23 05/15/24 03/12/25 05/31/26 11/03/27 09/04/29 05/04/30 06/30/31 03/15/39 05/15/48 07/31/51 Face Amount $(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 100.50 101.00 97.30 95.00 100.55 95.60 9140 90.95 105,20 104.75 78.00 1.850% 2.250 2.625% 1.375% 1.125% 2.900% 2.250% 1.750X 1.900 3.875% 4.150% 2.700N Senior Notes 7 Senior Notes Senior Notes 9 Senior Notes 10 Senior Notes 11 Senior Notes 12 Senior Notes 13 Senior Notes 14 Senior Notes 15 Senior Notes 16 Senior Notes 17 Senior Notes 18 Totals 19 20 21 22 23 24 25 26 27 28 29 30 1.6981% 1.8677% 2 1895% 2 2547% 23226% 2.7968% 2 8931% 29188% 3.0020% 3.4708% 3.6611% 3.9705% or billion Pre-tax cost of Debt Adjustment for tax rate After tax Cost of Debt 32 C D Texas Instruments, Inc. yahoo finance data 1 12/31/21 year end) Annual Annual Growth Dividends Rates 4.21 13.17% Average Growth Rate 20.265 0.2026 0.2026 3.72 Quarterly Dividends 1.15 1.02 1.02 1.02 1.02 0.90 0.90 0.90 0.90 0.77 0.77 Current stock price Market Cap Value 6 Beta 7 PERatio EPS 9 Annual dividend 10 of shares outstanding 15.89% $ 188.47 $ 176.41 billion 1.35 22.82 826 $ 4.21 936.000 million wu 3.21 22.05% 0.71 2.63 24.06% 5 188.47 936,000,000 $ 176.407,920,000 or 5 176.41 billion Date 10/29/21 07/23/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 0.77 0.62 0.62 0.62 0.62 0.50 2.12 29.27% 12 13 current price 14 outstanding shares 15 market value 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 050 1.64 17.14% 0.50 0.50 0.38 0.38 0.38 0.38 0.34 0.34 0.34 1.40 2021-12 2020-12 2019-12 2018-12 2017-12 2016-12 42 Texas Instruments Inc. (TXN) INCOME STATEMENT 43 Fiscal year ends in December. USD in millions. 44 45 Revenue (Sales) 46 Cost of revenue (Cost of goods sold) 47 Gross profit (Gross margin) 48 Operating expenses 49 EBITDA 50 Deprecand amort 51 Operating income (EBIT) 52 Interest Expense 53 Taxable income 54 Income tax expense 55 Net income 56 57 58 59 60 61 18,344 5,968 12,376 2,319 10,057 954 9,103 184 8,919 1,150 7,769 14,461 5,192 9,269 2,070 7,199 992 6,207 190 6,017 422 5,595 14,383 5,219 9,164 2,216 6,948 1,050 5,898 170 5,728 711 5,017 15,784 5,507 10,277 2,876 7,401 790 6,611 125 6,486 906 5,580 14,961 5,347 9,614 3,217 6,397 939 5,458 78 5,380 1,698 3,682 13,370 5,130 8,240 2,636 5,604 605 4,999 69 4,930 1,335 3,595 Texas Instruments Inc. (TXN) BALANCE SHEET Fiscal year ends in December. USD in millions 2021-12 2020-12 2019-12 2018-12 2017-12 2016-12 Assets 9,739 1,701 1,910 335 13,685 6,568 1,414 1,955 302 10,239 5,387 1,074 2,001 299 8,761 4,233 1,207 2,217 440 8,097 4,469 1,278 1,957 1,030 8,734 3,490 1,267 1,790 910 7,457 Current assets Cash and cash equivalents Receivables Inventories Other current assets Total current assets Non-current assets Gross property, plant and equipment Accumulated Depreciation Goodwill Other intangible assets Other long-term assets Total non-current assets Total assets 7,858 (2,717) 4,362 348 1,140 10,991 24,676 5,781 (2,512) 4,362 617 864 9,112 19,351 5,740 (2,437) 4,362 606 986 9,257 18,018 5,425 (2,242) 4,362 717 778 9,040 17,137 4,789 12,125) 4,362 1,056 826 8,908 17,642 4,923 (2,411) 4,362 1,316 784 8,974 16,431 500 1,428 641 2,569 550 1,182 658 2,390 500 1,102 521 2,123 749 1,001 724 2,474 500 1,036 722 2,258 631 923 710 2,264 Liabilities Current liabilities Short-term debt Accounts payable and other accruals Other current liabilities Total current liabilities Non-current liabilities Long-term debt Deferred taxes liabilities Other long-term liabilities Total non-current liabilities Total liabilities 7,241 87 1,446 8,774 11,343 6,248 90 1,436 7,774 10,164 5,303 78 1,607 6,988 9,111 4,319 42 1,308 5,669 8,143 3,577 78 1,392 5,047 7,305 2,978 33 683 3,694 5,958 Stockholders' equity Common stock Additional Paid in Capital Retained earnings Treasury stock Accumulated other comprehensive income Total stockholders' equity Total liabilities and stockholders' equity 1,741 2,630 45,919 (36,800) (157) 13,333 24,676 1,741 2,333 42,051 (36,578) (360) 9,187 19,351 1,741 2,110 39,898 (34,495) (347) 8,907 18,018 1,741 1,950 37,906 (32,130) (473) 8,994 17,137 1,741 1,776 34,662 (27,458) (384) 10,337 17,642 1,741 1,674 33, 107 (25,523) (526) 10,473 16,431