public ConsolidatedStatementOfCashFlow(OperatingActivities operatingActivities, InvestingActivities investingActivities, FinancingActivities financingActivities)
{
OperatingActivities = operatingActivities;
InvestingActivities = investingActivities;
FinancingActivities = financingActivities;
}
public ConsolidatedStatementOfCashFlow()
{
OperatingActivities = new OperatingActivities();
InvestingActivities = new InvestingActivities();
FinancingActivities = new FinancingActivities();
}
private ConsolidatedStatementOfCashFlow GetCashFlow(IWebElement table)
{
var cashFlow = new ConsolidatedStatementOfCashFlow();
var operating = new OperatingActivities();
var investing = new InvestingActivities();
var financing = new FinancingActivities();
var tableRows = table.FindElements(By.TagName("tr"));
foreach (var tr in tableRows)
{
var tableCellCount = tr.FindElements(By.TagName("td")).Count();
var tcs = tr.FindElements(By.TagName("td"));
if (tr.Text.Contains("Net income"))
{
operating.NetIncome = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Depreciation expense and impairment of property and equipment"))
{
operating.DepreciationOfProperty = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Amortization and impairment of intangible assets"))
{
operating.AmortizationOfIntangibleAssets = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Stock-based compensation expense"))
{
operating.StockBasedCompensationExpense = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Excess tax benefits from stock-based award activities"))
{
operating.ExcessTaxBenefitsFromStockBasedAward = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Deferred income taxes"))
{
operating.DeferredIncomeTaxes = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Gain on equity interest"))
{
operating.GainOnEquityInterest = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("loss on marketable and non-marketable investments, net"))
{
operating.NetLossOnInvestments = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Other"))
{
operating.OtherAdjustments = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Accounts receivable"))
{
operating.AccountsReceivable = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Income taxes, net"))
{
operating.NetIncomeTaxes = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Prepaid revenue share, expenses and other assets"))
{
operating.OtherAssets = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Accounts payable"))
{
operating.AccountsPayable = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Accrued expenses and other liabilities"))
{
operating.AccruedExpensesAndLiabilities = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Accrued revenue share"))
{
operating.AccruedRevenueShare = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Deferred revenue"))
{
operating.DeferredRevenue = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Purchases of property and equipment"))
{
investing.PurchasesOfProperty = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Purchases of marketable securities"))
{
investing.PurchasesOfMarketableSecurities = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Maturities and sales of marketable securities"))
{
investing.MaturitiesAndSalesOfInvestments = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Purchases of non-marketable investments"))
{
investing.PurchasesOfMarketableSecurities = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Cash collateral related to securities lending"))
{
investing.CashCollateral = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("nvestments in reverse repurchase agreements"))
{
investing.InvestmentsInReverseRepurchaseAgreements = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Acquisitions, net of cash acquired, and purchases of intangibles and other assets"))
{
investing.AcquisitionsNet = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Net payments related to stock-based award activities"))
{
financing.NetPaymentsToStockBasedAwards = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Excess tax benefits from stock-based award activities"))
{
financing.ExcessTaxBenefitsFromStockBasedAwards = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Adjustment Payment to Class C capital stockholders"))
{
financing.AdjustmentPaymentToClassCStockHolders = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Proceeds from issuance of debt, net of costs"))
{
financing.NetProceedsFromIssuranceOfDebt = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Repayments of debt"))
{
financing.RepaymentsOfDebt = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Effect of exchange rate changes on cash and cash equivalents"))
{
cashFlow.EffectOfExchangeRateChangesOnCash = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
}
cashFlow.OperatingActivities = operating;
cashFlow.InvestingActivities = investing;
cashFlow.FinancingActivities = financing;
return(cashFlow);
}
