Project

General

Profile

Actions
Copy link

Modification/ Enhancements #681

closed

Insurance-->quarterly-->Q5-Sec 8(13) Solvency-->Client wants changes in calculation for solvency form(latest excel sheet have provided by client)

Added by arti saraswat about 3 years ago. Updated almost 3 years ago.

Status:
Reopened
Priority:
Normal
Assignee:
sunil gupta
Category:
Q5-Sec 8(13) Solvency
Start date:
10/01/2021
Due date:
% Done:

0%

Estimated time:

Description

Q5 solvency form – the field where the percentage of premiums is calculated (second field on the form) does not take account of the fact that the form should be completed in ‘000s. So where the formula states that the first $13.441 million should be at 20% and amounts exceeding that should be multiplied by 10%, that means in the form, this threshold should be $13,441. Therefore, any figures for premiums entered that are above this amount, should trigger the change to 10% of premiums over this amount. See the below screenshot showing this is not being done in ARIAS currently.

See attached screenshot

See attached downloaded file for solvency calculation

Files

Download all files
clipboard-202110011820-hijdb.png (121 KB) clipboard-202110011820-hijdb.png arti saraswat, 10/01/2021 06:19 PM
clipboard-202110011820-kyr6q.png (93 KB) clipboard-202110011820-kyr6q.png arti saraswat, 10/01/2021 06:20 PM
Solvency Table - ARIAS - Example with 20000 premiums (5).xlsx (15.1 KB) Solvency Table - ARIAS - Example with 20000 premiums (5).xlsx arti saraswat, 10/01/2021 06:20 PM
clipboard-202111111719-g92of.png (266 KB) clipboard-202111111719-g92of.png arti saraswat, 11/11/2021 05:19 PM
Actions
Copy link

Also available in: Atom PDF