please help 495330
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:
We've got everything to become your favourite writing service
Money back guarantee
Your money is safe. Even if we fail to satisfy your expectations, you can always request a refund and get your money back.
Confidentiality
We don’t share your private information with anyone. What happens on our website stays on our website.
Our service is legit
We provide you with a sample paper on the topic you need, and this kind of academic assistance is perfectly legitimate.
Get a plagiarism-free paper
We check every paper with our plagiarism-detection software, so you get a unique paper written for your particular purposes.
We can help with urgent tasks
Need a paper tomorrow? We can write it even while you’re sleeping. Place an order now and get your paper in 8 hours.
Pay a fair price
Our prices depend on urgency. If you want a cheap essay, place your order in advance. Our prices start from $11 per page.
part_3.pdf