70.2K

Verified Solution

Link Copied!

The financial statements are from Charlottesville, Virginia, to complete a comparison. The statement below are from the year 2013 is in Tables 26.2 and 26.3; the statement from 2012 is provided in Tables 26.6 and 26.7. Statements from two years are provided to allow a comparison between years. Use the format in Table 26.6 and add an additional column for FY2012 so that the ratios can be compared side by side.

Table 26.2: Statement of Financial Position (Balance Sheet), Government Funds Governmental Funds City of Charlottesville, Virginia June 30, 2013 capital Debt Social Other General Projects Service Services Gov't. Fund Fund Fund Fund Fund Total Assets: Cash & Cash Equivalents $ 18,737,769 $ 11,605,320 $ 12,201,576 $ 77,878 $ 1,122,150 $ 43,744,693 Investments 14,810,113 14,818,113 Interest receivable 71,632 71,632 Accounts receivable, net 283,472 5,830 15,188 304,490 Taxes receivable, net 29,142,873 29,142,873 Special assesments receivable 3,997 3,997 Due from other governments (note 7) 2,967,586 4,532,258 512,808 5,363,027 13,375,679 Due from other funds (note 8) 3,372,154 3,372,154 Loans receivable (note 5) 1,100,000 1,214,601 2,314,601 Total Assets 69,393,599 17,241,575 12,201,576 596,516 7,714,966 107,148,232 Liabilities & Fund Balances Liabilities: Accounts Payable 920,469 4,594,182 22,317 382,480 5,919,448 Accrued liabilities 2,594,499 30,790 179,381 1,241,084 4,045,754 Due to other governments 1,211,471 1,211,471 Due to other funds (note 8) 35,116 3,227,952 3,263,068 Deferred Revenue 27,972,383 27,972,383 Total Liabilities 31,487,351 4,594,182 30,790 236,814 6,062,987 42,412,124 Fund Balances: Nonspendable 1,100,000 172,501 1,272,501 Restricted 545,723 8,950,111 359,702 176,222 10,031,758 Committed 6,737,955 2,597,282 12,170,786 21,506,023 Assigned 3,633,160 1,303,256 4,936,416 Unassigned 26,989,410 0 26,989,410 Total Fund Balances 37,906,248 12,647,393 12,170,786 359,702 1,651,979 64,736,108 Total Liabilities & Fund Balances $ 69,393,599 $ 17,241,575 $ 12,201,576 $ 596,516 7,714,966 107,148,232 Total Fund Balances 64,736,108 Capital assets 202,407,200 Proporty taxes receivable 544,516 Net OPEB asset 708,822 Internal Service funds 11,775,338 Accrued interest payable (873,896) Unamortized premium on bonds (4,170,431) Bonds & Notes Payable 79,149,240 Deferred amount of refunding (1,006,410) Compensated absences (2,044,825) Net Position of Government Activities $ 192,927,182Table 26.3 Statement of Revenues, Expenditures & Changes in Fund Balances Governmental Funds City of Charlottesville, Virginia for the year ended June 30, 2013 Capital Debt Social Other General Projects Service Services Govt Fund Fund Fund Fund Funds Total Revenues Taxes S 95,714,241 S $ $ $ 95,714,241 Fees & permits 2,464,889 2,464,889 Intergovernmental 30,031,104 7,705,746 185,173 8,624,926 13,668,093 60,215,042 Charges for Services 5,731,381 4,875,921 10,607,302 Fines 392,763 392,763 Investment earnings 239,096 5,412 32,149 276,657 Miscellaneous 810,274 3,754,121 22,383 193,448 4,780,226 Total Revenues 135,383,748 11,465,279 217,322 8,647,309 18,737,462 174,451,120 Expenditures Current: General Government 14,438,666 913,557 15,352,223 Public Safety 31,444,547 118,276 424,609 31,987,432 Community service 7,933,104 2,309,752 8,281,270 18,524,126 Health & welfare 5,012,504 11,899,321 14,284,562 31,196,387 Parks, recreation & culture 11,355,857 796,468 77,414 12,229,739 Education 43,065,839 2,460,328 45,526,167 Conservation & development 4,899,680 2,858,009 1,006,943 8,764,632 Other activities 266,562 266,562 Debt Service: Principal 6,430,175 6,430,175 Interest 2,452,754 2,452,754 Miscellaneous 87,599 87,599 Capital Outlay 21,380,655 21,380,655 Total expenditures 118,416,759 30,837,045 8,970,528 11,899,321 24,074,798 194,198,451 Revenues over Expenditures 16,966,989 (19,371,766) (8,753,206) (3,252,012) (5,337,336) (19,747,331)Other Financing Sources (uses) Transfers in 5,608,472 7,810,768 9,671,009 3,127,218 4,829,576 31,047,043 Transfers out (24,751,601) (319,874) (37,298) (25,108,773) Issuance of debt 5,610,000 5,610,000 Premium on issuance of debt 427,859 427,859 Total other financing sources (19,143,129) 13,528,753 9,671,009 3,127,218 4,792,278 11,976,129 Net change in fund balances (2,176,140) (5,843,013) 917,803 (124,794) (545,058) (7,771,202) Fund Balance - July 1, 2012 40,082,388 18,490,406 11,252,983 484,496 2,197,037 72,507,310 Fund Balance - June 30, 2013 37,906,248 12,647,393 12,170,786 359,702 1,651,979 64,736,108 Net Change in Fund Balances (7,771,202) Differences Change in capital assets 22,573,753 Depreciation expense Change in school capital assets less revenues not reported in funds Pg (8,291,446) (5,327,130) (173,301) Debt proceeds 392,316 Changes in interest 181,491 Compensated absences (61,076) Net OPEB obligation 26. 6 708,822 Net internal service funds 1,563,659 Change in Net position of Governmental Activities $ 3,795,886Table 26.6: Statement of Financial Position (Balance Sheet), Government Funds Governmental Funds City of Charlottesville, Virginia 30-Jun-12 capital Social General Projects Services Fund Fund Fund Assets: Cash & Cash Equivalents 34,198,840 $ 18,734,173 $ 104,507 Interest receivable 51,752 Accounts receivable, net 294,821 8,429 Taxes receivable, net 28,733,247 Special assesments receivable 16,813 Due from other governments (note 7) 2,971,744 1,076,694 690,794 Due from other funds (note 8) 4,640,987 Loans receivable (note 5) 880,000 Total Assets 70,891,391 20,707,680 803,730 Liabilities & Fund Balances Liabilities: Accounts Payable 720,740 2,217,274 21,152 Accrued liabilities 2,595,114 207,020 Due to other governments Due to other funds (note 8) 91,062 Deferred Revenue 27,493,149 Total Liabilities 30,809,003 2,217,274 319,234 Fund Balances: Nonspendable 3,143,710 Restricted 472,056 15,346,696 484,496 Committed 8,206,185 Assigned 4,542,491 Unassigned 26,861,656 Total Fund Balances 40,082,388 18,490,406 484,496 Total Liabilities & Fund Balances 70,891,391 20,707,680 803,730 Total Fund Balances Capital assets Proporty taxes receivable Page 1 / 2 + Net OPEB asset Internal Service funds\fTransfers out (26,121,631) (543,095) Issuance of debt 9,133,200 Refunding bonds issued Premium on issuance of debt 898,495 Payment to refunding bond escrow agent Sale of capital assets 352,000 Total other financing sources (20,713,660) 17,179,269 2,969,405 Net change in fund balances (61,913) (4,769,476) (3,547) Fund Balance - July 1, 2012 40,144,301 23,259,882 488,043 Fund Balance - June 30, 2013 40,082,388 18,490,406 484,496 Net Change in Fund Balances Differences Change in capital assets Depreciation expense Property taxes Gain on sale of assets New Debt Issued Principal payments Changes in interest Amortization of bond premium Amortization of deferred amount of refunding Compensated absences Net internal service funds Change in Net position of Governmental Activities

Answer & Explanation Solved by verified expert

See Answer