Hello all,
I recently started valuing an insurance company, but I have little to no experience with insurance companies. I am looking into doing a DDM model for an insurance company but couldn't find the insurance company Statutory Capital & Surplus listed on its 10q. Could you please help me out with the formula for Statutory Capital & Surplus? Tried Googling it, didn't help much.
| +72 | Q&A - Buyside Equity Research Analyst/PM | 27 | 1w | |
| +32 | How the heck do you learn all of this stuff? | 5 | 5d | |
| +28 | Getting Frustrated | 10 | 3w | |
| +27 | My experience on the sell side | 20 | 1w | |
| +22 | What’s my next move? | 6 | 2w | |
| +18 | Biotech ER vs IB | 16 | 3w | |
| +14 | Heard they don’t model at Oppenheimer | 10 | 1w | |
| +14 | Am i fairly compensated? | 8 | 4h | |
| +14 | Data Science to PM | 8 | 2d | |
| +13 | ER time line and ways to break in help | 17 | 3w |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
So the 10-Q is going to be GAAP focused for what you’re looking for you are going to need to go to the actual statutory or STAT filings. Most companies should have them on their investor relations pages.
Would suggest you start with the investor supplements for the insurer you’re looking to value and go from there. The supplements are GAAP and while they won’t provide the financials of the company on an economic basis (statutory), they’ll get you to where you need to go from a model build out perspective. Maybe you’ll need to go into the Q or K to determine something more nuanced but honestly, the supplements will have earnings drivers laid out cleanly.
On your other question, I think you’re looking for the formula for excess capital that uses the statutory statements. To get excess capital from statutory statements, you first need to determine the principal subsidiary structure ie which subs roll-up into other subs vs which subs are principal subs. The next steps are all done on a sub basis but rolled up into the holdco to determine excess.
From the stat statements, add together Capital and Surplus, Asset Valuation Reserve, 50% of Dividends Apportioned for Payment, the AVRs from the non-principal subs, and any dividends from non-principal subs. This will get you TAC. Next, multiply RBC-CAL from the stat statement by 2. TAC/RBC*2 = RBC ratio. Multiplying your RBC-CAL by RBC ratio minus the insurer’s target RBC gets you to Excess capital prior to adjustments. You then adjust this excess capital by subtracting any intercompany loans (found in the K). This is your adjusted excess capital.
Next, add holdco cash and holdco short term loans. Then, subtract the holdco working capital requirement (usually found in an earnings deck) to get to excess capital at the holdco level. Add this to your adjusted excess capital to get your excess capital prior to pro forma adjustments (this can be considered final excess capital for the insurer).
Wow... thanks for taking the time for a very thorough answer my man. This helped a LOT!
Non esse commodi impedit impedit. Nemo voluptates quos aut alias occaecati beatae inventore. Sit aspernatur tempore deleniti eius incidunt. Sed quo aut sint saepe ex eum. Sit expedita vel inventore eligendi vel. Sed velit voluptates eligendi impedit sint quo.
Reiciendis velit consequuntur quia rerum rerum ex deleniti. Quasi illo aspernatur sapiente dolorem. Quo exercitationem suscipit accusamus sapiente dolore consequatur modi. Sapiente maiores mollitia in distinctio.
Commodi officiis doloremque autem aliquam dicta. Distinctio nostrum in neque excepturi similique qui et.
Explicabo et debitis nostrum officia et sed. Aperiam placeat totam dolorem veritatis.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...