The information is below as follows:

Capital structure in perfect markets vs. with taxes (11 Mark) In preparing the report, you decide to start from the scenario where the capital markets are perfect. Using Excel spreadsheets, you complete the following: 1. Compute the market debt to equity (D/E) ratio, the cost of equity (TE) and the weighted average cost of capital (WACC) for HD. It is assumed the cost of unlevered equity (ru) is 14.8%. (Hint: the market value of debt is the sum of Long Term Debt and Short Term Debt/Current Portion of Long Term Debt subtracting Cash and Cash Equivalents from the balance sheet. Use market value of equity.) 2. Repeat the above assuming that market frictions exist, such as corporate tax. HD's business HD was a large producer of branded appliances primarily used in residential households. For the period 2015-2019 the industry posted modest annual unit sales growth of 1.8% despite positive market conditions including a strong housing market and product innovations. Competition from inexpensive imports and aggressive pricing by Mass Merchandisers Limited has reduced growth to 2.5% annually over the period. Under its CEO Benjamin White's leadership, HD operated much as it always had, with three notable exceptions. First, the company completed an IPO (Initial Public Offering) in 2014. This provided a measure of liquidity for founders' descendants who, collectively, owned 62% of the outstanding shares following the IPO. Second, beginning in the 2010s, HD has gradually moved its production abroad. Finally, HD had undertaken a strategy focused on rounding out and complementing its product offerings by acquiring small independent manufacturers and/or the kitchen appliance product lines of large diversified manufacturers. Thus far, all acquisitions had been for cash or HD stock. HD's historical performance During the year ended December 31, 2019, HD eamed net income of $8.25 billion on revenue of $83.18 billion. Exhibits 1 and 2 present the company's recent financial statements. The company's 2019 EBIT margin of nearly 7.0% was average within the peer group. During 2015- 2019, compounded annual retums for HD shareholders (including dividends and stock price appreciation) was approximately 11.1% per year. This was higher than the ASX S&P200, which returned approximately 5% per year. However, it was well below the 16% annual compounded return earned by shareholders of HD's peer group during the same period. HD's financial policies HD's financial position was conservative and very much in keeping with HD's long- standing practice and, with its management style. In recent years the company's largest uses of cash 31/12/2019 Case Exhibit 1: HD's Balance Sheet (in 000s) Balance Sheet (000s) Period Ending: Current Assets Cash and Cash Equivalents Short Term Investments Net Receivables Inventory Other Current Assets Total Current Assets 1,723,000 0 1,484.000 11,079,000 1,016,000 15,302,000 Long Term Assets Fixed Assets Goodwill Intangible Assets Other Assets Total Assets 22,720,000 1,353,000 0 571.000 39,946,000 Liabilities & stock holders' Equity: Accounts Payable Short Term Debt Current Portion of Long Term Debt Other Current Liabilities Total Current Liabilities 9,473,000 328.000 1,468,000 11,269,000 Long Term Debt Other Liabilities Deferred Liability Charges Total Liabilities 16,869,000 1,844,000 642.000 30,624,000 Share Holders Equity Common Stocks Capital Surplus Retained Earnings Treasury Stock Other Equity Total Equity 88,000 8,885,000 26,995,000 -26194000 452000 9,322,000 Case Exhibit 2: HD's Income Statement (in 000) Income Statement (000s) Period Ending: Total Revenue Cost of Revenue Gross Profit 31/12/2019 83,176,000 54,222,000 28,954,000 Operating Expenses Sales, General and Admin. Other Operating Items Operating Income Additional income/expense items EBIT Interest Expense Earnings Before Tax Income Tax Net Income-Cont. Operations Net Income Applicable to common shareholders 21,884,200 2,146,300 13,609,700 438,100 14,047,800 1,079,000 12,968,800 4,720,300 8,248,500 6,598,800 Capital structure in perfect markets vs. with taxes (11 Mark) In preparing the report, you decide to start from the scenario where the capital markets are perfect. Using Excel spreadsheets, you complete the following: 1. Compute the market debt to equity (D/E) ratio, the cost of equity (TE) and the weighted average cost of capital (WACC) for HD. It is assumed the cost of unlevered equity (ru) is 14.8%. (Hint: the market value of debt is the sum of Long Term Debt and Short Term Debt/Current Portion of Long Term Debt subtracting Cash and Cash Equivalents from the balance sheet. Use market value of equity.) 2. Repeat the above assuming that market frictions exist, such as corporate tax. HD's business HD was a large producer of branded appliances primarily used in residential households. For the period 2015-2019 the industry posted modest annual unit sales growth of 1.8% despite positive market conditions including a strong housing market and product innovations. Competition from inexpensive imports and aggressive pricing by Mass Merchandisers Limited has reduced growth to 2.5% annually over the period. Under its CEO Benjamin White's leadership, HD operated much as it always had, with three notable exceptions. First, the company completed an IPO (Initial Public Offering) in 2014. This provided a measure of liquidity for founders' descendants who, collectively, owned 62% of the outstanding shares following the IPO. Second, beginning in the 2010s, HD has gradually moved its production abroad. Finally, HD had undertaken a strategy focused on rounding out and complementing its product offerings by acquiring small independent manufacturers and/or the kitchen appliance product lines of large diversified manufacturers. Thus far, all acquisitions had been for cash or HD stock. HD's historical performance During the year ended December 31, 2019, HD eamed net income of $8.25 billion on revenue of $83.18 billion. Exhibits 1 and 2 present the company's recent financial statements. The company's 2019 EBIT margin of nearly 7.0% was average within the peer group. During 2015- 2019, compounded annual retums for HD shareholders (including dividends and stock price appreciation) was approximately 11.1% per year. This was higher than the ASX S&P200, which returned approximately 5% per year. However, it was well below the 16% annual compounded return earned by shareholders of HD's peer group during the same period. HD's financial policies HD's financial position was conservative and very much in keeping with HD's long- standing practice and, with its management style. In recent years the company's largest uses of cash 31/12/2019 Case Exhibit 1: HD's Balance Sheet (in 000s) Balance Sheet (000s) Period Ending: Current Assets Cash and Cash Equivalents Short Term Investments Net Receivables Inventory Other Current Assets Total Current Assets 1,723,000 0 1,484.000 11,079,000 1,016,000 15,302,000 Long Term Assets Fixed Assets Goodwill Intangible Assets Other Assets Total Assets 22,720,000 1,353,000 0 571.000 39,946,000 Liabilities & stock holders' Equity: Accounts Payable Short Term Debt Current Portion of Long Term Debt Other Current Liabilities Total Current Liabilities 9,473,000 328.000 1,468,000 11,269,000 Long Term Debt Other Liabilities Deferred Liability Charges Total Liabilities 16,869,000 1,844,000 642.000 30,624,000 Share Holders Equity Common Stocks Capital Surplus Retained Earnings Treasury Stock Other Equity Total Equity 88,000 8,885,000 26,995,000 -26194000 452000 9,322,000 Case Exhibit 2: HD's Income Statement (in 000) Income Statement (000s) Period Ending: Total Revenue Cost of Revenue Gross Profit 31/12/2019 83,176,000 54,222,000 28,954,000 Operating Expenses Sales, General and Admin. Other Operating Items Operating Income Additional income/expense items EBIT Interest Expense Earnings Before Tax Income Tax Net Income-Cont. Operations Net Income Applicable to common shareholders 21,884,200 2,146,300 13,609,700 438,100 14,047,800 1,079,000 12,968,800 4,720,300 8,248,500 6,598,800