Personal Finance & Money Asked on December 25, 2020
In order to know if companies are conservatively financed I query yahooquery API and it gives me some financial information. According to Graham in The Intelligent Investor, I have to calculate the ratio of the total assets on the total liabilities and it should be at least 200%. Yet it seems that the vocabulary used for that has changed since last time I was using it.
I used to have a totalAssets
and a totalLiabilities
column but it seems that I now only have the assets but not the liabilities anymore:
asOfDate periodType AccountsPayable AccountsReceivable AccumulatedDepreciation AdditionalPaidInCapital AllowanceForDoubtfulAccountsReceivable AssetsHeldForSaleCurrent AvailableForSaleSecurities CapitalLeaseObligations CapitalStock CashAndCashEquivalents CashCashEquivalentsAndShortTermInvestments CashEquivalents CashFinancial CommonStock CommonStockEquity ConstructionInProgress CurrentAssets CurrentCapitalLeaseObligation CurrentDebt CurrentDebtAndCapitalLeaseObligation CurrentDeferredLiabilities CurrentDeferredRevenue CurrentLiabilities CurrentProvisions DerivativeProductLiabilities DividendsPayable DuefromRelatedPartiesCurrent DuetoRelatedPartiesCurrent DuetoRelatedPartiesNonCurrent EmployeeBenefits FinancialAssets ForeignCurrencyTranslationAdjustments GainsLossesNotAffectingRetainedEarnings Goodwill GoodwillAndOtherIntangibleAssets GrossAccountsReceivable GrossPPE IncomeTaxPayable Inventory InvestedCapital InvestmentinFinancialAssets InvestmentsAndAdvances InvestmentsinAssociatesatCost LandAndImprovements LongTermCapitalLeaseObligation LongTermDebt LongTermDebtAndCapitalLeaseObligation LongTermEquityInvestment LongTermProvisions MachineryFurnitureEquipment MinorityInterest NetDebt NetPPE NetTangibleAssets NonCurrentAccountsReceivable NonCurrentDeferredAssets NonCurrentDeferredLiabilities NonCurrentDeferredRevenue NonCurrentDeferredTaxesAssets NonCurrentDeferredTaxesLiabilities NonCurrentPensionAndOtherPostretirementBenefitPlans NonCurrentPrepaidAssets OrdinarySharesNumber OtherCurrentAssets OtherCurrentBorrowings OtherCurrentLiabilities OtherEquityAdjustments OtherEquityInterest OtherIntangibleAssets OtherInvestments OtherNonCurrentLiabilities OtherPayable OtherProperties OtherReceivables OtherShortTermInvestments Payables PayablesAndAccruedExpenses PensionandOtherPostRetirementBenefitPlansCurrent PrepaidAssets Properties Receivables RetainedEarnings ShareIssued StockholdersEquity TangibleBookValue TaxesReceivable TotalAssets TotalCapitalization TotalDebt TotalEquityGrossMinorityInterest TotalLiabilitiesNetMinorityInterest TotalNonCurrentAssets TotalNonCurrentLiabilitiesNetMinorityInterest TotalTaxPayable TradeandOtherPayablesNonCurrent TreasurySharesNumber TreasuryStock UnrealizedGainLoss WorkingCapital
symbol
TEFN.MX 2016-12-31 12M 1.185900e+10 8.828000e+09 -8.612000e+10 3.227000e+09 -2.795000e+09 2.100000e+07 9.765000e+09 NaN 5.038000e+09 3.736000e+09 6.690000e+09 1.659000e+09 2.077000e+09 5.038000e+09 1.815700e+10 3.350000e+09 1.997400e+10 NaN 1.397700e+10 1.397700e+10 2.073000e+09 1.569000e+09 3.545100e+10 1.218000e+09 2.747000e+09 NaN 28000000.0 497000000.0 NaN 6.147000e+09 NaN -1.474000e+10 -1.355500e+10 2.868600e+10 4.920400e+10 1.162300e+10 1.225130e+11 4.860000e+08 1.055000e+09 7.499900e+10 9.765000e+09 9.841000e+09 NaN 1.193000e+10 NaN 4.286500e+10 4.286500e+10 76000000.0 3.726000e+09 1.072330e+11 1.022800e+10 5.310600e+10 3.639300e+10 -3.104700e+10 NaN 8.229000e+09 3.906000e+09 9.030000e+08 8.229000e+09 2.395000e+09 9.350000e+08 NaN 5.037805e+09 NaN 1.397700e+10 7.720000e+08 1.176000e+09 7.834000e+09 2.051800e+10 NaN NaN 1.721000e+09 3.639300e+10 418000000.0 2.954000e+09 1.640900e+10 1.640900e+10 1.002000e+09 1.401000e+09 0.0 1.080700e+10 1.709300e+10 5.037805e+09 1.815700e+10 -3.104700e+10 1.533000e+09 1.236410e+11 6.102200e+10 5.684200e+10 2.838500e+10 9.525600e+10 1.036670e+11 5.980500e+10 2.332000e+09 414000000.0 NaN 1.480000e+09 9000000.0 -1.547700e+10
TEFN.MX 2017-12-31 12M 1.152300e+10 8.328000e+09 -8.364300e+10 4.538000e+09 -2.563000e+09 NaN 8.167000e+09 NaN 5.192000e+09 5.192000e+09 7.346000e+09 1.202000e+09 3.990000e+09 5.192000e+09 1.692000e+10 3.289000e+09 1.993100e+10 NaN 9.134000e+09 9.134000e+09 1.559000e+09 1.387000e+09 2.906600e+10 1.304000e+09 2.872000e+09 NaN 32000000.0 491000000.0 0.0 5.666000e+09 NaN -1.934700e+10 -1.790200e+10 2.684100e+10 4.484600e+10 1.089100e+10 1.178680e+11 5.800000e+08 1.117000e+09 6.951400e+10 8.167000e+09 8.244000e+09 NaN 1.134400e+10 NaN 4.346000e+10 4.346000e+10 77000000.0 3.552000e+09 1.032350e+11 9.698000e+09 4.740200e+10 3.422500e+10 -2.792600e+10 NaN 7.820000e+09 3.488000e+09 7.740000e+08 7.820000e+09 2.145000e+09 1.030000e+09 NaN 5.192132e+09 NaN 9.134000e+09 2.800000e+08 1.371000e+09 7.555000e+09 1.800500e+10 NaN NaN 1.522000e+09 NaN 367000000.0 2.154000e+09 1.587700e+10 1.587700e+10 9.120000e+08 1.366000e+09 0.0 1.010200e+10 1.822500e+10 5.257820e+09 1.692000e+10 -2.792600e+10 1.375000e+09 1.150660e+11 6.038000e+10 5.259400e+10 2.661800e+10 8.844800e+10 9.513500e+10 5.938200e+10 2.341000e+09 344000000.0 65687859.0 6.880000e+08 74000000.0 -9.135000e+09
TEFN.MX 2018-12-31 12M 1.169400e+10 8.009000e+09 -9.085900e+10 4.538000e+09 -2.657000e+09 1.492000e+09 1.050000e+09 NaN 5.192000e+09 5.692000e+09 7.901000e+09 8.060000e+08 4.886000e+09 5.192000e+09 1.794700e+10 2.453000e+09 2.334000e+10 NaN 9.138000e+09 9.138000e+09 1.868000e+09 1.617000e+09 2.964900e+10 1.026000e+09 2.287000e+09 311000000.0 33000000.0 520000000.0 NaN 4.499000e+09 2.776000e+09 -1.475100e+10 -1.352200e+10 2.574800e+10 4.260400e+10 1.066600e+10 1.241540e+11 5.800000e+08 1.692000e+09 7.013200e+10 1.050000e+09 1.691000e+09 68000000.0 1.194900e+10 NaN 4.304700e+10 4.304700e+10 68000000.0 3.021000e+09 1.097520e+11 9.033000e+09 4.649300e+10 3.329500e+10 -2.465700e+10 478000000.0 7.822000e+09 4.232000e+09 8.960000e+08 7.631000e+09 2.674000e+09 3.890000e+08 2.041000e+09 5.192132e+09 566000000.0 9.138000e+09 1.067000e+09 1.598000e+09 7.540000e+09 1.685600e+10 573000000.0 NaN 1.092000e+09 3.329500e+10 718000000.0 2.209000e+09 1.566400e+10 1.566400e+10 8.860000e+08 1.253000e+09 0.0 1.043600e+10 1.488500e+10 5.257628e+09 1.794700e+10 -2.465700e+10 1.676000e+09 1.140470e+11 6.099400e+10 5.218500e+10 2.698000e+10 8.706700e+10 9.070700e+10 5.741800e+10 2.047000e+09 332000000.0 65496120.0 6.860000e+08 -369000000.0 -6.309000e+09
TEFN.MX 2019-12-31 12M 1.111400e+10 8.171000e+09 -8.903100e+10 4.538000e+09 -2.798000e+09 8.180000e+08 3.530000e+08 7.226000e+09 5.192000e+09 6.042000e+09 9.165000e+09 8.330000e+08 5.209000e+09 5.192000e+09 1.711800e+10 2.381000e+09 2.432800e+10 1.600000e+09 8.552000e+09 1.015200e+10 1.792000e+09 1.596000e+09 3.019100e+10 5.620000e+08 2.358000e+09 282000000.0 37000000.0 634000000.0 NaN 5.789000e+09 3.389000e+09 -1.458800e+10 -1.349100e+10 2.540300e+10 4.143700e+10 1.096900e+10 1.281980e+11 1.073000e+09 1.999000e+09 6.660000e+10 3.530000e+08 1.093000e+09 140000000.0 1.058800e+10 5.626000e+09 4.093000e+10 4.655600e+10 140000000.0 2.697000e+09 1.082900e+11 8.332000e+09 4.344000e+10 3.916700e+10 -2.431900e+10 903000000.0 6.903000e+09 5.457000e+09 1.187000e+09 6.682000e+09 2.908000e+09 5.650000e+08 1.657000e+09 5.192132e+09 625000000.0 8.552000e+09 9.040000e+08 1.541000e+09 8.267000e+09 1.603400e+10 600000000.0 4.328800e+10 1.081000e+09 6.939000e+09 895000000.0 3.123000e+09 1.567100e+10 1.567100e+10 1.110000e+09 1.057000e+09 0.0 1.066400e+10 1.337800e+10 5.269694e+09 1.711800e+10 -2.431900e+10 1.561000e+09 1.188770e+11 5.804800e+10 5.670800e+10 2.545000e+10 9.342700e+10 9.454900e+10 6.323600e+10 2.560000e+09 379000000.0 77562635.0 7.660000e+08 -444000000.0 -5.863000e+09
So I wonder what should I use now: TotalAssets
on TotalLiabilitiesNetMinorityInterest
?
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP