This imput table is NOT assessed. It supports the analysis of the case on Bell Technology:...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
This imput table is NOT assessed. It supports the analysis of the case on Bell Technology: Capital Structure, Valuation, and Cost of Capital Corporate Tax Rate Personal tax rate Current Share Price Num Shares Outstanding (see Final tips; in millions) Equity Beta rf (risk free rate = 20-yr treasury rate) Risk premium (= rm -rf) rD (yield on AAA corporate debt) Divident payout ratio 25% na 45.98% (in thousands, except per share amounts) EARNINGS Net sales Cost of sales Gross Profit Selling and general administrative expenses Operating income Investment income Other expense Earnings before income taxes (EBIT) Income taxes (@25%) Net earnings Income statement $ $ $ $ $ $ $ $ $ $ 2021 3,429,646 $ 997,054 $ 2,432,592 $ 919,236 $ 1,513,356 $ 18,553 $ (4,543) $ 1,527,366 $ 381,842 $ 1,145,525 $ 2020 2,145,706 $ 904,266 $ 1,241,440 $ 778,197 $ 463,243 $ 19,185 $ (3,116) $ 479,312 $ 119,828 $ 359,484 $ 2019 2,061,602 904,183 1,157,419 721,813 435,606 17,636 (8,812) 444,430 111,108 333,323 Capital Market Conditions U.S. Treasury Obligations 3-mos. 6 mos. 1 yr. 2 yr. 3 yr. 5 yr. 7 yr. 10 yr. 20 yr. Corporate Debt Obligations (10-year) AAA AA A BBB BB B Other Instruments U.S. Federal Reserve Bank Discount Rate LIBOR (1-month) Certificates of Deposit (6-month) Prime Interest Rates Yield 1.670% 1.710% 2.310% 3.160% 3.660% 4.090% 4.520% 4.860% 5.650% Yield 9.307% 9.786% 10.083% 10.894% 12.753% 14.663% Yield 1.730% 1.840% 1.980% 4.750% U.S. Treasury yield curve 6% 5% 4% 3% 2% 1% 0% 3 mos. 6 mos. 1 yr. 2 yr. 3 yr. 5 yr. 7 yr. 10 yr. 20 yr. (in thousands of dollars) ASSETS Current assets: Cash and equivalents Short-term investments, at amortized cost Accounts receivable (less allowance for doubtful accounts: 2001 - $7,712, 2000 - $7,065) Inventories Finished goods Raw materials and suppplies Other current assets Deferred income taxes - current Total current assets Marketable equity securities, at fair value Deferred charges and other assets Deferred income taxes - non-current Property, plant, and equipment (at cost) Land Buildings and building equipment Machinery and equipment Consolidated Balance Sheet Less accumulated depreciation $ $ $ $ $ $ $ $ $ $ $ $ $ $ 2021 221,946 $ 25,450 $ 239,885 $ 75,693 $ 203,288 $ 278,981 $ 46,896 $ 14,856 $ 828,014 $ 25,300 $ 115,745 $ 26,381 $ 219,312 $ 359,109 $ 857,044 $ 1,435,465 $ 571,717 $ 2020 300,599 29,301 191,570 64,676 188,615 253,291 39,728 14,226 828,715 28,535 83,713 26,743 39,125 344,457 756,050 1,139,632 532,598 Less accumulated depreciation Net, property plant and equipment TOTAL ASSETS LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Accounts payable Short term debt Dividends payable Income and other taxes payable Deferred income taxes - current Total current liabilities Deferred income taxes - non-current Other non-current liabilities Common stock (565.9 million shares outstanding) Class B common stock (332.7 million shares outstanding) Additional paid-in capital Retained earnings Treasury stock Accumulated other comprehensive income Total stockholders' equity TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 571,717 $ 863,748 $ 1,859,188 $ 91,223 $ 221,948 $ 42,711 $ 68,437 $ 1,455 $ 425,774 $ 43,206 $ 113,921 $ 12,646 $ 2,850 $ 1,153 $ 1,684,337 $ (289,799) $ (134,900) $ 1,276,287 $ 1,859,188 $ 532,598 607,034 1,574,740 73,129 113,779 39,467 60,976 859 288,210 40,144 113,489 12,558 2,938 346 1,492,547 (256,478) (119,014) 1,132,897 1,574,740 Financial Characteristics of Major Confectionary Firms in the Industry (Hypothetical) Company Name Pear Inc. HQ in Cupertino Phoebes. HQ in Mountain View Microtender. HQ in Redmond Facegram. HQ in Menlo Park Bell Technologies. HQ in Round Rock Company Name Pear Inc. HQ in Cupertino Phoemes. HQ in Mountain View Microtender. HQ in Redmond Facegram. HQ in Menlo Park Bell Technologies. HQ in Round Rock $ $ $ $ $ Recent Price 26.66 65.45 38.82 31.17 15.69 Beta 0.74 0.90 0.70 0.65 0.81 CommoUIT Shares Outstanding Market Value of (millions) Equity (millions) 502.50 $ 136.63 $ 1,735.00 $ 51.66 $ #REF! EPS 1.39 2.74 1.17 1.30 #REF! Book Value of Equity (millions) 13,397 $ 8,942 $ 67,353 $ 1,610 $ $ #REF! 5,264 $ 2,785 $ 39,920 $ 509 $ 1,276 $ Price/ Earnings Cash Dividend 15.20 $ 20.40 $ 18.70 $ 24.00 $ #REF! $ Total Long- term Debt 0.67 1.16 0.26 0.28 0.10 (millions) 2,264 869 8,548 840 Dividend Payout ratio 44.0% 41.0% 12.0% 22.0% 46.0% Dividend Yield 2.50% 2.00% 1.50% 0.90% 0.64% Question 3 (Q3) Impact of leverage on the cost of capital (WACC) Combining with your answers to Question 2, how does this debt, in each scenario of being used to repurchase shares or to pay a special dividend, affect BT's capital structure, the cost of capital (WACC), total value, and share price? Which alternative would you recommend? Tips: 1. Complete the table under Q3 in Excel spreadsheet Q2 Valuation & Q3 WACC. 2 Show your calculations in a MS Word document. All values are in millions except for share price and percentages a. Interest tax shield New debt (in million $s) PV(Int Tax Shields) in million $s b. Effect of additional debt on the value of WWJ and price per share New cash Interest tax shield (ITS) Total mkt value of assets Shares repurchased Num. shares outstanding Stock Price E D Total mkt value of assets 5,000 Pre-recapitalization 0 na At debt issue announcement na At debt issuance na Two scenarios post-recapitalization 2. Pay special dividend 1. Repurchase shares na All values are in millions except for share price and percentages D E Total mkt value of assets D/(D+E) E/(D+E) pre-tax WACC (rU) rE (See spreadsheet Other Info) rD (See spreadsheet Credit Rating) WACC Pre-recapitalization BLANK Two scenarios post-recapitalization 1. Repurchase 2. Pay special shares dividend This imput table is NOT assessed. It supports the analysis of the case on Bell Technology: Capital Structure, Valuation, and Cost of Capital Corporate Tax Rate Personal tax rate Current Share Price Num Shares Outstanding (see Final tips; in millions) Equity Beta rf (risk free rate = 20-yr treasury rate) Risk premium (= rm -rf) rD (yield on AAA corporate debt) Divident payout ratio 25% na 45.98% (in thousands, except per share amounts) EARNINGS Net sales Cost of sales Gross Profit Selling and general administrative expenses Operating income Investment income Other expense Earnings before income taxes (EBIT) Income taxes (@25%) Net earnings Income statement $ $ $ $ $ $ $ $ $ $ 2021 3,429,646 $ 997,054 $ 2,432,592 $ 919,236 $ 1,513,356 $ 18,553 $ (4,543) $ 1,527,366 $ 381,842 $ 1,145,525 $ 2020 2,145,706 $ 904,266 $ 1,241,440 $ 778,197 $ 463,243 $ 19,185 $ (3,116) $ 479,312 $ 119,828 $ 359,484 $ 2019 2,061,602 904,183 1,157,419 721,813 435,606 17,636 (8,812) 444,430 111,108 333,323 Capital Market Conditions U.S. Treasury Obligations 3-mos. 6 mos. 1 yr. 2 yr. 3 yr. 5 yr. 7 yr. 10 yr. 20 yr. Corporate Debt Obligations (10-year) AAA AA A BBB BB B Other Instruments U.S. Federal Reserve Bank Discount Rate LIBOR (1-month) Certificates of Deposit (6-month) Prime Interest Rates Yield 1.670% 1.710% 2.310% 3.160% 3.660% 4.090% 4.520% 4.860% 5.650% Yield 9.307% 9.786% 10.083% 10.894% 12.753% 14.663% Yield 1.730% 1.840% 1.980% 4.750% U.S. Treasury yield curve 6% 5% 4% 3% 2% 1% 0% 3 mos. 6 mos. 1 yr. 2 yr. 3 yr. 5 yr. 7 yr. 10 yr. 20 yr. (in thousands of dollars) ASSETS Current assets: Cash and equivalents Short-term investments, at amortized cost Accounts receivable (less allowance for doubtful accounts: 2001 - $7,712, 2000 - $7,065) Inventories Finished goods Raw materials and suppplies Other current assets Deferred income taxes - current Total current assets Marketable equity securities, at fair value Deferred charges and other assets Deferred income taxes - non-current Property, plant, and equipment (at cost) Land Buildings and building equipment Machinery and equipment Consolidated Balance Sheet Less accumulated depreciation $ $ $ $ $ $ $ $ $ $ $ $ $ $ 2021 221,946 $ 25,450 $ 239,885 $ 75,693 $ 203,288 $ 278,981 $ 46,896 $ 14,856 $ 828,014 $ 25,300 $ 115,745 $ 26,381 $ 219,312 $ 359,109 $ 857,044 $ 1,435,465 $ 571,717 $ 2020 300,599 29,301 191,570 64,676 188,615 253,291 39,728 14,226 828,715 28,535 83,713 26,743 39,125 344,457 756,050 1,139,632 532,598 Less accumulated depreciation Net, property plant and equipment TOTAL ASSETS LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Accounts payable Short term debt Dividends payable Income and other taxes payable Deferred income taxes - current Total current liabilities Deferred income taxes - non-current Other non-current liabilities Common stock (565.9 million shares outstanding) Class B common stock (332.7 million shares outstanding) Additional paid-in capital Retained earnings Treasury stock Accumulated other comprehensive income Total stockholders' equity TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 571,717 $ 863,748 $ 1,859,188 $ 91,223 $ 221,948 $ 42,711 $ 68,437 $ 1,455 $ 425,774 $ 43,206 $ 113,921 $ 12,646 $ 2,850 $ 1,153 $ 1,684,337 $ (289,799) $ (134,900) $ 1,276,287 $ 1,859,188 $ 532,598 607,034 1,574,740 73,129 113,779 39,467 60,976 859 288,210 40,144 113,489 12,558 2,938 346 1,492,547 (256,478) (119,014) 1,132,897 1,574,740 Financial Characteristics of Major Confectionary Firms in the Industry (Hypothetical) Company Name Pear Inc. HQ in Cupertino Phoebes. HQ in Mountain View Microtender. HQ in Redmond Facegram. HQ in Menlo Park Bell Technologies. HQ in Round Rock Company Name Pear Inc. HQ in Cupertino Phoemes. HQ in Mountain View Microtender. HQ in Redmond Facegram. HQ in Menlo Park Bell Technologies. HQ in Round Rock $ $ $ $ $ Recent Price 26.66 65.45 38.82 31.17 15.69 Beta 0.74 0.90 0.70 0.65 0.81 CommoUIT Shares Outstanding Market Value of (millions) Equity (millions) 502.50 $ 136.63 $ 1,735.00 $ 51.66 $ #REF! EPS 1.39 2.74 1.17 1.30 #REF! Book Value of Equity (millions) 13,397 $ 8,942 $ 67,353 $ 1,610 $ $ #REF! 5,264 $ 2,785 $ 39,920 $ 509 $ 1,276 $ Price/ Earnings Cash Dividend 15.20 $ 20.40 $ 18.70 $ 24.00 $ #REF! $ Total Long- term Debt 0.67 1.16 0.26 0.28 0.10 (millions) 2,264 869 8,548 840 Dividend Payout ratio 44.0% 41.0% 12.0% 22.0% 46.0% Dividend Yield 2.50% 2.00% 1.50% 0.90% 0.64% Question 3 (Q3) Impact of leverage on the cost of capital (WACC) Combining with your answers to Question 2, how does this debt, in each scenario of being used to repurchase shares or to pay a special dividend, affect BT's capital structure, the cost of capital (WACC), total value, and share price? Which alternative would you recommend? Tips: 1. Complete the table under Q3 in Excel spreadsheet Q2 Valuation & Q3 WACC. 2 Show your calculations in a MS Word document. All values are in millions except for share price and percentages a. Interest tax shield New debt (in million $s) PV(Int Tax Shields) in million $s b. Effect of additional debt on the value of WWJ and price per share New cash Interest tax shield (ITS) Total mkt value of assets Shares repurchased Num. shares outstanding Stock Price E D Total mkt value of assets 5,000 Pre-recapitalization 0 na At debt issue announcement na At debt issuance na Two scenarios post-recapitalization 2. Pay special dividend 1. Repurchase shares na All values are in millions except for share price and percentages D E Total mkt value of assets D/(D+E) E/(D+E) pre-tax WACC (rU) rE (See spreadsheet Other Info) rD (See spreadsheet Credit Rating) WACC Pre-recapitalization BLANK Two scenarios post-recapitalization 1. Repurchase 2. Pay special shares dividend
Expert Answer:
Answer rating: 100% (QA)
Impact of Leverage on the Cost of Capital WACC This analysis explores the impact of debt on Bell Technologies BT capital structure cost of capital WAC... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
Create a GPA calculator in Java. Ask the end user for the credit hours and letter grade for each class. Once the user is finished with the data entry, calculate and output the overall GPA for the...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
This case study on project evaluation is applicable for beginning courses in corporate finance or finance strategy. Two alternative investment options are available to evaluate. Challenges are...
-
Assume a memory hierarchy with two levels of cache, L1 and L2. a. What is the miss rate (MR1) for L1 if there are 75 misses per 1000 memory references? b. What is the miss rate (MR2) for L2 if there...
-
A candy shop sells various items for the price per pound (in dollars) indicated in matrix A. Matrix B gives the number of pounds of coated peanuts, raisins, and espresso beans prepared in a week....
-
Six individuals, including A and B, take seats around a circular table in a completely random fashion. Suppose the seats are numbered 1, . . . , 6. Let X = A's seat number and Y = B's seat number. If...
-
Has a reduction in working capital of 1% the same impact on a DCF as a 1% improvement in the EBIT margin?
-
Formulate Linear Programming Model (Excel Solver) Model To Calculate Optimal Quantity Of The Products To Maximize Profit? The Production manager of a paper manufacturing company must determine the...
-
Consider the following vector equation. r(t) = (3t 4, t + 2) (a) Find r'(t).
-
200mm Live load = 5 kN/m? 4 m Figure Qla 3 m 3 m Figure Qlb 120mm x10mm plate welded to underside of the RHS
-
Imagine, you have an opportunity to spend $1USD to plant a tree from every product (~$70USD) you sell. You need to prove/show consumers in a simple infographic that your activity is sustainable.
-
In what ways does the regulation of corporate securities differ from the regulation of other types of financial products? What regulatory philosophy underlies the regulation of corporate securities
-
Q3) Write the network model and 2 iterations of the network simplex for the following network. b1=3 b2=-1 3 b3=-1 1 b4=-1
-
Suppose a 10% 3years bond with a FV of $1000 Spot rates r1= 10%, r2= 12%, r3=13%. Calculate the forward rate required to calculate the bond price using the forward rate 1f2
-
What is the maximum price Cooper should be willing to pay for all of Nicholson's common stock? To answer this question, project Nicholson's free cash flows for the years 1972-1976 assuming a 6% per...
-
You have a random word generator which generates 5 letter wordsusing letters A-J a) how many words can be randomly generated that are inalphabetical order? (no repeats) b) with repeats? c) exactly 2...
-
Evaluate each logarithm to four decimal places. log 0.257
-
The following additional information is available for the Dr. Ivan and Irene Incisor family. Ivan and Irene have the following investment income, in addition to that reported in Chapter 1: Dividends...
-
Sally and Charles Heck received the following dividends and interest during 2012: Assuming the Hecks file a joint tax return, complete Schedule B of Form 1040 (on page 2-33) for them for the 2012 tax...
-
a. Wilson filed his individual tax return on the original due date, but failed to pay $700 in taxes that were due with the return. If Wilson pays the taxes exactly 2 months late, calculate the amount...
-
Antonio Rossi set up a part-time business on 1 November 2004 buying and selling second-hand sports cars. On 1 November 2004 he commenced business with $66,000 which he immediately used to purchase...
-
Why is it necessary for financial reporting to be subject to (a) mandatory control and (b) statutory control?
-
How is it possible to make shareholders aware of the significance of the exercise of judgement by directors which can turn profits of 6m into losses of 2m?
Study smarter with the SolutionInn App