Equity Lens
Research terminalDCF WORKSPACEEditable source
COMPANY RESEARCH DCF VALUATION

Company valuation

Search a company, build a forecast, and examine what drives its value.

A

AppleAAPL

Consumer technology · FY2025 ended 2025-09-27

Loading saved models…
ESTIMATED VALUE BASE CASE
$118.78/ share

Five-year discounted cash flow · FY2025 model anchor

9.0% WACC2.5% terminal growthUSD
$

Add a price to compare value
and run a reverse DCF.

Enterprise value$1,721.1B

Present value of operating cash flows

Equity value$1,754.8B

After net debt & bridge adjustments

Terminal share of EV71.6%

How much value comes after year 5

Cash flow, year by year

Your operating assumptions translated into value.

FCFF · USD billions

Five-year forecast

USD millions
Operating modelFY2026EFY2027EFY2028EFY2029EFY2030E
Revenue growth5.0%5.0%4.0%4.0%3.0%
Revenue436,969458,818477,170496,257511,145
EBIT139,830146,822152,694158,802163,566
Cash tax on EBIT22,37323,49124,43125,40826,171
NOPAT117,457123,330128,263133,394137,396
+ Depreciation & amortization12,23512,84713,36113,89514,312
− Capital expenditure13,54614,22314,79215,38415,845
− Change in selected NWC + other-12-13-11-11-9
Free cash flow to firm116,158121,966126,842131,916135,871
Present value of FCFF106,567102,65797,94693,45388,307

Enterprise → equity

Enterprise value
$1,721.1B
+ Cash & marketable securities
$132.4B
+ Other non-operating assets
$0B
− Interest-bearing debt
$98.7B
− Other claims
$0B
Equity value
$1,754.8B

Divided by 14,773 million shares, including your dilution adjustment.

A closer look at terminal value

Year 6 NOPAT
$140.8B
Required net reinvestment
$17.6B
Year 6 FCFF
$123.2B
PV of terminal value
$1,232.1B

Terminal reinvestment = NOPAT × growth / ROIC. Review the transition from forecast investment to mature investment.

Your research notes

Explain why your assumptions make sense.

Notes are saved with your model.