FundamentalAnalysis#

What it is#

fundamentalanalysis is a python package that makes it easy to access current and historical financial data from Financial Modeling Prep.

See the following resources:

After setting up a free account with Financial Modeling Prep, you gain access to a unique API key. From there you can import the fundamentalanalysis package and define an API variable.

import pandas as pd
import fundamentalanalysis as fa

my_api_key = 'YOUR_API_KEY_HERE'

Attention

With a free account, we are able to make no more than 250 requests per day. Similarly, the rate at which we can make requests might be limited. See the Slowing down requests section below.

Available functions#

Below you will find some examples of what you can do with the fundamentalanalysis package.

Available companies#

available_tickers = fa.available_companies(my_api_key)
available_tickers
name price exchange exchangeShortName type
symbol
SPY SPDR S&P 500 ETF Trust 402.33 New York Stock Exchange Arca AMEX etf
CMCSA Comcast Corporation 35.65 NASDAQ Global Select NASDAQ stock
KMI Kinder Morgan, Inc. 18.63 New York Stock Exchange NYSE stock
INTC Intel Corporation 29.34 NASDAQ Global Select NASDAQ stock
MU Micron Technology, Inc. 58.41 NASDAQ Global Select NASDAQ stock
... ... ... ... ... ...
TSLL Direxion Daily TSLA Bull 1.5X Shares 11.78 NASDAQ Global Market NASDAQ stock
AAALF Aareal Bank AG 31.99 Other OTC OTC stock
GEN Gen Digital Inc. 23.11 NASDAQ Global Select NASDAQ stock
NAMS NewAmsterdam Pharma Company N.V. Ordinary Shares 10.04 NASDAQ Global Market NASDAQ stock
NAMSW NewAmsterdam Pharma Company N.V. Warrant 0.95 NASDAQ Global Market NASDAQ stock

45692 rows × 5 columns

Company profile#

my_ticker = 'PFE'
company_profile = fa.profile(ticker=my_ticker, api_key=my_api_key)
company_profile
0
symbol PFE
price 49.21
beta 0.641639
volAvg 19927634
mktCap 276230982738
lastDiv 1.6
range 41.45-61.71
changes 0.36
companyName Pfizer Inc.
currency USD
cik 0000078003
isin US7170811035
cusip 717081103
exchange New York Stock Exchange
exchangeShortName NYSE
industry Drug Manufacturers—General
website https://www.pfizer.com
description Pfizer Inc. discovers, develops, manufactures,...
ceo Dr. Albert Bourla
sector Healthcare
country US
fullTimeEmployees 79000
phone 12125732323
address 235 E 42ND ST
city New York City
state NEW YORK
zip 10017
dcfDiff 0.329424
dcf 48.5206
image https://financialmodelingprep.com/image-stock/...
ipoDate 1944-01-17
defaultImage False
isEtf False
isActivelyTrading True
isAdr False
isFund False

Financial statements#

company_bs = fa.balance_sheet_statement(ticker=my_ticker, api_key=my_api_key)
company_bs
2021 2020 2019 2018 2017 2016 2015 2014 2013 2012 ... 2003 2002 2001 2000 1999 1998 1997 1996 1995 1994
reportedCurrency USD USD USD USD USD USD USD USD USD USD ... USD USD USD USD USD USD USD USD USD USD
cik 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 ... 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003
fillingDate 2022-02-24 2021-02-25 2020-02-27 2019-02-28 2018-02-22 2017-02-23 2016-02-29 2015-02-27 2014-02-28 2013-02-28 ... 2004-03-10 2003-03-27 2002-03-28 2001-03-28 1999-12-31 1998-12-31 1997-12-31 1996-12-31 1996-03-29 1995-03-24
acceptedDate 2022-02-24 14:25:01 2021-02-25 13:59:00 2020-02-27 14:15:12 2019-02-28 14:35:32 2018-02-22 15:42:15 2017-02-23 16:30:32 2016-02-29 17:26:35 2015-02-27 16:38:16 2014-02-28 16:38:15 2013-02-28 16:57:54 ... 2004-03-10 11:17:20 2003-03-27 15:04:15 2002-03-28 00:00:00 2001-03-28 00:00:00 1999-12-31 1998-12-31 1997-12-31 1996-12-31 1996-03-29 00:00:00 1995-03-24 00:00:00
calendarYear 2021 2020 2019 2018 2017 2016 2015 2014 2013 2012 ... 2003 2002 2001 2000 1999 1998 1997 1996 1995 1994
period FY FY FY FY FY FY FY FY FY FY ... FY FY FY FY FY FY FY FY FY FY
cashAndCashEquivalents 1944000000 1784000000 1305000000 1139000000 1342000000 2595000000 3641000000 3343000000 2183000000 10389000000 ... 1520000000 1878000000 1036000000 1099000000 739000000 1552000000 877000000 1150000000 403300000 1458500000
shortTermInvestments 29125000000 10437000000 8525000000 17694000000 18650000000 15255000000 19649000000 32779000000 30225000000 22319000000 ... 10432000000 10673000000 7579000000 5764000000 3703000000 0.0 0.0 0.0 0.0 0.0
cashAndShortTermInvestments 31069000000 12221000000 9830000000 18833000000 19992000000 17850000000 23290000000 36122000000 32408000000 32708000000 ... 11952000000 12551000000 8615000000 6863000000 4442000000 1552000000 877000000 1150000000 403300000 1458500000
netReceivables 15745000000 11194000000 12068000000 11399000000 11271000000 11266000000 10838000000 8669000000 9357000000 21574000000 ... 9166000000 6184000000 5337000000 5489000000 3864000000 2914000000 2527000000 2252000000 2024000000 1665000000
inventory 9059000000 8046000000 8283000000 7508000000 7578000000 6783000000 7513000000 5663000000 6166000000 7063000000 ... 5837000000 2678000000 2741000000 2702000000 1654000000 1828000000 1773000000 1589000000 1384100000 1264900000
otherCurrentAssets 3820000000 3606000000 2622000000 12186000000 2300000000 3050000000 2163000000 7248000000 8313000000 70000000 ... 2786000000 3368000000 1757000000 2133000000 1231000000 3637000000 1643000000 1477000000 2341000000 1400000000
totalCurrentAssets 59693000000 35067000000 32803000000 49926000000 41141000000 38949000000 43804000000 57702000000 56244000000 61415000000 ... 29741000000 24781000000 18450000000 17187000000 11191000000 9931000000 6820000000 6468000000 6152400000 5788400000
propertyPlantEquipmentNet 14882000000 13900000000 13967000000 13385000000 13865000000 13318000000 13766000000 11762000000 12397000000 14461000000 ... 18287000000 10712000000 10415000000 9425000000 5343000000 4415000000 4137000000 3850000000 3472600000 3073200000
goodwill 49208000000 49577000000 58653000000 53411000000 55952000000 54449000000 48242000000 42069000000 42519000000 44672000000 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
intangibleAssets 25146000000 28472000000 35369000000 35211000000 48740000000 52648000000 40358000000 35167000000 39385000000 46013000000 ... 58656000000 1200000000 1722000000 1791000000 763000000 813000000 1294000000 1424000000 1243000000 325700000
goodwillAndIntangibleAssets 74354000000 78049000000 94022000000 88622000000 104692000000 107097000000 88600000000 77236000000 81904000000 90685000000 ... 58656000000 1200000000 1722000000 1791000000 763000000 813000000 1294000000 1424000000 1243000000 325700000
longTermInvestments 21526000000 20262000000 20147000000 2767000000 7015000000 7116000000 15999000000 17518000000 16406000000 14149000000 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
taxAssets 3341000000 2383000000 2099000000 1924000000 1855000000 1812000000 1794000000 1544000000 1554000000 0.0 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
otherNonCurrentAssets 7679000000 4569000000 4450000000 2798000000 3227000000 3323000000 3497000000 3512000000 3596000000 5088000000 ... 10091000000 9663000000 8566000000 5107000000 3277000000 3143000000 3085000000 2925000000 1861300000 1911200000
totalNonCurrentAssets 121782000000 119163000000 134685000000 109496000000 130654000000 132666000000 123656000000 111572000000 115857000000 124383000000 ... 87034000000 21575000000 20703000000 16323000000 9383000000 8371000000 8516000000 8199000000 6576900000 5310100000
otherAssets 1000000.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
totalAssets 181476000000 154230000000 167488000000 159422000000 171795000000 171615000000 167460000000 169274000000 172101000000 185798000000 ... 116775000000 46356000000 39153000000 33510000000 20574000000 18302000000 15336000000 14667000000 12729300000 11098500000
accountPayables 5578000000 4309000000 4220000000 4674000000 4656000000 4536000000 3620000000 3440000000 3234000000 4264000000 ... 2601000000 1620000000 1579000000 1719000000 951000000 971000000 765000000 913000000 715300000 524900000
shortTermDebt 2241000000 2703000000 16190000000 8836000000 9940000000 10688000000 10160000000 5141000000 6027000000 6424000000 ... 8818000000 8669000000 6265000000 4289000000 5001000000 2729000000 2255000000 2235000000 2035500000 2220000000
taxPayables 1266000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
deferredRevenue 3067000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
otherCurrentLiabilities 30519000000 18908000000 16894000000 18348000000 15831000000 15891000000 15619000000 13050000000 14105000000 17931000000 ... 12238000000 8266000000 5796000000 5973000000 3233000000 3492000000 2285000000 2492000000 2436400000 2081000000
totalCurrentLiabilities 42671000000 25920000000 37304000000 31858000000 30427000000 31115000000 29399000000 21631000000 23366000000 28619000000 ... 23657000000 18555000000 13640000000 11981000000 9185000000 7192000000 5305000000 5640000000 5187200000 4825900000
longTermDebt 34757000000 35571000000 35955000000 32429000000 32666000000 31398000000 28818000000 31541000000 30462000000 31036000000 ... 5755000000 3140000000 2609000000 1123000000 525000000 527000000 1123000000 687000000 833000000 604200000
deferredRevenueNonCurrent 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
deferredTaxLiabilitiesNonCurrent 349000000 4063000000 5578000000 3700000000 3900000000 30753000000 26877000000 24981000000 25590000000 21593000000 ... 13238000000 364000000 452000000 380000000 301000000 197000000 156000000 253000000 166100000 211700000
otherNonCurrentLiabilities 26237000000 25202000000 25205000000 27677000000 33148000000 18509000000 17368000000 19499000000 16063000000 22872000000 ... 8748000000 4347000000 4159000000 3950000000 1676000000 1576000000 819000000 1083000000 989800000 1094000000
totalNonCurrentLiabilities 61343000000 64836000000 66738000000 63806000000 69714000000 80660000000 73063000000 76021000000 72115000000 75501000000 ... 27741000000 7851000000 7220000000 5453000000 2502000000 2300000000 2098000000 2023000000 1988900000 1909900000
otherLiabilities 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
capitalLeaseObligations 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 ... 0.0 0.0 0 0 0 0 0 0 0 0
totalLiabilities 104014000000 90756000000 104042000000 95664000000 100141000000 111775000000 102462000000 97652000000 95481000000 104120000000 ... 51398000000 26406000000 20860000000 17434000000 11687000000 9492000000 7403000000 7663000000 7176100000 6735800000
preferredStock 0.0 0.0 17000000 19000000 21000000 24000000 26000000 29000000 33000000 39000000 ... 219000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
commonStock 473000000 470000000 468000000 467000000 464000000 461000000 459000000 455000000 453000000 448000000 ... 435000000 341000000 340000000 337000000 213000000 0.0 0.0 0.0 0.0 0.0
retainedEarnings 103394000000 96770000000 97670000000 89554000000 85291000000 71774000000 71993000000 72176000000 69732000000 54240000000 ... 29382000000 30243000000 24430000000 19599000000 13396000000 11439000000 9349000000 8017000000 6858900000 5944500000
accumulatedOtherComprehensiveIncomeLoss -5897000000 -14812000000 -11640000000 -11275000000 -9321000000 -11036000000 -9522000000 -7316000000 -3271000000 -5953000000 ... -7094000000 -5431000000 -5133000000 -4709000000 -2074000000 -2429000000 -1990000000 -2155000000 -1990800000 -1919700000
othertotalStockholdersEquity -20769000000 -19190000000 -23372000000 -15358000000 -5147000000 -1679000000 1764000000 5957000000 9360000000 32486000000 ... 42435000000 -5203000000 -1344000000 849000000 -2648000000 -200000000 574000000 1092000000 638500000 299100000
totalStockholdersEquity 77201000000 63238000000 63143000000 63407000000 71308000000 59544000000 64720000000 71301000000 76307000000 81260000000 ... 65377000000 19950000000 18293000000 16076000000 8887000000 8810000000 7933000000 6954000000 5506600000 4323900000
totalLiabilitiesAndStockholdersEquity 181215000000 153994000000 167185000000 159071000000 171449000000 171319000000 167182000000 168953000000 171788000000 185380000000 ... 116775000000 46356000000 39153000000 33510000000 20574000000 18302000000 15336000000 14617000000 12682700000 11059700000
minorityInterest 261000000 236000000 303000000 351000000 346000000 296000000 278000000 321000000 313000000 418000000 ... 0 0 0 0 0 0 0 50000000 46600000 38800000
totalEquity 77462000000 63474000000 63446000000 63758000000 71654000000 59840000000 64998000000 71622000000 76620000000 81678000000 ... 65377000000 19950000000 18293000000 16076000000 8887000000 8810000000 7933000000 7004000000 5553200000 4362700000
totalLiabilitiesAndTotalEquity 181476000000 154230000000 167488000000 159422000000 171795000000 171615000000 167460000000 169274000000 172101000000 185798000000 ... 116775000000 46356000000 39153000000 33510000000 20574000000 18302000000 15336000000 14667000000 12729300000 11098500000
totalInvestments 50651000000 30699000000 28672000000 20461000000 25665000000 22371000000 35648000000 50297000000 46631000000 36468000000 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
totalDebt 36998000000 38274000000 52145000000 41265000000 42606000000 42086000000 38978000000 36682000000 36489000000 37460000000 ... 14573000000 11809000000 8874000000 5412000000 5526000000 3256000000 3378000000 2922000000 2868500000 2824200000
netDebt 35054000000 36490000000 50840000000 40126000000 41264000000 39491000000 35337000000 33339000000 34306000000 27071000000 ... 13053000000 9931000000 7838000000 4313000000 4787000000 1704000000 2501000000 1772000000 2465200000 1365700000
link https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... ... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/...
finalLink https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... ... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/...

