Civic Intelligence

Bright Magpie Charitable Foundation

990EZ • Fiscal year 2018 • EIN 26-0640486

Jan 01, 2018 to Dec 31, 2018 • Filed on Nov 06, 2019

Organization Profile
5542 N Pinnacle LaneSan Bernardino, CA 92407

(909) 706-2835

Siviq Scores

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

Liabilities / Assets

62nd percentile

0.01x

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

2018 filings • 501(c)3 • <$500k nonprofits • Source year 2018

Liabilities / Revenue

84th percentile

0.13x

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

2018 filings • 501(c)3 • <$500k nonprofits • Source year 2018

Net Margin

6th percentile

-82%

Higher net margin than 6% of similar nonprofits.

2018 filings • 501(c)3 • <$500k nonprofits • Source year 2018

Top Officer Pay

76th percentile

$0

Higher top officer pay than 76% of similar nonprofits.

Top officer pay equals 0.0% of source-year revenue.

2018 filings • 501(c)3 • <$500k nonprofits • Source year 2018

Asset Growth

36th percentile

-4.9%

Faster asset growth than 36% of similar nonprofits.

2018 filings • 501(c)3 • <$500k nonprofits • Annualized from 2017 to 2018

Revenue Growth

13th percentile

-39%

Faster revenue growth than 13% of similar nonprofits.

2018 filings • 501(c)3 • <$500k nonprofits • Annualized from 2017 to 2018

Balance Sheet
Liabilities / Assets62nd percentile

Assets

Down

$397,246

Down $20,560 (-4.9%) from 2017

Net Assets

Down

$394,318

Down $23,488 (-5.6%) from 2017

Liabilities

Up

$2,928

Up $2,928 from 2017

Revenue And Expenses
Liabilities / Revenue84th percentileNet Margin6th percentile

Revenue

Down

$23,053

Down $14,798 (-39%) from 2017

Expenses

Down

$41,913

Down $6,501 (-13%) from 2017

Net Income

Down

-$18,860

Down $8,297 (-79%) from 2017

Historical Trend

Balance Sheet Trend

Asset Growth36th percentile

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

$600K$400K$200K$0Assets 2012: $466,982Liabilities 2012: $0Net Assets 2012: $466,9822012Assets 2013: $463,124Liabilities 2013: $1,823Net Assets 2013: $461,3012013Assets 2014: $450,000Liabilities 2014: $1,373Net Assets 2014: $448,6272014Assets 2015: $427,474Liabilities 2015: $0Net Assets 2015: $427,4742015Assets 2016: $424,894Liabilities 2016: $0Net Assets 2016: $424,8942016Assets 2017: $417,806Liabilities 2017: $0Net Assets 2017: $417,8062017Assets 2018: $397,246Liabilities 2018: $2,928Net Assets 2018: $394,3182018Assets 2019: $397,569Liabilities 2019: $2,395Net Assets 2019: $395,1742019Assets 2020: $390,464Liabilities 2020: $1,770Net Assets 2020: $388,6942020Assets 2021: $362,004Liabilities 2021: $1,356Net Assets 2021: $360,6482021Assets 2022: $354,100Liabilities 2022: $1,507Net Assets 2022: $352,5932022Assets 2023: $361,013Liabilities 2023: $6,037Net Assets 2023: $354,9762023Assets 2024: $363,185Liabilities 2024: $0Net Assets 2024: $363,1852024

Highlighted filing

2018

Assets$397,246
Liabilities$2,928
Net Assets$394,318
Open 2018 Filing

Operations Trend

Revenue Growth13th percentile

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

$150K$100K$50K$0-$50KRevenue 2012: $2,608Expenses 2012: $21,979Net Income 2012: -$19,3712012Revenue 2013: $10,609Expenses 2013: $16,369Net Income 2013: -$5,7602013Revenue 2014: $16,350Expenses 2014: $29,208Net Income 2014: -$12,8582014Revenue 2015: $23,706Expenses 2015: $40,646Net Income 2015: -$16,9402015Revenue 2016: $30,676Expenses 2016: $41,598Net Income 2016: -$10,9222016Revenue 2017: $37,851Expenses 2017: $48,414Net Income 2017: -$10,5632017Revenue 2018: $23,053Expenses 2018: $41,913Net Income 2018: -$18,8602018Revenue 2019: $93,572Expenses 2019: $101,844Net Income 2019: -$8,2722019Revenue 2020: $47,702Expenses 2020: $59,003Net Income 2020: -$11,3012020Revenue 2021: $57,728Expenses 2021: $88,226Net Income 2021: -$30,4982021Revenue 2022: $39,524Expenses 2022: $33,559Net Income 2022: $5,9652022Revenue 2023: $47,474Expenses 2023: $53,206Net Income 2023: -$5,7322023Revenue 2024: $94,032Expenses 2024: $85,823Net Income 2024: $8,2092024

