Is there any documentation available to understand the hierarchy of Morningstar financial statements data? For example, how do we know that the value of
net_ppe_purchase_and_sale
is included in the value of cash_flow_from_continuing_investing_activities
which is then included in the value of investing_cash_flow
? The Quantopian Morningstar Fundamentals Reference page is not helpful in this regard. I doubt if even a Controller for a Fortune 500 company could easily piece all of this data together given the documentation provided here : )
Something like the (super incomplete) example below is sorely needed. Otherwise how can we understand how granular each data point is and how can we account for confounding variables?
Has anyone put something together like this that you'd like to share with the community? Or know of something put together by Morningstar that could help?
financial_statements
|-- balance_sheet
| |-- total_assets
| | |-- current_assets
| | | |-- cash_cash_equivalents_and_marketable_securities
| | | |-- inventory
| | | |-- receivables
| | | |-- assets_held_for_sale_current
| | | |-- restricted_cash
| | |-- total_non_current_assets
| | | |-- net_ppe
| | | |-- goodwill_and_other_intangible_assets
| | | |-- long_term_investments
| | | |-- non_current_accounts_receivable
| |-- total_liabilities
| | |-- current_liabilities
| | | |-- payables_and_accrued_expenses
| | | |-- current_debt_and_capital_lease_obligation
| | | |-- other_current_liabilities
| | |-- total_non_current_liabilities_net_minority_interest
| | | |-- long_term_debt_and_capital_lease_obligation
| | | |-- liabilities_heldfor_sale_non_current
| | | |-- other_non_current_liabilities
| |-- total_equity
| | |-- stockholders_equity
| | | |-- additional_paid_in_capital
| | | |-- retained_earnings
| | | |-- gains_losses_not_affecting_retained_earnings
|-- cash_flow_statement
| |-- operating_cash_flow
| | |-- cash_flow_from_continuing_operating_activities
| | |-- cash_from_discontinued_operating_activities
| |-- investing_cash_flow
| | |-- cash_flow_from_continuing_investing_activities
| | |-- cash_from_discontinued_investing_activities
| |-- financing_cash_flow
| | |-- cash_flow_from_continuing_financing_activities
| | |-- cash_from_discontinued_financing_activities