52 rows × 28 columns

company_is = fa.income_statement(ticker=my_ticker, api_key=my_api_key)
company_is
2021 2020 2019 2018 2017 2016 2015 2014 2013 2012 ... 1994 1993 1992 1991 1990 1989 1988 1987 1986 1985
reportedCurrency USD USD USD USD USD USD USD USD USD USD ... USD USD USD USD USD USD USD USD USD USD
cik 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 ... 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003
fillingDate 2022-02-24 2021-02-25 2020-02-27 2019-02-28 2018-02-22 2017-02-23 2016-02-29 2015-02-27 2014-02-28 2013-02-28 ... 1995-03-24 1993-12-31 1992-12-31 1991-12-31 1990-12-31 1989-12-31 1988-12-31 1987-12-31 1986-12-31 1985-12-31
acceptedDate 2022-02-24 14:25:01 2021-02-25 13:59:00 2020-02-27 14:15:12 2019-02-28 14:35:32 2018-02-22 15:42:15 2017-02-23 16:30:32 2016-02-29 17:26:35 2015-02-27 16:38:16 2014-02-28 16:38:15 2013-02-28 16:57:54 ... 1995-03-24 00:00:00 1993-12-31 1992-12-31 1991-12-31 1990-12-31 1989-12-31 1988-12-31 1987-12-31 1986-12-31 1985-12-31
calendarYear 2021 2020 2019 2018 2017 2016 2015 2014 2013 2012 ... 1994 1993 1992 1991 1990 1989 1988 1987 1986 1985
period FY FY FY FY FY FY FY FY FY FY ... FY FY FY FY FY FY FY FY FY FY
revenue 81288000000 41908000000 51750000000 53647000000 52546000000 52824000000 48851000000 49605000000 51584000000 58986000000 ... 8281300000 7477700000 7230200000 6950000000 6406000000 5671500000 5385400000 4919800000 4476000000 4024500000
costOfRevenue 30821000000 8692000000 10219000000 11248000000 11240000000 12329000000 9648000000 9577000000 9586000000 11334000000 ... 1626600000 1513800000 1760400000 1956500000 2034600000 1855200000 1825600000 1734900000 1573300000 1416200000
grossProfit 50467000000 33216000000 41531000000 42399000000 41306000000 40495000000 39203000000 40028000000 41998000000 47652000000 ... 6654700000 5963900000 5469800000 4993500000 4371400000 3816300000 3559800000 3184900000 2902700000 2608300000
grossProfitRatio 0.620842 0.792593 0.802531 0.790333 0.786092 0.766602 0.802501 0.806935 0.814167 0.807853 ... 0.803582 0.797558 0.756521 0.718489 0.682392 0.672891 0.661009 0.647364 0.648503 0.648105
researchAndDevelopmentExpenses 13829000000 9405000000 8650000000 8006000000 7657000000 7872000000 7690000000 8393000000 6678000000 7870000000 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
generalAndAdministrativeExpenses 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 ... 4390200000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
sellingAndMarketingExpenses 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
sellingGeneralAndAdministrativeExpenses 12703000000 11615000000 14350000000 14455000000 14784000000 14837000000 14809000000 14097000000 14355000000 16616000000 ... 4390200000 4792400000 3762500000 3495900000 3092800000 2641000000 2353400000 2082100000 1795900000 1598800000
otherExpenses 3700000000 3436000000 4610000000 4893000000 4758000000 4056000000 3728000000 4039000000 4599000000 5175000000 ... 292000000 258200000 263900000 244100000 224800000 207100000 194500000 162000000 147100000 129500000
operatingExpenses 30232000000 24456000000 27610000000 27354000000 27199000000 26765000000 26227000000 26529000000 25632000000 29661000000 ... 4682200000 5050600000 4026400000 3740000000 3317600000 2848100000 2547900000 2244100000 1943000000 1728300000
costAndExpenses 61053000000 33148000000 37829000000 38602000000 38439000000 39094000000 35875000000 36106000000 35218000000 40995000000 ... 6308800000 6564400000 5786800000 5696500000 5352200000 4703300000 4373500000 3979000000 3516300000 3144500000
interestIncome 36000000 73000000 226000000 333000000 391000000 470000000 471000000 425000000 403000000 383000000 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
interestExpense 1291000000 1449000000 1574000000 1316000000 1270000000 1186000000 1199000000 1360000000 1414000000 1524000000 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
depreciationAndAmortization 5191000000 4777000000 6010000000 6384000000 6269000000 5757000000 5157000000 5537000000 6410000000 7611000000 ... 292000000 258200000 263900000 244100000 224800000 207100000 194500000 162000000 147100000 129500000
ebitda 30313000000 16319000000 25241000000 19559000000 19798000000 15281000000 15306000000 19152000000 34133000000 26267000000 ... 2148900000 1107000000 1513400000 1184600000 1323900000 1119500000 1295200000 1169500000 1107800000 1005600000
ebitdaratio 0.372909 0.389401 0.487749 0.364587 0.376775 0.289281 0.31332 0.38609 0.661697 0.445309 ... 0.259488 0.14804 0.209316 0.170446 0.206666 0.19739 0.240502 0.237713 0.247498 0.24987
operatingIncome 20235000000 8760000000 13921000000 15045000000 14107000000 13730000000 12976000000 13499000000 16366000000 17991000000 ... 1972500000 913300000 1443400000 1253500000 1053800000 968200000 1011900000 940800000 959700000 880000000
operatingIncomeRatio 0.24893 0.209029 0.269005 0.280444 0.26847 0.25992 0.265624 0.27213 0.317269 0.305005 ... 0.238187 0.122136 0.199635 0.18036 0.164502 0.170713 0.187897 0.191227 0.21441 0.218661
totalOtherIncomeExpensesNet 4076000000 -1263000000 3761000000 -3160000000 -1802000000 -5379000000 -4011000000 -1259000000 -650000000 -5911000000 ... -115600000 -64500000 88700000 -313000000 45300000 -55800000 88800000 66700000 1000000.0 -3900000.0
incomeBeforeTax 24311000000 7497000000 17682000000 11885000000 12305000000 8351000000 8965000000 12240000000 15716000000 12080000000 ... 1856900000 848800000 1532100000 940500000 1099100000 912400000 1100700000 1007500000 960700000 876100000
incomeBeforeTaxRatio 0.299072 0.178892 0.341681 0.221541 0.234176 0.158091 0.183517 0.246749 0.304668 0.204794 ... 0.224228 0.113511 0.211903 0.135324 0.171574 0.160875 0.204386 0.204785 0.214634 0.217692
incomeTaxExpense 1852000000 477000000 1384000000 706000000 -9049000000 1123000000 1990000000 3120000000 4306000000 2562000000 ... 558500000 191300000 438600000 218400000 297900000 231300000 309400000 317300000 300700000 296400000
netIncome 21979000000 9616000000 16273000000 11153000000 21308000000 7215000000 6960000000 9135000000 22003000000 14570000000 ... 1298400000 657500000 810900000 722100000 801200000 681100000 791300000 690200000 660000000 579700000
netIncomeRatio 0.270384 0.229455 0.314454 0.207896 0.405511 0.136586 0.142474 0.184155 0.426547 0.247008 ... 0.156787 0.087928 0.112155 0.103899 0.12507 0.120092 0.146934 0.14029 0.147453 0.144043
eps 3.92 1.73 2.92 1.9 3.57 1.18 1.13 1.44 3.23 1.96 ... 0.349167 0.17 0.21 0.19 0.21 0.16 0.19 0.17 0.16 0.14
epsdiluted 3.85 1.71 2.87 1.87 3.52 1.17 1.11 1.42 3.19 1.94 ... 0.349167 0.17 0.2 0.18 0.21 0.16 0.19 0.17 0.16 0.14
weightedAverageShsOut 5601000000 5555000000 5569000000 5872000000 5970000000 6089000000 6176000000 6346000000 6813000000 7442000000 ... 3718568019 3867647059 3861428571 3800526316 3815238095 4256875000 4164736842 4060000000 4125000000 4140714286
weightedAverageShsOutDil 5708000000 5632000000 5675000000 5977000000 6058000000 6159000000 6257000000 6424000000 6895000000 7508000000 ... 3718568019 3867647059 4054500000 4011666667 3815238095 4256875000 4164736842 4060000000 4125000000 4140714286
link https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... ... https://www.sec.gov/Archives/edgar/data/78003/...
finalLink https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... ... https://www.sec.gov/Archives/edgar/data/78003/...

