QA: Piper Sandler Companies in us_brokers/2021

Table of Contents

See also this year's filing and all EDGAR filings for this company.

PDF Report 0001230245_2022_Piper_Sandler_Companies.pdf

Logs

warning The stock price does not exist industry.us_generic {}
warning No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping {'lase_node': None, 'equity_node': None, 'partners_cap_node': None, 'nodes': "NodeView(('CashAndCashEquivalentsAtCarryingValue', 'Assets', 'ReceivablesFromBrokersDealersAndClearingOrganizations', 'FinancialInstrumentsOwnedAtFairValue', 'PropertyPlantAndEquipmentNet', 'Goodwill', 'IntangibleAssetsNetExcludingGoodwill', 'InvestmentsExcludingFinancialInstrumentsOwned', 'DeferredIncomeTaxAssetsNet', 'OtherAssets', 'OperatingLeaseRightOfUseAsset', 'InvestmentsInAffiliatesSubsidiariesAssociatesAndJointVentures', 'FinancialInstrumentsOwnedAndNotPledgedAtFairValue', 'FinancialInstrumentsOwnedAndPledgedAsCollateralAtFairValue', 'AccruedLiabilitiesAndOtherLiabilities', 'Liabilities', 'PayablesToBrokerDealersAndClearingOrganizations', 'OperatingLeaseLiability', 'FinancialInstrumentsSoldNotYetPurchasedAtFairValue', 'LongTermDebt', 'EmployeeRelatedLiabilitiesCurrentAndNoncurrent', 'CommonStockValue', 'StockholdersEquity', 'AdditionalPaidInCapitalCommonStock', 'RetainedEarningsAccumulatedDeficit', 'TreasuryStockValue', 'AccumulatedOtherComprehensiveIncomeLossNetOfTax', 'StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest', 'MinorityInterest'))"}
warning Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic {'missing_ratio': 1.0, 'aggregate_val': 0, 'exp_sum': 128574000, 'exp_to_value': {'LaborExpense': 0, 'GeneralAndAdministrativeExpense': 0, 'CommissionsAndAdvisoryFees': 0, 'OperatingExpenses': 0, 'remainder_Expenses': 128574000}}
warning Ignoring company because Expenses is zero pre-agg {'balance_sheet': {'company_id': '0001230245', 'EntityCommonStockSharesOutstanding': 19170470, 'Assets': 1655721000, 'AssetsCurrent': 85807000, 'BrokerageAndAdvisoryCommissions': 0, 'CommissionsAndAdvisoryFees': 0, 'Expenses': 0, 'FinancialSecurities': 982735000, 'GeneralAndAdministrativeExpense': 0, 'GoodwillAndIntangibleAssets': 253656000, 'InterestIncome': 0, 'LaborExpense': 0, 'Liabilities': 905121000, 'LiabilitiesAndStockholdersEquity': 1655721000, 'LiabilitiesCurrent': 166175000, 'LongTermLiabilities': 115000000, 'NetIncome': -100557000, 'OperatingExpenses': 0, 'Payables': 67335000, 'Receivables': 148857000, 'RevenueFromContractWithCustomer': 0, 'Revenues': 0, 'SecuritiesRepurchaseAgreements': 412584000, 'TradingGainsAndLosses': 0, 'remainder_Assets': 184666000, 'remainder_ComprehensiveNetIncome': 0, 'remainder_Expenses': 0, 'remainder_Liabilities': 144027000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 750600000, 'obs_EconomicCapitalRatio': nan}}
info Failed to set obs_EconomicCapitalRatio industry.us_generic {'reason': "KeyError('0001230245')"}
info Added remainder_ComprehensiveNetIncome directly from 10K industry.us_generic {}

Graph

Absolute values for 0001230245, Piper Sandler Companies

  xvar xval
0 FinancialSecurities 348,974,000
1 AssetsCurrent 970,965,000
2 Receivables 254,130,000
3 GoodwillAndIntangibleAssets 347,286,000
4 remainder_Assets 643,952,000
5 LiabilitiesCurrent 0
6 LongTermLiabilities 125,000,000
7 SecuritiesRepurchaseAgreements 128,690,000
8 Payables 13,247,000
9 remainder_Liabilities 1,071,515,000
10 LaborExpense 1,305,166,000
11 GeneralAndAdministrativeExpense 56,946,000
12 CommissionsAndAdvisoryFees 45,942,000
13 OperatingExpenses 60,541,000
14 remainder_Expenses 242,832,000
15 RevenueFromContractWithCustomer 0
16 InterestIncome 6,967,000
17 BrokerageAndAdvisoryCommissions 0
18 TradingGainsAndLosses 1,553,219,000
19 remainder_Revenues 481,609,000
20 remainder_NetIncome 0
21 remainder_ComprehensiveNetIncome -52,621,000
  yvar yval
0 Assets 2,565,307,000
1 Liabilities 1,338,452,000
2 Expenses 1,711,427,000
3 Revenues 2,041,795,000
4 StockholdersEquity 1,226,855,000
5 NetIncome 330,368,000
6 ComprehensiveNetIncome 304,057,500
7 BaseVar 3,854,801,000
8 EconomicCapitalRatio 0.860

Edgar->Model Mapping

Feature Distribution

Change over Time