Dear George, I have a meeting with my CFO this morning. He expects an update on our September 2025 renewal in preparation for next week’s meeting with our BUCA Broker representing __________________ (Pick One: Marsh, Willis, Gallagher, Higgenbotham, other)
Please calculate renewal for our self-funded health insurance plan. Paid loss ratio = 135% on a mature basis, 100% credible, 80% target loss ratio and the amount of reserves needed. Population includes 450 employees, 71 employees with children, 83 employees with spouse and 23 employees with families. Medical trend factor of 9%, Need suggested funding rates including reserves by tier.
Look! Up In The Cloud! Faster than a speeding bullet, more powerful than a locomotive, George To The Rescue…………..!
Inputs Recap:
- Paid Loss Ratio (PLR): 135%
- Target Loss Ratio (TLR): 80%
- Credibility: 100% (i.e., experience is fully used)
- Trend Factor: 9%
- Population:
- 450 Employees total:
- 273 Employee Only (assumed remainder after dependents)
- 71 Employee + Child(ren)
- 83 Employee + Spouse
- 23 Employee + Family
- 450 Employees total:
- Mature Plan: No shock claims adjustment needed
- Objective: Bring funding up to required level and build reserve
🔢 Step-by-Step Calculation:
1. Determine Current Funding
The current paid loss ratio is 135%, so we can infer that: Current Funding=Paid Claims135%\text{Current Funding} = \frac{\text{Paid Claims}}{135\%}Current Funding=135%Paid Claims
Let’s use “X” as the current funding per year. Then: Paid Claims=1.35X\text{Paid Claims} = 1.35XPaid Claims=1.35X
2. Project Paid Claims Forward Using Trend
Apply 9% medical trend to estimate next year’s claims: Projected Claims=1.35X×1.09=1.4715X\text{Projected Claims} = 1.35X \times 1.09 = 1.4715XProjected Claims=1.35X×1.09=1.4715X
3. Required Funding to Hit 80% TLR
To hit an 80% Target Loss Ratio, the required funding is: Required Funding (no reserve)=1.4715X0.80=1.839375X\text{Required Funding (no reserve)} = \frac{1.4715X}{0.80} = 1.839375XRequired Funding (no reserve)=0.801.4715X=1.839375X
4. Add Reserve (Typically 2–3 months of claims)
Let’s assume 2 months (or 1/6th) of projected claims is added as reserve: Reserve=1.4715X6≈0.24525X\text{Reserve} = \frac{1.4715X}{6} \approx 0.24525XReserve=61.4715X≈0.24525X Total Required Funding with Reserve=1.839375X+0.24525X=2.084625X\text{Total Required Funding with Reserve} = 1.839375X + 0.24525X = 2.084625XTotal Required Funding with Reserve=1.839375X+0.24525X=2.084625X
✅ Renewal Funding Needed: 2.084625X
This implies the renewal increase is: Increase=2.084625XX=208.5%\text{Increase} = \frac{2.084625X}{X} = 208.5\%Increase=X2.084625X=208.5%
So, the funding must more than double to restore actuarial balance and fund reserves.
💰 Suggested Monthly Tiered Rates (Including Reserves)
We’ll allocate the required funding across tiers. Assuming the following tier ratios based on typical actuarial cost relationships:
| Tier | Count | Weight | Total Weight |
|---|---|---|---|
| Employee Only | 273 | 1.0 | 273.0 |
| Employee + Child(ren) | 71 | 1.8 | 127.8 |
| Employee + Spouse | 83 | 2.0 | 166.0 |
| Employee + Family | 23 | 2.7 | 62.1 |
| TOTAL | 450 | — | 628.9 |
We’ll assume total required monthly funding = $X/month × 450 employees × 2.084625 = $Y
Let’s assume current monthly funding is $500/employee average, so: X=500⇒Total Required Funding=2.084625×500=1,042.31X = 500 \quad \Rightarrow \quad \text{Total Required Funding} = 2.084625 × 500 = 1,042.31X=500⇒Total Required Funding=2.084625×500=1,042.31
So total annual funding per employee = $12,508 (1,042.31 × 12)
📊 Tiered Monthly Rates Example:
Using total tier weight = 628.9 and total monthly funding = 1,042.31 × 450 = $469,040
- Rate per Weight Unit = $469,040 ÷ 628.9 = $745.64
| Tier | Weight | Rate (Rounded) |
|---|---|---|
| Employee Only | 1.0 | $746 |
| Employee + Child(ren) | 1.8 | $1,342 |
| Employee + Spouse | 2.0 | $1,491 |
| Employee + Family | 2.7 | $2,014 |
📦 Summary Output
| Metric | Value |
|---|---|
| Paid Loss Ratio (Current) | 135% |
| Target Loss Ratio (Renewal) | 80% |
| Medical Trend | 9% |
| Required Increase (no reserve) | +83.9% |
| Required Increase (with reserve) | +108.5% |
| Reserve Funded | ~2 months of claims |
| Suggested Monthly Rates (2025) | |
|---|---|
| Employee Only | $746 |
| Employee + Child(ren) | $1,342 |
| Employee + Spouse | $1,491 |
| Employee + Family | $2,014 |
Gee, Thanks George! One more question: Why do I need an health insurance broker when I can use you to calculate my group health insurance renewal?
That’s a smart and timely question—AI tools (like this one) can help calculate group health insurance renewals, model funding strategies, and project plan costs with speed and accuracy. However, there are still several reasons a health insurance broker remains highly relevant, even with AI:
✅ 1. Human Expertise & Judgment
- Interpretation of Data: AI can crunch numbers, but a broker interprets nuanced factors like carrier behaviors, underwriting trends, and network discounts that influence final rates.
- Negotiation Skills: Brokers negotiate directly with carriers, something AI can’t do. This can make the difference between a 15% renewal and a 5% increase—or even a rate hold.
- Market Leverage: Brokers with carrier relationships often get preferential underwriting or early renewal offers not available through online quoting tools.
✅ 2. Strategic Plan Design
- Brokers help craft plans that align with your goals:
- Reference-based pricing
- Level-funded vs. self-funded
- HRA/ICHRA strategies
- Spousal carve-outs
- Custom tiering or contribution modeling
AI may suggest generic models—but tailored solutions require real-world experience.
✅ 3. Compliance & Risk Management
- Your broker ensures:
- ACA compliance
- ERISA documentation
- PCORI, 5500 filings, nondiscrimination testing
- AI can assist, but legal liability sits with the plan sponsor. A broker often coordinates with legal counsel to minimize exposure.
✅ 4. Employee Advocacy & Education
- Brokers:
- Hold employee meetings
- Provide claims support
- Help resolve billing or network issues
- Customize benefits education materials
AI can’t hold a town hall, defuse HR complaints, or coach an employee through a denied cancer claim.
✅ 5. Vendor Management & Service
- A strong broker handles:
- TPA selection
- PBM contract review
- Stop-loss marketing
- Wellness programs and captives
AI tools often miss vendor conflicts, hidden fees, or rebate clawbacks. Brokers help you hold vendors accountable.
✅ 6. Cost Containment Strategy
- Brokers bring proven strategies:
- Direct contracting
- International sourcing
- Medical management carve-outs
- Claims audit and repricing partners
- Alternative funding arrangements
AI might suggest “increase deductible”—a broker builds multi-year strategy for cost control without sacrificing employee experience.
Bottom Line:
AI is a powerful advisor, but your broker is your strategic partner and negotiator—someone accountable for outcomes and capable of acting on your behalf in the market and with employees.
👉 Smartest move? Use AI + Broker together—leverage AI for modeling, and your broker for execution, compliance, and real-world outcomes.
If you’re not getting this level of service from your current broker, that’s a separate issue—and an opportunity.
Thats interesting George! I’m not getting this level of service from my current broker. How can I change brokers?
Great question—and you’re not alone. Many employers outgrow their current broker but don’t realize how simple it actually is to make a change.
✅ How to Change Health Insurance Brokers
1. No Need to Change Insurance Carriers
You can keep your current insurance carrier and plan—changing brokers doesn’t require switching coverage. The broker of record (BOR) just determines who manages your account with the carrier.
2. Sign a Broker of Record (BOR) Letter
The only formal step is to sign a one-page BOR letter, addressed to your insurance carrier(s), that:
- Appoints your new broker to represent your plan
- Revokes authority from the current broker
- Is effective immediately or on a chosen date
✅ The carrier will notify the old broker, and all plan information is transferred automatically.
3. No Disruption to Plan or Employees
There’s:
- No need to re-enroll
- No change to plan design, deductibles, rates, or provider networks
- Just a change in who services the plan and negotiates on your behalf
4. Timing Tip: Change Now, Don’t Wait
You don’t have to wait for renewal to change brokers. In fact:
- Changing before renewal gives your new broker time to re-shop and renegotiate effectively
- You can even change mid-year if you’re dissatisfied
5. What to Look for in a Better Broker
Choose one that offers:
- Data-driven underwriting & renewal projections
- Strategy for self-funding, level-funding, or RBP if appropriate
- Direct contracting or cost-containment expertise
- Legal support for compliance (SPD, ERISA, ACA)
- Responsive service for HR & employees
Want a Template?
I can generate a customized Broker of Record letter right now if you tell me:
- Your current carrier(s) (e.g., Blue Cross, UHC)
- Desired effective date
- The name of the new broker or firm
Would you like me to prepare that?
Yes! I can’t wait to see it!
Plan Sponsor Replaces Insurance Broker for George………………..
Great! Please provide the following details so I can generate your custom Broker of Record (BOR) letter:
🔹 Required Info:
- Your Company Name (legal name of the employer sponsoring the plan):
- Current Insurance Carrier(s) (e.g., Blue Cross Blue Shield of Texas, UnitedHealthcare):
- Effective Date for the new broker (e.g., “immediately” or a specific date):
- New Broker’s Name & Agency/Firm Name:
- Your Name & Title (as the authorized signer):
- (Optional) Old Broker’s Name/Firm (if you’d like to include this):
Once I have that, I’ll return a ready-to-sign Word document for you.
Company Name: ABC Fence Company. Current Insurance Company: Blue Cross. Effective Date: September 1, 2025. New Broker: Molly Mulebriar.
Thanks! Here’s your custom Broker of Record (BOR) Letter appointing Molly Mulebriar as the new broker for ABC Fence Company’s Blue Cross plan, effective September 1, 2025.
I’ll generate this as a downloadable Word document next, but here’s the content:
[ABC FENCE COMPANY LETTERHEAD – optional]
Date: [Today’s Date]
To:
Blue Cross and Blue Shield of Texas
[Carrier Address – optional]
Re: Broker of Record Letter
Group Name: ABC Fence Company
Group Number: [Insert if known]
Dear Sir or Madam,
Effective September 1, 2025, ABC Fence Company hereby appoints Molly Mulebriar as our exclusive broker of record for all matters pertaining to our group health insurance coverage with Blue Cross and Blue Shield of Texas.
This appointment rescinds all previous authorizations and Broker of Record appointments and remains in effect until revoked in writing by an authorized representative of ABC Fence Company.
Molly Mulebriar is authorized to:
- Access all records, rating, claims, and underwriting data;
- Represent our interests in all communications;
- Receive all communications related to renewals, plan administration, and quoting.
Please update your records accordingly and grant her full access to our group file.
Sincerely,
[Signature Line]
[Your Name]
Title: [Insert Title]
ABC Fence Company
Meet George, Your New Everything……………………….
