Skip to content
Ti
← All Projects

APPLIED FINANCE LAB / 01

Corporate Valuation & Capital Allocation

A discounted cash flow valuation and WACC sensitivity analysis of Apple Inc. (AAPL).

DCFWACCValuationSensitivity Analysis

SNAPSHOT — AS OF SEPTEMBER 2026

$103.58

Base DCF Value / Share

$90.52–$120.81

WACC Sensitivity Range

10.3%

Base WACC

Question / Objective

Estimate an intrinsic per-share value for Apple Inc. using a discounted cash flow (DCF) model built on the company's own historical financials, then test how sensitive that value is to the discount rate assumed — a core exercise in corporate valuation and capital allocation coursework.

Course-Concept Connection

  • Intermediate Corporate Finance
  • FIN 3023 — Intermediate Corporate Finance
  • FIN 4123 — Security Analysis & Corporate Valuation II
  • Financial Modeling

Data Sources

Methodology

  1. 1.Pulled Apple's fiscal-year revenue, free cash flow (operating cash flow less capital expenditures), total debt, and cash & marketable securities for FY2021–FY2025 directly from SEC EDGAR's XBRL company-facts API (the same figures underlying AAPL's 10-K filings), plus current price/beta/shares outstanding from market data.
  2. 2.Built a five-year explicit free cash flow forecast off the FY2025 base, using a declining growth assumption (7.0% tapering to 4.0%) that reflects a maturing growth profile.
  3. 3.Calculated a WACC using CAPM for the cost of equity (10-year Treasury as the risk-free rate, AAPL's 5-year beta, and a standard 5.0% equity risk premium) and an assumed after-tax cost of debt, weighted by AAPL's actual capital structure (market cap vs. total debt).
  4. 4.Applied the Gordon Growth Model to estimate a terminal value at the end of Year 5, using a 3.0% long-run terminal growth rate.
  5. 5.Discounted the explicit-period cash flows and the terminal value back to present value, summed them for enterprise value, then bridged to equity value and per-share value.
  6. 6.Re-ran the model at three WACC scenarios (9.3%, 10.3%, 11.3%) to test sensitivity, holding the terminal growth rate constant.

Assumptions

  • Equity risk premium assumed at a standard 5.0% (a common textbook/practitioner convention, not company-specific data).
  • Pre-tax cost of debt assumed at 4.0%, taxed at a 21% statutory federal rate, given AAPL's investment-grade credit profile.
  • FCF growth assumption (7.0% declining to 4.0% over 5 years, 3.0% terminal) is a modeling judgment, not a company guidance figure or analyst consensus estimate.
  • Per-share values use AAPL's most recently reported shares outstanding (~14.59B) rather than a fully diluted or forward-adjusted count.

Analysis

AAPL Free Cash Flow, FY2021–FY2025

Operating cash flow less capital expenditures, in $ millions. Source: SEC EDGAR (Apple 10-K filings).

$93.0BFY21$111.4BFY22$99.6BFY23$108.8BFY24$98.8BFY25
AAPL Free Cash Flow, FY2021–FY2025 — data table
PeriodFree Cash Flow ($M)
FY21$93.0B
FY22$111.4B
FY23$99.6B
FY24$108.8B
FY25$98.8B

WACC Build-Up (Base Case)

COST OF EQUITY (CAPM)

Risk-free rate (10Y Treasury): 4.97%

Beta (5Y): 1.09

Equity risk premium (assumed): 5.0%

Re = 4.97% + 1.09 × 5.0% = 10.42%

COST OF DEBT (AFTER-TAX)

Pre-tax cost of debt (assumed): 4.0%

Statutory tax rate: 21%

Kd = 4.0% × (1 − 0.21) = 3.16%

Weighted by AAPL's capital structure (~97.8% equity / ~2.2% debt — current market cap vs. total debt of $111.0B: $90.7B long-term + $12.4B current portion + $8.0B commercial paper, per the FY2025 10-K): WACC ≈ 10.3%

Implied Value Per Share — WACC Sensitivity

Terminal growth rate held constant at 3.0%. Current AAPL share price for reference: $331.34 (Sep 15, 2026).

WACCImplied Value / Share
9.3%$120.81
10.3% (base case)$103.58
11.3%$90.52

Key Findings

  • At the base-case 10.3% WACC and 3.0% terminal growth rate, the model implies an intrinsic value of roughly $103.58/share — well below AAPL's actual trading price of $331.34 (as of Sep 15, 2026).
  • The gap is highly sensitive to WACC: dropping the discount rate to 9.3% raises the implied value to about $120.81/share, while raising it to 11.3% lowers it to about $90.52/share — a ~33% swing from a 2-point change in WACC, which illustrates how much terminal-value assumptions dominate DCF outcomes for mature, cash-generative companies.
  • The model's conservative growth and terminal-value assumptions contribute to the gap versus the market price. The market may also be pricing in factors that a simplified free-cash-flow DCF does not fully capture (buyback-driven per-share value growth, brand/ecosystem value, services-segment margin expansion) — this model does not attempt to determine AAPL's "correct" market value.
  • Operating margin has trended upward across the five-year window (29.8% in FY2021 to 32.0% in FY2025), suggesting the underlying growth assumption could reasonably be more optimistic than the conservative case used here.

Limitations

  • This is a simplified single-stage DCF built for educational purposes — it does not incorporate segment-level modeling, buyback effects on future share count, or analyst consensus estimates.
  • Revenue, cash flow, debt, and cash figures are pulled directly from SEC EDGAR's XBRL data (sourced from AAPL's own 10-K filings); current stock price, beta, and market cap are market data (not 10-K figures) and will move daily from the stated as-of date.
  • The equity risk premium and cost of debt are standard modeling assumptions, not AAPL-specific sourced data points.
  • This analysis is not investment advice and should not be used as the basis for any investment decision.
Tools used: Excel-style modeling logic, DCF / WACC framework, Sensitivity analysisLast updated: September 2026

This independent analysis was developed for portfolio demonstration using concepts from Tazreen Islam's Finance education at UTSA. It is not an original course submission and is not investment advice or a recommendation to buy or sell any security.

AI-assisted workflow: AI tools were used to support research, model development, coding, and validation. Source data, assumptions, calculations, and conclusions were reviewed against underlying sources before publication.