Civic Intelligence

Merlins Magic Wand Foundation

990 • Fiscal year 2016 • EIN 46-0809190

Jan 01, 2016 to Dec 31, 2016 • Filed on Nov 15, 2017

Organization ProfileWWW.MERLINSMAGICWAND.ORG/USA
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

65th percentile

0.24x

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

2016 filings • 501(c)3 • $1M-$5M nonprofits • Source year 2016

Liabilities / Revenue

43rd percentile

0.07x

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

2016 filings • 501(c)3 • $1M-$5M nonprofits • Source year 2016

Net Margin

34th percentile

-2.6%

Higher net margin than 34% of similar nonprofits.

2016 filings • 501(c)3 • $1M-$5M nonprofits • Source year 2016

Top Officer Pay

90th percentile

$210,000

Higher top officer pay than 90% of similar nonprofits.

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

2016 filings • 501(c)3 • $1M-$5M nonprofits • Source year 2016

Asset Growth

8th percentile

-16%

Faster asset growth than 8% of similar nonprofits.

2016 filings • 501(c)3 • $1M-$5M nonprofits • Annualized from 2015 to 2016

Revenue Growth

71st percentile

14%

Faster revenue growth than 71% of similar nonprofits.

2016 filings • 501(c)3 • $1M-$5M nonprofits • Annualized from 2015 to 2016

Balance Sheet
Liabilities / Assets65th percentile

Assets

Down

$362,121

Down $68,130 (-16%) from 2015

Net Assets

Down

$276,342

Down $14,151 (-4.9%) from 2015

Liabilities

Down

$85,779

Down $53,979 (-39%) from 2015

Revenue And Expenses
Liabilities / Revenue43rd percentileNet Margin34th percentile

Revenue

Up

$1,170,674

Up $147,366 (+14%) from 2015

Expenses

Up

$1,201,325

Up $358,962 (+43%) from 2015

Net Income

Down

-$30,651

Down $211,596 (-117%) from 2015

Historical Trend

Balance Sheet Trend

Asset Growth8th percentile

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

2016

Assets$362,121
Liabilities$85,779
Net Assets$276,342
Open 2016 Filing

Operations Trend

Revenue Growth71st percentile

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

2016

Revenue$1,170,674
Expenses$1,201,325
Net Income-$30,651
Open 2016 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2016 to Dec 31, 2016
Signed
Nov 15, 2017
Return Version
2016v3.0
Gross Receipts
$1,225,142
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 backinto the lives of seriously ill, disabled and disadvantaged childrenaround the usa.

Balance Sheet Detail
LineBeginningEndChange
Assets
Cash and Non-Interest-Bearing Accounts$391,949$349,117▼ $42,832
Pledges and Grants Receivable$35,187$10,240▼ $24,947
Prepaid Expenses and Deferred Charges$1,990$2,395▲ $405
Land, Buildings, and Equipment, Net$1,125$369▼ $756
Total Assets$430,251$362,121▼ $68,130
Liabilities
Accounts Payable and Accrued Expenses$139,758$85,779▼ $53,979
Total Liabilities$139,758$85,779▼ $53,979
Net Assets / Fund Balance
Unrestricted Net Assets$290,493$276,342▼ $14,151
Total Net Assets Fund Balance$290,493$276,342▼ $14,151
Total Liabilities and Net Assets / Fund Balance$430,251$362,121▼ $68,130

Asset Categories

AssetBook ValueDepreciationBasis
Equipment$369$1,888$2,257
Compensation and Service Providers
Top Officer Pay90th percentile

Employees

NameTitleFull / Part TimeOtherTotal
Robert LorenziniBoard Advisor-$133,737$133,737
Tracie HogencampCharity ManagerFT$73,320$73,320

Board Members and Trustees

NameTitle
Peter RonchettiCharity President
Janine DigioacchinoBoard Member
Kim ClarkBoard Member
Brian ShawCharity CFO/secretary
Revenue and Support

Revenue Composition

Contributions and Grants
$1,202,733
Program Service Revenue
$0
Investment Income
$0
Other Revenue
$-32,059
All Other Contributions
$813,390
Change in Net Assets
$-30,651

Noncash Contribution Practices

Property subject to holding requirements
No
Reviewed unusual noncash gifts
No
Third parties used for noncash contributions
No

Noncash Contributions

Contribution TypeContribution CountReported AmountValuation Method
Other Non Cash Contri Table27,471$878,199Fair Market Value (FMV)
Other Non Cash Contri Table3$80,194Fair Market Value (FMV)
Other Non Cash Contri Table2$22,087Fair Market Value (FMV)
Total Noncash Contributions27,476$980,480-

Audited Revenue Reconciliation

