Civic Intelligence

Merlins Magic Wand Foundation

990EZ • Fiscal year 2014 • EIN 46-0809190

Jan 01, 2014 to Dec 31, 2014 • Filed on Nov 15, 2015

One Legoland DriveCarlsbad, CA 92008

(760) 687-8698

Siviq Scores

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

Liabilities / Assets

90th percentile

0.59x

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

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

Liabilities / Revenue

94th percentile

0.81x

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

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

Net Margin

93rd percentile

57%

Higher net margin than 93% of similar nonprofits.

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

Top Officer Pay

74th percentile

$0

Higher top officer pay than 74% of similar nonprofits.

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

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

Asset Growth

Score unavailable

No value available

No earlier valid filing was available within the previous three public years.

Source year 2014

Revenue Growth

Score unavailable

No value available

No earlier valid filing was available within the previous three public years.

Source year 2014

Assets

$265,618

No earlier filing loaded for comparison.

Net Assets

$109,548

No earlier filing loaded for comparison.

Liabilities

$156,070

No earlier filing loaded for comparison.

Revenue

$192,565

No earlier filing loaded for comparison.

Expenses

$83,017

No earlier filing loaded for comparison.

Net Income

$109,548

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

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

$1.5M$1.0M$500K$0Assets 2014: $265,618Liabilities 2014: $156,070Net Assets 2014: $109,5482014Assets 2015: $430,251Liabilities 2015: $139,758Net Assets 2015: $290,4932015Assets 2016: $362,121Liabilities 2016: $85,779Net Assets 2016: $276,3422016Assets 2017: $379,803Liabilities 2017: $121,210Net Assets 2017: $258,5932017Assets 2018: $475,196Liabilities 2018: $165,715Net Assets 2018: $309,4812018Assets 2019: $458,975Liabilities 2019: $231,316Net Assets 2019: $227,6592019Assets 2020: $371,124Liabilities 2020: $206,551Net Assets 2020: $164,5732020Assets 2021: $573,498Liabilities 2021: $116,978Net Assets 2021: $456,5202021Assets 2022: $902,871Liabilities 2022: $224,426Net Assets 2022: $678,4452022Assets 2023: $1,025,644Liabilities 2023: $415,673Net Assets 2023: $609,9712023Assets 2024: $1,032,812Liabilities 2024: $381,410Net Assets 2024: $651,4022024

Highlighted filing

2014

Assets$265,618
Liabilities$156,070
Net Assets$109,548

Operations Trend

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

$1.5M$1.0M$500K$0-$500KRevenue 2014: $192,565Expenses 2014: $83,017Net Income 2014: $109,5482014Revenue 2015: $1,023,308Expenses 2015: $842,363Net Income 2015: $180,9452015Revenue 2016: $1,170,674Expenses 2016: $1,201,325Net Income 2016: -$30,6512016Revenue 2017: $267,186Expenses 2017: $284,935Net Income 2017: -$17,7492017Revenue 2018: $343,945Expenses 2018: $293,057Net Income 2018: $50,8882018Revenue 2019: $269,342Expenses 2019: $351,164Net Income 2019: -$81,8222019Revenue 2020: $169,637Expenses 2020: $232,723Net Income 2020: -$63,0862020Revenue 2021: $484,598Expenses 2021: $192,651Net Income 2021: $291,9472021Revenue 2022: $454,244Expenses 2022: $232,319Net Income 2022: $221,9252022Revenue 2023: $444,887Expenses 2023: $513,361Net Income 2023: -$68,4742023Revenue 2024: $398,879Expenses 2024: $357,448Net Income 2024: $41,4312024

Highlighted filing

2014

Revenue$192,565
Expenses$83,017
Net Income$109,548
Jump To
Filing Snapshot
Filing Period
Jan 1, 2014 to Dec 31, 2014
Signed
Nov 15, 2015
Return Version
2014v5.0
Gross Receipts
$192,565
Mission and Program Overview

Mission

Merlin's magic wand foundation's purpose is to support children facing challenges of serious illness, disability or adversity. The foundation believes that every child deserves to laugh, enjoy and cherish memorable experiences and its mission is to enable them to access the magic of merlin entertainments.

Merlin's magic wand foundation believes in putting the magic back into the lives of seriously ill, disabled and disadvantaged children around the usa. We make this happen by arranging great days out at merlin entertainments group attractions and provide travel grants.

