Accounting help

profileDaisy1
answer_file.docx

This activity is to be completed using the background information provided under the "Assignments" tab for "Government Activity 3".  You will be able to access this activity an unlimited amount of times prior to the due date of the assignment. 

Please round all answers calculated on your Excel spreadsheet to the nearest dollar.  Insert those rounded dollar amounts in your quiz answers here.  Please answer all questions requiring a dollar amount as the answer using NO dollar signs, NO decimals, and NO pennies.  DO USE commas if appropriate in your answers.  For example, if the answer on your Excel spreadsheet is $1,500.35, you would round that to $1,500 and insert 1,500 in the answer space for the appropriate quiz question. 

 

Top of Form

 

Question 1

What is the amount of unrestricted Cash and Investments at 9/30/15?

 

Question 2

What is the amount restricted Cash and Investments at 9/30/15?

 

Question 3

What is the amount of Accounts Receivable - Customers at 9/30/15?

 

Question 4

What is the amount of Accrued Interest Receivable at 9/30/15?

 

Question 5

What is the total amount of Property, Plant, and Equipment at 9/30/15?

 

Question 6

What is the net book value of Property, Plant, and Equipment at 9/30/15?

 

Question 7

What is the total amount of Accounts Payable and accrued expenses at 9/30/15?

 

Question 8

What is the total amount of Net Position at 9/30/15?

 

Question 9

What is the amount of Net Investment in Capital Assets at 9/30/15?

 

Question 10

What is the amount of Restricted Net Position at 9/30/15?

 

Question 11

What is the amount of Unrestricted Net Position at 9/30/15?

 

Question 12

What was the amount of Water & Sewer Revenues for the year ending 9/30/15?

 

Question 13

What is the total amount of Investment Income for the year ending 9/30/15?

 

Question 14

What is the amount of cash that was paid for expenses for the year ending 9/30/15?

 

Question 15

What is the total amount of expenses excluding depreciation for the year ending 9/30/15?

 

Question 16

What is the total amount of expenses including depreciation for the year ending 9/30/15?

 

Question 17

What is the amount of total Net Position for the Governmental Activities at 9/30/15?

Bottom of Form