What is the amount of unrestricted cash and investments at 9/30/15?
What is the amount restricted Cash and Investments at 9/30/15?
What is the amount of Accounts Receivable – Customers at 9/30/15?
What is the amount of Accrued Interest Receivable at 9/30/15?
What is the total amount of Property, Plant, and Equipment at 9/30/15?
What is the net book value of Property, Plant, and Equipment at 9/30/15?
What is the total amount of Accounts Payable and accrued expenses at 9/30/15?
What is the total amount of Net Position at 9/30/15?
What is the amount of Net Investment in Capital Assets at 9/30/15?
What is the amount of Restricted Net Position at 9/30/15?
What is the amount of Unrestricted Net Position at 9/30/15?
What was the amount of Water & Sewer Revenues for the year ending 9/30/15?
What is the total amount of Investment Income for the year ending 9/30/15?
What is the amount of cash that was paid for expenses for the year ending 9/30/15?
What is the total amount of expenses excluding depreciation for the year ending 9/30/15?
What is the total amount of expenses including depreciation for the year ending 9/30/15?
What is the amount of total Net Position for the Governmental Activities at 9/30/15?
ACG 3501 – Fall 2013 Government Activity – Part Three Instructions Use an Excel spreadsheet to organize the background information provided here in such a manner as to allow you to answer the questions noted under the “Quizzes” tab for “Government Activity 3”. You may find it helpful to actually prepare journal entries and post them to T accounts. Please clearly label all rows and columns in your spreadsheet and show all calculations. Remember, your formulas in a cell may not always be visible when uploaded; therefore, please show all work using the rows and columns approach. Your work will be completed a lot more efficiently if you thoroughly review the questions you are required to answer before attempting to set up your Excel spreadsheet. Submission of your Excel spreadsheet is a required part of this assignment and is worth 15 points. The remaining 60 points for this assignment are related to the questions (located under the “Quizzes” tab) that you will need to answer using the background information provided here. In order to receive the total 15 points for your spreadsheet, you will need to attach it and then submit it via the “Assignments” tab in Webcourses. Guidelines for the preparation of your Excel spreadsheet are as follows: ? Use only one “sheet” for your work. ? Your name and ACG 3501 section number should appear at the top of the spreadsheet. ? Order your spreadsheet in the same order as the questions are asked in the “quiz”. Indicate the question number(s) from the “quiz” on your spreadsheet next to the related work. ? Clearly label all columns and rows and show ALL of your work. Please avoid using abbreviations that are not generally accepted in the accounting vernacular. ? Enable the spreadsheet to allow the instructor to view the formulae used in each cells. ? Use commas for all numbers but do not use decimals or places (i.e. one thousand ten dollars and 20 cents should show as 1,010 not $1,010.20). …
Attachments:
part_3.pdf