Microsoft/Tesla/Apple 10-K Filing: Financial Info
For fiscal years 2023, 2022, and 2021
@kaggle.chrisw1212_company_finances
For fiscal years 2023, 2022, and 2021
@kaggle.chrisw1212_company_finances
This information comes from the 2023, 2022, and 2021 10-K filings for Microsoft, Tesla, and Apple. Each 10-K form can be found using the SEC's EDGAR database.
Microsoft 2023 10-K form: https://www.sec.gov/ix?doc=/Archives/edgar/data/0000789019/000095017023035122/msft-20230630.htm
Microsoft 2022 10-K form: https://www.sec.gov/ix?doc=/Archives/edgar/data/0000789019/000156459022026876/msft-10k_20220630.htm
Microsoft 2021 10-K form: https://www.sec.gov/ix?doc=/Archives/edgar/data/0000789019/000156459021039151/msft-10k_20210630.htm
Tesla 2023 10-K form: https://www.sec.gov/ix?doc=/Archives/edgar/data/0001318605/000162828024002390/tsla-20231231.htm
Tesla 2022 10-K form: https://www.sec.gov/ix?doc=/Archives/edgar/data/0001318605/000095017023001409/tsla-20221231.htm
Tesla 2021 10-K form: https://www.sec.gov/ix?doc=/Archives/edgar/data/0001318605/000095017022000796/tsla-20211231.htm
Apple 2023 10-K form: https://www.sec.gov/ix?doc=/Archives/edgar/data/0000320193/000032019323000106/aapl-20230930.htm
Apple 2022 10-K form: https://www.sec.gov/ix?doc=/Archives/edgar/data/0000320193/000032019322000108/aapl-20220924.htm
Apple 2021 10-K form: https://www.sec.gov/ix?doc=/Archives/edgar/data/0000320193/000032019321000105/aapl-20210925.htm
CREATE TABLE company_finances (
"company" VARCHAR,
"year" DOUBLE,
"total_revenue" DOUBLE,
"net_income" DOUBLE,
"total_assets" DOUBLE,
"total_liabilities" DOUBLE,
"cash_flow_from_operating_activities" DOUBLE
);Anyone who has the link will be able to view this.