COMERICA BANK & TRUST, NATIONAL ASSOCIATION has sponsored the creation of one or more 401k plans.
Submission information for form 5500 for 401k plan SDA INTERNATIONAL EQUITY INDEX FUND
| Measure | Date | Value |
|---|
| 2017 : SDA INTERNATIONAL EQUITY INDEX FUND 2017 401k financial data |
|---|
| Unrealized appreciation/depreciation of other (non real estate) assets | 2017-12-31 | $66,127,308 |
| Total unrealized appreciation/depreciation of assets | 2017-12-31 | $66,127,308 |
| Total transfer of assets to this plan | 2017-12-31 | $186,174,845 |
| Total transfer of assets from this plan | 2017-12-31 | $160,815,641 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2017-12-31 | $1,523,375 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2017-12-31 | $1,492,031 |
| Total income from all sources (including contributions) | 2017-12-31 | $77,008,838 |
| Total loss/gain on sale of assets | 2017-12-31 | $1,447,919 |
| Total of all expenses incurred | 2017-12-31 | $1,018,061 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2017-12-31 | $0 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2017-12-31 | $0 |
| Value of total assets at end of year | 2017-12-31 | $400,007,881 |
| Value of total assets at beginning of year | 2017-12-31 | $298,626,556 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2017-12-31 | $1,018,061 |
| Total interest from all sources | 2017-12-31 | $0 |
| Total dividends received (eg from common stock, registered investment company shares) | 2017-12-31 | $9,353,503 |
| Administrative expenses professional fees incurred | 2017-12-31 | $601,860 |
| Assets. Other investments not covered elsewhere at end of year | 2017-12-31 | $384,890,729 |
| Assets. Other investments not covered elsewhere at beginning of year | 2017-12-31 | $278,244,466 |
| Value of other receiveables (less allowance for doubtful accounts) at end of year | 2017-12-31 | $342,978 |
| Value of other receiveables (less allowance for doubtful accounts) at beginning of year | 2017-12-31 | $267,836 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at end of year | 2017-12-31 | $1,523,375 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at beginning of year | 2017-12-31 | $1,492,031 |
| Other income not declared elsewhere | 2017-12-31 | $69,005 |
| Administrative expenses (other) incurred | 2017-12-31 | $416,201 |
| Value of net income/loss | 2017-12-31 | $75,990,777 |
| Value of net assets at end of year (total assets less liabilities) | 2017-12-31 | $398,484,506 |
| Value of net assets at beginning of year (total assets less liabilities) | 2017-12-31 | $297,134,525 |
| Value of interest in common/collective trusts at end of year | 2017-12-31 | $1,809,760 |
| Value of interest in common/collective trusts at beginning of year | 2017-12-31 | $1,699,769 |
| Net investment gain or loss from common/collective trusts | 2017-12-31 | $11,103 |
| Income. Dividends from common stock | 2017-12-31 | $9,353,503 |
| Assets. Corporate common stocks other than exployer securities at end of year | 2017-12-31 | $12,964,414 |
| Assets. Corporate common stocks other than exployer securities at beginning of year | 2017-12-31 | $18,414,485 |
| Aggregate proceeds on sale of assets | 2017-12-31 | $60,431,827 |
| Aggregate carrying amount (costs) on sale of assets | 2017-12-31 | $58,983,908 |
| 2016 : SDA INTERNATIONAL EQUITY INDEX FUND 2016 401k financial data |
|---|
| Unrealized appreciation/depreciation of other (non real estate) assets | 2016-12-31 | $-1,506,140 |
| Total unrealized appreciation/depreciation of assets | 2016-12-31 | $-1,506,140 |
| Total transfer of assets to this plan | 2016-12-31 | $87,456,930 |
| Total transfer of assets from this plan | 2016-12-31 | $71,022,284 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2016-12-31 | $1,492,031 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2016-12-31 | $494,063 |
| Total income from all sources (including contributions) | 2016-12-31 | $2,462,034 |
| Total loss/gain on sale of assets | 2016-12-31 | $-3,721,449 |
| Total of all expenses incurred | 2016-12-31 | $928,166 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2016-12-31 | $0 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2016-12-31 | $0 |
| Value of total assets at end of year | 2016-12-31 | $298,626,556 |
| Value of total assets at beginning of year | 2016-12-31 | $279,660,074 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2016-12-31 | $928,166 |
| Total interest from all sources | 2016-12-31 | $0 |
| Total dividends received (eg from common stock, registered investment company shares) | 2016-12-31 | $7,688,877 |
| Administrative expenses professional fees incurred | 2016-12-31 | $470,552 |
| Assets. Other investments not covered elsewhere at end of year | 2016-12-31 | $278,244,466 |
| Assets. Other investments not covered elsewhere at beginning of year | 2016-12-31 | $265,945,459 |
| Value of other receiveables (less allowance for doubtful accounts) at end of year | 2016-12-31 | $267,836 |
| Value of other receiveables (less allowance for doubtful accounts) at beginning of year | 2016-12-31 | $265,787 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at end of year | 2016-12-31 | $1,492,031 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at beginning of year | 2016-12-31 | $494,063 |
| Other income not declared elsewhere | 2016-12-31 | $-4,572 |
| Administrative expenses (other) incurred | 2016-12-31 | $457,614 |
| Value of net income/loss | 2016-12-31 | $1,533,868 |
| Value of net assets at end of year (total assets less liabilities) | 2016-12-31 | $297,134,525 |
| Value of net assets at beginning of year (total assets less liabilities) | 2016-12-31 | $279,166,011 |
| Value of interest in common/collective trusts at end of year | 2016-12-31 | $1,699,769 |
| Value of interest in common/collective trusts at beginning of year | 2016-12-31 | $0 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at end of year | 2016-12-31 | $0 |
| Interest-bearing cash (include money market accounts & certificates of deposit) at beginning of the Year | 2016-12-31 | $424,364 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at beginning of year | 2016-12-31 | $424,364 |
| Net investment gain or loss from common/collective trusts | 2016-12-31 | $5,318 |
| Income. Dividends from common stock | 2016-12-31 | $7,688,877 |
| Assets. Corporate common stocks other than exployer securities at end of year | 2016-12-31 | $18,414,485 |
| Assets. Corporate common stocks other than exployer securities at beginning of year | 2016-12-31 | $13,024,464 |
| Aggregate proceeds on sale of assets | 2016-12-31 | $70,909,623 |
| Aggregate carrying amount (costs) on sale of assets | 2016-12-31 | $74,631,072 |
| 2015 : SDA INTERNATIONAL EQUITY INDEX FUND 2015 401k financial data |
|---|
| Unrealized appreciation/depreciation of other (non real estate) assets | 2015-12-31 | $-84,776 |
| Total unrealized appreciation/depreciation of assets | 2015-12-31 | $-84,776 |
| Total transfer of assets to this plan | 2015-12-31 | $95,940,714 |
| Total transfer of assets from this plan | 2015-12-31 | $95,265,687 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2015-12-31 | $494,063 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2015-12-31 | $3,084,134 |
| Total income from all sources (including contributions) | 2015-12-31 | $-2,766,509 |
| Total loss/gain on sale of assets | 2015-12-31 | $-11,048,867 |
| Total of all expenses incurred | 2015-12-31 | $1,150,975 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2015-12-31 | $0 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2015-12-31 | $0 |
| Value of total assets at end of year | 2015-12-31 | $279,660,074 |
| Value of total assets at beginning of year | 2015-12-31 | $285,492,602 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2015-12-31 | $1,150,975 |
| Total interest from all sources | 2015-12-31 | $138,058 |
| Total dividends received (eg from common stock, registered investment company shares) | 2015-12-31 | $8,283,478 |
| Administrative expenses professional fees incurred | 2015-12-31 | $633,655 |
| Assets. Other investments not covered elsewhere at end of year | 2015-12-31 | $265,945,459 |
| Assets. Other investments not covered elsewhere at beginning of year | 2015-12-31 | $279,998,403 |
| Value of other receiveables (less allowance for doubtful accounts) at end of year | 2015-12-31 | $265,787 |
| Value of other receiveables (less allowance for doubtful accounts) at beginning of year | 2015-12-31 | $236,202 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at end of year | 2015-12-31 | $494,063 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at beginning of year | 2015-12-31 | $3,084,134 |
| Other income not declared elsewhere | 2015-12-31 | $-54,402 |
| Administrative expenses (other) incurred | 2015-12-31 | $517,320 |
| Value of net income/loss | 2015-12-31 | $-3,917,484 |
| Value of net assets at end of year (total assets less liabilities) | 2015-12-31 | $279,166,011 |
| Value of net assets at beginning of year (total assets less liabilities) | 2015-12-31 | $282,408,468 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at end of year | 2015-12-31 | $424,364 |
| Interest-bearing cash (include money market accounts & certificates of deposit) at beginning of the Year | 2015-12-31 | $3,206,776 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at beginning of year | 2015-12-31 | $3,206,776 |
| Interest earned from interest bearing cash (including money market accounts and certificates of deposit) | 2015-12-31 | $138,058 |
| Income. Dividends from common stock | 2015-12-31 | $8,283,478 |
| Assets. Corporate common stocks other than exployer securities at end of year | 2015-12-31 | $13,024,464 |
| Assets. Corporate common stocks other than exployer securities at beginning of year | 2015-12-31 | $2,051,221 |
| Aggregate proceeds on sale of assets | 2015-12-31 | $237,454,816 |
| Aggregate carrying amount (costs) on sale of assets | 2015-12-31 | $248,503,683 |
| 2014 : SDA INTERNATIONAL EQUITY INDEX FUND 2014 401k financial data |
|---|
| Unrealized appreciation/depreciation of other (non real estate) assets | 2014-12-31 | $-24,256,321 |
| Total unrealized appreciation/depreciation of assets | 2014-12-31 | $-24,256,321 |
| Total transfer of assets to this plan | 2014-12-31 | $76,906,945 |
| Total transfer of assets from this plan | 2014-12-31 | $43,645,751 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2014-12-31 | $3,084,134 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2014-12-31 | $292,102 |
| Total income from all sources (including contributions) | 2014-12-31 | $-14,947,354 |
| Total loss/gain on sale of assets | 2014-12-31 | $497,968 |
| Total of all expenses incurred | 2014-12-31 | $1,012,821 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2014-12-31 | $0 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2014-12-31 | $0 |
| Value of total assets at end of year | 2014-12-31 | $285,492,602 |
| Value of total assets at beginning of year | 2014-12-31 | $265,399,551 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2014-12-31 | $1,012,821 |
| Total interest from all sources | 2014-12-31 | $145,206 |
| Total dividends received (eg from common stock, registered investment company shares) | 2014-12-31 | $8,731,391 |
| Administrative expenses professional fees incurred | 2014-12-31 | $587,049 |
| Assets. Other investments not covered elsewhere at end of year | 2014-12-31 | $279,998,403 |
| Assets. Other investments not covered elsewhere at beginning of year | 2014-12-31 | $262,525,396 |
| Value of other receiveables (less allowance for doubtful accounts) at end of year | 2014-12-31 | $236,202 |
| Value of other receiveables (less allowance for doubtful accounts) at beginning of year | 2014-12-31 | $299,665 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at end of year | 2014-12-31 | $3,084,134 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at beginning of year | 2014-12-31 | $292,102 |
| Other income not declared elsewhere | 2014-12-31 | $-65,598 |
| Administrative expenses (other) incurred | 2014-12-31 | $425,772 |
| Value of net income/loss | 2014-12-31 | $-15,960,175 |
| Value of net assets at end of year (total assets less liabilities) | 2014-12-31 | $282,408,468 |
| Value of net assets at beginning of year (total assets less liabilities) | 2014-12-31 | $265,107,449 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at end of year | 2014-12-31 | $3,206,776 |
| Interest-bearing cash (include money market accounts & certificates of deposit) at beginning of the Year | 2014-12-31 | $602,658 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at beginning of year | 2014-12-31 | $602,658 |
| Interest earned from interest bearing cash (including money market accounts and certificates of deposit) | 2014-12-31 | $145,206 |
| Income. Dividends from common stock | 2014-12-31 | $8,731,391 |
| Assets. Corporate common stocks other than exployer securities at end of year | 2014-12-31 | $2,051,221 |
| Assets. Corporate common stocks other than exployer securities at beginning of year | 2014-12-31 | $1,971,832 |
| Aggregate proceeds on sale of assets | 2014-12-31 | $174,179,041 |
| Aggregate carrying amount (costs) on sale of assets | 2014-12-31 | $173,681,073 |
| 2013 : SDA INTERNATIONAL EQUITY INDEX FUND 2013 401k financial data |
|---|
| Unrealized appreciation/depreciation of other (non real estate) assets | 2013-12-31 | $43,716,074 |
| Total unrealized appreciation/depreciation of assets | 2013-12-31 | $43,716,074 |
| Total transfer of assets to this plan | 2013-12-31 | $45,299,431 |
| Total transfer of assets from this plan | 2013-12-31 | $45,634,623 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2013-12-31 | $292,102 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2013-12-31 | $2,110,318 |
| Total income from all sources (including contributions) | 2013-12-31 | $50,536,272 |
| Total loss/gain on sale of assets | 2013-12-31 | $-281,887 |
| Total of all expenses incurred | 2013-12-31 | $847,677 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2013-12-31 | $0 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2013-12-31 | $0 |
| Value of total assets at end of year | 2013-12-31 | $265,399,551 |
| Value of total assets at beginning of year | 2013-12-31 | $217,864,364 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2013-12-31 | $847,677 |
| Total interest from all sources | 2013-12-31 | $2,912 |
| Total dividends received (eg from common stock, registered investment company shares) | 2013-12-31 | $7,136,271 |
| Administrative expenses professional fees incurred | 2013-12-31 | $516,933 |
| Assets. Other investments not covered elsewhere at end of year | 2013-12-31 | $262,525,396 |
| Assets. Other investments not covered elsewhere at beginning of year | 2013-12-31 | $209,511,324 |
| Value of other receiveables (less allowance for doubtful accounts) at end of year | 2013-12-31 | $299,665 |
| Value of other receiveables (less allowance for doubtful accounts) at beginning of year | 2013-12-31 | $295,952 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at end of year | 2013-12-31 | $292,102 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at beginning of year | 2013-12-31 | $2,110,318 |
| Other income not declared elsewhere | 2013-12-31 | $-37,098 |
| Administrative expenses (other) incurred | 2013-12-31 | $330,744 |
| Total non interest bearing cash at end of year | 2013-12-31 | $0 |
| Total non interest bearing cash at beginning of year | 2013-12-31 | $22 |
| Value of net income/loss | 2013-12-31 | $49,688,595 |
| Value of net assets at end of year (total assets less liabilities) | 2013-12-31 | $265,107,449 |
| Value of net assets at beginning of year (total assets less liabilities) | 2013-12-31 | $215,754,046 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at end of year | 2013-12-31 | $602,658 |
| Interest-bearing cash (include money market accounts & certificates of deposit) at beginning of the Year | 2013-12-31 | $0 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at beginning of year | 2013-12-31 | $0 |
| Interest earned from interest bearing cash (including money market accounts and certificates of deposit) | 2013-12-31 | $2,912 |
| Income. Dividends from common stock | 2013-12-31 | $7,136,271 |
| Assets. Corporate common stocks other than exployer securities at end of year | 2013-12-31 | $1,971,832 |
| Assets. Corporate common stocks other than exployer securities at beginning of year | 2013-12-31 | $8,057,066 |
| Aggregate proceeds on sale of assets | 2013-12-31 | $86,640,695 |
| Aggregate carrying amount (costs) on sale of assets | 2013-12-31 | $86,922,582 |
| 2012 : SDA INTERNATIONAL EQUITY INDEX FUND 2012 401k financial data |
|---|
| Unrealized appreciation/depreciation of other (non real estate) assets | 2012-12-31 | $24,565,313 |
| Total unrealized appreciation/depreciation of assets | 2012-12-31 | $24,565,313 |
| Total transfer of assets to this plan | 2012-12-31 | $50,364,538 |
| Total transfer of assets from this plan | 2012-12-31 | $21,869,320 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2012-12-31 | $2,110,318 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2012-12-31 | $3,758,121 |
| Total income from all sources (including contributions) | 2012-12-31 | $29,367,183 |
| Total loss/gain on sale of assets | 2012-12-31 | $-1,198,545 |
| Total of all expenses incurred | 2012-12-31 | $628,414 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2012-12-31 | $0 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2012-12-31 | $0 |
| Value of total assets at end of year | 2012-12-31 | $217,864,364 |
| Value of total assets at beginning of year | 2012-12-31 | $162,278,180 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2012-12-31 | $628,414 |
| Total interest from all sources | 2012-12-31 | $674 |
| Total dividends received (eg from common stock, registered investment company shares) | 2012-12-31 | $167,897 |
| Administrative expenses professional fees incurred | 2012-12-31 | $404,187 |
| Assets. Other investments not covered elsewhere at end of year | 2012-12-31 | $209,511,324 |
| Assets. Other investments not covered elsewhere at beginning of year | 2012-12-31 | $153,999,484 |
| Value of other receiveables (less allowance for doubtful accounts) at end of year | 2012-12-31 | $295,952 |
| Value of other receiveables (less allowance for doubtful accounts) at beginning of year | 2012-12-31 | $458,683 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at end of year | 2012-12-31 | $2,110,318 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at beginning of year | 2012-12-31 | $3,758,121 |
| Other income not declared elsewhere | 2012-12-31 | $5,831,844 |
| Administrative expenses (other) incurred | 2012-12-31 | $224,227 |
| Total non interest bearing cash at end of year | 2012-12-31 | $22 |
| Total non interest bearing cash at beginning of year | 2012-12-31 | $0 |
| Value of net income/loss | 2012-12-31 | $28,738,769 |
| Value of net assets at end of year (total assets less liabilities) | 2012-12-31 | $215,754,046 |
| Value of net assets at beginning of year (total assets less liabilities) | 2012-12-31 | $158,520,059 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at end of year | 2012-12-31 | $0 |
| Interest-bearing cash (include money market accounts & certificates of deposit) at beginning of the Year | 2012-12-31 | $3,602,335 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at beginning of year | 2012-12-31 | $3,602,335 |
| Interest earned from interest bearing cash (including money market accounts and certificates of deposit) | 2012-12-31 | $674 |
| Income. Dividends from common stock | 2012-12-31 | $167,897 |
| Assets. Corporate common stocks other than exployer securities at end of year | 2012-12-31 | $8,057,066 |
| Assets. Corporate common stocks other than exployer securities at beginning of year | 2012-12-31 | $4,217,678 |
| Aggregate proceeds on sale of assets | 2012-12-31 | $112,288,361 |
| Aggregate carrying amount (costs) on sale of assets | 2012-12-31 | $113,486,906 |
