Months Over Months: How to Calculate Growth

This calculator works out the month-over-month (MoM) percentage change between two values, such as revenue, website traffic, or inventory. You enter the previous month’s value and the current month’s value, and you get the percentage change, plus the absolute difference. This is the standard way to measure short-term growth or decline in business and finance.

Formula

The month-over-month growth rate is calculated with this formula:

MoM Change (%) = (Current Month Value − Previous Month Value) ÷ Previous Month Value × 100

Where:

• Previous Month Value – the figure from the earlier month (e.g., January revenue)
• Current Month Value – the figure from the later month (e.g., February revenue)
• MoM Change – the percentage increase or decrease from the previous month to the current month

The absolute change is simply the current value minus the previous value. A positive result means growth, a negative result means a decline.

Worked Example

Using the default values from the calculator above:

• Previous Month Value = 1,000
• Current Month Value = 1,200

Step 1: Subtract the previous value from the current value.
1,200 − 1,000 = 200

Step 2: Divide the difference by the previous value.
200 ÷ 1,000 = 0.2

Step 3: Multiply by 100 to get the percentage.
0.2 × 100 = 20%

So the month-over-month change is +20%, and the absolute change is +200. This matches the calculator’s output.

When to Use Month-Over-Month

Month-over-month analysis is useful for spotting short-term trends in metrics that you track regularly. Common uses include:

• Revenue and sales tracking
• Website traffic and user signups
• Inventory levels and stock movement
• Marketing campaign performance
• Expense monitoring

Because it compares only two adjacent months, MoM is sensitive to seasonal effects. For example, retail sales often spike in December and drop in January. A single MoM figure can look alarming when it is just the normal seasonal pattern. For that reason, MoM is best used alongside year-over-year (YoY) comparisons, which compare the same month in different years and remove seasonality.

How to Read the Result

A positive percentage means the current month is higher than the previous month. A negative percentage means it is lower. A result of 0% means no change. The larger the absolute percentage, the more dramatic the swing.

For example, a MoM change of +5% on revenue of $10,000 means you added $500. The same +5% on $1,000,000 means you added $50,000. Always look at the absolute change alongside the percentage to understand the scale of the movement.

Common Mistakes

• Dividing by the current month instead of the previous month. The denominator must always be the earlier value. Dividing by the current value gives a different number and is not the standard MoM growth rate.
• Swapping the order of subtraction. Always do current minus previous, not the other way around. Reversing them flips the sign and turns growth into decline.
• Forgetting to multiply by 100. The raw fraction (0.2) is not the percentage (20%). The calculator does this for you, but if you compute by hand, do not skip this step.
• Using inconsistent units. If last month’s figure is in thousands and this month’s is in single units, the result will be nonsense. Make sure both values are in the same unit.
• Ignoring zero or missing values. If the previous month is zero, the formula divides by zero and cannot produce a meaningful percentage. In that case, report the absolute change only.

Tips

• Use at least three months of data to see whether a change is a one-off or a trend.
• Pair MoM with year-over-year (YoY) growth to separate seasonal effects from real growth.
• Round to one or two decimal places for reporting; more precision is usually noise.
• If you are comparing multiple months in a row, calculate each adjacent pair separately rather than comparing every month to the first one.
• For very large numbers, consider using thousands or millions as the unit to keep the figures readable.

Troubleshooting

The result shows “Cannot compute”. This happens when the previous month’s value is zero, because dividing by zero is undefined. Check that you entered a non-zero previous value. If the previous value truly was zero, you cannot calculate a percentage change; report the absolute change instead.

The percentage looks too large. This is common when the previous month’s value is small. For example, going from 10 to 20 is a 100% increase. The math is correct, but the percentage can be misleading for small bases. Mention the absolute numbers when reporting.

The sign is wrong. Double-check that you entered the previous month in the first field and the current month in the second. If you swapped them, the sign flips.

The result does not match my spreadsheet. Verify that your spreadsheet formula is (current − previous) / previous × 100. Some spreadsheet tools have a built-in percentage change function that may use a different convention. Also confirm that your spreadsheet cells are formatted as numbers, not text.

Negative previous value. If the previous month’s value is negative (e.g., a loss), the percentage change formula still works mathematically but is hard to interpret. For example, going from −100 to −50 is a +50% change, but the meaning is different from going from 100 to 150. In such cases, it is often clearer to report the absolute change and describe the situation in words.

Frequently Asked Questions

What is the difference between MoM and YoY growth?
MoM compares one month to the immediately preceding month. YoY compares a month to the same month in the previous year. YoY removes seasonal patterns, while MoM shows the most recent short-term movement.

Can MoM be negative?
Yes. A negative MoM means the current month’s value is lower than the previous month’s. For example, a −10% MoM change means you lost 10% relative to last month.

How do I calculate MoM growth over several months?
Calculate each adjacent pair separately. For January to February, use those two values. For February to March, use those two. Do not compare March directly to January unless you specifically want a two-month change, which is a different metric.

What if the previous month is zero?
You cannot calculate a percentage change because division by zero is undefined. Report the absolute change instead, or use a different baseline such as the average of several prior months.

Is MoM the same as a growth rate?
MoM is one type of growth rate, specifically the growth rate over a one-month period. There are also weekly, quarterly, and annual growth rates. The formula structure is the same; only the time period changes.

Should I use MoM for seasonal businesses?
MoM is still useful, but be aware that seasonal swings will dominate the numbers. For seasonal businesses, YoY is usually more informative for long-term trends, while MoM can still help with short-term operational decisions.

Related

• 90 180 Day Calculator: Count Days Between Dates
• How to Calculate Days Old
• 8 Hour Shift End Calculator: Finish Time

in prev | Previous Month Value | - | 1000 | 0 | 1000000000
in curr | Current Month Value | - | 1200 | 0 | 1000000000
out mom | MoM Change | % | (curr - prev) / prev * 100 | 2
out diff | Absolute Change | - | curr - prev | 2