Highlighted filing

2018

Revenue$23,053
Expenses$41,913
Net Income-$18,860
Open 2018 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2018 to Dec 31, 2018
Signed
Nov 6, 2019
Return Version
2018v3.1
Gross Receipts
$23,053
Mission and Program Overview

Mission

charitable related activities

Program Services

DescriptionGrantsExpenses
charitable related donation--
Compensation and Service Providers
Top Officer Pay76th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
TSONG JUN CHUANGCEOPT$0--
Filing and Contact Details

Filer

Filer Name
Bright Magpie Charitable Foundation
EIN
26-0640486
Address
5542 N Pinnacle Lane, San Bernardino, CA 92407

Signing Officer

Name
Tsong Jun Chuang
Title
President
Phone
9097062835
Signed
2019-11-06
Discuss with paid preparer
Yes

Preparer

Firm
Accountax & Financial Assoc Inc
Address
19 E Live Oak Ave Suite J, Arcadia, CA 91006
Preparer
Peggy Sou EA
Phone
6262541223
Supplemental Narrative

Additional Explanations

Description of other expenses Part I line 16

“Description AmountDepreciation from 4562 6,833CONTRIBUTIONS TO OTHER FACILITIES 6,918BANK SERVICE CHARGE 67OFFICE EXPENSES 331AUTO EXPENSES 360SUPPLIES 2,043LILIBITY INSURANCE 1,000CONFERENCE AND METTINGS 1,112TAXES AND LIC 50INTERNET EXPENSE 239TRAVEL EXPENSE 528”

Other changes in net assets or fund balances Part I line 20

“Description AmountUnrealized gain from NY Life (4,628)”

Description of other assets Part II line 24

“Category Beginning of Year End of YearAccount Receivable from FTB 1,228 1,228”

Description of total liabilities Part II line 26

“Category Beginning of Year End of YearAccounts Payable 0 2,928”