Program Services

DescriptionGrantsExpenses
MAGICAL DAYS OUT: 10,884 TICKETS PROVIDED TO SERIOUSLY ILL, DISABLED AND DISADVANTAGED CHILDREN, THEIR FAMILIES AND CARE TAKERS TO HAVE DAYS OUT AT MERLIN ENTERTAINMENTS GROUP ATTRACTIONS IN THE USA.-$50,075
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
PETER RONCHETTIPresident-$0--
BRIAN SHAWCFO/Treasurer-$0--
KIMBERLY CLARKSecretary-$0--
Filing and Contact Details

Filer

Filer Name
MERLIN'S MAGIC WAND FOUNDATION
EIN
46-0809190
In Care Of
% TRACIE HOGENCAMP
Phone
7606878698
Address
ONE LEGOLAND DRIVE, CARLSBAD, CA 92008

Signing Officer

Name
Brian Shaw
Title
CFO/treasurer
Phone
3107814303
Signed
2015-11-15
Discuss with paid preparer
Yes

Preparer

Firm
Kpmg Llp
Address
550 S Hope St Suite 1500, Los Angeles, CA 90071
Preparer
Carey Mckee
Phone
2139724000
Supplemental Narrative

Additional Explanations

Form 990-ez, Part III, Line 28

Value of in-kind use of facilities for program services not reported on form 990-ez $305,607

Form 990EZ Part I Line 16

Description:ADVERTISING AND PROMOTION Amount:1315

Form 990EZ Part I Line 16

Description:OFFICE EXPENSES Amount:138

Form 990EZ Part I Line 16

Description:TRAVEL Amount:9772

Form 990EZ Part I Line 16

Description:DEPRECIATION Amount:376

Form 990EZ Part I Line 16

Description:OTHER EXPENSES Amount:12428

Form 990EZ Part II Line 24

Description:PLEDGES RECEIVABLE BOY Amount:EOY Amount:45806

Form 990EZ Part II Line 24

Description:IT EQUIPMENT, NET BOY Amount:EOY Amount:1881

