Pricing Logic
The most friendly premium calculation engine
Pricing Logic is the core of an insurance product. We understand that most companies use Excel to lay out the pricing structure of an insurance product, hence, at KASKO, we developed our pricing engine around Excel.
The configuration on Product Builder has essentially 2 parts, the Pricing Logic file and the Validation Rules.
You can keep your formula and sheets in your excel and simply add one KASKO formatted sheet Calculator to the first sheet of your excel. You can get the example Excel file here.
In the KASKO Calculator sheet, you will see the below sections.
In a functioning excel, you should be able to see the calculated premiums and output fields in column K
once you put in the test values in column C
. You should be able to test various scenarios and cases to see if the premiums are returned correctly.
There is a list of output fields that should always be in the pricing excel. These are the default outputs that are already listed in the pricing template file. The fields are:
billing_cycles
gross_payment_amount
gross_premium
premium_tax
net_premium
net_net_premium
net_commission_total
tax_rate
duration_strategy
Apart from the above fields, there are some additional
In the output field, there is a required field called Duration Strategy. This field defines how the policy start and end date should be defined. There are 4 duration strategies that can be used.
Apart from the Pricing Excel file, you will also need the Validation Rules for all the quote data of your product. The Validation Rules are written in JSON and here is an example.
In the example, you can see that each of the input fields in your pricing would include 3 parts in the Validation Rules.
Once you have a functioning Pricing Logic Excel file and the Validation Rules, you can go to Product Builder → Pricing Logic and start configuring for your product.
You will need to remove all the values (column C) for all the input fields so that the pricing is clean and without any prefilled values.
When you finish the Pricing Logic Configuration, you can go to the Manual Test
. Here on the left hand side, you can see a dropdown of the payment frequencies and the input fields of the product; on the right hand side, you can see a blank output screen.
This area is for you to run manual test of your Pricing Logic, by inputting different values on the left hand side and click Run Test
on the top right. Once clicked, you will see the return of the pricing calculation on the right hand side in the output area.
Once the Pricing Logic is configured and you want to update the pricing calculation for your product, simply go back to Pricing Logic Configuration screen. There you can download the latest Pricing Logic Excel and make the necessary update to your Pricing Logic Excel file. Once the changes are made, you can upload it to the Product Builder (and update the Validation Rules if there are any changes there as well).
Last updated