Revenue per Audited Statements
$1,170,674
Revenue Not Reported on Financial Statements
$0
Revenue Not Reported on Form 990
$102,009
Total Revenue per Audited Statements
$1,272,683
Total Revenue per Form 990
$1,170,674
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Grants and Similar Amounts Paid$1,027,800
Salaries, Compensation, and Employee Benefits$102,067
Other Expenses$71,458
Total Fundraising Expense$49,712
Professional Fundraising Fees$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Grants to Domestic Individuals$887,212--$887,212
Grants to Domestic Orgs$140,588--$140,588
Current Officers, Directors, Trustees, and Key Employees$46,487$15,496$15,496$77,479
Office Expenses$1,412$28,158$470$30,040
Advertising$571-$28,611$29,182
Other Salaries and Wages$14,797$7,103$2,688$24,588
Travel$6,889$2,295$2,296$11,480
Depreciation Depletion$454$151$151$756
Total Functional Expenses$1,098,410$53,203$49,712$1,201,325

Audited Expense Reconciliation

Line ItemAmount
Total Expenses per Audited Statements$1,303,334
Expenses per Audited Statements$1,201,325
Total Expenses per Form 990$1,201,325
Expenses Not Reported on Form 990$102,009
Expenses Not Reported on Financial Statements$0
International Activity

Grant and Assistance Recipients

RecipientLocationCategoryPurposeAmount
Howard Phillips Centre OrlandoOrlando, FL501(c)3For Design and Refurbishment of 3 Therapy Rooms for Children Attending the Center.$32,650
MERCY CHILDREN'S HOSPITAL KANSASKansas City, MO501(c)3FOR THE DESIGN AND REFURBISHMENT OF THE CHILDREN'S PLAY AREA AND WAITING ROOM.$18,987
RADY'S CHILDREN CENTRE SAN DIEGOSan Diego, CA501(c)3FOR THE DESIGN AND REFURBISHMENT OF THE CHILDREN'S WAITING AREA.$8,757
Fundraising, Events, and Gaming
Fundraising activities
Yes
Gaming activities
No
Professional fundraiser used
No

Fundraising and Gaming Totals

Line ItemAmount
Fundraising Direct Expenses$54,468
Fundraising Gross Income$22,409
Professional Fundraising Fees$0

Fundraising Events

EventGross ReceiptsGross RevenueDirect ExpensesNet Income
Golf Tournament$43,389$13,981$15,109$-1,128
Golf Tournament$46,855$6,478$15,421$-8,943
Total Events$94,549$22,409$54,468$-32,059
Political and Lobbying Activity
Political campaign activity
No
Lobbying activity
No
Subject to proxy tax
No
Governance and Compliance

Governance Checklist

Compiled or reviewed by an accountant
No
Annual disclosure for covered persons
Yes
Audit committee
Yes
Backup withholding compliance
Yes
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
No
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

Governance Explanations

Form 990, Part VI, Section A, Line 2

“Board members are employees of the related party legoland california.”

Form 990, Part VI, Section B, Line 11B

“Mmw's 990 is made available to the board of directors and for their review prior to filing.”

Form 990, Part VI, Section B, Line 12C

“Mmw maintains a written conflict of interest policy. The audit committee provides, at least annually, and whenever appropriate, a conflict of interest statement that is reviewed and signed by each interested person (board member, director, trustee or key employee, etc). The policy dictates that the audit committee conduct periodic reviews to ensure there are no conflicts of interest with any interested person. Such reviews are performed at least annually and whenever appropriate.”

Form 990, Part VI, Section C, Line 19

“Mmw makes its governing documents, conflict of interest policy, and financial statements available to the public in the same fashion as it makes its form 990 available to the public, upon request.”

Filing and Contact Details

Filer

Filer Name
MERLIN'S MAGIC WAND FOUNDATION
EIN
46-0809190
Phone
7606878698
Address
ONE LEGOLAND DRIVE, CARLSBAD, CA 92008

Signing Officer

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

Organization Details

Principal Officer
Brian Shaw
Formed
2012
Legal Domicile
CA
Voting Board Members
4
Independent Board Members
4
Employees
0
Volunteers
120

Preparer

Firm
MACIAS GINI & O'CONNELL LLP
Address
12264 EL CAMINO REAL SUITE 402, SAN DIEGO, CA 92130
Preparer
Cory Kalmin
Phone
8587922210
Supplemental Narrative

Additional Explanations

Form 990, Part III, Line 2

“Community outreach facilitates employees from merlin attractions to visit a local children's hospital or schools for children with special educational needs and engage the children in a fun merlin related activity. This gives them a unique opportunity to have a new, stimulating experience.”

Section A Line 1A

“Amount provided is an estimate of peter ronchetti's 2016 compensation.”

FORM 990, PART XII, LINE 2C:

“This process has not changed from prior year.”

Financial Statement Notes

PART X, LINE 2:

“Mmwf has evaluated the financial statement impact of tax positions taken or expected to be taken in its tax returns. Management has determined that no tax liabilities need to be recorded under applicable accounting guidance for the year ended december 31, 2016. Mmwf's federal and state information returns for tax years 2012 and later remain subject to examination by taxing authorities.”

