Excel file for health insurance comparison

PASLAGA Posted messages 3 Status Membre -  
brucine Posted messages 24411 Registration date   Status Membre Last intervention   -

Hello,

Does anyone have an Excel file for comparing health insurance?

I don't want to go through a website because they do send offers, but mainly the different insurance companies keep calling for a subscription.

I just want to do my comparison myself, but I need a template Excel file for that.

THANK YOU FOR YOUR HELP.

NOT

4 réponses

jee pee Posted messages 9403 Registration date   Status Modérateur Last intervention   9 948
 

Hello,

Someone needs to keep an Excel list updated with the different health insurances and especially the various options. I don't know if anyone is doing that.

A few months ago, I had to insure a car. Knowing that email and phone would be used for various follow-ups, I created a temporary email address, got a virtual phone number for a month, and provided a made-up name, first name, and address. With these elements, I used insurance comparison tools and the websites of the companies to get quotes, without being flagged and spammed afterward.


1
Raymond PENTIER Posted messages 58548 Registration date   Status Contributeur Last intervention   17 474
 

Hello.

I invited PASCALOU to join your request and contribute to your discussion, as your topic is the same.

https://forums.commentcamarche.net/forum/affich-37682193-modele-fichier-excel-comparateur-mutuelle#p37682212

In any case, we don't have a template to distribute!


Retirement is great! Especially in the Antilles...
Raymond (INSA, AFPA)

0
jee pee Posted messages 9403 Registration date   Status Modérateur Last intervention   9 948
 

Hello Raymond,

PASCALOU and PASLAGA are one and the same person. The former asks his question as a non-member, and after registering, he asks the same (or similar) question under his brand new member pseudonym.

0
PASLAGA Posted messages 3 Status Membre > jee pee Posted messages 9403 Registration date   Status Modérateur Last intervention  
 

That's correct, I hadn't registered on the forum yet.

I'm going to try to create a comparison file.....

Thank you

0
Raymond PENTIER Posted messages 58548 Registration date   Status Contributeur Last intervention   17 474
 

Not possible!

Dear friend jee pee, you can imagine that I understood that ...

But I was looking for a way for him to react himself by providing this explanation and asking for the first discussion to be deleted, the one signed PASCALOU ...

And if PASLAGA knew the number of health insurance policies, mutuals, banks (including La Poste), companies, and firms that provide health insurance, he would hesitate to embark on such a project!

https://www.bing.com/search?q=organismes+d%26%2339%3Bassurance+sant%C3%A9&form=EDGNTT&qs=PF&cvid=a9acc132028b4f4daf40c555d77e1531&cc=FR&setlang=fr-FR&elv=AQj93OAhDTi%2AHzTv1paQdni1qQsLsVlIaC0ixq%2A0PIe5R91GYI%2As%2Avsf4tpJusXNZcW1IQHrmu0zwngxamGd8GuLtnD%2APsO2%2ArInv%21KLj8VR


Retirement is great! Especially in the Antilles ...
Raymond (INSA, AFPA)

0
PASLAGA Posted messages 3 Status Membre
 

Yes Raymond, I fully understand that it's a real challenge. But when all the mutual insurance companies tell you that the out-of-pocket costs are zero because we are retired, we know that's a big lie. And in order to compare at least 5-6 mutual insurance policies and potentially save a little money in these difficult times, I think I can manage to do something... If it only benefits me, that will still be better than reading all the fine print of each mutual insurance and possibly forgetting one or two important ones when the need for care (optical or dental) arises.

Today, for a couple of retirees, I pay over €150 per month, and for dental and optical care, it's almost nothing or nothing at all, and that's only once every two years....

0
jee pee Posted messages 9403 Registration date   Status Modérateur Last intervention   9 948 > PASLAGA Posted messages 3 Status Membre
 

To establish this file, you need to dissect the contract, read all the fine print, and contracts change over time. I was previously a member of the mutual commission in my company, and the big difficulty in comparing two contracts is that most of the time, the guarantees and reimbursements vary for each type of care, each procedure.

