Estimating Walmarts Cost of Capital.xlsx

BALANCE SHEET AS OF JANUARY 31 ($ MILLIONS) ASSETS Current Assets: Cash and Equivalents Accounts Receivable Inventory Pr

Views 201 Downloads 5 File size 87KB

Report DMCA / Copyright

DOWNLOAD FILE

Recommend stories

Citation preview

BALANCE SHEET AS OF JANUARY 31 ($ MILLIONS) ASSETS Current Assets: Cash and Equivalents Accounts Receivable Inventory Prepaid Expenses Total Current Assets Net Property, Plant & Equipment Goodwill Other Long-Term Assets

2019

2018

7722 6283 44269 3623 61897 111395 31181 14822

6756 5614 43783 3511 59664 114818 18242 11798

Total Assets

219295

204522

LIABILITIES Current Liabilities: Accounts Payable Accrued Liabilities Short-Term Borrowings Current Portion of Long-Term Debt & Capital Leases Other Current Liabilities Total Current Liabilities Long-Term Debt & Capital Leases Deferred Income Taxes and Other Total Liabilities

47060 22159 5225 2605 428 77477 50203 11981 139661

46092 22122 5257 4405 645 78521 36825 8354 123700

EQUITY Common Stock and Paid-In Capital Retained Earnings Other Comprehensive Income (Loss) Total Common Equity Non-Controlling Interest Total Equity

3253 80785 -11542 72496 7138 79634

2943 85107 -10181 77869 2953 80822

Total Liabilities & Equity

219295

204522

INCOME STATEMENT ($ MILLIONS)

2019

2018

Revenue

514,405

500,343

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

(509)

(661)

6,670

9,862

Net Income Attrributable to Non-Controlling Interests Net Income Attributable to Walmart Shareholders

Exhibit 4 Year EPS 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019

DPS 2.71 3.12 3.39 3.71 4.47 4.52 5.02 4.88 5.06 4.58 4.39 3.27 2.28

Stock Price Total Return Growth Rate Payout ratio 0.67 36.30 10.07% 0.247232 0.88 37.98 7.04% 4.63% 0.282051 0.95 38.36 3.52% 1.00% 0.280236 1.09 43.04 15.03% 12.20% 0.293801 1.21 42.33 1.15% -1.65% 0.270694 1.46 49.43 20.22% 16.77% 0.323009 1.59 60.68 25.97% 22.76% 0.316733 1.88 65.61 11.23% 8.12% 0.385246 1.92 75.56 18.10% 15.17% 0.379447 1.96 61.39 -16.17% -18.75% 0.427948 2.00 67.54 13.28% 10.02% 0.455581 2.04 87.92 33.20% 30.17% 0.623853 2.08 96.08 11.64% 9.28% 0.912281 9.1435% -0.76119403

Exhibit 5 Arithmetic Average 1928-2018

S&P 500 Return 3-Month Treasury Billon 10- Year Treasury Bond (Includes Dividends) 11.36%

3.43%

5.10%

1969-2018

11.10%

4.76%

7.10%

2009-2018

13.49%

0.49%

2.28%

1928-2018

9.49%

3.38%

4.83%

1969-2018

9.73%

4.71%

6.69%

2009-2018

12.98%

0.49%

1.97%

Geometric Average

0 1 2 3 4 5 6

-100000 30000 30000 30000 25000 25000 25000 17.3%

Cost of Equity Dividends recd Common Stock and Paid-In Capital (2019) Common Stock and Paid-In Capital (2018) COE

2.08 3253 2943 9.2142%

ROE (2019) ROE (2018)

8.9 12.7