QA: Aspen Insurance Holdings LTD in us_non

Logs

error	Negative Expenses, ignoring company.	pre-agg	{'expenses': -15400000}
warning	Similarly named company. Duplicate?	None	{'details': [{'other_company': 'Selective Insurance Group INC', 'shared_tokens': {'insurance'}}, {'other_company': 'Universal Insurance Holdings Inc', 'shared_tokens': {'insurance'}}, {'other_company': 'Hanover Insurance Group Inc', 'shared_tokens': {'insurance'}}, {'other_company': 'Safety Insurance Group INC', 'shared_tokens': {'insurance'}}]}
warning	Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	{'missing_ratio': 0.9977022751243031, 'aggregate_val': 6100000, 'exp_sum': 2654800000, 'exp_to_value': {'PolicyholderBenefitsAndClaims': 1576100000, 'SellingGeneralAndAdministrativeExpense': 490100000, 'DeferredPolicyAcquisitionCostAmortizationExpense': 528900000, 'remainder_Expenses': 59700000}}
warning	Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	{'missing_ratio': 1.0052873721073954, 'aggregate_val': -15400000, 'exp_sum': 2912600000, 'exp_to_value': {'PolicyholderBenefitsAndClaims': 1994700000, 'SellingGeneralAndAdministrativeExpense': 502200000, 'DeferredPolicyAcquisitionCostAmortizationExpense': 400500000, 'remainder_Expenses': 15200000}}

	xvar	xval
0	Investments	7,900,300,000
1	SeparateAccountAssets	0
2	PremiumsReceivable	1,399,400,000
3	DeferredPolicyAcquisitionCosts	358,400,000
4	ReinsuranceRecoverables	815,900,000
5	IntangibleAssets	0
6	AssetsCurrent	1,273,800,000
7	AssetsNonCurrent	84,800,000
8	remainder_Assets	257,500,000
9	LiabilityForClaimsAndClaimsAdjustmentExpense	5,319,900,000
10	PolicyholderContractDeposits	0
11	LiabilitiesCurrent	0
12	UnearnedPremiums	1,618,600,000
13	ReinsurancePayable	345,300,000
14	LongTermDebt	549,300,000
15	remainder_Liabilities	608,700,000
16	PolicyholderBenefitsAndClaims	1,576,100,000
17	SellingGeneralAndAdministrativeExpense	490,100,000
18	DeferredPolicyAcquisitionCostAmortizationExpense	528,900,000
19	remainder_Expenses	-2,589,000,000
20	PremiumsEarned	2,637,300,000
21	InvestmentIncome	187,100,000
22	InsuranceCommissionsAndFees	0
23	remainder_Revenues	114,100,000
24	Revenues_Y1	0
25	Revenues_Y2	0
26	Revenues_Y3	0
27	Revenues_Y4	0
28	Revenues_Y5	0
29	remainder_NetIncome	0
30	remainder_ComprehensiveNetIncome	-64,800,000

	yvar	yval
0	Assets	12,090,100,000
1	Liabilities	8,441,800,000
2	Expenses	6,100,000
3	Revenues	2,938,500,000
4	StockholdersEquity	3,648,300,000
5	NetIncome	2,932,400,000
6	ComprehensiveNetIncome	2,900,000,000
7	BaseVar	70,695,668,876
8	EconomicCapitalRatiobeforeLimitedLiability	0.136
9	EconomicCapitalRatio	0.888