Civic Intelligence

Coalescion

990 • Fiscal year 2022 • EIN 86-1436675

Jan 01, 2022 to Dec 31, 2022 • Filed on Apr 04, 2023

Organization ProfileWWW.COALESCION.ORG
1601 Hollindale DriveAlexandria, VA 22306

(571) 235-1547

Siviq Scores

Precomputed percentiles for this filing year versus similar nonprofits in the same peer cohort.

Liabilities / Assets

100th percentile

9.76x

Higher debt load relative to assets than 100% of similar nonprofits.

2022 filings • 501(c)3 • $500k-$1M nonprofits • Source year 2022

Liabilities / Revenue

71st percentile

0.13x

Higher debt load relative to revenue than 71% of similar nonprofits.

2022 filings • 501(c)3 • $500k-$1M nonprofits • Source year 2022

Net Margin

40th percentile

1.3%

Higher net margin than 40% of similar nonprofits.

2022 filings • 501(c)3 • $500k-$1M nonprofits • Source year 2022

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2022

Asset Growth

3rd percentile

-48%

Faster asset growth than 3% of similar nonprofits.

2022 filings • 501(c)3 • $500k-$1M nonprofits • Annualized from 2021 to 2022

Revenue Growth

99th percentile

1120%

Faster revenue growth than 99% of similar nonprofits.

2022 filings • 501(c)3 • $500k-$1M nonprofits • Annualized from 2021 to 2022

Balance Sheet
Liabilities / Assets100th percentile

Assets

Down

$8,217

Down $7,600 (-48%) from 2021

Net Assets

Up

-$71,991

Up $12,198 (+14%) from 2021

Liabilities

Down

$80,208

Down $20,594 (-20%) from 2021

Revenue And Expenses
Liabilities / Revenue71st percentileNet Margin40th percentile

Revenue

Up

$627,900

Up $576,427 (+1120%) from 2021

Expenses

Up

$619,754

Up $484,092 (+357%) from 2021

Net Income

Up

$8,146

Up $92,335 (+110%) from 2021

Historical Trend

Balance Sheet Trend

Asset Growth3rd percentile

The highlighted filing sits inside the broader history for assets, liabilities, and net assets.

$1.0M$500K$0-$500KAssets 2021: $15,817Liabilities 2021: $100,802Net Assets 2021: -$84,1892021Assets 2022: $8,217Liabilities 2022: $80,208Net Assets 2022: -$71,9912022Assets 2022: $18,180Liabilities 2022: $192,944Net Assets 2022: -$174,7642022Assets 2023: $13,461Liabilities 2023: $464,676Net Assets 2023: -$451,2152023Assets 2024: $155,087Liabilities 2024: $564,961Net Assets 2024: -$409,8742024

Highlighted filing

2022

Assets$8,217
Liabilities$80,208
Net Assets-$71,991
Open 2022 Filing

Operations Trend

Revenue Growth99th percentile

Revenue, expenses, and net income across loaded years, with this filing highlighted.

$2.0M$1.0M$0-$1.0MRevenue 2021: $51,473Expenses 2021: $135,662Net Income 2021: -$84,1892021Revenue 2022: $627,900Expenses 2022: $619,754Net Income 2022: $8,1462022Revenue 2022: $615,842Expenses 2022: $721,715Net Income 2022: -$105,8732022Revenue 2023: $734,225Expenses 2023: $1,010,676Net Income 2023: -$276,4512023Revenue 2024: $1,849,142Expenses 2024: $1,807,801Net Income 2024: $41,3412024

Highlighted filing

2022

Revenue$627,900
Expenses$619,754
Net Income$8,146
Open 2022 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2022 to Dec 31, 2022
Signed
Apr 4, 2023
Return Version
2022v5.0
Gross Receipts
$627,900
Mission and Program Overview

Mission

Training for security education

Educational security training

Balance Sheet Detail
LineBeginningEndChange
Assets
Cash and Non-Interest-Bearing Accounts-$5,406-
Total Assets$0$8,217▲ $8,217
Other Assets Total-$2,811-
Liabilities
Other Liabilities-$70,719-
Accounts Payable and Accrued Expenses-$9,489-
Total Liabilities$0$80,208▲ $80,208
Net Assets / Fund Balance
Net Assets Without Donor Restrictions-$-71,991-
Total Net Assets Fund Balance$0$-71,991▼ $71,991
Total Liabilities and Net Assets / Fund Balance$0$8,217▲ $8,217

