quarterly-kpi-calculator

Quarterly KPI Calculator

Calculates and interprets financial KPIs. P&L data is fetched from the financial MCP server or taken from figures the user provides.

Prerequisites

At minimum: Revenue and COGS (provided by user or fetched via get_financial_data). Optional: EBITDA, Operating Expenses, prior quarter Revenue for QoQ growth.

Steps

Step 1: Retrieve benchmark thresholds

Call the get_kpi_benchmarks tool to get current KPI formulas and benchmark values:

get_kpi_benchmarks()

Store the result — you will use the formulas and benchmarks in Steps 3 and 4.

Step 2: Get P&L data

If the user provided P&L figures directly (Revenue, COGS, EBITDA, Operating Expenses), use those values.

If the user specified only a quarter (e.g. "Q3 2025") without raw figures, call get_financial_data to retrieve them:

get_financial_data(period="Q3 2025")

If QoQ Revenue Growth is requested and prior quarter data is needed, call get_financial_data for the prior quarter as well:

get_financial_data(period="Q2 2025")

Step 3: Calculate KPIs

Use python_exec to calculate the following from the P&L data (use values from Step 2):

• Gross Margin % = (Revenue - COGS) / Revenue * 100
• EBITDA Margin % = EBITDA / Revenue * 100 (if EBITDA available)
• Operating Expense Ratio = Operating Expenses / Revenue * 100 (if OpEx available)
• Revenue Growth % QoQ = (Current - Prior) / Prior * 100 (if prior available)

Round all percentages to one decimal place.

Example:

revenue   = 4200000
cogs      = 1890000
ebitda    = 1260000
opex      = 1050000
prior_rev = 3800000

gross_margin  = round((revenue - cogs) / revenue * 100, 1)
ebitda_margin = round(ebitda / revenue * 100, 1)
opex_ratio    = round(opex / revenue * 100, 1)
rev_growth    = round((revenue - prior_rev) / prior_rev * 100, 1)

print(f"Gross Margin:            {gross_margin}%")
print(f"EBITDA Margin:           {ebitda_margin}%")
print(f"Operating Expense Ratio: {opex_ratio}%")
print(f"Revenue Growth QoQ:      {rev_growth}%")