Question: Complete the table below FULLY for Staples (SPLS) from 2012 - 2016 using material found on Yahoo finance. Ticker - SPLS Name - Staples Ratios
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 |
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help