2-10. The following water and sewer fund information is available for the preparation of the financial statements for the City of Western Sands for the year ended December 31, 2020: Operating revenues-charges for services $17,387,000 Operating expenses: Personnel services Contractual services Utilities Repairs and maintenance Depreciation Interest revenue State aid (intergovernmental revenue) Interest expense Capital contributions Transfer to General Fund Net position, January 1, 2020 5,877,000 2,995,000 888,000 1,992,000 5,422,000 29,000 100,000 104,000 1,632,000 365,000 1,800,000 From the information given above, prepare, in good form, a Water and Sewer Fund column for the proprietary fund Statement of Revenues, Expenses, and Changes in Fund Net Position for the year ended December 31, 2020.

Q: Define terminal date

A: Answer: In finance, horizon date is called as terminal value. It is the date from which individual…

Q: Which of the following can be used to link two tables together? Select one: a. Primary Key b.…

A: Foreign key is a column or group of columns in a relational database table that provides a link…

Q: Show how to insert formula in excel

A: Perpetuity: It is a stream of cash flow that is presumed to continue for an indefinite period.

Q: For what reasons is the NPV technique preferable to IRR?

A: The Net Present Value (NPV) technique is a financial evaluation method used to assess the…

Q: Natarajan, Inc. had the following operating segments, with the in Segment Expenses $ 650,000…

A: We must contrast the segment revenues with the sum of the revenues of all other segments in order to…

Q: can you hand write it instead of using excel

A: Here,Risk Free Rate is 3%Standard Deviation of Optimal Risky Portfolio is 20%Expected Return of…

Q: What does the blank section post mean or what goes there

A: Post Column : It is the Column through which book keeper identify whether journal entries are…

Q: n you handwrite this or type it instead of using excel

A: According to the expectation theory short term interest rate should be in line with long term…

Q: not use ai please

A: To manually divide  110  by  39.37  using long division, follow these steps: Step 1: SetupDivide…

Q: I cannot use excel. please caculate manually

A: Given: Initial salary is $42,200 Salary rise after first year to $45,400 Inflation average is 3%

Q: Prepare the entry for the issuance under the following assumptions. (List all debit entries before…

A: The journal entries are prepared to record the transactions on regular basis. The cash received in…

Q: In a data visualization, the vertical axis typically shows __________.   Multiple Choice   values…

A: A column chart will include data labels along the horizontal (X) axis with measured metrics or…

Q: State the meaning of incomplete records?

A: Accounting refers to the process through which the financial transactions related to a business are…

Q: Choose the term that best describes static data? O Static data does not change once it is created. O…

A: static data does not change once it is createdThe best describes static data does not change once it…

Q: Fill out the missing column

A: Net revenue = Gross profit + Cost of goods sold = 511000+673400 = $1184400 Operating expense = Net…

Q: What exactly are reversing entries, and why do we need them?

A: Journal entry is the entry which is made at the date on which the transaction which relates to the…

Q: im having trouble with vlookup in excel

A: Type Vlookup in the formula bar of excel sheet.

Q: Can you please enter the information clearly without so many spaces? The information is hard to…

A: The ratio of inventory turnover measures how effectively the business uses its inventory through…

Q: no entry is required, select "No Entry for the account titles and enter O for the amounts. Credit…

A: Perpetual inventory system is used for recording the transactions related to the purchase and sale…