Civic Intelligence

Merlin Foundation

990EZ • Fiscal year 2017 • EIN 71-0747717

Jan 01, 2017 to Dec 31, 2017 • Filed on Apr 22, 2018

12825 Hwy 412Alpena, AR 72611-8926

(870) 553-2355

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

65th percentile

11%

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

49th percentile

1.4%

Faster asset growth than 49% of similar nonprofits.

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

Revenue Growth

11th percentile

-43%

Faster revenue growth than 11% of similar nonprofits.

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

Assets

Up

$155,919

Up $2,077 (+1.4%) from 2016

Net Assets

Up

$155,919

Up $2,077 (+1.4%) from 2016

Liabilities

Flat

$0

Flat from 2016

Revenue

Down

$18,988

Down $14,330 (-43%) from 2016

Expenses

Down

$16,911

Down $12,752 (-43%) from 2016

Net Income

Down

$2,077

Down $1,578 (-43%) from 2016

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

2017

Assets$155,919
Liabilities$0
Net Assets$155,919

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

2017

Revenue$18,988
Expenses$16,911
Net Income$2,077
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Apr 22, 2018
Return Version
2017v2.0
Gross Receipts
$18,988
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 (532 Clients)$0$14,374
Health-General and Rehabilitative: Indigent Women Breast Care Project, Transportation supplement (185 clients).$0$2,537
Compensation and Service Providers

Employees

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

Filer

Filer Name
Merlin Foundation
EIN
71-0747717
Phone
8705532355
Address
12825 Hwy 412, Alpena, AR 72611-8926

Signing Officer

Name
Anita L Engert
Title
Director, Treasurer
Phone
8705532355
Signed
2018-04-22
Supplemental Narrative

Additional Explanations

Form 990-EZ, Part I, Line 16

Total for all programs

Form 990-EZ, Part II, Line 24

Form 990-EZ, Part II, line 24 Deposits Utilities

Raw XML Appendix160 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/BenefitsPaidToOrForMembersAmt00
IRS990EZ/BooksInCareOfDetail/PersonNm0Anita L Engert
IRS990EZ/BooksInCareOfDetail/PhoneNum08705532355
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt012825 Hwy 412
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0Alpena
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0AR
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd0726118926
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt089687
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt091764
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd00
IRS990EZ/ContributionsGiftsGrantsEtcAmt018888
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DirectIndirectPltclExpendAmt00
IRS990EZ/DonorAdvisedFndsInd00
IRS990EZ/EngagedInExcessBenefitTransInd00
IRS990EZ/ExcessOrDeficitForYearAmt02077
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt00
IRS990EZ/FiledScheduleAInd01
IRS990EZ/ForeignFinancialAccountInd00
IRS990EZ/ForeignOfficeInd00
IRS990EZ/Form1120PolFiledInd00
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0153842
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0155919
IRS990EZ/FundraisingGrossIncomeAmt00
IRS990EZ/GainOrLossFromSaleOfAssetsAmt00
IRS990EZ/GamingGrossIncomeAmt00
IRS990EZ/GrantsAndSimilarAmountsPaidAmt00
IRS990EZ/GrossProfitLossSlsOfInvntryAmt00
IRS990EZ/GrossReceiptsAmt018988
IRS990EZ/GrossSalesOfInventoryAmt00
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt0100
IRS990EZ/LandAndBuildingsGrp/BOYAmt063850
IRS990EZ/LandAndBuildingsGrp/EOYAmt063850
IRS990EZ/LobbyingActivitiesInd00
IRS990EZ/MadeLoansToFromOfficersInd00
IRS990EZ/MembershipDuesAmt00
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0153842
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0155919
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0153842
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0155919
IRS990EZ/OccupancyRentUtltsAndMaintAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt010
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt120
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt210
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/OtherExpensesTotalAmt016911
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 (532 Clients)
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1Health-General and Rehabilitative: Indigent Women Breast Care Project, Transportation supplement (185 clients).
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt00
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt10
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt014374
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt12537
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/TotalExpensesAmt016911
IRS990EZ/TotalProgramServiceExpensesAmt016911
IRS990EZ/TotalRevenueAmt018988
IRS990EZ/TransactionWithControlEntInd00
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd00
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0http://www.merlinfoundation.com
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt018888
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt033241
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt024603
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt060662
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt058040
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt0195434
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus1YearAmt077
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus2YearsAmt0148
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus3YearsAmt0195
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus4YearsAmt0163
IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt0583
IRS990ScheduleA/OtherIncome170Grp/CurrentTaxYearMinus3YearsAmt00
IRS990ScheduleA/OtherIncome170Grp/TotalAmt00
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00.99703
IRS990ScheduleA/PublicSupportPY170Pct00.99750
IRS990ScheduleA/PublicSupportTotal170Amt0195434
IRS990ScheduleA/ThirtyThrPctSuprtTestsPY170Ind0X
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt018888
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt033241
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt024603
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt060662
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt058040
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt0195434
IRS990ScheduleA/TotalSupportAmt0196017
IRS990ScheduleA/UnrelatedBusinessNetIncm170Grp/CurrentTaxYearMinus3YearsAmt00
IRS990ScheduleA/UnrelatedBusinessNetIncm170Grp/TotalAmt00
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Total for all programs
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Form 990-EZ, Part II, line 24 Deposits Utilities
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Form 990-EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Form 990-EZ, Part II, Line 24
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/PersonNm0Anita L Engert
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Director, Treasurer
ReturnHeader/BusinessOfficerGrp/PhoneNum08705532355
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-04-22
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0MERLIN FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0MERL
ReturnHeader/Filer/EIN0710747717
ReturnHeader/Filer/PhoneNum08705532355
ReturnHeader/Filer/USAddress/AddressLine1Txt012825 Hwy 412
ReturnHeader/Filer/USAddress/CityNm0Alpena
ReturnHeader/Filer/USAddress/StateAbbreviationCd0AR
ReturnHeader/Filer/USAddress/ZIPCd0726118926
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt068.171.90.199
ReturnHeader/ReturnTs02018-04-22T14:43:29-07: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

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