36 rows × 37 columns

company_cf = fa.cash_flow_statement(ticker=my_ticker, api_key=my_api_key)
company_cf
2021 2020 2019 2018 2017 2016 2015 2014 2013 2012 ... 1998 1997 1996 1995 1994 1993 1992 1991 1990 1989
reportedCurrency USD USD USD USD USD USD USD USD USD USD ... USD USD USD USD USD USD USD USD USD USD
cik 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 ... 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003 0000078003
fillingDate 2022-02-24 2021-02-25 2020-02-27 2019-02-28 2018-02-22 2017-02-23 2016-02-29 2015-02-27 2014-02-28 2013-02-28 ... 1998-12-31 1997-12-31 1996-12-31 1996-03-29 1995-03-24 1993-12-31 1992-12-31 1991-12-31 1990-12-31 1989-12-31
acceptedDate 2022-02-24 14:25:01 2021-02-25 13:59:00 2020-02-27 14:15:12 2019-02-28 14:35:32 2018-02-22 15:42:15 2017-02-23 16:30:32 2016-02-29 17:26:35 2015-02-27 16:38:16 2014-02-28 16:38:15 2013-02-28 16:57:54 ... 1998-12-31 1997-12-31 1996-12-31 1996-03-29 00:00:00 1995-03-24 00:00:00 1993-12-31 1992-12-31 1991-12-31 1990-12-31 1989-12-31
calendarYear 2021 2020 2019 2018 2017 2016 2015 2014 2013 2012 ... 1998 1997 1996 1995 1994 1993 1992 1991 1990 1989
period FY FY FY FY FY FY FY FY FY FY ... FY FY FY FY FY FY FY FY FY FY
netIncome 21979000000 9616000000 16273000000 11153000000 21308000000 7215000000 6960000000 9135000000 22003000000 14570000000 ... 3351000000 2213000000 1929000000 1572900000 1298400000 657500000 810900000 722100000 801200000 681100000
depreciationAndAmortization 5191000000 4777000000 6010000000 6384000000 6269000000 5757000000 5157000000 5537000000 6410000000 7611000000 ... 489000000 502000000 430000000 374000000 292000000 258200000 263900000 244100000 224800000 207100000
deferredIncomeTax -4293000000 -1468000000 614000000 -2205000000 -2410000000 -700000000 -18000000 317000000 1703000000 2198000000 ... -61000000 24000000 75000000 -12900000 32600000 -336100000 0.0 0.0 0.0 0.0
stockBasedCompensation 1182000000 756000000 718000000 949000000 840000000 691000000 669000000 586000000 523000000 481000000 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
changeInWorkingCapital 12804000000 -275000000 -4031000000 -926000000 1296000000 85000000 564000000 1423000000 -3392000000 -1942000000 ... 224000000 -1110000000 -381000000 -77600000 -128600000 -79600000 -370600000 -342700000 -59400000 -223100000
accountsReceivables -3811000000 -1249000000 -742000000 -644000000 259000000 -134000000 21000000 148000000 940000000 275000000 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
inventory -1125000000 -736000000 -1050000000 -717000000 -357000000 365000000 -199000000 175000000 -538000000 -631000000 ... -439000000 -375000000 -149000000 -24600000 -110800000 -142300000 -116100000 -118000000 -38800000 -77100000
accountsPayables 1242000000 353000000 -564000000 431000000 46000000 871000000 254000000 297000000 382000000 579000000 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
otherWorkingCapital -1166000000 -1238000000 -2737000000 -78000000 1446000000 -734000000 -235000000 491000000 -170000000 1190000000 ... 2739000000 1515000000 828000000 965200000 962500000 0.0 0.0 0.0 0.0 0.0
otherNonCashItems -4283000000 997000000 -6996000000 472000000 -10833000000 2853000000 1180000000 -115000000 -9482000000 -5864000000 ... -1074000000 0.0 14000000 -35000000 -5900000.0 763000000 102800000 224100000 -106100000 -9300000.0
netCashProvidedByOperatingActivities 32580000000 14403000000 12588000000 15827000000 16470000000 15901000000 14512000000 16883000000 17765000000 17054000000 ... 2929000000 1629000000 2067000000 1821400000 1488500000 1263000000 807000000 847600000 860500000 655800000
investmentsInPropertyPlantAndEquipment -2711000000 -2252000000 -2176000000 -2042000000 -1956000000 -1823000000 -1397000000 -1199000000 -1206000000 -1327000000 ... -1198000000 -943000000 -774000000 -696300000 -671500000 -634200000 -674200000 -593800000 -547500000 -456500000
acquisitionsNet 0.0 0.0 -10861000000 0.0 -1000000000 -18368000000 -16466000000 -195000000 -15000000 10800000000 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
purchasesOfInvestments -47613000000 -14402000000 -7036000000 -13474000000 -18133000000 -28186000000 -38123000000 -61672000000 -58058000000 -35163000000 ... -5845000000 -317000000 -2862000000 -2610400000 -1355900000 -760900000 -535700000 -210600000 -89600000 -526900000
salesMaturitiesOfInvestments 28096000000 12730000000 16340000000 19908000000 15959000000 40690000000 52761000000 57449000000 48682000000 31751000000 ... 4209000000 217000000 3490000000 2184600000 1288200000 846800000 510800000 242400000 197200000 449800000
otherInvestingActivites -318000000 -347000000 -212000000 133000000 389000000 -124000000 245000000 -37000000 -28000000 93000000 ... 2499000000 21000000 -791000000 -1220700000 -101100000 351400000 1089000000 436800000 110900000 -93200000
netCashUsedForInvestingActivites -22546000000 -4271000000 -3945000000 4525000000 -4741000000 -7811000000 -2980000000 -5654000000 -10625000000 6154000000 ... -335000000 -1022000000 -937000000 -2342800000 -840300000 -196900000 389900000 -125200000 -329000000 -626800000
debtRepayment -2100000000 -30329000000 -12633000000 -9620000000 -14743000000 -15875000000 -6968000000 -3955000000 -8380000000 -9720000000 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
commonStockIssued 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 ... 643000000 411000000 280000000 205000000 64200000 0.0 0.0 0.0 0.0 0.0
commonStockRepurchased 0.0 0.0 -8865000000 -12198000000 -5000000000 -5000000000 -6160000000 -5000000000 -16290000000 -8228000000 ... -1912000000 -586000000 -27000000 -108500000 -511200000 -1019600000 -665100000 -463900000 -132200000 -154700000
dividendsPaid -8729000000 -8440000000 -8043000000 -7978000000 -7659000000 -7317000000 -6940000000 -6609000000 -6580000000 -6534000000 ... -976000000 -881000000 -771000000 -658500000 -594600000 -536100000 -486500000 -437100000 -396700000 -364000000
otherFinancingActivites 1013000000 29120000000 21056000000 9355000000 14367000000 19271000000 9835000000 5578000000 16275000000 8483000000 ... 325000000 208000000 136000000 42900000 1103500000 -11300000 -76400000 638400000 29000000 657500000
netCashUsedProvidedByFinancingActivities -9816000000 -9649000000 -8485000000 -20441000000 -13035000000 -8921000000 -10233000000 -9986000000 -14975000000 -15999000000 ... -1920000000 -848000000 -382000000 -519100000 61900000 -1567000000 -1228000000 -262600000 -499900000 138800000
effectOfForexChangesOnCash -59000000 -8000000.0 -32000000 -116000000 53000000 -215000000 -1000000000 -83000000 -63000000 -2000000.0 ... 1000000.0 -32000000 -1000000.0 -14700000 19000000 -26800000 -29400000 -12500000 13300000 -9000000.0
netChangeInCash 158000000 475000000 125000000 -206000000 -1253000000 -1046000000 298000000 1160000000 -7898000000 7207000000 ... -1920000000 -848000000 -382000000 -519100000 61900000 -1567000000 -1228000000 -262600000 -499900000 138800000
cashAtEndOfPeriod 1983000000 1825000000 1350000000 1225000000 1342000000 2595000000 3641000000 3343000000 2183000000 10389000000 ... 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
cashAtBeginningOfPeriod 1825000000 1350000000 1225000000 1431000000 2595000000 3641000000 3343000000 2183000000 10081000000 3182000000 ... 877000000 1150000000 403000000 1458500000 729400000 1257100000 1317600000 870300000 825400000 666600000
operatingCashFlow 32580000000 14403000000 12588000000 15827000000 16470000000 15901000000 14512000000 16883000000 17765000000 17054000000 ... 2929000000 1629000000 2067000000 1821400000 1488500000 1263000000 807000000 847600000 860500000 655800000
capitalExpenditure -2711000000 -2791000000 -2594000000 -2196000000 -2217000000 -1999000000 -1496000000 -1583000000 -1465000000 -1327000000 ... -1198000000 -943000000 -774000000 -696300000 -671500000 -634200000 -674200000 -593800000 -547500000 -456500000
freeCashFlow 29869000000 11612000000 9994000000 13631000000 14253000000 13902000000 13016000000 15300000000 16300000000 15727000000 ... 1731000000 686000000 1293000000 1125100000 817000000 628800000 132800000 253800000 313000000 199300000
link https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... ... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/...
finalLink https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/... ... https://www.sec.gov/Archives/edgar/data/78003/... https://www.sec.gov/Archives/edgar/data/78003/...

