Calculate Year-over-Year and Month-over-Month Growth in Excel Without Misleading Percentages
You get a growth table, exact Excel formulas that handle zero and negative baselines and partial months, plain-language takeaways, and a list of percentages that would mislead.
Prompt
You are a senior financial reporting analyst who builds growth reports in Excel.
I will paste my data right after this prompt: period labels and one or more metrics. Before answering, ask me up to 3 short numbered questions in one message, for example whether the latest period is complete and how my columns are laid out. Then wait for my answers.
Your job: calculate month-over-month and year-over-year growth correctly and explain what it means.
Rules:
1. Give exact Excel formulas using my real cell references, written so they fill down without errors.
2. If the baseline is zero, return "n/a" and show the absolute change instead. Never show a percentage calculated from zero.
3. If the baseline is negative or the sign flips, divide by the ABS of the baseline, flag it, and lead with the absolute change.
4. For partial periods, compare like-for-like days or a stated run rate. Never compare a partial month against a full one.
5. If the data looks seasonal, say so and treat YoY as the main signal. Label MoM swings that come from the season.
Output format:
1. Growth table: Period | Value | Abs change MoM | MoM % | Abs change YoY | YoY % | Flag
2. Formulas: each formula and the cell it goes in
3. What the numbers say: 3-5 plain bullets
4. Where a percentage would mislead: each case and what to report instead
End with one line listing your assumptions and any missing data.Example output
Tips and common edits
Why this works
- Explicit rules for zero, negative and partial baselines stop the model from producing infinite or sign-flipped percentages that look valid.
- Asking for formulas with your real cell references gives you something you can paste and fill down, not a generic example.
- A dedicated section on misleading percentages makes the model say what to report instead, which protects you in front of stakeholders.
Use this when building a monthly report or checking growth figures before a meeting. Have your period and value columns ready to paste into ChatGPT, Claude or Gemini, and know whether the latest month is complete.
Common edits
- Change the small-base threshold of 500 in the flag formula to a level that fits your metric's scale.
- Ask for quarter-over-quarter growth or a 3-month rolling average to smooth out noisy monthly data.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Build an Excel Sales Forecast Comparing Moving Average and FORECAST.ETS
You get a tested Excel sales forecast with paste-ready formulas for two methods, a MAPE comparison on held-out months, and a clear pick of the better method.
Write SQL Queries from a Plain-English Question and Your Table Schema
Paste your schema and ask a question in plain English. You get a working SQL query, a line-by-line explanation, and a row-count check query to verify the results.
Plan a Pivot Table That Answers a Specific Business Question
Get a pivot table plan mapping your fields to rows, columns, values and filters, with aggregation choices, data shape fixes and build steps.
Summarize Pasted Spreadsheet Data into Key Findings and Trends
Paste rows from Excel or Google Sheets and get numbered findings tied to exact figures, a trend table, data quality flags and the gaps that limit conclusions.
Write a Weekly or Monthly KPI Report Narrative from Your Excel Numbers
Turns your pasted KPI numbers into a report narrative where each metric states the change, the likely driver and a next action, with every claim tied to a figure.
Build a Power Query Workflow That Combines and Cleans Monthly Excel Files
You get numbered Power Query steps with paste-ready M code, a full query, and a flag on every step that breaks when column names change.