Title: Basis of Presentation
Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such
expenditures are recognized following the cost principles contained in the Uniform Guidance wherein certain
types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the
Schedule represent adjustments or credits made in the normal course of business to amounts reported as
expenditures in prior years. Pass-through entity identifying numbers are presented where available.
De Minimis Rate Used: N
Rate Explanation: Turtle Mountain Community College has not elected to use the 10-percent de minimis indirect cost rate as
allowed under the Uniform Guidance.
The accompanying schedule of expenditures of federal awards (the "Schedule") includes the federal grant
activity of the Turtle Mountain Community College under programs of the federal government for the year
ended June 30, 2023. The information in this schedule is presented in accordance with the requirements of Title
2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and
Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected
portion of the operations of the Turtle Mountain Community College, it is not intended to and does not present
the financial position, changes in net position, or cash flows of the Turtle Mountain Community College.
Title: Subrecipients
Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such
expenditures are recognized following the cost principles contained in the Uniform Guidance wherein certain
types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the
Schedule represent adjustments or credits made in the normal course of business to amounts reported as
expenditures in prior years. Pass-through entity identifying numbers are presented where available.
De Minimis Rate Used: N
Rate Explanation: Turtle Mountain Community College has not elected to use the 10-percent de minimis indirect cost rate as
allowed under the Uniform Guidance.
Of the federal expenditures presented in the schedule, the College provided federal awards to subrecipients as
follows:
AL Number Program Name
Amount Provided
to Subrecipients
81.123 National Nuclear Security Administration $ 749,134
Title: Outstanding Federal Loans
Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such
expenditures are recognized following the cost principles contained in the Uniform Guidance wherein certain
types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the
Schedule represent adjustments or credits made in the normal course of business to amounts reported as
expenditures in prior years. Pass-through entity identifying numbers are presented where available.
De Minimis Rate Used: N
Rate Explanation: Turtle Mountain Community College has not elected to use the 10-percent de minimis indirect cost rate as
allowed under the Uniform Guidance.
The College has no federal loan obligations as of June 30, 2023.
Title: BIA Endowment Investment
Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such
expenditures are recognized following the cost principles contained in the Uniform Guidance wherein certain
types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the
Schedule represent adjustments or credits made in the normal course of business to amounts reported as
expenditures in prior years. Pass-through entity identifying numbers are presented where available.
De Minimis Rate Used: N
Rate Explanation: Turtle Mountain Community College has not elected to use the 10-percent de minimis indirect cost rate as
allowed under the Uniform Guidance.
The College has $1,047,117 of restricted endowment moneys as of June 30, 2023. 2 CFR Part 200.502(e) states
the cumulative balance of Federal awards for endowment funds that are federally restricted are considered
Federal awards expended in each audit period in which the funds are still restricted, thusly $686,804 is
considered expended and is shown on the schedule of expenditures of federal awards under AL #15.028. Note
that the College has its own endowments so this amount will not agree to the amount reported on the
Statement of Net Position.Federal Share Match Share Total
Balance July 1 ,2022 $ 686,804 $ 356,907 $ 1,043,711
Activity 3,406 3,406
Withdrawals
Balance June 30, 2023 $ 686,804 $ 360,313 $ 1,047,117
Title: Reconciliation of Federal Expenditures
Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such
expenditures are recognized following the cost principles contained in the Uniform Guidance wherein certain
types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the
Schedule represent adjustments or credits made in the normal course of business to amounts reported as
expenditures in prior years. Pass-through entity identifying numbers are presented where available.
De Minimis Rate Used: N
Rate Explanation: Turtle Mountain Community College has not elected to use the 10-percent de minimis indirect cost rate as
allowed under the Uniform Guidance.
The following is a reconciliation of the expenditures reported on the College's schedule of expenditures of
federal awards to expenditures reported in the College's statement of revenues, expenditures, and changes in
fund balance.
Expenditures per Schedule of Expenditures of Federal Awards $ 27,242,212
Less restricted endowment (686,804)
Expenditures funded by general fund, state and other funding sources 4,755,325
Expenditures per Statement of Revenue, Expenditures, and Changes in Fund Balance $ 31,310,733
Title: Advances from Grantors by AL# for Health and Human Services Funds
Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such
expenditures are recognized following the cost principles contained in the Uniform Guidance wherein certain
types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the
Schedule represent adjustments or credits made in the normal course of business to amounts reported as
expenditures in prior years. Pass-through entity identifying numbers are presented where available.
De Minimis Rate Used: N
Rate Explanation: Turtle Mountain Community College has not elected to use the 10-percent de minimis indirect cost rate as
allowed under the Uniform Guidance.
AL #
Direct
Program Name Amount
93.959 Block Grants for Prevention and Treatment of Substance Abuse $ 19,960
93.653 Indian Health Service Domestic Violence Prevention Programs $ 226
Total advances from grantors - HHS funds $ 20,186