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

Financials

VIPS Cash Flow

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
(Increase) Decrease in inventories-160 M-2,129 M-1,272 M-685 M-2,240 M292 M-2,626 M-527 M144 M211 M
(Increase) Decrease in other current assets-11 M-53 M-67 M-79 M-84 M-12 M69 M-37 M-7 M-3 M
(Increase) Decrease in other current liabilities85 M688 M499 M746 M27 M150 M28 M-54 M11 M-10 M
(Increase) Decrease in other working capital177237.0-31 M-865000.030 M-2 M-7 M13 M-6 M814000.0-5 M
(Increase) Decrease in payables284 M2,875 M775 M1,367 M3,230 M117 M1,963 M1,326 M-309 M112 M
(Increase) Decrease in receivables-3 M-549 M-1,373 M-2,275 M-3,921 M59 M5,090 M1,657 M7 M-54 M
Acquisitions-1,191 M-611 M-276 M-287 M-982 M-3,355 M-2,171 M-143 M-97 M
Amortization of intangibles229456.0251 M292 M402 M396 M119 M97 M142 M156 M176 M
AssetImpairmentCharge34 M241 M394 M418 M340 M461 M1,291 M602 M97 M370 M
CapitalExpenditureReported28 M1,618 M2,193 M1,973 M2,199 M2,521 M3,303 M2,237 M429 M352 M
Cash at beginning of period775 M2,026 M4,791 M3,324 M4,110 M10,222 M10,038 M7,719 M12,811 M17,171 M
Cash at end of period986 M4,791 M3,324 M4,110 M1,571 M1,460 M1,109 M1,963 M2,695 M3,350 M
Cash flow437 M3,263 M1,915 M2,831 M981 M6,723 M12,867 M11,820 M2,167 M3,056 M
CashFlowFromContinuingInvestingActivities-321 M-4,253 M-2,937 M-1,781 M-2,058 M-6,713 M-8,241 M-6,695 M-365 M152 M
ChangeInAccountPayable284 M2,875 M775 M1,367 M3,230 M117 M1,963 M1,326 M-309 M112 M
ChangeInAccruedExpense144 M1,073 M537 M-305 M291 M1,986 M1,149 M1,268 M41 M-36 M
ChangeInInterestPayable144 M1,073 M537 M-305 M291 M1,986 M1,149 M1,268 M41 M-36 M
ChangeInPayablesAndAccruedExpense428 M3,948 M1,312 M1,062 M3,520 M2,103 M3,112 M2,594 M-267 M76 M
ChangeInPrepaidAssets-2 M-850747.0
ChangeInWorkingCapital348 M1,874 M-903 M-1,201 M-2,700 M2,585 M5,686 M3,626 M-112 M215 M
ChangesInAccountReceivables4 M-23 M-279 M-1,951 M-2,656 M-65 M4,165 M988 M-14 M-14 M
CommonStockDividendPaid-12 M-3 M-5 M
CommonStockPayments-650 M-194 M-1,939 M-907 M
Current deferred income taxes-11 M-166 M31 M-10 M-70 M-15 M-100 M-66 M-21 M11 M
Deferred income taxes-11 M-166 M31 M-10 M-70 M-15 M-100 M-66 M-21 M11 M
Depreciation9 M110 M291 M611 M721 M770 M830 M970 M1,097 M1,231 M
Depreciation unreconciled9 M388 M617 M1,048 M1,123 M890 M927 M1,112 M1,253 M1,407 M
DepreciationAndAmortization9 M388 M617 M1,048 M1,123 M890 M927 M1,112 M1,253 M1,407 M
EarningsLossesFromEquityInvestments63 M84 M71 M22 M47 M-27 M-88 M-42 M-38 M
Effect of exchange rate changes2 M-97 M95 M16 M-6 M26 M-13 M90000.0-9 M
FinancingCashFlow92 M3,852 M-539 M-281 M1,102 M85 M-6,257 M-21 M-59 M-808 M
Free cash flow410 M1,645 M-277 M872 M-2,039 M-1,680 M9,020 M9,889 M6,745 M1,525 M
GainLossOnInvestmentSecurities-4 M-120 M-133 M-32 M-56 M-192 M-166 M-645 M10 M-34 M
GainLossOnSaleOfBusiness11 M-49 M-30 M
GainLossOnSaleOfPPE52712.0196000.02 M10 M-4 M762000.014 M8 M893000.05 M
IncomeTaxPaidSupplementalData455 M447 M631 M949 M956 M818 M1,136 M214 M238 M
InterestPaidSupplementalData58 M86 M85 M82 M160 M86 M67 M2 M3 M
Issuance of capital stock90 M5,610 M
Issuance of debt95 M-95 M886 M419 M-5,007 M-146 M148 M79 M
IssuanceOfCapitalStock90 M5,610 M
IssuanceOfDebt3,836 M95 M-95 M1,646 M628 M-5,976 M-146 M148 M79 M
Net cash from financing activities92 M3,852 M-539 M-281 M7,196 M606 M-6,257 M-21 M-1,644 M-808 M
Net cash from investing activities-321 M-4,253 M-2,937 M-1,781 M-312 M-974 M-8,241 M-6,695 M-2,326 M152 M
Net cash from operating activities437 M3,263 M1,915 M2,831 M151 M836 M12,290 M11,820 M6,745 M1,525 M
Net change in cash & cash equivalents210 M2,764 M-1,466 M785 M933 M-27 M-2,319 M5,080 M4,360 M860 M
Net income from continuing operations52 M753 M1,509 M1,993 M1,892 M2,133 M3,986 M5,919 M736 M915 M
NetBusinessPurchaseAndSale-1,191 M-611 M-276 M-287 M-982 M-3,355 M-2,171 M-143 M-97 M
NetCommonStockIssuance90 M-650 M-194 M5,610 M-1,939 M-907 M
NetInvestmentPropertiesPurchaseAndSale-294 M-1,445 M-134 M455 M418 M-3,214 M-1,616 M-2,592 M144 M596 M
NetInvestmentPurchaseAndSale-294 M-1,445 M-134 M455 M418 M-3,214 M-1,616 M-2,592 M144 M596 M
NetIssuancePaymentsOfDebt3,836 M95 M-95 M1,646 M628 M-5,976 M-146 M148 M79 M
NetLongTermDebtIssuance3,836 M760 M209 M-969 M
NetPPEPurchaseAndSale-27 M-1,618 M-2,192 M-1,959 M-2,189 M-2,516 M-3,270 M-1,932 M-367 M-346 M
Operating (gains) losses-4 M-57 M-47 M50 M-38 M-144 M-167 M-774 M-61 M-67 M
Other financing charges net12 M10 M1 M-66 M-27 M-281 M136 M84 M25 M
Other investing changes net-128 M-1,981 M-569 M-115 M-507 M1,917 M1,898 M-87 M64 M
Other non-cash items43 M471 M709 M951 M773 M1,259 M2,534 M2,003 M371 M573 M
Payment of cash dividends12 M3 M5 M
ProceedsFromStockOptionExercised2 M11 M6 M6 M6 M4 M297000.0895000.066 M
Purchase of Float term investments-4 M-247 M-144 M-543 M-3,455 M-6,033 M-15,169 M-1,383 M-1,662 M
Purchase of property plant & equipment-27 M-1,618 M-2,192 M-1,959 M-2,189 M-2,516 M-3,270 M-1,932 M-367 M-346 M
Purchase of short term investments3,836 M760 M969 M
PurchaseOfInvestment-615 M-6,322 M-5,787 M-2,309 M-543 M-3,455 M-6,033 M-15,169 M-1,419 M-1,662 M
PurchaseOfLongTermInvestments-615 M-6,317 M-5,540 M-2,165 M-54 M-36 M
PurchaseOfPPE-28 M-1,618 M-2,193 M-1,973 M-2,199 M-2,521 M-3,303 M-2,237 M-429 M-352 M
Repayment of debt-760 M-969 M
RepaymentOfDebt-1,054 M-574 M-98 M-25 M-2,456 M-7,795 M-2,690 M-490 M-587 M
Repurchase of capital stock-650 M-194 M-1,939 M-907 M
Revenue per share229456.0278 M326 M437 M402 M119 M97 M142 M156 M176 M
Sale of Float term investments321 M5,005 M7,634 M3,332 M122 M1,054 M10 M26 M
Sale of short term investments1 M1,076 M748 M2,500 M9,626 M1,640 M2,168 M
SaleOfInvestment321 M5,005 M7,634 M3,332 M1,076 M748 M2,500 M10,680 M1,650 M2,194 M
SaleOfPPE682260.0204000.013 M9 M5 M33 M305 M62 M6 M
ShortTermDebtIssuance1,054 M669 M3 M910 M2,115 M1,819 M2,544 M638 M666 M
ShortTermDebtPayments-1,054 M-574 M-98 M-25 M-1,696 M-6,826 M-2,690 M-490 M-587 M
StockBasedCompensation12 M225 M303 M476 M667 M671 M688 M951 M158 M175 M
UnrealizedGainLossOnInvestmentSecurities-17 M-49 M-2 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