Skip to content

Free research worksheet

Quarterly earnings growth calculator

Compare the same financial measure across two named periods. See the absolute change alongside growth, with clear handling for zero and negative baselines.

No signup for calculations or CSV export. You enter the figures; this page does not fetch live estimates.

1. Enter comparable figures

2. Inspect the calculation

Enter figures and calculate, or load a clearly labeled example.

3. Review a source-checking question

Edit the question before opening it in FN2. Review in FN2 saves it as a draft in this browser tab; continue signup in the same tab. Copy it manually to use another tab or device. You decide when to send.

0 / 4000

Method and worked examples

The formula

Absolute change = current − prior. With a positive prior value, growth (%) = 100 × (current − prior) ÷ prior. FN2 does not display a growth percentage from zero or a negative baseline; the absolute change remains useful.

Quarter-on-quarter or year-on-year

For quarter-on-quarter growth, use the immediately preceding fiscal quarter. For year-on-year growth, use the corresponding fiscal quarter one year earlier. Name both periods. Do not compare a single quarter with a year-to-date total or mix periods of different lengths.

A worked example

Hypothetical revenue rising from 100 to 120 in identical units grows by 20, or 20%. Earnings moving from −10 to +5 improve by 15 and cross from loss to profit. Presenting that transition as ordinary percentage growth would be misleading, so this worksheet leaves the percentage unavailable.

Read beyond the percentage

Look for seasonality, acquisitions, currency effects and restatements in primary disclosures. If definitions changed, obtain a comparable series before interpreting the result. A percentage-point change in a margin is different from percentage growth in that margin; this worksheet is for changes in entered amounts.

Sources and further research

More worksheets