Equity · Nasdaq

Apple Inc.

AAPL · sample price 231.45 USD · FY2025 (sample)

Statement summary

Line-item sample statements with reconciliation checks

Line-item sample income statement, balance sheet and cash flow. Subtotals and reconciliation checks are calculated from the same fixture, not copied from a filing.

Sample statements

Income statement

FY2025 (sample) · USD Sample
Revenue
391.0 bn
Cost of revenue
210.0 bn
Gross profit
181.0 bn
Operating expenses
57.8 bn
Operating income
123.2 bn
Interest expense
3.5 bn
Pre-tax income
119.7 bn
Income tax
26.0 bn
Net income
93.7 bn

Sample income statement. Subtotals and totals are calculated from the lines shown.

Marketir demo fundamentals fixture · As of 12 Nov 2026, 09:00 UTC

Balance sheet

FY2025 (sample) · USD Sample
Cash and equivalents
30.0 bn
Receivables
33.0 bn
Inventory
6.0 bn
Other current assets
5.0 bn
Current assets
74.0 bn
Property, plant and equipment
100.0 bn
Other non-current assets
24.0 bn
Total assets
198.0 bn
Total debt
98.5 bn
Other liabilities
40.0 bn
Total liabilities
138.5 bn
Equity
59.5 bn
Total liabilities and equity
198.0 bn

Sample balance sheet. Assets reconcile to liabilities plus equity.

Marketir demo fundamentals fixture · As of 12 Nov 2026, 09:00 UTC

Cash flow statement

FY2025 (sample) · USD Sample
Net income
93.7 bn
Depreciation and amortisation
12.0 bn
Change in working capital Negative values are a source of cash.
-12.6 bn
Operating cash flow
118.3 bn
Capital expenditure
11.0 bn
Free cash flow
107.3 bn

Sample cash flow. Operating cash flow and free cash flow are calculated from the lines shown.

Marketir demo fundamentals fixture · As of 12 Nov 2026, 09:00 UTC

Reconciliation

Each check compares the reported sample line with its calculated value. A zero difference is the expected result; a mismatch would be shown rather than hidden.

Reconciliation checks for the sample income statement, balance sheet and cash flow
CheckFormulaReportedCalculatedDifferenceStatus
Gross profitRevenue − Cost of revenue181.0181.00.0Reconciled
Operating incomeGross profit − Operating expenses123.2123.20.0Reconciled
Net incomePre-tax income − Income tax93.793.70.0Reconciled
Total assetsTotal liabilities + Equity198.0198.00.0Reconciled
Total liabilitiesTotal debt + Other liabilities138.5138.50.0Reconciled
Operating cash flowNet income + D&A − Change in working capital118.3118.30.0Reconciled
Free cash flowOperating cash flow − Capital expenditure107.3107.30.0Reconciled

Every statement line and reconciliation value is a sample assumption for this prototype. It is not a reported statement, not independently verified and not a recommendation or investment advice. Missing lines stay missing and are never replaced with zero.

Fundamental metrics

Each row carries its own period, currency, status, assumption and sample provenance

Sample fundamental metrics for Apple Inc.
MetricValuePeriod, status and assumption
Revenue391.0 bn
FY2025 (sample) USD Sample

Revenue is a hand-written sample figure for the stated fiscal period, not a reported filing.

Marketir demo fundamentals fixture · As of 12 Nov 2026, 09:00 UTC

Operating income123.2 bn
FY2025 (sample) USD Sample

Sample operating profit after operating expenses; tax and non-operating items are excluded.

Marketir demo fundamentals fixture · As of 12 Nov 2026, 09:00 UTC

Net income93.7 bn
FY2025 (sample) USD Sample

Sample net income attributable to common shareholders for the stated period.

Marketir demo fundamentals fixture · As of 12 Nov 2026, 09:00 UTC

Diluted EPS6.13 per share
FY2025 (sample) USD Sample

Sample diluted EPS using the sample diluted share count.

Marketir demo fundamentals fixture · As of 12 Nov 2026, 09:00 UTC

Operating cash flow118.3 bn
FY2025 (sample) USD Sample

Sample cash from operations; investing and financing cash flows are excluded.

Marketir demo fundamentals fixture · As of 12 Nov 2026, 09:00 UTC

Total debt98.5 bn
FY2025 (sample) USD Sample

Sample gross debt before netting cash; lease and maturity detail is not modelled.

Marketir demo fundamentals fixture · As of 12 Nov 2026, 09:00 UTC

Equity59.5 bn
FY2025 (sample) USD Sample

Sample book equity at the end of the stated period.

Marketir demo fundamentals fixture · As of 12 Nov 2026, 09:00 UTC

P/E37.8 ×
FY2025 (sample) USD Sample

