Question 73102

14 pages
10 downs
217 views

Extension: PDF

Please download to get full document.

View again

of 14
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Share
Description
Hire A Tutor For Your Homework www.helpingtutors.com Alternatevely contact me for it's solution at flat rate of $20 licservernoida@gmail.comI need help finding the…
Transcript
Hire A Tutor For Your Homework www.helpingtutors.com Alternatevely contact me for it's solution at flat rate of $20 licservernoida@gmail.comI need help finding the solutions to the Province of Europa practice set. I have attached the Practice Set pdf and the assignment directions. Project Set Instructions Read the Governmental Accounting Practice Set PDF file containing information on the project. This file and Excel template files for your use are located in the Assignment Instructions for Parts A-1-A, A-1-B, A-2, & B of our myCMU course site. All work is to be completed in these Excel files and uploaded to the associated Assignment for grading. Part A-1-A Requirements: 1. Student completed cover sheet for project with student’s name, course number, date, assignment/project name 2. Student completed journal entries for transactions 1-15 (found on pages 3-6 “Transaction List” of PDF handout/instructions) o General Fund – 8 points o Debt Service Fund– 1 points o Capital Projects Fund– 5 points o General Fixed Assets Group – 2 points o General Long-Term Debt Group – 2 points o Enterprise Fund – 5 points Part A-1-A Points Possible: 23 Part A-1-B Requirements: 1. Student completed cover sheet for project with student’s name, course number, date, assignment/project name 2. Student completed journal entries for transactions 16-29 (found on pages 6-8 “Transaction List” of PDF handout/instructions) o General Fund – 7 points o Debt Service Fund– 2 points o Capital Projects Fund– 0 points o General Fixed Assets Group – 1 points o General Long-Term Debt Group – 1 points o Enterprise Fund – 8 points Part A-1-B Points Possible: 19 Part A-2 Requirements: 1. Student completed cover sheet for project with student’s name, course number, date, assignment/project name 2. (28 points) Student completed Ledgers (t-accounts) reflecting transactions 1-29 (found on pages 3-8 “Transaction List” of PDF handout/instructions) for accounts in the following funds/account groups: o General Fund o Debt Services Fund o Capital Projects Fund o Enterprise Fund o General Fixed Asset Account Group o General Long-Term Debt Account Group 3. (60 points) Student completed Fund-basis financial statements, including a Budget ComparisonStatement for the General Fund. o Statement of Cash Flows – Proprietary Funds o Statement of Net Assets – Proprietary Funds o Statement of Revenues, Expenses & Changes in Fund Net Assets – Proprietary Funds o General Funds Balance Sheet o General Funds Statement of Revenues, Expenditures & Changes in Fund Balance o General Funds Statement of Revenues, Expenditures, & Changes in Fund Balance – Budget and Actual Part A-2 Points Possible: 88 Part B Requirements: 1. Student completed cover sheet for project with student’s name, course number, date, assignment/project name 2. (10 points) Student completed Government-Wide Conversion Worksheet to Convert Fund Basis Information to Accrual Basis that reflects journal entries 1-8 required for Government-wide financial statements as shown on page 9 of PDF handout/instructions. 3. (10 points) Student completed journal entries 1-8, located on page 9 of PDF handout/instructions, necessary to prepare Government-wide Statements effectively converting fund basis statements to accrual basis. 4. (30 points) Student completed government-wide financial statements. o Government-Wide Statement of Activities o Government-Wide Statement of Net Assets Part B Points Possible: 50 Total Project Set Points Possible: 180 Hints for Practice Project Part A-1 Journal Entries (Including Closing Entries) I know this looks intimidating when you try and take it all in at once. Take it a little piece at a time. Your text has very good examples of common journal entries for each fund/group. Check out the glossary under "journal entries" and locate them in your text (they're listed by fund/group.) For instance, discussion/examples of journal entries for general fund start on pages 70 and 90. As noted in the instructions, maintain a separate sheet of entries for each fund and account group: 1. General Fund 2. Debt Service Fund 3. Capital Projects Fund 4. General Fixed Assets Group 5. General Long-Term Debt Group 6. Enterprise Fund Some journal entries will affect more than one fund/account. For instance, transaction #3 will show up on the General Fund and Enterprise Fund sheets. So you can see the format of your submission, below is a template to get you started on the General Fund entries: 1. Beginning Balances:(GF) Cash XXXXX Supplies XXXXX Fund Balance To record opening balances for 2091 (GF) Encumbrances XXXXX XXXXX Budgetary Fund Balance -Reserve for Encumbrances To re-establish outstanding encumbrances from 2090 3. 1/1/91: Memorandum - authorization of the contribution of cash to establish the Bureau of Electricity and Water. 2/1/91: (GF) OFU - Transfer Out to Enterprise Fund Cash To record cash transfer to EF. 4. XXXXX 1/1/91: XXXXX XXXXX (GF) Estimated Revenues XXXXXXXX Appropriations Estm’ OFU Transfers to Other Funds Budgetary Fund Balance To record the budget for 2091. XXXXX XXXXX XXXXX 5. 1/10/91: (GF) Cash XXXXXXX Intergovernmental (Grant) Revenue To record a cash grant from the U.E.C. XXXXXXX GOVERNMENTAL ACCOUNTING PRACTICE SET Introduction The date is December 31, 2091. You have just risen from a three month cryogenic sleep during which you traveled from Earth to Europa, the only inhabited moon of Jupiter. Europa has been colonized since the early 2060's. To encourage development the United Earth Council (roughly equivalent to a federal government for the planet Earth) gave land grants to colonists willing to leave Earth and settle this new world. The Council also built a series of water purification and power generating plants. These plants utilize the natural geothermal resources of Europa to generate electrical power. Most of the inhabitants are engaged in the operation of the quarter million acre farms which span the temperate zones on either side of the equator. The labor is performed by robots through a centralized computer under the direction of the owner/farmer and family members. Harvests are transported by freighter to Earth. It is lonely, although profitable life with an average of 10 harvests per Earth year. All banking is performed on Earth through electronic funds transfers. A substantial business sector has developed, servicing the farming operations. After several decades of hard work the inhabitants of Europa are beginning to enjoy the rewardsof their labors and are seeking some of the services which can only be provided by a local centralized government. They naturally sought to establish this government on Europa and petitioned the United Earth Council for admission to the Council as a member province (roughly equivalent to the 20th century state governments). Province status was granted by a vote of the Council and the citizens of Europa acted quickly to organize their new government, which officially began operations on January 1, 2091. One of the tasks facing the new government was to hire qualified people to carry on the day to day business of the government. You represent one of these people, having been highly trained in the subtleties of governmental accounting. Ownership of public facilities which were constructed by the United Earth Council (Buildings, roads & the electrical power utility) was transferred to the new province as of midnight on 12-31-2090. In return, the Province issued long-term bonds payable which provide for interest and principle payments to the United Earth Council over the next 20 years. Having no qualified governmental accountants on Europa, the province administrator has simply made notes summarizing the transactions which have occurred since the beginning of operations. Your task is to establish a fund accounting system, prepare summary journal entries recording all transactions, and prepare the year end 12-31-2091 financial statements for the Province. 1 Please maintain SEPARATE JOURNAL ENTRY SHEETS for each fund and account group. ** Report: Your completed projects should include (in this order): Part A-1: 1. Cover sheet for project with student’s name, course number, date, assignment/project name 2. Journal entries (including closing entries) for each fund and account group Part A-2: 1. Cover sheet for project with student’s name, course number, date, assignment/project name 2. Ledgers (t-accounts) for each fund and account group 3. Fund-basis financial statements, including a Budget Comparison Statement for the General Fund. Part B: 1. 2. 3. 4. Cover sheet for project with student’s name, course number, date, assignment/project name Government-wide Financial Statements Worksheets for the governmental activities portion of the Government-wide financial statements Journal Entries to convert fund basis statements to accrual basis Check figures: General fund cash: $ 43,250 General fund unassigned fund balance 750 Governmental funds: Total fund balance 1,981,750Enterprise fund cash: 114,500 Enterprise fund net assets: 132,583 A set of financial statement templates (Excel) are available for your use. Please turn in the printed copy of each financial statement after entering the correct amounts. 2 PROVINCE OF EUROPA Transaction list for the year ended December 31, 2091 Account Structure: Because the Province has a limited number of revenue sources, revenue control accounts are not used. Rather, General Fund revenues are directly recorded into the following accounts (property taxes, sales taxes, fees licenses and permits, program fees, and intergovernmental grants) Similarly, expenditures are recorded directly into the following accounts: (general government operations, public safety, education, capital outlay, and debt service: principal and interest). The Province established the Bureau of Electricity and Water to operate as an enterprise fund. The enterprise fund reports expenses by object category using the following account titles: (salaries, supplies, depreciation, and interest). There are no fiduciary, special revenue, permanent, or internal service funds. The government uses account groups to record general fixed assets and general long-term debt. Beginning Balances: 1. At 12-31-2090, the remaining cash and supplies on hand in the government offices were transferred to the new Province government. The opening trial balance for the Province for 1-1-2091 was as follows: GENERAL FUND Trial balance Jan. 1, 2091 Cash Supplies debits 18,000 13,000 31,000 credits Fund Balance: Assigned (Reserved for encumbrances ) Unassigned 11,800 19,200 31,000 The supplies were office supplies for general government operations. The reserve for encumbrances relates to a purchase order placed in December of 2090 for engineering services (see item # 7, below). TheProvince honors outstanding encumbrances from previous years and the encumbrance should be re-established for 2091. For purposes of the Budgetary Comparison Statement, amounts are charged to the budget in the year they are initially encumbered, regardless of when the expenditure is incurred. 3 2. On December 31, 2090, the United Earth Council the fixed assets which have been constructed with Province Council assigned custody of these assets Province government and the Bureau of Electricity follows: Buildings, roads, and other structures Equipment Geothermal Generators Total Government $1,395,000 480,000 0 -----------$1,875,000 ============ (U.E.C.) transferred U.E.C. funds. The to the general and Water as Useful Salvage Bureau Life Value $ 450,000 10 $0 150,000 650,000 -----------$1,250,000 ============ 5 50 0 In return, the Province government issued $1,875,000, 10 percent general obligation serial bonds. Principal payments of $93,750 and interest payments on the bonds are to be paid at the end of each year starting on December 31, 2091. The Bureau issued (at face value) $1,250,000, 10 percent long-term revenue bonds. The bonds call for annual interest payments on January 1 and mature on January 1, 2101. Current Year Transactions: 3. The government of the Europa Province established the Bureau of Electricity and Water. The Bureau of Electricity and Water is in charge of providing the power and water for residents and the Province government. On January 1, 2091, the Province government agreed tocontribute $300,000 for establishment of the Bureau of Electricity and Water, and transferred cash on February 1, 2091. 4. On January 1, 2091, The Province Council approved budgets for 2091 as follows: Budget Items Revenue and other financing sources Property Taxes Sales Taxes Fees, Licenses and Permits Charges for Services (Bureau) Program Fees: Education Intergovernmental grants Transfer from General Fund Proceeds from Bond Issues Expenditures/expenses and other financing uses: General government operations Public Safety Education Operating expenses (Bureau) Capital Outlays Transfers to other funds Province Government (General Fund) Capital Additions Bureau of Electricity and Water $3,775,000 750,000 250,000 $3,250,000 60,000 470,000 $ 250,000 2,500,000 300,000 1,250,000 2,750,000 3,000,000 1,875,000 1,500,000 1,400,000 1,250,000 850,000 4 5. On January 10, 2091, a cash grant of $450,000 was received from the United Earth Council for operation of the Province. The grant provisions stipulate the funds are to be used for general operations of the government. 6. On January 31, 2091, $3,750,000 in property taxes were levied. Ofthis, $187,500 (5% of property taxes) is estimated to be uncollectible. The remaining tax bills are expected to be collected within 60 days following the end of the fiscal year. During 2091, $3,030,000 was collected and $140,000 are identified as uncollectible and written off. 7. On January 5, 2091 the engineering report ordered in December of the previous year (see item 1 above) was received along with an invoice for of $ 11,500. The invoice was immediately paid. The engineering report was for general government operations. 8. During 2091, the Province government placed orders amounting to $940,000 for supplies. All the supplies ordered were received during the year with an invoice price of $935,000 (there are no outstanding encumbrances for supplies). $900,000 was paid during the year. The supplies were distributed by major functions of government as follows: Order placed Invoice prices General Operation $ 390,000 395,000 Public Safety $ 400,000 400,000 Education $ 150,000 140,000 Total $ 940,000 935,000 The government uses the consumption method of recording supplies – (i.e. expenditure is determined by the amount of supplies used – not purchased – during a period). 9. During 2091 the Bureau of Electricity and Water placed orders amounting to $1,200,000 for supplies. The supplies were received with an invoice price of $1,100,000. Of this $1,050,000 was paid before year end. 10. The Province Council approved the construction of a new school building at an estimated cost of $3,000,000. The issuance of $2,700,000 in general obligation long-term bonds was authorized to finance the cost of construction. In addition, the Province government agreed to provide $300,000 for the construction project. 11. On March 31, 2091, the Province government transferred $300,000 to the school building capital project. 5 12. On April 1, 2091, $2,700,000 in 10 percent general obligation long-term bonds were issued for $2,790,000. The premium of $90,000 was reserved for redemption of the bonds while the principal was set aside for construction of the school. The bonds call for annual interest payments on March 31, and mature on April 1, 2111. 13. On June 1, 2091, the school building contract was awarded to the lowest bidder for $2,800,000, including planning and architect's fees. 14. On November 30, 2091, the progress billings of$1,400,000 for the school building were received from the contractor and $ 950,000 was paid on December 31, 2091. The remaining balance is expected to be paid in January, 2092. Liabilities resulting from capital additions are recorded in “Contracts Payable”, (rather than Accounts Payable). 15. The Board of the Bureau of Electricity and Water approved the construction of an office building at an estimated cost of $880,000. 16. On July 1, 2091, the office building contract was signed in the amount of $865,000, including planning and architect's fees. 17. On October 30, 2091, construction was completed and $432,500 was paid on the contract. The remaining 50% will be paid following final inspection on January 15, 2092. Liabilities resulting from capital additions are recorded in “Contracts Payable”, (rather than Accounts Payable) 18. At the end of November, ground transportation units were ordered for the public safety department at an estimated cost of $175,000. The units have not been delivered as of December 31, 2091. 19. During 2091, the Province government received the following cash collections: Sales taxes Permits, fees & licenses Program Fees: Education $ 838,000 312,000 80,000 $1,230,000 6 20. Salaries and wages of $4,150,000 were incurred and paid by the Province government and the Bureau of Electricity and Water during 2091. Salaries and wages are classified by governmental functions as follows: General operation Public safety Education Bureau of Electricity Water Total Incurred & Paid $ 837,000 775,000 725,000 1,813,000 $ 4,150,000 21. During 2091, the Bureau of Electricity and Water billed the Province government and the residents for electricity and water services in the amounts of $920,000 and $2,200,000 respectively. The Bureau estimated that 2% of the gross revenue from the residents will be uncollectible. During 2091, $805,000 and $1,605,000 of the bills sent to the Province government and the residents, respectively, are collected. $38,000 of the bills sent to the residents are identified as uncollectible and written off. The electricity and water services provided to the Province governmentwere charged by government functions as follows: General operation Public safety Education $ 350,000 320,000 250,000 22. $281,250 was removed from general government funds and set aside for payments on outstanding general obligation serial bonds. 23. On December 31, 2091, the Province government made principal payment of $93,750 and annual interest of $187,500 on the general obligation serial bonds. 24. As of December 31, 2091, physical inventories of supplies on hand report the following: General operation Public safety Education Bureau of Electricity Water 7 $ 116,000 0 0 14,000 25. On December 31, 2091, the Bureau of Electricity and Water accrued annual interest on the bonds ($1,250,000) described in item # 2. 26. The Province government and the Bureau of Electricity and Water recorded depreciation for 2091 using the straight-line method. The new office building is estimated to have zero salvage value and 10-year useful life and is depreciated on a monthly basis, beginning with the month it was placed in service. 27. On December 31, 2091 the Bureau of Electricity and Water borrowed $700,000 on a 90 day note payable to cover a temporary cash shortfall. 28. On December 31, 2091, $250,000 was borrowed on a 60 day note payable to cover a temporary cash shortfall in general government operations. 29. For purposes of classifying fund balances in the governmental funds, assume: Supplies are the only nonspendable resource, The outstanding encumbrances in the capital project fund are classified as Committed by contractual obligation, The outstanding encumbrances in the General Fund are classified as Assigned for capital asset acquisitions The residual balances of the debt service and capital projects funds are classified as assigned. 8 Entries required for Government-wide financial statements. A review of the governm
Related Search
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks