Column Glossary
This glossary is designed to help you understand the meaning of various column names and their values.
| Column Display Name | Column Name | Example | Description |
|---|---|---|---|
| CIK | cik | '0000123456' | The CIK of the SPAC |
| SPAC Name | name | 'GORES HOLDING VIII INC' | The name of the SPAC |
| SPAC Name | spac_page_url | 'gores-holding-viii-inc' | The name of the SPAC (linked) |
| SPAC Status | status | 'ANNOUNCED' | What stage of life a SPAC is currently in |
| Industry | industry | 'BIOTECH' | Industry of the Search or Target |
| Sub-Industry | sub_industry | 'ENTERTAINMENT' | Sub-sector of the industry field |
| Target Company | target_company | 'VACASA' | Company the SPAC intends to combine with |
| SPAC Share Symbol | share_symbol | 'SPAC' | Share symbol of the SPAC |
| SPAC Share Description | share_description | '1 Class A Common Stock' | Description of whether it's an Ordinary Share, Common Stock, Class A Common Stock, etc. |
| SPAC Share Close Price | share_close_price | 10.00 | Close price of the SPAC share |
| Unit Symbol | unit_symbol | 'SPACU' | The symbol of the SPAC's unit |
| Unit Close Price | unit_close_price | 10.00 | Close price of the SPAC unit |
| Warrant Symbol | warrant_symbol | 'SPACW' | Warrant symbol of the SPAC |
| Warrant Close Price | warrant_close_price | 10.00 | Close price of the SPAC warrant |
| Right Symbol | right_symbol | 'SPACR' | Right symbol of the SPAC |
| Right Close Price | right_close_price | 10.00 | Close price of the SPAC right |
| DeSPAC Share Symbol | despac_share_symbol | 'SPC' | De-SPAC share symbol (post-combination) |
| DeSPAC Share Price | despac_share_price | 10.00 | Close price of the de-SPAC share |
| Previous Close Share Price | redemption_despac_share_price | Previous close price of the SPAC or DeSPAC company (Dependant on SPAC status) | |
| DeSPAC Warrant Symbol | despac_warrant_symbol | 'SPCW' | De-SPAC warrant symbol (post-combination) |
| DeSPAC Warrant Price | despac_warrant_price | 10.00 | Close price of the de-SPAC warrant |
| Initial Filing Date | initial_filing_date | 1/1/2022 | The date the first registration statement (S-1) is filed publicly |
| IPO Date | ipo_date | 1/1/2022 | The date the SPAC prices its IPO and begins trading |
| Announced Date | announced_date | 1/1/2022 | The date the SPAC announces a combination with a target company |
| Closing Or Liquidation Date | closing_or_liquidation_date | 1/1/2022 | The date the SPAC combination closes (the de-SPAC date) or the date the SPAC liquidates |
| Closing Date | closing_date | The date the SPAC combination closes (the de-SPAC date) | |
| Liquidation Date | liquidation_date | The date the SPAC liquidates | |
| Months To Complete | months_to_complete | 18 | The amount of time a SPAC is initially given to complete a combination (without any extensions) |
| Months Left to Complete | months_left_to_complete | The number of months between now and the completion deadline date | |
| Auto Extension Time (months) | auto_extension_time | 6 | The amount of time a SPAC can automatically extend its completion deadline without needing a shareholder vote to extend (typically requires a contribution to trust) |
| Current Completion Deadline Date | completion_deadline_date_generated | 1/1/2022 | Based on the current deadline and contribution. Example: If a SPAC can extend 6 months, but by one month at a time with contribution, the current deadline will be based on each month's contribution |
| Initial Resale Reg. Filing Date | initial_resale_s1_filing_date | 1/1/2022 | The intial filing date of the de-SPAC resale registration statement post closing of the combination |
| Termination Date | termination_date | 1/1/2022 | The date a SPAC cancels (terminates) its announced combination with a target company. The SPAC can either continue looking or decide to liquidate. |
| Terminated Deal Name | terminated_deal_name | 'TRANSFIX INC' | The name of the company the SPAC initially announced a combination and then terminated |
| IPO Proceeds ($mm) | ipo_proceeds | 123456789 | The amount of capital raised by investors at SPAC IPO |
| IPO Size Range | ipo_size_cat | '$200-$500mm' | Size category given this SPAC's IPO proceeds |
| Total Public Proceeds at IPO ($mm) | total_public_proceeds | 123456789 | ipo proceeds + over allotment, NO trust |
| Over Allotment Proceeds ($mm) | over_allotment_proceeds | 12345678 | The amount of additional capital raised in the over-allotment (maximum is 15% of IPO proceeds) |
| Private Placement Proceeds ($mm) | private_placement_proceeds | 12345678 | The amount of capital the sponsors contribute to the IPO transaction |
| Total Gross Proceeds In Trust at IPO ($mm) | total_gross_proceeds_in_trust | 123456789 | The total amount of capital held in the trust account that includes any over-funding by the sponsors. (no redemptions) |
| % Held In Trust | percent_held_in_trust | 1.00 | The amount held in trust relative to the IPO price on a percentage basis. |
| Held In Trust Per Unit at IPO | held_in_trust_per_unit | 10.00 | The amount in trust relative to the IPO price on a per unit basis. |
| Current Public SPAC Shares | current_public_spac_shares | 1234567 | Total public shares at IPO less any redemptions |
| Sponsor Promote Shares | atrisk_promote_share | 1234567 | This is calculating the 20% promote shares based on the total IPO size and dependent on whether the promote is a manual input or a calculation (if greater than 20%) |
| Sponsor Forfeited Shares | sponsor_forfeiture_shares | 1234567 | The number of founder shares a sponsor will forfeit at combination close |
| Total Current Shares Outstanding | total_current_shares_outstanding | 12345678 | Total shares outstanding less any redemptions and forfeited sponsor shares |
| % Redeemed | percent_redeemed | 0.87 | The percentage of public SPAC shares redeemed |
| Pro Forma Enterprise Value ($mm) | pf_enterprise_value | 123456789 | The estimated pro forma enterprise value of the combined company |
| Pro Forma Equity Value ($mm) | equity_value | 123456789 | Pro-forma equity value |
| Equity Value Range | equity_value_cat | '$300mm-$2bn' | Pro-forma equity value size ranges |
| Transaction Costs ($mm) | transaction_costs | 12345678 | Transaction costs for the deal announcement |
| ROI | roi | 0.0293 | Current share price + warrant price + right price / intital IPO price (Warrant price and right price have been adjusted for distribution) |
| ARR | arr | 0.0293 | Annual rate of return |
| % Return on Share | percent_return | 0.13 | The return based on the current share price compared to the initial IPO price |
| % Return on DeSPAC Share | despac_percent_return | 0.13 | the return based on the current de-SPAC share price compared to the initial IPO price |
| Left Lead UW | left_lead_uw | 'CANTOR FITZGERALD' | The name of the SPAC's left lead underwriter |
| UW Fees Upfront | uw_fees_upfront | 0.02 | The underwriting fees received at IPO |
| UW Fees Deferred | uw_fees_deferred | 0.035 | The underwriting fees received upon a successful combination close |
| Warrants In Unit | warrants_in_unit_string | '1 for 1/2' | Warrants included in the SPAC's unit as a string |
| Warrants In Unit (Decimal) | warrants_in_unit_float | 1.0 | Warrants included in the SPAC's unit as a decimal |
| Warrant Call Trigger | warrant_call_trigger | 'Cash/Cashless: $18.00' | The share price at which the de-SPAC company may call their warrants for exercise |
| Warrant Exercise Price | warrant_exercise_price | 11.5 | The price at which an investor can exercise the warrants (cash or cashless exercise) post-combination close. Typically 115% of the IPO price. |
| Rights In Unit | rights_in_unit_string | '1 for 1/2' | Rights included in the SPAC's unit as a string |
| Rights In Unit (Decimal) | rights_in_unit_float | 1.0 | Rights included in the SPAC's unit as a decimal |
| Min Cash Closing Condition ($mm) | min_cash_closing_condition | 123456789 | A term some de-SPACs use whereby the stipulate a minimum amount of cash at closing (from trust, PIPEs, additional funding sources, etc) |
| Anchor Investor | anchor_investors | ||
| Anchor Size ($mm) | anchor_size | 123456789 | The size of the anchor investment at IPO where an investor agrees to subscribe for a large portion of the offering |
| Has Anchor Funding | has_anchor_funding | 'Yes' | |
| Crescent Term (Y/N) | crescent_term | 'Yes' | A term that provides protection to warrantholders in the event a PIPE is used in a combination with a price struck below a threshold price |
| Crescent Term Threshold | crescent_term_threshold | 9.20 | The threshold price where a warrantholder in a SPAC has their strike price reset if a PIPE is done at a price below it. |
| CEO | ceo | 'KRISTI MARVIN' | Chief Executive Officer |
| Chairman | chairman | 'KRISTI MARVIN' | Chairman of the Board |
| Domicile | domicile | 'DELAWARE' | Where a SPAC is domiciled, i.e., Delaware, Cayman Islands, BVI, etc. |
| IPO Geography | ipo_geography | 'UNITED STATES' | What geographic area a SPAC intends to search for a target company within |
| DeSPAC Geography | despac_geography | 'UNITED STATES' | Where the de-SPAC company is domiciled (Ex. Cayman, Delaware, Luxemborg) |
| Stock Exchange | stock_exchange | 'NASDAQ' | Which stock exchange a SPAC IPO will trade - Nasdaq vs. NYSE |
| Archived Combination | archived_combination | GCM GROSVENOR | |
| Filed Early Liquidation Proxy | filed_early_liquidation_proxy | 'Yes' | Whether a SPAC has filed to move up their deadline date so the SPAC can liquidate early. Ex. If a SPAC is given 24 months to complete a combination but would like to liquidate at month 14. They will hold a shareholder vote for approval so they can liquidate earlier than 24 months |
| Liquidation Announcement Date | liquidation_announcement_date | 1/1/2022 | The date at which a SPAC has announced via 8K, early liquidation proxy, or press release that it intends to liquidate. |
| Has Liquidation Announcement Date | has_liquidation_announcement_date | 'Yes' | Has officially announced the intent to liquidate |
| Sponsor | sponsor | 'CF FINANCE HOLDINGS LLC' | The sponsor team of a SPAC. Can be institutional (PE, Hedge Fund, Asset Manager - backed) or a group of individuals (traditional sponsor team) |
| Sponsor Owner | sponsor_owner | 'CANTOR FITZGERALD' | The institutional entity of the SPAC sponsor group - typically an LLC |
| Sponsor Group | sponsor_group | 'CF TEAM CANTORLUTNICK' | The name of the Sponsor Group. Typically for institutionally backed teams, but also for serial sponsors made up of individuals - Hennessy Team, Gores Team, etc. |
| Sponsor Type | sponsor_type | 'BANK' | What type of institution sponsoring the SPAC - Private Equity (PE), Asset Manager (AM), Hedge Fund (HF), etc |
| Company Lockup Period (months) | company_lockup_period_months | 6 | The amount of time a de-SPAC company cannot trade the shares received in a combination |
| Company Lockup % Released | company_lockup_pct_released | 0.5 | The % subject to release in the event the company meets certain performance hurdles |
| Company Early Release (days) | company_early_release_days | 150 | The number of days from combination close that a company can be eligible for early release |
| Company Performance Hurdle One | company_performance_hurdle_one | 10.00 | The various performance hurdles that release shares from lock-up |
| Company % Subject To Hurdle One | company_pct_subject_to_hurdle_one | 0.5 | The % of shares released at each hurdle when performance critieria are met |
| Company Performance Hurdle Two | company_performance_hurdle_two | 10.00 | The various performance hurdles that release shares from lock-up |
| Company % Subject To Hurdle Two | company_pct_subject_to_hurdle_two | 0.5 | The % of shares released at each hurdle when performance critieria are met |
| Company Performance Hurdle Three | company_performance_hurdle_three | 10.00 | The various performance hurdles that release shares from lock-up |
| Company % Subject To Hurdle Three | company_pct_subject_to_hurdle_three | 0.5 | The % of shares released at each hurdle when performance critieria are met |
| Company Performance Hurdle Four | company_performance_hurdle_four | 10.00 | The various performance hurdles that release shares from lock-up |
| Company % Subject To Hurdle Four | company_pct_subject_to_hurdle_four | 0.5 | The % of shares released at each hurdle when performance critieria are met |
| Company Lockup Vesting Period (months) | company_lockup_vesting_period_months | 12 | The number of months a de-SPAC company must vest their shares |
| Outside Termination Date Original | outside_termination_date_original | 1/1/2022 | SPACs sometimes amended their Outside Dates with target companies. This is showing the original Outside Date |
| Outside Termination Date Amended | outside_termination_date_amended | 1/1/2022 | SPACs sometimes amended their Outside Dates with target companies. This is showing the amended Outside Date |
| Company Lockup Expiry Date | company_lockup_exp_date | 1/1/2022 | The date on the negotiated lock-up of shares issued to a target company expires |
| Sponsor Lockup Expiry Date | sponsor_lockup_exp_date | 1/1/2022 | The date on which the sponsor lock-up of founder shares expires |
| Sponsor Lockup Period (months) | sponsor_lockup_period_months | 6 | The amount of time a sponsor cannot trade the founder shares received in a combination |
| Sponsor Lockup % Released | sponsor_lockup_pct_released | 0.5 | The % subject to release in the event the sponsor meets certain performance hurdles |
| Sponsor Early Release (days) | sponsor_early_release_days | 150 | The number of days from combination close that a sponsor can be eligible for early release |
| Sponsor Performance Hurdle One | sponsor_performance_hurdle_one | 10.00 | The various performance hurdles that release founder shares from lock-up |
| Sponsor % Subject To Hurdle One | sponsor_pct_subject_to_hurdle_one | 0.5 | The % of founder shares released at each hurdle when performance critieria are met |
| Sponsor Performance Hurdle Two | sponsor_performance_hurdle_two | 10.00 | The various performance hurdles that release founder shares from lock-up |
| Sponsor % Subject To Hurdle Two | sponsor_pct_subject_to_hurdle_two | 0.5 | The % of founder shares released at each hurdle when performance critieria are met |
| Sponsor Performance Hurdle Three | sponsor_performance_hurdle_three | 10.00 | The various performance hurdles that release founder shares from lock-up |
| Sponsor % Subject To Hurdle Three | sponsor_pct_subject_to_hurdle_three | 0.5 | The % of founder shares released at each hurdle when performance critieria are met |
| Sponsor Performance Hurdle Four | sponsor_performance_hurdle_four | 10.00 | The various performance hurdles that release founder shares from lock-up |
| Sponsor % Subject To Hurdle Four | sponsor_pct_subject_to_hurdle_four | 0.5 | The % of founder shares released at each hurdle when performance critieria are met |
| Sponsor Lockup Vesting Period (months) | sponsor_lockup_vesting_period_months | 12 | The number of months a sponsor must vest their founder shares |
| Company Earnout % One | company_earnout_pct_one | 0.5 | The % shares subject to earnout based on certain thresholds |
| Company Earnout Threshold One | company_earnout_threshold_one | 10.00 | The various thresholds that qualify shares in an earnout |
| Company Earnout % Two | company_earnout_pct_two | 0.5 | The % shares subject to earnout based on certain thresholds |
| Company Earnout Threshold Two | company_earnout_threshold_two | 10.00 | The various thresholds that qualify shares in an earnout |
| Company Earnout % Three | company_earnout_pct_three | 0.5 | The % shares subject to earnout based on certain thresholds |
| Company Earnout Threshold Three | company_earnout_threshold_three | 10.00 | The various thresholds that qualify shares in an earnout |
| Company Earnout % Four | company_earnout_pct_four | 0.5 | The % shares subject to earnout based on certain thresholds |
| Company Earnout Threshold Four | company_earnout_threshold_four | 10.00 | The various thresholds that qualify shares in an earnout |
| Company Earnout Early Vesting (yrs) | company_earnout_early_vesting_years | 1.5 | The number of years in order to be eligible for early vesting of an earnout |
| Company Earnout Vesting Period (yrs) | company_earnout_vesting_period_years | 1.5 | The number of years a company is subject to an earnout |
| Company Earnout Share Amount | company_earnout_share_amount | 1234567 | The number of shares eligible in a company earnout |
| Sponsor Earnout % One | sponsor_earnout_pct_one | 0.5 | The % shares subject to earnout based on certain thresholds |
| Sponsor Earnout Threshold One | sponsor_earnout_threshold_one | 10.00 | The various thresholds that qualify shares in an earnout |
| Sponsor Earnout % Two | sponsor_earnout_pct_two | 0.5 | The % shares subject to earnout based on certain thresholds |
| Sponsor Earnout Threshold Two | sponsor_earnout_threshold_two | 10.00 | The various thresholds that qualify shares in an earnout |
| Sponsor Earnout % Three | sponsor_earnout_pct_three | 0.5 | The % shares subject to earnout based on certain thresholds |
| Sponsor Earnout Threshold Three | sponsor_earnout_threshold_three | 10.00 | The various thresholds that qualify shares in an earnout |
| Sponsor Earnout % Four | sponsor_earnout_pct_four | 0.5 | The % shares subject to earnout based on certain thresholds |
| Sponsor Earnout Threshold Four | sponsor_earnout_threshold_four | 10.00 | The various thresholds that qualify shares in an earnout |
| Sponsor Earnout Early Vesting (yrs) | sponsor_earnout_early_vesting_years | 1.5 | The number of years in order to be eligible for early vesting of an earnout |
| Sponsor Earnout Vesting Period (yrs) | sponsor_earnout_vesting_period_years | 1.5 | The number of years a sponsor is subject to an earnout |
| Sponsor Earnout Share Amount | sponsor_earnout_share_amount | 1234567 | The number of shares eligible in a sponsor earnout |
| Sponsor Earnout Warrant Amount | sponsor_earnout_warrant_amount | 1234567 | The number of warrants eligible in a sponsor earnout |
| Projected Rev 2021 ($mm) | projected_rev_2021 | 123456789 | The projected revenue of the target company found in the filed documents when the merger is announced (2021) |
| Actual Rev 2021 ($mm) | actual_rev_2021 | 123456789 | The actual revenue of the target or de-SPAC company found in the filed 10-K (2021) |
| % Above/Below Projected 2021 | percent_above_below_projections_2021 | 0.10 | The percentage the actual stated revenue is above or below the projected revenue |
| Projected Rev 2022 ($mm) | projected_rev_2022 | 123456789 | The projected revenue of the target company found in the filed documents when the merger is announced (2022) |
| Actual Rev 2022 ($mm) | actual_rev_2022 | 123456789 | The actual revenue of the target or de-SPAC company found in the filed 10-K (2022) |
| % Above/Below Projected 2022 | percent_above_below_projections_2022 | 0.10 | The percentage the actual stated revenue is above or below the projected revenue |
| Projected Rev 2023 ($mm) | projected_rev_2023 | 123456789 | |
| Actual Rev 2023 ($mm) | actual_rev_2023 | 123456789 | |
| % Above/Below Projected 2023 | percent_above_below_projections_2023 | 0.10 | |
| Projected Rev 2024 ($mm) | projected_rev_2024 | 123456789 | |
| Actual Rev 2024 ($mm) | actual_rev_2024 | 123456789 | |
| % Above/Below Projected 2024 | percent_above_below_projections_2024 | 0.10 | |
| Projected Rev 2025 ($mm) | projected_rev_2025 | 123456789 | |
| Actual Rev 2025 ($mm) | actual_rev_2025 | 123456789 | |
| % Above/Below Projected 2025 | percent_above_below_projections_2025 | 0.10 | |
| Projected Rev 2026 ($mm) | projected_rev_2026 | 123456789 | |
| Actual Rev 2026 ($mm) | actual_rev_2026 | 123456789 | |
| % Above/Below Projected 2026 | percent_above_below_projections_2026 | 0.10 | |
| Projected EBITDA 2021 ($mm) | projected_ebitda_2021 | The projected EBITDA of the target company found in the filed documents when the merger is announced (2021) | |
| Actual EBITDA 2021 ($mm) | actual_ebitda_2021 | The projected EBITDA of the target or de-SPAC company found in the filed documents when the merger is announced (2021) | |
| % Above / Below EBITDA Projections 2021 | percent_above_below_ebitda_projections_2021 | The percentage the actual stated EBITDA is above or below the projected EBITDA | |
| Projected EBITDA 2022 ($mm) | projected_ebitda_2022 | The projected EBITDA of the target company found in the filed documents when the merger is announced (2022) | |
| Actual EBITDA 2022 ($mm) | actual_ebitda_2022 | The actual EBITDA of the target or de-SPAC company found in the filed 10-K (2022) | |
| % Above / Below EBITDA Projections 2022 | percent_above_below_ebitda_projections_2022 | The percentage the actual stated EBITDA is above or below the projected EBITDA | |
| Projected EBITDA 2023 ($mm) | projected_ebitda_2023 | ||
| Actual EBITDA 2023 ($mm) | actual_ebitda_2023 | ||
| % Above / Below EBITDA Projections 2023 | percent_above_below_ebitda_projections_2023 | ||
| Projected EBITDA 2024 ($mm) | projected_ebitda_2024 | ||
| Actual EBITDA 2024 ($mm) | actual_ebitda_2024 | ||
| % Above / Below EBITDA Projections 2024 | percent_above_below_ebitda_projections_2024 | ||
| Projected EBITDA 2025 ($mm) | projected_ebitda_2025 | ||
| Actual EBITDA 2025 ($mm) | actual_ebitda_2025 | ||
| % Above / Below EBITDA Projections 2025 | percent_above_below_ebitda_projections_2025 | ||
| Projected EBITDA 2026 ($mm) | projected_ebitda_2026 | ||
| Actual EBITDA 2026 ($mm) | actual_ebitda_2026 | ||
| % Above / Below EBITDA Projections 2026 | percent_above_below_ebitda_projections_2026 | ||
| At-Risk Capital ($mm) | atrisk_capital | 123456789 | The capital a sponsor contributes to the SPAC via private placement and placed in the trust account that is fully at-risk in a liquidation. Typically contributed via a purchase of warrants, units, or shares at IPO. |
| % At-Risk | percent_atrisk | 1.00 | The % of sponsor at-risk capital relative to the public IPO proceeds |
| Units/Warrants Purchased | atrisk_capital_type | 'Units' | Noting which type of security was used in the at-risk private placement - unit, warrants, shares, etc |
| At-Risk Purchase Price | atrisk_purchase_price | '$10.00/ $1.00' | The purchase price at which the at-risk units/warrants were purchased in the at-risk private placement |
| At-Risk Units/Warrants Purchased | atrisk_amount | '330K Units/ 1.65M Wts' | The number of at-risk units/warrants purchased in the at-risk private placement |
| Public Shares At IPO | public_shares_at_ipo | 1234567 | The number of public SPAC shares issued at IPO. Example: In a $100M offering, at $10.00 per unit, there would be 10 million public SPAC shares included in the unit. |
| Public SPAC Shares Post-Vote | redemption_shares_post_vote | 1234567 | The number of public SPAC shares after any redemptions at an extension or completion vote. |
| Total Shares Redeemed | total_redemptions | 1234567 | The total number of shares redeemed at a shareholder vote, i.e., an extension or completion vote |
| Trust Value Post-Vote ($mm) | trust_value_post_redemption | 123456789.00 | The current trust value (including any interest earned) less an redemptions of shares at a shareholder vote. |
| Redemption Price At Vote | redemption_price_at_vote | 10.00 | The redemption price at which shareholders could redeem their shares at a shareholder vote |
| Last Vote Date | redemption_last_vote_date | 1/1/2022 | The last vote date held - could be an extension vote or a completion vote. |
| Has Redemption Last Vote Date | has_redemption_last_vote_date | 'Yes' | Has a redemption vote date - yes or no answer - used to determine if a SPAC or group of SPACs have extended |
| 2-WK VWAP | two_wk_vwap | 10.00 | The 2 week VWAP is the volume weighted average price over a two-week period. |
| Redemption Value Per Share | redemption_value | The redemption value per share is cash-per-share value of the trust account. If a shareholder redeems at a vote, they would receive the redemption value per share. | |
| Maximum Deadline Date | worst_deadline_date | The maximum deadline date is the date at which a SPAC must complete its combination and assumes all extensions have been taken. Example, a SPAC is given 24 months to complete, but can extend 2x for 3-months each with a contribution to trust. The maximum deadline would be 30 months. | |
| Current Implied Cash Per Share | current_implied_cash_per_share | 10.00 | The current implied cash per share is the estimated cash-per-share value or redemption value. This is an estimated value. |
| Current Deadline Implied Cash Per Share | deadline_implied_cash_per_share | 10.00 | The current estimated trust value expressed on a per share basis |
| Maximum Deadline Implied Cash Per Share | worst_implied_cash_per_share | 10.00 | The implied cash per share value based on the maximum deadline date and the estimate interest accrued at that time. |
| YTM Earliest Date | ytm_earliest_date | 0.035 | The estimated trust value as of the completion deadline date expressed on a per share basis |
| YTM Latest Date | ytm_latest_date | 0.035 | The calculated yield to maturity (YTM) of a SPAC based on the estimated trust value as of today and using the current completion deadline |
| YTM Maximum Date | ytm_worst_date | 0.035 | The calculated yield to maturity (YTM) of a SPAC based on the estimated trust value as of the maximum deadline date |
| 10-Q/K or Proxy as of Date | trust_value_10qk_proxy | 1/1/2022 | The calculated yield to maturity (YTM) of a SPAC based on the estimated trust value as of the completion date and using a completion deadline |
| 10-Q/K Cash In Trust | cash_in_trust_10qk | 123456789.00 | This is the date most recent 10-Q, 10-K, Proxy, or Vote Date that has a new Trust Value |
| Current Total Gross Proceeds In Trust ($mm) | current_total_gross_proceeds_in_trust | 123456789.00 | This is the trust value (including overfuding) less any recent redemptions |
| Current Ending Trust Balance ($mm) | current_ending_trust_balance | 123456789.00 | This is the SPACInsider estimated trust value as of the current day based on our internal model |
| Record Date | record_date | 1/1/2022 | The date at which an investor must own the share in order to be a 'shareholder of record' |
| Has Record Date | has_record_date | 'Yes' | The date at which an investors votes on either an extension of a SPAC's deadline or the completion vote |
| Extension Vote Date | extension_vote_date | 1/1/2022 | The date at which a shareholder must redeem their shares (if they wish to) ahead of a vote. Typically 2 trading days before a vote date. |
| Ext Vote 1 Redemptions | extension_vote_1 | 1234567 | The number of public SPAC shares redeemed at the first extension vote |
| Ext Vote 1 Date | extension_vote_1_date | Date of the 1st extension vote | |
| Ext Vote 1 Rdmpt Price | extension_vote_1_rdmpt_price | Redemption price at the vote | |
| Ext Vote 1 Link | extension_vote_1_link | Link to the Definitive Proxy for the Vote | |
| Ext Vote 2 Redemptions | extension_vote_2 | 1234567 | The number of public SPAC shares redeemed at the second extension vote |
| Ext Vote 2 Date | extension_vote_2_date | Date of the 2ndextension vote | |
| Ext Vote 2 Rdmpt Price | extension_vote_2_rdmpt_price | Redemption price at the vote | |
| Ext Vote 2 Link | extension_vote_2_link | Link to the Definitive Proxy for the Vote | |
| Ext Vote 3 Redemptions | extension_vote_3 | 1234567 | The number of public SPAC shares redeemed at the third extension vote |
| Ext Vote 3 Date | extension_vote_3_date | Date of the 3rd extension vote | |
| Ext Vote 3 Rdmpt Price | extension_vote_3_rdmpt_price | Redemption price at the vote | |
| Ext Vote 3 Link | extension_vote_3_link | Link to the Definitive Proxy for the Vote | |
| Ext Vote 4 Redemptions | extension_vote_4 | 1234567 | The number of public SPAC shares redeemed at the fourth extension vote |
| Ext Vote 4 Date | extension_vote_4_date | Date of the 4th extension vote | |
| Ext Vote 4 Rdmpt Price | extension_vote_4_rdmpt_price | Redemption price at the vote | |
| Ext Vote 4 Link | extension_vote_4_link | Link to the Definitive Proxy for the Vote | |
| Ext Vote 5 Redemptions | extension_vote_5 | 1234567 | The number of public SPAC shares redeemed at the fifth extension vote |
| Ext Vote 5 Date | extension_vote_5_date | Date of the 5th extension vote | |
| Ext Vote 5 Rdmpt Price | extension_vote_5_rdmpt_price | Redemption price at the vote | |
| Ext Vote 5 Link | extension_vote_5_link | Link to the Definitive Proxy for the Vote | |
| Completion Vote Redemptions | completion_vote | The number of public shares redeemed at the completion vote. | |
| Number Of Auto Extensions | number_of_auto_extensions | 3 | The number of auto-extensions at IPO |
| Auto-Ext. Contribution (per shr) | per_share_auto_extension | 0.10 | Amount per share contributed for the auto-extension |
| Vote Extension Time (months) | vote_extension_months_maximum | The amount of time that the SPAC asked for at the extension vote | |
| Total Time to Complete (Initial + Extensions) | total_months_given_plus_extension_months_maximum | The total time to complete calculating the intial time given (ex. 24 months), plus and auto extensions or extensions by shareholder vote | |
| Total Extension Contributions (Maximum) | vote_extension_contribution_to_date_maximum | The total amount of additional contribution of funds to trust in order to extend the intial amount of time given to a SPAC. | |
| Vote Extension 1 (months) | vote_extension_months_1 | 3 | Months alloted to exend the initial time given |
| Vote Ext. 1 (# of Exts.) | number_of_vote_extensions_1 | 1 | Amount of times needed to extend (1 time for 3 months, 9 times for 9 months) |
| Vote Ext. 1 Contribution (per shr) | per_share_vote_extension_1 | 0.10 | Per share contributed for each number of extensions |
| Vote Extension 2 (months) | vote_extension_months_2 | 3 | Months alloted to exend the initial time given |
| Vote Ext. 2 (# of Exts.) | number_of_vote_extensions_2 | 1 | Amount of times needed to extend (1 time for 3 months, 9 times for 9 months) |
| Vote Ext. 2 Contribution (per shr) | per_share_vote_extension_2 | 0.10 | Per share contributed for each number of extensions |
| Vote Extension 3 (months) | vote_extension_months_3 | 3 | Months alloted to exend the initial time given |
| Vote Ext. 3 (# of Exts.) | number_of_vote_extensions_3 | 1 | Amount of times needed to extend (1 time for 3 months, 9 times for 9 months) |
| Vote Ext. 3 Contribution (per shr) | per_share_vote_extension_3 | 0.10 | Per share contributed for each number of extensions |
| Vote Extension 4 (months) | vote_extension_months_4 | 3 | Months alloted to exend the initial time given |
| Vote Ext. 4 (# of Exts.) | number_of_vote_extensions_4 | 1 | Amount of times needed to extend (1 time for 3 months, 9 times for 9 months) |
| Vote Ext. 4 Contribution (per shr) | per_share_vote_extension_4 | 0.10 | Per share contributed for each number of extensions |
| Vote Extension 5 (months) | vote_extension_months_5 | 3 | Months alloted to exend the initial time given |
| Vote Ext. 5 (# of Exts.) | number_of_vote_extensions_5 | 1 | Amount of times needed to extend (1 time for 3 months, 9 times for 9 months) |
| Vote Ext. 5 Contribution (per shr) | per_share_vote_extension_5 | 0.10 | Per share contributed for each number of extensions |
| Completion Vote Date | completion_vote_date | 1/1/2022 | The date at which a shareholder must redeem their shares (if they wish to) ahead of a vote. Typically 2 trading days before a vote date. |
| Shareholder Vote Date | shareholder_vote_date | 1/1/2022 | The date at which shareholders are asked to vote on a proposal put forth by a SPAC. Typically an extension or completion vote. |
| Redemption Deadline | redemption_deadline | 1/1/2022 | The deadline at which public shareholders must request to redeem their shares at a shareholder vote. Typically two business days ahead of a shareholder vote. |
| Contribution to Trust Pending Vote | contribution_to_trust_pending_vote | '$70K per month (x6)' | The contribution to the trust by a SPAC team in order to extend their completion deadline. Example - a sponsor may contribute $0.10 per share in order to extend 3-months time. |
| Proxy Type on File | proxy_type_on_file | 'BUSINESS COMBINATION' | |
| Proxy Link | proxy_link | https://www.sec.gov/Archives/edgar/data/1865377/000119312522293440/d385773ddef14a.htm | Link to the current proxy filing |
| Underwriter 1 | underwriter_1 | The left lead underwriter | |
| Underwriter 2 | underwriter_2 | The second underwriter listed in importance | |
| Underwriter 3 | underwriter_3 | The third underwriter listed in importance | |
| Underwriter 4 | underwriter_4 | The fourth underwriter listed in importance | |
| Underwriter 5 | underwriter_5 | The fifth underwriter listed in importance | |
| Book-Runners / Lead Managers | book_runners_and_lead_managers | {'CANTOR FITZGERALD'} | The bookrunners and lead managers listed in the offering |
| Co-Managers | co_managers | 'CANTOR FITZGERALD' | The co-managers listed in the offering |
| Issuer's Counsel | issuers_counsel | {'CANTOR FITZGERALD'} | The law firm representing the SPAC in an IPO offering |
| Underwriter's Counsel | underwriters_counsel | {'CANTOR FITZGERALD'} | The law firm representing the underwriters in an IPO offering |
| Auditor | auditor | {'CANTOR FITZGERALD'} | The auditor representing the SPAC in an IPO offering |
| PIPE Size ($mm) | pipe_size | 123456789.00 | The total size of the PIPE raise to close concurrently in a de-SPAC. |
| PIPE Size Range | pipe_size_cat | '$100-$200mm' | The range is listed for analytical purposes. Example, if you wanted to sort for SPACs that included a PIPE in a certain size range. |
| PIPE Investor(s) | pipe_investors | {'UNDISCLOSED INVESTORS'} | Who the PIPE investors were (if they were listed in the press release or filed documentation) |
| PIPE Share Price | pipe_share_price | 10.00 | The purchase price investors will pay in the PIPE |
| PIPE Ownership Percent | pipe_ownership_percent | 0.22 | The % ownership of the pro forma company the PIPE investors will own. |
| PIPE Security Type | pipe_security_type | 'SHARE' | The security type investors will be purchasing in the PIPE transaction |
| PIPE Lock Up | pipe_lock_up | 'UPON REGISTRATION' | How long the PIPE investors will be restricted from selling, transferring, etc the securities they purchased in the PIPE |
| PIPE Warrants In Unit | pipe_warrants_in_unit_float | 0.5 | The number of warrants (if any) included as part of the investors purchase in a PIPE |
| PIPE Warrant Strike Price | pipe_warrant_strike_price | 10.00 | The strike price of the warrants that were included (if any) in the PIPE offering |
| PIPE Link | pipe_link | https://www.sec.gov/Archives/edgar/data/1728041/000121390020019788/ea124879_8k.htm | The link to the filed document detailing the PIPE transaction |
| Has PIPE Funding | has_pipe_funding | 'Yes' | Yes or No answer - used for sorting in the tables which transactions included a PIPE in their combinations |
| Non Redemption Security Type | non_redemption_security_type | 'SHARES' | The type of security used in the non-redemption agreement as part of the backstop financing at combination |
| Non Redemption Size ($mm) | non_redemption_size | 123456789 | The size of the non-redemption agreement at which investors are participating |
| Non Redemption Purchase Price | non_redemption_purchase_price | 123456789 | The purchase price at which investors have agreed to purchase shares (if any) as part of the non-redemption agreement |
| Non Redemption Investor(s) | non_redemption_investors | {'SPAC Sponsor', 'Unnamed Investor'} | The names of the investors (if disclosed) participating in the non-redemption agreement |
| Non Redemption Link | non_redemption_link | https://www.sec.gov/ix?doc=/Archives/edgar/data/1814114/000114036122024892/ny20004465x4_8k.htm | The link to the filed documents detailing the non-redemption agreement |
| Has Non Redemption Funding | has_non_redemption_funding | 'Yes' | Yes or No answer - used for sorting in the tables which transactions included a non-redemption agreement in their combinations |
| FPA Investor(s) | fpa_investor | 'CF FINANCE HOLDINGS LLC' | The names of investors (if disclosed) that participated in a forward purchase agreement at combination |
| FPA Size ($mm) | fpa_size | 123456789 | The size of the forward purchase agreement at which investors are subscribing |
| FPA Security Type | fpa_security_type | 'SHARE' | The type of security the forward purchase investors are purchasing |
| FPA Warrants In Unit | fpa_warrants_in_unit_float | 0.5 | The number of warrants included in the FPA (if any) sold to investors |
| FPA Purchase Price | fpa_purchase_price | 10.00 | The purchase price at which investors are buying the Forward Purchase |
| FPA Commitment | fpa_commitment | 'COMMITTED' | Whether the FPA is committed (obligated) to be purchased or if an FPA purchase is at the discretion of the purchaser |
| FPA Link | fpa_link | https://www.sec.gov/Archives/edgar/data/1728041/000121390020019788/ea124879_8k.htm | The link to the document that details the FPA purchase |
| FPA Trust Percent | fpa_trust_percent | 0.105 | The percentage of the FPA purchase relative to the size of the IPO offering. Example: a $100M FPA for a $200M IPO would be 50% |
| Has FPA Funding | has_fpa_funding | 'Yes' | Yes or No answer - used for sorting in the tables which transactions included an FPA in their combinations |
| Note Minimum Rate | note_minimum_rate | 0.119 | The minimum interest rate for the convertible note (usually based on hurdles) |
| Note Maximum Rate | note_maximum_rate | 0.119 | The maximum interest rate for the convertible note (usually based on hurdles) |
| Note Maturity Period | note_maturity_period | 4.0 | The maturity period of the convertible note |
| Note Notes | note_notes | 'The Loan amortizes at a rate of 15.0% of outstanding principal per annum, beginning on the 24-month anniversary of the closing date of the Loan.' | An additional notes or necessary information on the convertible notes |
| Note Size ($mm) | note_size | 123456789.00 | The size of the convertible note |
| Note Time Period Payable | note_time_period_payable | 'MONTHLY' | The period in which the convertible note is payable - quarterly, semi-annual, etc |
| Note Investor(s) | note_investors | 'SUNSTREAM BANCORP INC' | The investors (if listed) of the convertible note |
| Note Link | note_link | https://www.sec.gov/Archives/edgar/data/1790665/000121390021040626/ea145321-8k_greenrose.htm | The link to the document listing the details of the convertible note |
| Has Note Funding | has_note_funding | 'Yes' | Yes or No answer - used for sorting in the tables which transactions included a convertible note in their combinations |
| Preferred Purchase Price | preferred_purchase_price | 1000.0 | The price at which a convertible preferred is to be purchased by investors |
| Preferred Shares Purchased | preferred_shares_purchased | 7000 | The number of convertible preferred shares purchased by investors |
| Preferred Aggregate Value ($mm) | preferred_aggregate_value | 123456789.0 | The total aggregate value of the convertible preferred to be purchased |
| Preferred Conversion Price | preferred_conversion_price | 10.00 | The price at which the convertible preferred will be converted |
| Preferred Interest Rate | preferred_interest_rate | 0.10 | The interest rate of the convertible preferred |
| Preferred Time Period Payable | preferred_time_period_payable | 'SEMI-ANUALLY' | The period in which the convertible preferred is payable - annual, semi-annual, etc |
| Preferred Investor(s) | preferred_investors | 'UNNAMED INVESTORS' | The investors (if listed) of the convertible preferred |
| Preferred Link | preferred_link | https://www.sec.gov/ix?doc=/Archives/edgar/data/1844452/000121390022056379/ea165812-8k_inflection.htm | The link to the document listing the details of the convertible preferred |
| Has Preferred Funding | has_preferred_funding | 'Yes' | Yes or No answer - used for sorting in the tables which transactions included a convertible preferred in their combinations |
| Other Funding Type | other_funding_type | 'PURCHASE AGREEMENT' | Any other type of funding agreement used in a SPAC combination - ex. Standby Equity Agreement, Senior Secured Term Loan, etc |
| Other Funding Size ($mm) | other_funding_size | 123456789.00 | The size of the 'other funding' |
| Other Funding Note | other_funding_note | 'Please refer to the SPAC profile page for more information about this funding type' | Any notes or additional description of the 'other funding' |
| Other Funding Link | other_funding_link | https://www.sec.gov/ix?doc=/Archives/edgar/data/1844452/000121390022056379/ea165812-8k_inflection.htm | The link to the document listing the details of the 'other funding' |
| Has Other Funding | has_other_funding | 'Yes' | Yes or No answer - used for sorting in the tables which transactions included a type of 'other funding' in their combinations |
| Total Additional Funding ($mm) | total_additional_funding_no_trust | 123456789.00 | The sum of all of the additional funding types (other than the funds held in trust) used in a combination |
| Total Funding Sources (Incl. Trust) ($mm) | total_funding_sources | 123456789.00 | The sum of both the funds held in trust and all other funding types used in a combination |
| EV / Trust Balance | ev_over_trust_balance | 25.00 | Multiple: Enterprise Value to Current Trust Balance (if a SPAC has had redemptions, this reflects the current trust balance) |
| EV / Total Funding Sources | ev_over_total_funding_sources | 25.00 | Multiple: Enterprise Value to Current Trust Balance (if a SPAC has had redemptions, this reflects the current trust balance) |
| Special Status | special_status | This is used for Completed SPACs that have had their status change occur after Closing. Example: Acquired by another company, filed for Bankruptcy | |
| DeSPAC CIK | despac_cik | '0000123456' | The CIK number of the De-SPAC'd company (different than the SPAC CIK) |
| Percent Redeemed (with null) | percent_redeemed_with_null | 0.100 | Internal use only |
| SPAC Display Name | raw_spac_name | 'Gores Holding VIII, Inc.' | Raw unformatted name |
| Additional Terms | additional_terms | {'Term example 1', 'Term example 2'} | Any additional, non-standard terms, included in the IPO prospectus |