diff options
| author | Danglewood <85772166+deeleeramone@users.noreply.github.com> | 2023-05-04 10:32:27 -0700 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-05-04 17:32:27 +0000 |
| commit | 72c4ce01f32c5460d83783b8e988ee2b70bf1a52 (patch) | |
| tree | d784213910c91da6a7f9d519f5f2ec3152413410 | |
| parent | b9a4faa0d7b92d46813980e4325ff21855f82608 (diff) | |
Updates SDK Intro Guide for Fundamental Analysis Module's Recent Changes (#4964)
* Updates SDK intro guide for fundamental analysis for recent changes
* previous commit was missing this
* fixes
---------
Co-authored-by: James Maslek <jmaslek11@gmail.com>
| -rw-r--r-- | website/content/sdk/usage/intros/stocks/fundamental-analysis.md | 656 |
1 files changed, 249 insertions, 407 deletions
diff --git a/website/content/sdk/usage/intros/stocks/fundamental-analysis.md b/website/content/sdk/usage/intros/stocks/fundamental-analysis.md index 957dbbacdc2..185b544ab8a 100644 --- a/website/content/sdk/usage/intros/stocks/fundamental-analysis.md +++ b/website/content/sdk/usage/intros/stocks/fundamental-analysis.md @@ -3,10 +3,9 @@ title: Fundamental Analysis keywords: [fundamentals, fundamental, fa, ratios, earnings, balance, income, cash, statement, statements, sec, multiples, price, ebitda, ebitdam, revenue, quarter, annual, change, company, performance, filing, filings, 10K, 8K, audit, audited, due diligence, research, company, ticker, analyst, rating, rot, pt, est, sec, supplier, customer, arktrades, ratings, analysts, filings, form, forms, customers, suppliers, alphavantage, EODHD, financial modeling prep, polygon, how to, usage, examples, sdk] description: This guide introduces the Fundamental Analysis menu within the Stocks menu, briefly explains the features, and provides examples in context. --- - import HeadTitle from '@site/src/components/General/HeadTitle.tsx'; -<HeadTitle title="Fundamental Analysis - SDK | OpenBB Docs" /> +`<HeadTitle title="Fundamental Analysis - SDK | OpenBB Docs" />` The FA module provides programmatic access to the commands from within the OpenBB Terminal. To get the most out of these functions, we recommend obtaining API keys from: @@ -15,62 +14,109 @@ The FA module provides programmatic access to the commands from within the OpenB - Financial Modeling Prep - Polygon -View [this page](https://docs.openbb.co/terminal/usage/guides/api-keys) for a list of all API sources used across the platform. - -## How to Use - -The contextual help will be activated upon entering ., after, openbb.stocks.fa. A brief description below highlights the functions within the `fa` module. - -| Path | Description | -| :---------------------------------|----------------------------------------------: | -| openbb.stocks.fa.analysis | Analysis SEC Fillings with Machine Learning | -| openbb.stocks.fa.balance | Company Balance Sheet | -| openbb.stocks.fa.cal | Calendar Earnings and Estimates | -| openbb.stocks.fa.cash | Company Cash Flows | -| openbb.stocks.fa.data | Fundamental and Technical Data | -| openbb.stocks.fa.dcfc | Shows DCF Values for a Ticker | -| openbb.stocks.fa.divs | Historical Dividends for a Company | -| openbb.stocks.fa.dupont | Detailed ROE Breakdown | -| openbb.stocks.fa.earnings | Earnings Data and EPS | -| openbb.stocks.fa.enterprise | Company Enterprise Value | -| openbb.stocks.fa.fama_coe | Fama/French value for Cost of Equity | -| openbb.stocks.fa.fraud | Key Fraud Ratios | -| openbb.stocks.fa.growth | Growth of Financial Statement Items | -| openbb.stocks.fa.hq | HQ Location for Company | -| openbb.stocks.fa.income | Company Income Statement | -| openbb.stocks.fa.info | Information About a Company | -| openbb.stocks.fa.key | Company Key Metrics | -| openbb.stocks.fa.metrics | Key Metrics Over Time | -| openbb.stocks.fa.mgmt | Company Management Team | -| openbb.stocks.fa.mktcap | Estimated Market Cap | -| openbb.stocks.fa.overview | Overview of the Company | -| openbb.stocks.fa.profile | Company Profile | -| openbb.stocks.fa.ratios | In-Depth Ratios over Time | -| openbb.stocks.fa.score | Investing Score from Warren Buffet | -| openbb.stocks.fa.shrs | Shareholders (Insiders, Institutions, Funds) | -| openbb.stocks.fa.splits | Stock Splits and Reverse Splits Since IPO | -| openbb.stocks.fa.sust | Sustainability Values | -|openbb.stocks.fa.analyst |Analyst Prices and Ratings | -|openbb.stocks.fa.arktrades |Ark Trades for the Ticker | -|openbb.stocks.fa.customer |List of Customers | -|openbb.stocks.fa.est |Earnings Estimates | -|openbb.stocks.fa.pt |Historical Price Targets | -|openbb.stocks.fa.rating |Daily Ratings | -|openbb.stocks.fa.rot |Historical Number of Analysts and Ratings | -|openbb.stocks.fa.sec |List of SEC Filings | -|openbb.stocks.fa.supplier |List of Suppliers | - -Alternatively the contents of the module can be printed with: +View [this page](https://docs.openbb.co/sdk/usage/guides/api-keys) for a list of all API sources used across the platform. + +## The FA Module + +A brief description below highlights the properties of the `fa` module. + +| Path | Description | +| :---------------------------- | -----------------------------------------------: | +| openbb.stocks.fa.analysis | Analysis of SEC disclosure statements | +| openbb.stocks.fa.balance | Company balance sheet | +| openbb.stocks.fa.cal | Calendar earnings and estimates | +| openbb.stocks.fa.cash | Company cash flows statements | +| openbb.stocks.fa.customer | Lists other public companies who are customers | +| openbb.stocks.fa.dcfc | Historical DCF Values for a ticker | +| openbb.stocks.fa.divs | Historical Dividends for a company | +| openbb.stocks.fa.divs_chart | A chart for `divs` | +| openbb.stocks.fa.dupont | DuPont ratios | +| openbb.stocks.fa.earnings | Earnings data and EPS | +| openbb.stocks.fa.enterprise | Company enterprise value | +| openbb.stocks.fa.epsfc | Forward EPS estimates | +| openbb.stocks.fa.fama_coe | Fama/French value for cost of equity | +| openbb.stocks.fa.fraud | Key fraud ratios | +| openbb.stocks.fa.growth | Growth of financial statement ratios | +| openbb.stocks.fa.income | Company income statements | +| openbb.stocks.fa.key | Company Key Metrics | +| openbb.stocks.fa.metrics | Key Metrics Over Time | +| openbb.stocks.fa.mgmt | Company Management Team | +| openbb.stocks.fa.mktcap | Estimated Market Cap | +| openbb.stocks.fa.mktcap_chart | Chart for `mktcap` | +| openbb.stocks.fa.overview | Overview of the company | +| openbb.stocks.fa.pt | Analyst price targets | +| openbb.stocks.fa.pt_chart | Chart for `pt` | +| openbb.stocks.fa.rating | Historical buy/sell/hold ratings based on ratios | +| openbb.stocks.fa.ratios | Historical financial statements ratios | +| openbb.stocks.fa.revfc | Forward revenue estimates | +| openbb.stocks.fa.score | Investing Score from Warren Buffet | +| openbb.stocks.fa.shrs | Major shareholders | +| openbb.stocks.fa.splits | Stock Splits and Reverse Splits Since IPO | +| openbb.stocks.fa.splits_chart | Chart for `splits` | +| openbb.stocks.fa.supplier | Lists other public companies who are suppliers | + +This can be printed to the screen with: ```python help(openbb.stocks.fa) ``` +Parameters for each function are displayed using the same syntax. + +```python +help(openbb.stocks.fa.balance) + +Signature: +openbb.stocks.fa.balance( + symbol: str, + quarterly: bool = False, + ratios: bool = False, + source: str = 'YahooFinance', + limit: int = 10, +) -> pandas.core.frame.DataFrame +Call signature: openbb.stocks.fa.balance(*args: Any, **kwargs: Any) -> Any +Type: get_balance_sheet +String form: <openbb_terminal.stocks.fundamental_analysis.sdk_helpers.Operation object at 0x1684e8f70> +File: ~/GitHub/OpenBBTerminal/openbb_terminal/stocks/fundamental_analysis/sdk_helpers.py +Docstring: +Get balance sheet. + +Parameters +---------- +symbol : str + Symbol to get balance sheet for +source : str, optional + Data source for balance sheet, by default "YahooFinance" + Sources: YahooFinance, AlphaVantage, FinancialModelingPrep, Polygon, EODHD +quarterly : bool, optional + Flag to get quarterly data +ratios : bool, optional + Flag to return data as a percent change. +limit : int + Number of statements to return (free tiers may be limited to 5 years) + +Returns +------- +pd.DataFrame + Dataframe of balance sheet + +Examples +-------- +>>> from openbb_terminal.sdk import openbb +>>> balance_sheet = openbb.stocks.fa.balance("AAPL", source="YahooFinance") + +If you have a premium AlphaVantage key, you can use the quarterly flag to get quarterly statements +>>> quarterly_income_statement = openbb.stocks.fa.balance("AAPL", source="AlphaVantage", quarterly=True) +``` + +This information is also displayed in the contextual help window, when using Jupyter Lab or VS Code. + ## Examples The examples provided below will assume that the following import block is included at the beginning of the Python script or Notebook file: ```python +import pandas as pd from openbb_terminal.sdk import openbb ``` @@ -82,86 +128,59 @@ The `openbb.stocks.fa.earnings` function returns upcoming earnings dates and est openbb.stocks.fa.earnings('COST', quarterly = True) ``` -| | Symbol | Company | Earnings Date | EPS Estimate | Reported EPS | Surprise(%) | -|---:|:---------|:-----------------------------|:-----------------------|---------------:|---------------:|--------------:| -| 0 | COST | Costco Wholesale Corp | Sep 20, 2023, 4 PMEDT | nan | nan | nan | -| 1 | COST | Costco Wholesale Corp | May 24, 2023, 4 PMEDT | nan | nan | nan | -| 2 | COST | Costco Wholesale Corp | Dec 08, 2022, 5 PMEST | 3.11 | nan | nan | -| 3 | COST | Costco Wholesale Corp | Dec 07, 2022, 4 PMEST | 3.11 | nan | nan | -| 4 | COST | Costco Wholesale Corporation | Sep 22, 2022, 12 PMEDT | 4.17 | 4.2 | 0.84 | -| 95 | COST | Costco Wholesale Corporation | Oct 06, 1999, 12 AMEDT | 0.38 | 0.4 | 3.64 | -| 96 | COST | Costco Wholesale Corporation | May 26, 1999, 12 AMEDT | 0.22 | 0.23 | 4.41 | -| 97 | COST | Costco Wholesale Corporation | Mar 04, 1999, 12 AMEST | 0.32 | 0.35 | 8.57 | -| 98 | COST | Costco Wholesale Corporation | Dec 17, 1998, 12 AMEST | 0.23 | 0.23 | 0.9 | -| 99 | COST | Costco Wholesale Corporation | Oct 08, 1998, 12 AMEDT | 0.32 | 0.33 | 1.87 | +| Earnings Date | EPS Estimate | Reported EPS | Surprise(%) | +| :------------ | :----------- | :----------- | :---------- | +| 2024-02-29 | - | - | - | +| 2023-12-06 | - | - | - | +| 2023-09-20 | - | - | - | +| 2023-05-25 | 3.21 | - | - | +| 2023-05-25 | - | - | - | +| 2023-03-02 | 3.21 | 3.3 | 0.0288 | +| 2022-12-08 | 3.11 | 3.1 | -0.00451 | +| 2022-09-22 | 4.17 | 4.2 | 0.0084 | +| 2022-05-26 | 3.03 | 3.17 | 0.0449 | +| 2022-03-03 | 2.74 | 2.92 | 0.0647 | +| 2021-12-09 | 2.64 | 2.98 | 0.12890 | ### Growth `openbb.stocks.fa.growth` provides annualized financial ratios as growth metrics. ```python -openbb.stocks.fa.growth('COST', limit = 20) +openbb.stocks.fa.growth('COST') ``` -| | 2022 | 2021 | 2020 | 2019 | 2018 | 2017 | 2016 | 2015 | 2014 | 2013 | 2012 | 2011 | 2010 | 2009 | 2008 | 2007 | 2006 | 2005 | 2004 | 2003 | -|:--------------------|:-------|:-------|:-------|:-------|:-------|:-------|:-------|:-------|:-------|:-------|:-------|:-------|:-------|:-------|:-------|:-------|:-------|:-------|:-------|:-------| -| Period | FY | FY | FY | FY | FY | FY | FY | FY | FY | FY | FY | FY | FY | FY | FY | FY | FY | FY | FY | FY | -| Revenue growth | 0.158 | 0.175 | 0.092 | 0.079 | 0.097 | 0.087 | 0.022 | 0.032 | 0.071 | 0.061 | 0.115 | 0.141 | 0.091 | -0.015 | 0.126 | 0.071 | 0.136 | 0.100 | 0.131 | 0.098 | -| Gross profit growth | 0.092 | 0.157 | 0.101 | 0.076 | 0.075 | 0.084 | 0.045 | 0.067 | 0.074 | 0.073 | 0.102 | 0.123 | 0.095 | 0.012 | 0.130 | 0.074 | 0.124 | 0.095 | 0.133 | 0.111 | -| Debt growth | -0.108 | -0.003 | 0.49 | 0.052 | -0.026 | 0.29 | -0.16 | 0.207 | 0.019 | 2.616 | -0.358 | -0.006 | -0.059 | -0.018 | 0.056 | 2.93 | -0.264 | -0.418 | -0.012 | 0.023 | +**Note**: This returns thirty-five ratios, the table below is truncated for illustrative purposes. + +| | 2018 | 2019 | 2020 | 2021 | 2022 | +| :---------------------- | :---- | :----- | :---- | :---- | :---- | +| Period | FY | FY | FY | FY | FY | +| Revenue growth | 0.097 | 0.079 | 0.092 | 0.175 | 0.158 | +| Gross profit growth | 0.075 | 0.076 | 0.101 | 0.157 | 0.092 | +| Ebitgrowth | 0.090 | -0.236 | 0.134 | 0.306 | 0.203 | +| Operating income growth | 0.090 | -0.236 | 0.134 | 0.306 | 0.203 | ### Analysis -The `openbb.stocks.fa.analysis` function scans 10K SEC filings with NLP to highlight risk factors and notable statements provided by the company. +The `openbb.stocks.fa.analysis` function scans 10K SEC filings with NLP to highlight risk factors and statements provided in the Discussion and Analysis sections. Summarizations by, [elclect.us](https://eclect.us/) ```python -openbb.stocks.fa.analysis('COST') +openbb.stocks.fa.analysis('COST').head(1) ``` -| | Group | Good | Sentence | -|---:|:------------------------|:-------|:-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| -| 0 | Risk factors | False | During 2022, our international operations, including Canada, generated 27% and 32% of our net sales and operating income, respectively. | -| 1 | Risk factors | False | Changes in tax rates, new U. S. or foreign tax legislation, and exposure to additional tax liabilities could adversely affect our financial condition and results of operations. | -| 8 | Risk factors | True | Declines in financial performance of our U. S. operations, particularly in California, and our Canadian operations could arise from, among other things: slow growth or declines in comparable warehouse sales (comparable sales); negative trends in operating expenses, including increased labor, healthcare and energy costs; failing to meet targets for warehouse openings; cannibalizing existing locations with new warehouses; shifts in sales mix toward lower gross margin products; changes or uncertainties in economic conditions in our markets, including higher levels of unemployment and depressed home values; and failing to consistently provide high quality and innovative new products. | -| 26 | Discussion and Analysis | True | Stock Repurchase ProgramsDuring 2022 and 2021, we repurchased 863,000 and 1,358, 000 shares of common stock, at average prices of $511.46 and $364.39, respectively, totaling approximately $442 and $495, respectively. | - -### Sust - -A company's ESG scores are fetched with: +| Group | Good | Sentence | +| :----------- | :---- | :-------------------------------------------------------------------------------------------------------------------------------------- | +| Risk factors | False | During 2022, our international operations, including Canada, generated 27% and 32% of our net sales and operating income, respectively. | ```python -openbb.stocks.fa.sust('COST') +df = openbb.stocks.fa.analysis('COST') +hp = df["Group"].str.contains('Discussion') +df[hp].head(1) ``` -| | Value | -|:-----------------------|:---------------| -| Palm oil | False | -| Controversial weapons | False | -| Gambling | False | -| Social score | 11.21 | -| Nuclear | False | -| Fur leather | False | -| Alcoholic | False | -| Gmo | False | -| Catholic | False | -| Social percentile | | -| Peer count | 33 | -| Governance score | 5.72 | -| Environment percentile | | -| Animal testing | False | -| Tobacco | False | -| Total esg | 24.19 | -| Highest controversy | 3 | -| Esg performance | AVG_PERF | -| Coal | False | -| Pesticides | False | -| Adult | False | -| Percentile | 40.87 | -| Peer group | Food Retailers | -| Small arms | False | -| Environment score | 7.26 | -| Governance percentile | | -| Military contract | False | +| Group | Good | Sentence | +| :---------------------- | :--- | :-------------------------------------------------------------------------------------------------------------------------------------------------------------------- | +| Discussion and Analysis | True | Cash Flows from Operating ActivitiesNet cash provided by operating activities totaled $5,802 in the first half of 2023, compared to $3,659 in the first half of 2022. | ### Key @@ -172,70 +191,40 @@ openbb.stocks.fa.key('COST') ``` | | | -|:-------------------------|:----------| -| Market capitalization | 238.674 B | -| EBITDA | 9.693 B | -| EPS | 13.14 | -| PE ratio | 41.04 | -| PEG ratio | 3.759 | -| Price to book ratio | 11.34 | -| Return on equity TTM | 0.305 | -| Price to sales ratio TTM | 1.052 | -| Dividend yield | 0.0068 | -| 50 day moving average | 493.34 | -| Analyst target price | 562.93 | -| Beta | 0.717 | +| :----------------------- | :-------- | +| Market capitalization | 219.440 B | +| EBITDA | 9.891 B | +| EPS | 13.62 | +| PE ratio | 36.33 | +| PEG ratio | 3.433 | +| Price to book ratio | 10.39 | +| Return on equity TTM | 0.284 | +| Price to sales ratio TTM | 0.891 | +| Dividend yield | 0.0083 | +| 50 day moving average | 491.41 | +| Analyst target price | 547.64 | +| Beta | 0.787 | ### SHRS -Ownership metrics for a company are listed with: - -```python -openbb.stocks.fa.shrs(symbol = 'COST', holder = 'major') -``` - -| | | | -|---:|:-------|:------------------------------------------| -| 0 | 0.22% | Percentage of Shares Held by All Insider | -| 1 | 69.05% | Percentage of Shares Held by Institutions | -| 2 | 69.21% | Percentage of Float Held by Institutions | -| 3 | 3444 | Number of Institutions Holding Shares | - -Accepted arguments for `holder` are `major`, `mutualfund`, and `institutional`. +The top 10 mutual funds holding the stock are retrieved with: ```python openbb.stocks.fa.shrs(symbol = 'COST', holder = 'mutualfund') ``` -| | Holder | Shares | Date Reported | Stake | Value | -|---:|:-----------------------------------------------------------|:---------|:--------------------|:--------|:--------| -| 0 | Vanguard Total Stock Market Index Fund | 13.051 M | 2022-06-29 00:00:00 | 2.95 % | 6.576 B | -| 1 | Vanguard 500 Index Fund | 10.041 M | 2022-09-29 00:00:00 | 2.27 % | 5.059 B | -| 2 | Invesco ETF Tr-Invesco QQQ Tr, Series 1 ETF | 6.504 M | 2022-09-29 00:00:00 | 1.47 % | 3.277 B | -| 3 | SPDR S&P 500 ETF Trust | 5.062 M | 2022-10-30 00:00:00 | 1.14 % | 2.551 B | -| 4 | Fidelity 500 Index Fund | 4.785 M | 2022-09-29 00:00:00 | 1.08 % | 2.411 B | -| 5 | iShares Core S&P 500 ETF | 3.938 M | 2022-09-29 00:00:00 | 0.89 % | 1.984 B | -| 6 | Vanguard Growth Index Fund | 3.648 M | 2022-09-29 00:00:00 | 0.82 % | 1.838 B | -| 7 | Vanguard Institutional Index Fund-Institutional Index Fund | 3.216 M | 2022-09-29 00:00:00 | 0.73 % | 1.621 B | -| 8 | Select Sector SPDR Fund-Consumer Staples | 3.131 M | 2022-10-30 00:00:00 | 0.71 % | 1.577 B | -| 9 | Vanguard Specialized-Dividend Appreciation Index Fund | 2.740 M | 2022-07-30 00:00:00 | 0.62 % | 1.380 B | - -```python -openbb.stocks.fa.shrs(symbol = 'COST', holder = 'institutional') -``` - -| | Holder | Shares | Date Reported | Stake | Value | -|---:|:------------------------------------|:---------|:--------------------|:--------|:---------| -| 0 | Vanguard Group, Inc. (The) | 39.030 M | 2022-09-29 00:00:00 | 8.82 % | 19.666 B | -| 1 | Blackrock Inc. | 30.060 M | 2022-09-29 00:00:00 | 6.79 % | 15.146 B | -| 2 | State Street Corporation | 18.802 M | 2022-09-29 00:00:00 | 4.25 % | 9.473 B | -| 3 | FMR, LLC | 10.346 M | 2022-09-29 00:00:00 | 2.34 % | 5.213 B | -| 4 | Geode Capital Management, LLC | 8.044 M | 2022-09-29 00:00:00 | 1.82 % | 4.053 B | -| 5 | Bank of America Corporation | 7.875 M | 2022-09-29 00:00:00 | 1.78 % | 3.968 B | -| 6 | Morgan Stanley | 7.319 M | 2022-09-29 00:00:00 | 1.65 % | 3.688 B | -| 7 | Northern Trust Corporation | 4.976 M | 2022-09-29 00:00:00 | 1.12 % | 2.507 B | -| 8 | AllianceBernstein, L.P. | 4.680 M | 2022-09-29 00:00:00 | 1.06 % | 2.358 B | -| 9 | Bank Of New York Mellon Corporation | 4.481 M | 2022-09-29 00:00:00 | 1.01 % | 2.258 B | +| Holder | Shares | Date Reported | Stake | Value | +| :--------------------------------------------------------- | :------- | :------------------ | :----- | :------ | +| Vanguard Total Stock Market Index Fund | 13.453 M | 2022-12-30 00:00:00 | 3.03 % | 6.591 B | +| Vanguard 500 Index Fund | 10.232 M | 2022-12-30 00:00:00 | 2.31 % | 5.012 B | +| Invesco ETF Tr-Invesco QQQ Tr, Series 1 ETF | 5.834 M | 2023-03-30 00:00:00 | 1.32 % | 2.858 B | +| Fidelity 500 Index Fund | 4.852 M | 2023-02-27 00:00:00 | 1.09 % | 2.377 B | +| SPDR S&P 500 ETF Trust | 4.804 M | 2023-03-30 00:00:00 | 1.08 % | 2.353 B | +| iShares Core S&P 500 ETF | 3.950 M | 2023-02-27 00:00:00 | 0.89 % | 1.935 B | +| Vanguard Growth Index Fund | 3.736 M | 2022-12-30 00:00:00 | 0.84 % | 1.830 B | +| Select Sector SPDR Fund-Consumer Staples | 3.241 M | 2023-02-27 00:00:00 | 0.73 % | 1.588 B | +| Vanguard Institutional Index Fund-Institutional Index Fund | 3.102 M | 2022-12-30 00:00:00 | 0.70 % | 1.519 B | +| Vanguard Specialized-Dividend Appreciation Index Fund | 2.804 M | 2023-01-30 00:00:00 | 0.63 % | 1.374 B | ### Balance @@ -245,285 +234,138 @@ Financial statement items can be displayed as their reported value or as a perce openbb.stocks.fa.balance(symbol = 'COST', ratios=True) ``` -| Breakdown | 2022-08-31 | 2021-08-31 | 2020-08-31 | -|:-------------------------------------------|-------------:|-------------:|-------------:| -| Cash and cash equivalents | -0.0937111 | -0.0830007 | 0.464337 | -| Other short-term investments | -0.0774264 | -0.107977 | -0.0301887 | -| Total cash | -0.0924846 | -0.0849305 | 0.408831 | -| Net receivables | 0.242928 | 0.163226 | 0.00977199 | -| Inventory | 0.259726 | 0.161166 | 0.0743308 | -| Other current assets | 0.14253 | 0.282502 | -0.0792079 | -| Total current assets | 0.108151 | 0.0492532 | 0.19736 | -| Gross property, plant and equipment | 0.0532209 | 0.0815396 | 0.149114 | -| Accumulated depreciation | 0.0790625 | 0.0984801 | 0.0988412 | -| Net property, plant and equipment | 0.039345 | 0.072657 | 0.177358 | -| Other long-term assets | 0.19787 | 0.190074 | 1.77171 | -| Total non-current assets | 0.0573531 | 0.0848156 | 0.251928 | -| Total assets | 0.0826416 | 0.0668155 | 0.2237 | -| Current debt | -0.908636 | 7.41053 | -0.944085 | -| Accounts payable | 0.0964492 | 0.148603 | 0.21346 | -| Accrued liabilities | 0.0921715 | 0.152661 | 0.147383 | -| Other current liabilities | 0.230213 | 0.223444 | -0.0168776 | -| Total current liabilities | 0.0868517 | 0.185035 | 0.0691569 | -| Long-term debt | -0.0310819 | -0.109396 | 0.466432 | -| Other long-term liabilities | 0.057971 | 0.248062 | 0.329897 | -| Total non-current liabilities | -0.0194059 | -0.0214875 | 0.825049 | -| Total liabilities | 0.0565429 | 0.117744 | 0.235947 | -| Common stock | -0.5 | 0 | 0 | -| Retained earnings | 0.335933 | -0.0941843 | 0.255508 | -| Accumulated other comprehensive income | 0.608619 | -0.123362 | -0.0967967 | -| Total stockholders' equity | 0.175245 | -0.0393787 | 0.199501 | -| Total liabilities and stockholders' equity | 0.0826416 | 0.0668155 | 0.2237 | - - -Cashflow and Income statements function in the same way as `balance` does. +| Breakdown | 2022-08-31 | 2021-08-31 | 2020-08-31 | +| :----------------------------------------- | ---------: | ---------: | ---------: | +| Cash and cash equivalents | -0.0937111 | -0.0830007 | 0.464337 | +| Other short-term investments | -0.0774264 | -0.107977 | -0.0301887 | +| Total cash | -0.0924846 | -0.0849305 | 0.408831 | +| Net receivables | 0.242928 | 0.163226 | 0.00977199 | +| Inventory | 0.259726 | 0.161166 | 0.0743308 | +| Other current assets | 0.14253 | 0.282502 | -0.0792079 | +| Total current assets | 0.108151 | 0.0492532 | 0.19736 | +| Gross property, plant and equipment | 0.0532209 | 0.0815396 | 0.149114 | +| Accumulated depreciation | 0.0790625 | 0.0984801 | 0.0988412 | +| Net property, plant and equipment | 0.039345 | 0.072657 | 0.177358 | +| Other long-term assets | 0.19787 | 0.190074 | 1.77171 | +| Total non-current assets | 0.0573531 | 0.0848156 | 0.251928 | +| Total assets | 0.0826416 | 0.0668155 | 0.2237 | +| Current debt | -0.908636 | 7.41053 | -0.944085 | +| Accounts payable | 0.0964492 | 0.148603 | 0.21346 | +| Accrued liabilities | 0.0921715 | 0.152661 | 0.147383 | +| Other current liabilities | 0.230213 | 0.223444 | -0.0168776 | +| Total current liabilities | 0.0868517 | 0.185035 | 0.0691569 | +| Long-term debt | -0.0310819 | -0.109396 | 0.466432 | +| Other long-term liabilities | 0.057971 | 0.248062 | 0.329897 | +| Total non-current liabilities | -0.0194059 | -0.0214875 | 0.825049 | +| Total liabilities | 0.0565429 | 0.117744 | 0.235947 | +| Common stock | -0.5 | 0 | 0 | +| Retained earnings | 0.335933 | -0.0941843 | 0.255508 | +| Accumulated other comprehensive income | 0.608619 | -0.123362 | -0.0967967 | +| Total stockholders' equity | 0.175245 | -0.0393787 | 0.199501 | +| Total liabilities and stockholders' equity | 0.0826416 | 0.0668155 | 0.2237 | + +Cashflow and Income statements are requested in the same way. ### Cash Get the company's cash statements. ```python -openbb.stocks.fa.cash(symbol = 'COST') +openbb.stocks.fa.cash(symbol = 'COST').tail(4) ``` -| Breakdown | ttm | 2022-08-31 | 2021-08-31 | 2020-08-31 | 2019-08-31 | -|:----------------------------------------------------------|------------:|-------------:|-------------:|-------------:|:-------------| -| Net income | 5844000000 | 5844000000 | 5007000000 | 4002000000 | 3659000000 | -| Depreciation & amortisation | 1900000000 | 1900000000 | 1781000000 | 1645000000 | 1492000000 | -| Deferred income taxes | -37000000 | -37000000 | 59000000 | 104000000 | 147000000 | -| Stock-based compensation | 724000000 | 724000000 | 665000000 | 619000000 | 595000000 | -| Change in working capital | -1563000000 | -1563000000 | 1003000000 | 2198000000 | 409000000 | -| Inventory | -4003000000 | -4003000000 | -1892000000 | -791000000 | -536000000 | -| Accounts payable | 1891000000 | 1891000000 | 1838000000 | 2261000000 | 322000000 | -| Other working capital | 3501000000 | 3501000000 | 5370000000 | 6051000000 | 3358000000 | -| Other non-cash items | 453000000 | 453000000 | 371000000 | 236000000 | 9000000 | -| Net cash provided by operating activities | 7392000000 | 7392000000 | 8958000000 | 8861000000 | 6356000000 | -| Investments in property, plant and equipment | -3891000000 | -3891000000 | -3588000000 | -2810000000 | -2998000000 | -| Acquisitions, net | 0 | 0 | 0 | -1163000000 | `<NA>` | -| Purchases of investments | -1121000000 | -1121000000 | -1331000000 | -1626000000 | -1094000000 | -| Sales/maturities of investments | 1145000000 | 1145000000 | 1446000000 | 1678000000 | 1231000000 | -| Other investing activities | -48000000 | -48000000 | -62000000 | 30000000 | -4000000 | -| Net cash used for investing activities | -3915000000 | -3915000000 | -3535000000 | -3891000000 | -2865000000 | -| Debt repayment | -800000000 | -800000000 | -94000000 | -3200000000 | -89000000 | -| Common stock repurchased | -439000000 | -439000000 | -496000000 | -196000000 | -247000000 | -| Dividends paid | -1498000000 | -1498000000 | -5748000000 | -1479000000 | -1038000000 | -| Other financing activities | -1546000000 | -1546000000 | -379000000 | -401000000 | -281000000 | -| Net cash used provided by (used for) financing activities | -4283000000 | -4283000000 | -6488000000 | -1147000000 | -1147000000 | -| Net change in cash | -1055000000 | -1055000000 | -1019000000 | 3893000000 | 2329000000 | -| Cash at beginning of period | 11258000000 | 11258000000 | 12277000000 | 8384000000 | 6055000000 | -| Cash at end of period | 10203000000 | 10203000000 | 11258000000 | 12277000000 | 8384000000 | -| Operating cash flow | 7392000000 | 7392000000 | 8958000000 | 8861000000 | 6356000000 | -| Capital expenditure | -3891000000 | -3891000000 | -3588000000 | -2810000000 | -2998000000 | -| Free cash flow | 3501000000 | 3501000000 | 5370000000 | 6051000000 | 3358000000 | +| Breakdown | ttm | 2022-08-31 | 2021-08-31 | 2020-08-31 | 2019-08-31 | +| :-------------------- | ---------: | ---------: | ---------: | ---------: | ---------: | +| Cash at end of period | 13136000.0 | 10203000.0 | 11258000.0 | 12277000.0 | 8384000.0 | +| Operating cash flow | 9535000.0 | 7392000.0 | 8958000.0 | 8861000.0 | 6356000.0 | +| Capital expenditure | -4060000.0 | -3891000.0 | -3588000.0 | -2810000.0 | -2998000.0 | +| Free cash flow | 5475000.0 | 3501000.0 | 5370000.0 | 6051000.0 | 3358000.0 | ### Income Get the company's income statements. ```python -openbb.stocks.fa.income('COST') +openbb.stocks.fa.income('COST').tail(4) ``` -| Breakdown | ttm | 2022-08-31 | 2021-08-31 | 2020-08-31 | 2019-08-31 | |