38 rows × 33 columns

Financial ratios#

company_ratios = fa.financial_ratios(ticker=my_ticker, api_key=my_api_key)
company_ratios
2021 2020 2019 2018 2017 2016 2015 2014 2013 2012 ... 2003 2002 2001 2000 1999 1998 1997 1996 1995 1994
period FY FY FY FY FY FY FY FY FY FY ... FY FY FY FY FY FY FY FY FY FY
currentRatio 1.398913 1.352894 0.879343 1.567142 1.352121 1.251776 1.489983 2.66756 2.407087 2.145952 ... 1.257175 1.335543 1.352639 1.434521 1.2184 1.38084 1.28558 1.146809 1.186073 1.199445
quickRatio 1.097092 0.903356 0.587015 0.948961 1.027476 0.935754 1.160856 2.070686 1.787426 1.896712 ... 0.892674 1.009701 1.022874 1.030966 0.9043 0.620968 0.641659 0.603191 0.46794 0.647237
cashRatio 0.045558 0.068827 0.034983 0.035752 0.044106 0.0834 0.123848 0.154547 0.093426 0.363011 ... 0.064252 0.101213 0.075953 0.091729 0.080457 0.215795 0.165316 0.203901 0.077749 0.302223
daysOfSalesOutstanding 70.69832 97.49475 85.117295 77.555781 78.291687 77.845108 80.978281 63.787622 66.208611 133.497949 ... 74.037134 69.723535 60.386404 67.74481 87.037768 78.529976 73.764795 72.70299 73.718243 73.385217
daysOfInventoryOutstanding 107.281886 337.872757 295.850377 243.636202 246.08274 200.81069 284.229374 215.82907 234.778844 227.456767 ... 216.690907 241.648949 198.741557 242.973639 303.98288 415.713396 365.205982 332.179267 282.216915 283.83653
operatingCycle 177.980205 435.367507 380.967671 321.191983 324.374427 278.655799 365.207655 279.616692 300.987455 360.954716 ... 290.728041 311.372484 259.127961 310.718448 391.020649 494.243372 438.970777 404.882256 355.935158 357.221747
daysOfPayablesOutstanding 66.057883 180.946272 150.729034 151.672297 151.19573 134.288263 136.950663 131.105774 123.138953 137.317805 ... 96.558686 146.18047 114.488478 154.578714 174.780967 220.819315 157.576185 190.86197 145.849115 117.784643
cashConversionCycle 111.922323 254.421235 230.238637 169.519686 173.178698 144.367535 228.256992 148.510918 177.848503 223.636911 ... 194.169355 165.192015 144.639483 156.139734 216.239682 273.424057 281.394592 214.020286 210.086044 239.437105
grossProfitMargin 0.620842 0.792593 0.802531 0.790333 0.786092 0.766602 0.802501 0.806935 0.814167 0.807853 ... 0.78242 0.87505 0.843951 0.862751 0.877438 0.881497 0.858285 0.845569 0.821372 0.803582
operatingProfitMargin 0.24893 0.209029 0.269005 0.280444 0.26847 0.25992 0.265624 0.27213 0.317269 0.305005 ... 0.239002 0.379267 0.340246 0.293163 0.280733 0.266022 0.267594 0.272422 0.255473 0.238187
pretaxProfitMargin 0.299072 0.178892 0.341681 0.221541 0.234176 0.158091 0.183517 0.246749 0.304668 0.204794 ... 0.072209 0.364378 0.32019 0.195002 0.274192 0.191376 0.246161 0.247479 0.228731 0.224228
netProfitMargin 0.270384 0.229455 0.314454 0.207896 0.405511 0.136586 0.142474 0.184155 0.426547 0.247008 ... 0.086527 0.281902 0.241421 0.125989 0.196186 0.247416 0.176983 0.170617 0.156954 0.156787
effectiveTaxRate 0.07618 0.063625 0.078272 0.059403 -0.735392 0.134475 0.221974 0.254902 0.273988 0.212086 ... 0.496782 0.221177 0.247943 0.355297 0.279991 0.247685 0.281027 0.310579 0.321961 0.30077
returnOnAssets 0.121112 0.062348 0.097159 0.069959 0.124032 0.042042 0.041562 0.053966 0.127849 0.078418 ... 0.033483 0.196868 0.198912 0.111191 0.154515 0.183095 0.144301 0.13152 0.123565 0.116989
returnOnEquity 0.284698 0.15206 0.257717 0.175895 0.298816 0.121171 0.10754 0.128119 0.288348 0.179301 ... 0.059807 0.457444 0.425737 0.231774 0.357714 0.380363 0.278961 0.277394 0.285639 0.300284
returnOnCapitalEmployed 0.14578 0.068272 0.106933 0.117941 0.099789 0.097722 0.093987 0.09143 0.110035 0.114462 ... 0.115982 0.441639 0.430212 0.402713 0.39942 0.324302 0.333566 0.341199 0.339455 0.314463
netIncomePerEBT 0.904076 1.282646 0.920314 0.93841 1.731654 0.863968 0.776352 0.746324 1.400038 1.206126 ... 1.198284 0.773652 0.753994 0.64609 0.715508 1.292824 0.718973 0.689421 0.686197 0.69923
ebtPerEbit 1.201433 0.855822 1.270167 0.789963 0.872262 0.60823 0.690891 0.906734 0.960284 0.671447 ... 0.30213 0.960743 0.941053 0.665167 0.976698 0.7194 0.919904 0.908442 0.895321 0.941394
ebitPerRevenue 0.24893 0.209029 0.269005 0.280444 0.26847 0.25992 0.265624 0.27213 0.317269 0.305005 ... 0.239002 0.379267 0.340246 0.293163 0.280733 0.266022 0.267594 0.272422 0.255473 0.238187
debtRatio 0.573156 0.588446 0.621191 0.600068 0.58291 0.651313 0.61186 0.576887 0.554796 0.560394 ... 0.440146 0.569635 0.532782 0.520263 0.568047 0.518632 0.48272 0.522465 0.563747 0.606911
debtEquityRatio 1.347314 1.43515 1.64772 1.508729 1.404345 1.877183 1.583158 1.369574 1.251274 1.281319 ... 0.786179 1.323609 1.140327 1.084474 1.315067 1.077412 0.93319 1.101956 1.303182 1.557807
longTermDebtToCapitalization 0.310447 0.359998 0.362823 0.33838 0.314175 0.345253 0.308089 0.306694 0.285308 0.276377 ... 0.080906 0.13599 0.124821 0.065294 0.05578 0.056442 0.124006 0.08991 0.131396 0.122603
totalDebtToCapitalization 0.323978 0.377039 0.452302 0.394232 0.374019 0.41411 0.37588 0.339702 0.323496 0.315532 ... 0.182276 0.371832 0.326646 0.251862 0.383404 0.269849 0.298647 0.295869 0.342503 0.395098
interestCoverage 15.673896 6.045549 8.844346 11.432371 11.107874 11.576728 10.822352 9.925735 11.574257 11.805118 ... None None None None None None None None None None
cashFlowToDebtRatio 0.880588 0.376313 0.241404 0.383545 0.386565 0.377822 0.372313 0.460253 0.486859 0.455259 ... 0.805531 0.862308 1.043836 1.144678 0.553022 0.89957 0.482238 0.707392 0.634966 0.527052
companyEquityMultiplier 2.350695 2.438882 2.652519 2.514265 2.409197 2.882154 2.587454 2.374076 2.255376 2.286463 ... 1.786179 2.323609 2.140327 2.084474 2.315067 2.077412 1.93319 2.109146 2.311644 2.56678
receivablesTurnover 5.162782 3.743791 4.2882 4.70629 4.662053 4.688798 4.507381 5.722113 5.512878 2.734124 ... 4.929959 5.234961 6.044407 5.387867 4.193582 4.647907 4.94816 5.020426 4.951285 4.973754
payablesTurnover 5.525457 2.017173 2.421564 2.406504 2.414089 2.718034 2.665193 2.784012 2.964131 2.658068 ... 3.780085 2.496914 3.188094 2.361257 2.088328 1.652935 2.31634 1.912377 2.502586 3.098876
inventoryTurnover 3.402252 1.080288 1.233732 1.498135 1.483241 1.817632 1.284174 1.691153 1.554655 1.604701 ... 1.684427 1.510456 1.836556 1.502221 1.200726 0.878009 0.999436 1.098804 1.293331 1.285951
fixedAssetTurnover 5.462169 3.014964 3.705162 4.007994 3.789831 3.966361 3.548671 4.217395 4.161007 4.078971 ... 2.471045 3.022125 3.09736 3.137825 3.032753 3.067724 3.02248 2.936623 2.885849 2.694683
assetTurnover 0.447927 0.271724 0.308977 0.336509 0.305865 0.307805 0.291717 0.293046 0.299731 0.317474 ... 0.386966 0.698356 0.823922 0.882543 0.787596 0.740028 0.815336 0.770846 0.78727 0.746164
operatingCashFlowPerShare 5.816818 2.592799 2.26037 2.695334 2.758794 2.61143 2.349741 2.660416 2.607515 2.291588 ... 1.627478 1.654159 1.484693 0.997585 0.809536 0.773027 0.431981 0.534938 0.482495 0.400288
freeCashFlowPerShare 5.332798 2.090369 1.794577 2.321356 2.387437 2.283134 2.107513 2.410968 2.392485 2.113276 ... 1.261334 1.368583 1.131592 0.644767 0.396026 0.456849 0.181915 0.334627 0.298043 0.219708
cashPerShare 5.547045 2.2 1.765128 3.207255 3.348744 2.931516 3.771049 5.69209 4.756788 4.395055 ... 1.657008 2.038824 1.38083 1.105153 1.176689 0.409607 0.232564 0.297619 0.106836 0.392221
payoutRatio 0.397152 0.877704 0.494254 0.715323 0.359442 1.014137 0.997126 0.723481 0.29905 0.448456 ... 1.113299 0.34714 0.348613 0.58964 0.36112 0.291256 0.398102 0.399689 0.418653 0.457948
operatingCashFlowSalesRatio 0.400797 0.343681 0.243246 0.295021 0.31344 0.301018 0.297067 0.340349 0.34439 0.289119 ... 0.259781 0.314552 0.287145 0.209475 0.188595 0.216258 0.130278 0.182823 0.181751 0.179742
freeCashFlowOperatingCashFlowRatio 0.916789 0.806221 0.793931 0.86125 0.865392 0.874285 0.896913 0.906237 0.917534 0.922188 ... 0.775023 0.827359 0.762172 0.646328 0.489202 0.590987 0.421117 0.625544 0.617712 0.548875
cashFlowCoverageRatios 0.880588 0.376313 0.241404 0.383545 0.386565 0.377822 0.372313 0.460253 0.486859 0.455259 ... 0.805531 0.862308 1.043836 1.144678 0.553022 0.89957 0.482238 0.707392 0.634966 0.527052
shortTermCoverageRatios 14.538153 5.328524 0.777517 1.791195 1.656942 1.487743 1.428346 3.283991 2.947569 2.654732 ... 1.331254 1.174645 1.478532 1.444393 0.611078 1.073287 0.722395 0.924832 0.894817 0.670495
capitalExpenditureCoverageRatio -12.017706 -5.160516 -4.852737 -7.207195 -7.428958 -7.954477 -9.700535 -10.665193 -12.12628 -12.851545 ... -4.444907 -5.792378 -4.204721 -2.827476 -1.957719 -2.444908 -1.727466 -2.670543 -2.615827 -2.216679
dividendPaidAndCapexCoverageRatio 5.413759 2.549655 2.310149 2.737288 3.026461 2.990034 2.665687 3.359133 3.473118 3.275206 ... 6.856893 7.221986 18.091797 1032.5 -7.399516 -13.193694 -26.274194 -689.0 -48.185185 -19.356307
dividendPayoutRatio 0.397152 0.877704 0.494254 0.715323 0.359442 1.014137 0.997126 0.723481 0.29905 0.448456 ... 1.113299 0.34714 0.348613 0.58964 0.36112 0.291256 0.398102 0.399689 0.418653 0.457948
priceBookValueRatio 3.941689 3.153555 3.101944 3.653362 3.002529 3.037739 2.760486 2.638845 2.610755 2.390357 ... 3.83431 8.697967 13.347914 16.228584 14.181088 17.49493 12.289804 7.973651 7.303579 5.439616
priceToBookRatio 3.941689 3.153555 3.101944 3.653362 3.002529 3.037739 2.760486 2.638845 2.610755 2.390357 ... 3.83431 8.697967 13.347914 16.228584 14.181088 17.49493 12.289804 7.973651 7.303579 5.439616
priceToSalesRatio 3.743509 4.758626 3.784851 4.318018 4.074608 3.424184 3.657216 3.79301 3.862028 3.292992 ... 5.547396 5.36016 7.569156 8.821624 7.777545 11.379972 7.797106 4.904366 4.013201 2.840177
priceEarningsRatio 13.84514 20.738822 12.03626 20.770082 10.048074 25.06987 25.66935 20.596856 9.054168 13.331533 ... 64.111436 19.014294 31.352516 70.018978 39.643703 45.995325 44.055588 28.744824 25.56926 18.114876
priceToFreeCashFlowsRatio 10.187898 17.174002 19.598364 16.994258 15.021705 13.011014 13.726082 12.297534 12.222015 12.350762 ... 27.552838 20.596373 34.585466 65.157521 84.299219 89.04121 142.121016 42.88381 35.746057 28.788684
priceToOperatingCashFlowsRatio 9.340158 13.84604 15.559744 14.6363 12.999657 11.375329 12.3111 11.144481 11.21412 11.389729 ... 21.354095 17.040602 26.360077 42.113109 41.23931 52.62217 59.849612 26.825721 22.080756 15.801381
priceCashFlowRatio 9.340158 13.84604 15.559744 14.6363 12.999657 11.375329 12.3111 11.144481 11.21412 11.389729 ... 21.354095 17.040602 26.360077 42.113109 41.23931 52.62217 59.849612 26.825721 22.080756 15.801381
priceEarningsToGrowthRatio 0.10937 -0.508885 0.224205 -0.444007 0.04961 5.665791 -1.192383 -0.371664 0.139734 0.250946 ... -1.009414 1.033386 0.289408 -2.450664 -8.081276 0.909573 2.48538 1.466586 1.322658 0.17188
priceSalesRatio 3.743509 4.758626 3.784851 4.318018 4.074608 3.424184 3.657216 3.79301 3.862028 3.292992 ... 5.547396 5.36016 7.569156 8.821624 7.777545 11.379972 7.797106 4.904366 4.013201 2.840177
dividendYield 0.028685 0.042322 0.041064 0.03444 0.035772 0.040452 0.038845 0.035126 0.033029 0.033639 ... 0.017365 0.018257 0.011119 0.008421 0.009109 0.006332 0.009036 0.013905 0.016373 0.02528
enterpriseValueMultiple 11.195076 14.456432 9.774021 13.895124 12.898695 14.421184 13.981163 11.564916 6.841615 8.425455 ... 27.446011 14.365002 22.073346 39.330226 26.347297 34.768928 27.931848 17.726384 15.897459 11.580834
priceFairValue 3.941689 3.153555 3.101944 3.653362 3.002529 3.037739 2.760486 2.638845 2.610755 2.390357 ... 3.83431 8.697967 13.347914 16.228584 14.181088 17.49493 12.289804 7.973651 7.303579 5.439616

