On the following page is the statement of revenues, expenditures, and changes in fund balances for governmental funds from the city of Collierville, TNs CAFR for fiscal year 2019. Based on this information, answer the following:
1. What is the sum of revenues for all governmental funds?
2. What is the sum of expenditures for the General Fund?
3. How much money has been budgeted for public safety across all governmental funds?
4. What are the three largest revenue sources within the General Fund?
5. How much did fund balance change during FY19 for the General Fund?
Source of the table: Town of Collierville, Tennessee- Comprehensive annual financial report- Year ended June 30, 2019
(Statement of revenues, expenditure, and changes in fund balances
TOWN OF COLLIERVILLE, TENNESSEE STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES GOVERNMENTAL FUNDS For the Year Ended June 30, 2019 General Fund General Education Capital Purpose Capital Projects School Fund Project #177 Fund 8321 Other Governmental Funds Total Governmental Funds $ 30,090,868 $ 26,499,701 22.278,629 13,973,387 $ 56,590,569 36.283.583 31,567 6,487,045 43,110,671 15,962 1.599,661 REVENUES Property taxes Local sales taxes Intergovernmental State sales, income, and other tax State education revenue State gas tax Licenses and permits Charges for services Fines, forfeitures, and penalties Federal and state grant revenue Contributions Other Interest on investments Total revenues 270,469 5.984,343 73.498 7,502,521 6,487,045 43,126,633 1,599,661 1,384,194 8,6X07,360 1,681,612 10,651,327 5,387,614 1,502,914 1.260,414 173.962.926 1.384,194 1.752,548 1.608,114 108.951 1,423,074 602.790 1,138,274 66,874,487 3,039,855 3,964,540 771,412 82,493 84.708,133 128,712 39,647 15,375,911 3,964.540 3.039,855 11.463,101 22.678,589 5.540,004 2,014.196 171.500 34.887 1.557.965 11,634,601 22,713.476 7,097,969 2014.196 3,541,278 85,753,08 77.845,556 3.541,278 7.907,525 4,300,000 4.484.213 1,026,654 51.506,757 5,667, 186 83,512,742 4,300,0X10 4.484,213 30,669,494 172,205,304 11.483,440 11.483,440 6.686.118 6.686.118 5,806,096 19.019.251 EXPENDITURES Current General government Public safety Reads and public works Culture and recreation Sanitation Education Debt Service Principal Interest and fiscal charges Capital outlays Total expenditures Excess deficiency of revenus over (under) expenditures OTHER FINANCING SOURCES (USES) Issuance of capital lease Transfers in Transfers out Total other financing sources (uses) Net change in fund balances Fund balances beginning 15,367,730 1,195,391 (7.518,900) (3.646,263) (3.643,340) 1.754,618 5,064,107 3,651,913 19,693.087) (6.041.174) 2,891,213 100,728 (5,064,107) (2.072.166) 6,692,292 (2.402.879) 4.289.413 3,667,159 (1.091.3421 2.575,817 2.891.213 19,176,199 (18,251,415) 3,815,997 5,064,107 9.326,556 (876,775) (2.454.793) 643.150 (1.067.523) 5.570,615 56.800.657 15,424,549 2.454,793 16.537 5.251.282 79,947.818 Fund balances ending S 66.127.213 $ 14,547,774 S $ 659.687 $ 4.183.759 $ 85,518,433 TOWN OF COLLIERVILLE, TENNESSEE STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES GOVERNMENTAL FUNDS For the Year Ended June 30, 2019 General Fund General Education Capital Purpose Capital Projects School Fund Project #177 Fund 8321 Other Governmental Funds Total Governmental Funds $ 30,090,868 $ 26,499,701 22.278,629 13,973,387 $ 56,590,569 36.283.583 31,567 6,487,045 43,110,671 15,962 1.599,661 REVENUES Property taxes Local sales taxes Intergovernmental State sales, income, and other tax State education revenue State gas tax Licenses and permits Charges for services Fines, forfeitures, and penalties Federal and state grant revenue Contributions Other Interest on investments Total revenues 270,469 5.984,343 73.498 7,502,521 6,487,045 43,126,633 1,599,661 1,384,194 8,6X07,360 1,681,612 10,651,327 5,387,614 1,502,914 1.260,414 173.962.926 1.384,194 1.752,548 1.608,114 108.951 1,423,074 602.790 1,138,274 66,874,487 3,039,855 3,964,540 771,412 82,493 84.708,133 128,712 39,647 15,375,911 3,964.540 3.039,855 11.463,101 22.678,589 5.540,004 2,014.196 171.500 34.887 1.557.965 11,634,601 22,713.476 7,097,969 2014.196 3,541,278 85,753,08 77.845,556 3.541,278 7.907,525 4,300,000 4.484.213 1,026,654 51.506,757 5,667, 186 83,512,742 4,300,0X10 4.484,213 30,669,494 172,205,304 11.483,440 11.483,440 6.686.118 6.686.118 5,806,096 19.019.251 EXPENDITURES Current General government Public safety Reads and public works Culture and recreation Sanitation Education Debt Service Principal Interest and fiscal charges Capital outlays Total expenditures Excess deficiency of revenus over (under) expenditures OTHER FINANCING SOURCES (USES) Issuance of capital lease Transfers in Transfers out Total other financing sources (uses) Net change in fund balances Fund balances beginning 15,367,730 1,195,391 (7.518,900) (3.646,263) (3.643,340) 1.754,618 5,064,107 3,651,913 19,693.087) (6.041.174) 2,891,213 100,728 (5,064,107) (2.072.166) 6,692,292 (2.402.879) 4.289.413 3,667,159 (1.091.3421 2.575,817 2.891.213 19,176,199 (18,251,415) 3,815,997 5,064,107 9.326,556 (876,775) (2.454.793) 643.150 (1.067.523) 5.570,615 56.800.657 15,424,549 2.454,793 16.537 5.251.282 79,947.818 Fund balances ending S 66.127.213 $ 14,547,774 S $ 659.687 $ 4.183.759 $ 85,518,433