Example of what I have in my health contract:

  • 100% of the co-payment
  • 500% of the Social Security reimbursement base
  • 90% of the actual expenses after deducting Social Security benefits within the limit
  • of 500% of the Social Security reimbursement base. And at least 175% of the Social Security reimbursement base.
  • 100% of the actual expenses after deducting Social Security benefits within the limit of 20% of the Social Security monthly cap
0
brucine Posted messages 24411 Registration date   Status Membre Last intervention   4 105 > jee pee Posted messages 9403 Registration date   Status Modérateur Last intervention  
 

Hello,

I did this for years as well for different reasons.

Regarding the mentioned rate, I am a "young" retiree; my ex-company health insurance rate is gradually compensated over 5 years (Evin law) by the employer's contribution that has disappeared. Currently, in the 3rd year of this process, I am paying roughly this rate, and none of the carpet sellers who contacted me by phone were able to offer me the same for less.
It should be noted that this rate is calculated solely based on age for health insurances, and for insurance mutuals, just like for auto risk, it depends on the assessment of collective (company) or individual (insured's medical profile) risk.
Thus, the rate in question does not appear excessive on the market.

As for the calculation, it depends on the risk one wants to insure, and it is significantly more expensive for older individuals due to the items that are statistically more costly (optical and dental care).

It's not easy to make simple comparisons because you can find pretty much everything and anything (thermal cures, maternity allowances, funeral expenses, "alternative" medicines...) and because the calculation method can be different and remain very obscure.

In the past, "good" mutual insurances reimbursed a certain amount per the coding letter of a dental prosthesis or a set fee per lens rather than 400% because 4 times zero is still zero.

Moreover, this percentage can apply to actual costs (not for dental matters...), to the reimbursement base...

Rather than simplifying, the new provisions regarding 100% health and controlled fees have paradoxically managed to further obscure this picture; for example, in terms of optics, the security reimbursement barely exists anymore and in some cases, not at all. Consequently, a reimbursement that would rely on a percentage no longer makes sense.

For example, in dental matters, even if it involves controlled fees, as long as you don't have a quote for a specific type of work in hand, you have no way to anticipate and know what the real impact of the proposed rate will be on your out-of-pocket expenses and weigh the pros and cons of a higher contribution in relation to the supposed frequency of these procedures.

0
Raymond PENTIER Posted messages 58548 Registration date   Status Contributeur Last intervention   17 474
 

Hello.

I congratulate Brucine and Jee Pee for their relevant and well-argued analyses.

https://www.bing.com/aclick?ld=e8LWVFATG-XNxXTCCuGODtxTVUCUyEiDJElGvTU4dghEJKNSU8QtwmvbUuYDQ8kVMGkRlYlstdefLw6j00GUGOeaO0847l7y9w_7LCRdXIHbdcjE9xYuIKTBa3flazpgk7X-OZ4zNihUz35BQW1Ak9wYS4XAx8JRzwil5quyEwzhmYoVCD23b0oRzABgMwnjZaWJxv4w&u=aHR0cHMlM2ElMmYlMmZ3d3cubGVzZnVyZXRzLmNvbSUyZmxwJTJmc2FudGUlMmZjb21wYXJhdGV1ci1tdXR1ZWxsZS1zYW50ZSUzZmhvbCUzZHVuYnJhbmQlMjZ1dG1fc291cmNlJTNkU2VhcmNoJTI2dXRtX21lZGl1bSUzZFBQQ0JJTkclMjZ1dG1fY2FtcGFpZ24lM2Q3NTI0NzkzOTAxMzUzNCUyNnV0bV9jb250ZW50JTNkJTI1MkJtdXR1ZWxsZSUyNlNpdGVUYXJnZXQlM2Rrd2QtNzUyNDgwODE0ODY2NjIlM2Fsb2MtNzklMjZnY2xpZCUzZGQxN2VhOWJiYmYxNDFmOTg1MDM4Y2FhMDY3ZGE4YzIzJTI2Z2Nsc3JjJTNkM3AuZHMlMjZtc2Nsa2lkJTNkZDE3ZWE5YmJiZjE0MWY5ODUwMzhjYWEwNjdkYThjMjM&rlid=d17ea9bbbf141f985038caa067da8c23&ntb=1

I would like to add these tips, although they may certainly come too late for PASLAGA:

  1. One must choose their mutual insurance carefully, right from the start of their working life, and as much as possible prioritizing the one that is referenced by their administration or group (Mutual of Taxes, Mutual of the Police ...).
  2. One should avoid fluttering from one mutual insurance to another throughout their career.
  3. Once retired, it’s too late to start over from scratch! Certain benefits are only covered after a registration period (and thus a contribution).
  4. One must not confuse mutual insurances, which have a specific status under the Mutuality Code and are managed by mutualists, and insurance companies that inappropriately claim the title of mutual, in their promotional texts or more boldly directly in their title ...

https://www.bing.com/search?q=liste+des+mutuelles+labellis%C3%A9es+2022&FORM=QSRE1


Retirement is great! Especially in the Antilles...
Raymond (INSA, AFPA)

0
brucine Posted messages 24411 Registration date   Status Membre Last intervention   4 105
 

Hello,

Regarding point 1, we don’t always have a choice; in the example that interested me, the insurance resulted from a collective agreement and, in practice, the negotiations—or more precisely, their absence—meant that there was never any competition and change; it was consequently mandatory except in recent years if the employee could demonstrate that they were covered in an equally mandatory way by that of their spouse.

From an economic standpoint, the costing was very difficult because it did not constitute an independent item but was included in a Benefits item comprising other benefits (sick leave supplements, death benefits...) itself divided into contributions in the brackets below and above the social security ceiling.
It was very uncompetitive in terms of optical and dental care, and very expensive for executives with few beneficiaries because its contributions were not fixed but based on a percentage of salary.
This was also historically the case for the national gendarmerie's mutual insurance, which was not mandatory: young mobile gendarmes, single without children and generally in good health paid a fortune and therefore left it because a tradition, often military, meant that their career elders frequently had a housewife (often due to the military's mobility leaving them no choice) and a large number of children.

