PESTEL analysis

ratios.xlsx

ratios

Powered by Clearbit
VMware Inc (NYS: VMW)
Exchange rate used is that of the Year End reported date
Profitability Ratios	02/01/2019	02/02/2018	02/03/2017	12/31/2016	12/31/2015
ROA % (Net)	13.77	3.09	-0.52	7.3	6.44
ROE % (Net)	58.33	7.15	-1.05	14.77	12.86
ROI % (Operating)	24.47	15.59	-4.56	15.09	12.94
EBITDA Margin %	35.84	26.13	-0.6	24.16	21.75
Calculated Tax Rate %	15.99	68.35	EBT<0	19.48	17.81
Revenue per Employee	371845	366072	-	355458	345842
Liquidity Ratios	02/01/2019	02/02/2018	02/03/2017	12/31/2016	12/31/2015
Quick Ratio	0.78	2.58	2.23	2.16	2.21
Current Ratio	0.99	2.73	2.3	2.27	2.27
Net Current Assets % TA	-0.31	42.19	33.92	34.74	33.22
Debt Management	02/01/2019	02/02/2018	02/03/2017	12/31/2016	12/31/2015
LT Debt to Equity	7.7	0.54	0.18	0.19	0.19
Total Debt to Equity	7.7	0.54	0.18	0.19	0.19
Interest Coverage	15.3	22.82	-	55.35	46.04
Asset Management	02/01/2019	02/02/2018	02/03/2017	12/31/2016	12/31/2015
Total Asset Turnover	0.51	0.43	0.32	0.44	0.42
Receivables Turnover	6.23	6.34	3.49	4.05	4.17
Accounts Payable Turnover	119.98	233.64	59.83	53.79	38.54
Accrued Expenses Turnover	6.93	7.47	5.97	8.61	8.44
Property Plant & Equip Turnover	8.15	7.51	5.09	6.5	6.08
Cash & Equivalents Turnover	2.04	1.73	1.77	2.68	2.88
Per Share	02/01/2019	02/02/2018	02/03/2017	12/31/2016	12/31/2015
Cash Flow per Share	9.01	7.92	9.48	5.65	4.48
Book Value per Share	1.34	19.26	20.04	19.83	18.77