Civic Intelligence

Merlin Foundation

990EZ • Fiscal year 2018 • EIN 71-0747717

Jan 01, 2018 to Dec 31, 2018 • Filed on Jul 22, 2019

206 S Main StBerryville, AR 72616

(870) 929-6213

Siviq Scores

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

Liabilities / Assets

57th percentile

0.00x

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

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

Liabilities / Revenue

56th percentile

0.00x

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

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

Net Margin

85th percentile

33%

Higher net margin than 85% 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

55th percentile

4.2%

Faster asset growth than 55% of similar nonprofits.

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

Revenue Growth

57th percentile

5.3%

Faster revenue growth than 57% of similar nonprofits.

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

Assets

Up

$162,534

Up $6,615 (+4.2%) from 2017

Net Assets

Up

$162,534

Up $6,615 (+4.2%) from 2017

Liabilities

Flat

$0

Flat from 2017

Revenue

Up

$19,985

Up $997 (+5.3%) from 2017

Expenses

Down

$13,370

Down $3,541 (-21%) from 2017

Net Income

Up

$6,615

Up $4,538 (+218%) from 2017

Historical Trend

Balance Sheet Trend

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

$300K$200K$100K$0Assets 2010: $136,229Liabilities 2010: $0Net Assets 2010: $136,2292010Assets 2011: $148,733Liabilities 2011: $0Net Assets 2011: $148,7332011Assets 2012: $176,510Liabilities 2012: $0Net Assets 2012: $176,5102012Assets 2013: $169,136Liabilities 2013: $0Net Assets 2013: $169,1362013Assets 2014: $175,746Liabilities 2014: $0Net Assets 2014: $175,7462014Assets 2015: $150,187Liabilities 2015: $0Net Assets 2015: $150,1872015Assets 2016: $153,842Liabilities 2016: $0Net Assets 2016: $153,8422016Assets 2017: $155,919Liabilities 2017: $0Net Assets 2017: $155,9192017Assets 2018: $162,534Liabilities 2018: $0Net Assets 2018: $162,5342018Assets 2019: $178,658Liabilities 2019: $0Net Assets 2019: $178,6582019Assets 2020: $213,969Liabilities 2020: $0Net Assets 2020: $213,9692020Assets 2021: $232,706Liabilities 2021: $0Net Assets 2021: $232,7062021Assets 2022: $247,235Liabilities 2022: $0Net Assets 2022: $247,2352022

Highlighted filing

2018

Assets$162,534
Liabilities$0
Net Assets$162,534

Operations Trend

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

$150K$100K$50K$0-$50KRevenue 2010: $72,669Expenses 2010: $89,132Net Income 2010: -$16,4632010Revenue 2011: $108,533Expenses 2011: $78,921Net Income 2011: $29,6122011Revenue 2012: $106,723Expenses 2012: $78,894Net Income 2012: $27,8292012Revenue 2013: $58,203Expenses 2013: $65,577Net Income 2013: -$7,3742013Revenue 2014: $60,857Expenses 2014: $54,247Net Income 2014: $6,6102014Revenue 2015: $24,751Expenses 2015: $50,310Net Income 2015: -$25,5592015Revenue 2016: $33,318Expenses 2016: $29,663Net Income 2016: $3,6552016Revenue 2017: $18,988Expenses 2017: $16,911Net Income 2017: $2,0772017Revenue 2018: $19,985Expenses 2018: $13,370Net Income 2018: $6,6152018Revenue 2019: $22,561Expenses 2019: $6,437Net Income 2019: $16,1242019Revenue 2020: $44,273Expenses 2020: $8,962Net Income 2020: $35,3112020Revenue 2021: $68,871Expenses 2021: $50,134Net Income 2021: $18,7372021Revenue 2022: $25,828Expenses 2022: $11,299Net Income 2022: $14,5292022

Highlighted filing

2018

Revenue$19,985
Expenses$13,370
Net Income$6,615
Jump To
Filing Snapshot
Filing Period
Jan 1, 2018 to Dec 31, 2018
Signed
Jul 22, 2019
Return Version
2018v3.0
Gross Receipts
$19,985
Mission and Program Overview

Mission

Victim Assistance and Advocacy for Children & Families and health care assistance.

Program Services

