Perform vertical analysis and explain findings and any red flags

Year Ended April 20.2010 - For Illinois Capital Non-Major General Municipal Municipal Governme Sales Tax Developme Governmen ntal Retirement nt tal Funds fundo REVENUES General propertu taxes $1,972,544 $448.396 $1.276 023 $3.691.963 Foreign fire insurance tax 24 225 24.226 Intergovemmental revenues 2538,168 Gle92,775 578 287 6,507 210 Licenses, permits and other fees 270.910 270.910 Fines and penalties 159.894 159,894 Charges for services 453.633 453,633 Revenue from use of money and property 335 16.833 189 1,227 120.995 139 579 5 Other 489 586 650 000 25.883 1.168 469 5 Total revenues 5,431437 460 229 3,392.964 651.227 2,478,027 12,413,884 7 8 EXPENDITURES 19 General government 2.229.580 521188 52.314 2334 082 20 Public safety 21 Police protection and 22 community relations 2.635,980 2,635.980 23 Fire fighting and prevention 24 and emergency vehicle 1288.127 331.992 1620.119 25 Public works 139.118 139. 118 26 Highways and streets 735.156 1,347 113 2.082,269 27 Traffic development 77 690 77.690 28 Welfare-Civil Defense 25.016 25.016 29 Culture and recreation 459 315 459 315 30 Airport operations 117.177 112.177 31 Cemetery operations 249,014 248.014 32 Capital outlay 7,583,663 100 902 7.634 565 33 Debt Service 34 Principal 647.000 647.000 35 Interest 558,295 558 295 36 Payments to pensions 747 479 179,151 926.630 37 Payments to Social Security Systern 183.165 183.165 38 Total expenditures 7.853.130 179 151 52.188 8.738 958 2.8651008 19.688,435 39 40 Excess (deficiency of revenues over expenditures ($2.421693) $281078 $3,340.776 ($8.087.731 ($386,981 ($7.274,551 41 42 OTHER FINANCING SOURCES (USES) 43 Operating transfers in $1.010.000 $4925 000 $5.935.000 44 Operating transfers out ($400,000) ($3.460.000) ($450.000) $4,310.0001 45 Total other financing sources (uses) $610,000 ($6.460.000) $4.925.000 1$450 000 $1625.000 46 47 Excess (deficiency) of revenues and other 48 financing sources over expenditures and other financing ($1811.693) $281,078 ($119.224) ($3.162.731) ($836.981 ($5,649 551 49 FUND (DEFICIT) BALANCE, BEGINNING OF YE/ 1$2.736,321) $3.201,361 $616.481 $1675.847 $5.280.891 $8.038, 259 50 FUND (DEFICIT) BALANCE, END OF YEAR ($4,548,014) $8.482.439 $497.257 (91486.884) $4.443 910 $21688 708 51 52 The accompanying notes are an integral part of the basie financial statements - IH Year Ended April 20.2010 - For Illinois Capital Non-Major General Municipal Municipal Governme Sales Tax Developme Governmen ntal Retirement nt tal Funds fundo REVENUES General propertu taxes $1,972,544 $448.396 $1.276 023 $3.691.963 Foreign fire insurance tax 24 225 24.226 Intergovemmental revenues 2538,168 Gle92,775 578 287 6,507 210 Licenses, permits and other fees 270.910 270.910 Fines and penalties 159.894 159,894 Charges for services 453.633 453,633 Revenue from use of money and property 335 16.833 189 1,227 120.995 139 579 5 Other 489 586 650 000 25.883 1.168 469 5 Total revenues 5,431437 460 229 3,392.964 651.227 2,478,027 12,413,884 7 8 EXPENDITURES 19 General government 2.229.580 521188 52.314 2334 082 20 Public safety 21 Police protection and 22 community relations 2.635,980 2,635.980 23 Fire fighting and prevention 24 and emergency vehicle 1288.127 331.992 1620.119 25 Public works 139.118 139. 118 26 Highways and streets 735.156 1,347 113 2.082,269 27 Traffic development 77 690 77.690 28 Welfare-Civil Defense 25.016 25.016 29 Culture and recreation 459 315 459 315 30 Airport operations 117.177 112.177 31 Cemetery operations 249,014 248.014 32 Capital outlay 7,583,663 100 902 7.634 565 33 Debt Service 34 Principal 647.000 647.000 35 Interest 558,295 558 295 36 Payments to pensions 747 479 179,151 926.630 37 Payments to Social Security Systern 183.165 183.165 38 Total expenditures 7.853.130 179 151 52.188 8.738 958 2.8651008 19.688,435 39 40 Excess (deficiency of revenues over expenditures ($2.421693) $281078 $3,340.776 ($8.087.731 ($386,981 ($7.274,551 41 42 OTHER FINANCING SOURCES (USES) 43 Operating transfers in $1.010.000 $4925 000 $5.935.000 44 Operating transfers out ($400,000) ($3.460.000) ($450.000) $4,310.0001 45 Total other financing sources (uses) $610,000 ($6.460.000) $4.925.000 1$450 000 $1625.000 46 47 Excess (deficiency) of revenues and other 48 financing sources over expenditures and other financing ($1811.693) $281,078 ($119.224) ($3.162.731) ($836.981 ($5,649 551 49 FUND (DEFICIT) BALANCE, BEGINNING OF YE/ 1$2.736,321) $3.201,361 $616.481 $1675.847 $5.280.891 $8.038, 259 50 FUND (DEFICIT) BALANCE, END OF YEAR ($4,548,014) $8.482.439 $497.257 (91486.884) $4.443 910 $21688 708 51 52 The accompanying notes are an integral part of the basie financial statements - IH