Hey guys, I seriously need help with this Government Accounting assignment. Attached is the file. Thank you, Mac
Chapter 8 Recording Transactions Affecting a Fiduciary FundAn Investment Trust Fund The city council of the City of Bingham decided in late 2014 to create an investment pool that would put the city's investments under professional management. The pool will be accounted for as an investment trust fund. The name of the fund, when it is established in early 2015, will be the Investment Pool Fund. The initial participants in the Investment Pool Fund will be the city's debt service fund and the Bingham R4 Consolidated School District (CSD). The pool will be accounted for in accordance with GASB standards applicable to fiduciary funds; therefore, the city's debt service fund assets managed by the investment pool will not be reported in the Investment Pool Fund financial statements. Unless there is a request for a withdrawal, investment earnings and changes in the fair value of investments are distributed to participants only at year-end. During the year, investment earnings are added to an Undistributed Earnings on Pooled Investments account and changes in fair value are added to or subtracted from an Undistributed Change in Fair Value of Investments Account. a. Record the following transactions that occurred during 2015 in the Investment Pool Fund. Do not forget to click on [Year] to change the date to 2015. 1. [Para. 8-a-1] On March 1, 2015, the Investment Pool Fund was formally established with the receipt of $190,000 in cash from the city's own debt service fund, plus receipt from the Bingham CSD of bonds having a market value of $605,000 on this date. The bonds purchased by the Bingham CSD had a book value of $600,000 on March 1, 2015. The bonds receive semi-annual interest of 5 percent per annum, on July 1 and January 1 each year. The CSD's equity is to also be credited for $5,000, which represents the two months of interest receivable on the bonds for January and February 2015. 2. [Para. 8-a-2] The Investment Pool Fund manager purchased 4 percent bonds on March 1 in the amount of $150,000. Because the bonds pay interest semi-annually on January 1 and July 1, $1,000 in accrued interest was also paid. (Note: Interest Receivable on Investments should be debited for the accrued interest.) 3. [Para. 8-a-3] On March 1, the Investment Pool Fund manager also purchased a 9month certificate of deposit (CD) for $30,000. The interest rate on the CD is 1 percent per annum. 4. [Para. 8-a-4] On July 1, interest on the bonds in the amount of $18,000 ($15,000 and $3,000) was received in cash. (Note: Adjust for accrued interest.) 5. [Para. 8-a-5] On November 30, the 9-month CD matured and interest was received. 6. [Para. 8-a-6] On December 31, interest was accrued on bond investments. 7. [Para. 8-a-7]. On December 31, the fair value of investments in bonds was $760,000. (Note: Credit Undistributed Change in Fair Value of Investments for the increase in fair value.) 8. [Para. 8-a-8]. On December 31, the proportionate equities of the city's debt service fund and the Bingham CSD were calculated and investment earnings and changes in fair value of investments were distributed accordingly. In the journal entries round all calculations to the nearest whole dollar. (Note: You should complete 8-c below prior to making this journal entry.) 9. [Para. 8-a-9]. Subsequent to the distribution of earnings and changes in fair value, the Bingham CSD withdrew $100,000 to meet certain obligations coming due. To provide the cash needed for the withdrawal, the Investment Pool Fund manager sold 5 percent bonds on December 31 for $100,000, plus interest of $2,500, receiving in total $102,500 from the sale. (Note: Adjust Interest Receivable on Investments for the interest received.) City of Bingham Investment Trust Fund Pre-Closing Trial Balance For year 2015 Account Cash InvestmentBonds Interest Receivable on Investments Due to Debt Service Fund AdditionsDeposits in Pooled Investments AdditionsInvestment Earnings AdditionsChange in Fair Value of Investments DeductionsWithdrawal by Depositors Totals for all accounts Debits Credits $59,725 660,000 15,500 $198,366 610,000 23,047 3812 $100,000 $835,225 $835,225 City of Bingham Investment Trust Fund Post-Closing Trial Balance For year 2015 Account Cash InvestmentBonds Interest Receivable on Investments Due to Debt Service Fund Net Position Held in Trust for Depositors Totals for all accounts Debits Credits $59,725 660,000 15,500 $735,225 $198,366 536,859 $735,225 City of Bingham Investment Pool Statement of Fiduciary Net Position As of December 31, 2015 Assets Cash InvestmentBonds Interest Receivable on Investments Total Assets Net Position Held in trust for depositors $43,611 481,930 11,318 536,859 $536,859 City of Bingham Calculation of Equities As of December 31, 2015 (Before withdrawal by Bingham CSD) Equities at creation of fund Percentage Interest Distribution of Investment earnings Distribution of change in fair value Total Earnings and Change in Fair Value Total Equities Percentage Interest Debt Service Fund $190,000 23.75% Bingham CSD $610,000 76.25% Total $800,000 100.00% 7,178.44 1,187.50 8,366 $198,366 23.75% 23,046.56 3,812.50 26,859 $636,859 76.25% 30,225 5,000 35,225 $835,225 100.00%
