Skip to content
TheChatArchiveThe Chat Archive
gpt-4.1-mini-2025-04-14· OpenAIHugging Face LMArena Human Preference 140K

in building a fundamental database for equity investors - how do i calculate EPS growth,…

From a Chatbot Arena battleThe same person sent this prompt to two anonymous models at once. Compare it with Qwenqwen3-30b-a3b’s answer.
  1. User

    in building a fundamental database for equity investors - how do i calculate EPS growth, knowing that some companies have negative eps in the past, some have negative in the future etc. - ie. growth from positive to positive is clear, but negative to negative, negative to positive is quite a problem

  2. Assistant

    Great question! Calculating EPS growth when EPS values can be negative or cross zero is tricky because the usual percentage growth formula:

    [ \text{EPS Growth} = \frac{\text{EPS}{t} - \text{EPS}{t-1}}{|\text{EPS}_{t-1}|} ]

    can produce misleading or undefined results (division by zero, or nonsensical large negative growth).


    Challenges with EPS Growth Calculation

    • Positive to positive EPS: straightforward percentage growth.
    • Negative to negative EPS: percentage growth is ambiguous (e.g., from -1to−1 to -2, is that growth or decline?).
    • Negative to positive EPS: growth from a loss to profit — percentage growth is not meaningful (division by negative number).
    • Positive to negative EPS: similarly problematic.

    Recommended Approaches for EPS Growth in a Fundamental Database

    1. Use Absolute Change Instead of Percentage Growth

    Calculate the absolute change in EPS:

    [ \Delta \text{EPS} = \text{EPS}{t} - \text{EPS}{t-1} ]

    • This avoids division by zero or negative base issues.
    • You can track whether EPS improved or deteriorated by the sign of the change.
    • Useful for flagging trends without misleading percentages.

    2. Use a Modified Growth Metric with Sign Handling

    Define growth as:

    [ \text{EPS Growth} = \frac{\text{EPS}{t} - \text{EPS}{t-1}}{\max(|\text{EPS}_{t-1}|, \epsilon)} ]

    where (\epsilon) is a small positive number (e.g., 0.01) to avoid division by zero.

    • This caps extreme growth rates when EPS is near zero.
    • Still problematic if EPS changes sign, but less volatile.

    3. Use Logarithmic Growth for Positive EPS Only

    For positive EPS values only, use log growth:

    [ \text{Log EPS Growth} = \ln(\text{EPS}{t}) - \ln(\text{EPS}{t-1}) ]

    • This is symmetric and scale-invariant.
    • But only valid if both EPS values are positive.
    • For negative or zero EPS, this is undefined.

    4. Categorize EPS Transitions

    Create a categorical variable to capture EPS sign transitions:

    Previous EPSCurrent EPSCategory
    PositivePositivePositive to Positive
    PositiveNegativePositive to Negative
    NegativePositiveNegative to Positive
    NegativeNegativeNegative to Negative
    ZeroAnyZero to Any
    AnyZeroAny to Zero
    • Use this to flag and treat growth calculations differently.
    • For example, report absolute change or mark as "transition" cases.

    5. Use Median or Average Growth Over Multiple Periods

    • Calculate growth over multiple years to smooth volatility.
    • For example, use CAGR (Compound Annual Growth Rate) over 3-5 years, but only if EPS remains positive throughout.
    • If EPS crosses zero, report "N/A" or use absolute change.

    Summary Table of EPS Growth Calculation Methods

    MethodProsConsWhen to Use
    Percentage GrowthIntuitive for positive EPSMisleading or undefined with negatives or zeroPositive to positive EPS only
    Absolute ChangeSimple, no division issuesNot scale-invariantAll cases
    Modified Growth with EpsilonAvoids division by zeroStill tricky with sign changesWhen EPS near zero
    Logarithmic GrowthSymmetric, scale-invariantOnly for positive EPSPositive EPS only
    Categorical Transition FlagsHelps identify problematic casesRequires manual handlingFor data quality and analysis

    Practical Implementation Tips

    • Store raw EPS values and store growth metrics separately.
    • For growth metrics, flag cases where EPS crosses zero.
    • Consider reporting multiple growth metrics (absolute change + percentage growth where valid).
    • Document your methodology clearly for users of the database.

    If you want, I can help you with a sample Python or Excel formula to implement these approaches! Would you like that?

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.