Asset Categories

AssetBook ValueDepreciationBasis
Other Assets Org$2,811--
Compensation and Service Providers
Top Officer PayScore unavailable

Employees

NameTitleFull / Part TimeBaseTotal
Shawn Baker GaFounder CEOFT$50,000$50,000
Revenue and Support

Revenue Composition

Contributions and Grants
$0
Program Service Revenue
$627,445
Investment Income
$0
Other Revenue
$455
Change in Net Assets
$8,146
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Salaries, Compensation, and Employee Benefits$473,752
Other Expenses$141,875
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0
Total Fundraising Expense$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Current Officers, Directors, Trustees, and Key Employees$473,752--$473,752
Office Expenses$137,414--$137,414
Other Expenses$4,461--$4,461
Benefits to Members$4,127--$4,127
Total Functional Expenses$619,754$0$0$619,754
Fundraising, Events, and Gaming
Fundraising activities
No
Gaming activities
No
Professional fundraiser used
No

Fundraising and Gaming Totals

Line ItemAmount
Professional Fundraising Fees$0
Political and Lobbying Activity
Political campaign activity
No
Lobbying activity
No
Debt and Bond Financing

Other Reported Liabilities

LiabilityAmount
Loan from Officer Greg Baker$73,548
Governance and Compliance

Governance Checklist

Compiled or reviewed by an accountant
No
Annual disclosure for covered persons
Yes
Backup withholding compliance
Yes
Business relationship with 35% controlled entity
No
Business relationship with family members
No
Business relationship with organization members
No
Material changes to governing documents
No
Compensation from other sources disclosed
No
CEO compensation reviewed
Yes
Other officer compensation reviewed
No
Conflict-of-interest policy
Yes
Audited financial statements prepared
No
Key decisions subject to board approval
No
Management duties delegated
No
Filing and Contact Details

Filer

Filer Name
Coalescion
EIN
86-1436675
Address
1601 Hollindale Drive, ALEXANDRIA, VA 22306

Signing Officer

Name
Shawn Baker-Garcia
Title
CEO and Founder
Phone
5712351547
Signed
2023-04-04
Discuss with paid preparer
Yes

Organization Details

Principal Officer
Shawn Baker Garcia
Voting Board Members
1
Independent Board Members
0
Employees
0

Preparer

Firm
Alexandria Tax and Bookkeepi
Address
3682 King St 16934, ALEXANDRIA, VA 22302
Preparer
Christine Riccardi Cok
Phone
7034077545
Supplemental Narrative

Additional Explanations

security education training

“security education training”

Raw XML Appendix242 raw XML fields

This appendix keeps the raw XML leaves available for debugging and edge-case review. The human report above is the primary experience.

