Fundamentals and illustrative valuation
Research
Sample fundamental metrics, bank-specific metrics for BBCA and BBRI, and a line-item three-statement summary with reconciliation, where every metric carries its own currency, period, status, assumption and provenance. An editable DCF follows where a free-cash-flow model is appropriate, with sensitivity and separate base/bull/bear scenarios, plus an editable project-finance case with base/bull/bear scenarios and a DSCR covenant. Figures are illustrative, not reported statements, and nothing here is investment advice.
Equity · Nasdaq
Apple Inc.
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 statementsIncome statement
- 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
- 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
- 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.
| Check | Formula | Reported | Calculated | Difference | Status |
|---|---|---|---|---|---|
| Gross profit | Revenue − Cost of revenue | 181.0 | 181.0 | 0.0 | Reconciled |
| Operating income | Gross profit − Operating expenses | 123.2 | 123.2 | 0.0 | Reconciled |
| Net income | Pre-tax income − Income tax | 93.7 | 93.7 | 0.0 | Reconciled |
| Total assets | Total liabilities + Equity | 198.0 | 198.0 | 0.0 | Reconciled |
| Total liabilities | Total debt + Other liabilities | 138.5 | 138.5 | 0.0 | Reconciled |
| Operating cash flow | Net income + D&A − Change in working capital | 118.3 | 118.3 | 0.0 | Reconciled |
| Free cash flow | Operating cash flow − Capital expenditure | 107.3 | 107.3 | 0.0 | Reconciled |
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
| Metric | Value | Period, status and assumption |
|---|---|---|
| Revenue | 391.0 bn | |
| Operating income | 123.2 bn | |
| Net income | 93.7 bn | |
| Diluted EPS | 6.13 per share | |
| Operating cash flow | 118.3 bn | |
| Total debt | 98.5 bn | |
| Equity | 59.5 bn | |
| P/E | 37.8 × | |
| Price / book | 48.2 × | |
| Return on equity | 157.4 % | |
| Net debt / EBITDA | 0.90 × | |
| Dividend yield | 0.41 % |
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)).
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.
Forecast
| Year | FCF (USD bn) | Discount factor | PV (USD bn) |
|---|---|---|---|
| Year 1 | 115.3 | 0.9174 | 105.8 |
| Year 2 | 122.2 | 0.8417 | 102.9 |
| Year 3 | 129.6 | 0.7722 | 100.1 |
| Year 4 | 137.4 | 0.7084 | 97.3 |
| Year 5 | 145.6 | 0.6499 | 94.6 |
Sensitivity — value per share (USD)
| Discount rate ↓ / terminal growth → | 2.0% | 2.5% | 3.0% |
|---|---|---|---|
| 8.0% | 145.14 | 156.07 | 169.18 |
| 9.0% | 123.61 | 131.25 | 140.16 |
| 10.0% | 107.47 | 113.06 | 119.44 |
Scenario analysis — value per share (USD)
Shared across all three scenarios: base FCF 108.8 USD bn, net debt 45.2 USD bn, and diluted shares 14.8 bn.
| Scenario | FCF growth | Discount rate | Terminal growth | Value / share | vs base |
|---|---|---|---|---|---|
| Base | 6.0% | 9.0% | 2.5% | 131.25 | — |
| Bull | 9.0% | 8.0% | 3.0% | 192.80 | +46.89% |
| Bear | 3.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.
Formulas used
- 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.
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.
Editable sample assumptions
Sample inputsUSD 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.
Scenario analysis
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.
| Scenario | Revenue growth | Expense growth | Discount rate | Interest rate | NPV (USD m) | IRR | Payback (yrs) | Min DSCR | Covenant |
|---|---|---|---|---|---|---|---|---|---|
| Base | 3.0% | 2.5% | 9.0% | 8.0% | 114.6 | 19.3% | 5.4 | 1.39 | Pass |
| Bull | 5.0% | 1.5% | 8.0% | 7.5% | 200.0 | 22.1% | 5.1 | 1.42 | Pass |
| Bear | 1.0% | 3.5% | 10.0% | 8.5% | 53.4 | 16.2% | 5.8 | 1.36 | Pass |
- 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.
Annual cash flow and debt service
| Year | Revenue (USD m) | Operating expenses (USD m) | Project cash flow (USD m) | Debt service (USD m) | DSCR (×) | Covenant |
|---|---|---|---|---|---|---|
| Year 1 | 28.0 | 7.5 | 20.5 | 14.8 | 1.39 | Pass |
| Year 2 | 28.8 | 7.7 | 21.2 | 14.0 | 1.51 | Pass |
| Year 3 | 29.7 | 7.9 | 21.8 | 13.3 | 1.64 | Pass |
| Year 4 | 30.6 | 8.1 | 22.5 | 12.6 | 1.79 | Pass |
| Year 5 | 31.5 | 8.3 | 23.2 | 11.9 | 1.96 | Pass |
| Year 6 | 32.5 | 8.5 | 24.0 | 11.2 | 2.15 | Pass |
| Year 7 | 33.4 | 8.7 | 24.7 | 10.4 | 2.37 | Pass |
| Year 8 | 34.4 | 8.9 | 25.5 | 9.7 | 2.63 | Pass |
| Year 9 | 35.5 | 9.1 | 26.3 | — | — | — |
| Year 10 | 36.5 | 9.4 | 27.2 | — | — | — |
| Year 11 | 37.6 | 9.6 | 28.0 | — | — | — |
| Year 12 | 38.8 | 9.8 | 28.9 | — | — | — |
| Year 13 | 39.9 | 10.1 | 29.8 | — | — | — |
| Year 14 | 41.1 | 10.3 | 30.8 | — | — | — |
| Year 15 | 42.4 | 10.6 | 31.8 | — | — | — |
| Year 16 | 43.6 | 10.9 | 32.8 | — | — | — |
| Year 17 | 44.9 | 11.1 | 33.8 | — | — | — |
| Year 18 | 46.3 | 11.4 | 34.9 | — | — | — |
| Year 19 | 47.7 | 11.7 | 36.0 | — | — | — |
| Year 20 | 49.1 | 12.0 | 37.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.
Formulas used
- 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
Simplifications and boundaries
- 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.