Question 1

What is year-over-year growth?

Accepted Answer

Year-over-year growth is the percentage change in a metric compared to the same period one year prior. It is used to measure performance trends while accounting for seasonality.

Question 2

How do you calculate year-over-year growth in Excel?

Accepted Answer

Use =((B2-B1)/B1)*100 where B1 is last year's value and B2 is this year's. Alternatively, use =(B2/B1)-1 and format the cell as a percentage.

Question 3

Is 40% year-over-year growth good?

Accepted Answer

For mid-stage SaaS companies ($10M to $50M ARR), 40% YoY is considered strong and aligns with the Rule of 40. Early-stage startups are typically expected to grow faster, while for mature public companies, 40% would be exceptional.

Question 4

How do you calculate sales growth year-over-year?

Accepted Answer

Use the same formula: ((Current Year Sales − Previous Year Sales) / Previous Year Sales) × 100. For example, if sales grew from $2M to $2.4M, the YoY growth rate is 20%. Always compare the same time period.

Question 5

Can year-over-year growth be negative?

Accepted Answer

Yes. If the current period value is lower than the previous year, the result will be negative. For example, a YoY growth rate of -15% means the metric declined by 15% compared to the same period last year.

Year-Over-Year Growth Calculator, Formula & Examples

Year-Over-Year Growth Calculator, Formula & Examples

Related articles

Why We're Open Sourcing OpenUI

What Is an AI Agent Builder, How It Works, & How to Build One

AI Copilots: A Complete Guide to Intelligent Assistance

What Are AI Agents: Types, Capabilities, and Real-World Use

Top LLMs 2025: Understanding the Models Behind Modern AI Systems

ChatKit: What It Is, What It Isn’t, and Where C1 Fits In

PowerPoint Automation Reimagined with C1 Artifacts API

The Future of AI Interfaces is Generative

MCP UI: Making AI Apps Interactive

What Is AG-UI and Why It Matters for AI-Native User Interfaces

How to design AI-Native Conversational Interfaces : From Templates to Generative UI

GPT 5 vs. GPT 4.1

How to Build Generative UI Applications

Implementing Generative Analytics with Thesys and MCP

Evolution of Analytics: From Static Dashboards to Generative UI

Why Generating Code for Generative UI is a bad idea

Building the First Generative UI API: Technical Architecture and Design Decisions Behind C1

How we evaluate LLMs for Generative UI

Generative UI vs Prompt to UI vs Prompt to Design

Generative UI: What It Is and Why It Matters