Civic Intelligence

Turtle Mountain Community College Foundation

990EZ • Fiscal year 2018 • EIN 46-1318232

Jul 01, 2017 to Jun 30, 2018 • Filed on May 14, 2019

Organization ProfileN/A
Bia Hwy 7Belcourt, ND 58316

(701) 477-7862

Siviq Scores

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

Liabilities / Assets

Score unavailable

No value available

Liabilities-to-assets requires both liabilities and assets on this filing.

Source year 2018

Liabilities / Revenue

Score unavailable

No value available

Liabilities-to-revenue requires both liabilities and revenue on this filing.

Source year 2018

Net Margin

36th percentile

-1.2%

Higher net margin than 36% of similar nonprofits.

2018 filings • NTEE B • <$500k nonprofits • Source year 2018

Top Officer Pay

84th percentile

$0

Higher top officer pay than 84% of similar nonprofits.

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

2018 filings • NTEE B • <$500k nonprofits • Source year 2018

Asset Growth

39th percentile

-1.6%

Faster asset growth than 39% of similar nonprofits.

2018 filings • NTEE B • <$500k nonprofits • Annualized from 2017 to 2018

Revenue Growth

79th percentile

34%

Faster revenue growth than 79% of similar nonprofits.

2018 filings • NTEE B • <$500k nonprofits • Annualized from 2017 to 2018

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Down

$26,304

Down $415 (-1.6%) from 2017

Net Assets

Down

$26,304

Down $415 (-1.6%) from 2017

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet Margin36th percentile

Revenue

Up

$35,510

Up $8,920 (+34%) from 2017

Expenses

Down

$35,925

Down $7,014 (-16%) from 2017

Net Income

Up

-$415

Up $15,934 (+97%) from 2017

Historical Trend

Balance Sheet Trend

Asset Growth39th percentile

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

$80K$60K$40K$20K$0Assets 2014: $0Net Assets 2014: $02014Assets 2015: $0Net Assets 2015: $02015Assets 2016: $43,068Net Assets 2016: $43,0682016Assets 2017: $26,719Net Assets 2017: $26,7192017Assets 2018: $26,304Net Assets 2018: $26,3042018Assets 2019: $26,844Liabilities 2019: $893Net Assets 2019: $25,9512019Assets 2020: $21,511Liabilities 2020: $0Net Assets 2020: $21,5112020Assets 2021: $34,040Liabilities 2021: $0Net Assets 2021: $34,0402021Assets 2022: $49,996Liabilities 2022: $0Net Assets 2022: $49,9962022Assets 2023: $79,394Liabilities 2023: $319Net Assets 2023: $79,0752023Assets 2024: $69,454Liabilities 2024: $0Net Assets 2024: $69,4542024

Highlighted filing

2018

Assets$26,304
Liabilities-
Net Assets$26,304
Open 2018 Filing

Operations Trend

Revenue Growth79th percentile

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

$100K$50K$0-$50KRevenue 2014: $02014Revenue 2015: $02015Revenue 2016: $13,895Expenses 2016: $24,643Net Income 2016: -$10,7482016Revenue 2017: $26,590Expenses 2017: $42,939Net Income 2017: -$16,3492017Revenue 2018: $35,510Expenses 2018: $35,925Net Income 2018: -$4152018Revenue 2019: $50,060Expenses 2019: $50,413Net Income 2019: -$3532019Revenue 2020: $18,582Expenses 2020: $23,022Net Income 2020: -$4,4402020Revenue 2021: $14,641Expenses 2021: $2,112Net Income 2021: $12,5292021Revenue 2022: $52,685Expenses 2022: $36,729Net Income 2022: $15,9562022Revenue 2023: $90,894Expenses 2023: $61,815Net Income 2023: $29,0792023Revenue 2024: $9,877Expenses 2024: $19,499Net Income 2024: -$9,6222024

Highlighted filing

2018

Revenue$35,510
Expenses$35,925
Net Income-$415
Open 2018 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2017 to Jun 30, 2018
Signed
May 14, 2019
Return Version
2017v2.2
Gross Receipts
$35,510
Mission and Program Overview

Mission

Turtle mountain community college foundation is a tribally controlled community foundation. Tmccf seeks to assist students in their endeavour to achieve higher eduction.

Program Services

DescriptionGrantsExpenses
TURTLE MOUNTAIN COMMUNITY COLLEGE FOUNDATION (TMCCF) IS A TRIBALLY CONTROLLED FOUNDATION. TMCCF ASSISTS STUDENTS IN OBTAINING FINANCIAL SUPPORT TO PURSUE A HIGHER EDUCATION.$35,925-
Compensation and Service Providers
Top Officer Pay84th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
DR JIM DAVISExecutive Director-$0--
Filing and Contact Details

