Calculating Insurance Renewal Rates: A Step-By-Step Guide

how to calculate insurance renewal rate

Renewal rates are a crucial metric for businesses, especially Software as a Service (SaaS) companies, as they provide valuable insights into customer satisfaction and loyalty. This indicator is calculated by determining the percentage of customers who actively choose to renew their subscriptions within a specific time frame. A high renewal rate signifies that customers perceive value in the services provided, while a low rate may signal potential issues with customer support, products, or the overall customer experience. To calculate the renewal rate, businesses must first establish the time period, count the number of customers who renewed their subscriptions during that period, and then divide this number by the total count of customers who had the option to renew. This formula provides the renewal rate as a percentage. Notably, the renewal rate differs from the retention rate, which focuses on customers who do not cancel their subscriptions rather than those who actively renew.

Characteristics Values
Definition Renewal rate is the percentage of customers who renew their subscriptions at the end of each period.
Formula Renewal Rate = Number of Customer Renewals ÷ Number of Customers Up for Renewal x 100
Calculation method There are two commonly used methods of calculation: count of customers and revenue methods.
Customer method suitability The count of customer method is most suitable for companies with a homogeneous customer base.
Revenue method suitability The revenue method is more suitable for companies with a diverse customer base.
Renewal rate analysis models Several different rate analysis models have been developed to determine the appropriateness of renewal rates.
Inflation adjustment An inflation adjustment is included when evaluating claims experience due to rising healthcare costs.
Group size considerations For medium and large groups, insurers base rates on the group's claims experience, while for smaller groups, only partial credibility is given to claims experience.
Manual rates Insurers' manual rates (average rate for a similar demographic group) are factored into the rate calculation for smaller groups.
Time period The time period for analysis can be monthly, quarterly, or annually.
Importance A renewal rate of 80% or higher indicates effective customer retention and is a priority for financially stable companies.

shunins

Renewal rate formula

Renewal rate is the percentage of customers who renew their subscriptions at the end of each period. It is calculated while ignoring the contract start date and only looking at the percentage of customers who re-signed when given the opportunity.

The formula for calculating the customer renewal rate is as follows:

Renewal Rate = Number of Customer Renewals ÷ Total Number of Customers Up for Renewal

For example, if a company has 100 customers coming up for renewal at the end of the month, and 90 of those customers decided to extend their subscriptions, the renewal rate would be 90%.

The renewal rate can also be calculated by replacing the customer count with the value of each contract. This is known as the gross renewal rate, which measures the percentage of total revenue that is successfully renewed, excluding upsells and expansions.

The formula for calculating the gross renewal rate is as follows:

Gross Renewal Rate = Renewed Revenue ÷ Total Revenue Eligible for Renewal x 100

For example, if a company had $500,000 in revenue eligible for renewal at the beginning of the period, and by the end of the period, $400,000 of that revenue was successfully renewed, the gross renewal rate would be 80%.

There are also other types of renewal rates that can be calculated, such as the net renewal rate, logo renewal rate, and monthly recurring revenue (MRR) renewal rate. The net renewal rate reflects the percentage of total revenue retained, including renewals and any additional revenue from upsells or expansions. The logo renewal rate indicates the percentage of customers (accounts) who renew their contracts. The MRR renewal rate is the percentage of MRR kept through renewals over time and is important for SaaS companies as it shows contract value over the number of accounts.

In the context of insurance, renewal rates are determined by evaluating a group's past experience and allowing for expected future claim trends. The incurred loss ratio, which is the ratio of incurred claims to paid premiums during the policy year, is a key component of this formula. Insurers also consider inflation trends and adjust past experience figures to account for the expected rise in future claim costs.

shunins

Renewal rate calculation methods

Customer Renewal Rate Calculation

The customer renewal rate is calculated by dividing the number of customers who renew their contracts or subscriptions by the total number of customers who had the opportunity to renew during the specified period. This formula can be expressed as:

> Customer Renewal Rate = Number of Customer Renewals / Total Number of Customers Up for Renewal x 100

For example, if a SaaS company has 100 customers with subscriptions ending in a month, and 90 of them choose to renew, the renewal rate would be 90%. This method focuses on the count of customers and is suitable for companies with a homogeneous customer base.

