Ch_13_sm_Excel Solutions

Governmental and Nonprofit Accounting: Theory and Practice, Update (9th Edition)

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Problem 13-3 Tazewell County Statement of Activities For the Year December 31, 20X9 Program Revenues Net (Expenses) Revenues and Changes in Net Assets Primary Government Charges Operating for Grants and Capital Governmental Business-Type Functions: Expenses Services Contributions Grants Activities Activities Total Primary government Governmental activities: General government $10,000,000 ($10,000,000) ($10,000,000) Public safety 18,000,000 (18,000,000) (18,000,000) Education 34,000,000 $12,000,000 (22,000,000) (22,000,000) Transportation 24,000,000 $9,000,000 (15,000,000) (15,000,000) Culture and recreation 1,500,000 (1,500,000) (1,500,000) Interest 3,000,000 (3,000,000) (3,000,000) Total governmental activities 90,500,000 - 12,000,000 9,000,000 (69,500,000) - (69,500,000) Business-type activities: Water service 11,900,000 13,000,000 1,100,000 1,100,000 Total business-type activities 11,900,000 13,000,000 - - - 1,100,000 1,100,000 Total primary government $102,400,000 $13,000,000 $12,000,000 $9,000,000 (69,500,000) 1,100,000 (68,400,000) General revenues: Property taxes, levied for general purposes 70,000,000 70,000,000 Unrestricted grant revenues 300,000 300,000 Special item, gain on sale of land ($2,200,000 - $350,00 1,850,000 1,850,000 Extraordinary loss--tornado damage (310,000) (310,000) Transfers (4,000,000) 4,000,000 - Total general revenues, special items and transfers 67,840,000 4,000,000 71,840,000 Change in net assets (1,660,000) 5,100,000 3,440,000 Net assets--beginning 26,530,000 4,000,000 30,530,000 Net assets--ending $24,870,000 $9,100,000 $33,970,000
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Problem 13-4 Walland County School District Statement of Activities For the Year Ended December 31, 20X5 Program Revenues Net (Expenses) Revenues and Changes in Net Assets Primary Government Charges Operating for Grants and Capital Governmental Business-Type Functions: Expenses Services Contributions Grants Activities Activities Total Primary government Instructional departments $34,000,000 $1,050,000 $800,000 $720,000 ($31,430,000) ($31,430,000) Support services 27,000,000 440,000 750,000 55,100 (25,754,900) (25,754,900) Noninstructional services 575,000 10,000 490,000 (75,000) (75,000) Extracurricular activities
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

Ch_13_sm_Excel Solutions - Problem 13-3 Tazewell County...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online