please help. need all parts please

In December 2016, the Hamilton County Board of Commissioners established the Hamilton County OPEB Trust Fund. Retired employees of Hamilton County can participate in postemployment benefits through the Trust. The Trust is a single-employer defined benefit plan. The benefits provided are health insurance and life insurance. In December 2016, the County made a one-time contribution to the fund of $16,000,000. No other events took place in 2016. Fiscal year 2017 transactions were as follows: 1. The County paid its actuarially determined annual contribution of S9,200,000. 2. Member (employee) contributions totaled $4,500,000 of this, $4.280,000 was collected by December 31 and the remainder will be collected in January 2018 3. Cash totaling $20,000,000 was invested in U.S. government securities. 4. Interest totaling $1,407,000 was earned on these securities of this amount, S1,385,000 was collected during the year. 5. Because the County offers a drug plan to retired employees, the federal government Medicare program provides a subsidy to the County. The County received $502.000 from this subsidy 6. Benefit claims from employees totaled $11.722.000 for the year. By year-end, 59,575.000 had been paid to employees. 7. Administrative expenses totaled $147.000 (all paid in the current year) Hamilton County operates the Domestic Relations Agency Fund. The fund works with the State Government's Domestic Relations Court, the purpose of which is to establish child support, enforce child support obligations, and locate absent parents to ensure noncustodial parents contribute toward the support of their children. The Domestic Relations Agency Fund is used to account for receipts and disbursements of support payments collected by the County, which are ultimately owed to the State Government's Domestic Relations Court. The County ended the year 2016 with $55.900 of cash. Fiscal year 2017 transactions were as follows: 8. The County collected $408.000 from noncustodial parents. 9. The County remitted S420,900 to the State Government's Domestic Relations Court Required: Page 211 Use the Excel template provided to complete the following requirements: a separate tab is provided in Excel for each of these steps. a. Prepare journal entries to record the information described in items 1 to 9. b. Post these entries to T-accounts. c. Prepare closing journal entries. Post to the T-accoul provided. d. Prepare a Statement of Changes in Fiduciary Net Position for the year ending 2017, e. Prepare a Statement of Fiduciary Net Position as of December 31, 2017 Show transcribed image text In December 2016, the Hamilton County Board of Commissioners established the Hamilton County OPEB Trust Fund. Retired employees of Hamilton County can participate in postemployment benefits through the Trust. The Trust is a single-employer defined benefit plan. The benefits provided are health insurance and life insurance. In December 2016, the County made a one-time contribution to the fund of $16,000,000. No other events took place in 2016. Fiscal year 2017 transactions were as follows: 1. The County paid its actuarially determined annual contribution of S9,200,000. 2. Member (employee) contributions totaled $4,500,000 of this, $4.280,000 was collected by December 31 and the remainder will be collected in January 2018 3. Cash totaling $20,000,000 was invested in U.S. government securities. 4. Interest totaling $1,407,000 was earned on these securities of this amount, S1,385,000 was collected during the year. 5. Because the County offers a drug plan to retired employees, the federal government Medicare program provides a subsidy to the County. The County received $502.000 from this subsidy 6. Benefit claims from employees totaled $11.722.000 for the year. By year-end, 59,575.000 had been paid to employees. 7. Administrative expenses totaled $147.000 (all paid in the current year) Hamilton County operates the Domestic Relations Agency Fund. The fund works with the State Government's Domestic Relations Court, the purpose of which is to establish child support, enforce child support obligations, and locate absent parents to ensure noncustodial parents contribute toward the support of their children. The Domestic Relations Agency Fund is used to account for receipts and disbursements of support payments collected by the County, which are ultimately owed to the State Government's Domestic Relations Court. The County ended the year 2016 with $55.900 of cash. Fiscal year 2017 transactions were as follows: 8. The County collected $408.000 from noncustodial parents. 9. The County remitted S420,900 to the State Government's Domestic Relations Court Required: Page 211 Use the Excel template provided to complete the following requirements: a separate tab is provided in Excel for each of these steps. a. Prepare journal entries to record the information described in items 1 to 9. b. Post these entries to T-accounts. c. Prepare closing journal entries. Post to the T-accoul provided. d. Prepare a Statement of Changes in Fiduciary Net Position for the year ending 2017, e. Prepare a Statement of Fiduciary Net Position as of December 31, 2017 Show transcribed image text