QA: Piper Sandler Companies in us_brokers/2022

Table of Contents

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

PDF Report 0001230245_2023_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(('CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents', 'Assets', 'ReceivablesFromBrokersDealersAndClearingOrganizations', 'FinancialInstrumentsOwnedAtFairValue', 'PropertyPlantAndEquipmentNet', 'Goodwill', 'IntangibleAssetsNetExcludingGoodwill', 'InvestmentsExcludingFinancialInstrumentsOwned', 'DeferredIncomeTaxAssetsNet', 'OperatingLeaseRightOfUseAsset', 'OtherAssets', 'InvestmentsInAffiliatesSubsidiariesAssociatesAndJointVentures', 'PrepaidExpenseCurrentAndNoncurrent', 'AccruedFeesAndOtherRevenueReceivable', 'LongTermDebt', 'Liabilities', 'PayablesToBrokerDealersAndClearingOrganizations', 'FinancialInstrumentsSoldNotYetPurchasedAtFairValue', 'EmployeeRelatedLiabilitiesCurrentAndNoncurrent', 'OperatingLeaseLiability', 'AccruedLiabilitiesAndOtherLiabilities', '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 339,979,000
1 AssetsCurrent 0
2 Receivables 300,463,000
3 GoodwillAndIntangibleAssets 436,788,000
4 remainder_Assets 1,104,327,000
5 LiabilitiesCurrent 0
6 LongTermLiabilities 125,000,000
7 SecuritiesRepurchaseAgreements 60,836,000
8 Payables 4,622,000
9 remainder_Liabilities 737,071,000
10 LaborExpense 983,524,000
11 GeneralAndAdministrativeExpense 64,252,000
12 CommissionsAndAdvisoryFees 53,189,000
13 OperatingExpenses 70,750,000
14 remainder_Expenses 162,223,000
15 RevenueFromContractWithCustomer 0
16 InterestIncome 20,365,000
17 BrokerageAndAdvisoryCommissions 0
18 TradingGainsAndLosses 1,009,509,000
19 remainder_Revenues 405,244,000
20 remainder_NetIncome 0
21 remainder_ComprehensiveNetIncome 7,959,000
  yvar yval
0 Assets 2,181,557,000
1 Liabilities 927,529,000
2 Expenses 1,333,938,000
3 Revenues 1,435,118,000
4 StockholdersEquity 1,254,028,000
5 NetIncome 101,180,000
6 ComprehensiveNetIncome 105,159,500
7 BaseVar 2,943,050,500
8 EconomicCapitalRatio 0.971

Edgar->Model Mapping

Feature Distribution

Change over Time