FMPFMP
Datasets

Financial Reports Form 10-K XLSX API

Financial Statements

Financial Reports Form 10-K XLSX

Edit any parameter, add optional ones, then hit Try it, then switch the response between Formatted and Raw.

Download detailed 10-K reports in XLSX format with the Financial Reports Form 10-K XLSX API. Effortlessly access and analyze annual financial data for companies in a spreadsheet-friendly format.

>_ Endpoint:
https://financialmodelingprep.com/stable/financial-reports-xlsx?symbol=AAPL&year=2022&period=Q1&apikey=YOUR_API_KEY

Parameters

( * ) Required
Query Parameter
Type
Value
symbol *
string
year *
number
period *
string
ResponseSample
1 result
Symbol
Period
Year
Cover Page
Auditor Information
C O N S O L I D A T E D …
C O N S O L I D A T E D …
C O N S O L I D A T E D …
C O N S O L I D A T E D …
C O N S O L I D A T E D …
C O N S O L I D A T E D …
Summary of Significant …
Revenue
Financial Instruments
Consolidated Financial …
Income Taxes
Leases
Debt
Shareholders' Equity
Benefit Plans
Commitments and Conting…
Segment Information and…
Summary of Significant …
Summary of Significant …
Revenue ( Tables)
Financial Instruments (…
Consolidated Financial …
Income Taxes ( Tables)
Leases ( Tables)
Debt ( Tables)
Shareholders' Equity ( …
Benefit Plans ( Tables)
Commitments and Conting…
Segment Information and…
Summary of Significant …
Summary of Significant …
Revenue - Net Sales D…
Revenue - Additional I…
Revenue - Deferred Rev…
Financial Instruments -…
Financial Instruments -…
Financial Instruments -…
Financial Instruments -…
Financial Instruments -…
Financial Instruments -…
Consolidated Financial …
Consolidated Financial …
Consolidated Financial …
Income Taxes - Provisi…
Income Taxes - Additio…
Income Taxes - Reconci…
Income Taxes - Signifi…
Income Taxes - Aggrega…
Leases - Additional In…
Leases - R O U Assets …
Leases - Lease Liabili…
Debt - Additional Info…
Debt - Summary of Cash…
Debt - Summary of Term…
Debt - Future Principa…
Shareholders' Equity - …
Shareholders' Equity - …
Benefit Plans - Additi…
Benefit Plans - Restri…
Benefit Plans - Summar…
Commitments and Conting…
Segment Information and…
Segment Information and…
Segment Information and…
Segment Information and…
AAPL
FY
2022
[{"Cover Page - USD ($) shares in Thousands, $ in Millions":["12 Months Ended"]},{"items":["Sep. 24, 2022","Oct. 14, 2022","Mar. 25, 2022"]},{"Entity Information [Line Items]":[" "," "," "]}]
[{"Auditor Information":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Auditor Information [Abstract]":[" "]}]
[{"CONSOLIDATED STATEMENTS OF OPERATIONS - USD ($) shares in Thousands, $ in Millions":["12 Months Ended"]},{"items":["Sep. 24, 2022","Sep. 25, 2021","Sep. 26, 2020"]},{"Net sales":[394328,365817,2745…
[{"CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME - USD ($) $ in Millions":["12 Months Ended"]},{"items":["Sep. 24, 2022","Sep. 25, 2021","Sep. 26, 2020"]},{"Statement of Comprehensive Income [Abstra…
[{"CONSOLIDATED BALANCE SHEETS - USD ($) $ in Millions":["Sep. 24, 2022","Sep. 25, 2021"]},{"Current assets:":[" "," "]},{"Cash and cash equivalents":[23646,34940]}]
[{"CONSOLIDATED BALANCE SHEETS (Parenthetical) - $ / shares":["Sep. 24, 2022","Sep. 25, 2021"]},{"Statement of Financial Position [Abstract]":[" "," "]},{"Common stock, par value (in dollars per share…
[{"CONSOLIDATED STATEMENTS OF SHAREHOLDERS' EQUITY - USD ($) $ in Millions":["Total","Common stock and additional paid-in capital","Retained earnings/(Accumulated deficit)","Retained earnings/(Accumul…
[{"CONSOLIDATED STATEMENTS OF CASH FLOWS - USD ($) $ in Millions":["12 Months Ended"]},{"items":["Sep. 24, 2022","Sep. 25, 2021","Sep. 26, 2020"]},{"Statement of Cash Flows [Abstract]":[" "," "," "]}]
[{"Summary of Significant Accounting Policies":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Accounting Policies [Abstract]":[" "]}]
[{"Revenue":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Revenue from Contract with Customer [Abstract]":[" "]}]
[{"Financial Instruments":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Investments, All Other Investments [Abstract]":[" "]}]
[{"Consolidated Financial Statement Details":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Organization, Consolidation and Presentation of Financial Statements [Abstract]":[" "]}]
[{"Income Taxes":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Income Tax Disclosure [Abstract]":[" "]}]
[{"Leases":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Leases [Abstract]":[" "]}]
[{"Debt":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Debt Disclosure [Abstract]":[" "]}]
[{"Shareholders' Equity":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Equity [Abstract]":[" "]}]
[{"Benefit Plans":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Share-Based Payment Arrangement [Abstract]":[" "]}]
[{"Commitments and Contingencies":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Commitments and Contingencies Disclosure [Abstract]":[" "]}]
[{"Segment Information and Geographic Data":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Segment Reporting [Abstract]":[" "]}]
[{"Summary of Significant Accounting Policies (Policies)":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Accounting Policies [Abstract]":[" "]}]
[{"Summary of Significant Accounting Policies (Tables)":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Accounting Policies [Abstract]":[" "]}]
[{"Revenue (Tables)":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Revenue from Contract with Customer [Abstract]":[" "]}]
[{"Financial Instruments (Tables)":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Investments, All Other Investments [Abstract]":[" "]}]
[{"Consolidated Financial Statement Details (Tables)":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Organization, Consolidation and Presentation of Financial Statements [Abstract]":[" "]}]
[{"Income Taxes (Tables)":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Income Tax Disclosure [Abstract]":[" "]}]
[{"Leases (Tables)":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Leases [Abstract]":[" "]}]
[{"Debt (Tables)":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Debt Disclosure [Abstract]":[" "]}]
[{"Shareholders' Equity (Tables)":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Equity [Abstract]":[" "]}]
[{"Benefit Plans (Tables)":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Share-Based Payment Arrangement [Abstract]":[" "]}]
[{"Commitments and Contingencies (Tables)":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Commitments and Contingencies Disclosure [Abstract]":[" "]}]
[{"Segment Information and Geographic Data (Tables)":["12 Months Ended"]},{"items":["Sep. 24, 2022"]},{"Segment Reporting [Abstract]":[" "]}]
[{"Summary of Significant Accounting Policies - Additional Information (Details) $ in Billions":["12 Months Ended"]},{"items":["Sep. 24, 2022 USD ($) performanceObligation","Sep. 25, 2021 USD ($)","Se…
[{"Summary of Significant Accounting Policies - Computation of Basic and Diluted Earnings Per Share (Details) - USD ($) $ / shares in Units, shares in Thousands, $ in Millions":["12 Months Ended"]},{"…
[{"Revenue - Net Sales Disaggregated by Significant Products and Services (Details) - USD ($) $ in Millions":["12 Months Ended"]},{"items":["Sep. 24, 2022","Sep. 25, 2021","Sep. 26, 2020"]},{"Disaggre…
[{"Revenue - Additional Information (Details) - USD ($) $ in Billions":["Sep. 24, 2022","Sep. 25, 2021"]},{"Revenue from Contract with Customer [Abstract]":[" "," "]},{"Total deferred revenue":[12.4,1…
[{"Revenue - Deferred Revenue, Expected Timing of Realization (Details)":["Sep. 24, 2022"]},{"Revenue, Remaining Performance Obligation, Expected Timing of Satisfaction, Start Date [Axis]: 2022-09-25"…
[{"Financial Instruments - Cash, Cash Equivalents and Marketable Securities (Details) - USD ($) $ in Millions":["Sep. 24, 2022","Sep. 25, 2021"]},{"Debt Securities, Available-for-sale [Line Items]":["…
[{"Financial Instruments - Non-Current Marketable Debt Securities by Contractual Maturity (Details) $ in Millions":["Sep. 24, 2022 USD ($)"]},{"Fair value of non-current marketable debt securities by …
[{"Financial Instruments - Additional Information (Details) $ in Millions":["12 Months Ended"]},{"items":["Sep. 24, 2022 USD ($) Customer Vendor","Sep. 25, 2021 Vendor"]},{"Financial Instruments [Line…
[{"Financial Instruments - Notional Amounts Associated with Derivative Instruments (Details) - USD ($) $ in Millions":["Sep. 24, 2022","Sep. 25, 2021"]},{"Derivatives designated as accounting hedges |…
[{"Financial Instruments - Gross Fair Values of Derivative Assets and Liabilities (Details) - Level 2 $ in Millions":["Sep. 24, 2022 USD ($)"]},{"Other current assets and other non-current assets | Fo…
[{"Financial Instruments - Derivative Instruments Designated as Fair Value Hedges and Related Hedged Items (Details) - USD ($) $ in Millions":["Sep. 24, 2022","Sep. 25, 2021"]},{"Current and non-curre…
[{"Consolidated Financial Statement Details - Property, Plant and Equipment, Net (Details) - USD ($) $ in Millions":["Sep. 24, 2022","Sep. 25, 2021"]},{"Property, Plant and Equipment [Line Items]":[" …
[{"Consolidated Financial Statement Details - Other Non-Current Liabilities (Details) - USD ($) $ in Millions":["Sep. 24, 2022","Sep. 25, 2021"]},{"Organization, Consolidation and Presentation of Fina…
[{"Consolidated Financial Statement Details - Other Income/(Expense), Net (Details) - USD ($) $ in Millions":["12 Months Ended"]},{"items":["Sep. 24, 2022","Sep. 25, 2021","Sep. 26, 2020"]},{"Organiza…
[{"Income Taxes - Provision for Income Taxes (Details) - USD ($) $ in Millions":["12 Months Ended"]},{"items":["Sep. 24, 2022","Sep. 25, 2021","Sep. 26, 2020"]},{"Federal:":[" "," "," "]}]
[{"Income Taxes - Additional Information (Details) $ in Millions, € in Billions":[null,"12 Months Ended"]},{"items":["Aug. 30, 2016 EUR (€) Subsidiary","Sep. 24, 2022 USD ($)","Sep. 25, 2021 USD ($)",…
[{"Income Taxes - Reconciliation of Provision for Income Taxes to Amount Computed by Applying the Statutory Federal Income Tax Rate to Income Before Provision for Income Taxes (Details) - USD ($) $ in…
[{"Income Taxes - Significant Components of Deferred Tax Assets and Liabilities (Details) - USD ($) $ in Millions":["Sep. 24, 2022","Sep. 25, 2021"]},{"Deferred tax assets:":[" "," "]},{"Amortization …
[{"Income Taxes - Aggregate Changes in Gross Unrecognized Tax Benefits (Details) - USD ($) $ in Millions":["12 Months Ended"]},{"items":["Sep. 24, 2022","Sep. 25, 2021","Sep. 26, 2020"]},{"Reconciliat…
[{"Leases - Additional Information (Details) - USD ($) $ in Billions":["12 Months Ended"]},{"items":["Sep. 24, 2022","Sep. 25, 2021","Sep. 26, 2020"]},{"Lessee, Lease, Description [Line Items]":[" ","…
[{"Leases - ROU Assets and Lease Liabilities (Details) - USD ($) $ in Millions":["Sep. 24, 2022","Sep. 25, 2021"]},{"Lease-Related Assets and Liabilities":[" "," "]},{"Operating lease right-of-use ass…
[{"Leases - Lease Liability Maturities (Details) - USD ($) $ in Millions":["Sep. 24, 2022","Sep. 25, 2021"]},{"Operating Leases":[" "," "]},{"2023":[1758," "]}]
[{"Debt - Additional Information (Details) - USD ($) $ in Millions":["12 Months Ended"]},{"items":["Sep. 24, 2022","Sep. 25, 2021","Sep. 26, 2020"]},{"Debt Instrument [Line Items]":[" "," "," "]}]
[{"Debt - Summary of Cash Flows Associated with Commercial Paper (Details) - USD ($) $ in Millions":["12 Months Ended"]},{"items":["Sep. 24, 2022","Sep. 25, 2021","Sep. 26, 2020"]},{"Maturities 90 day…
[{"Debt - Summary of Term Debt (Details) - USD ($) $ in Millions":["12 Months Ended"]},{"items":["Sep. 24, 2022","Sep. 25, 2021"]},{"Debt Instrument [Line Items]":[" "," "]}]
[{"Debt - Future Principal Payments for Term Debt (Details) - USD ($) $ in Millions":["Sep. 24, 2022","Sep. 25, 2021"]},{"Debt Disclosure [Abstract]":[" "," "]},{"2023":[11139," "]}]
[{"Shareholders' Equity - Additional Information (Details) shares in Millions, $ in Billions":["12 Months Ended"]},{"items":["Sep. 24, 2022 USD ($) shares"]},{"Stockholders' Equity Note [Abstract]":["…
[{"Shareholders' Equity - Shares of Common Stock (Details) - shares shares in Thousands":["12 Months Ended"]},{"items":["Sep. 24, 2022","Sep. 25, 2021","Sep. 26, 2020"]},{"Increase (Decrease) in Share…
[{"Benefit Plans - Additional Information (Details) shares in Millions":["12 Months Ended"]},{"items":["Sep. 24, 2022 USD ($) shares","Sep. 25, 2021 USD ($) shares","Sep. 26, 2020 USD ($) shares","Mar…
[{"Benefit Plans - Restricted Stock Units Activity and Related Information (Details) - Restricted stock units - USD ($) $ / shares in Units, shares in Thousands, $ in Millions":["12 Months Ended"]},{"…
[{"Benefit Plans - Summary of Share-Based Compensation Expense and the Related Income Tax Benefit (Details) - USD ($) $ in Millions":["12 Months Ended"]},{"items":["Sep. 24, 2022","Sep. 25, 2021","Sep…
[{"Commitments and Contingencies - Future Payments Under Unconditional Purchase Obligations (Details) $ in Millions":["Sep. 24, 2022 USD ($)"]},{"Unconditional Purchase Obligation, Fiscal Year Maturit…
[{"Segment Information and Geographic Data - Information by Reportable Segment (Details) - USD ($) $ in Millions":["12 Months Ended"]},{"items":["Sep. 24, 2022","Sep. 25, 2021","Sep. 26, 2020"]},{"Seg…
[{"Segment Information and Geographic Data - Reconciliation of Segment Operating Income to the Consolidated Statements of Operations (Details) - USD ($) $ in Millions":["12 Months Ended"]},{"items":["…
[{"Segment Information and Geographic Data - Net Sales (Details) - USD ($) $ in Millions":["12 Months Ended"]},{"items":["Sep. 24, 2022","Sep. 25, 2021","Sep. 26, 2020"]},{"Revenues from External Cust…
[{"Segment Information and Geographic Data - Long-Lived Assets (Details) - USD ($) $ in Millions":["Sep. 24, 2022","Sep. 25, 2021"]},{"Revenues from External Customers and Long-Lived Assets [Line Item…