Raw XML Appendix154 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
IRS990EZ/ActivitiesNotPreviouslyRptInd0false
IRS990EZ/BenefitsPaidToOrForMembersAmt01000
IRS990EZ/BooksInCareOfDetail/PersonNm0TSONG JUN CHUANG
IRS990EZ/BooksInCareOfDetail/PhoneNum09097062835
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt05542 N Pinnacle Lane
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0San Bernardino
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0CA
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd092407
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0186677
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0172950
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt03810
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-18860
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt020775
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0417806
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0397246
IRS990EZ/GrossReceiptsAmt023053
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt019243
IRS990EZ/LandAndBuildingsGrp/BOYAmt0229901
IRS990EZ/LandAndBuildingsGrp/EOYAmt0223068
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0417806
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0394318
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0417806
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0394318
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt012.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0TSONG JUN CHUANG
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0CEO
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt01228
IRS990EZ/OtherAssetsTotalDetail/EOYAmt01228
IRS990EZ/OtherChangesInNetAssetsAmt0-4628
IRS990EZ/OtherExpensesTotalAmt019481
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0charitable related activities
IRS990EZ/PrintingPublicationsPostageAmt0657
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0charitable related donation
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0CA
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt00
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt02928
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt041913
IRS990EZ/TotalProgramServiceExpensesAmt00
IRS990EZ/TotalRevenueAmt023053
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt03810
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt010720
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt06670
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt03275
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt02925
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt027400
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearAmt026
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus1YearAmt02501
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus2YearsAmt08373
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus3YearsAmt076
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus4YearsAmt0184
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt011160
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearAmt026
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus1YearAmt02501
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus2YearsAmt08373
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus3YearsAmt076
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus4YearsAmt0184
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt011160
IRS990ScheduleA/InvestmentIncomeCYPct00.08000
IRS990ScheduleA/InvestmentIncomePYPct00.09000
IRS990ScheduleA/OtherIncome509Grp/CurrentTaxYearAmt012409
IRS990ScheduleA/OtherIncome509Grp/CurrentTaxYearMinus1YearAmt027105
IRS990ScheduleA/OtherIncome509Grp/CurrentTaxYearMinus2YearsAmt025800
IRS990ScheduleA/OtherIncome509Grp/CurrentTaxYearMinus3YearsAmt020355
IRS990ScheduleA/OtherIncome509Grp/CurrentTaxYearMinus4YearsAmt013424
IRS990ScheduleA/OtherIncome509Grp/TotalAmt099093
IRS990ScheduleA/PrivateFoundation509Ind0X
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct00.19910
IRS990ScheduleA/PublicSupportPY509Pct00.17860
IRS990ScheduleA/PublicSupportTotal509Amt027400
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt03810
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt010720
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt06670
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt03275
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt02925
IRS990ScheduleA/Total509Grp/TotalAmt027400
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt016245
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt040326
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt040843
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt023706
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt016533
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0137653
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Description AmountDepreciation from 4562 6,833CONTRIBUTIONS TO OTHER FACILITIES 6,918BANK SERVICE CHARGE 67OFFICE EXPENSES 331AUTO EXPENSES 360SUPPLIES 2,043LILIBITY INSURANCE 1,000CONFERENCE AND METTINGS 1,112TAXES AND LIC 50INTERNET EXPENSE 239TRAVEL EXPENSE 528
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Description AmountUnrealized gain from NY Life (4,628)
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2Category Beginning of Year End of YearAccount Receivable from FTB 1,228 1,228
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3Category Beginning of Year End of YearAccounts Payable 0 2,928
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Description of other expenses Part I line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Other changes in net assets or fund balances Part I line 20
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Description of other assets Part II line 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Description of total liabilities Part II line 26
ReturnHeader/BuildTS02020-03-31 21:24:44Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0TSONG JUN CHUANG
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum09097062835
ReturnHeader/BusinessOfficerGrp/SignatureDt02019-11-06
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0BRIGHT MAGPIE CHARITABLE FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0BRIG
ReturnHeader/Filer/EIN0260640486
ReturnHeader/Filer/USAddress/AddressLine1Txt05542 N Pinnacle Lane
ReturnHeader/Filer/USAddress/CityNm0San Bernardino
ReturnHeader/Filer/USAddress/StateAbbreviationCd0CA
ReturnHeader/Filer/USAddress/ZIPCd092407
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0A6803E152544DF13CF6B6AC29003703FBD4AA610
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0A6803E152544DF13CF6B6AC29003703FBD4AA610
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionId09547942019310my0ch0v
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02019-11-06
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0172.12.89.7
ReturnHeader/FilingSecurityInformation/IPDt02019-11-06
ReturnHeader/FilingSecurityInformation/IPTm020:18:31
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0954843410
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Accountax & Financial Assoc Inc
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt019 E Live Oak Ave Suite J
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Arcadia
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0CA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd091006
ReturnHeader/PreparerPersonGrp/PhoneNum06262541223
ReturnHeader/PreparerPersonGrp/PreparationDt02019-11-05
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Peggy Sou EA
ReturnHeader/ReturnTs02019-11-06T19:36:25-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02018-01-01
ReturnHeader/TaxPeriodEndDt02018-12-31
ReturnHeader/TaxYr02018

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$397,246
Liabilities
$2,928
Net assets
$394,318
Revenue
$23,053
Expenses
$41,913
Net income
-$18,860
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$3.63$0.00$3.63$0.94$0.86$0.08
2023Detailed filing. Detailed filing data is available for this year.$3.61$0.06$3.55$0.47$0.53$0.06
2022Detailed filing. Detailed filing data is available for this year.$3.54$0.02$3.53$0.40$0.34$0.06
2021Detailed filing. Detailed filing data is available for this year.$3.62$0.01$3.61$0.58$0.88$0.30
2020Detailed filing. Detailed filing data is available for this year.$3.90$0.02$3.89$0.48$0.59$0.11
2019Detailed filing. Detailed filing data is available for this year.$3.98$0.02$3.95$0.94$1.02$0.08
2018Detailed filing. Detailed filing data is available for this year.$3.97$0.03$3.94$0.23$0.42$0.19
2017Detailed filing. Detailed filing data is available for this year.$4.18$0.00$4.18$0.38$0.48$0.11
2016Detailed filing. Detailed filing data is available for this year.$4.25$0.00$4.25$0.31$0.42$0.11
2015Detailed filing. Detailed filing data is available for this year.$4.27$0.00$4.27$0.24$0.41$0.17
2014Detailed filing. Detailed filing data is available for this year.$4.50$0.01$4.49$0.16$0.29$0.13
2013Detailed filing. Detailed filing data is available for this year.$4.63$0.02$4.61$0.11$0.16$0.06
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$4.67$0.00$4.67$0.03$0.22$0.19