WBA (NASDAQ) - Fundamental Data Analysis
VR Fundamental Rating -4.60
| VR Piotroski Score | 3.00 |
| Tobins Q Ratio | 0.21 |
| Free-Cash-Flow Yield | 0.55% |
| Free-Cash-Flow Margin | 0.10% |
| Net Margin | -2.54% |
| Gross Margin | 19.46% |
| Current Ratio | 0.63 |
| Debt / Equity | 0.41 |
| Debt / EBITDA | -2.87 |
| Debt / Free-Cash Flow | 57.77 |
| Interest Expense / Debt | 1.90% |
| WACC | 5.32% |
| RoE Return on Equity | -17.62% |
| RoCE Return on Cap. Employed | -8.16% |
| RoA Return on Assets | -3.65% |
| RoIC Return on Inv. Cap. | -7.26% |
| Analysts Rating | 3.19 |
| Analysts Target Price (is above last close by |
26.11 USD 30.7%) |
VR Piotroski 3
| No: Net Income TTM (-3528.0m) > 10m and > 3% of Revenue TTM (3% = 4172.4m) |
| No: FCF TTM (141.0m) > 1m and > FCF prev (97%) (2100.0m) |
| No: RoA TTM -3.65% (Net Income TTM -3528.0m / Total Assets 96628.0m) >3% and > RoA prev (97%) 4.38% (4065.0m / 90124.0m) |
| Yes: Total Cash from Operating Activities TTM 2258.0m > 1m and > Net Income TTM -3528.0m |
| No: Net Debt (Debt 8145.0m - CCE 739.0m) to EBITDA TTM (-2584.0m) ratio: -2.87 < 3.5 |
| No: Current Ratio 0.63 (Total Current Assets 15503.0m / Total Current Liabilities 24535.0m) >= 1 and > Current Ratio prev (97%) 0.75 (16902.0m / 22583.0m) |
| Yes: Shares Outstanding last quarter 864.3m < quarter 12m ago 864.5m |
| No: Gross Margin 19.46% (Total Revenue 139081.0m - Cost Of Revenue 112009.0m / Total Revenue) > 15% and > Gross Margin prev (97%) 0.21% |
| Yes: Asset Turnover 1.44 (Total Revenue 139081.0m / Total Assets 96628.0m) > Asset Turnover prev (97%) 1.43 (132703.0m / 90124.0m) |
| No: Interest Coverage Ratio -4.46 (EBITDA TTM -2584.0m / Interest Expense TTM 579.0m) > 5 |
VR Altman 3.41
| -0.093 (A) = (Total Current Assets 15503.0m - Total Current Liabilities 24535.0m) / Total Assets 96628.0m |
| 1.390 (B) = Retained Earnings TTM 134328.0m / Total Assets 96628.0m |
| -0.061 (C) = EBIT TTM -5886.0m / Total Assets 96628.0m |
| 1.811 (D) = Book Value of Equity 123375.0m / Total Liabilities 68138.0m |
| 1.439 (E) = Revenue TTM 139081.0m / Total Assets 96628.0m |
| Total Rating: 3.408 = (2.6 * A) + (1.5 * B) + (4.9 * C) + (0.95 * D) + (0.1 * E) |
Current Fundamental Values
Market Capitalization = 18220.0m USD
Market Capitalization in USD = 18219.97m (18219.97m USD * 1 USDUSD)
Revenue TTM = 139081.0m
Long Term Debt = 8145.0m (by last quarter)
Short Term Debt = 3265.0m (by last quarter)
Debt = 8145.0m (Short Term 3265.0 + Long Term 8145.0)
CCE Cash And Equivalents = 739.0m (cash And Short Term Investments by last quarter)
Enterprise Value = 25626.0m (Market Cap 18220.0m + Debt 8145.0m - CCE 739.0m)
Net Debt = 7406.0m (8145.0m Debt - 739.0m Cash and Cash Equivalents)
EBITDA = -2584.0m (TTM)
FCF Yield = 0.55% (FCF TTM 141.0m / Enterprise Value 25626.0m)
FCF Margin = 0.1% (FCF TTM 141.0m / Revenue TTM 139081.0m)
Net Margin = -2.54% (Net Income TTM -3528.0m / Revenue TTM 139081.0m)
Gross Margin = 19.46% ((Revenue TTM 139081.0m - Cost of Revenue TTM 112009.0m) / Revenue TTM)
Tobins Q-Ratio = 0.208 (Enterprise Value 25626.0m / Book Value Of Equity 123375.0m)
Interest Expense / Debt = 1.90% (Interest Expense 155.0m / Debt 8145 m)
Interest Coverage Ratio = -4.46 (EbitDA TTM -2584 m / Interest Expense TTM 579.0m)
Taxrate = 40.27% (Income Tax Expense -151.0m / Income Before Tax -375.0m, last quarter)
NOPAT Net Operating Profit after Tax = -3653.9m (Operating Income TTM -6117 m * (1 - Taxrate 0.40))
Current Ratio = 0.63 (Total Current Assets 15.50km / Total Current Liabilities 24.54km)
Debt / Equity = 0.41 (Debt 8145m / last Quarter total Stockholder Equity 20021m)
Debt / EBITDA = -2.87 (Debt 8145m - Cash and Cash Equivalents 739m / EBITDA -2584m)
Debt / FCF = 57.77 (Debt 8145m / FCF TTM 141m)
RoA = -3.65%
RoE = -17.62% (Net Income TTM -3528m / Total Stockholder Equity 20021m)
RoCE = -8.16% (Ebit TTM -5886 m / x)
RoIC = -7.26% (Ebit TTM -5886 m / (Total Assets 96.63km - Total Current Assets 15.50km) )
WACC = 5.32% ((Market Cap / EV) * CAPM 0.07) + (Debt / EV) * Interest Expense on Debt * (1 - Taxrate)
Shares Correlation 10-Years: -77.78 | Cagr: -1.00% (-0.78)
EPS Correlation 4-Years: -35.41 | EPS CAGR: -2.71%
Revenue Correlation 4-Years: -16.34 | Revenue CAGR: 0.14%
Market Capitalization in USD = 18219.97m (18219.97m USD * 1 USDUSD)
Revenue TTM = 139081.0m
Long Term Debt = 8145.0m (by last quarter)
Short Term Debt = 3265.0m (by last quarter)
Debt = 8145.0m (Short Term 3265.0 + Long Term 8145.0)
CCE Cash And Equivalents = 739.0m (cash And Short Term Investments by last quarter)
Enterprise Value = 25626.0m (Market Cap 18220.0m + Debt 8145.0m - CCE 739.0m)
Net Debt = 7406.0m (8145.0m Debt - 739.0m Cash and Cash Equivalents)
EBITDA = -2584.0m (TTM)
FCF Yield = 0.55% (FCF TTM 141.0m / Enterprise Value 25626.0m)
FCF Margin = 0.1% (FCF TTM 141.0m / Revenue TTM 139081.0m)
Net Margin = -2.54% (Net Income TTM -3528.0m / Revenue TTM 139081.0m)
Gross Margin = 19.46% ((Revenue TTM 139081.0m - Cost of Revenue TTM 112009.0m) / Revenue TTM)
Tobins Q-Ratio = 0.208 (Enterprise Value 25626.0m / Book Value Of Equity 123375.0m)
Interest Expense / Debt = 1.90% (Interest Expense 155.0m / Debt 8145 m)
Interest Coverage Ratio = -4.46 (EbitDA TTM -2584 m / Interest Expense TTM 579.0m)
Taxrate = 40.27% (Income Tax Expense -151.0m / Income Before Tax -375.0m, last quarter)
NOPAT Net Operating Profit after Tax = -3653.9m (Operating Income TTM -6117 m * (1 - Taxrate 0.40))
Current Ratio = 0.63 (Total Current Assets 15.50km / Total Current Liabilities 24.54km)
Debt / Equity = 0.41 (Debt 8145m / last Quarter total Stockholder Equity 20021m)
Debt / EBITDA = -2.87 (Debt 8145m - Cash and Cash Equivalents 739m / EBITDA -2584m)
Debt / FCF = 57.77 (Debt 8145m / FCF TTM 141m)
RoA = -3.65%
RoE = -17.62% (Net Income TTM -3528m / Total Stockholder Equity 20021m)
RoCE = -8.16% (Ebit TTM -5886 m / x)
RoIC = -7.26% (Ebit TTM -5886 m / (Total Assets 96.63km - Total Current Assets 15.50km) )
WACC = 5.32% ((Market Cap / EV) * CAPM 0.07) + (Debt / EV) * Interest Expense on Debt * (1 - Taxrate)
Shares Correlation 10-Years: -77.78 | Cagr: -1.00% (-0.78)
EPS Correlation 4-Years: -35.41 | EPS CAGR: -2.71%
Revenue Correlation 4-Years: -16.34 | Revenue CAGR: 0.14%