Sample price divided by sample diluted EPS; not a market quote.

Marketir demo fundamentals fixture · As of 12 Nov 2026, 09:00 UTC

Price / book48.2 ×
FY2025 (sample) USD Sample

Sample price divided by sample book value per share; not a market quote.

Marketir demo fundamentals fixture · As of 12 Nov 2026, 09:00 UTC

Return on equity157.4 %
FY2025 (sample) USD Sample

Sample net income divided by sample ending equity; not an average-balance calculation.

Marketir demo fundamentals fixture · As of 12 Nov 2026, 09:00 UTC

Net debt / EBITDA0.90 ×
FY2025 (sample) USD Sample

Sample net debt divided by sample EBITDA.

Marketir demo fundamentals fixture · As of 12 Nov 2026, 09:00 UTC

Dividend yield0.41 %
FY2025 (sample) USD Sample

Sample annual dividend per share divided by sample price.

Marketir demo fundamentals fixture · As of 12 Nov 2026, 09:00 UTC

Every row carries its own period, currency, status, assumption and sample provenance. The figures are not reported statements, are not independently verified, and are not a recommendation. Missing metrics stay missing and are excluded from every comparison.

Valuation

A DCF is only offered where a free-cash-flow model is defensible for the demo

Illustrative DCF — Apple Inc.

Five-year explicit forecast plus a Gordon-growth terminal value. Inputs are sample assumptions, not reported figures (FY2025 (sample)).

Illustrative model

USD billions, year 0

Percent per year, years 1–5

Percent, WACC proxy

Percent, perpetuity

USD billions; negative is net cash

Billions of shares

FCF, net debt and share count are sample inputs aligned to the sample scale.

Model value per share

131.25 USD

Sample price 231.45 USD · −43.29% difference

The difference is a property of these assumptions, not a recommendation or a price target.

PV of forecast FCF
500.7
Terminal value (undiscounted)
2,296.0
PV of terminal value
1,492.2
Enterprise value
1,992.9
Equity value
1,947.7

Cash-flow, terminal, enterprise and equity values in USD billions.

Projected free cash flow, discount factor and present value
YearFCF (USD bn)Discount factorPV (USD bn)
Year 1115.30.9174105.8
Year 2122.20.8417102.9
Year 3129.60.7722100.1
Year 4137.40.708497.3
Year 5145.60.649994.6
Model value per share across discount rate and terminal growth assumptions
Discount rate ↓ / terminal growth →2.0%2.5%3.0%
8.0%145.14156.07169.18
9.0%123.61131.25140.16
10.0%107.47113.06119.44

Shared across all three scenarios: base FCF 108.8 USD bn, net debt 45.2 USD bn, and diluted shares 14.8 bn.

Base, bull and bear scenario assumptions and implied value per share
ScenarioFCF growthDiscount rateTerminal growthValue / sharevs base
Base6.0%9.0%2.5%131.25—
Bull9.0%8.0%3.0%192.80+46.89%
Bear3.0%10.0%2.0%94.47−28.02%

Base uses the inputs currently entered. Bull adds 3.0pp FCF growth, subtracts 1.0pp from the discount rate and adds 0.5pp terminal growth; Bear applies the opposite shifts. These are mechanical illustrations, not forecasts, probabilities, price targets or recommendations. No scenario is preferred.

  • FCFₜ = FCF₀ × (1 + g)ᵗ for t = 1…5
  • PV(FCFₜ) = FCFₜ ÷ (1 + r)ᵗ
  • Terminal value = FCF₅ × (1 + gₜ) ÷ (r − gₜ)
  • Enterprise value = Σ PV(FCFₜ) + PV(terminal value)
  • Equity value = enterprise value − net debt
  • Value per share = equity value ÷ diluted shares

Simplifications: one constant growth rate, no separate tax, capex or working-capital build, no share dilution, no mid-year discounting, and no scenario weighting. The model is a demonstration of interaction and disclosure, not a validated valuation.

Project finance

An editable sample infrastructure case with base/bull/bear scenarios, NPV, IRR, payback and a DSCR covenant test. Every input is an illustrative assumption, not advice.

Solar-plus-storage project

An editable utility-scale solar-plus-storage case used to demonstrate project-finance mechanics. USD millions, nominal, pre-tax.

Editable sample Not investment advice

All inputs are sample assumptions. Every assumption input below can be edited locally to demonstrate NPV, IRR, payback and DSCR mechanics. This is not a feasibility study, a lender case, a valuation or a recommendation. Nothing is saved or sent anywhere.

Sample inputs

USD millions, capex

Years, whole number

Percent, nominal

USD millions

Percent per year

USD millions

Percent per year

Percent of capex

Percent, fixed