55 rows × 28 columns

Key metrics#

key_metrics = fa.key_metrics(ticker=my_ticker, api_key=my_api_key)
key_metrics
2021 2020 2019 2018 2017 2016 2015 2014 2013 2012 ... 2003 2002 2001 2000 1999 1998 1997 1996 1995 1994
period FY FY FY FY FY FY FY FY FY FY ... FY FY FY FY FY FY FY FY FY FY
revenuePerShare 14.513123 7.544194 9.292512 9.136069 8.801675 8.675316 7.909812 7.816735 7.571408 7.926095 ... 6.2648 5.258772 5.17054 4.762319 4.29245 3.574558 3.315831 2.925983 2.654704 2.227013
netIncomePerShare 3.924121 1.731053 2.922069 1.899353 3.569179 1.184924 1.126943 1.439489 3.229561 1.957807 ... 0.542077 1.482456 1.248277 0.6 0.842119 0.884402 0.586847 0.499224 0.416667 0.349167
operatingCashFlowPerShare 5.816818 2.592799 2.26037 2.695334 2.758794 2.61143 2.349741 2.660416 2.607515 2.291588 ... 1.627478 1.654159 1.484693 0.997585 0.809536 0.773027 0.431981 0.534938 0.482495 0.400288
freeCashFlowPerShare 5.332798 2.090369 1.794577 2.321356 2.387437 2.283134 2.107513 2.410968 2.392485 2.113276 ... 1.261334 1.368583 1.131592 0.644767 0.396026 0.456849 0.181915 0.334627 0.298043 0.219708
cashPerShare 5.547045 2.2 1.765128 3.207255 3.348744 2.931516 3.771049 5.69209 4.756788 4.395055 ... 1.657008 2.038824 1.38083 1.105153 1.176689 0.409607 0.232564 0.297619 0.106836 0.392221
bookValuePerShare 13.783432 11.383978 11.338301 10.798195 11.944389 9.778946 10.479275 11.235581 11.200205 10.919108 ... 9.063774 3.240741 2.93204 2.588728 2.354172 2.325152 2.103686 1.799689 1.458717 1.162786
tangibleBookValuePerShare 0.554901 -2.623762 -5.490393 -4.234332 -5.534003 -7.761045 -3.821567 -0.884652 -0.775576 -1.210293 ... 0.93179 3.045809 2.656035 2.300322 2.152053 2.110583 1.760541 1.444099 1.141787 1.085633
shareholdersEquityPerShare 13.783432 11.383978 11.338301 10.798195 11.944389 9.778946 10.479275 11.235581 11.200205 10.919108 ... 9.063774 3.240741 2.93204 2.588728 2.354172 2.325152 2.103686 1.799689 1.458717 1.162786
interestDebtPerShare 6.836101 7.150855 9.646076 7.251533 7.349414 7.106586 6.505343 5.994642 5.563335 5.238377 ... 2.02038 1.918291 1.422343 0.871498 1.463841 0.85933 0.895784 0.756211 0.759876 0.759486
marketCap 304302340081.799988 199424508332.5 195866053771.600006 231648724718.399994 214104358302 180879110017.899994 178658677049.599976 188152276679.799988 199218849881.399994 194240433009.600006 ... 250675715913.799988 173524445845.200012 244173393392.599976 260890712649 126027331967.500015 154130334836.399994 97495017304.5 55448766307.200005 40217888550.671997 23520355109.368309
enterpriseValue 339356340081.799988 235914508332.5 246706053771.600006 271774724718.399994 255368358302 220370110017.899994 213995677049.599976 221491276679.799988 233524849881.399994 221311433009.600006 ... 263728715913.799988 183455445845.200012 252011393392.599976 265203712649 130814331967.500015 155834334836.399994 99996017304.5 57220766307.200005 42683088550.671997 24886055109.368309
peRatio 13.84514 20.738822 12.03626 20.770082 10.048074 25.06987 25.66935 20.596856 9.054168 13.331533 ... 64.111436 19.014294 31.352516 70.018978 39.643703 45.995325 44.055588 28.744824 25.56926 18.114876
priceToSalesRatio 3.743509 4.758626 3.784851 4.318018 4.074608 3.424184 3.657216 3.79301 3.862028 3.292992 ... 5.547396 5.36016 7.569156 8.821624 7.777545 11.379972 7.797106 4.904366 4.013201 2.840177
pocfratio 9.340158 13.84604 15.559744 14.6363 12.999657 11.375329 12.3111 11.144481 11.21412 11.389729 ... 21.354095 17.040602 26.360077 42.113109 41.23931 52.62217 59.849612 26.825721 22.080756 15.801381
pfcfRatio 10.187898 17.174002 19.598364 16.994258 15.021705 13.011014 13.726082 12.297534 12.222015 12.350762 ... 27.552838 20.596373 34.585466 65.157521 84.299219 89.04121 142.121016 42.88381 35.746057 28.788684
pbRatio 3.941689 3.153555 3.101944 3.653362 3.002529 3.037739 2.760486 2.638845 2.610755 2.390357 ... 3.83431 8.697967 13.347914 16.228584 14.181088 17.49493 12.289804 7.973651 7.303579 5.439616
ptbRatio 3.941689 3.153555 3.101944 3.653362 3.002529 3.037739 2.760486 2.638845 2.610755 2.390357 ... 3.83431 8.697967 13.347914 16.228584 14.181088 17.49493 12.289804 7.973651 7.303579 5.439616
evToSales 4.174741 5.629343 4.767267 5.065982 4.859901 4.17178 4.380579 4.4651 4.527079 3.751932 ... 5.836256 5.666928 7.812127 8.967462 8.072965 11.505784 7.997122 5.061097 4.259194 3.00509
enterpriseValueOverEBITDA 11.195076 14.456432 9.774021 13.895124 12.898695 14.421184 13.981163 11.564916 6.841615 8.425455 ... 27.446011 14.365002 22.073346 39.330226 26.347297 34.768928 27.931848 17.726384 15.897459 11.580834
evToOperatingCashFlow 10.416094 16.37954 19.598511 17.171588 15.505061 13.858884 14.746119 13.11919 13.145221 12.977098 ... 22.466029 18.015854 27.206239 42.809316 42.805737 53.203938 61.384909 27.683003 23.43422 16.718881
evToFreeCashFlow 11.36149 20.316441 24.685417 19.937989 17.916815 15.851684 16.440971 14.476554 14.326678 14.072069 ... 28.987548 21.775127 35.695665 66.234693 87.501225 90.025612 145.766789 44.254266 37.937151 30.460288
earningsYield 0.072228 0.048219 0.083082 0.048146 0.099522 0.039889 0.038957 0.048551 0.110446 0.07501 ... 0.015598 0.052592 0.031895 0.014282 0.025225 0.021741 0.022699 0.034789 0.039109 0.055203
freeCashFlowYield 0.098156 0.058228 0.051025 0.058843 0.06657 0.076858 0.072854 0.081317 0.08182 0.080967 ... 0.036294 0.048552 0.028914 0.015347 0.011863 0.011231 0.007036 0.023319 0.027975 0.034736
debtToEquity 0.450214 0.562494 0.569422 0.511442 0.458097 0.527308 0.445272 0.442364 0.399203 0.381935 ... 0.088028 0.157393 0.142623 0.069856 0.059075 0.059818 0.141561 0.098792 0.151273 0.139735
debtToAssets 0.573156 0.588446 0.621191 0.600068 0.58291 0.651313 0.61186 0.576887 0.554796 0.560394 ... 0.440146 0.569635 0.532782 0.520263 0.568047 0.518632 0.48272 0.522465 0.563747 0.606911
netDebtToEBITDA 1.156402 2.236044 2.014183 2.051536 2.084251 2.58432 2.308702 1.740758 1.005068 1.030609 ... 1.358414 0.777621 0.68652 0.639626 0.964149 0.380187 0.698603 0.548947 0.918172 0.635534
currentRatio 1.398913 1.352894 0.879343 1.567142 1.352121 1.251776 1.489983 2.66756 2.407087 2.145952 ... 1.257175 1.335543 1.352639 1.434521 1.2184 1.38084 1.28558 1.146809 1.186073 1.199445
interestCoverage 15.673896 6.045549 8.844346 11.432371 11.107874 11.576728 10.822352 9.925735 11.574257 11.805118 ... None None None None None None None None None None
incomeQuality 1.482324 1.497816 0.773551 1.41908 0.772949 2.203881 2.085057 1.848166 0.80739 1.170487 ... 3.002302 1.115823 1.189394 1.662641 0.961309 0.874067 0.736105 1.07154 1.157988 1.146411
dividendYield 0.028685 0.042322 0.041064 0.03444 0.035772 0.040452 0.038845 0.035126 0.033029 0.033639 ... 0.017365 0.018257 0.011119 0.008421 0.009109 0.006332 0.009036 0.013905 0.016373 0.02528
payoutRatio 0.397152 0.877704 0.494254 0.715323 0.359442 1.014137 0.997126 0.723481 0.29905 0.448456 ... 1.113299 0.34714 0.348613 0.58964 0.36112 0.291256 0.398102 0.399689 0.418653 0.457948
salesGeneralAndAdministrativeToRevenue 0 0 0 0 0 0 0 0 0 0 ... 0 0 0.350259 0.386894 0.39194 0.411105 0.396353 0.535114 0.528579 0.530134
researchAndDdevelopementToRevenue 0.170124 0.22442 0.16715 0.149235 0.14572 0.149023 0.157417 0.169197 0.129459 0.133421 ... 0.157807 0.159886 0.150253 0.149963 0.171316 0.168266 0.154191 0 0 0
intangiblesToTotalAssets 0.409718 0.506056 0.561366 0.555896 0.609401 0.624054 0.529082 0.456278 0.475907 0.488084 ... 0.502299 0.025887 0.043981 0.053447 0.037086 0.044421 0.084377 0.097089 0.097649 0.029346
capexToOperatingCashFlow -0.083211 -0.193779 -0.206069 -0.13875 -0.134608 -0.125715 -0.103087 -0.093763 -0.082466 -0.077812 ... -0.224977 -0.172641 -0.237828 -0.353672 -0.510798 -0.409013 -0.578883 -0.374456 -0.382288 -0.451125
capexToRevenue -0.033351 -0.066598 -0.050126 -0.040934 -0.042192 -0.037843 -0.030624 -0.031912 -0.0284 -0.022497 ... -0.058445 -0.054305 -0.068291 -0.074085 -0.096334 -0.088452 -0.075416 -0.068459 -0.069481 -0.081086
capexToDepreciation -0.52225 -0.584258 -0.431614 -0.343985 -0.353645 -0.347229 -0.290091 -0.285895 -0.228549 -0.174353 ... -0.647621 -1.696911 -2.062734 -2.26343 -2.880074 -2.449898 -1.878486 -1.8 -1.861765 -2.299658
stockBasedCompensationToRevenue 0.014541 0.01804 0.013874 0.01769 0.015986 0.013081 0.013695 0.011813 0.010139 0.008154 ... 0 0 0 0 0 0 0 0 0 0
grahamNumber 34.885192 21.056854 27.303006 21.48175 30.971155 16.146651 16.30076 19.076262 28.528308 21.931573 ... 10.514199 10.396911 9.074688 5.911669 6.67878 6.802081 5.270407 4.496117 3.698037 3.022439
roic 0.14578 0.068272 0.106933 0.117941 0.099789 0.097722 0.093987 0.09143 0.110035 0.114462 ... 0.115982 0.441639 0.430212 0.402713 0.39942 0.324302 0.333566 0.341199 0.339455 0.314463
returnOnTangibleAssets 0.205177 0.126226 0.221504 0.157528 0.317542 0.111829 0.088258 0.099252 0.243944 0.153186 ... 0.067276 0.202099 0.208063 0.117469 0.160466 0.191606 0.157599 0.145662 0.136937 0.120526
grahamNetNet -10.106543 -11.90216 -14.548303 -10.989058 -11.374665 -13.480703 -10.894916 -8.225142 -7.775172 -6.947057 ... -4.111049 -1.279727 -1.101418 -0.821779 -0.93245 -1.277514 -0.992906 -1.042831 -1.208688 -0.913282
workingCapital 17022000000 9147000000 -4501000000 18068000000 10714000000 7834000000 14405000000 36071000000 32878000000 32796000000 ... 6084000000 6226000000 4810000000 5206000000 2006000000 2739000000 1515000000 828000000 965200000 962500000
tangibleAssetValue 3108000000 -14575000000 -30576000000 -24864000000 -33038000000 -47257000000 -23602000000 -5614000000 -5284000000 -9007000000 ... 6721000000 18750000000 16571000000 14285000000 8124000000 7997000000 6639000000 5580000000 4310200000 4037000000
netCurrentAssetValue -44321000000 -55689000000 -71239000000 -45738000000 -59000000000 -72826000000 -58658000000 -39950000000 -39237000000 -42705000000 ... -21657000000 -1625000000 -2410000000 -247000000 -496000000 439000000 -583000000 -1195000000 -1023700000 -947400000
investedCapital 0.479242 0.605237 0.825824 0.650796 0.597493 0.706805 0.602256 0.514467 0.478187 0.460989 ... 0.222907 0.59193 0.485104 0.336651 0.621807 0.36958 0.425816 0.42019 0.52092 0.65316
averageReceivables 13469500000 11194000000 11631000000 11296500000 11232500000 11230000000 11016000000 9931500000 10275500000 16384000000 ... 10180000000 8689000000 8265500000 8341500000 7529000000 7054000000 6860500000 6723000000 6609000000 6429500000
averagePayables 4943500000 4309000000 4264500000 4491500000 4482500000 4422500000 3964500000 3874500000 3771500000 4286500000 ... 3455000000 2964500000 2944000000 3014000000 2630000000 2640000000 2537000000 2611000000 2512150000 2416950000
averageInventory 8552500000 8046000000 8164500000 7777000000 7812000000 7414500000 7779500000 6854500000 7106000000 7554500000 ... 6941500000 5362000000 5393500000 5374000000 4850000000 4937000000 4909500000 4817500000 4715050000 4655450000
daysSalesOutstanding 70.69832 97.49475 85.117295 77.555781 78.291687 77.845108 80.978281 63.787622 66.208611 133.497949 ... 74.037134 69.723535 60.386404 67.74481 87.037768 78.529976 73.764795 72.70299 73.718243 73.385217
daysPayablesOutstanding 66.057883 180.946272 150.729034 151.672297 151.19573 134.288263 136.950663 131.105774 123.138953 137.317805 ... 96.558686 146.18047 114.488478 154.578714 174.780967 220.819315 157.576185 190.86197 145.849115 117.784643
daysOfInventoryOnHand 107.281886 337.872757 295.850377 243.636202 246.08274 200.81069 284.229374 215.82907 234.778844 227.456767 ... 216.690907 241.648949 198.741557 242.973639 303.98288 415.713396 365.205982 332.179267 282.216915 283.83653
receivablesTurnover 5.162782 3.743791 4.2882 4.70629 4.662053 4.688798 4.507381 5.722113 5.512878 2.734124 ... 4.929959 5.234961 6.044407 5.387867 4.193582 4.647907 4.94816 5.020426 4.951285 4.973754
payablesTurnover 5.525457 2.017173 2.421564 2.406504 2.414089 2.718034 2.665193 2.784012 2.964131 2.658068 ... 3.780085 2.496914 3.188094 2.361257 2.088328 1.652935 2.31634 1.912377 2.502586 3.098876
inventoryTurnover 3.402252 1.080288 1.233732 1.498135 1.483241 1.817632 1.284174 1.691153 1.554655 1.604701 ... 1.684427 1.510456 1.836556 1.502221 1.200726 0.878009 0.999436 1.098804 1.293331 1.285951
roe 0.284698 0.15206 0.257717 0.175895 0.298816 0.121171 0.10754 0.128119 0.288348 0.179301 ... 0.059807 0.457444 0.425737 0.231774 0.357714 0.380363 0.278961 0.277394 0.285639 0.300284
capexPerShare -0.484021 -0.50243 -0.465793 -0.373978 -0.371357 -0.328297 -0.242228 -0.249448 -0.21503 -0.178312 ... -0.366144 -0.285575 -0.353101 -0.352818 -0.41351 -0.316178 -0.250066 -0.200311 -0.184452 -0.18058

