Budget & Finance
chick
budget_tools_chapter_09_exercises.xls2005 balance
| City of Charlottesville Virginia | |||||
| Statement of Net Assets | |||||
| June 30,2005 | Capital | Social | Other | ||
| General | Projects | Services | Gov't. | ||
| Fund | Fund | Fund | Fund | Total | |
| Assets | |||||
| Cash | $ 17,455,863 | $ 3,889,312 | $ 108,907 | $ 4,334,506 | $ 25,788,588 |
| Investments | 599 | 599 | |||
| Accounts Receivable | 1,358,985 | 16,164 | 6,263 | 700,456 | 2,081,868 |
| Taxes Receivable | 21,203,551 | 21,203,551 | |||
| Specal assessments receivable | 16,813 | 16,813 | |||
| Due from other governments | 3,363,801 | 4,819,047 | 782,115 | 5,277,677 | 14,242,640 |
| Due from other funds | 3,113,737 | 3,113,737 | |||
| Loans receivable | 1,826,518 | 148,543 | 1,975,061 | ||
| Accrued interest receivable | 216,489 | - 0 | - 0 | 10 | 216,499 |
| Total Assets | $ 46,712,426 | $ 10,567,854 | $ 897,285 | $ 10,461,791 | $ 68,639,356 |
| Liabilities & Fund Balances | |||||
| Liabilities | |||||
| Accounts payable | $1,467,986 | $3,322,474 | $92,249 | $3,284,540 | $8,167,249 |
| Accrued liabilties | 2,815,039 | 24,000 | 230,255 | 171,488 | 3,240,782 |
| Due to other governments | 108,543 | 108,543 | |||
| Due to other funds | 1,848,853 | 1,848,853 | |||
| Deferred revenue | 23,236,817 | 21,162 | 574,781 | 344,611 | 24,177,371 |
| Total Liabilities | $27,519,842 | $3,367,636 | $897,285 | $5,758,035 | $37,542,798 |
| Fund Balances | |||||
| Reserved | $979,023 | $5,684,987 | $788,797 | $7,452,807 | |
| Unreserved, designated: | - | ||||
| General Fund | 1,118,013 | 1,118,013 | |||
| Capital Projects Fund | 1,515,231 | 1,515,231 | |||
| Debt Service Fund | 3,914,959 | 3,914,959 | |||
| Unreserved, undesignated: | - | ||||
| General Fund | 17,095,548 | - | - | - | 17,095,548 |
| Total Fund Balances | $19,192,584 | $7,200,218 | $ - | $4,703,756 | $31,096,558 |
| Total Liabilities and Fund Balances | $46,712,426 | $10,567,854 | $897,285 | $10,461,791 | $68,639,356 |
2006 balance
| City of Charlottesville Virginia | |||||
| Statement of Net Assets | |||||
| June 30,2006 | |||||
| Capital | Social | Other | |||
| General | Projects | Services | Gov't. | ||
| Fund | Fund | Fund | Fund | Total | |
| Assets | |||||
| Cash | $ 25,540,244 | $ - 0 | $ 156,943 | $ 5,462,149 | $ 31,159,336 |
| Investments | - 0 | - 0 | - 0 | 600 | 600 |
| Accounts Receivable | 1,046,166 | 2,295 | 3,893 | 35,610 | 1,087,964 |
| Taxes Receivable | 24,319,651 | - 0 | - 0 | - 0 | 24,319,651 |
| Specal assessments receivable | - 0 | 16,813 | - 0 | - 0 | 16,813 |
| Due from other governments | 5,055,427 | 5,195,502 | 705,290 | 3,178,186 | 14,134,405 |
| Due from other funds | 3,269,698 | 506 | - 0 | - 0 | 3,270,204 |
| Loans receivable | - 0 | 3,192,556 | - 0 | 143,723 | 3,336,279 |
| Accrued interest receivable | 9,972 | - 0 | - 0 | 10 | 9,982 |
| Total Assets | $ 59,241,158 | $ 8,407,672 | $ 866,126 | $ 8,820,278 | $ 77,335,234 |
| Liabilities & Fund Balances | |||||
| Liabilities | |||||
| Accounts payable | 1,727,186 | 2,625,763 | 111,167 | 1,291,934 | 5,756,050 |
| Accrued liabilties | 3,644,356 | 8,612 | 210,905 | 190,381 | 4,054,254 |
| Due to other governments | - 0 | - 0 | - 0 | 134,281 | 134,281 |
| Due to other funds | - 0 | 1,756,310 | - 0 | 1,211,616 | 2,967,926 |
| Deferred revenue | 27,581,876 | 3,215,701 | 544,054 | 127,374 | 31,469,005 |
| Total Liabilities | 32,953,418 | 7,606,386 | 866,126 | 2,955,586 | 44,381,516 |
| Fund Balances | |||||
| Reserved | 715,230 | 20,257,807 | - 0 | 901,885 | 21,874,922 |
| Unreserved, designated: | - 0 | - 0 | - 0 | - 0 | - 0 |
| General Fund | 3,921,815 | - 0 | - 0 | - 0 | 3,921,815 |
| Capital Projects Fund | - 0 | (19,456,521) | - 0 | - 0 | (19,456,521) |
| Debt Service Fund | - 0 | - 0 | - 0 | 4,962,807 | 4,962,807 |
| Unreserved, undesignated: | - 0 | - 0 | - 0 | - 0 | - 0 |
| General Fund | 21,650,695 | - 0 | - 0 | - 0 | 21,650,695 |
| Total Fund Balances | 26,287,740 | 801,286 | - 0 | 5,864,692 | 32,953,718 |
| Total Liabilities & FB | $ 59,241,158 | $ 8,407,672 | $ 866,126 | $ 8,820,278 | $ 77,335,234 |
2005 income
| City of Charlottesville | |||||
| Statement of Revenues, Expenditures and Changes in Fund Balances | |||||
| Governmental Funds | |||||
| For the Year Ended June 30, 2005 | |||||
| Capital | Social | Other | |||
| General | Projects | Services | Gov't. | ||
| Fund | Fund | Fund | Fund | Total | |
| Revenues | |||||
| Taxes | 73,521,654 | - 0 | - 0 | - 0 | 73,521,654 |
| Fees & Permits | 1,553,833 | - 0 | - 0 | - 0 | 1,553,833 |
| Intergovernmental | 19,629,915 | 8,937,858 | 9,819,003 | 12,830,816 | 51,217,592 |
| Charges for Services | 4,420,205 | - 0 | - 0 | 3,285,459 | 7,705,664 |
| Fines | 541,733 | - 0 | - 0 | - 0 | 541,733 |
| Investment Earnings | - 0 | 90,121 | - 0 | 3,247 | 93,368 |
| Miscellaneous | 1,400,939 | 237,422 | 26,751 | 220,515 | 1,885,627 |
| Total Revenue | 101,068,279 | 9,265,401 | 9,845,754 | 16,340,037 | 136,519,471 |
| Expenditures | |||||
| General Government | 10,293,731 | 540,328 | - 0 | - 0 | 10,834,059 |
| Public Safety | 22,388,096 | - 0 | - 0 | 3,962,105 | 26,350,201 |
| Community Services | 6,299,314 | 2,066,346 | - 0 | 4,440,075 | 12,805,735 |
| Health & Welfare | 3,385,595 | 213,015 | 11,986,071 | 9,437,130 | 25,021,811 |
| Parks, Recreation & Culture | 6,624,111 | 753,057 | - 0 | 136,810 | 7,513,978 |
| Education | 31,133,916 | 661,986 | - 0 | - 0 | 31,795,902 |
| Conservation & Development | 3,259,330 | 1,898,156 | - 0 | 1,339,792 | 6,497,278 |
| Other Activities | 167,858 | - 0 | - 0 | - 0 | 167,858 |
| Debt Services | - 0 | - 0 | - 0 | 5,529,690 | 5,529,690 |
| Capital Outlay | - 0 | 23,908,132 | - 0 | - 0 | 23,908,132 |
| Total Expenditures | 83,551,951 | 30,041,020 | 11,986,071 | 24,845,602 | 150,424,644 |
| Net | 17,516,328 | (20,775,619) | (2,140,317) | (8,505,565) | (13,905,173) |
| Other Financing Sources | |||||
| Transfers from other funds | 4,403,507 | 5,726,162 | 2,140,317 | 10,652,361 | 22,922,347 |
| Transfers to other funds | (16,578,460) | (1,561,643) | - 0 | (20,602) | (18,160,705) |
| Proceeds from debt issuance | - 0 | 19,962,475 | - 0 | - 0 | 19,962,475 |
| Refunding bond issued | - 0 | - 0 | - 0 | 2,913,333 | 2,913,333 |
| Payment to refund | - 0 | - 0 | - 0 | (3,043,650) | (3,043,650) |
| Total Other financial sources | (12,174,953) | 24,126,994 | 2,140,317 | 10,501,442 | 24,593,800 |
| Net Change in Fund Balance | 5,341,375 | 3,351,375 | - 0 | 1,995,877 | 10,688,627 |
| Fund Balance - July 1, 2004 | 13,851,209 | 3,848,843 | - 0 | 2,707,879 | 20,407,931 |
| Fund Balance - June 30, 2005 | $ 19,192,584 | $ 7,200,218 | $ - 0 | $ 4,703,756 | $ 31,096,558 |
2006 income
| City of Charlottesville | |||||
| Statement of Revenues, Expenditures and Changes in Fund Balances | |||||
| Governmental Funds | |||||
| For the Year Ended June 30, 2006 | |||||
| Capital | Social | Other | |||
| General | Projects | Services | Gov't. | ||
| Fund | Fund | Fund | Fund | Total | |
| Revenues | |||||
| Taxes | $ 80,203,931 | $ - 0 | $ - 0 | $ - 0 | $ 80,203,931 |
| Fees & Permits | 1,594,542 | - 0 | - 0 | - 0 | 1,594,542 |
| Intergovernmental | 21,984,160 | 4,681,286 | 9,526,662 | 11,399,552 | 47,591,660 |
| Charges for Services | 4,204,335 | 12,198 | - 0 | 2,484,904 | 6,701,437 |
| Fines | 508,322 | - 0 | - 0 | - 0 | 508,322 |
| Investment Earnings | - 0 | 78,312 | - 0 | 6,956 | 85,268 |
| Miscellaneous | 1,657,780 | 137,421 | 22,162 | 215,119 | 2,032,482 |
| Total Revenue | 110,153,070 | 4,909,217 | 9,548,824 | 14,106,531 | 138,717,642 |
| Expenditures | |||||
| General Government | 11,198,590 | 2,379,781 | - 0 | - 0 | 13,578,371 |
| Public Safety | 24,314,230 | - 0 | - 0 | 1,875,079 | 26,189,309 |
| Community Services | 6,119,250 | 2,429,279 | - 0 | 4,569,087 | 13,117,616 |
| Health & Welfare | 3,466,120 | - 0 | 11,810,684 | 9,602,318 | 24,879,122 |
| Parks, Recreation & Culture | 6,941,920 | 724,953 | - 0 | 79,957 | 7,746,830 |
| Education | 32,503,082 | 904,589 | - 0 | - 0 | 33,407,671 |
| Conservation & Development | 3,528,002 | 1,027,612 | - 0 | 922,190 | 5,477,804 |
| Other Activities | 173,034 | 148,199 | - 0 | - 0 | 321,233 |
| Debt Services | - 0 | - 0 | - 0 | 7,074,419 | 7,074,419 |
| Capital Outlay | - 0 | 8,719,385 | - 0 | - 0 | 8,719,385 |
| Total Expenditures | 88,244,228 | 16,333,798 | 11,810,684 | 24,123,050 | 140,511,760 |
| Net | 21,908,842 | (11,424,581) | (2,261,860) | (10,016,519) | (1,794,118) |
| Other Financing Sources | |||||
| Transfers from other funds | 3,964,587 | 5,991,263 | 2,261,860 | 11,193,957 | 23,411,667 |
| Transfers to other funds | (18,778,273) | (965,614) | - 0 | (16,502) | (19,760,389) |
| Proceeds from debt issuance | - 0 | - 0 | - 0 | - 0 | - 0 |
| Refunding bond issued | - 0 | - 0 | - 0 | - 0 | - 0 |
| Payment to refund | - 0 | - 0 | - 0 | - 0 | - 0 |
| Total Other financial sources | (14,813,686) | 5,025,649 | 2,261,860 | 11,177,455 | 3,651,278 |
| Net Change in Fund Balance | 7,095,156 | (6,398,032) | - 0 | 1,160,936 | 1,857,160 |
| Fund Balance July 1, 2005 | 19,192,584 | 7,200,218 | - 0 | 4,703,756 | 31,096,558 |
| Fund BalanceJune 30, 2006 | $ 26,287,740 | $ 802,186 | $ - 0 | $ 5,864,692 | $ 32,953,718 |