Years, equal principal; within project life

× minimum, sample lender test

Starting values come from the sample fixture. Edited values are illustrative, remain local and are not a quote, term sheet or recommendation.

Net present value
114.6 USD m
At the 9.0% sample discount rate.
IRR
19.3%
Discount rate at which NPV equals zero.
Payback
5.4 years
Undiscounted, interpolated within the recovery year.
Minimum DSCR
1.39 ×
Lowest annual project cash flow ÷ debt service. Sample covenant 1.20×: Pass

Sample funding: 72.0 USD m debt (60% of capex) and 48.0 USD m equity. Average DSCR during the loan: 1.93×. Covenant 1.20×: Pass.

All scenarios share capex 120.0 USD m, 20-year life, year-1 revenue 28.0 USD m, year-1 operating expenses 7.5 USD m, debt share 60%, tenor 8 years and covenant 1.20×. Only growth, discount and interest assumptions shift.

Base, bull and bear sample assumptions and project-finance outputs
ScenarioRevenue growthExpense growthDiscount rateInterest rateNPV (USD m)IRRPayback (yrs)Min DSCRCovenant
Base3.0%2.5%9.0%8.0%114.619.3%5.41.39Pass
Bull5.0%1.5%8.0%7.5%200.022.1%5.11.42Pass
Bear1.0%3.5%10.0%8.5%53.416.2%5.81.36Pass
  • Base: Current editable assumptions.
  • Bull: Revenue growth +2pp, expense growth −1pp, discount rate −1pp, interest rate −0.5pp.
  • Bear: Revenue growth −2pp, expense growth +1pp, discount rate +1pp, interest rate +0.5pp.

Scenarios are mechanical sample cases around the inputs currently entered, not forecasts, probabilities, lender cases, price targets or recommendations. No scenario is preferred. A negative DSCR or a breach is shown as calculated, not adjusted. A result shown as n/a means the shifted assumptions fall outside the model's valid bounds and no value is substituted.

Sample project revenue, operating expenses, cash flow, debt service, DSCR and covenant status by year
YearRevenue (USD m)Operating expenses (USD m)Project cash flow (USD m)Debt service (USD m)DSCR (×)Covenant
Year 128.07.520.514.81.39Pass
Year 228.87.721.214.01.51Pass
Year 329.77.921.813.31.64Pass
Year 430.68.122.512.61.79Pass
Year 531.58.323.211.91.96Pass
Year 632.58.524.011.22.15Pass
Year 733.48.724.710.42.37Pass
Year 834.48.925.59.72.63Pass
Year 935.59.126.3———
Year 1036.59.427.2———
Year 1137.69.628.0———
Year 1238.89.828.9———
Year 1339.910.129.8———
Year 1441.110.330.8———
Year 1542.410.631.8———
Year 1643.610.932.8———
Year 1744.911.133.8———
Year 1846.311.434.9———
Year 1947.711.736.0———
Year 2049.112.037.1———

All figures are sample USD millions, nominal and pre-tax. Debt service appears only during the 8-year loan; DSCR and the covenant test are blank after the debt is repaid. The sample covenant is 1.20×. No terminal or residual value is included.

  • Revenueₜ = year-1 revenue × (1 + revenue growth)ᵗ⁻¹
  • Operating expensesₜ = year-1 operating expenses × (1 + expense growth)ᵗ⁻¹
  • Project cash flowₜ = revenueₜ − operating expensesₜ
  • NPV = −initial investment + Σ project cash flowₜ ÷ (1 + discount rate)ᵗ
  • IRR solves NPV = 0 over the same cash flows
  • Payback = years until cumulative project cash flow recovers the initial investment
  • Equal principal = debt ÷ tenor; interest = opening balance × rate
  • DSCRₜ = project cash flowₜ ÷ debt serviceₜ
  • Covenant test = DSCRₜ ≥ sample DSCR covenant; otherwise a breach
  • Annual, nominal, pre-tax project cash flow; no tax, depreciation, working capital or inflation.
  • No terminal or residual value, financing fees, reserves, maintenance capex or replacement capex.
  • Initial funding is 60% debt at a fixed rate with equal principal over eight years; edited debt share and tenor replace those starting values. No grace period, refinancing or fees.
  • The initial DSCR covenant is a sample 1.20× minimum test, not a lender term sheet. It is applied to each year with debt service; breaches are listed, not cured or waived.
  • Revenue and operating expenses grow at constant annual rates from year one; no seasonality or volume build-up.
  • Payback is undiscounted; NPV and IRR use end-of-year cash flows.
  • All inputs are sample assumptions. This is not a feasibility study, valuation, recommendation or investment advice.
Sample Marketir demo project-finance fixture As of 17 Nov 2026, 09:00 UTC