The following is a screenshot of an assignment I am working on. I have the answe
ID: 2329473 • Letter: T
Question
The following is a screenshot of an assignment I am working on. I have the answer but I would like information on how to obtain the answer. Specifically I am looking for how to find the cash and cash equivalents as well as the invested in capital assets, net of related debt. I'm not looking for anything else in the question. Just how to find those two answers.
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 Franchise taxes Charges for general government services Charges for public safety services Charges for health and sanitation services Issued long-term note payable $406,000 51,700 8,000 3,700 50,400 273,000 Receivables at end of year: Property taxes (90% estimated to be collectible) 107,400 Payments: Salary: General government Public safety Health and sanitation 67,650 46, 300 22,600 Rent: General government Public safety Health and sanitation 13,000 24, 500 3,300 Maintenance: General government Public safet Health and sanitation 22,500 6,900 9,600 Insurance: 9,600 13,500 19,500 21,840 5,460 190,008 83,000 23,800 104,000 General government Public safety ($2,400 still prepaid at end of year) Health and sanitation Interest ondebt Principal payment on debt Storage shed Equipment Supplies (20% still held) (public safety) InvestmentsExplanation / Answer
Working Government Activites Expenses General Governmental Salary $ 67,650.00 Rent $ 13,000.00 Maintenance $ 22,500.00 Insurance $ 9,600.00 Salary Payable $ 6,300.00 Compensated Absences $ 19,700.00 Art Work $ 21,500.00 Depreciation on Building($190000/10) $ 19,000.00 Total General Government $ 1,79,250.00 Public Safety Salary $ 46,300.00 Rent $ 24,500.00 Maintenance $ 6,900.00 Expired Insurance($13500-$2400) $ 11,100.00 Supplies used($23800*80%) $ 19,040.00 Salary Payable $ 8,700.00 Total Public Safety $ 1,16,540.00 Health & Sanitation Salary $ 22,600.00 Rent $ 3,300.00 Maintenance $ 9,600.00 Insurance $ 19,500.00 Salary Payable $ 10,500.00 Depreciation on Equipment($83000/5) $ 16,600.00 Total Health & Sanitation $ 82,100.00 Interest on Debt $ 21,840.00 (Given) Charges for Services Govt Grants $ 8,000.00 (Given) Public Safety $ 3,700.00 (Given) Health & Sanitation $ 50,400.00 (Given) The City received a piece of art this year valued at $21500=Capital Grants Net Expenses charges Government activities Govt grants=($179250-$8000-$21500) $ 1,49,750.00 Public safety=($116540-$3700) $ 1,12,840.00 Health & Sanitation=($82100-$50400) $ 31,700.00 Property Taxes $ 4,06,000.00 Property Taxes($107400*90%) $ 96,660.00 Total $ 5,02,660.00 Franchise Taxes $ 51,700.00 Investment Gain=($126900-$104000) $ 22,900.00 Total General revenue($502660+$51700+$22900) $ 5,77,260.00 Changes in Net Position=($577260-$316130) $ 2,61,130.00 Cash & Cash Equivalents Property Taxes $ 4,06,000.00 Franchise Taxes $ 51,700.00 Cherges for general govt services $ 8,000.00 Charges for public safety services $ 3,700.00 Charges for health & sanitation $ 50,400.00 Issued long term note Payable $ 2,73,000.00 Total Receipts $ 7,92,800.00 Less: Payments Salary $ 1,36,550.00 Rent $ 40,800.00 Maintenance $ 39,000.00 Insurance $ 42,600.00 Intt & principal on debts $ 27,300.00 Storage shed $ 1,90,000.00 Equipment $ 83,000.00 Supplies $ 23,800.00 Investment $ 1,04,000.00 Total Payments $ 6,87,050.00 Cash & Cash Equivalents $ 1,05,750.00 Prepaid Expenses $ 2,400.00 (Given) Investment (Valued) $ 1,26,900.00 Receivable (Net)=($107400-(107400*10%)) $ 96,660.00 Inventory=($23800*20%) $ 4,760.00 Capital Assets(Net) Equipment=($83000-$16600Dep) $ 66,400.00 Storage Shed($190000-$19000Dep) $ 1,71,000.00 $ 2,37,400.00 Total Assets $ 5,73,870.00
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.