Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2013 Redevelopment Authority & Building Corporation Report Final
O� low 4( U PEACE r' W1 �0�ee 1865 �1 d a axe City of South Bend Redevelopment Authority and Building Corporation 2013 Financial Reports Prepared by - Department of Administration and Finance October 23, 2014 (Information obtained from the City of South Bend Comprehensive Annual Report (CAFR) for the year ended December 31, 2013) City of South Bend, Indiana Redevelopment Authority and Building Corporation Financial Statements December 31, 2013 ------------------------------------- - - - - -- -City of South Bend Redevelopment Authority --------------------------------------------- College Football Redevelopment Redvelopment Redevelopment Redevelopment Blackthorn Total South Bend Hall of Fame Bond Bond Authority Authority Golf Course Redvelopment Building Coporation Debt Service Airport Taxable Palais Royale Debt Service General Enterprise Fund Authority Debt Service Balance Sheet Assets & Deferred Outflows Cash and cash equivalents $185,046 $264,755 $442,362 $3,980,899 $6,561 $52,362 $4,931,985 $595,831 Restricted cash 0 0 0 0 0 0 0 0 Investments 530,371 772,362 1,290,492 0 19,142 38,766 2,651,133 0 Accounts receivable 0 0 0 0 0 4,444 4,444 0 Interest receivable 732 980 1,860 0 27 53 3,652 0 Taxes 6,349 0 0 0 0 0 6,349 0 Inventories 0 0 0 0 0 22,038 22,038 0 Unamortized debt Issue Costs 0 0 0 0 0 0 0 0 Land and construction in progress 0 0 0 0 0 448,469 448,469 0 Other capital assets (net of accumulated depn) 0 0 0 0 0 1,860,932 1,860,932 0 Total assets & deferred outflows 722,498 1,038,097 1,734,714 3,980,899 25,730 2,427,064 9,929,002 595,831 Liabilities & Deferred Inflows Accounts payable 0 0 0 0 6,072 3,406 9,478 0 Interfund payable 0 0 223 0 0 0 223 0 Taxes payable 0 0 0 0 0 0 0 0 Revenue Bonds payable 0 0 0 0 0 0 0 0 Capital leases payable 0 0 0 0 0 106,803 106,803 0 Accrued Interest Payable 0 0 0 0 0 0 0 0 Advances from Other Funds 0 0 0 0 0 1,742,115 1,742,115 0 Total liabilities & deferred inflows 0 0 223 0 6,072 1,852,324 1,858,619 0 Net $722,498 $1,038,097 $1,734,491 $3,980,899 $19,658 $574,740 $8,070,383 $595,831 Fund Balance /Net Position Restricted 722,498 1,038,097 1,734,491 3,980,899 0 0 7,475,985 595,831 Assigned 0 0 0 0 19,658 0 19,658 0 Invested in capital assets, net of related debt 0 0 0 0 0 2,202,598 2,202,598 0 Restricted for debt service 0 0 0 0 0 0 0 0 Unrestricted 0 0 0 0 0 (1,627,858) (1,627,858) 0 Total fund balance/net position $722,498 $1,038,097 $1,734,491 $3,980,899 $19,658 $574,740 $8,070,383 $595,831 Income Statement Revenue Property taxes $1,274,527 $0 $0 $0 $0 $0 1,274,527 $0 Intergovernmental 67,317 0 0 0 0 0 67,317 0 Golf course fees 0 0 0 0 0 1,530,402 1,530,402 0 Other 0 0 0 0 0 0 0 1 Interest earnings 0 2,000 3,342 11891 60 0 7,293 173 Total revenue 1,341,844 2,000 3,342 11891 60 1,530,402 2,879,539 174 Expenditureslexpenses Operations and maintenance 0 0 0 0 0 1,194,830 1,194,830 0 Administrative and general 0 0 0 0 0 127,077 127,077 0 Depreciation 0 0 0 0 0 157,513 157,513 0 Capital outlay- economic development 0 0 0 0 11,871 0 11,871 0 Capital outlay - culture and recreation 0 0 0 3,000 0 0 3,000 0 Capital outlay - public safety 0 0 0 0 0 0 0 9,335 Debt service - principal 11115,000 0 0 2,400,000 0 0 3,515,000 1,672,885 Debt service - interest and fiscal charges 153,632 0 0 2,351,707 0 0 2,505,339 552,342 Debt service - bond issuance costs 0 0 0 127,125 0 0 127,125 192,884 Total expenditureslexpenses 1,268,632 0 0 4,881,832 11,871 1,479,420 7,641,755 2,427,446 Net revenue less expenditures /expenses 73,212 2,000 3,342 (4,879,941) (11,811) 50,982 (4,762,216) (2,427,272) Other financing /nonopereting items Transfers in 71,468 0 0 4,755,324 0 0 4,826,792 2,237,291 Transfers out 0 (3,167) (5,292) 0 0 (207,879) (216,338) 0 Interest revenue 0 0 0 0 0 146 146 0 Interest expense 0 0 0 0 0 (18,093) (18,093) 0 City of South Bend, Indiana Redevelopment Authority and Building Corporation Financial Statements December 31, 2013 ------------------------------------- - - - - -- -City of South Bend Redevelopment Authority --------------------------------------------- College Football Redevelopment Redvelopment Redevelopment Redevelopment Blackthorn Total South Bend Hall of Fame Bond Bond Authority Authority Golf Course Redvelopment Building Coporation Debt Service Airport Taxable Palais Royale Debt Service General Enterprise Fund Authority Debt Service Amortization expense 0 0 0 0 0 0 0 0 Premium on debt issuance 0 0 0 21,576 0 0 21,576 244,463 Issuance of refunding bonds 0 0 0 3,990,000 0 0 3,990,000 0 Gain (loss) on disposition of assets 0 0 0 0 0 0 0 0 Payment to refunded bond escrow agent 0 0 0 4,3( 76,769) 0 0 4,37( 6,769) 0 Total other financing /nonoperating items 71,468 (3,167) (5,292) 4,390,131 0 (225,826) 4,227,314 2,481,754 Net changes in fund balances 144,680 (1,167) 1 (1,950) (489,810) (11,811) (174,844) (534,902) 54,482 Fund balance /net position - beginning 577,818 1,039,264 1,736,441 4,470,709 31,469 749,584 8,605,285 541,349 Fund balance/net position - ending $722,498 $1,038,097 $1,734,491 $3,980,899 $19,658 $574,740 $8,070,383 $595,831 The Redevelopment Authority and Building Corporation are presented as blended component units in the City of South Bend 2013 Comprehensive Annual Financial Report. Redevlopment Authority Revenue - 2013 $1,274,527 $67,317 $3,990,000 $1,530,402 ,439 $21,576–/ lqqqmw�— $4,826,792 13 Property taxes 13 Intergovernmental •Charges for services •Interest earnings ■Transfers in •Premium on debt issuance •Issuance of refunding bonds Revenue Amount Percent Property taxes $1,274,527 10.88% Intergovernmental 67,317 0.57% Charges for services 1,530,402 13.06% Interest earnings 7,439 0.06% Transfers in 4,826,792 41.19% Premium on debt issuance 21,576 0.18% Issuance of refunding bonds 3,990,000 34.06% Total Revenue $11,718,053 100.00% Redevelopment Authority Expenditures - 2013 Al 1 Q It 'An 157,513 14,871 515,000 2,505,339 •Operations and maintenance ■Administrative and general oDepreciation •Capital outlay ■Debt service - principal ■Debt service - interest ■Debt service - bond issuance •Transfers out •Interest expense •Payment to refunded bond agent Expenditures Amount Percent Operations and maintenance $1,194,830 9.75% Administrative and general 127,077 1.04% Depreciation 157,513 1.29% Capital outlay 14,871 0.12% Debt service - principal 3,515,000 28.68% Debt service - interest 2,505,339 20.45% Debt service - bond issuance 127,125 1.04% Transfers out 216,338 1.77% Interest expense 18,093 0.15% Payment to refunded bond agent 4,376,769 35.71% Total Expenditures $12,252,955 100.00% 3 Building Corporation Revenue - 2013 $173 c—A o Interest earnir Revenue Amount Percent Interest earnings Premium on debt issuance Transfers in Total Revenue $173 0.01% 244,463 9.85% 2,237,291 90.14% $2,481,927 100.00% Building Corporation Expenditures - 2013 $192,884 ■Principal oCapital $1,672,885 0Bond Issuance Costs ointerest Expenditures Amount Percent Principal Capital Bond Issuance Costs Interest Total Expenditures $1,672,885 68.92% 9,335 0.38% 192,884 7.95% 552,342 22.75% $2,427,446 100.00% 4 CITY OF SOUTH BEND COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS December 31, 2013 Liabilities and fund balances Liabilities: Accounts payable Redevelopment Coveleski Redevelopment Accrued payroll payable South Bend - - - - Interfund payable: College Football Bond - Bond Bond - Redevelopment Building TIF Erskine Advances from other funds Hall of Fame Airport Debt Service Palais Authority Corporation Village Non - spendable Debt Service Taxable Reserve Royale Debt Service Debt Service Debt Service Totals Assets - - - - Assigned - - - - - - - - Unassigned Total fund balances Cash and cash equivalents $ 185,046 $ 264,755 $ 128,305 $ 442,362 $ 3,980,899 $ 595,831 $ 561,102 $6,158,300 Cash with fiscal agent - - - - - - - - Investments 530,371 772,362 374,301 1,290,492 - - - 2,967,526 Receivables (net of allowances for uncollectibles): Interest 732 980 540 1,860 - - 6 4,118 Taxes 6,349 - - - - - - 6,349 Accounts - - - - - - - - Intergovernmental - - - - - - - - Loans - - - - - - - - Interfund receivable: Interfund services provided and used - - - - - - - - Advances to other funds - - - - - - - - Property held for sale Total assets $ 722,498 $ 1,038,097 $ 503,146 $ 1,734,714 $ 3,980,899 $ 595,831 $ 561,108 $9,136,293 Liabilities and fund balances Liabilities: Accounts payable $ - $ - $ - $ - $ - Accrued payroll payable - - - - - - - - Interfund payable: Interfund services provided and used - - - 223 - - - 223 Other current payables - - - - - - - - Advances from other funds Total liabilities 223 223 Fund balances: Non - spendable Property held for resale - - - - - - - - Restricted 722,498 1,038,097 503,146 1,734,491 3,980,899 595,831 561,108 9,136,070 Committed - - - - - - - - Assigned - - - - - - - - Unassigned Total fund balances 722,498 1,038,097 503,146 1,734,491 3,980,899 595,831 561,108 9,136,070 Total liabilities and fund balances $ 722,498 $ 1,038,097 $ 503,146 $ 1,734,714 $ 3,980,899 $ 595,831 $ 561,108 $9,136,293 5 CITY OF SOUTH BEND COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS December 31, 2013 Liabilities and fund balances Liabilities: Accounts payable TIF Downtown TIF Leighton TIF - West Plaza Washington Redevelopment General Community Revitalization Enhancement District TIF No. 1 - Southside Development TIF No. 3 - Southside Development Certified Technology Park Palais Royale Historic Preservation Airport Urban Enterprise Equipment Zone Leasing Totals Total Nonmajor Governmental Funds Assets - - - - - - - - - - - 213,184 Interfund payable: Cash and cash equivalents $ 663,725 $ 22,618 $ 156,207 $ 6,561 $ 9,537 $ 876,561 $ 1,632,913 $ 938,474 $ 13,607 $ 95,915 $ 431,603 $ 11,309,687 $ 27,947,211 Cash with fiscal agent - 50,162 - - - - - - - - - 50,162 50,162 Investments 1,936,270 65,985 455,700 19,142 - 2,557,171 4,763,660 2,737,788 39,690 279,810 - 31,706,561 56,319,954 Receivables (net of allowances for uncollectibles): Total liabilities 57,209 12,273 319 6,072 81,949 656 9,044,803 11,691,289 Fund balances: Interest 2,761 95 649 27 30 3,671 6,844 3,945 57 434 - 45,567 88,517 Taxes 982,818 - 62,044 - - 83,236 - - - - - 2,399,017 2,405,366 Accounts - 2,192 - - - - - - 1,758 - - 250,619 426,700 Intergovernmental - - - - - - - - - - - 114,274 802,771 Loans 683,474 - - - - - - - - - - 683,474 7,694,684 Interfund receivable: (2,851,765) (4,852,169) Total fund balances 9,612,002 128,779 Interfund services provided and used 223 - - - - - - - - - - 223 1,710 Advances to other funds - - - - - - - - - - - 5,912,837 6,412,837 Property held for sale 5,399,940 436,690 105,000 5,941,630 9,198,433 Total assets $ 9,669,211 $ 141,052 $ 1,111,290 $ 25,730 $ 114,567 $ 3,520,639 $ 6,403,417 $ 3,680,207 $ 55,112 $ 376,159 $ 431,603 $ 58,414,051 $ 111,348,345 Liabilities and fund balances Liabilities: Accounts payable $ 54,059 $ - $ 319 $ 6,072 $ - $ 81,949 $ 656 $ - $ - $ - $ - $ 2,459,008 $ 2,844,159 Accrued payroll payable - - - - - - - - - - - - 213,184 Interfund payable: Interfund services provided and used 3,150 - - - - - - - - - - 3,837 20,423 Other current payables - 12,273 - - - - - - - - - 12,273 15,865 Advances from other funds 6,569,685 8,597,658 Total liabilities 57,209 12,273 319 6,072 81,949 656 9,044,803 11,691,289 Fund balances: Non - spendable Property held for resale 5,399,940 - 436,690 - 105,000 - - - - - - 5,941,630 9,198,433 Restricted 4,212,062 128,779 674,281 - 9,567 3,438,690 6,402,761 3,680,207 - - 431,603 34,148,958 64,074,963 Committed - - - - - - - - 55,112 376,159 - 12,110,767 20,697,026 Assigned - - - 19,658 - - - - - - - 19,658 10,538,803 Unassigned (2,851,765) (4,852,169) Total fund balances 9,612,002 128,779 1,110,971 19,658 114,567 3,438,690 6,402,761 3,680,207 55,112 376,159 431,603 49,369,248 99,657,056 Total liabilities and fund balances $ 9,669,211 $ 141,052 $ 1,111,290 $ 25,730 $ 114,567 $ 3,520,639 $ 6,403,417 $ 3,680,207 $ 55,112 $ 376,159 $ 431,603 $ 58,414,051 $ 111,348,345 6 COMBINING STATEMENT OF REVENUES, EXPENDITURES AND OTHER CHANGES IN FUND BALANCES NONMAJOR GOVERNMENTAL FUNDS For The Year Ended December 31, 2013 Revenues: Taxes: Property Professional sports development Community revitalization enhancement district Intergovernmental Charges for services Fines and forfeits Interest Donations Sale of property Other Total revenues Expenditures: Current: General government Public safety Highways and streets Economic development Culture and recreation Debt service: Principal Interest and fiscal charges Bond issuance costs Capital outlay: General government Public safety Highways and streets Economic development Culture and recreation Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Debt issuance Premium(Discount) on debt issuance Issuance of refunding bonds Payment to refunded bond escrow agent Total other financing sources and uses Net change in fund balances Fund balances - beginning (restated) Fund balances - ending Redevelopment Coveleski Redevelopment South Bend College Football Bond - Bond Bond - Redevelopment Building TIF Erskine Hall of Fame Airport Debt Service Palais Authority Corporation Village Debt Service Taxable Reserve Royale Debt Service Debt Service Debt Service Totals $ 1,274,527 $ - $ - $ - $ - $ - $ - $ 1,274,527 67,317 - - - - - - 67,317 2,000 967 3,342 1,891 173 15 8,388 1,341,844 2,000 967 3,342 1,891 174 15 1,350,233 1,115,000 - - - 2,400,000 1,672,885 - 5,187,885 153,632 - - - 2,351,707 552,342 - 3,057,681 - - - - 127,125 192,884 - 320,009 - - - - - 9,335 - 9,335 3,000 - 3,000 1,268,632 4,881,832 2,427,446 8,577,910 73,212 2,000 967 3,342 (4,879,941) (2,427,272) 15 (7,227,677) 71,468 - - - 4,755,324 2,237,291 - 7,064,083 - (3,167) - (5,292) - - - (8,459) - - - - - 244,463 - 244,463 - - - - 21,576 - - 21,576 - - - - 3,990,000 - - 3,990,000 (4,376,769) (4,376,769) 71,468 (3,167) (5,292) 4,390,131 2,481,754 6,934,894 144,680 (1,167) 967 (1,950) (489,810) 54,482 15 (292,783) 577,818 1,039,264 502,179 1,736,441 4,470,709 541,349 561,093 9,428,853 $ 722,498 $ 1,038,097 $ 503,146 $ 1,734,491 $ 3,980,899 $ 595,831 $ 561,108 $ 9,136,070 COMBINING STATEMENT OF REVENUES, EXPENDITL NONMAJOR GOVERNMENTAL FUNDS For The Year Ended December 31, 2013 Expenditures: Community Total Current: TIF Revitalization TIF No. 1 - TIF No. 3 - Certified Palais Royale Airport Urban Nonmajor TIF Leighton TIF - West Redevelopment Enhancement Southside Southside Technology Historic Enterprise Equipment - Governmental - - Downtown Plaza Washington General District Development Development Park Preservation Zone Leasing Totals Funds Revenues: - - - - 626,563 Highways and streets - - - - - - Taxes: - - - - - 8,388,444 Economic development - - - - - Property $ 3,573,627 $ - $ 518,833 $ - $ - $ 2,475,377 $ 1,311,129 $ - $ - $ - $ - $ 13,375,425 $ 14,649,952 Professional sports development - - - - - - - - - - - 649,996 649,996 Community revitalization enhancement district - - - - 244,481 - - - - - - 244,481 244,623 Intergovernmental 398,500 - - - - - - 1,412,953 15,911 - - 2,288,670 13,384,075 Charges for services 33,994 - - - - - - - - - - 2,966,121 5,258,092 Fines and forfeits - - - - - - - - - - - 8,869 80,587 Interest 55,521 169 641 60 342 10,341 9,881 4,117 125 754 385 361,343 640,683 Donations - - - - - - - - - - - 8 36,303 Sale of property 8,727 - - - - - - - - - - 17,416 35,977 Other 188,531 155,728 Highways and streets - - - - - - 489,457 5,215,148 Total revenues 4,258,900 155,897 519,474 60 244,823 2,485,718 1,321,010 1,417,070 16,036 754 385 20,401,786 40,195,436 Expenditures: Current: General government - - - - - - - - - - - - 549,950 Public safety - - - - - - - - - - - - 626,563 Highways and streets - - - - - - - - - - - - 8,388,444 Economic development - - - - - - - - - - - - 8,068,458 Culture and recreation - - - - - - - - - - - - 891,271 Debt service: Principal 1,676,667 - - - 385,000 - 195,000 - - - - 3,544,119 9,267,584 Interest and fiscal charges 805,754 - - - 73,949 - 293,848 - - - - 1,640,439 4,748,566 Bond issuance costs - - - - - - - - - - - - 320,009 Capital outlay: General government - - - - - - - - - - 233 737 737 Public safety - - - - - - - - - - 1,089,719 8,743,367 8,752,702 Highways and streets - - - - - - - - - - 643,543 1,839,121 1,839,121 Economic development 990,356 132,154 323,963 11,871 - 4,329,259 1,813 - - - - 7,685,071 7,685,071 Culture and recreation 20,470 321,970 324,970 Total expenditures 3,472,777 132,154 323,963 11,871 458,949 4,329,259 490,661 20,470 1,733,495 23,774,824 51,463,446 Excess (deficiency) of revenues over (under) expenditures 786,123 23,743 195,511 (11,811) (214,126) (1,843,541) 830,349 1,417,070 (4,434) 754 (1,733,110) (3,373,038) (11,268,010) Other financing sources (uses): Transfers in 5,291 - - - - - - - - - - 322,230 12,730,714 Transfers out (398,500) - - - - - - - - - - (4,590,399) (4,848,858) Debt issuance - - - - - - - - - - 2,162,750 7,498,287 7,748,309 Premium(Discount) on debt issuance - - - - - - - - - - - - 21,576 Issuance of refunding bonds - - - - - - - - - - - - 3,990,000 Payment to refunded bond escrow agent (4,376,769) Total other financing sources and uses (393,209) 2,162,750 3,230,118 15,264,972 Net change in fund balances 392,914 23,743 195,511 (11,811) (214,126) (1,843,541) 830,349 1,417,070 (4,434) 754 429,640 (142,920) 3,996,962 Fund balances- beginning (restated) 9,219,088 105,036 915,460 31,469 328,693 5,282,231 5,572,412 2,263,137 59,546 375,405 1,963 49,512,168 95,660,094 Fundbalances - ending $ 9,612,002 $ 128,779 $ 1,110,971 $ 19,658 $ 114,567 $ 3,438,690 $ 6,402,761 $ 3,680,207 $ 55,112 $ 376,159 $ 431,603 $ 49,369,248 $ 99,657,056 CITY OF SOUTH BEND COMBINING STATEMENT OF NET POSITION - NONMAJOR ENTERPRISE FUNDS December 31, 2013 Assets Current assets: Cash and cash equivalents Investments Interest receivable Accounts receivable (net of allowance) Inventories Restricted assets: Cash and cash equivalents: Capital outlay accounts Cash with fiscal agent Investments: Capital outlay accounts Total current assets Noncurrent Assets: Capital assets: Land and construction in progress Other capital assets (net of accumulated depreciation) Total noncurrent assets Total assets Deferred outflows of resources: Unamortized loss on sale /leaseback Total deferred outflow of resources Consolidated Parking Solid Blackthorn 2,329,551 1,860,932 Building Garage Waste Golf Course Totals 4,896,028 2,427,064 13,524,160 $ 38,670 $ 225,327 $ 795,275 $ 52,362 $ 1,111,634 112,810 657,340 591,239 38,766 1,400,155 163 949 120 53 1,285 14,663 1,520 421,007 4,444 441,634 - - - 22,038 22,038 - - 118,441 - 118,441 - - 552,342 - 552,342 - - 88,053 - 88,053 166,306 885,136 2,566,477 117,663 3,735,582 - 1,132,020 - 448,469 1,580,489 63,920 3,953,686 2,329,551 1,860,932 8,208,089 63,920 5,085,706 2,329,551 2,309,401 9,788,578 230,226 5,970,842 4,896,028 2,427,064 13,524,160 9 - 1,125,301 1,125,301 - 1,125,301 - 1,125,301 (Continued on next page) CITY OF SOUTH BEND COMBINING STATEMENT OF NET POSITION - NONMAJOR ENTERPRISE FUNDS (continued) December 31, 2013 (Continued) Liabilities Current liabilities: Accounts payable Interfund payables: Interfund services provided and used Accrued payroll payable Compensated absences payable Performance deposits payable Current liabilities payable from restricted assets: Capital leases payable Accrued interest payable Total current liabilities Noncurrent liabilities: Advances from other funds Capital leases payable Total noncurrent liabilities Total liabilities Deferred inflows or resources: Unamoritzed gain on sale /leaseback Net Position Net investment in capital assets Restricted for capital asset outlays Unrestricted Total net position Consolidated Parking Solid Blackthorn Building Garage Waste Golf Course Totals 11,671 96,837 209,826 3,406 321,740 7,356 - - - 7,356 56,229 - 54,420 - 110,649 111,489 - 50,131 - 161,620 37,437 - - - 37,437 14,628 - 700,136 52,087 766,851 155 - 11,019 - 11,174 238,965 96,837 1,025,532 55,493 1,416,827 - - - 1,742,115 1,742,115 32,978 - 1,894,497 54,716 1,982,191 32,978 - 1,894,497 1,796,831 3,724,306 271,943 96,837 2,920,029 1,852,324 5,141,133 - 10,277 - - 10,277 5,085,706 (265,082) 2,202,598 7,023,222 - - 206,494 - 206,494 (41,717) 1,903,323 2,034,587 (1,627,858) 2,268,335 01 (Al 7171 ct F QAQ 090 0, 1 Q7r, QQQ q, G7a Tan 0, A AQR nr1 im CITY OF SOUTH BEND COMBINING STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN NET POSITION NONMAJOR ENTERPRISE FUNDS For The Year Ended December 31, 2013 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 Total nonoperating revenue (expenses) Income (loss) before contributions and transfers Transfers out Change in net position Total net position - beginning Total net position - ending Consolidated Parking Solid Blackthorn Building Garage Waste Golf Course Totals $ 964,240 $ - $ $ $ 964,240 - 948,722 948,722 - 4,800,454 4,800,454 - - - 1,530,402 1,530,402 3,427 20,146 598,590 - 622,163 967,667 968,868 5,399,044 1,530,402 8,865,981 1,089,316 - 4,395,179 1,194,830 6,679,325 17,376 463,756 332,856 127,077 941,065 24,144 260,960 331,220 157,513 773,837 1,130,836 724,716 5,059,255 1,479,420 8,394,227 (163,169) 244,152 339,789 50,982 471,754 394 1,131 2,300 146 3,971 (979) - (32,333) (18,093) (51,405) - (560,340) (560,340) (585) (559,209) (30,033) (17,947) (607,774) (163,754) (315,057) 309,756 33,035 (136,020) (207,879) (207,879) (163,754) (315,057) 309,756 (174,844) (343,899) 122,037 7,304,086 1,666,243 749,584 9,841,950 $ (41,717) $ 6,989,029 $ 1,975,999 $ 574,740 $ 9,498,051 11 CITY OF SOUTH BEND COMBINING STATEMENT OF CASH FLOWS - NONMAJOR ENTERPRISE FUNDS For The Year Ended December 31, 2013 Cash flows from operating activities: Receipts from customers and users Payments to suppliers Payments to employees Payments for interfund services used Net cash provided (used) by operating activities Cash flows from noncapital financing activities: Principal paid on interfund loan Transfers to other funds Net cash provided (used) by noncapital financing activities Cash flows from capital and related financing activities: Acquisition and construction of capital assets Proceeds from capital debt issued Principal paid on capital debt Interest paid on capital debt Net cash provided (used) by capital and related financing activities Cash flows from investing activities: Investments sold Investments purchased Interest received Net cash provided (used) by investing activities Consolidated Parking Solid Blackthorn Building Garage Waste Golf Course Totals $ 953,561 $ 968,614 $ 5,424,977 $ 1,525,958 $ 8,873,110 (107,851) (435,292) (2,664,790) (709,098) (3,917,031) (865,254) - (1,664,959) (609,143) (3,139,356) (22,417) (23,700) (386,520) (6,136) (438,773) (41,961) 509,622 708,708 201,581 1,377,950 (10,759) (10,759) - (207,879) (207,879) - (218,638) (218,638) - (483,315) (1,696,427) (2,179,742) 4,094 800,686 804,780 (13,919) (614,111) (666,170) (1,294,200) (990) (33,841) (25,636) (60,467) (10,815) (483,315) (1,543,693) (691,806) (2,729,629) 13,895 135,977 202,630 352,502 - (125,628) (87,986) (38,428) (252,042) 393 858 3,555 352 5,158 14,288 (124,770) 51,546 164,554 105,618 Net decrease in cash and cash equivalents (38,488) (98,463) (783,439) (544,309) (1,464,699) Cash and cash equivalents, January 1 (Including $551,638 and $41 for the revenue bond covenants and capital outlays, respectively, reported in restricted accounts) 77,158 323,790 2,249,497 596,671 3,247,116 Cash and cash equivalents, December 31 (Including $118,441 for capital outlays reported in restricted accounts) $ 38,670 $ 225,327 $ 1,466,058 $ 52,362 $ 1,782,417 (Continued on next page) 12 CITY OF SOUTH BEND COMBINING STATEMENT OF CASH FLOWS - NONMAJOR ENTERPRISE FUNDS For The Year Ended December 31, 2013 (Continued) Reconciliation of operating income (loss) to net cash provided by operating activities: Operating income (loss) Adjustments to reconcile operating income (loss) to net cash provided by operating activities: Depreciation expense Bad debt expense (Increase) decrease in assets: Accounts receivable Interfund receivable Inventories Increase (decrease) in liabilities: Accounts payable Interfund payable Accrued payroll payable Compensated absence payable Total adjustments Net cash provided (used) by operating activities Consolidated Parking Building Garage Solid Blackthorn Waste Golf Course Totals $ (163,169) $ 244,152 $ 339,789 $ 50,982 $ 471,754 24,144 260,960 (14,104) (254) 10,160 5,903 30,018 65,087 331,220 75,204 (53,605) 4,333 4,764 67,810 - (53,664) 3,034 (5,413) 157,513 773,837 - 75,204 (4,444) (72,407) 4,333 (3,965) (3,965) 1,662 84,396 (167) (47,928) - 33,052 59,674 121,208 265,470 368,919 150,599 906,196 $ (41,961) $ 509,622 $ 708,708 $ 201,581 $ 1,377,950 13 Supporting Schedules 14 of South Bend, Indiana ✓ersion Worksheets amber 31, 2013 Account Number Account Name FUND 313 HALL OF FAME DEBT SERVICE (completed 3/31/14) 12/31/13 12/31/13 Auditor's Prior Year Current Year CAFR Worksheet Adjustments Adjustments Balance Totals Notes 313 - 0000 - 101 -00 -00 CASH 713,401.97 (531,598.41) 181,803.56 313 - 0000 - 103 -00 -00 INVESTMENTS - 530,371.36 530,371.36 Investment Summary 313 - 0000 - 111 -00 -00 CASH WITH FISCAL AGENT 2,933.69 308.73 3,242.42 Trustee Cash INTEREST RECEIVABLE - 731.87 731.87 PROPERTY TAXES RECEIVABLE 6,348.57 6,348.57 722,497.78 A/R 313 - 0000 - 271 -00 -00 FUND BALANCE (577,372.68) (445.39) - (577,818.07) (577,818.07) Per 12131/2012 CAFR 577,818 313 - 0000 - 311 -00 -00 GENERAL PROPERTY TAX (1,268,178.59) (6,348.57) (1,274,527.16) 313 - 0000 - 312 -02 -00 AUTO EXCISE (55,942.23) (55,942.23) 313 - 0000 - 312 -03 -00 COMMERCIAL VEHICLE TAX (11,374.00) (11,374.00) 313 - 0000 - 338 -00 -00 PILOT TRANSFERS IN (71,468.16) (71,468.16) 313 - 0000 - 361 -00 -00 INTEREST ON INVESTMENTS 445.39 481.45 926.84 (1,412,384.71) I/R 313 - 0401 - 472 -38 -01 PRINCIPAL 1,115,000.00 - - 1,115,000.00 Per Trustee Accounting Summary 313 - 0401 - 472 -38 -02 INTEREST 153,000.00 (295.00) 152,705.00 1,267,705.00 Per Trustee Accounting Summary 0.00 0.00 0.00 0.00 0.00 15 Balance at January 1, 2013 South Bend Redevelopment Authority $0.00 $0.00 $2.47 $2,931.22 College Football Hall of Fame $0.00 $2,933.69 Service Payment Received from City 0.00 Include with Fund 313 Hall of Fame Conversion Worksheet 0.00 1,268,000.00 0.00 December 31, 2013 0.00 1,268,000.00 mt Earnings 0.00 Prepared - March 31, 2014 0.00 12.20 1.53 Wells Fargo Wells Fargo Wells Fargo US Bank US Bank US Bank US Bank Operation & Sinking 2000 Escrow 2011 Refunding 2011 Refunding 2011 Refunding 2011 Refunding Reserve Fund Fund Sinking Fund Oper /Reserve Fund Expense Fund Refunding Account Name #10335701 #10335700 #83665101 149536000 149536001 149536002 149536003 Total Balance at January 1, 2013 $0.00 $0.00 $0.00 $2.47 $2,931.22 $0.00 $0.00 $2,933.69 Service Payment Received from City 0.00 0.00 0.00 1,268,000.00 0.00 0.00 0.00 1,268,000.00 mt Earnings 0.00 0.00 0.00 12.20 1.53 0.00 0.00 13.73 ;fer In From Other Account 0.00 0.00 0.00 174.89 482.50 0.00 0.00 657.39 ipal Paid to Bondholders 0.00 0.00 0.00 (1,115,000.00) 0.00 0.00 0.00 (1,115,000.00) fist Paid to Bondholders 0.00 0.00 0.00 (152,705.00) 0.00 0.00 0.00 (152,705.00) se Fees Paid 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 ;fer Out To Other Accounts 0.00 0.00 0.00 (482.50) (174.89) 0.00 0.00 (657.39) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Balance at December 31, 2013 $0.00 $0.00 $0.00 $2.06 $3,240.36 $0.00 $0.00 $3,242.42 'nary Per Trustee Statements Adjustments Per CAFR Service Payment Received from City 1,268,000.00 0.00 1,268,000.00 Account No. 313 - 0401 - 472 -38 -01 and 313 - 0401 - 472 -38 -02 ?st Earnings 13.73 0.00 13.73 ;fer In From Other Account 657.39 (657.39) 0.00 Eliminate ipal Paid to Bondholders (1,115,000.00) 0.00 (1,115,000.00) Est Paid to Bondholders (152,705.00) 0.00 (152,705.00) ;fer Out To Other Accounts (657.39) 657.39 0.00 Eliminate 0.00 0.00 0.00 308.73 0.00 308.73 fining Cash - 1/1/13 2,933.69 0.00 2,933.69 ig Cash - 12/31/13 3,242.42 0.00 3,242.42 16 City of South Bend, Indiana Conversion Worksheets December 31, 2013 Account Number Account Name FUND 619 BLACKTHORN GOLF COURSE OPERATIONS 12/31/13 12/31/13 Auditor's Prior Year Current Year CAFR Worksheet Adjustments Adjustments Balance Totals Notes 619- 0000 - 101 -00 -00 CASH 51,044.21 (38,855.76) 12,188.45 619- 0000 - 101 -01 -01 PETTY CASH W /FISCAL AGENT 1,100.00 - 1,100.00 Petty Cash Summary, Kitson Trial Balance 619- 0000 - 103 -00 -00 INVESTMENTS - CURRENT - 38,766.07 38,766.07 Per Investment Summary 619- 0000 - 111 -00 -00 CASH WITH FISCAL AGENT 31,585.23 7,488.63 39,073.86 Bill Casper Golf 12/31/13 Grp #397, 1/21/14 TRUSTEE CASH - 428,244.61 (428,244.61) - Wells Fargo Trustee Stmts - closed CASH - FUND 319 123,392.78 (123,392.78) Fund 319 conversion worksheet - closed INVESTMENTS - FUND 319 202,629.65 (202,629.65) - Fund 319 conversion worksheet - closed INTEREST RECEIVABLE - FUND 619 - 53.49 53.49 I/R 619 - 0000 - 115 -00 -00 ACCOUNTS RECEIVABLE 3,984.18 460.09 4,444.27 Per Billy Casper Golf 12/31/13 trial balance 619 - 0000 - 117 -00 -00 PREPAID EXPENSE 3,000.00 - 3,000.00 619- 0000 - 142 -00 -00 INVENTORY -GOLF PROSHOP 18,687.61 18,687.61 $18,687.61 12/31/13 Inventory, Kitson TB 619- 0000 - 144 -00 -00 CONCESSION INVENTORY 350.00 350.00 350.00 12/31/13 Inventory, Kitson TB 619- 0000 - 149 -10 -00 UNAM DEBT ISSUE COSTS 722.57 (722.57) - Amortize $4,335.42 per year 619- 0000 - 149 -11 -00 AMT LOSS REFUNDING 3,528.36 (3,528.36) Amortize $21,170.09 per year 619- 0000 - 149 -12 -00 UNAMORT BOND DISCOUNT 2,104.12 - (2,104.12) Amortize $4,280.23 per year 619 - 0000 - 190 -10 -00 FIXED ASSETS 4,885,958.02 3.00 (42,799.02) 4,843,162.00 Per Capital Asset Summary 619- 0000 - 190 -15 -00 LAND & CONST IN PROGRESS 448,469.00 - - 448,469.00 Per Capital Asset Summary 619- 0000 - 190 -20 -00 ACCUMULATED DEPRECIATION (2,867,512.51) (114,717.49) (2,982,230.00) Per Capital Asset Summary ACCOUNTS PAYABLE (3,262.38) (3,262.38) Per Billy Casper Golf 12/31/13 trial balance SALES TAX PAYABLE (143.69) (143.69) Per Bill Casper Golf 12/31/13 trial balance 619- 0000 - 204 -00 -00 DUE TO OTHER FUNDS (6,197,878.89) - (6,197,878.89) Fund 324 - Airport TIF Gross Amount 619- 0000 - 204 -20 -00 RESERVE FOR UNCOLLECT 4,300,250.06 207,878.85 4,508,128.91 (1,689,749.98) Fund 324 Net - $1,689,749.98 619- 0000 - 204 -30 -00 EQUIPMENT (62,943.74) 10,578.84 (52,364.90) Debt Schedules #88 & #83 LEASE PAYABLE - PNC BANK (155,113.40) 48,310.60 (106,802.80) Debt Schedule #75 REVENUE BOND (620,000.00) 620,000.00 Debt Schedule #10 paid off Wells Fargo ACCRUED INTEREST PAY - BOND (9,975.42) 9,975.42 Debt Schedule #10 paid off ACCRUED INTEREST PAY - PNC (1,276.92) 1,276.92 574,741.00 Debt Schedule #75 619 - 0000 - 249 -00 -00 PR YR RES FOR ENCUMBRANCE (160,028.23) - - (160,028.23) 619- 0000 - 271 -00 -00 FUND BALANCE (627,025.33) 37,470.25 (589,555.08) Per 12/31/2012 CAFR 749,584 319- 0000 - 271 -00 -00 FUND BALANCE (326,000.00) (112.96) (326,112.96) (1,075,696.27) Per 12/31/2012 Conversion Worksheet 17 City of South Bend, Indiana Conversion Worksheets December 31, 2013 Account Number Account Name FUND 619 BLACKTHORN GOLF COURSE OPERATIONS 12/31/13 12/31/13 Auditor's Prior Year Current Year CAFR Worksheet Adjustments Adjustments Balance Totals Notes Revenue 619 - 0000 - 361 -00 -00 INTEREST ON INVESTMENTS 1.20 36.20 37.40 I/R 319 - 0000 - 361 -00 -00 INTEREST ON INVESTMENTS (463.63) 280.16 - (183.47) I/R 619- 0000 - 392 -00 -00 INTER -FUND OPER. TRANSFER (50,500.00) - 50,500.00 Transfer from fund 319 - $50,500.00 619- 1065 - 347 -01 -19 SEASON PASS SALES (191,013.85) - (191,013.85) 619 - 1065- 347 -01 -20 GOLF COURSE GREEN FEES (562,998.66) (562,998.66) 619- 1065 - 347 -01 -22 GOLF CART RENTALS (87,491.78) (87,491.78) 619 - 1065- 347 -01 -23 PRO SHOP RETAIL SALES (177,180.10) (460.09) (177,640.19) 619- 1065 - 347 -01 -25 DRIVING RANGE (36,311.17) (36,311.17) 619 - 1065- 347 -01 -26 GIFT CERTIFICATES (15,155.51) (15,155.51) 619- 1065 - 347 -01 -27 MEMBERSHIP (189,378.99) (189,378.99) 619 - 1065- 347 -01 -29 CLUB RENTAL (3,766.00) (3,766.00) 619- 1065 - 347 -01 -30 CONCESSION (213,861.60) (213,861.60) 619 - 1065 - 347 -01 -31 INSTRUCTION (12,023.28) (12,023.28) 619- 1065 - 347 -01-41 OTHER GOLF (3,068.72) 67.64 (3,001.08) Kitson Cash AJ 619 - 1065 - 347 -01 -99 ADVERTISING REVENUE (37,714.37) - (37,714.37) 619- 1065 - 347 -99 -00 CASH OVER /SHORT (47.55) (47.55) INTEREST INCOME FUND 319 (183.47) (183.47) OPERATING TRANSFERS IN - (207,878.85) (207,878.85) (1,738,612.42) $207,878.85 final Airport 324 bond payment Expenditures Maintenance 619 - 0401 - 460 -37 -11 CAPITAL LEASE PRINCIPAL 207,878.85 (207,878.85) - $207,878.85 final bond payment - see below 619 - 1065 - 460 -62 -01 SALARIES 264,963.18 (996.49) - 263,966.69 619 - 1065- 460 -62 -02 PAYROLL OVERHEAD 28,896.64 0.02 28,896.66 619- 1065 - 460 -62 -03 HEALTH INSURANCE 12,994.45 1,827.96 14,822.41 619 - 1065- 460 -62 -05 TRAVEL ALLOWANCE 3,659.94 - 3,659.94 619- 1065 - 460 -62 -06 PROF. EDUCATION 237.00 237.00 619 - 1065- 460 -62 -07 DUES /SUBSCRIPTION 690.00 690.00 619 - 1065 - 460 -62 -08 UNIFORMS /CLOTHING 1,276.13 1,276.13 619- 1065- 460 -62 -10 FERTILIZER 25,052.36 25,052.36 619- 1065 - 460 -62 -11 FUNGICIDES 31,308.64 31,308.64 619 - 1065- 460 -62 -12 INSECTICIDES 5,953.21 5,953.21 619- 1065 - 460 -62 -13 HERBICIDES 5,244.41 5,244.41 619 - 1065 - 460 -62 -14 HORTCULT. SUPPLY 10,569.88 10,569.88 619- 1065 - 460 -62 -15 SEED 1,170.74 1,170.74 619 - 1065 - 460 -62 -17 SAND 6,276.40 6,276.40 619- 1065 - 460 -62 -21 PLANT MATERIALS 864.75 864.75 619 - 1065 - 460 -62 -23 SMALL TOOLS 493.96 493.96 619- 1065 - 460 -62 -24 IRRIGATION REPAIR 10,508.97 10,508.97 619 - 1065 - 460 -62 -25 DRAINAGE SUPPLY 3,103.72 3,103.72 619- 1065 - 460 -62 -26 FUEULUBRICANTS 28,162.97 28,162.97 619 - 1065 - 460 -62 -29 G.C. ACCESSORIES 5,122.14 (3,000.00) 2,122.14 $3,000 adjust prepaid expense to zero at 12131/12 619- 1065 - 460 -62 -31 EQUIPMENT REPAIRS 30,330.14 (1,162.27) 29,167.87 $1,162.27 A/P per Kitson Trial Balance at 12/31/12 619 - 1065- 460 -62 -34 OFFICE SUPPLY 640.70 3.68 644.38 $6.68 adjustment to sales tax payable to agree with Kitson TB 619 -1065- 460 -62 -36 BUILDING MAINT. 1,588.74 - 1,588.74 619 - 1065- 460 -62 -37 TREE TRIMMING 594.00 594.00 619- 1065 - 460 -62 -39 UTILITY WATER 981.95 981.95 619 - 1065- 460 -62-40 UTILITY ELECTRIC 7,667.56 7,667.56 619- 1065 - 460 -62-42 TRASH REMOVAL 3,773.41 3,773.41 619 - 1065- 460 -62-46 UTILITY GAS 2,104.06 2,104.06 619- 1065 - 460 -62-47 CAPITAL EQUIP /IMPROV. 8,815.70 (10,578.85) (1,763.15) Principal #83 & #88 619- 1065 - 460 -62 -90 DEPRECIATION EXPENSE 489,139.80 18 City of South Bend, Indiana Conversion Worksheets December 31, 2013 Account Number Account Name FUND 619 BLACKTHORN GOLF COURSE OPERATIONS 12/31/13 12/31/13 Auditor's Prior Year Current Year CAFR Worksheet Adjustments Adjustments Balance Totals Notes Administration 619 - 1065 - 460 -63 -04 PAYROLL SERVICES 15,525.04 (1,832.17) 13,692.87 619 - 1065- 460 -63 -05 DUES /SUBSCRIPTION 2,040.48 2,040.48 619- 1065 - 460 -63 -10 ADVERTISING 18,403.53 18,403.53 619- 1065- 460 -63 -18 YELLOW PAGES/WEBSITE 4,440.00 4,440.00 619- 1065 - 460 -63 -20 INSURANCE 9,675.00 9,675.00 619- 1065- 460 -63 -21 BANK CHARGES 969.65 969.65 619- 1065 - 460 -63 -23 CITY ACCOUNTING FEE 24,000.00 24,000.00 619- 1065- 460 -63 -26 TELEPHONE SERVICE 10,632.49 10,632.49 619- 1065 - 460 -63 -29 TV CABLE 1,457.92 1,457.92 619 - 1065- 460 -63 -31 WATER/SEWER 4,987.34 4,987.34 619- 1065 - 460 -63 -32 GAS C.H. 3,751.74 3,751.74 619- 1065- 460 -63 -34 OFFICE SUPPLIES /EQUIP. 1,971.01 1,971.01 619- 1065 - 460 -63 -37 STATIONERY /PRINTING 566.02 - 566.02 619 - 1065 - 460 -63 -38 POSTAGE /FREIGHT 1,988.93 63.02 2,051.95 619- 1065 - 460 -63 -39 CREDIT CARD FEES 20,191.11 316.42 20,507.53 619- 1065 - 460 -63-40 SECURITY 974.13 - 974.13 619- 1065 - 460 -63-42 BUILDING MAINTENANCE 6,568.43 6,568.43 619 - 1065 - 460 -63-43 VEHICLE LEASE 387.40 387.40 127,077.49 Proshop 619 - 1065 - 460 -64 -01 SALARIES 245,033.53 (3,864.58) 241,168.95 619- 1065- 460 -64 -02 PAYROLL OVERHEAD 16,222.62 (579.69) 15,642.93 619- 1065 - 460 -64 -03 HEALTH INSURANCE 13,467.16 13,467.16 619- 1065- 460 -64 -05 DUES /SUBSCRIPTIONS 450.00 450.00 619- 1065 - 460 -64 -06 TRAVEL ALLOWANCE 5,734.39 5,734.39 619- 1065- 460 -64 -07 PROF. EDUCATION 164.90 164.90 619- 1065 - 460 -64 -08 UNIFORMS /CLOTHING 156.65 156.65 619- 1065- 460 -64 -10 COST OF GOODS SOLD 124,507.34 124,507.34 619- 1065 - 460 -64 -11 RANGE BALLS /SUPPLY 5,347.80 5,347.80 619 - 1065- 460 -64 -13 RENTAL CLUBS 1,659.28 1,659.28 619- 1065 - 460 -64 -14 GOLF CART PRINCIPAL 56,421.00 (56,421.00) - Schedule #75 619 - 1065 - 460 -64 -14 GOLF CART INTEREST - - 619- 1065 - 460 -64 -15 GOLF CART ELECTRICITY 14,713.73 14,713.73 619 - 1065 - 460 -64 -16 GOLF CART MAINTENANCE 2,475.83 2,475.83 619- 1065 - 460 -64 -17 HANDICAP SERVICE 4,574.50 4,574.50 619 - 1065 - 460 -64 -18 PRO SHOP SUPPLIES 2,228.26 2,228.26 619- 1065 - 460 -64 -19 SCORECARDS 982.73 982.73 619 - 1065 - 460 -64 -24 GPS FEES 48,314.08 48,314.08 619- 1065 - 460 -64 -30 TOURNAMENT EXP - LPGA 104,498.78 104,498.78 619 - 1065 - 460 -64 -90 DEPRIATION EXPENSE - - 586,087.31 Concessions 619 - 1065 - 460 -65 -01 SALARIES 49,602.71 49,602.71 619- 1065- 460 -65 -02 PAYROLL OVERHEAD 7,320.30 7,320.30 619- 1065 - 460 -65 -03 HEALTH INSURANCE 836.42 4.21 840.63 619- 1065- 460 -65 -08 UNIFORMS /CLOTHING 1,795.45 - 1,795.45 619- 1065 - 460 -65 -10 COST OF GOODS SOLD 80,185.46 (220.67) (47.34) 79,917.45 619 - 1065- 460 -65 -12 PAPER GOODS 4,015.98 4,015.98 619- 1065 - 460 -65 -13 CLEANING SUPPLIES 2,307.60 2,307.60 619- 1065- 460 -65 -14 UTENSILS 30.00 30.00 619- 1065 - 460 -65 -16 EQUIPMENT /SUPPLIES 3,808.67 3,808.67 619 - 1065- 460 -65 -17 LINENS 3,287.48 3,287.48 619- 1065 - 460 -65 -18 MISCELLANEOUS 335.82 335.82 619 - 1065 - 460 -65 -19 OUTING EXPENSE 1,636.07 1,636.07 619 - 1065- 460 -65 -20 LICENSES & PERMITS 1,135.00 1,135.00 156,033.16 19 of South Bend, Indiana version Worksheets aber 31, 2013 20 FUND 619 BLACKTHORN GOLF COURSE OPERATIONS 12/31/13 12/31/13 Auditor's Prior Year Current Year CAFR Account Number Account Name Worksheet Adjustments Adjustments Balance Totals Notes Other - 619- 1065 - 460 -66 -10 FIXED FEE 96,000.00 - 96,000.00 619- 1065- 460 -66 -12 MGMNT. EXPENSE 6,412.56 45.51 6,458.07 AMORTIZE LOSS ON REFUNDING - 3,528.36 3,528.36 AMORTIZE BOND DISCOUNT 2,104.12 2,104.12 BOND ISSUE COST AMORTIZATION 722.57 722.57 BOND INTEREST EXPENSE 14,880.00 14,880.00 $14.880.00 Wells Fargo statement BOND INTEREST ACCRUED INT ADJ (9,975.42) (9,975.42) $9,975.42 12/31/12 accrual CAPITAL LEASE INTEREST 6,833.48 6,833.48 Schedule #75 TRUSTEE FEES 1,250.00 1,250.00 $1,250.00 Wells Fargo statement DEPRECIATION EXPENSE 157,513.00 157,513.00 Capital Asset Schedule 619- 1050 - 460 -50 -02 TRANSFER OUT - FUND 319 275,500.00 275,500.00 Close out Fund 319.$275,500.00 to fund 324 619- 1050- 460 -50 -02 TRANSFER OUT - FUND 319 - - $50,500.00 to fund 619 eliminated in revene 319- 1002 - 460 -50 -02 INTER -FUND OPER. TRANSFER 463.63 (167.20) 296.43 Transfer to Fund -interest 319 - 1050 - 460 -50 -02 INTER -FUND OPER. TRANSFER 326,000.00 - 326,000.00 Transfer to Fund - Debt OTHER - 119.32 119.32 Total - $326,000.00 - - - 881,229.93 (0.00) 0.00 0.00 (0.00) 20 City of South Bend Blackthorn Redevelopment Accounts - Fund 619 Conversion Worksheet December 31, 2013 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, 21 #70395302 Operation & Reserve #70395300 Bond Sinking Totals Closed Closed Beginning Balance, January 1, 2013 $111,279.95 $316,964.66 $428,244.61 Interest earned 1.79 5.12 6.91 Transfer from Another Account 0.00 110,031.74 110,031.74 Lease Rental Paid from City Funds 0.00 207,878.85 207,878.85 Trustee Fees Paid to Well Fargo (1,250.00) 0.00 (1,250.00) Bond Principal Paid 0.00 (620,000.00) (620,000.00) Bond Interest Paid 0.00 (14,880.00) (14,880.00) Transfer to Another Account (110,031.74) 0.00 (110,031.74) Other 0.00 (0.37) (0.37) Excess Lease Rental 0.00 0.00 0.00 Ending Balance, December 31, 2013 ($0.00) ($0.00) ($0.00) 21 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, 2013 Unadjusted Trial Balance Account Name 12/31/13 Adjustments CAFR Trial Balance 12/31/13 Cash - Police & Fire 13,834.11 0.00 13,834.11 Cash - Public Works Building, 87.7% of total 612,776.96 (76,129.30) 3 536,647.66 Cash - Wells Fargo - Defeasance Account 0.00 0.00 5 0.00 Cash - US Bank 2013 Revenue Bond Issue 45,346.59 0.00 45,346.59 Accounts Payable 0.00 0.00 4 0.00 Beginning Fund Balance, per CAFR 12/31/12 (15,233,308.95) 14,691,959.88 (541,349.07) Interest Income (17,909.86) 17,738.50 5 (171.36) Contributions (1.00) 0.00 (1.00) Transfers In - From City Funds (2,320,500.00) 83,209.50 1 (2,237,290.50) Transfers In - From Building Corporation Accounts (20,081,725.34) 20,081,725.34 2 0.00 Bond Proceeds - EMS Bond (see also Fund 288) (5,539,916.95) 5,295,454.08 6,7 (244,462.87) Account Fees 4,901.00 0.00 4,901.00 Cost of Issuance of Bonds 150,950.37 21,307.05 4,7 172,257.42 Bond Discount 0.00 15,726.00 8 15,726.00 Debt Service - Principal 2,805,000.00 (1,132,115.00) 1,5 1,672,885.00 Debt Service - Interest 1,218,955.67 (666,613.60) 1,5 552,342.07 Debt Service - Bond Redemption - Interest 12,915,000.00 (12,915,000.00) 5 0.00 Transfers Out - To Building Corporation Accounts 20,081,725.32 (20,081,725.32) 2 0.00 Acquire Prop & Title 265,484.95 (256,150.00) 6 9,334.95 Project Expenses 5,079,387.13 (5,079,387.13) 6 0.00 Other 0.00 0.00 0.00 Proof Total 0.00 (9-40JO (D.DD) 1 - eliminate Wastewater portion of Public Works Building COIT debt service and Transfer In of 12.3% account no. 641 - 0630 - 793 -37 -02 - $0 paid to Wells Fargo in lease payments in 2013. 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. 4 - record 2012 Police & Fire bond issuance costs paid in 2013 in accounts payable. 5 - eliminate 2012 Police & Fire Wells Fargo defeasance account balance (used for future debt service). Account closed in 8/2/2013. 6 - eliminate $5,335,537.13 in 2013 EMS project costs recorded in fund 288. Reimbursement draw deposited in fund 288. some bond proceeds and issuance costs for the 2013 EMS bond are recorded in this fund 7 - SBOA adjustment to increase debt issuance by $15,726 and $24,357 for debt issuance for surety bond costs paid from bond proceeds. Adjust so total bond issuance costs are $5,580,000 between Fund 288 and Bldg Corp Fund. 8 - discount on 2013 Building Corporation bond. 22 City of South Bend, Indiana Building Corporation Transactions - Per Trustee Statements January 1, 2013 through December 31, 2013 Wells Fargo Wells Fargo Wells Fargo Defeasance 2010 COIT 2001 COIT 2010 Refunding Wells Fargo Wells Fargo US Bank US Bank 2010 Refunding 2010 Refunding Public Works 2003 Police /Fire 2012 Police /Fire 2012 Police /Fire 2012 Police /Fire Debt Reserve Sinking Fund Operation /Res. Sinking Fund Escrow Refunding Sinking Fund Oper /Reserve 10835901 10835900 10835905 14873700 48187900 20039600 200396001 Jan -Aug 2013 Sep -Dec 2012 Acct closed 8/2/13 Acct closed 8/2/13 Balance @ January 1, 2013 $607,500.00 $52.04 $4,189.09 $0.00 $14,613,146.50 $8,420.32 $0.00 Receipts: Interest 60.74 0.00 0.07 0.00 17,738.50 8.60 0.56 Lease Payments from City 0.00 676,500.00 0.00 0.00 1,644,000.00 0.00 Contributions 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Transfer From Other Accounts (1) 0.00 60.76 3,060.00 14,630,885.00 0.00 0.30 5,796.83 Bond Proceeds 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total Receipts 60.74 676,560.76 3,060.07 14,630,885.00 17,738.50 1,644,008.90 5,797.39 Disbursements: Account Fees 0.00 0.00 2,000.00 0.00 0.00 0.00 1,000.00 Debt Service - Principal 0.00 505,000.00 0.00 1,070,000.00 0.00 1,230,000.00 0.00 Debt Service - Interest 0.00 168,525.00 0.00 645,885.00 0.00 404,545.67 0.00 Debt Service - Bond Redemption 0.00 0.00 0.00 12,915,000.00 0.00 0.00 0.00 Transfer to Other Accounts (1) 60.74 3,060.00 0.00 0.00 14,630,885.00 8,846.83 0.00 Acquire Prop & Title 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Project Expenses 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Cost of Issuance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total Disbursements 60.74 676,585.00 2,000.00 14,630,885.00 14,630,885.00 1,643,392.50 1,000.00 Balance @ December 31, 2013 $607,500.00 $27.80 $5,249.16 $0.00 $0.00 $9,036.72 $4,797.39 23 City of South Bend, Indiana Building Corporation Transactions - Per Trustee Statements January 1, 2013 through December 31, 2013 US Bank US Bank US Bank US Bank US Bank US Bank 2012 Police /Fire 2012 Police /Fire 2013 Rev Bond 2013 Rev Bond 2013 Rev Bond 2013 Rev Bond Reserve Issuance Costs Sinking Fund Reserve Const Fund Bond Int Acct Grand 200396002 200396003 206670000 206670002 206670003 206670004 Total Balance @ January 1, 2013 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $15,233,307.95 Receipts: Interest 0.00 0.30 0.00 0.00 100.20 0.89 17,909.86 Lease Payments from City 0.00 0.00 0.00 0.00 0.00 0.00 2,320,500.00 Contributions 0.00 0.00 0.00 1.00 0.00 0.00 1.00 Transfer From Other Accounts (1) 0.00 3,050.00 0.00 0.00 5,438,872.45 0.00 20,081,725.34 Bond Proceeds 0.00 0.00 5,438,872.45 0.00 55,800.00 45,244.50 5,539,916.95 Total Receipts 0.00 3,050.30 5,438,872.45 1.00 5,494,772.65 45,245.39 27,960,053.15 Disbursements: Account Fees 0.00 0.00 0.00 0.00 1,900.00 0.00 4,900.00 Debt Service - Principal 0.00 0.00 0.00 0.00 0.00 0.00 2,805,000.00 Debt Service - Interest 0.00 0.00 0.00 0.00 0.00 0.00 1,218,955.67 Debt Service - Bond Redemption 0.00 0.00 0.00 0.00 0.00 0.00 12,915,000.00 Transfer to Other Accounts (1) 0.00 0.30 5,438,872.45 0.00 0.00 0.00 20,081,725.32 Acquire Prop & Title 0.00 0.00 0.00 0.00 265,484.95 0.00 265,484.95 Project Expenses 0.00 0.00 0.00 0.00 5,079,387.13 0.00 5,079,387.13 Cost of Issuance 0.00 3,050.00 0.00 0.00 147,900.37 0.00 150,950.37 Total Disbursements 0.00 3,050.30 5,438,872.45 0.00 5,494,672.45 0.00 42,521,403.44 Balance @ December 31, 2013 $0.00 $0.00 $0.00 $1.00 $100.20 $45,245.39 $671,957.66 $1,395,500 Assured Guaranty Insurance 24