PART XI, LINE 2D - OTHER ADJUSTMENTS:

“Special event expenses netted against revenue on form 990”

PART XII, LINE 2D - OTHER ADJUSTMENTS:

“Special event expenses netted against revenue on form 990”

Raw XML AppendixShowing 400 of 554 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/AccountantCompileOrReviewInd00
IRS990/AccountsPayableAccrExpnssGrp/BOYAmt0139758
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt085779
IRS990/ActivitiesConductedPrtshpInd00
IRS990/ActivityOrMissionDesc0MERLIN'S MAGIC WAND FOUNDATION BELIEVES IN PUTTING THE MAGIC BACKINTO THE LIVES OF SERIOUSLY ILL, DISABLED AND DISADVANTAGED CHILDRENAROUND THE USA.
IRS990/AdvertisingGrp/FundraisingAmt028611
IRS990/AdvertisingGrp/ProgramServicesAmt0571
IRS990/AdvertisingGrp/TotalAmt029182
IRS990/AllOtherContributionsAmt0813390
IRS990/AnnualDisclosureCoveredPrsnInd01
IRS990/AuditCommitteeInd01
IRS990/BackupWthldComplianceInd01
IRS990/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt0TRACIE HOGENCAMP
IRS990/BooksInCareOfDetail/PhoneNum07306878698
IRS990/BooksInCareOfDetail/USAddress/AddressLine1Txt0ONE LEGOLAND DRIVE
IRS990/BooksInCareOfDetail/USAddress/CityNm0CARLSBAD
IRS990/BooksInCareOfDetail/USAddress/StateAbbreviationCd0CA
IRS990/BooksInCareOfDetail/USAddress/ZIPCd092008
IRS990/BusinessRlnWithFamMemInd00
IRS990/BusinessRlnWithOfficerEntInd00
IRS990/BusinessRlnWithOrgMemInd00
IRS990/CashNonInterestBearingGrp/BOYAmt0391949
IRS990/CashNonInterestBearingGrp/EOYAmt0349117
IRS990/ChangeToOrgDocumentsInd00
IRS990/CntrctRcvdGreaterThan100KCnt00
IRS990/CollectionsOfArtInd00
IRS990/CompCurrentOfcrDirectorsGrp/FundraisingAmt015496
IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt015496
IRS990/CompCurrentOfcrDirectorsGrp/ProgramServicesAmt046487
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt077479
IRS990/CompensationFromOtherSrcsInd00
IRS990/CompensationProcessCEOInd00
IRS990/CompensationProcessOtherInd00
IRS990/ConflictOfInterestPolicyInd01
IRS990/ConservationEasementsInd00
IRS990/ConsolidatedAuditFinclStmtInd00
IRS990/ContriRptFundraisingEventAmt072140
IRS990/CreditCounselingInd00
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt01202733
IRS990/CYGrantsAndSimilarPaidAmt01027800
IRS990/CYInvestmentIncomeAmt00
IRS990/CYOtherExpensesAmt071458
IRS990/CYOtherRevenueAmt0-32059
IRS990/CYProgramServiceRevenueAmt00
IRS990/CYRevenuesLessExpensesAmt0-30651
IRS990/CYSalariesCompEmpBnftPaidAmt0102067
IRS990/CYTotalExpensesAmt01201325
IRS990/CYTotalFundraisingExpenseAmt049712
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt01170674
IRS990/DecisionsSubjectToApprovaInd00
IRS990/DeductibleArtContributionInd00
IRS990/DeductibleNonCashContriInd01
IRS990/DelegationOfMgmtDutiesInd00
IRS990/DepreciationDepletionGrp/FundraisingAmt0151
IRS990/DepreciationDepletionGrp/ManagementAndGeneralAmt0151
IRS990/DepreciationDepletionGrp/ProgramServicesAmt0454
IRS990/DepreciationDepletionGrp/TotalAmt0756
IRS990/Desc0MAGICAL DAYS OUT: 27,471 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. WE MAKE THIS HAPPEN BY ARRANGING GREAT DAYS OUT AT MERLIN ENTERTAINMENTS GROUP ATTRACTIONS AND PROVIDE TRAVEL GRANTS.
IRS990/DescribedInSection501c3Ind01
IRS990/DisregardedEntityInd00
IRS990/DocumentRetentionPolicyInd00
IRS990/DonorAdvisedFundInd00
IRS990/ElectionOfBoardMembersInd00
IRS990/EmployeeCnt00
IRS990/EngagedInExcessBenefitTransInd00
IRS990/ExpenseAmt0921966
IRS990/FamilyOrBusinessRlnInd01
IRS990/FederalGrantAuditRequiredInd00
IRS990/ForeignActivitiesInd00
IRS990/ForeignFinancialAccountInd00
IRS990/ForeignOfficeInd00
IRS990/Form8282PropertyDisposedOfInd00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt040.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt140.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt00.25
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt10.25
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt20.25
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt30.25
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt40.25
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt540.00
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd0X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd1X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd2X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd3X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd4X
IRS990/Form990PartVIISectionAGrp/OfficerInd0X
IRS990/Form990PartVIISectionAGrp/OfficerInd1X
IRS990/Form990PartVIISectionAGrp/OfficerInd2X
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt030000
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt10
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt20
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt30
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt418808
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt518808
IRS990/Form990PartVIISectionAGrp/PersonNm0PETER RONCHETTI
IRS990/Form990PartVIISectionAGrp/PersonNm1BRIAN SHAW
IRS990/Form990PartVIISectionAGrp/PersonNm2KIM CLARK
IRS990/Form990PartVIISectionAGrp/PersonNm3JANINE DIGIOACCHINO
IRS990/Form990PartVIISectionAGrp/PersonNm4ROBERT LORENZINI
IRS990/Form990PartVIISectionAGrp/PersonNm5TRACIE HOGENCAMP
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt0180000
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt4114929
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt554512
IRS990/Form990PartVIISectionAGrp/TitleTxt0CHARITY PRESIDENT
IRS990/Form990PartVIISectionAGrp/TitleTxt1CHARITY CFO/SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt2BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt3BOARD MEMBER
IRS990/Form990PartVIISectionAGrp/TitleTxt4BOARD ADVISOR
IRS990/Form990PartVIISectionAGrp/TitleTxt5CHARITY MANAGER
IRS990/Form990ProvidedToGvrnBodyInd01
IRS990/FormationYr02012
IRS990/FormerOfcrEmployeesListedInd00
IRS990/FSAuditedBasisGrp/SeparateBasisFinclStmtInd0X
IRS990/FSAuditedInd01
IRS990/FundraisingActivitiesInd01
IRS990/FundraisingAmt072140
IRS990/FundraisingDirectExpensesAmt054468
IRS990/FundraisingGrossIncomeAmt022409
IRS990/GamingActivitiesInd00
IRS990/GoverningBodyVotingMembersCnt04
IRS990/GrantAmt0885131
IRS990/GrantsToDomesticIndividualsGrp/ProgramServicesAmt0887212
IRS990/GrantsToDomesticIndividualsGrp/TotalAmt0887212
IRS990/GrantsToDomesticOrgsGrp/ProgramServicesAmt0140588
IRS990/GrantsToDomesticOrgsGrp/TotalAmt0140588
IRS990/GrantsToIndividualsInd01
IRS990/GrantsToOrganizationsInd01
IRS990/GrantToRelatedPersonInd00
IRS990/GrossReceiptsAmt01225142
IRS990/GroupReturnForAffiliatesInd00
IRS990/IncludeFIN48FootnoteInd01
IRS990/IndependentAuditFinclStmtInd01
IRS990/IndependentVotingMemberCnt04
IRS990/IndivRcvdGreaterThan100KCnt00
IRS990/IndoorTanningServicesInd00
IRS990/InfoInScheduleOPartIIIInd0X
IRS990/InfoInScheduleOPartVIIInd0X
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InfoInScheduleOPartXIIInd0X
IRS990/InvestmentInJointVentureInd00
IRS990/IRPDocumentCnt01
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipAccumDeprecAmt01888
IRS990/LandBldgEquipBasisNetGrp/BOYAmt01125
IRS990/LandBldgEquipBasisNetGrp/EOYAmt0369
IRS990/LandBldgEquipCostOrOtherBssAmt02257
IRS990/LegalDomicileStateCd0CA
IRS990/LoanOutstandingInd00
IRS990/LobbyingActivitiesInd00
IRS990/LocalChaptersInd00
IRS990/MaterialDiversionOrMisuseInd00
IRS990/MembersOrStockholdersInd00
IRS990/MethodOfAccountingAccrualInd0X
IRS990/MinutesOfCommitteesInd01
IRS990/MinutesOfGoverningBodyInd01
IRS990/MissionDesc0MERLIN'S MAGIC WAND FOUNDATION BELIEVES IN PUTTING THE MAGIC BACKINTO THE LIVES OF SERIOUSLY ILL, DISABLED AND DISADVANTAGED CHILDRENAROUND THE USA.
IRS990/MoreThan5000KToIndividualsInd00
IRS990/MoreThan5000KToOrgInd00
IRS990/NetAssetsOrFundBalancesBOYAmt0290493
IRS990/NetAssetsOrFundBalancesEOYAmt0276342
IRS990/NetIncmFromFundraisingEvtGrp/ExclusionAmt0-32059
IRS990/NetIncmFromFundraisingEvtGrp/TotalRevenueColumnAmt0-32059
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NoncashContributionsAmt0980480
IRS990/NondeductibleContributionsInd00
IRS990/OfficeExpensesGrp/FundraisingAmt0470
IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt028158
IRS990/OfficeExpensesGrp/ProgramServicesAmt01412
IRS990/OfficeExpensesGrp/TotalAmt030040
IRS990/OfficerMailingAddressInd00
IRS990/OperateHospitalInd00
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsSFAS117Ind0X
IRS990/OtherChangesInNetAssetsAmt00
IRS990/OtherSalariesAndWagesGrp/FundraisingAmt02688
IRS990/OtherSalariesAndWagesGrp/ManagementAndGeneralAmt07103
IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt014797
IRS990/OtherSalariesAndWagesGrp/TotalAmt024588
IRS990/OtherWebsiteInd0X
IRS990/PartialLiquidationInd00
IRS990/PayPremiumsPrsnlBnftCntrctInd00
IRS990/PledgesAndGrantsReceivableGrp/BOYAmt035187
IRS990/PledgesAndGrantsReceivableGrp/EOYAmt010240
IRS990/PoliticalCampaignActyInd00
IRS990/PrepaidExpensesDefrdChargesGrp/BOYAmt01990
IRS990/PrepaidExpensesDefrdChargesGrp/EOYAmt02395
IRS990/PrincipalOfficerNm0BRIAN SHAW
IRS990/PriorPeriodAdjustmentsAmt016500
IRS990/ProfessionalFundraisingInd00
IRS990/ProgSrvcAccomActy2Grp/Desc0MERLIN'S MAGIC SPACES ARE PROJECTS DESIGNED TO ENSURE THAT LOCAL CHILDREN WHO ARE PREVENTED FROM VISITING A MERLIN ENTERTAINMENTS ATTRACTION (DUE TO SEVERE ILLNESS, PHYSICAL DISABILITY OR OTHER EXCEPTIONAL CIRCUMSTANCES) STILL HAVE THE OPPORTUNITY TO EXPERIENCE THE MAGIC OF MERLIN.
IRS990/ProgSrvcAccomActy2Grp/ExpenseAmt0169622
IRS990/ProgSrvcAccomActy2Grp/GrantAmt0140588
IRS990/ProgSrvcAccomActy3Grp/Desc0COMMUNITY OUTREACH - EMPLOYEES FROM MERLIN ATTRACTIONS VISIT A LOCAL CHILDREN'S HOSPITAL OR SCHOOLS FOR CHILDREN WITH SPECIAL EDUCATIONAL NEEDS AND ENGAGE THE CHILDREN IN A FUN MERLIN RELATED ACTIVITY. THIS GIVES THEM A UNIQUE OPPORTUNITY TO HAVE A NEW, STIMULATING EXPERIENCE.
IRS990/ProgSrvcAccomActy3Grp/ExpenseAmt06822
IRS990/ProgSrvcAccomActy3Grp/GrantAmt02081
IRS990/ProhibitedTaxShelterTransInd00
IRS990/PYBenefitsPaidToMembersAmt00
IRS990/PYContributionsGrantsAmt01023014
IRS990/PYExcessBenefitTransInd00
IRS990/PYGrantsAndSimilarPaidAmt0712709
IRS990/PYInvestmentIncomeAmt00
IRS990/PYOtherExpensesAmt053063
IRS990/PYOtherRevenueAmt0294
IRS990/PYProgramServiceRevenueAmt00
IRS990/PYRevenuesLessExpensesAmt0180945
IRS990/PYSalariesCompEmpBnftPaidAmt076591
IRS990/PYTotalExpensesAmt0842363
IRS990/PYTotalProfFndrsngExpnsAmt00
IRS990/PYTotalRevenueAmt01023308
IRS990/QuidProQuoContributionsInd01
IRS990/QuidProQuoContriDisclInd01
IRS990/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990/ReconcilationRevenueExpnssAmt0-30651
IRS990/RegularMonitoringEnfrcInd01
IRS990/RelatedEntityInd01
IRS990/RelatedOrganizationCtrlEntInd00
IRS990/RelatedOrganizationsAmt0317203
IRS990/ReportInvestmentsOtherSecInd00
IRS990/ReportLandBuildingEquipmentInd01
IRS990/ReportOtherAssetsInd00
IRS990/ReportOtherLiabilitiesInd00
IRS990/ReportProgramRelatedInvstInd00
IRS990ScheduleA/AmountsRcvdDsqlfyPersonGrp/TotalAmt00
IRS990ScheduleA/First5Years509Ind0X
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt01202733
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt01037976
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt0192565
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt02433274
IRS990ScheduleA/OtherIncome509Grp/CurrentTaxYearAmt022409
IRS990ScheduleA/OtherIncome509Grp/TotalAmt022409
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportTotal509Amt02433274
IRS990ScheduleA/SubstAndDsqlfyPrsnsTotGrp/TotalAmt00
IRS990ScheduleA/SubstantialContributorsAmtGrp/TotalAmt00
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt01202733
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt01037976
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt0192565
IRS990ScheduleA/Total509Grp/TotalAmt02433274
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt01225142
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt01037976
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt0192565
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt02455683
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
IRS990/ScheduleBRequiredInd01
IRS990ScheduleD/DonatedServicesAndUseFcltsAmt047541
IRS990ScheduleD/DonatedServicesUseFcltsAmt047541
IRS990ScheduleD/EquipmentGrp/BookValueAmt0369
IRS990ScheduleD/EquipmentGrp/DepreciationAmt01888
IRS990ScheduleD/EquipmentGrp/OtherCostOrOtherBasisAmt02257
IRS990ScheduleD/ExpensesNotReportedAmt0102009
IRS990ScheduleD/ExpensesNotRptFinclStmtAmt00
IRS990ScheduleD/ExpensesSubtotalAmt01201325
IRS990ScheduleD/FootnoteTextInd0X
IRS990ScheduleD/OtherExpensesIncludedAmt054468
IRS990ScheduleD/OtherRevenueAmt054468
IRS990ScheduleD/RevenueNotReportedAmt0102009
IRS990ScheduleD/RevenueNotReportedFinclStmtAmt00
IRS990ScheduleD/RevenueSubtotalAmt01170674
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt0MMWF HAS EVALUATED THE FINANCIAL STATEMENT IMPACT OF TAX POSITIONS TAKEN OR EXPECTED TO BE TAKEN IN ITS TAX RETURNS. MANAGEMENT HAS DETERMINED THAT NO TAX LIABILITIES NEED TO BE RECORDED UNDER APPLICABLE ACCOUNTING GUIDANCE FOR THE YEAR ENDED DECEMBER 31, 2016. MMWF'S FEDERAL AND STATE INFORMATION RETURNS FOR TAX YEARS 2012 AND LATER REMAIN SUBJECT TO EXAMINATION BY TAXING AUTHORITIES.
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt1SPECIAL EVENT EXPENSES NETTED AGAINST REVENUE ON FORM 990
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt2SPECIAL EVENT EXPENSES NETTED AGAINST REVENUE ON FORM 990
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc0PART X, LINE 2:
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc1PART XI, LINE 2D - OTHER ADJUSTMENTS:
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc2PART XII, LINE 2D - OTHER ADJUSTMENTS:
IRS990ScheduleD/TotalBookValueLandBuildingsAmt0369
IRS990ScheduleD/TotalExpensesPerForm990Amt01201325
IRS990ScheduleD/TotalRevenuePerForm990Amt01170674
IRS990ScheduleD/TotalRevEtcAuditedFinclStmtAmt01272683
IRS990ScheduleD/TotExpnsEtcAuditedFinclStmtAmt01303334
IRS990ScheduleG/FundraisingEventInformationGrp/CharitableContributionsTotAmt072140
IRS990ScheduleG/FundraisingEventInformationGrp/CharitableContriEvent1Amt040377
IRS990ScheduleG/FundraisingEventInformationGrp/CharitableContriEvent2Amt029408
IRS990ScheduleG/FundraisingEventInformationGrp/CharitableContriOtherEventsAmt02355
IRS990ScheduleG/FundraisingEventInformationGrp/DirectExpenseSummaryEventsAmt054468
IRS990ScheduleG/FundraisingEventInformationGrp/Event1Nm0GOLF TOURNAMENT
IRS990ScheduleG/FundraisingEventInformationGrp/Event2Nm0GOLF TOURNAMENT
IRS990ScheduleG/FundraisingEventInformationGrp/FoodAndBeverageEvent1Amt03628
IRS990ScheduleG/FundraisingEventInformationGrp/FoodAndBeverageEvent2Amt04922
IRS990ScheduleG/FundraisingEventInformationGrp/FoodAndBeverageTotalEventsAmt08550
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent1Amt046855
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent2Amt043389
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsOtherEventsAmt04305
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsTotalAmt094549
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent1Amt06478
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent2Amt013981
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueOtherEventsAmt01950
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueTotalEventsAmt022409
IRS990ScheduleG/FundraisingEventInformationGrp/NetIncomeSummaryAmt0-32059
IRS990ScheduleG/FundraisingEventInformationGrp/OthDirectExpnssOtherEventsAmt02180
IRS990ScheduleG/FundraisingEventInformationGrp/OthDirectExpnssTotalEventsAmt032710
IRS990ScheduleG/FundraisingEventInformationGrp/OtherDirectExpensesEvent1Amt015421
IRS990ScheduleG/FundraisingEventInformationGrp/OtherDirectExpensesEvent2Amt015109
IRS990ScheduleG/FundraisingEventInformationGrp/OtherEventsTotalCnt01
IRS990ScheduleG/FundraisingEventInformationGrp/RentFacilityCostsEvent1Amt08200
IRS990ScheduleG/FundraisingEventInformationGrp/RentFacilityCostsEvent2Amt05008
IRS990ScheduleG/FundraisingEventInformationGrp/RentFcltyCostsTotalEventsAmt013208
IRS990ScheduleI/GrantRecordsMaintainedInd01
IRS990ScheduleI/GrantsOtherAsstToIndivInUSGrp/CashGrantAmt06932
IRS990ScheduleI/GrantsOtherAsstToIndivInUSGrp/CashGrantAmt12081
IRS990ScheduleI/GrantsOtherAsstToIndivInUSGrp/GrantTypeTxt0TRAVEL GRANTS
IRS990ScheduleI/GrantsOtherAsstToIndivInUSGrp/GrantTypeTxt1MAGICAL DAYS OUT
IRS990ScheduleI/GrantsOtherAsstToIndivInUSGrp/GrantTypeTxt2COMMUNITY OUTREACH
IRS990ScheduleI/GrantsOtherAsstToIndivInUSGrp/NonCashAssistanceAmt0878199
IRS990ScheduleI/GrantsOtherAsstToIndivInUSGrp/NonCashAssistanceDesc0N/A
IRS990ScheduleI/GrantsOtherAsstToIndivInUSGrp/NonCashAssistanceDesc1ATTRACTION TICKETS
IRS990ScheduleI/GrantsOtherAsstToIndivInUSGrp/NonCashAssistanceDesc2N/A
IRS990ScheduleI/GrantsOtherAsstToIndivInUSGrp/RecipientCnt054
IRS990ScheduleI/GrantsOtherAsstToIndivInUSGrp/RecipientCnt127471
IRS990ScheduleI/GrantsOtherAsstToIndivInUSGrp/RecipientCnt220
IRS990ScheduleI/GrantsOtherAsstToIndivInUSGrp/ValuationMethodUsedDesc0N/A
IRS990ScheduleI/GrantsOtherAsstToIndivInUSGrp/ValuationMethodUsedDesc1FMV
IRS990ScheduleI/GrantsOtherAsstToIndivInUSGrp/ValuationMethodUsedDesc2N/A
IRS990ScheduleI/RecipientTable/CashGrantAmt032650
IRS990ScheduleI/RecipientTable/CashGrantAmt18757
IRS990ScheduleI/RecipientTable/CashGrantAmt218987
IRS990ScheduleI/RecipientTable/IRCSectionDesc0501(C)3
IRS990ScheduleI/RecipientTable/IRCSectionDesc1501(C)3
IRS990ScheduleI/RecipientTable/IRCSectionDesc2501(C)3
IRS990ScheduleI/RecipientTable/NonCashAssistanceAmt033172
IRS990ScheduleI/RecipientTable/NonCashAssistanceAmt135260
IRS990ScheduleI/RecipientTable/NonCashAssistanceAmt211762
IRS990ScheduleI/RecipientTable/NonCashAssistanceDesc0PRODUCTS AND GOODS FOR BUILD AND REFURBISHMENT
IRS990ScheduleI/RecipientTable/NonCashAssistanceDesc1PRODUCTS AND GOODS FOR BUILD AND REFURBISHMENT
IRS990ScheduleI/RecipientTable/NonCashAssistanceDesc2PRODUCTS AND GOODS FOR BUILD AND REFURBISHMENT
IRS990ScheduleI/RecipientTable/PurposeOfGrantTxt0FOR DESIGN AND REFURBISHMENT OF 3 THERAPY ROOMS FOR CHILDREN ATTENDING THE CENTER.
IRS990ScheduleI/RecipientTable/PurposeOfGrantTxt1FOR THE DESIGN AND REFURBISHMENT OF THE CHILDREN'S WAITING AREA.
IRS990ScheduleI/RecipientTable/PurposeOfGrantTxt2FOR THE DESIGN AND REFURBISHMENT OF THE CHILDREN'S PLAY AREA AND WAITING ROOM.
IRS990ScheduleI/RecipientTable/RecipientBusinessName/BusinessNameLine1Txt0HOWARD PHILLIPS CENTRE ORLANDO
IRS990ScheduleI/RecipientTable/RecipientBusinessName/BusinessNameLine1Txt1RADY'S CHILDREN CENTRE SAN DIEGO
IRS990ScheduleI/RecipientTable/RecipientBusinessName/BusinessNameLine1Txt2MERCY CHILDREN'S HOSPITAL KANSAS
IRS990ScheduleI/RecipientTable/RecipientEIN0592244943
IRS990ScheduleI/RecipientTable/USAddress/AddressLine1Txt0601 W MICHIGAN ST
IRS990ScheduleI/RecipientTable/USAddress/AddressLine1Txt16020 CHILDRENS WAY
IRS990ScheduleI/RecipientTable/USAddress/AddressLine1Txt22401 GILLHAM ROAD
IRS990ScheduleI/RecipientTable/USAddress/CityNm0ORLANDO
IRS990ScheduleI/RecipientTable/USAddress/CityNm1SAN DIEGO
IRS990ScheduleI/RecipientTable/USAddress/CityNm2KANSAS CITY
IRS990ScheduleI/RecipientTable/USAddress/StateAbbreviationCd0FL
IRS990ScheduleI/RecipientTable/USAddress/StateAbbreviationCd1CA
IRS990ScheduleI/RecipientTable/USAddress/StateAbbreviationCd2MO
IRS990ScheduleI/RecipientTable/USAddress/ZIPCd032805
IRS990ScheduleI/RecipientTable/USAddress/ZIPCd192123
IRS990ScheduleI/RecipientTable/USAddress/ZIPCd264108
IRS990ScheduleI/RecipientTable/ValuationMethodUsedDesc0FMV
IRS990ScheduleI/RecipientTable/ValuationMethodUsedDesc1FMV
IRS990ScheduleI/RecipientTable/ValuationMethodUsedDesc2FMV
IRS990ScheduleI/SupplementalInformationDetail/ExplanationTxt0THE FOUNDATION REVIEWS APPLICATIONS AND HAS PROCEDURES IN PLACE TO DETERMINE ELIGIBILITY. THE FOUNDATION COORDINATES TRAVEL AND ATTRACTION TICKETS WITH THE FAMILIES WHICH ENSURES THE PROPER USE OF THE GRANT FUNDS.
IRS990ScheduleI/SupplementalInformationDetail/FormAndLineReferenceDesc0PART I, LINE 2:
IRS990ScheduleI/Total501c3OrgCnt03
IRS990ScheduleI/TotalOtherOrgCnt00
IRS990ScheduleJ/AnyNonFixedPaymentsInd00
IRS990ScheduleJ/CompBasedOnRevenueOfFlngOrgInd00
IRS990ScheduleJ/CompBsdNetEarnsFlngOrgInd00
IRS990ScheduleJ/CompBsdNetEarnsRltdOrgsInd00
IRS990ScheduleJ/CompBsdOnRevRelatedOrgsInd00
IRS990ScheduleJ/EquityBasedCompArrngmInd00
IRS990ScheduleJ/InitialContractExceptionInd00
IRS990/ScheduleJRequiredInd01
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BaseCompensationFilingOrgAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BonusFilingOrganizationAmount00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BonusRelatedOrganizationsAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompensationBasedOnRltdOrgsAmt0180000
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompReportPrior990FilingOrgAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompReportPrior990RltdOrgsAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/DeferredCompensationFlngOrgAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/DeferredCompRltdOrgsAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/NontaxableBenefitsFilingOrgAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/NontaxableBenefitsRltdOrgsAmt030000
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/OtherCompensationFilingOrgAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/OtherCompensationRltdOrgsAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/PersonNm0PETER RONCHETTI
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/TitleTxt0CHARITY PRESIDENT
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/TotalCompensationFilingOrgAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/TotalCompensationRltdOrgsAmt0210000
IRS990ScheduleJ/SeverancePaymentInd00
IRS990ScheduleJ/SupplementalNonqualRtrPlanInd00
IRS990ScheduleM/AnyPropertyThatMustBeHeldInd00
IRS990ScheduleM/OtherNonCashContriTableGrp/ContributionCnt027471
IRS990ScheduleM/OtherNonCashContriTableGrp/ContributionCnt13
IRS990ScheduleM/OtherNonCashContriTableGrp/ContributionCnt22
IRS990ScheduleM/OtherNonCashContriTableGrp/Desc0TICKETS IN KIND
IRS990ScheduleM/OtherNonCashContriTableGrp/Desc1GOODS FOR MERLIN'S MAGIC SPACES

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$362,121
Liabilities
$85,779
Net assets
$276,342
Revenue
$1,170,674
Expenses
$1,201,325
Net income
-$30,651
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.03$0.38$0.65$0.40$0.36$0.04
2023Detailed filing. Detailed filing data is available for this year.$1.03$0.42$0.61$0.44$0.51$0.07
2022Detailed filing. Detailed filing data is available for this year.$0.90$0.22$0.68$0.45$0.23$0.22
2021Detailed filing. Detailed filing data is available for this year.$0.57$0.12$0.46$0.48$0.19$0.29
2020Detailed filing. Detailed filing data is available for this year.$0.37$0.21$0.16$0.17$0.23$0.06
2019Detailed filing. Detailed filing data is available for this year.$0.46$0.23$0.23$0.27$0.35$0.08
2018Detailed filing. Detailed filing data is available for this year.$0.48$0.17$0.31$0.34$0.29$0.05
2017Summary only. Only limited summary data is available for this year.$0.38$0.12$0.26$0.27$0.28$0.02
2016Detailed filing. Detailed filing data is available for this year.$0.36$0.09$0.28$1.17$1.20$0.03
2015Detailed filing. Detailed filing data is available for this year.$0.43$0.14$0.29$1.02$0.84$0.18
2014Detailed filing. Detailed filing data is available for this year.$0.27$0.16$0.11$0.19$0.08$0.11