Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ## Task
- You're tasked with extracting comprehensive financial and structural information from a SPAC (Special Purpose Acquisition Company) S-1 registration filing, including calculating the projected liquidation date based on the timeline details.
- ## Context
- SPACs are blank-check companies formed to raise capital through an IPO for the purpose of acquiring an existing private company. The S-1 filing contains critical details about the SPAC's structure, terms, management team, and financial arrangements.
- ## Instructions
- Read the entire document carefully.
- Extract information for ALL categories in the schema below.
- Use precise numerical values when available (e.g., "$10.00 per unit" not "ten dollars per unit").
- For missing information, use null instead of leaving fields empty.
- If information is ambiguous, note your uncertainty in [brackets].
- Convert all textual descriptions of percentages, time periods, and monetary values to standardized numerical formats.
- Important: Calculate the projected liquidation date by adding the business combination deadline period to the IPO date.
- ## Output Schema
- Please provide your responses in this structured JSON format:
- {
- "basic_information": {
- "spac_name": "",
- "ticker_symbols": {
- "units": "",
- "common_stock": "",
- "warrants": "",
- "rights": ""
- },
- "incorporation_location": "",
- "registration_date": "",
- "expected_ipo_date": "",
- "actual_ipo_date": ""
- },
- "offering_structure": {
- "unit_composition": "",
- "unit_price": "",
- "total_units_offered": "",
- "overallotment_units": "",
- "total_offering_value": "",
- "minimum_purchase": ""
- },
- "trust_account": {
- "initial_deposit": "",
- "percentage_of_proceeds": "",
- "interest_terms": "",
- "permitted_investments": "",
- "tax_status": ""
- },
- "timeline": {
- "business_combination_deadline": "",
- "deadline_in_months": 0,
- "extension_provisions": "",
- "calculated_liquidation_date": "",
- "liquidation_terms_if_no_acquisition": ""
- },
- "redemption_rights": {
- "redemption_price": "",
- "redemption_conditions": [],
- "redemption_limitations": [],
- "minimum_cash_condition": "",
- "public_shareholder_approval_requirements": ""
- },
- "warrant_terms": {
- "warrants_per_unit": "",
- "warrant_exercise_price": "",
- "exercise_period": "",
- "redemption_conditions": [],
- "cashless_exercise_provisions": "",
- "anti_dilution_provisions": ""
- },
- "sponsor_details": {
- "sponsor_name": "",
- "founder_shares": "",
- "percentage_ownership_post_ipo": "",
- "private_placement_warrants": "",
- "private_placement_investment": "",
- "lockup_provisions": ""
- },
- "management_team": [
- {
- "name": "",
- "position": "",
- "age": "",
- "background": ""
- }
- ],
- "target_business": {
- "focus_industries": [],
- "geographic_focus": [],
- "size_criteria": "",
- "stated_acquisition_strategy": ""
- },
- "expenses": {
- "underwriting_fees": {
- "total": "",
- "upfront": "",
- "deferred": ""
- },
- "offering_expenses": {
- "legal_fees": "",
- "accounting_fees": "",
- "printing_costs": "",
- "filing_fees": "",
- "miscellaneous": "",
- "total_offering_expenses": ""
- },
- "operational_expenses": {
- "annual_administrative_fee": "",
- "working_capital": "",
- "d&o_insurance": ""
- }
- },
- "underwriter_information": {
- "lead_underwriters": [],
- "underwriting_discount_percentage": "",
- "deferred_underwriting_commission": ""
- }
- }
- ## Additional Instructions
- - Financial Details: Always express monetary values in standard format (e.g., "10,000,000" not "10 million").
- - Time Periods: Express as number of months (e.g., "24 months" not "two years").
- - Percentages: Include the % symbol (e.g., "20%" not "twenty percent").
- - Ownership: Express as percentage with decimals if provided (e.g., "20.5%").
- - Detailed Provisions: Summarize key conditions while capturing all material terms.
- - Team Members: Include all named executive officers and directors.
- ## Liquidation Date Calculation:
- Extract the IPO date from the document (if available) or use the expected IPO date
- Identify the business combination deadline (typically X months from IPO closing)
- Convert the deadline to a specific number of months in the deadline_in_months field
- Calculate and format the liquidation date as "YYYY-MM-DD" in the calculated_liquidation_date field
- If exact dates aren't available, provide your best estimate and note it as [Estimated]
- For quantitative data requiring calculations (such as ownership percentages or total values), perform those calculations if the raw data is provided. For qualitative assessments of business strategy or risk factors, extract the primary stated objectives or concerns.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement