kpi-calculator

What problem does it solve?

This Skill automates the complex and precise calculation of 16 core car insurance Key Performance Indicators (KPIs) from cumulative weekly CSV data. It eliminates manual spreadsheet errors and ensures consistent, accurate metrics for business performance evaluation, saving significant time for financial analysts.

Core Features & Use Cases

• 16 Core KPI Calculations: Accurately computes critical metrics like Matured Margin Contribution Rate, Premium Time Progress Achievement Rate, Matured Loss Ratio, and Average Premium per Policy.
• Cumulative & Incremental Modes: Supports both year-to-date cumulative data processing and week-over-week incremental analysis, with clear rules for ratio calculations.
• Robust Data Handling: Accepts raw CSV data, performs necessary aggregation, and applies safe division for robust results.
• Standardized Output: Generates a clear, structured Markdown report of all KPIs, including calculation verifications.
• Use Case: A finance team needs to quickly assess the weekly performance of the car insurance business. They upload the latest cumulative CSV data, and this skill instantly provides a comprehensive report of all 16 KPIs, highlighting key financial and operational metrics without any manual calculation.

Quick Start

Calculate the KPIs for the attached 'weekly_cumulative_data.csv' file.