Revenue Renewal Rate Calculation

The revenue renewal rate, also known as the net renewal rate, takes a slightly different approach. This method calculates the value of contracts renewed rather than simply counting the number of customers. It considers the revenue retained from existing customers, including cross-sells and upsells, while excluding churned customers. The formula for the revenue renewal rate can be expressed as:

> Net Renewal Rate = Renewed Revenue + Expansion Revenue / Total Revenue Eligible for Renewal x 100

For instance, if a company renews $850,000 worth of contracts and upsells an additional $150,000 in expansions, with a total revenue eligible for renewal of $1 million, their net renewal rate would be 100%. This method is more applicable to companies with a diverse customer base, where contract values vary significantly.

Gross Renewal Rate Calculation

The gross renewal rate measures the percentage of total revenue retained from existing customers, excluding any additional revenue from upsells or cross-sells. This metric provides insight into the core revenue generated from renewals alone. The formula for the gross renewal rate is calculated as follows:

> Gross Renewal Rate = Renewed Revenue / Total Revenue Eligible for Renewal x 100

For example, if a SaaS company has $500,000 in revenue eligible for renewal and successfully renews $400,000 of that revenue, their gross renewal rate would be 80%. This indicates that the company retained 80% of the total amount up for renewal.

Monthly Recurring Revenue (MRR) Renewal Rate Calculation

The MRR renewal rate is particularly relevant for SaaS companies with monthly subscription plans. It calculates the percentage of monthly recurring revenue retained through renewals, providing a shorter-term view of the company's performance. The formula for the MRR renewal rate is as follows:

> MRR Renewal Rate = Renewed MRR / Total MRR Eligible for Renewal x 100

For instance, if a company has $400,000 in MRR eligible for renewal and renews $350,000 of that amount, their MRR renewal rate would be 87.5%. This metric is valuable for understanding the stability of monthly income and the impact of renewals on it.

Group Insurance Renewal Rate Factors

In the context of group insurance, renewal rates are influenced by various factors. Insurers consider the group's claims experience, adjusting for inflation and trends to account for rising healthcare costs. They also factor in the group's demographics and the incurred loss ratio, which is the ratio of incurred claims to paid premiums during the policy year. Additionally, the insurer's manual rates, or average rates for similar groups, are taken into account when determining renewal rates for smaller groups with limited claims history.

shunins

Renewal rate and customer retention

Renewal rates and customer retention are key metrics for understanding customer success and business health. A renewal rate of 80% or higher is generally considered positive, indicating good customer retention. Conversely, a lower renewal rate may signal issues with customer support, products, or the overall customer experience.

Calculating Renewal Rates

The renewal rate is the percentage of customers who renew their subscriptions within a given time frame. This is calculated by dividing the number of customers who renewed by the total number of customers who had the opportunity to renew, then multiplying that number by 100 to get a percentage. For example, if 180 customers out of 250 renewed their subscriptions, the renewal rate would be 72%.

The renewal rate formula can be applied to various scenarios, such as gross revenue, net revenue, monthly revenue, and the number of customer accounts (logos). The net renewal rate considers both renewed revenue and expansion revenue, providing insight into the combined impact of renewals and upsells. The logo renewal rate focuses on the percentage of customers who renew their contracts.

Calculating Customer Retention Rates

While renewal rates focus on subscription renewals, customer retention rates consider the percentage of existing customers who continue using a product or service over a specific period. To calculate the retention rate, you subtract the number of new customers acquired during that period from the total number of paying customers, then divide that figure by the total number of customers at the start of the period.

For example, if a company starts with 1000 customers, loses 100, but gains 200 new customers, the retention rate would be ((1100-200)/1000) x 100 = 90%. Deducting new customers from the calculation provides an accurate view of churned customers and ensures that high acquisition rates do not mask churn issues.

Improving Renewal and Retention Rates

To enhance renewal and retention rates, companies can employ several strategies. Gathering and analyzing customer data through surveys, trend reports, and user behaviour analytics can help personalize the customer experience and increase retention. Additionally, understanding customer needs and preferences enables companies to develop effective retention strategies and improve product features valued by customers.

