Sources of Revenue

Prepare an Excel workbook that contains a separate spreadsheet for each individual government entity. The spreadsheets should list the following:

• The principle sources of revenues for the general fund

• The primary expenditures made out of the general fund of each government entity. In other words, how does the general fund get and spend its money. Be sure to include dollar amounts.

Brainstorm and discuss the commonalities and the differences between the sources of revenue and the types and amounts of expenditures for each entity. Discuss those differences among team members the reasons for the differences.

Prepare a summary spreadsheet for the workbook that provides a comparative (side-by-side) analysis between the different entities.