58 rows × 28 columns

Analyst recommendations#

analyst_data = fa.rating(ticker=my_ticker, api_key=my_api_key)
analyst_data
rating ratingScore ratingRecommendation ratingDetailsDCFScore ratingDetailsDCFRecommendation ratingDetailsROEScore ratingDetailsROERecommendation ratingDetailsROAScore ratingDetailsROARecommendation ratingDetailsDEScore ratingDetailsDERecommendation ratingDetailsPEScore ratingDetailsPERecommendation ratingDetailsPBScore ratingDetailsPBRecommendation
date
2022-11-23 A+ 4 Buy 5 Strong Buy 3 Neutral 3 Neutral 4 Buy 4 Buy 5 Strong Buy
2022-11-22 A+ 4 Buy 5 Strong Buy 3 Neutral 3 Neutral 4 Buy 4 Buy 5 Strong Buy
2022-11-21 A+ 4 Buy 5 Strong Buy 3 Neutral 3 Neutral 4 Buy 4 Buy 5 Strong Buy
2022-11-18 A+ 4 Buy 5 Strong Buy 3 Neutral 3 Neutral 4 Buy 4 Buy 5 Strong Buy
2022-11-17 A+ 4 Buy 5 Strong Buy 3 Neutral 3 Neutral 4 Buy 4 Buy 5 Strong Buy