Raw XML Appendix179 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/PersonNm0TRACIE HOGENCAMP
IRS990EZ/BooksInCareOfDetail/PhoneNum07606878698
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0ONE LEGOLAND DRIVE
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0CARLSBAD
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0CA
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd092008
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt00
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0217931
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/CntrctRcvdGreaterThan100KCnt00
IRS990EZ/ContributionsGiftsGrantsEtcAmt0192565
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DirectIndirectPltclExpendAmt00
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0109548
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt020000
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt00
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0265618
IRS990EZ/GainOrLossFromSaleOfAssetsAmt00
IRS990EZ/GrossProfitLossSlsOfInvntryAmt00
IRS990EZ/GrossReceiptsAmt0192565
IRS990EZ/GrossReceiptsForPublicUseAmt00
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InitialReturnInd0X
IRS990EZ/InitiationFeesAndCapContriAmt00
IRS990EZ/LandAndBuildingsGrp/BOYAmt00
IRS990EZ/LandAndBuildingsGrp/EOYAmt00
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt00
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0109548
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt00
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0109548
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt00.5
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt10.5
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt20.5
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0PETER RONCHETTI
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1BRIAN SHAW
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2KIMBERLY CLARK
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1CFO/TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2SECRETARY
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt00
IRS990EZ/OtherAssetsTotalDetail/EOYAmt047687
IRS990EZ/OtherEmployeePaidOver100kCnt00
IRS990EZ/OtherExpensesTotalAmt024029
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0MERLIN'S MAGIC WAND FOUNDATION BELIEVES IN PUTTING THE MAGIC BACK INTO THE LIVES OF SERIOUSLY ILL, DISABLED AND DISADVANTAGED CHILDREN AROUND THE USA. WE MAKE THIS HAPPEN BY ARRANGING GREAT DAYS OUT AT MERLIN ENTERTAINMENTS GROUP ATTRACTIONS AND PROVIDE TRAVEL GRANTS.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0MAGICAL DAYS OUT: 10,884 TICKETS PROVIDED TO SERIOUSLY ILL, DISABLED AND DISADVANTAGED CHILDREN, THEIR FAMILIES AND CARE TAKERS TO HAVE DAYS OUT AT MERLIN ENTERTAINMENTS GROUP ATTRACTIONS IN THE USA.
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt050075
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SalariesOtherCompEmplBnftAmt038988
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt00
IRS990EZ/SpecialEventsNetIncomeLossAmt00
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0CA
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt00
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt0156070
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TaxImposedUnderIRC4911Amt00
IRS990EZ/TaxImposedUnderIRC4912Amt00
IRS990EZ/TaxImposedUnderIRC4955Amt00
IRS990EZ/TotalExpensesAmt083017
IRS990EZ/TotalProgramServiceExpensesAmt050075
IRS990EZ/TotalRevenueAmt0192565
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0WWW.MERLINSMAGICWAND.ORG/USA
IRS990ScheduleA/AmountsRcvdDsqlfyPersonGrp/TotalAmt00
IRS990ScheduleA/First5Years509Ind0X
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt0192565
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt00
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt00
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt00
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt00
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt0192565
IRS990ScheduleA/GovtFurnSrvcFcltsVl509Grp/TotalAmt00
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt00
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt00
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/TotalAmt00
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt00
IRS990ScheduleA/NetIncomeFromOtherUBIGrp/TotalAmt00
IRS990ScheduleA/OtherIncome509Grp/TotalAmt00
IRS990ScheduleA/Post1975UBTIGrp/TotalAmt00
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct00.00000
IRS990ScheduleA/PublicSupportTotal509Amt0192565
IRS990ScheduleA/SubstAndDsqlfyPrsnsTotGrp/TotalAmt00
IRS990ScheduleA/SubstantialContributorsAmtGrp/TotalAmt00
IRS990ScheduleA/TaxRevLeviedOrgnztnlBnft509Grp/TotalAmt00
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt0192565
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt00
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt00
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt00
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt00
IRS990ScheduleA/Total509Grp/TotalAmt0192565
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt0192565
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt00
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt00
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt00
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt00
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0192565
IRS990ScheduleB/ContributorInformationGrp/ContributorBusinessName/BusinessNameLine10RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorNum0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine10RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine20RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/City0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/State0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/ZIPCode0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/TotalContributionsAmt0RESTRICTED
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0VALUE OF IN-KIND USE OF FACILITIES FOR PROGRAM SERVICES NOT REPORTED ON FORM 990-EZ $305,607
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Description:ADVERTISING AND PROMOTION Amount:1315
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2Description:OFFICE EXPENSES Amount:138
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3Description:TRAVEL Amount:9772
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4Description:DEPRECIATION Amount:376
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5Description:OTHER EXPENSES Amount:12428
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt6Description:PLEDGES RECEIVABLE BOY Amount:EOY Amount:45806
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt7Description:IT EQUIPMENT, NET BOY Amount:EOY Amount:1881
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART III, LINE 28
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990EZ PART I LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990EZ PART I LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990EZ PART I LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4FORM 990EZ PART I LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5FORM 990EZ PART I LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc6FORM 990EZ PART II LINE 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc7FORM 990EZ PART II LINE 24
ReturnHeader/BuildTS02016-04-25 22:37:26Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0BRIAN SHAW
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0CFO/TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum03107814303
ReturnHeader/BusinessOfficerGrp/SignatureDt02015-11-15
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0MERLIN'S MAGIC WAND FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0MERL
ReturnHeader/Filer/EIN0460809190
ReturnHeader/Filer/InCareOfNm0% TRACIE HOGENCAMP
ReturnHeader/Filer/PhoneNum07606878698
ReturnHeader/Filer/USAddress/AddressLine1Txt0ONE LEGOLAND DRIVE
ReturnHeader/Filer/USAddress/CityNm0CARLSBAD
ReturnHeader/Filer/USAddress/StateAbbreviationCd0CA
ReturnHeader/Filer/USAddress/ZIPCd092008
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0KPMG LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0550 S Hope St Suite 1500
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Los Angeles
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0CA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd090071
ReturnHeader/PreparerPersonGrp/PhoneNum02139724000
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0CAREY MCKEE
ReturnHeader/ReturnTs02015-11-16T12:59:32-06:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02014-01-01
ReturnHeader/TaxPeriodEndDt02014-12-31
ReturnHeader/TaxYr02014

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings