Please help with the questions below. The prompt & references are below:

1. Determine Walmart's WACC. Organize your calculations in a clear and concise manner and state any assumptions 2. If Walmart had preferred stock or planned to issue preferred shares, clearly explain how would Dale and Lee deal with this additional form of financing? 3 How does Walmart's WACC relate to the hurdle rate it might use to evaluate capital investments for growing its business? OVERVIEW In March 2019, Dale and Lee, senior managers from technology firms, were attending an executive education program-Financial Management for Non-Financial Executivesat a highly-regarded business school. They were provided with background readings related to estimating a firm's cost of capital. Their small-group learning team was assigned the task of applying the learnings from the readings and gathering background information related to Walmart Inc. (Walmart) in order to estimate its costs of capital (see Exhibits 1 to 5). The following day, they would participate in a class discussion, share their results, and discuss why the cost of capital was such an important concept. Walmart had humble beginnings: Sam Walton opened the first Walmart store in 1962 in Rogers, Arkansas. Subsequently, Walmart grew to be the world's largest retail store, serving 275 million customers weekly from more than 11,300 stores and numerous e-commerce websites under 58 banners in 27 countries. Walmart's goal was to help people around the world save money and live better, and its strategy was to make every day easier for busy families, operate with discipline sharpen its culture and become digital, and make trust a competitive advantageIn the fiscal year ending January 31, 2019, Walmart had invested over $10 billion in capital expenditures: over $300 million on new stores in the United States; over $2 billion on remodeling, over $5 billion on e-commerce, technology, and supply chain; and $2.7 billion internationally. ESTIMATING THE COST OF CAPITAL Dale and Lee sat down with the information that had been gathered and discussed the task-how they would estimate the cost of capital, and why it was important Page 2 Dale: I think the reason we really care about the cost of capital is that we want to know what hurdle rate Walmart should use for its annual investments in capital projects, which represent billions of dollars each year. Lee: But I'm not sure if it should make any difference to senior management whether the company is investing in more U.S. stores, remodeling, or investing internationally. Shouldn't they want the same return? Dale: Interesting question. So, where should we start? I was thinking we might look at the balance sheet-particularly the liabilities and equity section. Shouldn't that show how Walmart financed its assets, which cost over $200 billion? Lee: Yes, and I think we should try to associate a cost with each of the items. Then we need to figure out how to average them in order to estimate the cost of capital. Dale: I think we need some kind of interest rate, or borrowing rate, for each of the debt components. Or maybe we can just take a look at how much interest Lee: There sure are a lot of interest rates. I noticed on the U.S. Department of Treasury website that three-month treasury bills were yielding 2.45 per cent, while one-, five-, and 10-year treasury bonds were yielding 2.54 per cent, 2.47 per cent and 2.65 per cent, respectively. I pulled together those and some other rates to graph today's yield curve compared with last year's (see Exhibit 1). I wonder if we can somehow use this information. Dale: I found some other interest rates as well. The prime rate is 5.50 per cent, and three- month commercial paper was averaging 2.73 per cent. I read in the annual report that Walmart has issued commercial paper in the past,as part of its short-term borrowingsso perhaps that information might be relevant. I also read that Walmart uses short-term borrowing to provide funds for operations, make capital expenditures, and cover other cash requirements. Lee: Yes, and I read in the same report that Walmart has issued lots of bonds. Other reports showed the same pattern. For example, I noticed that on February 15, 2000, Walmart issued $1 billion in bonds with a coupon rate of 7.55 per cent. The bonds mature on February 15, 2030, around 11 years from now. I also noticed from an online source that these bonds were selling for $136.38 and yielding 3.53 per cent. I think I need to re-read the background material we were provided with because I'm confused about the difference between coupon rates and yields. Which is more relevant for us? Dale: What about preferred shares? I don't think Walmart has any currently, but I read that years ago it issued some kind of securities that were like preferred shares. I don't think the company has any plans to issue new preferred shares in the next little while, but maybe we should be prepared to figure out how it would affect the cost of capital if it did. Lee: How should we go about estimating the cost of equity? Page 3 Dale: I think, since shareholder return is in the form of dividends that shareholders receive, we could examine the annual dividends relative to the current stock price. Over the past year, shareholders received $2.08 per share in dividends. The stock was recently trading for $102.20. Lee: I think earnings are more relevant than dividends. Earnings were down recently because of several one-time write-offs, at the end of the last fiscal year. Walmart recorded $2.26 in unadjusted earnings per share, but $4.91 in adjusted earnings per share. So why not take the earnings yield relative to the stock price? Dale: I wonder if we can estimate an equity return using accounting information such as the book value of equity. I estimated Walmart's return on equity or ROE to be 8.9 per cent as of the fiscal year ending January 31, 2019. For 2018, 2017, and 2016, it was 12.7, 17.2, and 18.1 per cent, respectively. Lee: But that includes retained earnings. Aren't those like free capitaland therefore something we can ignore? Dale: Maybe we're overlooking something; there may be a different approach. Recall that we read about the beta of a stock. It is usually estimated by regressing the return on a stock, like Walmart, against the return on the market, like the S&P 500. According to the Bloomberg terminal we accessed in our library, Walmart's recent "raw" beta was 0.56. It was based on a regression of two years of weekly data. Lee: I noticed that as well. There was also an "adjusted" beta of 0.71. According to Bloomberg, the ad hoc adjustment0.67 times the raw beta plus 0.33always makes the adjusted beta closer to the market's beta of 1.0. They do this because of the assumption that a security's beta tends to move toward the market average over time. Dale: Well, I think if we try to incorporate Walmart's beta, then we need to somehow take into account overall market returns. Lee: We also need to incorporate taxes. I'm not sure how we go about doing that. But I also noticed in the business news that corporate tax rates are now lower than in the recent past due to some new U.S. tax regulations. I read that the new rate is 21 per cent. But a recent press release to accompany Walmart's quarterly returns says the company is anticipating an effective tax rate of around 27 per cent. Dale: What about deferred income taxes? I remember reading that these can arise when a company is allowed to depreciate its assets at a faster rate, for tax purposes, than the actual economic depreciation. Is that money that needs to be paid back to the tax department? If so, what cost is associated with it? Lee: I'm not sure. I also noticed there are other items on the balance sheet under "Liabilities and Equity," and I'm not even sure what they mean. Dale: I may have figured them out: "Other Non-Current Liabilities"which is lumped in with "Deferred Income Taxes" and is probably about half that totalmay have to do with some unrealized losses on hedging instruments. "Other Comprehensive Loss" was related to foreign exchange losses, with the U.S. dollar stronger relative to other currencies. And "Non-Controlling Page 5 EXHIBIT 1: U.S. TREASURY YIELDS 3.5 3.0 2.5 2.0 Vield (%) 15 1.0 0.5 0.0 8 0.25 1 10 20 25 30 15 Time to Maturity (Years) -2/19/2019 ----2/20/2018 Page 6 EXHIBIT 2: WALMART INC., CONSOLIDATED BALANCE SHEET AS OF JANUARY 31 ($ MILLIONS) 2019 2018 ASSETS EXHIBIT 2: WALMART INC., CONSOLIDATED BALANCE SHEET AS OF JANUARY 31 ($ MILLIONS) 2019 2018 ASSETS Current Assets Cash and Equivalents 7,722 6,756 Accounts Receivable 6,283 5,614 Inventory 44,269 43,783 Prepaid Expenses 3.623 3.511 Total Current Assets 61,897 59,664 Net Property, Plant & Equipment 111,395 114,818 Goodwill 31,181 18,242 Other Long-Term Assets 14,822 11.798 Total Assets 219.295 204,522 LIABILITIES Current Liabilities: Accounts Payable 47,060 46,092 Accrued Liabilities 22,159 22,122 Short-Term Borrowings 5,225 5,257 Current Portion of Long-Term Debt & Capital Leases 2,605 4,405 Other Current Liabilities 428 645 Total Current Liabilities 77,477 78,521 Long-Term Debt & Capital Leases 50,203 36,825 Deferred Income Taxes and Other 11.981 8,354 Total Liabilities 139,661 123,700 EQUITY Common Stock and Paid In Capital 3,253 2,943 Retained Earnings 80,785 85,107 Other Comprehensive Income (Loss) (11.542) (10.181) Total Common Equity 72,496 77,869 Non-Controlling Interest 7.138 2.953 Total Equity 79,634 80.822 Total Liabilities & Equity 219.295 204,522 Note: This balance sheet was simplified somewhat for ease of discussion. As of this date there were approximately 2,945 million shares outstanding Page 7 EXHIBIT 3: WALMART INC., CONSOLIDATED INCOME STATEMENT AS OF JANUARY 31 ($ MILLIONS) 2019 2018 Revenue 514,405 500,343 Costs and Expenses: Cost of Goods Sold 385,301 373,396 Operating, Selling, General & Administrative Expenses 107,147 106.510 Total Costs and Expenses 492.448 479.906 Operating Income 21,957 20,437 Interest Expense, Net (2,129) (2,178) Other Items (8.368) (3.136) Income Before Income Taxes 11,460 15,123 Income Tax Expense 4.281 4.600 Net Income 7,179 10,523 Net Income Attrributable to Non-Controlling Interests (509) (661) Net Income Attributable to Walmart Shareholders 6,670 9,862 Note: This income statement was simplified somewhat for ease of discussion. Source: Created by the case author using data from Walmart Inc., 2019 Annual Report, 7, accessed April 30, 2019, https://s2.q4cdn.com/056532643/files/doc_financials/2019/annual/Walmart-2019-AR-Final.pdf. EXHIBIT 4: SELECTED DATA ON WALMART INC., 2007-2019 Year EPS DPS Stock Price 2.71 3.12 0.67 0.88 0.95 1.09 2007 2008 2009 2010 2011 2012 2013 2014 2015 1.21 1.46 3.39 3.71 4.47 4.52 5.02 4.88 5.06 4.58 4.39 3.27 2.28 Total Return 10.07% 7.04% 3.52% 15.03% 1.15% 20.22% 25.97% 11.23% 18.10% -16.17% 13.28% 33.20% 11.64% 36.3 37.98 38.36 43.04 42.33 49.43 60.68 65.61 75.56 61.39 67.54 87.92 96.08 1.59 1.88 1.92 1.96 2016 2 2017 2018 2019 2.04 2.08 Notes: As at fiscal year-end, January 31; EPS = earnings per share: DPS = dividends per share; Total Return = (Dividend + Price Change) = Previous Price. Page 8 EXHIBIT 5: AVERAGE ANNUAL RETURNS IN U.S. CAPITAL MARKETS Page 8 EXHIBIT 5: AVERAGE ANNUAL RETURNS IN U.S. CAPITAL MARKETS OVER THE PERIOD 1928-2018 Column1 S&P 500 (Includes Dividends 3-Month Treasury Bill Return on 10-Year Treasury Bond Arithmetic Average 1928-2018 1969-2018 2009-2018 11.36% 11.10% 13.49% 3.43% 4.76% 0.49% 5.10% 7.10% 2.28% Column 1 S&P 500 (Includes Dividends 3-Month Treasury Bill Return on 10-Year Treasury Bond Geometric Average 1928-2018 1969-2018 2009-2018 9.49% 9.73% 12.98% 3.38% 4.71% 0.49% 4.83% 6.69% 1.97% 1. Determine Walmart's WACC. Organize your calculations in a clear and concise manner and state any assumptions 2. If Walmart had preferred stock or planned to issue preferred shares, clearly explain how would Dale and Lee deal with this additional form of financing? 3 How does Walmart's WACC relate to the hurdle rate it might use to evaluate capital investments for growing its business? OVERVIEW In March 2019, Dale and Lee, senior managers from technology firms, were attending an executive education program-Financial Management for Non-Financial Executivesat a highly-regarded business school. They were provided with background readings related to estimating a firm's cost of capital. Their small-group learning team was assigned the task of applying the learnings from the readings and gathering background information related to Walmart Inc. (Walmart) in order to estimate its costs of capital (see Exhibits 1 to 5). The following day, they would participate in a class discussion, share their results, and discuss why the cost of capital was such an important concept. Walmart had humble beginnings: Sam Walton opened the first Walmart store in 1962 in Rogers, Arkansas. Subsequently, Walmart grew to be the world's largest retail store, serving 275 million customers weekly from more than 11,300 stores and numerous e-commerce websites under 58 banners in 27 countries. Walmart's goal was to help people around the world save money and live better, and its strategy was to make every day easier for busy families, operate with discipline sharpen its culture and become digital, and make trust a competitive advantageIn the fiscal year ending January 31, 2019, Walmart had invested over $10 billion in capital expenditures: over $300 million on new stores in the United States; over $2 billion on remodeling, over $5 billion on e-commerce, technology, and supply chain; and $2.7 billion internationally. ESTIMATING THE COST OF CAPITAL Dale and Lee sat down with the information that had been gathered and discussed the task-how they would estimate the cost of capital, and why it was important Page 2 Dale: I think the reason we really care about the cost of capital is that we want to know what hurdle rate Walmart should use for its annual investments in capital projects, which represent billions of dollars each year. Lee: But I'm not sure if it should make any difference to senior management whether the company is investing in more U.S. stores, remodeling, or investing internationally. Shouldn't they want the same return? Dale: Interesting question. So, where should we start? I was thinking we might look at the balance sheet-particularly the liabilities and equity section. Shouldn't that show how Walmart financed its assets, which cost over $200 billion? Lee: Yes, and I think we should try to associate a cost with each of the items. Then we need to figure out how to average them in order to estimate the cost of capital. Dale: I think we need some kind of interest rate, or borrowing rate, for each of the debt components. Or maybe we can just take a look at how much interest Lee: There sure are a lot of interest rates. I noticed on the U.S. Department of Treasury website that three-month treasury bills were yielding 2.45 per cent, while one-, five-, and 10-year treasury bonds were yielding 2.54 per cent, 2.47 per cent and 2.65 per cent, respectively. I pulled together those and some other rates to graph today's yield curve compared with last year's (see Exhibit 1). I wonder if we can somehow use this information. Dale: I found some other interest rates as well. The prime rate is 5.50 per cent, and three- month commercial paper was averaging 2.73 per cent. I read in the annual report that Walmart has issued commercial paper in the past,as part of its short-term borrowingsso perhaps that information might be relevant. I also read that Walmart uses short-term borrowing to provide funds for operations, make capital expenditures, and cover other cash requirements. Lee: Yes, and I read in the same report that Walmart has issued lots of bonds. Other reports showed the same pattern. For example, I noticed that on February 15, 2000, Walmart issued $1 billion in bonds with a coupon rate of 7.55 per cent. The bonds mature on February 15, 2030, around 11 years from now. I also noticed from an online source that these bonds were selling for $136.38 and yielding 3.53 per cent. I think I need to re-read the background material we were provided with because I'm confused about the difference between coupon rates and yields. Which is more relevant for us? Dale: What about preferred shares? I don't think Walmart has any currently, but I read that years ago it issued some kind of securities that were like preferred shares. I don't think the company has any plans to issue new preferred shares in the next little while, but maybe we should be prepared to figure out how it would affect the cost of capital if it did. Lee: How should we go about estimating the cost of equity? Page 3 Dale: I think, since shareholder return is in the form of dividends that shareholders receive, we could examine the annual dividends relative to the current stock price. Over the past year, shareholders received $2.08 per share in dividends. The stock was recently trading for $102.20. Lee: I think earnings are more relevant than dividends. Earnings were down recently because of several one-time write-offs, at the end of the last fiscal year. Walmart recorded $2.26 in unadjusted earnings per share, but $4.91 in adjusted earnings per share. So why not take the earnings yield relative to the stock price? Dale: I wonder if we can estimate an equity return using accounting information such as the book value of equity. I estimated Walmart's return on equity or ROE to be 8.9 per cent as of the fiscal year ending January 31, 2019. For 2018, 2017, and 2016, it was 12.7, 17.2, and 18.1 per cent, respectively. Lee: But that includes retained earnings. Aren't those like free capitaland therefore something we can ignore? Dale: Maybe we're overlooking something; there may be a different approach. Recall that we read about the beta of a stock. It is usually estimated by regressing the return on a stock, like Walmart, against the return on the market, like the S&P 500. According to the Bloomberg terminal we accessed in our library, Walmart's recent "raw" beta was 0.56. It was based on a regression of two years of weekly data. Lee: I noticed that as well. There was also an "adjusted" beta of 0.71. According to Bloomberg, the ad hoc adjustment0.67 times the raw beta plus 0.33always makes the adjusted beta closer to the market's beta of 1.0. They do this because of the assumption that a security's beta tends to move toward the market average over time. Dale: Well, I think if we try to incorporate Walmart's beta, then we need to somehow take into account overall market returns. Lee: We also need to incorporate taxes. I'm not sure how we go about doing that. But I also noticed in the business news that corporate tax rates are now lower than in the recent past due to some new U.S. tax regulations. I read that the new rate is 21 per cent. But a recent press release to accompany Walmart's quarterly returns says the company is anticipating an effective tax rate of around 27 per cent. Dale: What about deferred income taxes? I remember reading that these can arise when a company is allowed to depreciate its assets at a faster rate, for tax purposes, than the actual economic depreciation. Is that money that needs to be paid back to the tax department? If so, what cost is associated with it? Lee: I'm not sure. I also noticed there are other items on the balance sheet under "Liabilities and Equity," and I'm not even sure what they mean. Dale: I may have figured them out: "Other Non-Current Liabilities"which is lumped in with "Deferred Income Taxes" and is probably about half that totalmay have to do with some unrealized losses on hedging instruments. "Other Comprehensive Loss" was related to foreign exchange losses, with the U.S. dollar stronger relative to other currencies. And "Non-Controlling Page 5 EXHIBIT 1: U.S. TREASURY YIELDS 3.5 3.0 2.5 2.0 Vield (%) 15 1.0 0.5 0.0 8 0.25 1 10 20 25 30 15 Time to Maturity (Years) -2/19/2019 ----2/20/2018 Page 6 EXHIBIT 2: WALMART INC., CONSOLIDATED BALANCE SHEET AS OF JANUARY 31 ($ MILLIONS) 2019 2018 ASSETS EXHIBIT 2: WALMART INC., CONSOLIDATED BALANCE SHEET AS OF JANUARY 31 ($ MILLIONS) 2019 2018 ASSETS Current Assets Cash and Equivalents 7,722 6,756 Accounts Receivable 6,283 5,614 Inventory 44,269 43,783 Prepaid Expenses 3.623 3.511 Total Current Assets 61,897 59,664 Net Property, Plant & Equipment 111,395 114,818 Goodwill 31,181 18,242 Other Long-Term Assets 14,822 11.798 Total Assets 219.295 204,522 LIABILITIES Current Liabilities: Accounts Payable 47,060 46,092 Accrued Liabilities 22,159 22,122 Short-Term Borrowings 5,225 5,257 Current Portion of Long-Term Debt & Capital Leases 2,605 4,405 Other Current Liabilities 428 645 Total Current Liabilities 77,477 78,521 Long-Term Debt & Capital Leases 50,203 36,825 Deferred Income Taxes and Other 11.981 8,354 Total Liabilities 139,661 123,700 EQUITY Common Stock and Paid In Capital 3,253 2,943 Retained Earnings 80,785 85,107 Other Comprehensive Income (Loss) (11.542) (10.181) Total Common Equity 72,496 77,869 Non-Controlling Interest 7.138 2.953 Total Equity 79,634 80.822 Total Liabilities & Equity 219.295 204,522 Note: This balance sheet was simplified somewhat for ease of discussion. As of this date there were approximately 2,945 million shares outstanding Page 7 EXHIBIT 3: WALMART INC., CONSOLIDATED INCOME STATEMENT AS OF JANUARY 31 ($ MILLIONS) 2019 2018 Revenue 514,405 500,343 Costs and Expenses: Cost of Goods Sold 385,301 373,396 Operating, Selling, General & Administrative Expenses 107,147 106.510 Total Costs and Expenses 492.448 479.906 Operating Income 21,957 20,437 Interest Expense, Net (2,129) (2,178) Other Items (8.368) (3.136) Income Before Income Taxes 11,460 15,123 Income Tax Expense 4.281 4.600 Net Income 7,179 10,523 Net Income Attrributable to Non-Controlling Interests (509) (661) Net Income Attributable to Walmart Shareholders 6,670 9,862 Note: This income statement was simplified somewhat for ease of discussion. Source: Created by the case author using data from Walmart Inc., 2019 Annual Report, 7, accessed April 30, 2019, https://s2.q4cdn.com/056532643/files/doc_financials/2019/annual/Walmart-2019-AR-Final.pdf. EXHIBIT 4: SELECTED DATA ON WALMART INC., 2007-2019 Year EPS DPS Stock Price 2.71 3.12 0.67 0.88 0.95 1.09 2007 2008 2009 2010 2011 2012 2013 2014 2015 1.21 1.46 3.39 3.71 4.47 4.52 5.02 4.88 5.06 4.58 4.39 3.27 2.28 Total Return 10.07% 7.04% 3.52% 15.03% 1.15% 20.22% 25.97% 11.23% 18.10% -16.17% 13.28% 33.20% 11.64% 36.3 37.98 38.36 43.04 42.33 49.43 60.68 65.61 75.56 61.39 67.54 87.92 96.08 1.59 1.88 1.92 1.96 2016 2 2017 2018 2019 2.04 2.08 Notes: As at fiscal year-end, January 31; EPS = earnings per share: DPS = dividends per share; Total Return = (Dividend + Price Change) = Previous Price. Page 8 EXHIBIT 5: AVERAGE ANNUAL RETURNS IN U.S. CAPITAL MARKETS Page 8 EXHIBIT 5: AVERAGE ANNUAL RETURNS IN U.S. CAPITAL MARKETS OVER THE PERIOD 1928-2018 Column1 S&P 500 (Includes Dividends 3-Month Treasury Bill Return on 10-Year Treasury Bond Arithmetic Average 1928-2018 1969-2018 2009-2018 11.36% 11.10% 13.49% 3.43% 4.76% 0.49% 5.10% 7.10% 2.28% Column 1 S&P 500 (Includes Dividends 3-Month Treasury Bill Return on 10-Year Treasury Bond Geometric Average 1928-2018 1969-2018 2009-2018 9.49% 9.73% 12.98% 3.38% 4.71% 0.49% 4.83% 6.69% 1.97%