This activity is to be completed using the background information prov This activity is to be completed using the background information provided under the "Assignments" tab for "Government Activity 3." You will have unlimited access to this activity prior to the due date. Round all answers measured in your Excel spreadsheet to the nearest dollar; answers should be without dollar signs, decimals, or pennies. If your Excel calculation results in $1,500.35, round to 1,500 and insert that number in your answer space, using commas where appropriate (e.g., 1,500). Answer all questions requiring dollar amounts accordingly.
Paper For Above instruction The problem involves analyzing the financial position and activity of the Town of Johnsonville’s Water and Sewer Utility Fund as of September 30, 2015, based on provided balance sheet data, transactions during the fiscal year, and specific billing information. To accurately answer the questions, you will organize this information in an Excel spreadsheet, applying accounting principles relevant to governmental and proprietary funds. First, the background details include initial balances from the fiscal year ending September 30, 2014, such as cash, investments, receivables, property, plant, and equipment, along with accumulated depreciation, liabilities, and net position components. The transactions during the year, such as revenues billed, expenses paid, bond payments, interest accrued, and asset upgrades, need to be recorded systematically. Additionally, billing data from October and November 2015 must be incorporated to determine accrued revenues at year-end. Your spreadsheet should include all relevant journal entries, posted to T-accounts if necessary, and calculations clearly labeled to facilitate transparency. It must be a single sheet with your name and section number at the top. Follow the same order as the questions on the quiz, and clearly cite all sources of data. Equations or formulas used should be visible, and all formatting should adhere to professional standards, emphasizing clarity and accuracy. The questions range from calculating unrestricted and restricted cash and investments, receivables, property, plant, and equipment, liabilities, net position components, revenues, investment income, expenses, and bond-related figures. Carefully interpret initial balances and transactional data to derive accurate responses, applying relevant accounting and financial reporting rules for governmental funds, proprietary funds, and related capital assets.