Civic Intelligence

Turtle Mountain Community College Foundation

990EZ • Fiscal year 2017 • EIN 46-1318232

Jul 01, 2016 to Jun 30, 2017 • Filed on Jan 23, 2018

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 2017

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2017

Net Margin

8th percentile

-61%

Higher net margin than 8% of similar nonprofits.

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

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.

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

Asset Growth

10th percentile

-38%

Faster asset growth than 10% of similar nonprofits.

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

Revenue Growth

91st percentile

91%

Faster revenue growth than 91% of similar nonprofits.

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

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Down

$26,719

Down $16,349 (-38%) from 2016

Net Assets

Down

$26,719

Down $16,349 (-38%) from 2016

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet Margin8th percentile

Revenue

Up

$26,590

Up $12,695 (+91%) from 2016

Expenses

Up

$42,939

Up $18,296 (+74%) from 2016

Net Income

Down

-$16,349

Down $5,601 (-52%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth10th 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

2017

Assets$26,719
Liabilities-
Net Assets$26,719
Open 2017 Filing

Operations Trend

Revenue Growth91st 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

2017

Revenue$26,590
Expenses$42,939
Net Income-$16,349
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2016 to Jun 30, 2017
Signed
Jan 23, 2018
Return Version
2016v3.0
Gross Receipts
$26,590
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.$22,625-
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 Jim Davis
Title
Executive Director
Signed
2018-01-23
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 $26070”

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

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

Other Expenses.1001

“Advertising and Promotion $1059”

Other Expenses.1002

“Office Expenses $2446”

Other Expenses.1005

“Travel $19”

Other Expenses.1

“OTHER EXPENSES $15837”

Other Expenses.3

“ROUNDING $2”

Other Assets.1006

“Pledges and Grants Receivable - Beginning $5000 Pledges and Grants Receivable - Ending $0”

Raw XML Appendix147 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/BOYAmt038068
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt026719
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt0520
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-16349
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form720FiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt043068
IRS990EZ/Form990TotalAssetsGrp/EOYAmt026719
IRS990EZ/FundraisingGrossIncomeAmt00
IRS990EZ/GrantsAndSimilarAmountsPaidAmt022625
IRS990EZ/GrossReceiptsAmt026590
IRS990EZ/GrossReceiptsForPublicUseAmt00
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InfoInScheduleOPartVInd0X
IRS990EZ/InitiationFeesAndCapContriAmt00
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt043068
IRS990EZ/NetAssetsOrFundBalancesEOYAmt026719
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt043068
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt026719
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/BOYAmt05000
IRS990EZ/OtherExpensesTotalAmt019363
IRS990EZ/OtherRevenueTotalAmt026070
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/PrintingPublicationsPostageAmt0951
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/GrantsAndAllocationsAmt022625
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/RelatedOrgSect527OrgInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt00
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt042939
IRS990EZ/TotalProgramServiceExpensesAmt022625
IRS990EZ/TotalRevenueAmt026590
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/ActivitiesFurtherExemptPrpsInd0false
IRS990ScheduleA/Form990SchAType3FuncIntGrp/AppointElectMajorityOfficerInd0false
IRS990ScheduleA/Form990SchAType3FuncIntGrp/ExerciseDirectionPoliciesInd0false
IRS990ScheduleA/Form990SchAType3SprtOrgAllGrp/OfficersCloseRelationshipInd0true
IRS990ScheduleA/Form990SchAType3SprtOrgAllGrp/SupportedOrgVoiceInvestmentInd0false
IRS990ScheduleA/Form990SchAType3SprtOrgAllGrp/TimelyProvidedDocumentsInd0true
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 $26070
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Class of Activity: SCHOLARSHIPS | Cash Amount Given: $22625
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2Advertising and Promotion $1059
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3Office Expenses $2446
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4Travel $19
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5OTHER EXPENSES $15837
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt6ROUNDING $2
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt7Pledges and Grants Receivable - Beginning $5000 Pledges and Grants Receivable - Ending $0
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.1005
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5Other Expenses.1
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc6Other Expenses.3
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc7Other Assets.1006
ReturnHeader/BuildTS02018-03-14 21:41:22Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0DR JIM DAVIS
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Executive Dir.
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-01-23
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/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/ReturnTs02018-01-23T07:41:39-08:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02016-07-01
ReturnHeader/TaxPeriodEndDt02017-06-30
ReturnHeader/TaxYr02016

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$26,719
Liabilities
-
Net assets
$26,719
Revenue
$26,590
Expenses
$42,939
Net income
-$16,349
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