Staples Inc

  All amounts in Millions of US Dollars except per share items
Select start date for quarterly reports
BALANCE SHEET (at a glance)
2016/072016/102017/012017/042017/07
INDICATORS
quarter end date2016/072016/102017/012017/042017/07
date preliminary data loaded2016-09-182016-11-202017-03-122017-05-212017-08-27
earnings period indicatorAAAAA
quarterly indicator34123
basic earnings indicatorYYYYY
template indicator
preliminary full context indNNNNN
projected fiscal year date2016-01-312016-01-312017-01-312017-01-312017-01-31
number of months last report period33333
INCOME STATEMENT
operating revenue4,752.05,355.03,039.04,149.03,905.0
total revenue4,752.05,355.03,039.04,149.03,905.0
adjustments to revenue0.00.00.00.00.0
cost of sales3,465.03,817.02,114.02,992.02,832.0
cost of sales with depreciation3,560.03,912.02,204.03,071.02,908.0
gross margin1,192.01,443.0835.01,078.0997.0
gross operating profit1,192.01,443.0835.01,078.0997.0
Research & Development (R&D) Expense0.00.00.00.00.0
Selling, General & Administrative (SG&A) Expense1,077.01,078.0568.0897.0881.0
advertising0.00.00.00.00.0
operating income-825.0298.0155.0163.0106.0
EBITDA-736.0404.0270.0259.0197.0
depreciation95.095.090.079.076.0
depreciation (unrecognized)-15.0-14.0-14.0-12.0-9.0
amortization-80.0-81.0-83.0-68.0-65.0
amortization of intangibles15.014.07.011.011.0
operating profit after depreciation-831.0309.0180.0180.0121.0
interest income1.01.01.01.02.0
earnings from equity interest0.00.00.00.00.0
other income net-22.0-4.010.04.04.0
income, acquired in process r&a0.00.00.00.00.0
Income, Restructuring and M&A0.00.00.00.00.0
other special charges-250.00.00.00.00.0
special income charges-659.0-51.0-100.0-6.0-3.0
EBIT-846.0295.0166.0168.0112.0
interest expense18.011.010.010.010.0
pre-tax income -864.0284.0156.0158.0102.0
income taxes0.00.00.00.00.0
minority interest8.08.00.08.08.0
pref. securities of subsid. trust0.00.00.00.00.0
income before income taxes-864.0284.0156.0158.0102.0
net income (continuing operations)-766.0180.0-952.0-815.055.0
net income (discontinued operations)0.00.00.00.00.0
net income (total operations)-766.0179.0-952.0-815.055.0
extraordinary income/losses0.00.00.00.00.0
income from cum. effect of acct. change0.00.00.00.00.0
income from tax loss carryforward0.00.00.00.00.0
other gains/losses0.00.00.00.00.0
total net income-766.0179.0-952.0-815.055.0
normalized income143.0226.2155.6108.664.8
net income available for common-766.0179.0-952.0-815.055.0
preferred dividends0.00.00.00.00.0
excise taxes0.00.00.00.00.0
*
Basic EPS (Continuing)-1.180.280.130.160.10
Basic EPS (Discontinued)0.000.000.00-1.41-0.02
Basic EPS from Total Operations-1.180.28-1.47-1.250.08
Basic EPS (Extraordinary Items)0.000.000.000.000.00
Basic EPS (Cum. Effect of Acct. Change)0.000.000.000.000.00
Basic EPS (Tax Loss Carry Forward)0.000.000.000.000.00
Basic EPS (Other Gains/Losses)0.000.000.000.000.00
Basic EPS - Total-1.180.28-1.47-1.250.08
Basic EPS - Normalized0.220.350.240.170.10
*
Diluted EPS (Continuing)-1.180.270.130.160.10
Diluted EPS (Discontinued)0.000.000.00-1.40-0.02
Diluted EPS from Total Operations-1.180.27-1.47-1.240.08
Diluted EPS (Extraordinary)0.000.000.00-1.40-0.02
Diluted EPS (Cum. Effect of Acct. Change)0.000.000.000.000.00
Diluted EPS (Tax Loss Carry Forward)0.000.000.000.000.00
Diluted EPS (Other Gains/Losses)0.000.000.000.000.00
Diluted EPS - Total-1.180.27-1.47-1.240.08
Diluted EPS - Normalized0.220.340.240.170.10
Dividends Paid Per Share (DPS)0.120.120.120.120.12
INCOME STATEMENT (YEAR-TO-DATE)
Revenue (YTD)15,121.020,476.03,039.07,188.011,093.0
Net Income from Total Operations (YTD)-639.0-460.0-952.0-1,767.0-1,712.0
EPS from Total Operations (YTD)-0.99-0.71-1.47-2.72-2.64
Dividends Paid Per Share (YTD)0.360.480.120.240.36
BALANCE SHEET
ASSETS
cash & equivalents775.01,076.00.01,290.01,199.0
restricted cash0.00.00.00.00.0
marketable securities775.01,076.00.01,290.01,199.0
accounts receivable0.00.00.00.00.0
loans receivable0.00.00.00.00.0
other receivable0.00.00.00.00.0
receivables1,808.01,865.00.01,342.01,342.0
inventories, raw materials0.00.00.00.00.0
inventories, work in progress0.00.00.00.00.0
inventories, purchased components0.00.00.00.00.0
inventories, finished goods2,233.02,019.00.01,623.01,870.0
inventories, other0.00.00.00.00.0
inventories, adjustments & allowances0.00.00.00.00.0
inventories2,233.02,019.00.01,623.01,870.0
prepaid expenses432.0374.00.0207.0189.0
current defered income taxes0.00.00.00.00.0
other current assets0.00.00.0123.0154.0
total current assets5,248.05,334.00.04,585.04,754.0
land and improvements0.00.00.00.00.0
building and improvements0.00.00.00.00.0
machinery, furniture & equipment0.00.00.00.00.0
construction in progress0.00.00.00.00.0
other fixed assets1,465.01,412.00.01,071.01,057.0
total fixed assets1,465.01,412.00.01,071.01,057.0
gross fixed assets1,465.01,412.00.01,071.01,057.0
accumulated depreciation0.00.00.00.00.0
net fixed assets1,465.01,412.00.01,071.01,057.0
intangibles246.0202.00.0170.0163.0
cost in excess2,014.02,010.00.01,290.01,294.0
non-current deferred income taxes0.00.00.00.00.0
other non-current assets510.0429.00.0394.0398.0
total non-current assets4,235.04,053.00.02,925.02,912.0
total assets9,483.09,387.00.07,510.07,666.0
inventory valuation methodAvAvAvAvAv
EQUITY & LIABILITIES
accounts payable2,049.02,025.00.01,655.01,732.0
notes payable0.00.00.00.00.0
short-term debt0.00.00.00.00.0
accrued expenses1,143.01,193.00.0933.0941.0
accrued liabilities0.00.00.00.00.0
deferred revenues0.00.00.00.00.0
current deferred income taxes0.00.00.00.00.0
other current liabilities0.00.00.00.00.0
total current liabilities3,399.03,241.00.03,194.03,316.0
long-term debt1,015.01,024.00.0526.0524.0
capital lease obligations0.00.00.00.00.0
deferred income taxes12.060.0-21.04.010.0
other non-current liabilities497.0467.00.0422.0431.0
minority interest liability4,911.04,732.00.04,142.04,271.0
preferred secur. of subsid. trust0.00.00.00.00.0
preferred equity outside stock equity0.00.00.00.00.0
total non-current liabilities1,520.01,499.00.0956.0963.0
total liabilities4,919.04,740.00.04,150.04,279.0
preferred stock equity0.00.00.00.00.0
common stock equity4,564.04,647.00.03,360.03,387.0
common par0.00.00.00.00.0
additional paid-in capital5,029.05,039.00.05,079.05,102.0
cumulative translation adjustments0.00.00.00.00.0
retained earnings6,021.06,122.00.04,196.04,174.0
treasury stock5,419.05,419.00.05,419.05,419.0
other equity adjustments0.00.00.00.00.0
total capitalization5,579.05,671.00.03,886.03,911.0
total equity4,564.04,647.00.03,360.03,387.0
total liabilities & stock equity9,483.09,387.00.07,510.07,666.0
*
cash flow0.00.00.00.00.0
working capital1,849.02,093.00.01,391.01,438.0
free cash flow-345.0585.0207.0221.0-31.0
invested capital5,786.05,694.00.04,407.04,435.0
*
shares out (common class only)650.4650.5652.5653.2656.7
preferred shares0.00.00.00.00.0
total ordinary shares650.4650.50.0653.2656.7
total common shares out650.4650.5652.5653.2656.7
treasury shares301.2301.20.0301.2301.2
basic weighted shares0.00.00.00.00.0
diluted weighted shares0.00.00.00.00.0
number of employees7537175371774407744077440
number of part-time employees32817328173187531875
CASH-FLOW STATEMENT
OPERATING ACTIVITIES
net income/loss-766.0180.0-952.0-815.055.0
depreciation95.095.090.079.076.0
amortization-80.0-81.0-83.0-68.0-65.0
amortization of intangibles15.014.07.011.011.0
deferred income taxes12.060.0-21.04.010.0
operating gains17.01.0118.0909.0-5.0
extraordinary gains0.00.00.00.00.0
(increase) decrease in receivables9.0-69.033.00.0-17.0
(increase) decrease in inventories-179.0203.056.02.0-217.0
(increase) decrease in prepaid expenses-141.082.084.0-10.010.0
(increase) decrease in other current assets0.00.00.00.00.0
decrease (increase) in payables38.0-14.0-137.0110.084.0
decrease (increase) in other current liabilities-97.061.017.0-50.0-13.0
decrease (increase) in other working capital-14.0-30.0-23.0-4.08.0
other non-cash items676.058.01,010.020.015.0
net cash from continuing operations-287.0641.0304.0258.021.0
net cash from discontinued operations0.00.00.00.00.0
net cash from total operating activities-287.0641.0304.0258.021.0
INVESTING ACTIVITIES
sale of property, plant & equipment0.00.00.016.07.0
sale of long-term investments0.00.00.00.00.0
sale of short-term investments0.00.00.00.00.0
purchase of property, plant & equipment-58.0-56.0-97.0-37.0-52.0
acquisitions0.00.00.00.00.0
purchase of long-term investments0.00.00.00.00.0
purchase of short-term investments0.00.00.00.00.0
other investing changes, net-11.00.0-15.00.00.0
cash from discontinued investing activities0.00.00.00.00.0
net cash from investing activities14.0-56.0-170.0-15.0-52.0
FINANCING ACTIVITIES
issuance of debt182.05.00.03.04.0
issuance of capital stock0.00.00.00.00.0
repayment of long-term debt-185.0-10.0-11.0-5.0-3.0
repurchase of capital stock-9.0-1.00.00.0-3.0
payment of cash dividends-77.0-78.0-78.0-78.0-79.0
other financing charges, net0.00.00.00.00.0
cash from discontinued financing activities0.00.00.00.00.0
net cash from financing activities115.0-273.0-74.0-80.0-68.0
NET CASH FLOW
effect exchange rate changes-13.0-11.01.0-10.08.0
net change in cash & equivalents-171.0301.061.0153.0-91.0
cash at beginning of period946.0775.01,076.01,137.01,290.0
cash end of period775.01,076.01,137.01,290.01,199.0
*
foreign sales0.00.00.00.00.0
domestic sales0.00.00.00.00.0
auditor nameErnst & Young LLPErnst & Young LLPErnst & Young LLPErnst & Young LLPErnst & Young LLP
auditor reportUQUQUQUQUQ
RATIOS CALCULATIONS
PROFIT MARGINS
Close PE Ratio-12.7-13.5-12.2-13.60.0
High PE Ratio-28.5-27.3-27.3-30.3-51.1
Low PE Ratio-11.8-10.2-10.2-11.3-19.1
gross profit margin0.00.00.30.00.0
pre-tax profit margin0.00.00.00.00.0
post-tax profit margin0.00.00.00.00.0
net profit margin0.00.00.00.00.0
interest coverage (cont. operations)0.00.0-3.30.00.0
interest as % of invested capital0.00.00.00.00.0
effective tax rate0.00.00.00.00.0
income per employee
NORMALIZED RATIOS
Normalized Close PE Ratio38.626.535.952.999.2
Normalized High PE Ratio38.827.838.553.699.5
Normalized Low PE Ratio38.226.236.052.599.2
normalized net profit margin0.00.00.00.00.0
Normalized ROE0.00.00.00.00.0
Normalized ROA0.00.00.00.00.0
Normalized ROCI0.00.00.00.00.0
normalized income per employee1897300120091402837
SOLVENCY RATIOS
quick ratio0.00.00.70.00.0
current ratio0.00.01.40.00.0
payout ratio
total debt/equity ratio0.000.000.280.000.00
long-term debt/total capital 0.000.000.130.000.00
EFFICIENCY RATIOS
leverage ratio0.00.00.30.00.0
asset turnover0.00.02.00.00.0
cash as % of revenue16.320.10.031.130.7
receivables as % of revenue38.034.80.032.334.4
SG&A as % of Revenue22.720.118.721.622.6
R&D as % of Revenue0.00.00.00.00.0
ACTIVITY RATIOS
revenue per $ cash6.134.980.003.223.26
revenue per $ plant (net)3.243.790.003.873.69
revenue per $ common equity1.041.150.001.231.15
revenue per $ invested capital0.820.940.000.940.88
LIQUIDITY RATIOS
receivables turnover0.00.010.60.00.0
inventory turnover0.00.07.10.00.0
receivables per day sales0.000.000.000.000.00
sales per $ receivables0.000.000.000.000.00
sales per $ inventory0.000.000.000.000.00
revenue/assets0.50.60.00.60.5
number of days cost of goods in inventory
current assets per share8.188.310.007.827.26
total assets per share14.7714.620.0012.8111.71
intangibles as % of book-value0.00.00.00.00.0
inventory as % of revenue47.037.70.039.147.9
CAPITAL STRUCTURE RATIOS
long-term debt per share1.581.600.000.900.80
current liabilities per share5.305.050.005.455.06
cash per share1.031.401.441.411.87
LT-Debt to Equity Ratio0.000.000.140.000.00
LT-Debt as % of Invested Capital17.518.00.011.911.8
LT-Debt as % of Total Debt83.197.80.050.250.0
total debt as % total assets12.911.20.013.913.7
working captial as % of equity40.545.00.041.442.5
revenue per share7.408.344.737.085.96
book value per share7.027.145.655.145.16
tangible book value per share3.593.790.003.242.95
price/revenue ratio118.26116.62186.38137.28171.37
price/equity ratio123.13134.390.00169.51197.58
price/tangible book ratio243.91256.480.00299.77346.73
working capital as % of price32.933.50.024.421.5
PROFITABILITY
working capital per share2.843.220.002.132.19
cash flow per share1.031.401.441.411.87
free cash flow per share0.500.901.051.031.50
Return on Stock Equity (ROE)0.00.0-0.30.00.0
Return on Capital Invested (ROCI)0.00.00.00.00.0
Return on Assets (ROA)0.00.0-0.20.00.0
price/cash flow ratio8.46.96.06.25.5
price/free cash flow ratio17.410.78.38.56.8
sales per employee235628
AGAINST THE INDUSTRY RATIOS
% of sales-to-industry
% of earnings-to-industry
% of EPS-to-Industry
% of price-to-industry
% of PE-to-Industry
% of price/book-to-industry
% of price/sales-to-industry
% of price/cashflow-to-industry
% of pric/free cashlow-to-industry
% of debt/equity-to-industry
% of current ratio-to-industry
% of gross profit margin-to-industry
% of pre-tax profit margin-to-industry
% of post-tax profit margin-to-industry
% of net profit margin-to-industry
% of ROE-to-Industry
% of leverage-to-industry
Your Recent History
LSE
GKP
Gulf Keyst..
LSE
QPP
Quindell
FTSE
UKX
FTSE 100
LSE
IOF
Iofina
FX
GBPUSD
UK Sterlin..
Stocks you've viewed will appear in this box, letting you easily return to quotes you've seen previously.

Register now to create your own custom streaming stock watchlist.

NYSE, AMEX, and ASX quotes are delayed by at least 20 minutes.
All other quotes are delayed by at least 15 minutes unless otherwise stated.

By accessing the services available at ADVFN you are agreeing to be bound by ADVFN's Terms & Conditions

P:43 V:us D:20170923 21:57:43