DCF Studio

    MS · NYQ · Financial Services

    Morgan Stanley

    Also onShortfallConsensus DriftCrosscheck

    Implied value per share

    USD 110.27

    Market price

    USD 185.73

    Implied upside

    -40.6%

    10-year forecast · Excess returns over book equity · Base case · Price 2026-11-02 · Accounts to 2025-12-31

    NoteA financial, valued on excess returns over book equity.

    Excess Returns

    Return on equity
    14.2%
    Payout
    48%
    Cost of equity
    9.75%
    LineFY26FY27FY28FY29FY30FY31FY32FY33FY34FY35
    Opening book equityUSD 101.9bnUSD 108.9bnUSD 115.9bnUSD 122.7bnUSD 129.4bnUSD 135.8bnUSD 141.8bnUSD 147.4bnUSD 152.6bnUSD 157.1bn
    Return on equity14.2%14.2%14.2%14.2%14.2%14.2%14.2%14.2%14.2%14.2%
    Excess returnUSD 4.5bnUSD 4.8bnUSD 5.1bnUSD 5.4bnUSD 5.7bnUSD 6.0bnUSD 6.3bnUSD 6.5bnUSD 6.8bnUSD 7.0bn
    Present valueUSD 4.1bnUSD 4.0bnUSD 3.9bnUSD 3.7bnUSD 3.6bnUSD 3.4bnUSD 3.3bnUSD 3.1bnUSD 2.9bnUSD 2.7bn
    Book equityUSD 101.9bn
    Present value of excess returnsUSD 34.8bn
    Terminal, growing at 2.50%USD 38.8bn
    Equity valueUSD 175.6bn
    Per shareUSD 110.27

    Discount Rate

    Risk-free rate4.89%US 10-year Treasury (^TNX), 2026-11-02
    Equity risk premium4.23%Damodaran, January 2026
    Beta1.147Reported 1.220, pulled toward 1.0 (Blume)
    Cost of equity9.75%Risk-free + beta x equity risk premium
    Download as Excel

    Live formulas, not pasted numbers - edit a driver and the workbook reprices.

    Yahoo Finance and RBA data. General information, not advice. Methodology.