Dividend history#

dividends = fa.stock_dividend(ticker=my_ticker, api_key=my_api_key)
dividends
label adjDividend dividend recordDate paymentDate declarationDate
2022-11-03 November 03, 22 0.4 0.4 2022-11-04 2022-12-05 2022-09-22
2022-07-28 July 28, 22 0.4 0.4 2022-07-29 2022-09-06 2022-06-23
2022-05-12 May 12, 22 0.4 0.4 2022-05-13 2022-06-10 2022-04-28
2022-01-27 January 27, 22 0.4 0.4 2022-01-28 2022-03-04 2021-12-10
2021-11-04 November 04, 21 0.39 0.39 2021-11-05 2021-12-06 2021-09-23
... ... ... ... ... ... ...
1973-08-28 August 28, 73 0.00316 0.00316
1973-05-30 May 30, 73 0.00316 0.00316
1973-02-28 February 28, 73 0.00316 0.00316
1972-11-28 November 28, 72 0.00416 0.00416
1972-08-29 August 29, 72 0.00316 0.00316

203 rows × 6 columns

Slowing down requests#

If you are making many quick requests, you may run into an error with fundamentalanalysis. Fortunately, the solution is an easy one. Simply add a one second delay between requests.

# this is the package we need to add a delay
import time

# this is how we add a one second delay to our code
time.sleep(1)

