Loading...
HomeMy WebLinkAbout2011 Redevelopment Authority & Building Corporation Report Finalaw City of South Bend Redevelopment Authority and Building Corporation 2011 Financial Reports Prepared by - Department of Administration and Finance September 11, 2012 (Information obtained from the City of South Bend Comprehensive Annual Report (CAFR) for the year ended December 31, 2011) City of South Bend, Indiana Redevelopment Authority and Building Corporation Financial Statements December 31, 2011 - -- College Football Redevelopmem Redevelopment Hell of F.- Bond Bond Debt service Central Dev. Airport Tenable City of South Bend Redevelopment Authority- ------ Redvolopmem Redevelopment Rodevelopmenl Blackthorn Bond Author" Authority Golf Courao Pelais Ro ale Dobf Somice Goneral Enterprfi,e Fund Eddy Str-1 Common., Constmcflon Century Center Construelion Total Redvelopment Authority South Bend Building Coporation Debt Sorvlee Cash and cash equivalents 5201.062 ; $262.040 $330,984 _ 5553.020 ;- - $4,530,966 $10,989 _ $53.250 $2,306.465 s0 I $8.248.776 $570,448 1 Restricted cash 0. 0 i 0 0 0' 0 723.753 O 0` 723,753 0 Irrvestmenls _ _ 408.121 560,756 ; 7081293 1,183,443 0 : 23.515 668,200.1 0_- 0 3,552.328 0 I Accounts receivable - - - - I 5.900 _ 0 '` 0 -- 0 8888_ 0 _ _ 0 _0 _ _ _ 0 • 0 5,900 0 , Interest rectdwdble -_ 579 634 f _ 1.090 -- 1,734 _ _ _ _ _ 0 - - - _ _ 35 _ _ 996 , _. 0 I _ _ _ 0 5.268 0 I Prepaid 0ems 0 _ 0 _ 0 -- 0 ; - - - - - 0 1 _ -- 0. , _ _ _ _ 3.184: _ - 0 . 0 _ i 3.184 _ 0 ; Inventories 0 0 0 : 0 0 0 22,654 0 0 22,654 0 ' - - - -- - Unamorttzed debt Issue Costs 0 0 _ 0 ; - - 0 i_ _ _ -- -•_ _ 0., _ --- - _ 0 5,058 a - 0 0 5.058 0 -- - -- -- Land and construction In progress. _ -- 0 ; 0 ` 0 , 0 } _ _ 0 , _ _ _ 0 ! _ ... 448.469 _- _ . 0 _ _ _ 0_[ _ 448,469 0 Other capital assets (nel of accumulated depn) 1 0 , 0 0 0 1 0 0 2.177 198 0 0 , 21177,196 0 _ 615,662. _ - 823,630 ; 1 040,367 . . _1,738.1 97 �_ 4,530,986 ; - 34 539. _ 4.102 766 • _ 2,306,465 _ _ - 0 ' 15,192,586 570.448 Ua it - - - -_ - f _ _ I _ -- -- - - - _ -- _ _ - Accounts payable - - - - - - -- - -- -__- - -- 0 1 _ - - 0 _ 0 r o 0 0 - -0 8,599 - 0 - -- - 0 8.599 0 InleAund payable. _ , 0; 834 _ 1,090., 1,734 0, 994 8888_ 0 _ _0 6 4,652 0' Taxes payable . 0 0 [ 0 01 _ 0 0 [ 289 0 289 _ 0 ; __ _- . _ Revenue Bonds payable ! 0 0 ;_ 0 0 1 0 ; 0 : 1,178.682 0 . 0 ; 1.178.882 - 0 Cadtallease; payable i 0- 0 _- 0 0' Q' - 01- - ---201.935 i-- - 0' -- - -- 0 -- 201.935 - 0 . ___ -- _ -- -- AccruedlnterestPayable _ _ _ _ _ 0 _ •_ -- 0 • - -- _ -- 0 i . -- _ _0 [ -. Q ,- 0 - - --.- 0 : . -_ 21.129 • - -- _ 0 1 0 _0 [ 0. _ 21,129 1.759.923 _ _ _0 . 0 Advances from 00ter Funds - 0 - - -- - 0' 0! - --1.080 0 I - - - 0 - 1.759.923 I • Total 0ab11Rles 0 I 834 J , _ _ 1 734 ---- 0 _ 0 3.171,751_ -_ _ 0 1- -- _ -- -- 0 J.. 3,175,409_ 0 _ --- . - — -- — -. - - - -1 -_ 1 534,539 i $12,017,177 $570,446 _5815.862 $822,796 - ..$1.039.277 i $1,736,463 54,530,966 1 - $931,009 _ $2,306,465 _ _ $0 i Restricted — - - -- fi -- -) - - 6-115.6-6-2 , -0 822,796 j - 1,039.277 , -0 1.736.463 1 _ -- - - 4.530,966 • 0 - _ 0 2,308,465 0 1 - 0 I 11,051.829 34.539 570,448 0 Ass ad -� - - -. _.,._ 0 0 _ [ 0 I 0 �- 0 - 0 . _ 0 34 539 I._ 0 0j 7244_848 0 0 1 7.244,848 0 f Invested In capitat assets, ne_ t of related debt _ „ _ __ -0 , ___ __ -_, _ _ _ _ . _ _ _ _ _0 _ __ Restricted for debt service 0 L__ 0 I 0 0 , - . _ 0 _ _ _ 0 -� 708,88 - _ 0 _ -_ 0 I _ 708,678 - -_ - 0 _ _ Unrttsbtded - ., 0 - -- ._ - 0[ - -_ _ 0 _ __ . 0 I- 0 0 ` 1 0( 22,517) 0 0 j (1.022.517) 0 Totattund- balancs/nalassets s615w_662 $522_7961 $1039.27'7 57,736,463 534.539 5931,009 52,3084651 SO $12,017,177 $570.448 InWrOeS�titemens _54,530,986 .i . - --- - - -- - -- - ._. _ -- -- - It ---- Protieity taxes - -- j 51.549,954-.._ --- - S.0.1 .. - s0 - _ _ 50.; - - $0 - - --. - SO I - $0 -- -- 0 SO 0 - $0 , 0 - 1.549,954 - 107,203 _ - $0 0. inler9ovemmental 107203 ; - -_ -- 0 1- - 0 • __ _ -- 0 0 : 0 - 0-1-- O I - ...-1.392.999 -- -- -- 0 i - - -- 0 ---- - ----- - 0 j - 1,392.999 0 Goff course fees . - - -- . -- _ -- Otlter _ -0 _ 5.899 1 0- 0 _ - - -. 0 0 [ -- -- -0 , - 8 _ - - -- _0 - -- I - - O i --- -'0. -- - 0� 5.907 _- _- -- 0 - -- - ------ Interest earnings --t- - --- 820 3.238 i -- 6,-382 I - 5163 2.706 142 i 0 1_ 1.006 �� O I- 19.457 - -- - 761 - -- - Total revenue - 1,883,6 6 { - 3,236 i _ ..1 - 6,362 - 5,763 _ 2,714 142 .I - - 1,392,999 I 1,008 .. - -- .0 .1 3,075,520 -- 78 I ' 1,262.209 ' ns Operatio and maintenance ! 0 -- - - 0 1 0 - 0 _ 0 _ 0 1.262,209 .0 0 L - 0 Adm nlstra6ve and general_ 0 1 0 . _ 0 1 0 . - -- 0- ._ _ . _ - . 0 -_ _ 164.578 1 _ - - 0.1 - - - 0' 164.578 0 1 - - -- Depredation - -- 0-1 -- 0 L 0 ; - 0' 0 --- 0 I .... .- 155.177 j - ° -_ 0 _ --- - _- 0 155,177 _ .. 01 CaPllat ou0ay__- acongmic development - , i _ - - 0 - _ 0 � - _- - O j - _ _ - - 0 [ _ - 0 { _ - .5.0711 _ _ 0 1 158,080 '• 61 163,131 _ 88 _ 0. Capital outlay culture and recreation I 0 - 0 - - 0. i 0 1 0 ,. • 2,326 0 i_- 0 - -0 0 0 _ 0 0 ' _ 0 I _ 0 3.265,000 88 0. 1,392,805 1 Debt service pnrklpal- _- -- Debi service interest and fiscal charges- DeMservice- bond issuan wsls ce ,_ _ ' I 94.0 000 _ 462.038 8 ! _ 133257 ' 0 : 0 0 i 0 i 0 ; 0 ' 0 - - -0 0_ • .000 I 2 621.573 • -_ _ 0 • - - 0 - -- 0 L - 0 i _ ,•_ - _ 0 0 _ _ _ 0 0 _ 3.083.611 187.897 _ _ . _ 920.307 ' 0 TolaltBlpentil I sf" lenses _ 1.535,295! '- -_ -' -0_! _ 0.11 --- _ _ 01 -- 5.001,213! _ _5,071 1- "-- 1.581,984 1 - -- 156, -060 �-' -_--0 ; 8,281.603 _ _ _ 2.313,1121 -- Net revenue less expendNu sfexpensos_ _ 126,561 _ 3,230 ; 6,382 1 _ 5,183 (4,996,4")_L -_ (4 828) - (168 965 !_ (157,054 - - -0 - -- 5 06 083) 1 .2 , - - -- (2,313,034)] -, -- =- I Qfh�r r ancimdnon Un Item; I - -_ Fr- Transfers ln — - Transfers out 92,964 I 0 1 -- 0 - (2.902 ___ 0 _- - - _(886,711)! - _ _ 640,792 (4_540 4.958.092 (1 277)1 - _ -_ 0 i - _ 0� -0 651,500 I - ( ?SOS _ 1,277 O -_ 0 -, (92) 6,344.645 (699.067) - _ 2,316,386 -i 0. _ _-- - - Intereslreyenue -' - - 0' 0 [ 0 0 I 0I- i 3_54e 0._- - 0 _ 1.544 0 interest expense - _ _ - -_ -� -- -- O. i - - - -- 0 t- - --_ _ -- 0 1- - _ -- _ -- -.- O 1, -.- _ _ _.9J .. o I — - - -� 1- . (103._6112. _ o _ .. 0 1_ O I (101.841) - _ 0 Amortizallon expense _- Premium on debt issuance _ - -_ 0 . 0 0 _ _ o ; - 0 1 _ _ 0 I 01 _ 26,877 1 0 ; 0' _ ol 01__ 0 1 26,817 0 City of South Bend, Indiana Redevelopment Authority and Building Corporation Financial Statements December 31, 2011 - -- -City of South Bend Redevelopment Authority-- -. - - -- -- -- College Football Red.vetopment Red.— I.preent Redvelopment R.develop —M Redevelopment Bl.ckthom Eddy Street Century Total South Bend NO of F.— Bond Bond Bond Authority Authority Galf Course Common. Center RedvolopmoM Building Coporetion Debt service Central Dv. JUM20 Tueble P.IMs R ale Debt Service General Enterprise Fund Constru.1ion Construction Author' Debt Service Issuance of refunding bonds_ I 7,580,000 0 ; 0 0 i 2,980,000 0 0 0 0 10,560.000 0 --- -- _ -• -- _ _ __ _ , _ _ -- .. (3237 • -- 0 _ - - _ 0 (3,237) - _ . _ _ t7, _ 01). - - -� _ _ _ 0. (10.875.740) 01 - ___ -_ - Tot�slaotharrfinancint noeppera0 gReam I- — 7i, n){ (2,9421; (886,71 636.252 - 4( 688,659) 0 541461) 1,277 (92)_ I - 5.053,181 6 2,316,388 i Net.ohangeslniundbalances -- 199,8581 -_296 - (880,329) ;- 641,415 _'(308-.840) 355,488; (155,777) (92)1 (152,902) 3,3521 Fund balanceMetassets- beginning -- 415.804 822500 1,919,606 1,095.048 - 4.819.8061 - 39.488 ( 575.513 1 - - 2.482.242 92 12.170.079 567,096 Fund balance/netassets- ending i 1615.882 , .$822,796 1 .$1,039,277 31,7 6.463 ; $4,530,966 i - - $34,519 1 f931_.009 ' $2,306,465 1 SO $12.017,177 5570.448 The Redevelopment Authority and Building Corporation are presented as blended component units In the City of South Bend 2010 Comprehell a Annual Financial Report. -.1 Redevlopment Authority Revenue - 2011 $1,549,954 7$23,001 ,203 1,392,999 $6,344,645 , $10,560,000 M Property taxes ■ Intergovernmental ❑ Charges for services O Interest earnings ■ Issuance of refunding bonds © Other ■Transfers in Revenue Amount Property taxes $1,549,954 7.75% Intergovernmental 107,203 0.54% Charges for services 1,392,999 6.96% Interest earnings 23,001 0.11% Issuance of refunding bonds 10,560,000 52.77% Other 32,784 0.16% Transfers in 6,344,645 31.71% Total Revenue $20,010,586 100.00% Redevelopment Authority Expenditures - 2011 10,875,740 77 3,131 3,265,000 ,452 Operations and maintenance ■Administrative and general DDepreciation 3 Capital outlay ■ Debt service - principal © Debt service - interest I Debt service - bond issuance O Payment on bond refunding ■ Other (Transfers out Expenditures Amount Percent Operations and maintenance $1,262,209 6.26% Administrative and general 164,578 0.82% Depreciation 155,177 0.77% Capital outlay 163,131 0.81% Debt service - principal 3,265,000 16.19% Debt service - interest 3,187,452 15.81% Debt service - bond issuance 187,897 0.93% Payment on bond refunding 10,875,740 53.94% Other 3,237 0.02% Transfers out 899,067 4.46% Total Expenditures $30,163,488 100.00% Building Corporation Revenue - 2011 Revenue Amount Percent Interest earnings $78 0.00% Transfers in 2,316,386 100.00% Total Revenue $2,316,464 100.00% Building Corporation Expenditures - 2011 $920,307 $1,392,805 ■ Principal ■ Interest Expenditures Amount Percent Principal $1,392,805 60.21% Interest 920,307 39.79% Total Expenditures $2,313,112 100.00% un Assets Cash and cash equivalents Cash with fiscal agent Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Intergovernmental Loans Interfund receivable: Interfund loans Interfund services provided and used Advances to other funds Property held for sale Total assets Liabilities and Fund Balances Liabilities: Accounts payable Accrued payroll payable Interfund payable: Interfund services provided and used Performance deposits payable Other current payables Advances from other funds Total liabilities Fund balances: Nonspendable: Noncurrent loans receivable Property held for resale Advances to other funds Restricted Committed Assigned Unassigned Total fund balances Total liabilities and fund balances CITY OF SOUTH BEND COMBINING BALANCE SHEET - NONMAJOR GOVERNMENTAL FUNDS December 31, 2011 (Continued) $ 201.062 $ Debt Service $ 330,984 $ 159,064 $ 553,020 $ Redevelopment Redevelopment Coveleski Redevelopment 560,756 College Football Bond - Bond - Bond Bond - Redevelopment Hall of Fame Central Airport Debt Service Palais Authority Debt Service Development Taxable Reserve Royale Debt Service $ 201.062 $ 262,040 $ 330,984 $ 159,064 $ 553,020 $ 4.530,966 408,121 560,756 708,293 340,392 1,183,443 579 834 1,090 506 1,734 5,900 4,530,966 $ 1;738,197 $ S 1,040,367 $ 499,962 $ 823,630 $ 615,662 $ $ $ S $ $ 834 1,090 1,734 1,734 1,090 834 615,662 822,796 1,039,277 499,962 1,736,463 4,530,966 615.662 822,796 1,039,277 499,962 1,736,463 4,530,966 $ 615,662 $ 823,630 $ 1,040,367 $ 499,982 $ 1,738,197 $ 4,530,966 Continued on next page Assets Cash and cash equivalents Cash with fiscal agent Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Intergovernmental Loans Interfund receivable: Interfund loans Interfund services provided and used Advances to other funds Property held for sale Total assets CITY OF SOUTH BEND COMBINING BALANCE SHEET - NONMAJOR GOVERNMENTAL FUNDS December 31, 2011 (Continued) $ 153,173 $ Capital Projects Morris Community Performing TIF Revitalization Arts Center TIF Leighton TIF - West Redevelopment Enhancement Capital Downtown Plaza Washington General District $ 153,173 $ 1,264,340 S 29,283 $ 296,875 $ 10.989 $ 447,697 - - 12,952 - - 327,784 2,705,643 62,665 635.302 23,515 6,112 $ 487 3,923 93 935 35 99 - 33,302 - 23,180 - 34 2.192 Interfund services provided and used 2,568 - Performance deposits payable 5,594,003 71,546 436,690 105,000 Other current payables $ 481,444 $ 9,603,813 $ 107,185 $ 1,392,982 $ 34,539 $ 552,796 rn Liabilities and Fund Balances Liabilities: Accounts payable $ 4,365 $ 142,310 $ 6,112 $ 381 $ $ Accrued payroll payable - - - Interfund payable: Interfund services provided and used 8,478 - Performance deposits payable 71,546 4,264 Other current payables - - Advances from other funds - - - Total liabilities 4,365 222,334 10,376 381 Fund balances: Nonspendable Noncurrent loans receivable - - - Property held for resale 5,594,003 436,690 105,000 Advances to other funds - Restricted _ 447,796 Committed 477,079 _ _ Assigned 3,787,476 95.809 955,911 34,539 Unassigned Total fund balances 477,079 9,381,479 96,809 1,392.601 34,539 552,796 Total liabilities and fund balances $ 481,444 $ 9,603,813 $ 107.185 $ 1,392,982 $ 34,539 $ 552.796 Continued on next page CITY OF SOUTH BEND COMBINING STATEMENT OF NET ASSETS - NONMAJOR ENTERPRISE FUNDS December 31, 2011 Continued on next page Consolidated Parking Solid Blacklhom Asses Building Garage Waste Golf Course Totals Current assets: Cash and cash equivalents $ 22,147 $ 291,474 $ 376.451 $ 53,250 $ 743,322 Investments 47,394 623,745 805,593 1,476,732 Interest receivable 70 927 1,825 2,822 Accounts receivable (net of allowance) 1,200 64 430.876 432,140 Interfund receivables - Interfund services provided and used 8,666 - 4,333 12,999 Inventories 22,654 22,654 Prepaid items 3,184 3,184 Restricted assets: Cash and cash equivalents: Revenue bond covenant accounts 723,753 723,753 Capital outlay accounts 5,041 - 5,041 Investments: Revenue bond covenant accounts 668,200 668,200 Capital outlay accounts 10,786 10,786 Cash with fiscal agent 45,126 45,126 Interest receivable 996 996 Total current assets 79,477 916,210 1,680,031 1,472,037 4,147,755 Noncurrent assets: Deferred charges: Unamortized debt issue costs - 5,058 5,058 Unamortized loss on sale/leaseback 2,250,595 2,250,595 , Total deferred charges 2.250,595 5,058 2,255,653 Capital assets Land and construction in progress 1,132,020 448,469 1,580,489 Other capital assets (net of accumulated depreciation) 56,790 3,869,177 1,179,765 2,177,196 7,282,928 Total capital assets 56,790 5,001,197 1,179,765 2.625,685 8,863,417 Total noncurrent assets 56,790 7,251,792 1,179,765 2,630,723 11,119,070 Total assets 136,267 8.168,002 2,859,796 4,102,760 15,266,825 Continued on next page co CITY OF SOUTH BEND COMBINING STATEMENT OF NET ASSETS - NONMAJOR ENTERPRISE FUNDS December 31. 2011 (Continued) Liabilities Current liabilities: Accounts payable Interfund payables: Interfund services provided and used Accrued payroll payable Compensated absences payable Taxes payable Current liabilities payable from restricted assets Revenue bonds payable Capital leases payable Accrued interest payable Total current liabilities Noncurrent liabilities: Advances from other funds Revenue bonds payable (net of unamorized discounts and deferred amount on refunding) Capital leases payable Unamortized gain on salelleaseback Total noncurrent liabilities Total liabilities Net Assets Invested in capital assets, net of related debt Restricted for debt service Restricted for capital asset outlays Unrestricted Total net assets Consolidated Parking Solid Blackthorn Building Garage Waste Golf Course Totals 253 52,552 183,942 8,599 245,346 2,146 74,301 994 77,441 24,845 52,925 77,770 42,697 47,085 - 89,782 289 289 - 590,000 590,000 7,672 256,116 47,207 310,995 32 5,204 21,129 26,365 77,645 52,552 619,573 668,218 1,417,988 - - 1,759,923 1,759,923 - 588,882 588,882 28,050 576,458 154,728 759,236 14,891 14,891 28,050 14,891 576,458 2,503.533 3,122,932 105,695 67,443 1,196.031 3,171,751 4,540,920 21,068 5,001,197 347.191 1,244,848 6,614,304 - - 708,678 708,678 60,947 60,947 9,504 3,099,362 1,255,627 (1,022,517) 3,341,976 $ 30,572 $ 8,100,559 $ 1,663,765 $ 931,009 S 10,725,905 (o Assets Cash and cash equivalents Cash with fiscal agent Investments Receivables (net of allowances for uncollectibles): Interest Taxes Accounts Intergovernmental Loans Interfund receivable Interfund loans Interfund services provided and used Advances to other funds Property held for sale Total assets Liabilities and Fund Balances Liabilities: Accounts payable Accrued payroll payable Interfund payable: Interfund services provided and used Performance deposits payable Other current payables Advances from other funds Total liabilities Fund balances: Nonspendable: Noncurrent loans receivable Property held for resale Advances to other funds Restricted Committed Assigned Unassigned Total fund balances Total liabilities and fund balances CITY OF SOUTH BEND COMBINING BALANCE SHEET - NONMAJOR GOVERNMENTAL FUNDS December 31, 2011 (Continued) $ $ $ $ 576.679 $ 1,043,483 $ 1,587,655 - - 186,166 81,303 244,636 75,810 75,810 7,141 5,902,948 8,523,530 576,679 7,103,544 10,624,938 Capital Projects - 6,135,693 8,603,995 - - - 5,028.355 5,920.513 - 2,306,465 145,970 15,661,334 38,062,406 262,394 - 6,395,620 Total Airport Urban Century Eddy Street (2,777,374) (2,777,374) Nonmajor Enterprise Center Commons Equipment Governmental Zone Construction Construction Leasing Totals Funds $ 83,482 $ $ 2,306.465 $ 722,513 $ 16,928.513 $ 34,287,501 - - 12,952 12,952 178,649 - 28,786,454 48,672,455 263 136 42.763 79,922 5,213,918 5,213,918 134,245 344,853 149,248 450,044 - 10,347.788 - 25.000 2,568 7,439 5,028.355 5,920,513 6,135,693 8,603,995 $ 262.394 $ - $ 2,306,465 $ 722.649 $ 62,434.709 $ 113,966,380 $ $ $ $ 576.679 $ 1,043,483 $ 1,587,655 - - 186,166 81,303 244,636 75,810 75,810 7,141 5,902,948 8,523,530 576,679 7,103,544 10,624,938 7,280,301 - 6,135,693 8,603,995 - - - 5,028.355 5,920.513 - 2,306,465 145,970 15,661,334 38,062,406 262,394 - 6,395,620 11,829,074 24,887,537 34,422,527 (2,777,374) (2,777,374) 262,394 2,306,465 145,970 55,331,165 103,341.442 $ 262,394 $ $ 2,306,465 S 722,649 S 62,434,709 $ 113,966.380 CITY OF SOUTH BEND COMBINING BALANCE SHEET - NONMAJOR GOVERNMENTAL FUNDS December 31, 2011 (Continued) Debt Service Capital Projects South Bend Central Building TIF Erskine Emergency Development Professional Corporation Village Medical Area Bond Sports Debt Service Debt Service Totals Services Proceeds Development Assets Cash and cash equivalents $ 570,448 S 901,659 $ 7.509,243 $ 1.761,392 $ $ 351,219 Cash with fiscal agent - - Investments - 3.201.005 3,769,317 751,596 Receivables (net of allowances for uncollectibles). Interest 24 4,767 5.608 1,119 Taxes - - Accounts 5,900 124,650 Intergovernmental - 149,248 Loans Interfund receivable: Interfund loans Interfund services provided and used Advances to other funds Property held for sale - - Total assets $ 570,448 $ 901,683 $ 10,720,915 $ 5,660,967 $ $ 1,253,182 Liabilities and Fund Balances Liabilities: Accounts payable $ $ $ S 98,110 $ $ Accrued payroll payable Interfund payable. Interfund services provided and used 3,658 72,825 Performance deposits payable Other current payables Advances from other funds Total liabilities 3,658 170,935 Fund balances, Nonspendable: Noncurrent loans receivable - - Prop" held for resale Advances to other funds - Restricted 570,448 901,683 10,717,257 - 1,253,182 Committed - - - 5,490,032 Assigned Unassigned Total fund balances 570,448 901,683 10,717,257 5.490,032 1.253,162 Total liabilities and fund balances $ 570,448 $ 901.683 $ 10.720.915 $ 5,660.967 $ $ 1,253,182 Continued on next page CITY OF SOUTH BEND COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES - NONMAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2011 (Continued) Expenditures Debt Service Current Redevelopment Redevelopment Coveleski Redevelopment College Football Bond - Bond - Bond Bond - Redevelopment Hall of Fame Central Airport Debt Service Palais Authority Debt Service Development Taxable Reserve Royale Debt Service Revenues Economic development Taxes Culture and recreation Property $ 1,549.954 $ - $ - $ - $ $ - Professional sports development - 940.000 - - - - Community revitalization enhancement district - 462,038 Intergovemmental 107,203 133,257 - - - - Charges for services Capital outlay. Fines and forfeits General government - Interest 820 3,238 6.382 1.962 5.163 2.706 Donations Economic development - - - Sele of property - Other 5.899 1,535,295 8 Total revenues 1,663,876 3,238 6,382 _ 1,962. 5,163 2.714 Expenditures Current General government Public safety Highways and streets Economic development Culture and recreation " Debt service: Principal 940.000 - - - - 2,325.000 Interest and fiscal charges 462,038 2.621,573 Bond issuance costs 133,257 - - - - 54.640 Capital outlay. General government - Public safety Economic development - - - Culture and recreation Total expenditures 1,535,295 5,001,213 Excess (deficiency) of revenues over (under) expenditures 128,581 3.238 6,382 1,962 5,163 (4.998.499) Other financing sources (uses) Transfers in 92,984 - - 640,792 4,958,092 Transfers out - (2.942) (886,711) (4,540) (1,277) Debt issuance - - - - - - Premium on debt issuance - 26.877 Issuance of refunding bonds 7,580.000 - - - - 2,980,000 Payment to refunded bond escrow agent (7,601,707) (3,274,033) Total other financing sources and uses 71,277 (2.942) (886,711) 636,252 4,689.659 Net change in fund balances 199 858 296 (880.329) 1,962 641.415 (308.840) Fundbalances - beginning 415,804 822,500 1.919,606 498,000 1,095.048 4.839,806 Fundbalances - ending $ 615.662 $ 822,796 $ 1,039.277 $ 499.962 $ 1,736.463 $ 4,530.966 Continued on next page N CITY OF SOUTH BEND COMBINING STATEMENT OF REVENUES. EXPENDITURES, AND CHANGES IN FUND BALANCES - NONMAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2011 (Continued) Expenditures. Capital Projects Morris Current Community Performing TIF Revitalization Arts Center TIF Leighton TIF -West Redevelopment Enhancement Capital Downtown Plaza Washington General District Revenues: Taxes. Property $ $ 3.666.775 $ $ 454,265 $ $ Professional sports development - - - - - - Community revitalization enhancement district - - - - - 733,100 Intergovernmental - 400.000 720,000 - - - Charges for services 84.125 51,238 128,322 Bond issuance costs Fines and forfeits - - - Interesl 2.007 13,411 417 4.195 142 1,433 Donations General government - - - Sale of property - Public safety - Other 163 27,587 111,154 - 2,921,047 Total revenues 86.295 4.159,011 111,571 458,460 142 734,533 Expenditures. Current General government Public safety Highways and streets Economic development Culture and recreation - - Debt service Principal - 650,018 - - - 720,000 Interest and fiscal charges - 889.534 - - 128,322 Bond issuance costs - - Capital outlay. General government Public safety - Economic development - 2,921,047 159,399 506,726 5,071 - Culture and recreation 122,148 Total expenditures 122,148 4.460,599 159.399 506,726 5,071 848.322 Excess (deficiency) of revenues over (under) expenditures (35,853) (301,588) (47,828) (48,266) (4,929) (113,789) Other financing sources (uses). Transfers in 1,089,506 - Transfers out - (1,772,058) - - - - Debt issuance - - - - - Premium on debt issuance - - - - - - Issuance of refunding bonds - 17.358,395 - - - Payment to refunded bond escrow agent - (16 737,918) - Total other financing sources and uses (62.075) Net change in fund balances (35,853) (363,663) (47.828) (48,266) (4,929) (113,789) Fund balances - beginning 512,932 9,745.142 144,637 1,440,867 39,468 666,585 Fund balances - ending $ 477,079 $ 9.381,479 5 96,809 $ 1,392,601 $ 34,539 S 552,796 Continued on next page w CITY OF SOUTH BEND COMBINING STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN FUND NET ASSETS - NONMAJOR ENTERPRISE FUNDS For the Year Ended December 31. 2011 Operating revenues: Licenses and permits Parking fees Solid waste fees Golf course fees Other Total operating revenues Operating expenses. Operating and maintenance Administrative and general expense: Depreciation Total operating expenses Operating income (loss) Nonoperating revenues (expenses): Interest and investment revenue Interest expense Amortization expense Gain (loss) on disposition of assets Total nonoperating revenue (expenses) Income (loss) before contributions and transfers Transfers in Transfers out Change in net assets Total net assets - beginning Total net assets - ending Consolidated Parking Solid Blackthorn 12.756 Building Garage Waste Golf Course Totals $ 887,852 $ - $ $ $ 887,852 - 1,066,566 (40,025) (3,237) 1,066,566 3,464 - 4,830,342 (103,534) 4,830,342 - - (125,987) 1,392,999 1,392,999 7,773 4,512 651,500 12,285 895,625 1,071,078 4,830,342 1,392,999 8,190,044 28,294 (393.380) (125,987) 355,496 (135.577) 835,484 - 4,325,874 1,262,209 6,423,567 20,724 691,074 331,760 164,578 1,208,136 14,587 216,232 241,291 155,177 627,287 870,795 907,306 4,898,925 1,581,964 8,258,990 24,830 163,772 (68,583) (188,965) (68,946) 196 3,188 5,828 3,544 12.756 (504) - (23,207) (103,841) (127,552) - (560,340) (560,340) 3,772 (40,025) (3,237) (39,490) 3,464 (557,152) (57,404) (103,534) (714,626) 28,294 (393,380) (125,987) (292,499) (783,572) 651,500 651,500 (3.505) (3,505) 28,294 (393.380) (125,987) 355,496 (135.577) 2,278 8,493,939 1,789,752 575,513 10,861.482 $ 30,572 $_8,100,559 $ 1,663,765 $ 931,009 $ 10,725,905 a CITY OF SOUTH BEND COMBINING STATEMENT OF REVENUES. EXPENDITURES. AND CHANGES IN FUND BALANCES - NONMAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2011 (Continued) Expenditures Capital Projects Current Total General government Airport Urban Century Eddy Street - Nonmalor Public safety Enterprise Center Commons Equipment - Governmental Highways and streets Zone Construction Construction Leasing_ Totals Funds Revenues 9.628,545 Taxes - - - 1,085.158 Property S 123,165 $ - $ - S - S 17,585,163 S 19,135.117 Professional sports development 558,268 558,268 Community revitalization enhancement district - - - - 733,100 733.100 Intergovernmental - - - 2,822,793 16,398.075 Charges for services 2.010,500 4.062,827 Fines and forfeits - - 1,297,430 9.240 82,031 Interest 785 1,006 1,578 362,977 758,315 Donations - - - 3,660 20.524 Sale of property - - - - 62,158 77,035 Other 158,060 3.327,441 417,531 1,243.058 Total revenues 123,950 1,006 1.578 24,565,390 43,068,350 Expenditures Current General government - - - - 388,741 Public safety - - - - - 6,800,940 Highways and streets - - 1,998,189 Economic development 9.628,545 Culture and recreation - - - 1,085.158 Debt service Principal 5.649.793 11,003,596 Interest and fiscal charges 1,375,004 5,786.682 Bond issuance costs - 62.904 250.801 Capital outlay General government - - 1,297,430 1,420,492 1,420,492 Public safely 1,081,944 2,585.164 2.585,164 Economic development 158,060 - 8,798,765 8,798.765 Culture and recreation 948,067 6,421,455 6,421.455 Total expenditures 158,060 3.327,441 26,313,577 56,168,528 Excess (deficiency) of revenues over(under)expenditures 123,950 (157,054) (3.325.863) (1,748.187) (13,100.178) Other financing sources (uses) Transfers in - - 1,277 - 1,321,373 12,346.053 Transfers out - (92) - (6,644,488) (8,316,045) Debt issuance - - - 3,471,833 3,471,833 3.471,833 Premium on debt issuance - - - - - 26,877 Issuance of refunding bonds 17,358.395 27,918,395 Payment to refunded bond escrow agent (16,737,918) (27,613.658) Total other financing sources and uses (92) 1,277 3,471,833 (1.230,805) 7,833.455 Net change in fund balances 123.950 (92) (155.777) 145,970 (2,978,992) (5,266.723) Fund balances - beginning 138,444 92 2.462.242 58,310,157 108,608.165 Fundbalances - ending $ 262.394 $ - $ 2.306 465 S 145,970 1 55.331,165 $ 103,341,442 CITY OF SOUTH BEND COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES - NONMAJOR GOVERNMENTAL FUNDS For the Year Ended December 31, 2011 (Continued) Continued on next page Debt Service Capital Projects South Bend Central Building TIF Erskine Em3rgency Development Professional Corporation Village Medical Area Bond Sports Debt Service Debt Service Totals Services Proceeds Development Revenues. Taxes Property $ - $ - $ 1.549.954 $ $ $ - Professional sports development - - - 558.266 Community revitalization enhancement district - - - Intergovernmental - - 107,203 600.000 - 494,325 Charges for services - - 1.871,416 - Fines and forfeits - 9,240 - Interest 78 117 20,466 21,115 2.163 4 569 Donations - - - - - Sale of property 1,858 Other 5,907 24,611 49,691 Total revenues 78 117 1,683.530 2,528.240 2.163 1,106.853 Expenditures. Current. General government Public safety - - - - - Highways and streets - - - - Economic development Culture and recreation - - - - Debt service, Principal 1,392,805 175,000 4.832.805 143,008 - 285,000 Ln Interest and fiscal charges 920.307 316.418 4,320,336 6,846 - 110.423 Bond issuance costs - - 187.897 Capital outlay. General government - - Public safety 1,503,220 Economic development 620.295 - Culture and recreation 600,000 Total expenditures 2,313,112 491,418 9,341,038 1,653,074 620,295 995.423 Excess (deficiency) of revenues over(under)expenditures (2,313,034) (491,301) (7,657.508) 875,166 (618.132) 111,430 Other financing sources (uses)' Transfers in 2.316.386 496,080 8,504,334 - - - Transfers out - - (895,470) (500,000) (898,258) - Debt issuance Premium on debt issuance 26,877 Issuance of refunding bonds 10.560,000 Payment to refunded bond escrow agent (10,875,740) - - Total other financing sources and uses 2,316,386 496,080 7,320.001 (500.000) (898.258) Net change in fund balances 3,352 4,779 (337,507) 375,166 (1,516,390) 111,430 Fund balances• beginning 567,096 896,904 11,054,764 _ 5.114_,866 1,516,390 1,141,752 Fund balances - ending $ 570,448 $ 901,683 $ 10.717.257 $ 5,490,032 $ - 1 1,253.182 Continued on next page Supporting Schedules 16 V itn tiena, inatana i Worksheets - John 31, 2011 12!31/11 Auditor's ) 313 HALL OF FAME DEBT SERVICE (Completed 4/10/12 JHM) 10100 00 CASH 598.620.30 103 00 00 INVESTMENTS - CURRENT 0.00 CASH - TRUSTEE WELLS FARGO 0.00 INTEREST RECEIVABLE 0.00 115 00 00 ACCOUNTS RECEIVABLE 0.00 271 0000 FUND BALANCE (253,479.57) 3110000 GENERALPROPERTYTAX (1,549,953.75) 312 02 00 AUTO EXCISE (95.882.98) 312 03 00 COMMERCIAL VEHICLE TAX (11.320.00) 338 00 00 PAYMENT IN LIEU OF TAXES (88,695.00) 360 00 00 MISCELLANEOUS REVENUE 0.00 361 00 00 INTEREST ON INVESTMENTS 0.00 BOND REFUNDING PROCEEDS 0.00 392 00 00 INTER -FUND OPER. TRANSFER (4,289.00) 472 37 02 CAPITAL LEASE PAYMENTS 1.405,000.00 BOND ISSUANCE COSTS 0.00 BOND REFUNDING PAYOUT 0.00 472 38 03 PAYING AGENT FEES 0.00 (88,695.00) 0.00 Administration /Finance 12/31111 Prior Year Current Year CAFR ,diustments Adiustments Balance Notes 0.00 (407,906.31) 190,713.99 0.00 408,121.14 408.121,14 Per investment allocation 162,324.62 (151,976.39) 10,348.23 Per trustee stmis 0.00 579.36 579.36 Per A/R list 0.00 5,900.00 5,900.00 615.662.72 Per A/R list (162,324.62) 0.00 (415,804.19) (415,804.19) Per 12/31/10 CAFR 0.00 0.00 (1,549,953.75) 0.00 0.00 (95.882.98) 0.00 0.00 (11,320.00) 0.00 0.00 (88,695.00) 0.00 (5,900.00) (5.900.00) 0.00 (819.50) (819.50) $25.31 interest per trustee stmts 0.00 (7,580,000.00) (7,580.000.00) Per trustee slmts 0.00 0.00 (4,289.00) (9,336,860.23) From Excess Levy Fund 0.00 (5.862.50) 1.399,137.50 Per trustee stmts - $940,000.00 principal, $459,137.50 interest 0.00 133,257.48 133,257.48 Per trustee stmis 0.00 7.601,706.72 7,601.706.72 Per trustee stints 0.00 2.900.00 2,900.00 9,137,001.70 Per trustee slmts 0.00 0.00 0.00 0.00 9/11/2012 Page 1 Colleae Football Hall of Fame Include with Fund 313 Hall of Fame Conversion Worksheet December 31, 2011 Prepared - March 28, 2012 Name Wells Fargo Operation & Reserve #10335701 Wells Fargo Sinking Fund #10335700 Wells Fargo 2000 Escrow Fund #83665101 US Bank 2011 Refunding Sinking Fund 149536000 US Bank 2011 Refunding OperlReserve Fund 149536001 US Bank 2011 Refunding Expense Fund 149536002 US Bank 2011 Refunding Refunding Account 149536003 Total 1,405,000.00 Jan -Sept 2011 Jan -Sept 2011 Aug -Sept 2011 Aug -Dec 2011 Aug -Dec 2011 Aug -Dec 2011 August2011 25.31 Cash Balance at January 1, 2011 $162,319.18 $5.44 $0.00 $0.00 $0.00 $0.00 $0.00 $162.324.62 Debt Service Payment Received from City 0.00 1.405,000.00 0-DO 0.00 0.00 0.00 0.00 1,405,000.00 Band Refunding Proceeds 0.00 0.00 7,437,214.25 0.00 0 00 104,885.75 0100 7.542.100 00 Interest Earnings 15.91 154 0.00 0.00 1.55 6.31 0.00 25.31 Reimbursement - Overpayment Fees 2,450.00 0.00 0.00 0.00 0.00 21500 0.00 2.665.00 Transfer In From Other Account 5,869.48 0.00 164,492.47 7.284.58 3,062.10 0.00 0.00 180,708.63 Principal Paid to Bondholders 0.00 (940,000.00) 0.00 0.00 0.00 0.00 0.00 (940,000.00) Interest Paid to Bondholders 0.00 (459.137.50) 0.00 0.00 0.00 0.00 0.00 (459,137 50) Bond Refunding Payout 0.00 0.00 (7.601,706.72) 0.00 0.00 0.00 0.00 (7,601,70612) Bond Issuance Costs 0.00 0.00 0.00 0.00 000 (95.572.48) 0.00 (95.572.48) Trustee Fees Paid 000 000 0.00 0.00 0.00 (2,250.00) 0.00 (2,25000) Transfer Out To Other Accounts (167,554.57) (5,869.48) 0.00 0.00 0.00 (7,284.58) 0.00 (180,708.63) Paid to Account No. 99990902 (300.00) 0.00 0.00 000 0.00 0.00 0.00 (300.00) Disbursement - UCC Filing Fee (2,800.00) 0.00 0.00 0.D0 0.00 0.00 0.00 (2.800.00) Other 0.DO 0.00 0100 0.00 0.00 0.00 0.00 0.00 Cash Balance at December 31, 2011 $0.00 ($0_000) $0.00 $7,284.58 $3,063.65 $0000 $0.00 $10.348.23 Per Trustee Statements Adjustments Per CAFR Service Payment Received from City 1,405,000.00 0.00 1,405.000.00 1 Refunding Proceeds 7,542,100.00 37,900.00 7.580,000.00 gross proceeds, add back underwriter discount :sl Earnings 25.31 0.00 25.31 ibursement - Overpayment Fees 2.665.00 (2,665.00) 0.00 adjust reimbursement against expenditures sferIn From Other Account 180,708.63 (180.708.63) 0.00 :ipal Paid to Bondholders (940,000.00) 0.00 (940.000.00) ssl Paid to Bondholders (459,137.50) 0.00 (459,137.50) 1 Refunding Payout (7.601.706.72) 0.00 (7,601,706.72) 1 Issuance Costs (1) (95,572.48) (37,685.00) (133,257.48) include underwriter's discount, net of $215 reimbursement ee Fees Paid (2,250.00) 0.00 (2,250.00) sfer Out To Other Accounts (180.708.63) 180.708.63 0100 to Account No. 99990902 (300.00) 0.00 (300.00) irsemenl - UCC Filing Fee (2,800.00) 2,450.00 (350.00) net reimbursement against expenditures r 0.00 0_00 0_00 (151,976.39) 0.00 (151.976.39) fining Cash - 1/1111 162.324.62 0_00 162.324.62 ng Cash - 12131111 110,348.23 0.00 10,348.23 1Issuance Costs (II r & Daniels 34,474.48 e Horwath 28,712.00 rwriters Discount 37,900.00 Ratings 10.049.00 lard & Poors 8,470.00 ly's Investors Service 11,485.00 ey Oemgen & Moore, Inc. Verification 1,615.00 lard & Poors - Cusip 552.00 Bond Issuance Costs Paid by Escrow 133,257.48 testy of soutn tsend, inctiana Conversion Worksheets - John December 31, 2011 12131111 Auditor's Prior Year Current Year Worksheet Adiustments Adiustments 619 BLACKTHORN GOLF COURSE (Completed 4/23112) les fund 319, Wells Fargo summary, and certain accounts from Kitson balance sheet at 12131111) 101 00 00 CASH 101 01 00 PETTY CASH INVESTMENTS INVESTMENT CASH - WELLS CASH FUND 319 DEBT SVC RES 1000 11100 00 CASH WITH FISCAL AGENT 000 115 00 00 ACCOUNTS RECEIVABLE 1000 117 00 00 PREPAID EXPENSE INTEREST RECEIVABLE INTEREST REC - FUND 319 UNAMORTIZED DEBT ISSUE COST AMT OF LOSS ON REFUNDING UNAMORTIZED BOND DISCOUNT 000 142 00 00 INVENTORY -GOLF PROSHOP 000 144 00 00 CONCESSION INVENTORY CAPITAL ASSETS - LAND 000 190 10 00 CAPITAL ASSETS - OTHER ?0 00 ACCUMULATED DEPRECIATION )0 00 ACCOUNTS PAYABLE t0 00 A/P CENTRAL STORES 50 00 TEAMSTAFF/TIPS )0 00 DUE TO OTHER FUNDS DUE TO FUNDS - EQUIPMENT DUE TO FUNDS - EQUIPMENT ?0 00 PAYABLE TO STATE t0 00 LEASE PAYABLE 5000 CUSTODIAL DEPOSITS LEASE PAYABLE - PNC BANK REVENUE BOND ACCRUED INTEREST PAYABLE ACCRUED INTEREST PAYABLE 11 04 LOAN PAYABLE 11 05 LOAN RESERVE 10 00 PR YR RES FOR ENCUMBRANCE FUND BALANCE - FUND 319 10 00 FUND BALANCE 0 00 MISCELLANEOUS REVENUE 0 00 INTEREST ON INVESTMENTS i0 00 INTEREST - FUND 319 Administration /Finance 98.21 1,100.00 0.00 0.00 980,000.00 54,646.30 (4,907.35) 3,184.00 0.00 0.00 0.00 0.00 0.00 24,622.90 0.00 0.00 0.00 0.00 3.498.30 (98.21) 0.01 (5,338,500.04) 0.00 0.00 1,949.89 (0.32) 2,132.75 0.00 0.00 0.00 0.00 (5,090.000.00) 5,090,000.00 (160,028.23) (980,000.00) 4,653,176.90 (98.21) 0.00 (2,827.48) 0.00 0.00 0.00 398,097.10 0.00 0.00 4,907.35 0.00 0.00 0.00 9,393.41 45,868.54 10,700.58 0.00 0.00 448.469.00 4,874,512.62 (2,592,500.98) (10,25144) 98.21 (0.01) 2,997,250.06 (31,032.00) 0.00 (2,245.34) 0.32 (5,792.75) (246.509.64) (1,775,000.00) (29,639.45) (2.029.30) 5.090,000.00 (5,090,000.00) 0.00 0.00 (4,088,661.67) (66.92) 0.00 66.94 13,788.81 0.00 (2,527.68) 0.00 0.00 2.03 993.76 (4,335.42) (21.170.09) (4,280.23) (2,315.13) 345.67 0.00 16,895.00 (121,710.78) 1,815.65 0.00 0.00 651,500.00 7.758.00 (46,898.66) 6.68 0.00 0.00 44.574.40 565,000.00 10,173.08 366.93 0.00 0.00 0.00 0.00 0.00 12/31111 CAFR Balance 31.29 1,100.00 66.94 411,885.91 980,000.00 52,118.62 0.00 3,184.00 2.03 993.76 5,057.99 24,698.45 6,420.35 22,307.77 345.67 448,469.00 4,891, 407.62 (2,714,211.76) (4,939.49) 0.00 0.00 (1,689,749.98) (23,274.00) (46,898.66) (288.77) 0.00 (3,660.00) (201,935.24) (1,210,000.00) (19,466.37) (1,662.37) 0.00 0.00 (160,028.23) (980.000.00) 564,515.23 0.00 0.00 (98.21) 0.00 (2.05) (2.05) 316.30 (1,031.32) (3,542.50) 9/11/2012 Totals 932,002.76 Notes Per Petty Cash Summary Per Investment Summary Wells Fargo Statement Fund 319 Grp #291, Kitson Bank Balance at 12/31/11 - Old National $52.118.62 per Kitson Trial Balaance $3,000.00 SB, $184.00 Kitson Trial Balance Per A/R Summary - Revised Amortize $4,335.42 per year Amortize $21,170.09 per year Amortize $4,280.23 per year Grp #291 ($2,315.13), agrees with Inventory Listing at 12/31/11 Grp #291 $345.67, Agrees with Inventory Listing at 12/31/11 Per Capital Asset Summary Per Capital Asset Summary Per Capital Asset Summary $4,939.49 A/P per Kitson Trial Balance. Grp #291 $1,861.51 Due to Airport TIF 324, discounted amount Debt Schedule #83 - Airport TIF 324 Debt Schedule #88 - Airport TIF 324 - $53,598.00 original amt $288.77 Sales Tax due State per Kitson Trial Balance $3.660.00 deposits payable per Kitson Trial Balance Debt Schedule #75 Debt Schedule #10 Debt Schedule #10 $29,040.00 x 122 days / 182 days Debt Schedule #75, per schedule Nov & Dec (575,513.00) $575,513 per 12/31/10 CAFR $37.56 Interest Wells Fargo, $993.76 Fund 319 A/R Page 1 Conversion Worksheets - John December 31, 2011 Account Number /Name 12/31/11 Auditor's Worksheet Prior Year Adjustments Current Year Adjustments 12131/11 CAFR Balance 1065 347 01 20 GOLF COURSE GREEN FEES (681,520.98) 0.00 0.00 (681,520.98) 1065 347 01 22 GOLF CART RENTALS (79.894.84) 0.00 0.00 (79,894.84) 1065 347 01 23 PRO SHOP RETAIL SALES (161.845.40) 0.00 0.00 (161,845.40) 1065 347 01 25 DRIVING RANGE (41,875.52) 0.00 0.00 (41,875.52) 1065 347 01 27 MEMBERSHIP (181,974.13) 0.00 0.00 (181,974.13) 1065 347 01 29 CLUB RENTAL (3,930.00) 0.00 0.00 (3.930.00) 1065 347 01 30 CONCESSION (258.321.07) 0.00 0.00 (258.321.07) 1065 347 0131 INSTRUCTION (618.84) 0.00 0.00 (618.84) 1065 347 01 41 OTHER GOLF (1,344.21) 0.00 0.00 (1,344.21) 1065 347 01 99 ADVERTISING REVENUE (36,679.94) 0.00 0.00 (36,679.94) 1065 347 99 00 CASH OVERISHORT (1,315.18) 129.90 221.99 (963.29) 1065 347 0126 GIFT CERTIFICATES 56,066.75 0.00 0.00 56,066.75 TRANSFER IN 0.00 0.00 (651,500.00) (651,500.00) 1065 460 62 01 SALARIES 274.549.60 0.00 0.00 274,549.60 1065 460 62 02 PAYROLL OVERHEAD 29,202.24 0.00 0.00 29,202.24 1065 460 62 03 HEALTH INSURANCE 14,689.80 0.00 0.00 14,689.80 1065 460 62 05 TRAVEL ALLOWANCE 451.21 0.00 0.00 451.21 1065 460 62 06 PROF. EDUCATION 135.00 0.00 0.00 135.00 i 065 460 62 07 DUES /SUBSCRIPTION 830.00 0.00 0.00 830.00 1065 460 62 08 UNIFORMS /CLOTHING 1,044.76 0.00 0.00 1,044.76 1065 460 62 10 FERTILIZER 20,732.58 (3,676.80) 0.00 17,055.78 1065 460 62 11 FUNGICIDES 31,234.21 0.00 0.00 31,234.21 1065 460 62 12 INSECTICIDES 5,670.72 0.00 0.00 5,670.72 1065 460 62 13 HERBICIDES 4,533.11 0.00 0.00 4,533.11 1065 460 62 14 HORTCULT. SUPPLY 7,651.01 0.00 0.00 7,651.01 1065 460 62 15 SEED 1,991.91 0.00 0.00 1,991.91 1065 460 62 17 SAND 6,364.93 0.00 0.00 6,364.93 1065 460 62 21 PLANT MATERIALS 230.68 0.00 0.00 230.68 1065 460 62 23 SMALL TOOLS 415.73 0.00 0.00 415.73 1065 460 62 24 IRRIGATION REPAIR 7,835.67 0.00 0.00 7,835.67 1065 460 62 26 FUEULUBRICANTS 29.198.48 0.00 0.00 29,198.48 1065 460 62 29 G.C. ACCESSORIES 5,064.16 0.00 0.00 5,064.16 1065 460 62 31 EQUIPMENT REPAIRS 29,672.31 (15.00) 0.00 29.657.31 1065 460 62 34 OFFICE SUPPLY 1,799.02 0.00 0.00 1,799.02 1065 460 62 36 BUILDING MAINT. 2,712.05 0.00 0.00 2,712.05 1065 460 62 39 UTILITY WATER 1,084.78 0.00 0.00 1,084.78 1065 460 62 40 UTILITY ELECTRIC 8.177.92 0.00 0.00 8,177.92 1065 460 62 42 TRASH REMOVAL 3.074.25 0.00 0.00 3,074.25 1065 460 62 43 MISCELLANEOUS 495.65 0.00 0.00 495.65 1065 460 62 46 UTILITY GAS 3,818.24 0.00 0.00 3,818.24 1065 460 62 47 CAPITAL EQUIP /IMPROV 30,999.42 0.00 (14,457.84) 16,541.58 Notes Reverse Grp #327. Grp #291 (2,048,044.23) Airport TIF transfer to cover 2011 debt service, reclass. From advance to transfer in Reverse Grp #327 Reverse Kitson A/P 505,509.80 Principal paid #83 $7,758.00, #88 $6.699.84 during 2011 Administration /Finance 9/11/2012 Page 2 Conversion Worksheets - John December 31, 2011 Account NumberlName 12/31/11 Auditor's Worksheet Prior Year Adjustments Current Year Adjustments 12/31/11 CAFR Balance ADMINISTRATION 1065 460 63 04 PAYROLL SERVICES 17,892.14 0.00 0.00 17,892.14 1065 460 63 10 PRINT ADVERTISING 42,508.29 0.00 0.00 42.508.29 1065 460 63 20 INSURANCE 14,613.35 0.00 0.00 14,61135 1065 460 63 21 BANK CHARGES 997.35 (51.00) 35.00 981.35 1065 460 63 23 CITY ACCOUNTING FEE 24,000.00 0.00 0.00 24,000.00 1065 460 63 25 DUES & SUBSCRIPTION 1.273.42 0.00 0.00 1,273.42 1065 460 63 26 TELEPHONE SERVICE 9,777.93 0.00 0.00 9,777.93 1065 460 63 28 LICENSES & PERMITS 1,580.43 0.00 0.00 1,580.43 1065 460 63 29 TV CABLE 1.424.77 0.00 0.00 1.424.77 1065 460 63 31 WATER/SEWER 4,093.30 0.00 0.00 4.093.30 1065 460 63 32 GAS C.H. 5,570.02 0.00 0.00 5,570.02 1065 460 63 34 OFFICE SUPPLIES /EQUIP, 327.65 0.00 0.00 327.65 1065 460 63 37 STATIONERY /PRINTING 1.471.62 0.00 0.00 1,471.62 1065 460 63 38 POSTAGE /FREIGHT 2,092.29 0.00 0.00 2,092.29 1065 460 63 39 CREDIT CARD FEES 21.579.84 (490.62) 341.58 21,430.80 1065 460 63 40 SECURITY 1,358.00 0.00 0.00 1,358.00 1065 460 63 41 MISCELLANEOUS 1,920.00 0.00 39.18 1,959.18 1065 460 63 42 BUILDING MAINTENANCE 7,569.23 0.00 (4.40) 7,564.83 1065 460 63 43 VEHICLE LEASE 5,036.20 (377.40) 0.00 4.658.80 N PROSHOP 1065 460 64 01 SALARIES 233,006.92 0.00 0.00 233,006.92 1065 460 64 02 PAYROLL OVERHEAD 28.339.56 0.00 0.00 28,339.56 1065 460 64 03 HEALTH INSURANCE 11.694.36 0.00 0.00 11,694.36 1065 460 64 05 DUES /SUBSCRIPTIONS 711.80 0.00 0.00 711.80 1065 460 64 06 TRAVEL ALLOWANCE 2,947.24 (183.96) 0.00 2,763.28 1065 460 64 07 PROF. EDUCATION 473.04 0.00 0.00 473.04 1065 460 64 08 UNIFORMS /CLOTHING 2,037.60 0.00 0.00 2.037.60 1065 460 64 10 COST OF GOODS SOLD 136,329.67 0.00 2,387.13 138,716.80 1065 460 64 11 RANGE BALLS /SUPPLY 3.143.20 0.00 0.00 3,143.20 1065 460 64 14 GOLF CART PAYMETS (INTEREST) 56,421.00 0.00 (44,574.40) 11,846.60 1065 460 64 15 GOLF CART ELECTRICITY 14,087.94 0.00 0.00 14.087.94 1065 460 64 16 GOLF CART MAINTENANCE 447.33 0.00 0.00 447.33 1065 460 64 17 HANDICAP SERVICE 6.028.00 0.00 0.00 6,028.00 1065 460 64 18 PRO SHOP SUPPLIES 343.52 0.00 0.00 343.52 1065 460 64 19 SCORECARDS 1,631.66 0.00 0.00 1,631.66 1065 460 64 20 MISCELLANEOUS 200.00 0.00 0.00 200.00 1065 460 64 21 TEES, PENCILS, ETC 6,450.04 0.00 0.00 6,450.04 1065 460 64 24 GPS FEES 44,410.86 0.00 0.00 44,410.86 065 460 65 01 SALARIES 50,064.83 0.00 0.00 50.064.83 065 460 65 02 PAYROLL OVERHEAD 6,799.13 0.00 0.00 6,799.13 Reverse Grp #327. Grp #291 Reverse Grp #327. Grp #291 Adjust accounts to Kitson Trial Balance Grp #291 164,578.17 Reverse Grp #327 506,332.51 Reverse Grp #327 Grp #291 Debt Schedule #75 PNC Bank - balance is interest Administration /Finance 9/1112012 Page 3 Conversion Worksheets - John December 31, 2011 Account Number /Name 12/31/11 Auditor's Worksheet Prior Year Adjustments Current Year Adjustments 12/31111 CAFR Balance Totals Notes 1065 460 65 03 HEALTH INSURANCE 1,248.00 (231.00) 0.00 1,017.00 Reverse Grp #327 1065 460 65 08 UNIFORMS /CLOTHING 445.93 0.00 0.00 445.93 1065 460 65 10 COST OF GOODS SOLD 91.875.03 0.00 (345.67) 91,529.36 Grp #291 1065 460 65 12 PAPER GOODS 1,447.68 0.00 0.00 1,447.68 1065 460 65 13 CLEANING SUPPLIES 863.02 0.00 0.00 863.02 1065 460 65 16 EQUIPMENT /SUPPLIES 1,663.83 0.00 0.00 1.663.83 1065 460 65 17 LINENS 1,004.50 0.00 0.00 1.004.50 1065 460 65 18 MISCELLANEOUS 94.45 0.00 0.00 94.45 1065 460 65 19 OUTING EXPENSE 1,686.24 0.00 0.00 1,686.24 1065 460 65 20 LICENSES & PERMITS 1,200.00 0.00 0.00 1,200.00 157,815.97 OTHER 1065 460 66 10 FIXED FEE 96.000.00 0.00 0.00 96,000.00 1065 460 66 12 MGMNT. EXPENSE 9,134.81 (736.73) 0.00 8.398.08 Reverse Grp #327 0401 460 37 06 BUILDINGS (DEBT SVC - INTER.) 651.500.00 0.00 (651,500.00) 0.00 Reclassify lease rental paid - Wells Fargo 1002 460 50 02 INTERFUND TRANSFERS - FD 319 2,827.48 (316.30) 0.00 2,511.18 INTEREST EXPENSE 0.00 0.00 60,958.74 60.958.74 $10,173.08 #10, $366.3 #75, $71.498.75 Wells Fargo AMORTIZE LOSS ON REFUNDING 0.00 0.00 21.170.09 21.170.09 Amortize $21,170.09 per year AMORTISE BOND DISCOUNT 0.00 0.00 4,280.23 4,280.23 Amortize $4,280.23 per year BOND ISSUE COST AMORTIZAT. 0.00 0.00 4,335.42 4,335.42 Amortize $4,335.42 per year ^' TRUSTEE FEES WELLS FARGO 0.00 0.00 1,250.00 1,250.00 Wells Fargo Statement & Summary 12/31/11 N DEPRECIATION 0.00 0.00 155.177.11 155.177.11 Per Capital Asset Summary LOSS ON DISPOSAL 0.00 0.00 3.237.17 3.237.17 357,318.02 Per Capital Asset Summary, $36,703.50 - $33,466.33 (0.00) 0.00 (0.00) 0.00 0.00 Total Expenses - $1,691,554.47 Administration /Finance 9/1112012 Page 4 City of South Bend Blackthorn Redevelopment Accounts - Fund 619 Conversion Worksheet December 31, 2011 Summary of Wells Fargo Trust Statements Funds 619 and 319 and these trustee statements combined into one fund for the CAFR. These amounts and Fund 319 are reported as investment cash on CAFR, #70395302 #70395300 Operation Bond & Reserve Sinkinq Totals Beginning Balance, January 1, 2011 $113,757.89 $284,339.21 $398,097.10 Interest earned 14.23 23.33 37.56 Lease Rental Paid from City Funds 0.00 651,500.00 651,500.00 Trustee Fees Paid to Well Fargo (1,250.00) 0.00 (1,250.00) Bond Principal Paid 0.00 (565.000.00) (565;000.00) Bond Interest Paid 0.00 (71,498.75) (71,498.75) Transfer Out: 0.00 0.00 0.00 Excess Lease Rental 0.00 0.00 0.00 Ending Balance, December 31, 2011 $112,52212 $299,363.79 $411,885.91 23 N -Pb City of South Bend Conversion Worksheet - Building/ Corporation Debt Service Accounts (Recorded in CAFR as a separate fund. Not in Navline or on Controller's Cash Report) December 31, 2011 Unadjusted Trial Balance Account Name 12/31/11 Adjustments CAM Trial Balance 12131/11 Cash - Police & Fire 36,568.70 0.00 36,568.70 Cash - Public Works Building, 87.7% of total 609,076.71 (75,197.58) 3 5_33,879.13 Beginning Fund Balance, per CAFR 12/31/10 (642,146.98) 7_ _5_ ,050.66 j - (567,096.32) Interest Income (76.45)1 0.00 (76.45) Transfers In - From Ci Funds 2,399,469.48 83,082.75 1 2,316,386.73 Transfers In--- From Building Corporation Accounts (7,774.98), 7,774.98 2 0.00 Bond Refunding Proceeds 0.00 i t 0.00 0.00 Account F__ ees t 4,350.00 0.00 I 4,350.00 Cost 6f--1 s__s_u__a_nc__e on Refunding Bonds 0.00 0.00 0.00 Debt Service - 1,450,000.00_ ! (57_,195.00)1 1 _1,392,805.00 _Principal Debt Service - Interest 941,697.50 _i (25,740_83)1_ 1 915,956.67 Debt Service - Bond Redemption 4 0.00 ' 0.00 i 0.00 Other Interest Adjustment 0.00 t 0.00 ! f _ 0.00 Transfers Out - To Building Corporation Accounts 7,774.98 I — (7,774_98)1 2 0.00 Other 0.00 i 0.00 ; 0.00 Proof Total 0.00 0.110 1 - eliminate Wastewater portion of Public Works Building COIT debt service and Transfer In of 12.3% account no. 649 - 0630 - 472_37 -02 _$83,082.75 paid to Wells Fargo in lease payments in 2011. 2 - eliminate transfers in %transfer out from building Authority Debt Service accounts for consolidation /conversion worksheet. 3 - allocate 12.3% of Building Corporation cash for Public Works Building to Wastewater trial balance. Wastewater Cash Summa 12.3% of PW Building Total): I Beginning Cash - 1/1/11 (per prior year audit) r 75,050.66 ' Lease Rental Paid by _Wastewater - -- - - -- 83,082.75 , - -- I— -- ( -- Wastewater Principal Paid_ $465,000AO x 12_3% (57,195.00)1 Wastewater Interest Paid - $209,275.00 x 12.3% _ (25,740.83): I Ending Cash - 12/31/11 - - - - t 75,197.58 City of South Bend, Indiana Building Corporation Transactions - Per Wells Fargo Statements January 1, 2011 through December 31, 2011 2010 COIT 2001 COIT 2010 Refunding 2010 Refunding 2010 Refunding Public Works 2003 Police /Fire 2003 Police /Fire 2003 Police /Fire Debt Reserve Sinking Fund Operation /Res. Sinking Fund Reserve Oper /Reserve Grand 10835901 10835900 10835905 14873700 14873701 14873702 Total _ $607,500.00 $2,614.29 - 0.22 565.63 - - 7.77 31.00 -- -_ 0.00 0.00 $31,912.39 $53.67 Balance 0 Januag 1, 2011 _ $642,146.98 Recei ts• _ -_ -- 76.45 Interest 0.00 64.05 4.41 Lease Payments from City 0.00 675,469.48 0.00 1,724,000.00 0.00 6,577.50 0.00 6,581.91 2,000.00 2,399,469.48 , 7,774.98 0.00 2,407,320.91 4,350.00 Transfer From Other Accounts Refunding Proceeds 0.00 0.00 0.00 0.00 _ 1,197.48 0.00 _ 0.00 0.00 0.00 0.00 Total Receipts _ 0.00 675,533.53 1,197.70 1,724,007.77 0.00 _ _ 0.00 Disbursements: _ 0.00 2,350.00 0.00 Account Fees 0.00 Debt Service - Principal Debt Service - Interest _ 0.00 0.00 465,000.00 209,275.00 0.00 0.00 985,000.00 732,422.50 _ 0.00 0.00 0.00 0.001 I 1,450,000.00 941,697.50 Debt Service - Bond Redemption 0.00 0.00 0.00 0.00 0.00 0.00 , 0.00 Transfer to Other Accounts (1) _ 0.00 1,197.48 0.00 6,577.50 0.00 0.00 7,774.98 Cost of Issuance 0.00 0.00 0.00 0.00 _ 0.00 0.00 0.00 Total Disbursements 0.00 675,472.48 2,350.00 1,724,000.00 0.00 2,000.00 2,403,822.48 Balance @ December 31, 2011 $607,500.00 $114.72 $1,461.99 $73.40 $1.00 $36,494.30 $645,645.41