Title: Subrecipients
Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal award activity of the Turtle Mountain College under programs of the federal government for the year ended June 30, 2024. The information in this Schedule is presented in accordance with requirements of the Title 2 U.S. Code of Federal Regulations 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 College, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Turtle Mountain College.
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 - 81.123, Program Name - National Nuclear Security Administration, Amount Providdd to Subrecipients - $ 768,361
Title: Outstanding Federal Loans
Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal award activity of the Turtle Mountain College under programs of the federal government for the year ended June 30, 2024. The information in this Schedule is presented in accordance with requirements of the Title 2 U.S. Code of Federal Regulations 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 College, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Turtle Mountain College.
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, 2024.
Title: BIA Endowment Investment
Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal award activity of the Turtle Mountain College under programs of the federal government for the year ended June 30, 2024. The information in this Schedule is presented in accordance with requirements of the Title 2 U.S. Code of Federal Regulations 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 College, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Turtle Mountain College.
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,050,523 of restricted endowment moneys as of June 30, 2024. 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 ,2023 $ 686,804 $ 360,313 $ 1,047,117
Activity 3,406 3,406
Withdrawals
Balance June 30, 2024 $ 686,804 $ 363,719 $ 1,050,523
Title: Reconciliation of Federal Expenditures
Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal award activity of the Turtle Mountain College under programs of the federal government for the year ended June 30, 2024. The information in this Schedule is presented in accordance with requirements of the Title 2 U.S. Code of Federal Regulations 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 College, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Turtle Mountain College.
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 $23,127,046
Less restricted endowment (686,804)
Expenditures funded by general fund, state and other funding sources 5,246,731
Expenditures per Statement of Revenue, Expenditures, and Changes in Fund Balance $ 27,686,973
Title: Advances from Grantors by AL# for Health and Human Services Funds
Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal award activity of the Turtle Mountain College under programs of the federal government for the year ended June 30, 2024. The information in this Schedule is presented in accordance with requirements of the Title 2 U.S. Code of Federal Regulations 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 College, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Turtle Mountain College.
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 $15,100
93.653 Indian Health Service Domestic Violence Prevention Programs $ 226
Total advances from grantors - HHS funds $ 15,326