QA: Principal Financial Group Inc in us_non

Logs

warning	Similarly named company. Duplicate?	None	{'details': [{'other_company': 'Cincinnati Financial CORP', 'shared_tokens': {'financial'}}, {'other_company': 'American Financial Group Inc', 'shared_tokens': {'financial'}}, {'other_company': 'Kingsway Financial Services Inc', 'shared_tokens': {'financial'}}]}
warning	Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	{'missing_ratio': 0.5377453585763247, 'aggregate_val': 8390400000, 'exp_sum': 5456300000, 'exp_to_value': {'PolicyholderBenefitsAndClaims': 5123900000, 'SellingGeneralAndAdministrativeExpense': 0, 'DeferredPolicyAcquisitionCostAmortizationExpense': 0, 'remainder_Expenses': 332400000}}
warning	Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	{'missing_ratio': 0.6507064519316273, 'aggregate_val': 8353400000, 'exp_sum': 5060500000, 'exp_to_value': {'PolicyholderBenefitsAndClaims': 4683600000, 'SellingGeneralAndAdministrativeExpense': 0, 'DeferredPolicyAcquisitionCostAmortizationExpense': 0, 'remainder_Expenses': 376900000}}

	xvar	xval
0	Investments	68,811,300,000
1	SeparateAccountAssets	81,653,800,000
2	PremiumsReceivable	1,084,400,000
3	DeferredPolicyAcquisitionCosts	2,673,800,000
4	ReinsuranceRecoverables	0
5	IntangibleAssets	1,470,600,000
6	AssetsCurrent	4,177,200,000
7	AssetsNonCurrent	1,471,000,000
8	remainder_Assets	584,400,000
9	LiabilityForClaimsAndClaimsAdjustmentExpense	22,436,200,000
10	PolicyholderContractDeposits	82,370,200,000
11	LiabilitiesCurrent	0
12	UnearnedPremiums	0
13	ReinsurancePayable	0
14	LongTermDebt	2,671,300,000
15	remainder_Liabilities	44,615,200,000
16	PolicyholderBenefitsAndClaims	5,110,986,359
17	SellingGeneralAndAdministrativeExpense	0
18	DeferredPolicyAcquisitionCostAmortizationExpense	0
19	remainder_Expenses	3,246,006,218
20	PremiumsEarned	3,201,870,768
21	InvestmentIncome	3,251,372,445
22	InsuranceCommissionsAndFees	0
23	remainder_Revenues	2,865,018,671
24	Revenues_Y1	9,280,965,452
25	Revenues_Y2	9,307,787,311
26	Revenues_Y3	9,315,350,138
27	Revenues_Y4	9,317,600,054
28	Revenues_Y5	9,318,261,884
29	remainder_NetIncome	0
30	remainder_ComprehensiveNetIncome	355,100,000

	yvar	yval
0	Assets	161,926,500,000
1	Liabilities	152,092,900,000
2	Expenses	8,356,992,577
3	Revenues	9,318,261,884
4	StockholdersEquity	9,833,600,000
5	NetIncome	961,269,307
6	ComprehensiveNetIncome	1,138,819,307
7	BaseVar	681,147,911,086
8	EconomicCapitalRatiobeforeLimitedLiability	0.0563
9	EconomicCapitalRatio	0.812