PLUS1
Wesfarmers Financial Data
| Company name: | Wesfarmers Ltd | Status: | Active |
| End of fiscal year: | 30 June 2018 | ISIN | AU000000WES1 |
| Auditor: | EY | Year established: | 1914 |
| Company sector name: | Consumer Cyclical | Trading currency: | AUD |
| Industry name: | Home Improvement Stores | Place of incorporation: | Australia (AU) |
| Industry group name | Retail - Apparel & Specialty | Doing business in: | Australia (AU) |
| Address | 123 St Georges Terrace Level 14, Brookfield Place Tower 2, 6000 | Tel.: | +61 893274211 |
| City/Country: | Perth, Australia | Fax: | +61 893274216 |
| Web address: | http://www.wesfarmers.com.au |
| Company description: | Wesfarmers is Australia's largest conglomerate. Its retail operations include the Bunnings hardware chain (number one in market share), discount department stores Kmart and Target (number one and three) and Officeworks in office supplies (number one). These activities account for the vast majority of group EBIT. Other operations include chemicals, fertilisers, industrial and medical gases, LPG production and distribution, and industrial and safety supplies. Management is focused on generating cash and creating shareholder wealth in the long term. |
| Price | Price change [%] | Bid | Offer | Open | High | Low | Volume |
|---|---|---|---|---|---|---|---|
| 46.71 | -0.96[-2.01%] | 46.72 | 46.90 | 47.41 | 47.47 | 46.69 | 1,202,724 |
| Market Cap. [m] | Shares In Issue [m] | Beta | EPS | DPS | PE Ratio | Yield | 52-Wks-Range |
| 53914.77 | 1133.840242 | 1.03 | 1.06 | 2.23 | 45.04 | 4.68 | 0.11 - 67.75 |
WES KEY FIGURES (at previous day's close) | |
|---|---|
Yesterday's Close | 47.67 |
PE Ratio | 45.04 |
Market Capitalisation | 53.91B |
Latest Shares Outstanding | 1.13B |
Earnings pS (EPS) | 1.06 |
Dividend pS (DPS) | 2.23 |
Dividend Yield | 4.68% |
Sales per Employee | 306.88k |
Effective Tax Rate | - |
Foreign Sales | - |
Domestic Sales | - |
Selling, General & Adm/tive (SG... | 21.24% |
Research & Devlopment (R&D) as ... | 0.00% |
Gross Profit Margin | 31.35% |
EBITDA Margin | 7.90% |
Pre-Tax Profit Margin | 5.78% |
Assets Turnover | 0.55% |
Return on Assets (ROA) | 0.03% |
Return on Equity (ROE) | 0.05% |
Return on Capital Invested (ROC... | 0.05% |
Current Ratio | 0.87 |
Leverage Ratio (Assets/Equity) | 1.62% |
Interest Cover | 24.92 |
Total Debt/Equity (Gearing Rati... | 0.18% |
LT Debt/Total Capital | 0.12% |
Working Capital pS | 23.79 |
Cash pS | 0.60 |
Book-Value pS | 16.86 |
Tangible Book-Value pS | 9.17 |
Cash Flow pS | - |
Free Cash Flow pS | 2.00 |
Spread | 0.18 |
Gross gearing | 0.00% |
Net Debt | -683.00M |
WES Balance Sheet Chart (30 June 2018) | ||
|---|---|---|
 | ||
| Period † | High | Low |
|---|---|---|
| 1 Week | 48.01 | 29.01 |
| 1 Month | 58.01 | 29.01 |
| 3 Months | 64.00 | 26.01 |
| 6 Months | 64.00 | 26.01 |
| 1 Year | 67.75 | 0.11 |
| 3 Years | 280.665 | 0.11 |
| 5 Years | 280.665 | 0.11 |
Share price performance previous 3 years |
|---|
Share price performance intraday |
|---|
| Period † | Open | Open Avg. | VWAP | Min Vol | Max Vol | Avg. Daily Vol | Change | % |
|---|---|---|---|---|---|---|---|---|
| 1 Week | 46.59 | 47.164 | 47.10 | 889,871 | 1,664,004 | 1,384,482 | 0.12 | 0.26% |
| 1 Month | 44.85 | 46.38 | 46.37 | 889,871 | 2,694,282 | 1,600,762 | 1.86 | 4.15% |
| 3 Months | 49.95 | 45.4514 | 44.97 | 889,871 | 6,781,724 | 2,045,533 | -3.24 | -6.49% |
| 6 Months | 53.24 | 47.7878 | 47.56 | 889,871 | 6,781,724 | 2,081,990 | -6.53 | -12.27% |
| 1 Year | 63.71 | 52.9745 | 52.11 | 387,264 | 8,153,318 | 1,889,847 | -17.00 | -26.68% |
| 3 Years | 38.00 | 48.6377 | 47.31 | 39,718 | 9,399,769 | 1,947,878 | 8.71 | 22.92% |
| 5 Years | 40.97 | 46.2593 | 44.95 | 39,718 | 10,293,792 | 2,068,190 | 5.74 | 14.01% |
WES Growth Ratios (30 June 2018) | ||||
|---|---|---|---|---|
| 1 year | 3 years | 5 years | 10 years | |
Diluted EPS growth | -0.58 | -0.21 | -0.12 | -0.05 |
Diluted continuous EPS growth | -0.10 | 0.02 | 0.03 | 0.03 |
Dividend growth | 0.13 | 0.00 | 0.05 | 0.01 |
Equity per share growth | -0.05 | -0.03 | -0.06 | -0.02 |
Revenue growth | -0.02 | 0.02 | 0.02 | 0.07 |
Operating income growth | 0.06 | 0.07 | 0.03 | 0.07 |
Net income growth | -0.58 | -0.21 | -0.12 | 0.01 |
Net income cont growth | -0.09 | 0.02 | 0.03 | 0.10 |
CFO growth | -0.03 | 0.02 | 0.01 | 0.11 |
FCF growth | -0.11 | 0.13 | 0.07 | 0.31 |
Operating revenue growth | -0.02 | 0.02 | 0.02 | 0.07 |
WES Income Statement 30 June 2018 (AUD) | |
|---|---|
Total Revenue | 66594 |
Operating Revenue | 66594 |
Cost of Revenue | 45718 |
Gross Profit | 20876 |
Operating Expenses | 17063 |
Selling,General and Administr... | 14147 |
General and Administrative Ex... | 13390 |
Salary and Benefit | 9375 |
Rent and Landing Fees | 2976 |
OtherGandA | 1039 |
Selling and Marketing Expense | 757 |
Depreciation,Amortization and... | 1198 |
Depreciation and Amortization | 1198 |
Depreciation | 913 |
Amortization | 285 |
Amortization of Intangibles | 285 |
Other Operating Expenses | 1718 |
Operating Income | 3813 |
Interest Income/Expense,Net-N... | -197 |
Interest Income-Non Operating | 14 |
Interest Expense-Non Operatin... | 211 |
Other Income/Expense,Net | 234 |
Earnings from Equity Interest | 97 |
Special Income/Charges | -359 |
Impairment of Capital Assets | 421 |
Gain on Sale of Property,Plan... | 62 |
Other Non-Operating Income/Ex... | 496 |
Pretax Income | 3850 |
Provision for Income Tax | 1246 |
Net Income Available to Commo... | 1197 |
Net Income | 1197 |
Net Income Including Noncontr... | 1197 |
Net Income from Continuing Op... | 2604 |
Discontinued Operations | -1407 |
Basic EPS | 1.06 |
Basic EPS from Continuing Ope... | 2.30 |
Basic EPS from Discontinued O... | -1.24 |
Diluted EPS | 1.06 |
Diluted EPS from Continuing O... | 2.30 |
Diluted EPS from Discontinued... | -1.24 |
Basic Weighted Average Shares... | 1131 |
Diluted Weighted Average Shar... | 1132.98627544 |
Dividend Per Share | 2.23 |
Net Income from Continuing an... | 1197 |
Normalized Income | 2846.81454545 |
Basic EPS,Continuing and Disc... | 1.06 |
Diluted EPS,Continuing and Di... | 1.06 |
Interest and Dividend Income | 14 |
Interest Expense | 211 |
Net Interest Income | -197 |
Earning Before Interest and T... | 4061 |
Earning Before Interest Tax D... | 5259 |
Cost of Revenue,Reconciled | 45718 |
Depreciation,Reconciled | 1198 |
Net Income from Continuing Op... | 2604 |
TotalUnusualItemsExcludingGoo... | -359 |
TotalUnusualItems | -359 |
Normalized Basic EPS | 2.52 |
Normalized Diluted EPS | 2.51 |
NormalizedEBITDA | 5618 |
Tax rate for calculations | 0.32 |
WES Efficency Ratios (30 June 2018) | |
|---|---|
Days in sales | 7.27 |
Days in inventory | 50.06 |
Days in payment | 52.52 |
Cash conversion cycle | 4.81 |
Receivable turnover | 50.24 |
Inventory turnover | 7.29 |
Payable turnover | 6.95 |
Fixed assets turnover | 7.46 |
Assets turnover | 1.73 |
ROE | 0.05 |
ROA | 0.03 |
ROIC | 0.05 |
FCF sales ratio | 0.03 |
FCF net income ratio | 1.89 |
Capital expenditure sales ratio | 0.03 |
WES Financial Health Ratios (30 June 2018) | |
|---|---|
Current ratio | 0.87 |
Quick ratio | 0.23 |
Debt total capital ratio | 0.12 |
Debt equity ratio | 0.13 |
Financial leverage | 1.62 |
Total debt to equity | 0.18 |
WES Avearge Growth Ratios Over 5 Years (30 June 2018) | |
|---|---|
Growth ann capital spending | -0.05 |
Growth ann gross profit | 0.01 |
Avg gross margin | 0.31 |
Avg post tax margin | 0.03 |
Avg pre tax marginr | 0.05 |
Avg net profit | 0.03 |
Avg ret commonr | 0.08 |
Avg ret assets | 0.05 |
Avg ret invested capital | 0.07 |
WES Profitability Ratios (30 June 2018) | |
|---|---|
Gross margin | 0.31 |
Operating margin | 0.06 |
EBT margin | 0.06 |
Tax rate | 0.32 |
Net margin | 0.02 |
Sales per employee | 306,884.79 |
EBIT margin | 0.06 |
EBITDA margin | 0.08 |
Normalized net profit margin | 0.04 |
Interest coverage | 19.25 |
Inc per employee tot ops | 5,516.13 |
WES Valuation Ratios (29 June 2018) | |
|---|---|
Sales per share | 60.96 |
Growth ann sales per share 5 ye... | 0.03 |
Book value per share | 20.13 |
CF per share | 3.95 |
Price to EPS | 37.17 |
Ratio PE 5 year high | 26.68 |
Ratio PE 5 year low | 19.61 |
Price to book | 2.45 |
Price to sales | 0.81 |
Price to cash flow | 12.50 |
Price to free cash flow | 20.62 |
Div rate | 2.23 |
Dividend yield | 0.05 |
Div payout tot ops | 1.67 |
Div payout 5 year | 1.40 |
Payout ratio | 1.68 |
Sustainable growth rate | -0.04 |
Cash return | 0.05 |
WES Balance Sheet 30 June 2018 (AUD) | |
|---|---|
Total Assets | 36933 |
Current Assets | 8706 |
Cash,Cash Equivalents,and Sho... | 683 |
Cash and Cash Equivalents | 683 |
Cash | 492 |
Cash Equivalents | 191 |
Receivables | 1657 |
Accounts Receivable | 1351 |
Other Receivables | 364 |
Recievables Adjustments/Allow... | -58 |
Inventories | 6011 |
Raw Materials | 37 |
Work-in-Process | 2 |
Finished Goods | 5972 |
Hedging Assets, Current | 126 |
Other Current Assets | 229 |
Total Non-Current Assets | 28227 |
Net Property,Plant,and Equipm... | 8408 |
Gross Property,Plant,and Equi... | 16592 |
Land and Improvements | 2080 |
Machinery,Furniture/Equipment | 12620 |
Other Properties | 158 |
Leasehold and Improvements | 1734 |
Accumulated Depreciation | -8184 |
Goodwill and Other Intangible... | 17860 |
Goodwill | 13491 |
Other Intangible Assets | 4369 |
Investments and Advances | 748 |
Long term equity investment | 748 |
Investments in Associates, at... | 748 |
Derivative Assets,Non-Current | 391 |
Deferred Non-Current Assets | 692 |
Deferred Taxes,Non-Current As... | 692 |
Other Non-Current Assets | 128 |
Total Liabilities | 14179 |
Current Liabilities | 10025 |
Payables and Accrued Expenses | 6541 |
Payables | 6541 |
Accounts Payable | 6541 |
Provisions,Current | 548 |
Pension and Other Post-Retire... | 1194 |
Current Debt and Capital Leas... | 1159 |
Current Debt | 1159 |
Notes Payable,Current | 499 |
Other Current Borrowings | 660 |
Deferred Liabilities,Current | 299 |
Deferred Taxes,Current Liabil... | 299 |
Other Current Liabilities | 284 |
Total Non-Current Liabilities | 4154 |
Provisions,Long Term | 866 |
Long Term Debt and Capital Le... | 2965 |
Long Term Debt | 2965 |
Employee Benefits | 167 |
Pension and Other Postretirem... | 167 |
Other Non-Current Liabilities | 156 |
Total Equity | 22754 |
Stockholder's Equity | 22754 |
Capital Stock | 22234 |
Common Stock | 22234 |
Retained Earnings | 176 |
Accumulated Gains/ Losses Not... | 344 |
Foreign Currency Translation ... | 43 |
Other Equity Adjustments | 296 |
Total Capitalization | 25719 |
Common Stock Equity | 22754 |
Net Tangible Assets | 4894 |
Working Capital | -1319 |
Invested Capital | 26878 |
Tangible Book Value | 4894 |
Total Debt | 4124 |
NetDebt | 3441 |
Ordinary Shares Number | 1133.840242 |
TotalLiabilitiesAsReported | 14179 |
TotalEquityAsReported | 22754 |
WES Cash Flow 30 June 2018 (AUD) | |
|---|---|
Classes of Cash Receipts from... | 75354 |
Receipts from Customers | 75354 |
Classes of Cash Payments | -69836 |
Payments to Suppliers for Goo... | -69836 |
Dividends Received, Direct | 50 |
Interest Paid, Direct | -195 |
Interest Received, Direct | 15 |
Taxes Refund/Paid, Direct | -1308 |
Cash Flow from Investing Acti... | -658 |
Cash Flow from Continuing Inv... | -658 |
Purchase/Sale of Property,Pla... | -1209 |
Purchase of Property,Plant an... | -1815 |
Sale of Property,Plant,and Eq... | 606 |
Purchase/Sale of Business,Net | 534 |
Sale of Business | 534 |
Purchase/Sale of Investments,... | 17 |
Sale of Investments | 17 |
Cash Flow from Financing Acti... | -3752 |
Cash Flow from Continuing Fin... | -3752 |
Issuance/Payments of Debt,Net | -1217 |
Issuance/Payments of Long Ter... | -1217 |
Proceeds or Issuance of Long ... | 688 |
Payments to Settle Long Term ... | -1905 |
Cash Dividends Paid | -2528 |
Common Stock Dividends Paid | -2528 |
Other Financing Changes, Net | -7 |
Cash and Cash Equivalents,End... | 683 |
Change in Cash | -330 |
Cash and Cash Equivalents,Beg... | 1013 |
Income Tax Paid, Supplemental... | 1308 |
Interest Paid, Supplemental D... | 195 |
Capital Expenditure | -1815 |
Issuance of Debt | 688 |
Repayment of Debt | -1905 |
Free Cash Flow | 2265 |
ChangeinCashSupplementalAsRep... | -330 |
