Please help ... I have a few questions on this. The following information pertains to the City of Williamson for 2017, its first year of legal existence. For convenience, assume that all transactions are for the general fund, which has three separate functions: general government, public safety, and health and sanitation.

Receipts:

Property Taxes $444,000

Franchise taxes 48,200

Charges for general government services 7,600

Charges for public safety services 3,600

Charges for health and sanitation services 45,100

Issued long-term note payable 291,000

Receivables at the end of year:

Property taxes (90% estimated to be collectible) 92,600

Payments:

Salary:

General government 66,500

Public safety 48,500

Health and sanitation 29,100

Rent:

General government 20,900

Public safety 27,100

Health and sanitation 3,000

Maintenance:

General government 31,600

Public safety 6,600

Health and sanitation 10,300

Insurance:

General government 9,100

Public safety ($3,100 still prepaid at end of year) 13,900

Health and sanitation 19,200

Interest on debt 23,280

Principal payment on debt 5,820

Storage shed 177,000

Equipment 114,000

Supplies (20% still held) (public safety) 19,500

Investments 88,000

Ordered but not received:

Equipment 16,000

Due in one month at end of year:

Salaries:

General government 4,200

Public safety 6,900

Health and sanitation 9,600

Compensated absences (such as vacations and sick days) are legally owed to general government workers at year-end total $15,400. These amounts will not be taken by the employees until so late in 2018 that the payment is not viewed as requiring 2017 current financial resources. The city received a piece of art this year as a donation. It is valued at $23,200. It will be used for general government purposes. There are no eligibility requirements. The city chose not to capitalize this property. The general government uses the storage shed that was acquired this year. It is being depreciated over 10 years using the straight-line method with no salvage value. The city uses the equipment for health and sanitation and depreciates it using the straight-line method over five years with no salvage value. The investments are valued at $107,500 at the end of the year. For the equipment that has been ordered but not yet received, the City Council (the highest decision-making body in the government) has voted to honor the commitment when the equipment is received.

a-2. Prepare a statement of net position for governmental activities for December 31, 2017. ***I only need the amounts for the Cash and Cash Equivalents -and- Invested in Capital Assets, Net of Related Debt -and- Unrestricted Deficit.***

b-1. Prepare a statement of revenues, expenditures, and other changes in fund balances for the general fund as of December 31, 2017. Assume that the city applies the consumption method.

b-2. Prepare a balance sheet for the general fund as of December 31, 2017. Assume that the city applies the consumption method.*** I only need the amount to the Cash and Cash Equivalents***

I have been using the following formula and it is not computing. Cash and cash equivalents = Total Receipts (Total Payments + Current Assets + Total Debt). For the Statement of Net Position, can you please explain how to calculate Cash and Cash Equivalents; Invested in capital assets, net of related debt; and Unrestricted (deficit)? For the Balance Sheet, how do you calculate the Cash and cash equivalents (and do I need to include the Salary Payables for this calculation)?