(vi) From your dataset calculate solvency ratio for the respective years "Solvency ratio is calculated as the amount of Available Solvency Margin (ASM) in relation to the amount of Required Solvency Margin (RSM). The ASM is the value of the company's assets over liabilities, and RSM is based on net premiums" a. Comment on the solvency ratio for your company Data Collection Template.xlsx A Net Total Liabilities Contingent Liability Total Equity Premium Net Earned Premis Net Claims Incurred NON Underwriting Underwriting Expenses Surplus/Deficit underwriting expenses Management/AdNet profit before tax Net profit after tas income 00 $505,940.000.00 .00 888 $562,577,000.00 $633,828,000.00 $686,795,000.00 $738,080.000.00 $580,000.00 $75,180,000.00 N.A 5645,000.00 $82,552,000.00 N.A $530,000.00 $552,000.00 NA NA NA NA N.A NA NA NA NA NA NA NA $16,046,000.00 $26,104,000.00 $15,924,000.00 $22,208,000.00 $86,966,000.00 N.A NA NA NA NA NA NA $83,245,000.00 N.A NA NA NA NA NA NA $25,359,000.00 $21.835,000.00 $20,929,000.00 $20,409,000.00 $552,000.00 $84,591,000.00 N.A NA NA NA NA NA NA $16,495,000.00 $15,306,000.00 Done Sheet1 Group Details Done Data Collection Template.xlsx A Other Provisions Borrowings (Liability) Total Liabilities Contingent Liability Total Equity Net Premium Net Earned Premiums Net Claims Underwriting Underwriting Expenses Surplus/Deficit NON. underwriting Management/AN Inome expenses Incurred income $20,952,000.00 0 $16,233,000.00 $454,988,000.00 $505,940,000.00 $546,344,000.00 $562,577,000.00 $580,000.00 $75,180,000.00 N.A NA NA N.A N.A NA NA $645,000.00 $82,552,000.00 N.A NA NA NA NA NA NA 0 $20,030,000.00 $613,798,000.00 $633,828,000.00 $530,000.00 $86,966,000.00 N.A NA NA NA NA NA NA 0 $20,517,000.00 $666,278,000.00 $22,558,000.00 $686,795,000.00 $552.000.00 $83,245,000.00 N.A NA NA NA NA NA NA $715,522,000.00 $738,080,000.00 $552,000.00 $84,591,000.00 N.A NA NA N.A NA NA NA Sheet1 Group Details Done Data Collection Template.xlsx Sheet1 Group Details Underwriting Unearned Incurred Admitted Year Company provisions as per balance sheet Premium Claim But Not Investments Provisions Loans (Part of assets) Other Current Fixed Assets Intangible Assets Total Assets Reported 2016 BSP LIFE N.A. NA NA NA $469,159,000.00 2017 BSP LIFE N.A NA NA N.A $526,736,000.00 2018 BSP LIFE N.A NA NA NA 2019 BSP LIFE NA NA NA NA 2020 BSP LIFE N.A NA NA NA $616,464,000.00 $659,263,000.00 5694,915,000.00 $54.995,000.00 $9,243,000.00 $49,673,000.00 $56,011,000.00 $1,438,000.00 $72,809,000.00 $19,861,000.00 $1,305,000.00 $71,648,000.00 $29,682,000.00 $2,191,000.00 $73,626,000.00 $47.593,000.00 $2,456,000.00 $46,833,000.00 $890,000.00 $11,271,000.00 5581,120,000.00 $645,129,000.00 $10,355,000.00 $720,794,000.00 $7.256,000.00 $770,040,000.00 $4,081,000.00 5822,671,000.00