Insurance liquidity ratio under draft FSI 6
Enter your stressed cash flows and your high-quality liquid assets (HQLA). The calculator returns the insurance liquidity ratio (ILR) the way paragraph 7.4 of the draft defines it, runs the standard's checks, shows a sensitivity range, fills in the PA's Liquidity Return workbook and prints an evidence pack for the head of the actuarial function and the auditor.
Try it
Load a worked example for a made-up insurer, then change numbers and watch the ratio move.
Start with your own numbers
Start empty and paste from Excel, or reload inputs you saved earlier. Saved files stay on your computer.
About this insurer
All amounts are in R'000, as in the PA's return. Cash flows on unit-linked liabilities where the policyholder bears the investment risk are excluded (para 7.4); put the residual liquidity needs on that business under "other funding and liquidity needs" on the next page.
Advanced settings
The draft does not say whether the 60% Level 1 test and the 20% issuer limit are measured on market value or on value after haircut, so both are shown. Months in the time ladder are taken as 30 days.
Cash flows
The PA's return asks for business-as-usual and stressed cash flows over seven time buckets. Only the first three buckets (30 calendar days) feed the ILR; the rest feed the cumulative position and the reverse stress view. Paste a block from Excel into any cell to fill the grid from there.
Other funding and liquidity needs (not in the stressed cash flows)
Margin and collateral calls, securities lending, repos, the residual liquidity requirement on unit-linked business, operational events. They are added to the net stressed outflows (return lines 115 to 124). Up to ten lines.
Net outflows in other currencies (next 30 days)
Foreign-currency HQLA counts only up to your net outflows in that currency over 30 days, unless the PA approves more in writing (Notice 2.7). Enter the net 30-day outflow for each currency you hold HQLA in.
High-quality liquid assets
One row per holding, at market value in R'000. Choose the asset class and give the rating; the calculator applies Table 1 of the PA's haircuts notice (items 1 to 16), the less-favourable-rating rule of para 8.15, and tells you why a holding does not qualify.
Return and evidence
The PA's Liquidity Return, filled in
The Prudential Authority's own workbook (Annexure E), unchanged, with your business-as-usual and stressed cash flows, your HQLA by line and your other funding needs filled in. Its formulas are recalculated, so the file shows its numbers in any viewer. Check it, then submit it through the Umoja portal yourself.
Evidence pack
A printable record of the inputs, the method, every check and the sign-off lines for the head of the actuarial function (para 3.5) and for the auditor's evidence on the HQLA and the ILR (para 3.6). Use your browser's "Save as PDF" in the print dialog.
Save your inputs
A small file with everything you entered, to reload later or hand to a colleague. It stays on your computer.
Fingerprint of the current inputs (SHA-256): ...
Before you rely on any of this
- The standard, the haircuts notice and the return are drafts. Comments close 27 Nov 2026 and no start date is set. The final text may differ.
- Where the draft is silent or inconsistent the calculator takes the cautious reading and says so. See questions to put to the PA.
- It does not design your stress scenarios, and it cannot tell you whether your cash flow projections are right. The head of the actuarial function and your auditor still sign off.
- Questions about the calculator: hello@beyonddata.co.za.