The choice of one’s professional body’s mutual insurance is today less relevant in general; outside of dogma, it was mainly intended to reduce costs through the bargaining power of the number of members (this was historically the case, for example, with MAIF), but you will have all noticed while reading your third-party payment card or watching TV advertisements that almost all mutuals have now integrated into a few major groups that can be counted on one hand.

It remains for specific professions, probably the police as mentioned, likely the defense: no non-specific mutual will cover you for injuries or even simple illnesses incurred in an "external operational theater".

Regarding point 3, the waiting period is an economic weapon for insurers. It is a dogma of mutuals, which rightly consider that members do not mutualize anything if they only address the issue when they are old and/or sick, without having previously participated in that mutual effort.

But it can be perverse in the case of individual membership: in the case where, from a job with mandatory provident insurance, one would switch to another where the agreements provide for a mutual, mandatory or not, the question does not arise.
If, however, we migrate from the first situation or from an individual health insurer to an individual mutual, including because the new company has no mandatory mutual, the new mutual will theoretically apply this waiting period because the previous organization was not a mutual affiliated with FNMF.
This situation, acceptable in other cases, can be perceived as unfair by an employee who was previously a beneficiary of group insurance, who would not have chosen to prefer the mutual sphere from the outset.

The fluttering or nomadism, we can call it whatever we want, can be constrained in terms of insurance.
I knew the example of a young woman in perfect health who suddenly developed type 1 diabetes with no clear reason: even though most expenses were covered by long-term illness and thus escaped complementary coverage, the insurer terminated her the following year.

In terms of mutual insurance, and even if one does not see the interest other than commercial or if one does not maintain good relations with a particular representative, the situation is without consequence because, unlike an insurance policy, a mutual cannot exclude you due to your state of health or refuse to cover events that it considers to have occurred prior to the contract.

0