Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Sector:    

Industry: 

 
USD
  
  
()
Optionable:   Market Cap:   90-day average vol:

Previous close:   Open:   Bid:   Ask:
52 week range    
   
   

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Metrics

Valuation

Returns

Risk

Ranks

Dividends

Analyst Estimates

Financial Health

Technicals

Growth

Profitability

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

VIPS Income Statement

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
AllowancesForConstruction7,247 M
Amortization of intangibles-229456.0-250 M-290 M-364 M-341 M-48 M-16 M-37 M-3 M
Basic EPS total0.050.7413.7417.5716.5916.0930.0843.7334.3849.51
Basic weighted shares outstanding1,090 M1,133 M116 M116 M118 M132 M134 M135 M136 M127 M
Cost of sales-1,289 M-17,378 M-30,307 M-42,995 M-56,618 M-67,455 M-72,314 M-80,573 M-93,953 M-81,536 M
Depreciation-9 M-110 M-291 M-611 M-721 M-770 M-830 M-970 M-1,231 M
Depreciation unreconciled1 M7,489 M
DepreciationAndAmortization-9 M-110 M-291 M-611 M-721 M7,489 M-830 M-970 M-1,231 M
DevelopmentExpense7,653 M
Diluted EPS total0.050.713.2316.8615.9415.6129.5842.7933.7449.15
Diluted weighted shares outstanding1,155 M1,202 M120 M126 M126 M140 M136 M138 M139 M128 M
Earnings from equity interest-63 M-84 M-71 M33 M-47 M27 M30 M42 M-7 M
EarningsFromEquityInterestNetOfTax-63 M-84 M-71 M33 M-47 M27 M30 M42 M-7 M
GainOnSaleOfSecurity6 M41 M66 M17 M49 M12 M2 M
GeneralAndAdministrativeExpense90 M1,638 M2,378 M3,505 M4,256 M4,675 M5,632 M4,970 M5,707 M6,065 M
Gross operating profit408 M5,751 M9,896 M13,597 M16,294 M17,069 M20,680 M21,285 M23,107 M21,616 M
ImpairmentOfCapitalAssets7,596 M-468 M
Income before tax71 M1,060 M2,051 M2,666 M2,541 M2,747 M4,943 M6,342 M4,991 M7,337 M
Income taxes19 M245 M458 M602 M626 M567 M984 M1,130 M1,223 M1,759 M
Interest income16 M289 M267 M107 M101 M243 M217 M449 M671 M764 M
InterestExpenseNonOperating75 M86 M85 M82 M160 M86 M6,946 M14 M24 M
InterestIncomeOperating9 M
MarketingExpense74 M1,164 M2,089 M2,838 M2,979 M3,240 M3,324 M4,284 M5,089 M2,831 M
MinorityInterests89 M81 M44 M57 M-5 M30 M-12 M-12 M-13 M
MiscOtherSpecialCharges4 M20 M111 M155 M72,912 M84,524 M92,994 M101,858 M117,060 M103,152 M
Net income from total operations52 M841 M1,590 M2,037 M1,950 M2,129 M4,017 M5,199 M3,756 M5,565 M
NetIncomeCommonStockholders52 M841 M1,590 M2,037 M1,950 M2,129 M4,017 M5,199 M3,756 M5,565 M
NetIncomeContinuousOperations52 M841 M1,590 M2,037 M1,950 M2,129 M4,017 M5,199 M3,756 M5,565 M
NetNonOperatingInterestIncomeExpense16 M213 M181 M22 M19 M83 M131 M-6,497 M657 M740 M
Operating income54 M834 M2,071 M2,708 M-70,222 M-82,103 M-80,625 M-89,827 M-112,402 M-90,441 M
Operating income before depreciation (EBITDA)80 M1,523 M2,754 M3,800 M3,746 M3,797 M5,956 M14,400 M6,259 M8,769 M
OperatingExpense-2,227 M-5,072 M-8,134 M-11,247 M-14,134 M-15,405 M-16,552 M-16,133 M-18,449 M-16,143 M
Other income net-4 M49 M184 M186 M-72,813 M-84,649 M-93,061 M-102,826 M-116,773 M-96,351 M
OtherGandA90 M1,638 M2,378 M3,505 M4,256 M4,675 M5,632 M4,970 M5,707 M6,065 M
OtherImpairmentOfCapitalAssets6 M100 M115 M133 M20 M128 M43 M415 M94 M
OtherOperatingExpenses2,269 M3,667 M4,905 M6,900 M-15,405 M-16,552 M-16,133 M-260 M
OtherWriteOff-4 M-174 M-16 M-10 M-45 M
PromotionAndAdvertising-71 M-788 M-1,022 M-1,672 M-1,527 M-1,652 M-2,234 M-3,079 M
RentAndLandingFees90 M1,638 M2,378 M3,505 M4,256 M4,675 M5,632 M4,970 M5,707 M6,065 M
Research & development expense7,653 M
Revenue per share-229456.0-277 M-323 M-400 M-347 M7,489 M-16 M-37 M-3 M
SalariesAndWages198 M-225 M-303 M-476 M-667 M-671 M-688 M-951 M-1,208 M
Selling Gen & administrative expense165 M2,803 M4,467 M6,342 M7,235 M7,916 M8,956 M9,254 M10,796 M8,896 M
SellingAndMarketingExpense74 M1,164 M2,089 M2,838 M2,979 M3,240 M3,324 M4,284 M5,089 M2,831 M
Special income/charges-7,596 M468 M
Total Income available for interest expense (EBIT)71 M1,136 M2,136 M2,751 M2,623 M2,907 M5,029 M13,288 M5,005 M7,361 M
Total common shares outstanding115 M117 M118 M131 M133 M134 M136 M136 M
Total net income52 M841 M1,590 M2,037 M1,950 M2,129 M4,017 M5,199 M3,756 M5,565 M
Total ordinary shares508 M508 M508 M508 M508 M508 M508 M508 M508 M508 M
Total revenues1,705 M23,283 M40,512 M56,949 M531 M757 M645 M708 M117,060 M-9 M
TotalExpenses-3,516 M-22,450 M-38,441 M-54,242 M-70,753 M-82,860 M-88,866 M-96,706 M-112,402 M-97,680 M
TotalRevenue1,681 M22,685 M39,410 M55,282 M72,912 M84,524 M92,994 M101,858 M117,060 M103,152 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University