Filer

Filer Name
Turtle Mountain Community College
EIN
46-1318232
Phone
7014777862
Address
BIA HWY 7, BELCOURT, ND 58316

Signing Officer

Name
Dr Kellie Hall
Title
Interim President
Signed
2019-05-14
Discuss with paid preparer
Yes

Preparer

Firm
Wipfli Llp
Address
614 PARK DRIVE SOUTH, GREAT FALLS, MT 59405
Preparer
Todd Timboe
Phone
4067271798
Supplemental Narrative

Additional Explanations

Other Revenue.1

“MISC. INCOME $29310”

Grants and Similar Amounts Paid In Excess of $5,000.1

“Class of Activity: SCHOLARSHIPS | Cash Amount Given: $17000”

Other Expenses.1001

“Advertising and Promotion $30”

Other Expenses.1002

“Office Expenses $4694”

Other Expenses.1

“OTHER EXPENSES $12030”

Other Assets.1011

“Prepaid Expenses and Deferred Charges - Beginning $0 Prepaid Expenses and Deferred Charges - Ending $209”

Raw XML Appendix144 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/PersonNm0TRACY AZURE
IRS990EZ/BooksInCareOfDetail/PhoneNum07014777862
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0PO BOX 340
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0BELCOURT
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0ND
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd058316
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt026719
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt026095
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt06200
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-415
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form720FiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt026719
IRS990EZ/Form990TotalAssetsGrp/EOYAmt026304
IRS990EZ/FundraisingGrossIncomeAmt00
IRS990EZ/GrantsAndSimilarAmountsPaidAmt017000
IRS990EZ/GrossReceiptsAmt035510
IRS990EZ/GrossReceiptsForPublicUseAmt00
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InitiationFeesAndCapContriAmt00
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt026719
IRS990EZ/NetAssetsOrFundBalancesEOYAmt026304
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt026719
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt026304
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0DR JIM DAVIS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0Executive Dir.
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationFiled990TInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/EOYAmt0209
IRS990EZ/OtherExpensesTotalAmt016754
IRS990EZ/OtherRevenueTotalAmt029310
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0TURTLE MOUNTAIN COMMUNITY COLLEGE FOUNDATION IS A TRIBALLY CONTROLLED COMMUNITY FOUNDATION. TMCCF SEEKS TO ASSIST STUDENTS IN THEIR ENDEAVOUR TO ACHIEVE HIGHER EDUCTION.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0TURTLE MOUNTAIN COMMUNITY COLLEGE FOUNDATION (TMCCF) IS A TRIBALLY CONTROLLED FOUNDATION. TMCCF ASSISTS STUDENTS IN OBTAINING FINANCIAL SUPPORT TO PURSUE A HIGHER EDUCATION.
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt035925
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/RelatedOrgSect527OrgInd0false
IRS990EZ/SalariesOtherCompEmplBnftAmt02171
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt00
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt035925
IRS990EZ/TotalProgramServiceExpensesAmt035925
IRS990EZ/TotalRevenueAmt035510
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/Form990SchASupportingOrgGrp/Contribution35ControlledInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ContributionControllerInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ContributionFamilyInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ControlledDisqualifiedPrsnInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/DisqualifiedPrsnControllIntInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/DisqualifiedPrsnOwnrIntInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ExcessBusinessHoldingsRulesInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ListedByNameGoverningDocInd0true
IRS990ScheduleA/Form990SchASupportingOrgGrp/LoanDisqualifiedPersonInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/OrganizationChangeSuprtOrgInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/PaymentSubstantialContribtrInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SupportedOrgNotOrganizedUSInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SupportedOrgSectionC456Ind0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SupportNonSupportedOrgInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SuprtOrgNoIRSDeterminationInd0false
IRS990ScheduleA/Form990SchAType3FuncIntGrp/ActivitiesEngagedOrgInvlmntInd0false
IRS990ScheduleA/Form990SchAType3FuncIntGrp/ActivitiesFurtherExemptPrpsInd0true
IRS990ScheduleA/Form990SchAType3FuncIntGrp/ActivitiesTestInd0X
IRS990ScheduleA/Form990SchAType3SprtOrgAllGrp/OfficersCloseRelationshipInd0true
IRS990ScheduleA/Form990SchAType3SprtOrgAllGrp/SupportedOrgVoiceInvestmentInd0false
IRS990ScheduleA/Form990SchAType3SprtOrgAllGrp/TimelyProvidedDocumentsInd0true
IRS990ScheduleA/Form990ScheduleAPartVIGrp/ExplanationTxt0THE FOUNDATION WAS ESTABLISHED TO FURTHER THE MISSION OF THE TURTLE MOUNTAIN COMMUNITY COLLEGE AND ITS' STUDENTS.
IRS990ScheduleA/Form990ScheduleAPartVIGrp/FormAndLineReferenceDesc0Part IV, Section E, Line 2a: Identify Supported Orgs. and Explain How Activities Furthered Exempt Pu
IRS990ScheduleA/OtherSupportSumAmt00
IRS990ScheduleA/SupportedOrganizationsCnt01
IRS990ScheduleA/SupportedOrganizationsTotalCnt01
IRS990ScheduleA/SupportedOrgInformationGrp/EIN0450323401
IRS990ScheduleA/SupportedOrgInformationGrp/GoverningDocumentListedInd0false
IRS990ScheduleA/SupportedOrgInformationGrp/OrganizationTypeCd03
IRS990ScheduleA/SupportedOrgInformationGrp/OtherSupportAmt00
IRS990ScheduleA/SupportedOrgInformationGrp/SupportAmt00
IRS990ScheduleA/SupportedOrgInformationGrp/SupportedOrganizationName/BusinessNameLine1Txt0TURTLE MOUNTAIN COMMUNITY COLLEGE
IRS990ScheduleA/SupportingOrganization509a3Ind0X
IRS990ScheduleA/SupportingOrgType3FuncIntInd0X
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0MISC. INCOME $29310
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Class of Activity: SCHOLARSHIPS | Cash Amount Given: $17000
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2Advertising and Promotion $30
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3Office Expenses $4694
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4OTHER EXPENSES $12030
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5Prepaid Expenses and Deferred Charges - Beginning $0 Prepaid Expenses and Deferred Charges - Ending $209
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Other Revenue.1
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Grants and Similar Amounts Paid In Excess of $5,000.1
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Other Expenses.1001
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Other Expenses.1002
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4Other Expenses.1
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5Other Assets.1011
ReturnHeader/BuildTS02019-02-21 02:37:17Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0DR KELLIE HALL
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0INTERIM PRESIDENT
ReturnHeader/BusinessOfficerGrp/SignatureDt02019-05-14
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0TURTLE MOUNTAIN COMMUNITY COLLEGE
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0TURT
ReturnHeader/Filer/EIN0461318232
ReturnHeader/Filer/PhoneNum07014777862
ReturnHeader/Filer/USAddress/AddressLine1Txt0BIA HWY 7
ReturnHeader/Filer/USAddress/CityNm0BELCOURT
ReturnHeader/Filer/USAddress/StateAbbreviationCd0ND
ReturnHeader/Filer/USAddress/ZIPCd058316
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0390758449
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0WIPFLI LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0614 PARK DRIVE SOUTH
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0GREAT FALLS
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MT
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd059405
ReturnHeader/PreparerPersonGrp/PhoneNum04067271798
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0TODD TIMBOE
ReturnHeader/ReturnTs02019-05-14T13:51:03-07:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02017-07-01
ReturnHeader/TaxPeriodEndDt02018-06-30
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$26,304
Liabilities
-
Net assets
$26,304
Revenue
$35,510
Expenses
$35,925
Net income
-$415
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$69.5$0.00$69.5$9.88$19.5$9.62
2023Detailed filing. Detailed filing data is available for this year.$79.4$0.32$79.1$90.9$61.8$29.1
2022Detailed filing. Detailed filing data is available for this year.$50.0$0.00$50.0$52.7$36.7$16.0
2021Detailed filing. Detailed filing data is available for this year.$34.0$0.00$34.0$14.6$2.11$12.5
2020Detailed filing. Detailed filing data is available for this year.$21.5$0.00$21.5$18.6$23.0$4.44
2019Detailed filing. Detailed filing data is available for this year.$26.8$0.89$26.0$50.1$50.4$0.35
2018Detailed filing. Detailed filing data is available for this year.$26.3$26.3$35.5$35.9$0.42
2017Detailed filing. Detailed filing data is available for this year.$26.7$26.7$26.6$42.9$16.3
2016Detailed filing. Detailed filing data is available for this year.$43.1$43.1$13.9$24.6$10.7
2015Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00
2014Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00