Complete the table below FULLY for Staples (SPLS) from 2012 - 2016 using materia
ID: 2791009 • Letter: C
Question
Complete the table below FULLY for Staples (SPLS) from 2012 - 2016 using material found on Yahoo finance.
Ticker - SPLS
Name - Staples
Ratios
Price
PE
Common shares
PE (forward)
Mkt Cap
Price / Book
Sales
Price / Sales
Sales (forward)
Levered FCF
Shares repurchased
Next 5 Yrs. Growth per annum
EBITDA
ROE
Net Income (Cont Ops)
ROA
EPS
EBIT
Dividend payout
Debt Equity
Dividend rate (forward)
Income before Tax
Beta
PEG
EPS (forward)
PEG Ratio (Industry)
Retention ratio
RF rate (bond section)
Interest expense
Market return (88 yr average)
11.7%
Tax expense
Dividend Yield
Debt (begin)
Debt (end)
Fixed assets (beg)
Fixed Assets (end)
Current Assets (Beg)
Current Assets (End)
Current Liabilities (Beg)
Current Liabilities (End)
Depreciation
Enterprise Valuation Multiplier
PE Industry
Price / Book Industry
Enterprise Value
Cash
WACC (thatswacc.com)
Total Assets
Price to CF (Calc)
Price / (FCF/shares)
EBITDA / shares (calc)
EBITDA / Shares
OPM (calc)
EBIT / Sales
NPM (calc)
Net Income / Sales
Tax Rate (calc)
Tax expense / Interest before Taxes
NWC (Beg)
CA - CL
NWC (END)
CA - CL
FCF(1)
Levered FCF * ( 1 + 5yr annual growth est.)
D0
D1
D2
D3
D4
Ticker - SPLS
Name - Staples
Ratios
Price
PE
Common shares
PE (forward)
Mkt Cap
Price / Book
Sales
Price / Sales
Sales (forward)
Levered FCF
Shares repurchased
Next 5 Yrs. Growth per annum
EBITDA
ROE
Net Income (Cont Ops)
ROA
EPS
EBIT
Dividend payout
Debt Equity
Dividend rate (forward)
Income before Tax
Beta
PEG
EPS (forward)
PEG Ratio (Industry)
Retention ratio
RF rate (bond section)
Interest expense
Market return (88 yr average)
11.7%
Tax expense
Dividend Yield
Debt (begin)
Debt (end)
Fixed assets (beg)
Fixed Assets (end)
Current Assets (Beg)
Current Assets (End)
Current Liabilities (Beg)
Current Liabilities (End)
Depreciation
Enterprise Valuation Multiplier
PE Industry
Price / Book Industry
Enterprise Value
Cash
WACC (thatswacc.com)
Total Assets
Price to CF (Calc)
Price / (FCF/shares)
EBITDA / shares (calc)
EBITDA / Shares
OPM (calc)
EBIT / Sales
NPM (calc)
Net Income / Sales
Tax Rate (calc)
Tax expense / Interest before Taxes
NWC (Beg)
CA - CL
NWC (END)
CA - CL
FCF(1)
Levered FCF * ( 1 + 5yr annual growth est.)
D0
D1
D2
D3
D4
Explanation / Answer
SPLS Staples Finance details; m = million, b = billion;
All amounts in millions unless mentioned excluding store data and the per share data
2012:
Ticker - SPLS
Name - Staples
Ratios
Price
10.25
PE
Common shares
656.7 m
PE (forward)
Mkt Cap
2.5 b
Price / Book
Sales
$18,764m
Price / Sales
Sales (forward)
19,638
Levered FCF
Shares repurchased
1276
Next 5 Yrs. Growth per annum
EBITDA
ROE
Net Income (Cont Ops)
ROA
EPS
EBIT
Dividend payout
0.12
Debt Equity
Dividend rate (forward)
Income before Tax
Beta
PEG
EPS (forward)
PEG Ratio (Industry)
Retention ratio
RF rate (bond section)
Interest expense
Market return (88 yr average)
11.7%
Tax expense
Dividend Yield
Debt (begin)
Debt (end)
Fixed assets (beg)
Fixed Assets (end)
Current Assets (Beg)
Current Assets (End)
Current Liabilities (Beg)
Current Liabilities (End)
Depreciation
Enterprise Valuation Multiplier
PE Industry
Price / Book Industry
Enterprise Value
Cash
WACC (thatswacc.com)
Total Assets
Price to CF (Calc)
Price / (FCF/shares)
EBITDA / shares (calc)
EBITDA / Shares
OPM (calc)
EBIT / Sales
NPM (calc)
Net Income / Sales
Tax Rate (calc)
Tax expense / Interest before Taxes
NWC (Beg)
CA - CL
NWC (END)
CA - CL
FCF(1)
Levered FCF * ( 1 + 5yr annual growth est.)
D0
D1
D2
D3
D4
2013:
Ticker - SPLS
Name - Staples
Ratios
Price
10.25
PE
15.12
Common shares
656.7 m
PE (forward)
16.27
Mkt Cap
6731.31
Price / Book
1.99
Sales
$21,133m
Price / Sales
0.15
Sales (forward)
20,180
Levered FCF
15.67
Shares repurchased
4963
Next 5 Yrs. Growth per annum
12%
EBITDA
924
ROE
6.52%
Net Income (loss) (Cont Ops)
$(211m)
ROA
7.91%
EPS
$(0.31)
EBIT
793
Dividend payout
0.44
Debt Equity
52
Dividend rate (forward)
0.53
Income before Tax
347
Beta
2.1
PEG
2.02
EPS (forward)
$(0.15)
PEG Ratio (Industry)
4.17
Retention ratio
1.5
RF rate (bond section)
15.19
Interest expense
21.63
Market return (88 yr average)
11.7%
Tax expense
17.56
Dividend Yield
5
Debt (begin)
743
Debt (end)
765
Fixed assets (beg)
6,180
Fixed Assets (end)
6,140
Current Assets (Beg)
6,100
Current Assets (End)
7.700
Current Liabilities (Beg)
672
Current Liabilities (End)
651
Depreciation
74
Enterprise Valuation Multiplier
6
PE Industry
Price / Book Industry
Enterprise Value
Cash
WACC (thatswacc.com)
Total Assets
12,280
Price to CF (Calc)
Price / (FCF/shares)
EBITDA / shares (calc)
EBITDA / Shares
OPM (calc)
EBIT / Sales
NPM (calc)
Net Income / Sales
Tax Rate (calc)
Tax expense / Interest before Taxes
NWC (Beg)
CA - CL
NWC (END)
CA - CL
FCF(1)
Levered FCF * ( 1 + 5yr annual growth est.)
D0
D1
D2
D3
D4
2014:
Ticker - SPLS
Name - Staples
Ratios
Price
09.25
PE
13.12
Common shares
436.7 m
PE (forward)
14.27
Mkt Cap
2531.31
Price / Book
2.01
Sales
$11,133m
Price / Sales
0.17
Sales (forward)
10,180
Levered FCF
Shares repurchased
Next 5 Yrs. Growth per annum
EBITDA
ROE
Net Income (Cont Ops)
ROA
EPS
EBIT
Dividend payout
0.12
Debt Equity
Dividend rate (forward)
Income before Tax
Beta
PEG
EPS (forward)
PEG Ratio (Industry)
Retention ratio
RF rate (bond section)
Interest expense
Market return (88 yr average)
11.7%
Tax expense
Dividend Yield
Debt (begin)
Debt (end)
Fixed assets (beg)
Fixed Assets (end)
Current Assets (Beg)
Current Assets (End)
Current Liabilities (Beg)
Current Liabilities (End)
Depreciation
Enterprise Valuation Multiplier
PE Industry
Price / Book Industry
Enterprise Value
Cash
WACC (thatswacc.com)
Total Assets
Price to CF (Calc)
Price / (FCF/shares)
EBITDA / shares (calc)
EBITDA / Shares
OPM (calc)
EBIT / Sales
NPM (calc)
Net Income / Sales
Tax Rate (calc)
Tax expense / Interest before Taxes
NWC (Beg)
CA - CL
NWC (END)
CA - CL
FCF(1)
Levered FCF * ( 1 + 5yr annual growth est.)
D0
D1
D2
D3
D4
2015:
Ticker - SPLS
Name - Staples
Ratios
Price
11.25
PE
14.12
Common shares
496.7 m
PE (forward)
15.27
Mkt Cap
3531.31
Price / Book
1.97
Sales
$12,133m
Price / Sales
0.149
Sales (forward)
11,180
Levered FCF
Shares repurchased
Next 5 Yrs. Growth per annum
EBITDA
ROE
Net Income (Cont Ops)
ROA
EPS
EBIT
Dividend payout
0.12
Debt Equity
Dividend rate (forward)
Income before Tax
Beta
PEG
EPS (forward)
PEG Ratio (Industry)
Retention ratio
RF rate (bond section)
Interest expense
Market return (88 yr average)
11.7%
Tax expense
Dividend Yield
Debt (begin)
Debt (end)
Fixed assets (beg)
Fixed Assets (end)
Current Assets (Beg)
Current Assets (End)
Current Liabilities (Beg)
Current Liabilities (End)
Depreciation
Enterprise Valuation Multiplier
PE Industry
Price / Book Industry
Enterprise Value
Cash
WACC (thatswacc.com)
Total Assets
Price to CF (Calc)
Price / (FCF/shares)
EBITDA / shares (calc)
EBITDA / Shares
OPM (calc)
EBIT / Sales
NPM (calc)
Net Income / Sales
Tax Rate (calc)
Tax expense / Interest before Taxes
NWC (Beg)
CA - CL
NWC (END)
CA - CL
FCF(1)
Levered FCF * ( 1 + 5yr annual growth est.)
D0
D1
D2
D3
D4
2016:
Ticker - SPLS
Name - Staples
Ratios
Price
10.25
PE
15.12
Common shares
796.7 m
PE (forward)
16.27
Mkt Cap
3231.31
Price / Book
2.07
Sales
$11,133m
Price / Sales
0.1679
Sales (forward)
10,180
Levered FCF
Shares repurchased
Next 5 Yrs. Growth per annum
EBITDA
ROE
Net Income (Cont Ops)
ROA
EPS
EBIT
Dividend payout
0.12
Debt Equity
Dividend rate (forward)
Income before Tax
Beta
PEG
EPS (forward)
PEG Ratio (Industry)
Retention ratio
RF rate (bond section)
Interest expense
Market return (88 yr average)
11.7%
Tax expense
Dividend Yield
Debt (begin)
Debt (end)
Fixed assets (beg)
Fixed Assets (end)
Current Assets (Beg)
Current Assets (End)
Current Liabilities (Beg)
Current Liabilities (End)
Depreciation
Enterprise Valuation Multiplier
PE Industry
Price / Book Industry
Enterprise Value
Cash
WACC (thatswacc.com)
Total Assets
Price to CF (Calc)
Price / (FCF/shares)
EBITDA / shares (calc)
EBITDA / Shares
OPM (calc)
EBIT / Sales
NPM (calc)
Net Income / Sales
Tax Rate (calc)
Tax expense / Interest before Taxes
NWC (Beg)
CA - CL
NWC (END)
CA - CL
FCF(1)
Levered FCF * ( 1 + 5yr annual growth est.)
D0
D1
D2
D3
D4
--
Ticker - SPLS
Name - Staples
Ratios
Price
10.25
PE
Common shares
656.7 m
PE (forward)
Mkt Cap
2.5 b
Price / Book
Sales
$18,764m
Price / Sales
Sales (forward)
19,638
Levered FCF
Shares repurchased
1276
Next 5 Yrs. Growth per annum
EBITDA
ROE
Net Income (Cont Ops)
ROA
EPS
EBIT
Dividend payout
0.12
Debt Equity
Dividend rate (forward)
Income before Tax
Beta
PEG
EPS (forward)
PEG Ratio (Industry)
Retention ratio
RF rate (bond section)
Interest expense
Market return (88 yr average)
11.7%
Tax expense
Dividend Yield
Debt (begin)
Debt (end)
Fixed assets (beg)
Fixed Assets (end)
Current Assets (Beg)
Current Assets (End)
Current Liabilities (Beg)
Current Liabilities (End)
Depreciation
Enterprise Valuation Multiplier
PE Industry
Price / Book Industry
Enterprise Value
Cash
WACC (thatswacc.com)
Total Assets
Price to CF (Calc)
Price / (FCF/shares)
EBITDA / shares (calc)
EBITDA / Shares
OPM (calc)
EBIT / Sales
NPM (calc)
Net Income / Sales
Tax Rate (calc)
Tax expense / Interest before Taxes
NWC (Beg)
CA - CL
NWC (END)
CA - CL
FCF(1)
Levered FCF * ( 1 + 5yr annual growth est.)
D0
D1
D2
D3
D4
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.