At ACTBuilder Actuarial Solutions, we support clients in developing spreadsheet-based actuarial models that serve as practical and transparent tools for both validation and product design. These models are particularly valuable for two key purposes:
- to reconcile and validate results from Prophet models, ensuring the underlying calculations are correctly implemented, and
- to support actuarial pricing teams in performing profitability assessments for new products under development.
Spreadsheets remain the foundation of actuarial modelling, offering a level of visibility and control that is essential for understanding how variables interact and influence results. For pricing actuaries, spreadsheet models provide a more flexible and efficient environment to experiment with different product features and assumptions.
This is especially important during early-stage product design, where the ability to test multiple configurations and assess their impact on profitability is critical—something that would be far more complex and time-consuming to do directly in Prophet. By building clear and structured spreadsheet models, we help clients make better-informed decisions, reduce implementation risk, and bridge the gap between conceptual design and system-based modelling.