For insurance-specific renewal rate calculations, factors such as group size, claims experience, incurred loss ratio, inflation adjustments, and premium adjustments are considered. Insurers use these components to evaluate renewal rate structures and determine appropriate rates for health plans and other benefits.

shunins

Renewal rate analysis models

Data Sources for Analysis

To effectively analyse renewal rates, insurers collect and utilise various data sources. These include policyholder data, such as demographics, policy type, premium amount, and payment frequency. Additionally, policy renewal data, including renewal dates and rates across different policy types and segments, is crucial for understanding renewal patterns. Historical persistency data, segmented into specific time periods (e.g., 13-month, 25-month, 37-month persistency rates), provides insights into long-term trends. Distribution channel data is also analysed to understand the correlation between persistency and sales methods or intermediaries.

Market Surveys and Demographics

Conducting comprehensive market surveys every few years, along with analysing changes in group demographics, helps insurers maintain competitive pooled rates. This allows them to adjust their rates based on the market dynamics and evolving customer characteristics.

Claims Experience and Manual Rates

For medium and large groups, insurers typically base their renewal rates on the group's claims experience. However, for smaller groups with limited claims history, only partial credibility is given to claims experience, and manual rates come into play. Manual rates refer to the average rates for groups with similar demographics and are factored into the rate calculation.

Inflation Adjustments

Due to rising healthcare costs, it is essential to adjust past experience figures to account for future claim costs. An inflation adjustment is included when evaluating claims experience, as the inflation rate for health benefits tends to be higher than the general Consumer Price Index (CPI) Trend.

Model C: Weighted Credibility Analysis

One specific model mentioned is Model C, which applies different weights to each year's experience. In this model, 50% credibility is given to the most recent year's experience, 30% to the previous year, and 20% to the experience from two years prior. This approach helps smooth out fluctuations and identifies more stable trends.

Strategies for Improving Renewal Rates

Insurers employ various strategies to enhance renewal rates and retention. These include simplifying the renewal process, offering incentives like loyalty discounts, and analysing customer feedback to address concerns. Additionally, targeted retention campaigns and predictive modelling to identify at-risk customers are also utilised.

shunins

Renewal rate and insurance groups

Renewal rates are an important metric for insurance companies as they ensure recurring revenue and predictability in revenue. A high renewal rate is an indicator of customer satisfaction and value.

When it comes to insurance groups, renewal rates are calculated based on a group's claims experience. For medium and large groups, insurers base rates on the group's claims experience, while for smaller groups, other factors such as the insurer's manual rates and the group's demographics are also considered. The insurer's manual rates refer to the average rate for a group with similar demographics.

Insurers also take into account macroeconomic factors that affect the entire insurance industry, such as changes in prescription drug costs or government-mandated benefits. They adjust rates annually to reflect their understanding of each group's situation and these broader trends.

Additionally, insurance companies estimate the likelihood of a person or group incurring healthcare expenses by considering factors such as age, gender, and area of residence. This information helps them provide accurate rates upfront and formulate a stable baseline for the cost of coverage.

To calculate the renewal rate, one can use the following formula:

Renewal Rate = # of Contract Renewals / # of Contracts For Renewal x 100

For example, if there are 250 contracts up for renewal and 180 of those customers renew, the renewal rate would be:

180 (renewals) / 250 (contracts up for renewal) x 100 = 72% renewal rate

A renewal rate of 80% or higher is generally considered a positive indicator of customer retention.

Frequently asked questions

The formula for calculating the customer renewal rate is: Renewal Rate = Number of Customer Renewals / Number of Customers Up for Renewal x 100.

There are several types of renewal rates, including gross renewal rate, net renewal rate, logo renewal rate, and monthly recurring revenue renewal rate.

The renewal rate is the percentage of customers who actively chose to renew their contracts, whereas the retention rate considers customers who did not cancel their subscriptions. The renewal rate is calculated for each subscription period, while the retention rate can be calculated for multiple periods.

For medium and large groups, insurers typically base renewal rates on the group's claims experience. Insurers also consider their manual rates, which are the average rates for groups with similar demographics. Other factors include incurred loss ratios, inflation adjustments, and expected future claim trends.

Written by
Reviewed by
Share this post
Print
Did this article help you?

Leave a comment