Posts

Fit-for-All Prophet Model - Not a Good Idea

Image
After completing the debugging on Prophet model yesterday, I still think that building a #Prophet model that aims to fit-for-all (e.g., business units) is NOT A GOOD IDEA . Yesterday my team member, Cang Zheng, and I were assisting one of our Prophet users in debugging her reserve figure generated from their existing Prophet production model (which was developed earlier by other modelers). When we went through the Prophet model, although it was not modified from the standard Conventional library, we still found traces that it is modified from a library that aims to achieve fit-for-all purposes.

Prophet Modelling Technique (4): SPCODE

Image
In several discussions with Prophet users, the topic of sub-product codes, commonly known as SPCODE , often comes up. I thought it would be helpful to share some of my views on how SPCODE should be used—especially in terms of maintaining model flexibility and supporting various actuarial analyses.

Prophet Modelling Technique (3): Calculation Looping

Image
In my previous post about using enumerations in Prophet, I referenced "calculation looping" in one of the illustrations. That got me thinking—not all Prophet users may be familiar with this concept. After all, not every Prophet model uses the calculation looping technique. Let’s take a closer look at what calculation looping is, how it works, and why it’s useful—especially when you're dealing with different sets of assumptions in a single run.

Prophet Modelling Technique (2): New Business Processing

Image
From my experience working with Prophet users (Valuation Team), most are quite familiar with running in-force projections, such as monthly valuation and embedded value calculations. However, when it comes to new business ("NB") processing , many users find themselves uncertain or confused on how it works. It’s not uncommon for me to receive questions like,  "Why can’t I just use the cross multiplication method?" "Why does the project method take so much longer to run?" (Prefer video? View the  video  for this post!)

Prophet Modelling Technique (1): Enumerations

Image
If you’ve upgraded your Prophet version to Release 2024 Q4, you might have noticed a new and helpful feature: you can now define a variable as an enumeration type—in addition to the usual number and text types. (Prefer video? View the video for this post!)

Rising Medical Insurance Premiums (4) – Additional Metrics in Claim Analysis

Image
In one of the discussions with my team about medical insurance, I emphasized that claim data is one of the most valuable assets  for insurance companies. Even if insurers engage third-party administrators ("TPAs") to handle claim processing, it’s crucial for them to retain access to detailed claim data – and at a granular level.  

Rising Medical Insurance Premiums (3) – Is Medical Inflation in General a Fair Benchmark?

Image
In its recent announcement on medical insurance , Bank Negara Malaysia highlighted Malaysia’s medical inflation rate of 15%, which surpasses the average across global and Asia Pacific region. However, when I consider the rate of increase in medical insurance premiums, I question whether this 15% figure is truly a suitable benchmark – are we really comparing apples to apples?   Before diving into my thoughts on this, I believe it’s helpful to explain the concept of " insured lives " experience.