Use the financial statements from Charlottesville, Virginia (Module4PartC.xlsx attachment), to conduct your analysis. Two years are provided so that a comparison between years can be made. Students are advised to use the format in the spreadsheet Financial Statement Example_Ratios.xlsx found in Lesson 3 and add an additional column for FY 2005 so that the ratios can be compared side by side. (Please note that NPS used in the days payable ratio is 20 percent of the total expenditures.).

Use the financial statements from Charlottesville, Virginia (Module4PartC.xIsx attachment), to conduct your analysis. Two years are provided so that a comparison between years can be made. Students are advised to use the format in the spreadsheet Financial Statement Example_Ratios.xIsx found in Lesson 3 and add an additional column for FY 2005 so that the ratios can be compared side by side. (Please note that NPS used in the days payable ratio is 20 percent of the total expenditures.) \begin{tabular}{|c|c|c|c|c|c|} \hline City of Charlottesville Virginia & & & & & \\ \hline Statement of Net Assets & & & & & \\ \hline June 30,2005 & c. & Capital & Social & Other & \\ \hline i. & General & Projects & Services & Gov't. & \\ \hline & Fund & Fund & Eund & Eund & Total \\ \hline Assets & % & & & & \\ \hline Cash & 17,455,863 & 3,889,312 & 108,907 & 4,334,506 & 25,788,588 \\ \hline Investments & & & & 599 & 599 \\ \hline Accounts Recoivablo & 1,358,985 & 16,164 & 6,263 & 700,456 & 2,081,868 \\ \hline Taxes Receivable & 21,203,551 & & & & 21,203,551 \\ \hline Specal assessments rocelvable & & 16,813 & & & 16,813 \\ \hline Due from other governmerits & 3,363,801 & 4,819,047 & 782,115 & 5,277,677 & 14,242,640 \\ \hline Due from other funds & 3,113,737 & & & & 3,113,737 \\ \hline Loans receivable & & 1,828,518 & & 148,543 & 1,975,061 \\ \hline Accrued interest recelvable & 216.489 & 297.000 & = & 10 & 513,499 \\ \hline Total Assets & 46,712,426 & \$ 10,864,854 & 897,285 & 10,461,791 & 68,936,356 \\ \hline & & & & & \\ \hline Liabilities \& Fund Balances & & & & & \\ \hline Llabilites & & & & & \\ \hline Accounts payable & $1,467,986 & $3.322,474 & $92,249 & $3,284,540 & $8,167,249 \\ \hline Accrued liabilies & 2,815,039 & 24,000 & 230.255 & 171,488 & 3,240,782 \\ \hline Due to other governments & & s. & & 108,543 & 108,543 \\ \hline Due to other funds & & & & 1,848,853 & 1,848,853 \\ \hline Doforred revenue & 23.236 .817 & 21.162 & 574.781 & 344.611 & 24.177 .371 \\ \hline Total Liabilites & $27,519,842 & $3,367,636 & $897,285 & $5,758,035 & $37,542,798 \\ \hline 7 & & & & & E \\ \hline Fund Balances & & & & & \\ \hline Reserved & $979,023 & $5,684,987 & & $788,797 & $7,452,807 \\ \hline Unreserved, designated: & & & & & * \\ \hline General Fund & 1,118,013 & & & & 1,118,013 \\ \hline Copital Projocts Fund & & 1,515,231 & & & 1,515,231 \\ \hline Debt Service Fund & & & & 3,914,959 & 3,914,959 \\ \hline Unreserved, undesignated: & & & & & - \\ \hline General Fund & 17.095 .548 & & & = & 17,095.548 \\ \hline Total Fund Balances & $19,192,584 & $7,200,218 & s & $4,703,756 & $31,096,558 \\ \hline Total Liabilities and Fund Balances & $46,712,426 & $10,567,854 & $897,285 & $10,461.791 & $68,639,356 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline City of Charlottesville Virginia & & & & & \\ \hline Statement of Net Assets & & & & & \\ \hline June 30,2006 & . & & & & \\ \hline & & Capital & Social & Other & \\ \hline - & General & Projects & Services & Gov't. & \\ \hline & Fund & Fund & Eund & Eund & Total \\ \hline Assets & & : & & & \\ \hline Cash & is 25,540,244 & & 156,943 & $5,462,149 & \$ 31,159,336 \\ \hline Investments & - & & - & 600 & 600 \\ \hline Accounts Receivable & 1,046,166 & 2,295 & 3,893 & 35,610 & 1,087,964 \\ \hline Taxes Receivable & 24,319,651 & - & - & - & 24,319,651 \\ \hline Specal assessments receivable & - & 16,813 & - & - & 16,813 \\ \hline Due from other governments & 5,055,427 & 5,195,502 & 705,290 & 3,178,186 & 14,134,405 \\ \hline Due from other funds & 3,269,698 & 506 & - & - & 3,270,204 \\ \hline Loans receivable & & 3,192,556 & - & 143,723 & 3,336,279 \\ \hline Accrued interest receivable & 9.972 & = & = & 10 & 9.982 \\ \hline Total Assets & $59,241,158 & 8,407,672 & $866,126 & $8,820,278 & $77,335,234 \\ \hline & & + & & & \\ \hline Liabilities \& Fund Balances & ? & & & & \\ \hline Liabilities & - & & & & \\ \hline Accounts payable & 1,727,186 & 2,625,763 & 111,167 & 1,291,934 & 5,756,050 \\ \hline Accrued liabilties & 3,644,356 & 8,612 & 210,905 & 190,381 & 4,054,254 \\ \hline Due to other governments & - & - & - & 134,281 & 134,281 \\ \hline Due to other funds & - & 1,756,310 & - & 1,211,616 & 2,967,926 \\ \hline Deferred revenue & 27.581 .876 & 3.215 .701 & 544.054 & 127.374 & 31.469 .005 \\ \hline Total Liabilities & 32,953,418 & 7,606,386 & 866,126 & 2,955,586 & 44,381,516 \\ \hline & & & & & \\ \hline Fund Balances & & & & & \\ \hline Reserved & 715,230 & 20,257,807 & - & 901,885 & 21,874,922 \\ \hline Unreserved, designated: & - & & & = & - \\ \hline General Fund & 3,921,815 & - & ain & - & 3,921,815 \\ \hline Capital Projects Fund & - & (19,456,521) & - & - & (19,456,521) \\ \hline Debt Service Fund & - & - & - & 4,962,807 & 4,962,807 \\ \hline Unreserved, undesignated: & - & - & - & - & - \\ \hline General Fund & 21.650 .695 & = & = & + & 21.650 .695 \\ \hline Total Fund Balances & 26,287,740 & 801,286 & & 5,864,692 & 32,953,718 \\ \hline Total Liabilities \& FB & $59,241,158 & 8,407,672 & $866,126 & 8,820,278 & \$ 77,335,234 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{\begin{tabular}{l} City of Charlottesville \\ Statement of Revenues, Expenditures and Changes in Fund Balances \end{tabular}} \\ \hline \multicolumn{7}{|c|}{ Statement of Revenues, Expenditures and Changes in Fund Balances } \\ \hline \multicolumn{7}{|c|}{ Governmental Funds } \\ \hline \multicolumn{7}{|l|}{ For the Yoar Ended June 30, 2005} \\ \hline & & Capital & Social & Other & & \\ \hline & General & Projects & Services & Gov't. & & \\ \hline & Fund & Fund & Fund & Eund & Total & - \\ \hline Revenues & & & & & & \\ \hline Taxes & 73,521,654 & - & & - & 73,521,654 & \\ \hline Fees \& Permits & 1,553,833 & . & - & - & 1,553,833 & \\ \hline intergovernmental & 19,629,915 & 8,937,858 & 9,819,003 & 12,830,816 & 51,217,592 & \\ \hline Charges for Services & 4,420,205 & - & & 3,285,459 & 7,705,664 & \\ \hline Fines & 541,733 & - & - & & 541,733 & \\ \hline Investment Earnings & - & 90,121 & & 3,247 & 93,368 & \\ \hline Miscellaneous & 1.400 .939 & 237.422 & 26.751 & 220.515 & 1.885 .627 & \\ \hline \multirow[t]{2}{*}{ Total Revenue } & 101,068,279 & 9,265,401 & 9,845,754 & 16,340,037 & 136,519,471 & + \\ \hline & & & & & & \\ \hline \multicolumn{7}{|l|}{ Expenditures } \\ \hline General Government & 10,293,731 & 540,328 & - & - & 10,834,059 & \\ \hline Public Safety & 22,388,096 & - & - & 3,962,105 & 26,350,201 & \\ \hline Community Services & 6,299,314 & 2,066,346 & . & 4.440,075 & 12,805,735 & \\ \hline Health \& Welfare & 3,385,595 & 213,015 & 11,986,071 & 9,437,130 & 25,021,811 & \\ \hline Parks, Recreation \& Culture & 6,624,111 & 753,057 & - & 136,810 & 7.513,978 & \\ \hline Education & 31,133,916 & 661,986 & - & & 31,795,902 & \\ \hline Conservation \& Development & 3,259,330 & 1,898,156 & & 1,339,792 & 6,497,278 & \\ \hline Other Activites & 167,858 & - & - & & 167,858 & \\ \hline Debt Services & - & - & - & 5,529,690 & 5,529,690 & \\ \hline Capital Outlay & & 23,908,132 & = & = & 23.908 .132 & \\ \hline Total Expenditures & 83,551,951 & 30,041,020 & 11,986,071 & 24,845,602 & 150,424,644 & \\ \hline \multirow[t]{2}{*}{ Net } & 17,516,328 & (20,775,619) & (2,140,317) & (8,505,565) & (13,905,173) & \\ \hline & . & & & & +1 & \\ \hline \multicolumn{7}{|l|}{ Other Financing Sources } \\ \hline Transfers from other funds & 4,403,507 & 5,726,162 & 2,140,317 & 10,652,361 & 22,922,347 & \\ \hline Transfers to other funds & (16,578,460) & (1,561,643) & - & (20,602) & (18,160,705) & \\ \hline Proceeds from dobt issuance & & 19,962,475 & - & . & 19,962,475 & \\ \hline Refunding bond issued & & - & - & 2,913,333 & 2,913,333 & S \\ \hline Payment to refund & = & = & & (3.043.650) & (3.043.650) & 2 \\ \hline \multirow[t]{2}{*}{ Total Other financial sources } & (12,174,953) & 24,126,994 & 2,140,317 & 10,501,442 & 24,593,800 & \\ \hline & & & & & & \\ \hline Net Change in Fund Balance & 5,341,375 & 3,351,375 & . & 1,995,877 & 10,688,627 & \\ \hline \multirow[t]{2}{*}{ Fund Balance - July 1, 2004} & 13.851 .209 & 3.248 .643 & & 2.707 .879 & 20.407 .931 & \\ \hline & & & & & & a \\ \hline Fund Balance - June 30, 2005 & $19,192,584 & \& 7,200,218 & $ & \& 4,703,756 & \$ 31,096,558 & \\ \hline \end{tabular}