DescriptionGrantsExpenses
Human Services - Multipurpose: Advocacy and assistance for children (601 Clients)$0$12,995
Health-General and Rehabilitative: Indigent Women Breast Care Project, Transportation supplement (7 clients).$0$375
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
Anita L EngertDirector-$0--
Michelle SteinerDirectorPT$0--
Robert BartosDirector, Chair-$0--
Filing and Contact Details

Filer

Filer Name
Merlin Foundation
EIN
71-0747717
Phone
8709296213
Address
206 S Main St, Berryville, AR 72616

Signing Officer

Name
Anita L Engert
Title
Director, Treasurer
Phone
8709296213
Signed
2019-07-22
Supplemental Narrative

Additional Explanations

Form 990-EZ, Part I, Line 16

Part 1 Line 16 Program expenses total for all programs

Form 990-EZ, Part II, Line 24

Deposits utilities

Raw XML Appendix164 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/ActivitiesNotPreviouslyRptInd00
IRS990EZ/AddressChangeInd0X
IRS990EZ/BenefitsPaidToOrForMembersAmt00
IRS990EZ/BooksInCareOfDetail/PersonNm0Anita L Engert
IRS990EZ/BooksInCareOfDetail/PhoneNum08709296213
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt01401 Julie St
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0Berryville
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0AR
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd072616
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt091764
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt098379
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd00
IRS990EZ/ContributionsGiftsGrantsEtcAmt019614
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DirectIndirectPltclExpendAmt00
IRS990EZ/DonorAdvisedFndsInd00
IRS990EZ/EngagedInExcessBenefitTransInd00
IRS990EZ/ExcessOrDeficitForYearAmt06615
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt00
IRS990EZ/FiledScheduleAInd01
IRS990EZ/ForeignFinancialAccountInd00
IRS990EZ/ForeignOfficeInd00
IRS990EZ/Form1120PolFiledInd00
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0155919
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0162534
IRS990EZ/FundraisingGrossIncomeAmt00
IRS990EZ/GainOrLossFromSaleOfAssetsAmt00
IRS990EZ/GamingGrossIncomeAmt00
IRS990EZ/GrantsAndSimilarAmountsPaidAmt00
IRS990EZ/GrossProfitLossSlsOfInvntryAmt00
IRS990EZ/GrossReceiptsAmt019985
IRS990EZ/GrossSalesOfInventoryAmt00
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt0371
IRS990EZ/LandAndBuildingsGrp/BOYAmt063850
IRS990EZ/LandAndBuildingsGrp/EOYAmt063850
IRS990EZ/LobbyingActivitiesInd00
IRS990EZ/MadeLoansToFromOfficersInd00
IRS990EZ/MembershipDuesAmt00
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0155919
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0162534
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0155919
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0162534
IRS990EZ/OccupancyRentUtltsAndMaintAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt03
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt15
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt23
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/PersonNm0Anita L Engert
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1Michelle Steiner
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2Robert Bartos
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2Director, Chair
IRS990EZ/OperateHospitalInd00
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd00
IRS990EZ/OrganizationHadUBIInd00
IRS990EZ/OtherAssetsTotalDetail/BOYAmt0305
IRS990EZ/OtherAssetsTotalDetail/EOYAmt0305
IRS990EZ/OtherChangesInNetAssetsAmt00
IRS990EZ/OtherExpensesTotalAmt013370
IRS990EZ/OtherRevenueTotalAmt00
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd00
IRS990EZ/PrimaryExemptPurposeTxt0Victim Assistance and Advocacy for Children & Families and health care assistance.
IRS990EZ/PrintingPublicationsPostageAmt00
IRS990EZ/ProgramServiceRevenueAmt00
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0Human Services - Multipurpose: Advocacy and assistance for children (601 Clients)
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1Health-General and Rehabilitative: Indigent Women Breast Care Project, Transportation supplement (7 clients).
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt00
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt10
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt012995
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt1375
IRS990EZ/ProhibitedTaxShelterTransInd00
IRS990EZ/RelatedOrganizationCtrlEntInd00
IRS990EZ/SalariesOtherCompEmplBnftAmt00
IRS990EZ/SaleOfAssetsGrossAmt00
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd00
IRS990EZ/SpecialEventsDirectExpensesAmt00
IRS990EZ/SpecialEventsNetIncomeLossAmt00
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0AR
IRS990EZ/SubjectToProxyTaxInd00
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt00
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt00
IRS990EZ/TanningServicesProvidedInd00
IRS990EZ/TaxImposedOnOrganizationMgrAmt00
IRS990EZ/TaxImposedUnderIRC4911Amt00
IRS990EZ/TaxImposedUnderIRC4912Amt00
IRS990EZ/TaxImposedUnderIRC4955Amt00
IRS990EZ/TaxReimbursedByOrganizationAmt00
IRS990EZ/TotalExpensesAmt013370
IRS990EZ/TotalProgramServiceExpensesAmt013370
IRS990EZ/TotalRevenueAmt019985
IRS990EZ/TransactionWithControlEntInd00
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd00
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0http://www.merlinfoundation.com
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt019614
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt018888
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt033241
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt024603
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt060662
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt0157008
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearAmt0371
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus1YearAmt0100
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus2YearsAmt077
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus3YearsAmt0148
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus4YearsAmt0195
IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt0891
IRS990ScheduleA/GrossReceiptsRltdActivitiesAmt00
IRS990ScheduleA/OtherIncome170Grp/CurrentTaxYearMinus4YearsAmt00
IRS990ScheduleA/OtherIncome170Grp/TotalAmt00
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00.99436
IRS990ScheduleA/PublicSupportPY170Pct00.99703
IRS990ScheduleA/PublicSupportTotal170Amt0157008
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY170Ind0X
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt019614
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt018888
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt033241
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt024603
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt060662
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt0157008
IRS990ScheduleA/TotalSupportAmt0157899
IRS990ScheduleA/UnrelatedBusinessNetIncm170Grp/CurrentTaxYearMinus4YearsAmt00
IRS990ScheduleA/UnrelatedBusinessNetIncm170Grp/TotalAmt00
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Part 1 Line 16 Program expenses total for all programs
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Deposits utilities
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Form 990-EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Form 990-EZ, Part II, Line 24
ReasonableCauseExplanation/ExplanationTxt0The computer containing the financial information was lost during a move in April and was severely damaged when finally found in May. It was two months before it was functional again and much of the data was lost and had to be redone
ReturnHeader/BuildTS02019-02-21 02:37:17Z
ReturnHeader/BusinessOfficerGrp/PersonNm0Anita L Engert
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Director, Treasurer
ReturnHeader/BusinessOfficerGrp/PhoneNum08709296213
ReturnHeader/BusinessOfficerGrp/SignatureDt02019-07-22
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0MERLIN FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0MERL
ReturnHeader/Filer/EIN0710747717
ReturnHeader/Filer/PhoneNum08709296213
ReturnHeader/Filer/USAddress/AddressLine1Txt0206 S Main St
ReturnHeader/Filer/USAddress/CityNm0Berryville
ReturnHeader/Filer/USAddress/StateAbbreviationCd0AR
ReturnHeader/Filer/USAddress/ZIPCd072616
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt072.204.104.74
ReturnHeader/ReturnTs02019-07-22T15:41:58-07: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

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2022Detailed filing. Detailed filing data is available for this year.$2.47$0.00$2.47$0.26$0.11$0.15
2021Detailed filing. Detailed filing data is available for this year.$2.33$0.00$2.33$0.69$0.50$0.19
2020Detailed filing. Detailed filing data is available for this year.$2.14$0.00$2.14$0.44$0.09$0.35
2019Detailed filing. Detailed filing data is available for this year.$1.79$0.00$1.79$0.23$0.06$0.16
2018Detailed filing. Detailed filing data is available for this year.$1.63$0.00$1.63$0.20$0.13$0.07
2017Detailed filing. Detailed filing data is available for this year.$1.56$0.00$1.56$0.19$0.17$0.02
2016Detailed filing. Detailed filing data is available for this year.$1.54$0.00$1.54$0.33$0.30$0.04
2015Detailed filing. Detailed filing data is available for this year.$1.50$0.00$1.50$0.25$0.50$0.26
2014Detailed filing. Detailed filing data is available for this year.$1.76$0.00$1.76$0.61$0.54$0.07
2013Detailed filing. Detailed filing data is available for this year.$1.69$0.00$1.69$0.58$0.66$0.07
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.77$0.00$1.77$1.07$0.79$0.28
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.49$0.00$1.49$1.09$0.79$0.30
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.36$0.00$1.36$0.73$0.89$0.16