Excel-Based Problems 6-13 Jefferson County operates a centralized motor pool to service county vehicles. At the end of 2016, the Motor Pool Internal Service Fund had the following account balances Debits Credits Due from General Fund Cash Capital assets Supplies inventory Accounts pavable Accrued wages payable Accumulated depreciation Advance from enterprise fund Net position $6,500 18.000 35,000 4,000 $5,500 300 6,500 25,000 26.200 $63,500 $63,500 Total The following events took place during 2017: 1. Additional supplies were purchased on account in the amount of $38,000. 2. Services provided to other departments on account totaled $98,ooo. A total of $68,ooo was for departments in the General Fund and $30,0oo for enterprise fund departments The following events took place during 2017 1. Additional supplies were purchased on account in the amount of $38,0oo. 2. Services provided to other departments on account totaled $98,000. A total of $68,ooo was for departments in the General Fund and $30,000 for enterprise fund departments. 3. Supplies used amounted to $36,70o. 4. Payments made on accounts payable amounted to $38,800. 5. Cash collected from the General Fund totaled $62,000, and cash collected from the enterprise fund totaled $30,000 6. Salaries were paid in the amount of $48,700. Included in this amount is the accrued wages payable at the end of 2016. All of these are determined to be part of the cost of services provided. 7. In a previous year, the enterprise fund loaned the motor pool money under an advance for the purpose of purchasing garage equipment. In the current year, the motor pool repaid the enterprise fund $8,000 of this amount. 8. On July 1, 2017, the Motor Pool Fund borrowed $12,0oo from the bank, signing a 12 percent note that is due in two years with annual interest payments on June 30. The borrowings are not related to capital asset purchases but were made to provide working capital. Additional information includes 9. Depreciation for the year amounted to $6,900. 10. The payment of interest on the note is payable on June 30, 2018 11. Unpaid wages relating to the final week of the year totaled $770 Using the Excel template provided (a separate tab is provided for each of the requirements): a. Prepare journal entries and post entries to the T-accounts b. Prepare closing entries. c. Prepare a Statement of Revenues, Expenses, and Changes in Fund Net Position. d. Prepare a Statement of Net Position. e. Prepare a Statement of Cash Flows for the year. Page 17