IRIS Ratio Analysis Spreadsheet Using the information presented below, calculate the ratios requested in the IRIS ratio section. All of your answers should be in percentage-format. Note that the combined and investment income ratios are already presented in percentage formet for your use. Percentage-change calculations over time use the following pattern [(Current period - Previous period) / Previous period]. Use the information generated in this spreadsheet to answer the questions asked in the associated IRIS Analysis Exam. Note: All monetary values presented in thousands (000s) Fields Policyholder Surplus (PHS) Gross Premiums Written Net Premiums Written 2023 Company A 2022 2021 2023 Company B 2022 2021 $6,358 $5,804 $5,019 $331 $368 $368 $3,523 $3,374 $3,833 $156 $518 $744 $3,202 $3,211 $3,194 $120 $475 $659 Direct Business Written Combined Ratio Investment Income Ratio Total Assets $2,844 $2,917 $2,923 $1,871 $2,059 $2,164 110.0% 116.0% 105.0% 105.0% 116.0% 120.0% 12.1% 15.4% 13.3% 9.4% 11.3% 14.6% $22,253 $18,571 $15,057 $958 $1,029 $1,139 Liquid Assets $15,577 $12,072 $8,281 $479 $463 $627 Liabilities $15,895 $12,768 $10,038 $628 $662 $772 Reinsurance assumed from affiliated firms $387 $309 $288 $0 Reinsurance assumed from non-affiliated firms $11 $11 $11 $0 Asset - uncollected premiums/agent balances in collection Asset-deferred premiums/agent balances not due Year 1 reserve development - losses and ALAE incurred Year 2 reserve development - losses and ALAE incurred $39 $42 $52 $28 $354 $309 $445 $497 $636 -$19 -$92 -$106 $112 -$63 -$115 -$170 $103 -$1 $0 $0 $674 $29 $22 IRIS Ratios 2023 Company A 2022 2021 2023 Company B 2022 2021 IRIS Unus Gross written premium to policyholder surplus (PHS) Net written premium to PHS 323099.9% Over 900% Over 300% Change in writing** Change b Two year operating ratio Investment Income Ratio Gross change in PHS Over 1009 Under 3% Drop of n