clive-africa/magnus

A VBA library to assist in the calculation of the SAM standard formula. # Magnus Magnus is an Excel-based tool designed to streamline Solvency Assessment and Management (SAM) capital calculations for South African short-term insurers. Currently implemented as an Excel workbook with VBA modules, Magnus will be published as an Excel Add-in to provide seamless integration with existing actuarial workflows. ## Purpose The South African non-life insurance industry needs robust, modern tools for calculating SAM capital requirements. Magnus aims to address this need by providing: - **Automated Capital Calculations**: Non-life capital requirement calculations including premium and reserve risk, natural catastrophe risk, factor-based and non-proportional capital requirements - **Multi-dimensional Analysis**: Support for complex organizational structures and reinsurance arrangements - **Regulatory Compliance**: Built specifically for SAM requirements applicable to South African insurers - **Efficiency**: Replaces manual calculation workbooks with automated, auditable functions ## Important Disclaimers and Limitations **THIS SOFTWARE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND** ### No Professional Advice Magnus is a calculation tool only and does not constitute actuarial advice, regulatory advice, or professional services of any kind. Users must exercise their own professional judgment and are solely responsible for: - Validating all calculations and results - Ensuring compliance with applicable regulations - Obtaining appropriate professional oversight - Making their own independent assessments ### Regulatory Responsibility While Magnus is designed to assist with SAM framework calculations: - **Users remain fully responsible** for ensuring compliance with all applicable regulations, including SAM requirements and Prudential Authority standards - **Independent verification required**: All outputs must be validated by qualified actuaries - **No guarantee of accuracy**: The tool may contain errors, omissions, or become outdated as …