Path#Value
IRS990/AccountantCompileOrReviewInd0false
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt09489
IRS990/ActivitiesConductedPrtshpInd0false
IRS990/ActivityOrMissionDesc0Educational security training
IRS990/AnnualDisclosureCoveredPrsnInd0true
IRS990/BackupWthldComplianceInd0true
IRS990/BenefitsToMembersGrp/ProgramServicesAmt04127
IRS990/BenefitsToMembersGrp/TotalAmt04127
IRS990/BooksInCareOfDetail/PersonNm0Shawn Baker Garcia
IRS990/BooksInCareOfDetail/PhoneNum05712351547
IRS990/BooksInCareOfDetail/USAddress/AddressLine1Txt01601 Hollindale
IRS990/BooksInCareOfDetail/USAddress/CityNm0ALEXANDRIA
IRS990/BooksInCareOfDetail/USAddress/StateAbbreviationCd0VA
IRS990/BooksInCareOfDetail/USAddress/ZIPCd022306
IRS990/BusinessRlnWith35CtrlEntInd0false
IRS990/BusinessRlnWithFamMemInd0false
IRS990/BusinessRlnWithOrgMemInd0false
IRS990/CashNonInterestBearingGrp/EOYAmt05406
IRS990/ChangeToOrgDocumentsInd0false
IRS990/CntrctRcvdGreaterThan100KCnt00
IRS990/CollectionsOfArtInd0false
IRS990/CompCurrentOfcrDirectorsGrp/ProgramServicesAmt0473752
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt0473752
IRS990/CompensationFromOtherSrcsInd0false
IRS990/CompensationProcessCEOInd0true
IRS990/CompensationProcessOtherInd0false
IRS990/ConflictOfInterestPolicyInd0true
IRS990/ConservationEasementsInd0false
IRS990/ConsolidatedAuditFinclStmtInd0false
IRS990/CreditCounselingInd0false
IRS990/CYBenefitsPaidToMembersAmt04127
IRS990/CYContributionsGrantsAmt00
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt00
IRS990/CYOtherExpensesAmt0141875
IRS990/CYOtherRevenueAmt0455
IRS990/CYProgramServiceRevenueAmt0627445
IRS990/CYRevenuesLessExpensesAmt08146
IRS990/CYSalariesCompEmpBnftPaidAmt0473752
IRS990/CYTotalExpensesAmt0619754
IRS990/CYTotalFundraisingExpenseAmt00
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt0627900
IRS990/DAFExcessBusinessHoldingsInd0false
IRS990/DecisionsSubjectToApprovaInd0false
IRS990/DeductibleArtContributionInd0false
IRS990/DeductibleNonCashContriInd0false
IRS990/DelegationOfMgmtDutiesInd0false
IRS990/Desc0Training for security education
IRS990/DescribedInSection501c3Ind0true
IRS990/DisregardedEntityInd0false
IRS990/DistributionToDonorInd0false
IRS990/DocumentRetentionPolicyInd0true
IRS990/DonorAdvisedFundInd0false
IRS990/DonorRstrOrQuasiEndowmentsInd0false
IRS990/ElectionOfBoardMembersInd0false
IRS990/EmployeeCnt00
IRS990/EngagedInExcessBenefitTransInd0false
IRS990/ExcsTaxSect4951Or4952Or4953Ind0false
IRS990/ExpenseAmt0137414
IRS990/FamilyOrBusinessRlnInd0false
IRS990/FederalGrantAuditRequiredInd0false
IRS990/ForeignActivitiesInd0false
IRS990/ForeignFinancialAccountInd0false
IRS990/ForeignOfficeInd0false
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt040
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd0X
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt00
IRS990/Form990PartVIISectionAGrp/PersonNm0Shawn Baker Ga
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt050000
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt00
IRS990/Form990PartVIISectionAGrp/TitleTxt0Founder CEO
IRS990/Form990ProvidedToGvrnBodyInd0true
IRS990/FormerOfcrEmployeesListedInd0false
IRS990/FSAuditedInd0false
IRS990/FundraisingActivitiesInd0false
IRS990/GamingActivitiesInd0false
IRS990/GoverningBodyVotingMembersCnt01
IRS990/GrantsToIndividualsInd0false
IRS990/GrantsToOrganizationsInd0false
IRS990/GrantToRelatedPersonInd0false
IRS990/GrossReceiptsAmt0627900
IRS990/GroupReturnForAffiliatesInd0false
IRS990/IncludeFIN48FootnoteInd0false
IRS990/IndependentAuditFinclStmtInd0false
IRS990/IndependentVotingMemberCnt00
IRS990/IndivRcvdGreaterThan100KCnt00
IRS990/IndoorTanningServicesInd0false
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InvestmentInJointVentureInd0false
IRS990/IRPDocumentCnt00
IRS990/IRPDocumentW2GCnt00
IRS990/LoanOutstandingInd0false
IRS990/LobbyingActivitiesInd0false
IRS990/LocalChaptersInd0false
IRS990/MaterialDiversionOrMisuseInd0false
IRS990/MembersOrStockholdersInd0false
IRS990/MethodOfAccountingCashInd0X
IRS990/MinutesOfCommitteesInd0false
IRS990/MinutesOfGoverningBodyInd0false
IRS990/MiscellaneousRevenueGrp/RelatedOrExemptFuncIncomeAmt0455
IRS990/MiscellaneousRevenueGrp/TotalRevenueColumnAmt0455
IRS990/MissionDesc0Training for security education
IRS990/MoreThan5000KToIndividualsInd0false
IRS990/MoreThan5000KToOrgInd0false
IRS990/NetAssetsOrFundBalancesEOYAmt0-71991
IRS990/NetIncmFromFundraisingEvtGrp/TotalRevenueColumnAmt00
IRS990/NoDonorRestrictionNetAssetsGrp/EOYAmt0-71991
IRS990/NondeductibleContributionsInd0false
IRS990/OfficeExpensesGrp/ProgramServicesAmt0137414
IRS990/OfficeExpensesGrp/TotalAmt0137414
IRS990/OfficerMailingAddressInd0false
IRS990/OperateHospitalInd0false
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsFASB117Ind0X
IRS990/OtherAssetsTotalGrp/EOYAmt02811
IRS990/OtherExpensesGrp/Desc0advertising, interest
IRS990/OtherExpensesGrp/ProgramServicesAmt04461
IRS990/OtherExpensesGrp/TotalAmt04461
IRS990/OtherLiabilitiesGrp/EOYAmt070719
IRS990/OtherRevenueTotalAmt0455
IRS990/PartialLiquidationInd0false
IRS990/PoliticalCampaignActyInd0false
IRS990/PrincipalOfficerNm0Shawn Baker Garcia
IRS990/ProfessionalFundraisingInd0false
IRS990/ProgramServiceRevenueGrp/BusinessCd0611430
IRS990/ProgramServiceRevenueGrp/Desc0Education Training
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt0627445
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt0627445
IRS990/ProhibitedTaxShelterTransInd0false
IRS990/PYExcessBenefitTransInd0false
IRS990/PYProgramServiceRevenueAmt051473
IRS990/PYRevenuesLessExpensesAmt051473
IRS990/PYTotalRevenueAmt051473
IRS990/ReconcilationRevenueExpnssAmt08146
IRS990/RegularMonitoringEnfrcInd0false
IRS990/RelatedEntityInd0false
IRS990/RelatedOrganizationCtrlEntInd0false
IRS990/ReportInvestmentsOtherSecInd0false
IRS990/ReportLandBuildingEquipmentInd0false
IRS990/ReportOtherAssetsInd0false
IRS990/ReportOtherLiabilitiesInd0true
IRS990/ReportProgramRelatedInvstInd0false
IRS990ScheduleA/Form990ScheduleAPartVIGrp/ExplanationTxt0income rcvd from clients for educational services
IRS990ScheduleA/Form990ScheduleAPartVIGrp/FormAndLineReferenceDesc0Part II line 10
IRS990ScheduleA/GovtFurnSrvcFcltsVl170Grp/CurrentTaxYearMinus1YearAmt019575
IRS990ScheduleA/GovtFurnSrvcFcltsVl170Grp/TotalAmt019575
IRS990ScheduleA/OtherIncome170Grp/CurrentTaxYearMinus1YearAmt031898
IRS990ScheduleA/OtherIncome170Grp/TotalAmt031898
IRS990ScheduleA/OtherSupportSumAmt00
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00.38030
IRS990ScheduleA/PublicSupportPY170Pct00.38030
IRS990ScheduleA/PublicSupportTotal170Amt019575
IRS990ScheduleA/SupportSumAmt00
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY170Ind0X
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt019575
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt019575
IRS990ScheduleA/TotalSupportAmt051473
IRS990/ScheduleBRequiredInd0false
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt02811
IRS990ScheduleD/OtherAssetsOrgGrp/Desc0computer equipment
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt073548
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc0Loan from Officer Greg Baker
IRS990ScheduleD/TotalBookValueOtherAssetsAmt02811
IRS990ScheduleD/TotalLiabilityAmt073548
IRS990/ScheduleJRequiredInd0false
IRS990/ScheduleORequiredInd0false
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0security education training
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0security education training
IRS990/SchoolOperatingInd0false
IRS990/SignificantChangeInd0false
IRS990/SignificantNewProgramSrvcInd0false
IRS990/SubjectToExcsTaxNetInvstIncInd0false
IRS990/SubjToTaxRmnrtnExPrchtPymtInd0false
IRS990/TaxableDistributionsInd0false
IRS990/TaxablePartyNotificationInd0false
IRS990/TaxExemptBondsInd0false
IRS990/TerminateOperationsInd0false
IRS990/TotalAssetsEOYAmt08217
IRS990/TotalAssetsGrp/BOYAmt00
IRS990/TotalAssetsGrp/EOYAmt08217
IRS990/TotalCompGreaterThan150KInd0false
IRS990/TotalEmployeeCnt00
IRS990/TotalFunctionalExpensesGrp/FundraisingAmt00
IRS990/TotalFunctionalExpensesGrp/ManagementAndGeneralAmt00
IRS990/TotalFunctionalExpensesGrp/ProgramServicesAmt0619754
IRS990/TotalFunctionalExpensesGrp/TotalAmt0619754
IRS990/TotalGrossUBIAmt00
IRS990/TotalLiabilitiesEOYAmt080208
IRS990/TotalLiabilitiesGrp/BOYAmt00
IRS990/TotalLiabilitiesGrp/EOYAmt080208
IRS990/TotalNetAssetsFundBalanceGrp/BOYAmt00
IRS990/TotalNetAssetsFundBalanceGrp/EOYAmt0-71991
IRS990/TotalProgramServiceExpensesAmt0137414
IRS990/TotalProgramServiceRevenueAmt0627445
IRS990/TotalReportableCompFromOrgAmt050000
IRS990/TotalRevenueGrp/RelatedOrExemptFuncIncomeAmt0627900
IRS990/TotalRevenueGrp/TotalRevenueColumnAmt0627900
IRS990/TotLiabNetAssetsFundBalanceGrp/BOYAmt00
IRS990/TotLiabNetAssetsFundBalanceGrp/EOYAmt08217
IRS990/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990/TypeOfOrganizationCorpInd0X
IRS990/UnrelatedBusIncmOverLimitInd0false
IRS990/USAddress/AddressLine1Txt01601 Hollindale Drive
IRS990/USAddress/CityNm0ALEXANDRIA
IRS990/USAddress/StateAbbreviationCd0VA
IRS990/USAddress/ZIPCd022306
IRS990/VotingMembersGoverningBodyCnt01
IRS990/VotingMembersIndependentCnt00
IRS990/WhistleblowerPolicyInd0true
ReturnHeader/BuildTS02023-04-26 12:10:37Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0Shawn Baker-Garcia
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0CEO and Founder
ReturnHeader/BusinessOfficerGrp/PhoneNum05712351547
ReturnHeader/BusinessOfficerGrp/SignatureDt02023-04-04
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0Coalescion
ReturnHeader/Filer/BusinessNameControlTxt0COAL
ReturnHeader/Filer/EIN0861436675
ReturnHeader/Filer/USAddress/AddressLine1Txt01601 Hollindale Drive
ReturnHeader/Filer/USAddress/CityNm0ALEXANDRIA
ReturnHeader/Filer/USAddress/StateAbbreviationCd0VA
ReturnHeader/Filer/USAddress/ZIPCd022306
ReturnHeader/IRSResponsiblePrtyInfoCurrInd0true
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0541950250
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Alexandria Tax and Bookkeepi
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt03682 King St 16934
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0ALEXANDRIA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0VA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd022302
ReturnHeader/PreparerPersonGrp/PhoneNum07034077545
ReturnHeader/PreparerPersonGrp/PreparationDt02023-04-04
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Christine Riccardi Cok
ReturnHeader/ReturnTs02023-04-21T15:00:02-04:00
ReturnHeader/ReturnTypeCd0990
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0Shawn
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0Baker-Garcia
ReturnHeader/TaxPeriodBeginDt02022-01-01
ReturnHeader/TaxPeriodEndDt02022-12-31
ReturnHeader/TaxYr02022

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2022 • Form 990Detailed filing. Detailed filing data is available for this year.

Open filing
Assets
$8,217
Liabilities
$80,208
Net assets
-$71,991
Revenue
$627,900
Expenses
$619,754
Net income
$8,146
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.16$0.56$0.41$1.85$1.81$0.04
2023Detailed filing. Detailed filing data is available for this year.$0.01$0.46$0.45$0.73$1.01$0.28
2022Detailed filing. Detailed filing data is available for this year.$0.02$0.19$0.17$0.62$0.72$0.11
2022Detailed filing. Detailed filing data is available for this year.$0.01$0.08$0.07$0.63$0.62$0.01
2021Detailed filing. Detailed filing data is available for this year.$0.02$0.10$0.08$0.05$0.14$0.08