Civic Intelligence

Bright Magpie Charitable Foundation

990EZ • Fiscal year 2017 • EIN 26-0640486

Jan 01, 2017 to Dec 31, 2017 • Filed on Oct 24, 2018

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

56th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

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

Liabilities / Revenue

56th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

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

Net Margin

12th percentile

-28%

Higher net margin than 12% of similar nonprofits.

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

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.

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

Asset Growth

41st percentile

-1.7%

Faster asset growth than 41% of similar nonprofits.

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

Revenue Growth

75th percentile

23%

Faster revenue growth than 75% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets56th percentile

Assets

Down

$417,806

Down $7,088 (-1.7%) from 2016

Net Assets

Down

$417,806

Down $7,088 (-1.7%) from 2016

Liabilities

Flat

$0

Flat from 2016

Revenue And Expenses
Liabilities / Revenue56th percentileNet Margin12th percentile

Revenue

Up

$37,851

Up $7,175 (+23%) from 2016

Expenses

Up

$48,414

Up $6,816 (+16%) from 2016

Net Income

Up

-$10,563

Up $359 (+3.3%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth41st 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

2017

Assets$417,806
Liabilities$0
Net Assets$417,806
Open 2017 Filing

Operations Trend

Revenue Growth75th 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

2017

Revenue$37,851
Expenses$48,414
Net Income-$10,563
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Oct 24, 2018
Return Version
2017v2.2
Gross Receipts
$37,851
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 J chuang
Title
President
Phone
9097062835
Signed
2018-10-24
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 5,041BANK SERVICE CHARGE 73OFFICE EXPENSES 628AUTO EXPENSES 409SUPPLIES 1,274LILIBITY INSURANCE 500CONFERENCE AND METTINGS 1,405TAXES AND LIC 25INTERNET EXPENSE 755TRAVEL EXPENSE 1,096REPAIRS AND MAINT 2,732PROPERTIES TAXES 3,674MANAGEMENT FEE 2,400”

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

“Description AmountUnrealized gain from NY Life 3,475”

Description of other assets Part II line 24

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

Raw XML Appendix150 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/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/BOYAmt0186932
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0186677
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt010720
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-10563
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt019900
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0424894
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0417806
IRS990EZ/GrossReceiptsAmt037851
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt027131
IRS990EZ/LandAndBuildingsGrp/BOYAmt0236734
IRS990EZ/LandAndBuildingsGrp/EOYAmt0229901
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0424894
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0417806
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0424894
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0417806
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt010.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/OtherChangesInNetAssetsAmt03475
IRS990EZ/OtherExpensesTotalAmt026845
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0charitable related activities
IRS990EZ/PrintingPublicationsPostageAmt01669
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0charitable related donation
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0CA
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt00
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt00
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt048414
IRS990EZ/TotalProgramServiceExpensesAmt00
IRS990EZ/TotalRevenueAmt037851
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt010720
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt06670
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt03275
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt02925
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt023590
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearAmt02501
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus1YearAmt08373
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus2YearsAmt076
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus3YearsAmt0184
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus4YearsAmt0166
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt011300
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearAmt02501
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus1YearAmt08373
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus2YearsAmt076
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus3YearsAmt0184
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus4YearsAmt0166
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt011300
IRS990ScheduleA/InvestmentIncomeCYPct00.09000
IRS990ScheduleA/InvestmentIncomePYPct00.18000
IRS990ScheduleA/OtherIncome509Grp/CurrentTaxYearAmt027105
IRS990ScheduleA/OtherIncome509Grp/CurrentTaxYearMinus1YearAmt025800
IRS990ScheduleA/OtherIncome509Grp/CurrentTaxYearMinus2YearsAmt020355
IRS990ScheduleA/OtherIncome509Grp/CurrentTaxYearMinus3YearsAmt013424
IRS990ScheduleA/OtherIncome509Grp/CurrentTaxYearMinus4YearsAmt010522
IRS990ScheduleA/OtherIncome509Grp/TotalAmt097206
IRS990ScheduleA/PrivateFoundation509Ind0X
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct00.17860
IRS990ScheduleA/PublicSupportPY509Pct00.12700
IRS990ScheduleA/PublicSupportTotal509Amt023590
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt010720
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt06670
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt03275
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt02925
IRS990ScheduleA/Total509Grp/TotalAmt023590
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt040326
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt040843
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt023706
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt016533
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt010688
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0132096
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Description AmountDepreciation from 4562 6,833CONTRIBUTIONS TO OTHER FACILITIES 5,041BANK SERVICE CHARGE 73OFFICE EXPENSES 628AUTO EXPENSES 409SUPPLIES 1,274LILIBITY INSURANCE 500CONFERENCE AND METTINGS 1,405TAXES AND LIC 25INTERNET EXPENSE 755TRAVEL EXPENSE 1,096REPAIRS AND MAINT 2,732PROPERTIES TAXES 3,674MANAGEMENT FEE 2,400
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Description AmountUnrealized gain from NY Life 3,475
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2Category Beginning of Year End of YearAccount Receivable from FTB 1,228 1,228
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
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0tsong J chuang
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum09097062835
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-10-24
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/FederalOriginalSubmissionId09547942018297rixaxpg
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02018-10-24
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0172.12.89.7
ReturnHeader/FilingSecurityInformation/IPDt02018-10-24
ReturnHeader/FilingSecurityInformation/IPTm017:18:26
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/PreparationDt02018-10-24
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Peggy Sou EA
ReturnHeader/ReturnTs02018-10-24T17:17:48-04:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$417,806
Liabilities
$0
Net assets
$417,806
Revenue
$37,851
Expenses
$48,414
Net income
-$10,563
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