a.
33128-9-52P
Prepare the pre-closing
a.
33128-9-52P

Explanation of Solution
The trial balance is a workbook in which the balance of all ledgers is combined into the balances of the debit and credit account that are equal. The pre-closure trial balance includes balances of both temporary and permanent accounts.
The pre-closing trial balance for the General Fund of the City of Iron River is as follows:
Trial Balance | Debit ($) | Credit ($) |
Cash | ||
Receivables: | ||
Real estate and personal property | ||
Intergovernmental | ||
Payables | ||
Deferred revenues | ||
Fund balances: | ||
Assigned | ||
Unassigned | ||
Revenues—real estate taxes | ||
Intergovernmental revenues | ||
Expenditures—General government | ||
Expenditures—Public safety | ||
Expenditures—Education | ||
Expenditures—Public works | ||
Expenditures—Human services | ||
Expenditures—Debt principal payments | ||
Expenditures—Debt interest payments | ||
Other financing sources - proceeds from bonds | ||
Table (1)
b.
Prepare the
b.

Explanation of Solution
The General Fund is the main fund used by a government entity. The fund is used to monitor all capital inflows and outflows that are not affiliated with special purpose funds.
The balance sheet of government funds shows the finances of the government and the money and revenues it uses to provide services such as fire, police and sanitation. Short-term expenses are shown on the balance sheet to be close to those of the Government General Fund.
The balance sheet for the General fund of the City of Iron River is as follows:
CITY OF IRON RIVER | |||
Balance sheet | |||
Assets: | |||
Cash | $26,091 | ||
Receivables: | |||
Real Estate & Personal Property | 2,360 | ||
Intergovernmental | 22,337 | ||
Total Assets | $50,788 | ||
Liabilities: | |||
Payables | $4,011 | ||
Deferred Revenues | 24,570 | ||
Total Liabilities | 28,581 | ||
Fund Balances: | |||
Assigned | 6,480 | ||
Unassigned | 15,727 | ||
Total Fund Balances | $22,207 | ||
Total Liabilities and Fund Balances | $50,788 | ||
The statement of revenues, expenditures and changes in the balances of the funds is the declaration of income of the Government Funds, monitoring the flow of resources in and out.
The Statement of Revenues, Expenditures and Changes in Fund Balances for the General fund of the City of Iron River is as follows:
CITY OF IRON RIVER | |||||
Statement of Revenues, Expenditures and Changes in Fund Balances | |||||
Revenues: | |||||
Real Estate Taxes | $80,930 | ||||
Intergovernmental | $14,742 | ||||
Total revenues | $95,672 | ||||
Expenditures: | |||||
General Government | 15,227 | ||||
Public Safety | 9,181 | ||||
Education | 55,086 | ||||
Public Works | 4,590 | ||||
Human Services | 9,181 | ||||
Debt Principal payments | 700 | ||||
Debt Interest payments | 100 | ||||
Total expenditures | 94,065 | ||||
Excess (Deficiency) of revenues over expenditures | 1,607 | ||||
Other financing sources(uses): | |||||
Proceeds from bonds | 2,000 | ||||
Total Other Financing Sources (Uses) | 2,000 | ||||
Net change in fund balances | $3,607 | ||||
Fund Balance at beginning of the year | 18,600 | ||||
Fund Balance at the end of the year | $22,207 | ||||
Table (1)
Want to see more full solutions like this?
Chapter 9 Solutions
ADVANCED ACCOUNTING
- Financial accountingarrow_forwardI need help with this general accounting question using the proper accounting approach.arrow_forwardEricsson Company has a predetermined overhead rate of 152% of direct labor cost. Estimated overhead for the period was $275,000. The actual cost for direct labor was $194,000 and the actual overhead was $283,000. How much overhead was applied? How much was over-or under-applied overhead?arrow_forward
- Gamma Industries, which applies manufacturing overhead on the basis of machine hours, has provided the following data for its most recent year of operations: Item Amount Estimated Manufacturing Overhead $540,000 Estimated Machine Hours 18,000 Actual Manufacturing Overhead $562,500 19,500 Actual Machine Hours The estimates for manufacturing overhead and machine hours were made at the beginning of the year for the purpose of computing the company's predetermined overhead rate for the year. Calculate the overhead rate for the year.arrow_forwardHow much was over-or under-applied overhead?arrow_forwardNonearrow_forward
- Searching and Splitting Sometimes you need to search for the location of the first occurrence of a character or sub-string within a larger string. A common example is to find the location of the "@" symbol in an email address so you can isolate the username of the address. In cell D12, find the location of the "@" symbol in the email address in cell C12. Search for the location of the text string "@" within an email address: Finally, you can combine SEARCH and LEFT to isolate the username of the email address. SEARCH tells you where the "@" symbol is located and LEFT needs to know how many characters on the left you want to keep; which SEARCH can provide. Try combining SEARCH and LEFT in cell D13 to isolate the email username from cell C13. Note: there is one slight modification you will need to make to the SEARCH part of the formula to get just the username. See if you can figure it out. Split off username from email address. Hint: search for @ symbol:arrow_forwardCan you provide the accurate answer to this financial accounting question using correct methods?arrow_forwardData Table Oftentimes you will receive data that is overly general. Notice in the data table that begins in row 18, daily revenue is provided. However, your analysis calls for monthly and daily aggregation of the revenue data. In columns C and D of the data table, use the techniques you learned above to populate each row with the month and day of the week based on the date in column A. In column E of the data table, note the target dollar value in cell E16. In column E of the data table, create an IF formula that will display TARGET if the revenue in column B is greater than or equal to the target value in E16, or MISS otherwise. Revenue Pivot Table In cell A2 in Pivot worksheet, create a pivot table based on the data table, that aggregates revenue by placing month in the columns and weekdays in the rows. Make sure Vales in the Pivot Table task pane is set to Sum of Revenue. What is the lowest sum of revenue in the pivot table? (Note: Conditional formatting can help!) Lowest revenue…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education