For example, if you are looping over a list of companies and collecting the latest stock price for each company, you could do the following:

list_of_companies = ['CSCO', 'TXN', 'QCOM']

list_of_prices = []

# loop over the list of companies
for company in list_of_companies:

	# get the profile data using fundamentalanalysis
	stock_profile = fa.profile(ticker=company, api_key=my_api_key)

	# get the latest stock price from the table
	stock_price = stock_profile.at['price', 0]

	# append the stock price to the list
	list_of_prices.append(stock_price)

	# add a one second delay before the next request
	time.sleep(1)

list_of_prices
[48.4, 177.07, 123.45]

Example#

In this example, we

  • loop over a list of companies

  • get the name, market cap, dividend, number of employees, current assets, current liabilities, operating cycle, and free cash flow per share

  • put this information into a list of dictionaries

  • put everything into a table

peer_list = ["MSFT", "NVDA", "INTC", "CSCO", "TXN", "QCOM", "AAPL"]

# empty list to store the results
results = []

for peer in peer_list:
    # create an empty dictionary to hold the data for the company
    obs_dict = {}
    
    # add ticker to the dictionary
    obs_dict['ticker'] = peer

    # get the profile data
    profile_data = fa.profile(peer, my_api_key)

    # add pieces of profile data to dictionary
    obs_dict['name'] = profile_data.loc['companyName', 0]
    obs_dict['mcap'] = profile_data.loc['mktCap', 0]
    obs_dict['div'] = profile_data.loc['lastDiv', 0]
    obs_dict['employs'] = profile_data.loc['fullTimeEmployees', 0]

    # get the balance sheet data
    bs_data = fa.balance_sheet_statement(peer, my_api_key)

    # add pieces of balance sheet data to dictionary
    obs_dict['assets_c'] = bs_data.loc['totalCurrentAssets', '2021']
    obs_dict['liab_c'] = bs_data.loc['totalCurrentLiabilities', '2021']

    # get the ratios data
    ratios_data = fa.financial_ratios(peer, my_api_key)

    # add pieces of ratios data to dictionary
    obs_dict['oper_cycle'] = ratios_data.loc['operatingCycle', '2021']
    obs_dict['fcf_per_share'] = ratios_data.loc['freeCashFlowPerShare', '2021']

    # append the dictionary to our list of results
    results.append(obs_dict)
    
final_data = pd.DataFrame(results)
final_data.set_index('ticker', inplace=True)
final_data
name mcap div employs assets_c liab_c oper_cycle fcf_per_share
ticker
MSFT Microsoft Corporation 1844906815939 2.54 221000 184406000000 88657000000 101.030183 7.435802
NVDA NVIDIA Corporation 405448400000 0.16 22473 16055000000 3925000000 159.314399 1.901945
INTC Intel Corporation 121086181878 1.46 121100 57718000000 27462000000 155.391674 2.380389
CSCO Cisco Systems, Inc. 198728944128 1.51 83300 39112000000 26257000000 106.083483 3.496447
TXN Texas Instruments Incorporated 160703768374 4.69 31000 13685000000 2569000000 150.660350 6.833876
QCOM QUALCOMM Incorporated 138387442099 2.93 51000 20075000000 11951000000 121.530936 7.646331
AAPL Apple Inc. 2356148705219 0.91 164000 134836000000 125481000000 62.667561 5.565624