ALEXANDER CITY BOARD OF EDUCATION
COMBINED BALANCE SHEET - ALL FUND TYPES AND ACCOUNT GROUPS
FISCAL PERIOD ENDING NOVEMBER 30, 2017
EXHIBIT F-I-A
Fund Types and Account Groups Governmental Fiduciary Account Groups
General Special Revenue Debt Service Capital Projects Trust F/A & L/T Debt
Assets and Other Debits      
Cash $ 6,998,483.74 $ 911,648.92 $ 455,004.16 $ (462.33) $ 460,289.84 $ -
Investments - 67,239.45 - - 2,466.59 -
Receivables:      
Interfund - - - - - -
Other 45,369.80 760,497.76 - - 3,425.45 -
Inventories - 66,890.04 - - - -
Other Assets - - - - - -
Fixed Assets - - - - - 39,573,983.72
Other Debits:      
Debt Service - - - - - 352,324.76
Long-Term Debt - - - - - 7,288,281.08
Total Assets and Other Debits $ 7,043,853.54 $ 1,806,276.17 $ 455,004.16 $ (462.33) $ 466,181.88 $ 47,214,589.56
Liabilities and Fund Equity
Liabilities
Salaries and Benefits 1,192.03 51.77 - - - -
Payroll Taxes - - - - 49,600.53 -
Interfund - - - - - -
Accounts Payable 133,738.72 422,819.12 - 6,000.00 47,891.68 -
Long-Term Liabilities - - - - - 7,640,605.84
Total Liabilities $ 134,930.75 $ 422,870.89 $ - $ 6,000.00 $ 97,492.21 $ 7,640,605.84
   
Fund Equity    
Investment in Gen. Fixed Assets - - - - - 39,573,983.72
Reserved Fund Balance 250,000.00 66,890.04 - - - -
Unreserved Fund Balance 6,658,922.79 1,316,515.24 455,004.16 (6,462.33) 368,689.67 -
Total Fund Equity $ 6,908,922.79 $ 1,383,405.28 $ 455,004.16 $ (6,462.33) $ 368,689.67 $ 39,573,983.72
   
Total Liabilities and Fund Equity $ 7,043,853.54 $ 1,806,276.17 $ 455,004.16 $ (462.33) $ 466,181.88 $ 47,214,589.56
ALEXANDER CITY BOARD OF EDUCATION
COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES
ALL GOVERNMENTAL FUND TYPES AND EXPENDABLE TRUST FUNDS
FISCAL PERIOD ENDING NOVEMBER 30, 2017
EXHIBIT F-II-A
FUND TYPE Governmental Fiduciary Total
DESCRIPTION General Special Revenue Debt Service Capital Projects Expendable Trust (Memorandum Only
   
REVENUES:    
STATE REVENUES 2,703,684.65 1,500.00 15,858.00 - - 2,721,042.65
FEDERAL REVENUES 2,318.86 882,805.33 - - - 885,124.19
LOCAL REVENUES 1,220,748.46 250,264.23 77,046.00 - 86,672.04 1,634,730.73
OTHER SOURCES 10,171.20 - - - - 10,171.20
TOTAL REVENUES $ 3,936,923.17 $ 1,134,569.56 $ 92,904.00 $ - $ 86,672.04 $ 5,251,068.77
   
EXPENDITURES:    
INSTRUCTIONAL SERVICES 2,577,000.57 326,496.14 - - 22,539.25 2,926,035.96
INSTRUCTIONAL SUPPORT SERVICES 662,393.62 121,219.06 - - 46,090.21 829,702.89
OPERATION & MAINTENANCE 302,318.12 18,092.22 - - 336.60 320,746.94
AUXILIARY SERVICES 190,034.04 403,209.33 - - 121.50 593,364.87
GENERAL ADMINISTRATIVE SERVICES 192,718.98 38,722.46 - 36,117.37 - 267,558.81
CAPITAL OUTLAY - - - - - -
DEBT SERVICES - - 56,767.28 - - 56,767.28
OTHER EXPENDITURES 153,375.40 68,696.87 - - 33,662.46 255,734.73
TOTAL EXPENDITURES $ 4,077,840.73 $ 976,436.08 $ 56,767.28 $ 36,117.37 $ 102,750.02 $ 5,249,911.48
   
OTHER FUND SOURCES (USES):    
TRANSFERS IN & OTHER FUND SOURCES 26,213.01 52,757.68 - - 110.00 79,080.69
TRANSFERS OUT (33,827.83) (26,085.20) - - (110.00) (60,023.03)
TOTAL OTHER FUND SOURCES (USES) $ (7,614.82) $ 26,672.48 $ - $ - $ - $ 19,057.66
   
EXCESS REVENUES & OTHER SOURCES OVER(UNDER) EXPENDITURES & OTHER FUND USES $ (148,532.38) $ 184,805.96 $ 36,136.72 $ (36,117.37) $ (16,077.98) $ 20,214.95
   
BEGINNING FUND BALANCE - OCT 1 $ 7,057,455.17 $ 1,198,599.32 $ 418,867.44 $ 29,655.04 $ 384,767.65 $ 9,089,344.62
   
ENDING FUND BALANCE - OCT 31 $ 6,908,922.79 $ 1,383,405.28 $ 455,004.16 $ (6,462.33) $ 368,689.67 $ 9,109,559.57
ALEXANDER CITY BOARD OF EDUCATION
COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES
BUDGET AND ACTUAL
FISCAL PERIOD ENDING NOVEMBER 30, 2017
EXHIBIT F-III-A
FUND TYPE GENERAL SPECIAL
DESCRIPTION BUDGET ACTUAL VARIANCE BUDGET ACTUAL VARIANCE
     
REVENUES:      
STATE REVENUES 16,401,763.00 2,703,684.65 (13,698,078.35) - 1,500.00 1,500.00
FEDERAL REVENUES 71,403.00 2,318.86 (69,084.14) 3,988,765.00 882,805.33 (3,105,959.67)
LOCAL REVENUES 8,044,025.92 1,220,748.46 (6,823,277.46) 1,182,426.00 250,264.23 (932,161.77)
OTHER SOURCES 170,456.00 10,171.20 (160,284.80) 37,971.00 - (37,971.00)
TOTAL REVENUES 24,687,647.92 3,936,923.17 (20,750,724.75) 5,209,162.00 1,134,569.56 (4,074,592.44)
     
EXPENDITURES:      
INSTRUCTIONAL SERVICES 14,491,575.46 2,577,000.57 (11,914,574.89) 2,003,663.57 326,496.14 (1,677,167.43)
INSTRUCTIONAL SUPPORT SERVICES 4,106,208.69 662,393.62 (3,443,815.07) 452,496.63 121,219.06 (331,277.57)
OPERATION & MAINTENANCE 1,901,135.31 302,318.12 (1,598,817.19) 83,450.00 18,092.22 (65,357.78)
AUXILIARY SERVICES 1,000,537.00 190,034.04 (810,502.96) 2,115,978.00 403,209.33 (1,712,768.67)
GENERAL ADMINISTRATIVE SERVICES 1,222,612.42 192,718.98 (1,029,893.44) 221,239.80 38,722.46 (182,517.34)
CAPITAL OUTLAY 1,024,485.00 - (1,024,485.00) - - -
DEBT SERVICES - - - - - -
PRINCIPAL      
INTEREST      
OTHER EXPENDITURES 916,190.65 153,375.40 (762,815.25) 408,073.00 68,696.87 (339,376.13)
TOTAL EXPENDITURES 24,662,744.53 4,077,840.73 (20,584,903.80) 5,284,901.00 976,436.08 (4,308,464.92)
     
OTHER FUND SOURCES (USES):      
TRANSFERS IN 64,310.00 - (64,310.00) 214,692.00 52,757.68 (161,934.32)
OTHER FUND SOURCES 145,162.80 26,213.01 (118,949.79) - - -
OTHER FUND USES (184,480.25) (33,827.83) 150,652.42 (189,772.00) (26,085.20) 163,686.80
TOTAL OTHER FUND SOURCES (USES) 24,992.55 (7,614.82) (32,607.37) 24,920.00 26,672.48 1,752.48
     
EXCESS REVENUES & OTHER SOURCES OVER(UNDER) EXPENDITURES & OTHER FUND USES 49,895.94 (148,532.38) (198,428.32) (50,819.00) 184,805.96 235,624.96
     
BEGINNING FUND BALANCE 7,057,455.17 7,057,455.17 - 1,198,599.32 1,198,599.32 -
     
ENDING FUND BALANCE 7,107,351.11 6,908,922.79 (198,428.32) 1,147,780.32 1,383,405.28 235,624.96
ALEXANDER CITY BOARD OF EDUCATION
COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES
BUDGET AND ACTUAL
FISCAL PERIOD ENDING NOVEMBER 30, 2017
EXHIBIT F-III-B
FUND TYPE DEBT SERVICE CAPITAL PROJECTS
DESCRIPTION BUDGET ACTUAL VARIANCE BUDGET ACTUAL VARIANCE
     
REVENUES:      
STATE REVENUES 819,585.00 15,858.00 (803,727.00) - - -
FEDERAL REVENUES - - - - - -
LOCAL REVENUES 77,046.00 77,046.00 - - - -
OTHER SOURCES 1,438,909.00 - (1,438,909.00) - - -
TOTAL REVENUES 2,335,540.00 92,904.00 (2,242,636.00) - - -
     
EXPENDITURES:      
INSTRUCTIONAL SERVICES - - - 4,852.16 - (4,852.16)
INSTRUCTIONAL SUPPORT SERVICES - - - - - -
OPERATION & MAINTENANCE - - - - - -
AUXILIARY SERVICES - - - - - -
GENERAL ADMINISTRATIVE SERVICES - - - 181,150.50 36,117.37 (145,033.13)
CAPITAL OUTLAY - - - - - -
DEBT SERVICES 2,301,700.67 56,767.28 (2,244,933.39) - - -
PRINCIPAL      
INTEREST      
OTHER EXPENDITURES - - - - - -
TOTAL EXPENDITURES 2,301,700.67 56,767.28 (2,244,933.39) 186,002.66 36,117.37 (149,885.29)
     
OTHER FUND SOURCES (USES):      
TRANSFERS IN 117,980.25 - (117,980.25) 162,664.58 - (162,664.58)
OTHER FUND SOURCES - - - - - -
OTHER FUND USES (162,664.58) - 162,664.58 - - -
TOTAL OTHER FUND SOURCES (USES) (44,684.33) - 44,684.33 162,664.58 - (162,664.58)
     
EXCESS REVENUES & OTHER SOURCES OVER(UNDER) EXPENDITURES & OTHER FUND USES (10,845.00) 36,136.72 46,981.72 (23,338.08) (36,117.37) (12,779.29)
     
BEGINNING FUND BALANCE 418,867.44 418,867.44 - 29,655.04 29,655.04 -
     
ENDING FUND BALANCE 408,022.44 455,004.16 46,981.72 6,316.96 (6,462.33) (12,779.29)
ALEXANDER CITY BOARD OF EDUCATION
COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES
BUDGET AND ACTUAL
FISCAL PERIOD ENDING NOVEMBER 30, 2017
EXHIBIT F-III-C
FUND TYPE EXPENDABLE TRUST TOTAL GOVERNMENT & EXPENDABLE TRUST FUNDS
DESCRIPTION BUDGET ACTUAL VARIANCE BUDGET ACTUAL VARIANCE
     
REVENUES:      
STATE REVENUES - - - 17,221,348.00 2,721,042.65 (14,500,305.35)
FEDERAL REVENUES - - - 4,060,168.00 885,124.19 (3,175,043.81)
LOCAL REVENUES 656,875.00 86,672.04 (570,202.96) 9,960,372.92 1,634,730.73 (8,325,642.19)
OTHER SOURCES - - - 1,647,336.00 10,171.20 (1,637,164.80)
TOTAL REVENUES 656,875.00 86,672.04 (570,202.96) 32,889,224.92 5,251,068.77 (27,638,156.15)
     
EXPENDITURES:      
INSTRUCTIONAL SERVICES 131,200.00 22,539.25 (108,660.75) 16,631,291.19 2,926,035.96 (13,705,255.23)
INSTRUCTIONAL SUPPORT SERVICES 257,685.00 46,090.21 (211,594.79) 4,816,390.32 829,702.89 (3,986,687.43)
OPERATION & MAINTENANCE 550.00 336.60 (213.40) 1,985,135.31 320,746.94 (1,664,388.37)
AUXILIARY SERVICES 15,240.00 121.50 (15,118.50) 3,131,755.00 593,364.87 (2,538,390.13)
GENERAL ADMINISTRATIVE SERVICES - - - 1,625,002.72 267,558.81 (1,357,443.91)
CAPITAL OUTLAY - - - 1,024,485.00 - (1,024,485.00)
DEBT SERVICES - - - 2,301,700.67 56,767.28 (2,244,933.39)
PRINCIPAL      
INTEREST      
OTHER EXPENDITURES 157,200.00 33,662.46 (123,537.54) 1,481,463.65 255,734.73 (1,225,728.92)
TOTAL EXPENDITURES 561,875.00 102,750.02 (459,124.98) 32,997,223.86 5,249,911.48 (27,747,312.38)
     
OTHER FUND SOURCES (USES):      
TRANSFERS IN 36,500.00 - (36,500.00) 596,146.83 52,757.68 (543,389.15)
OTHER FUND SOURCES - - - 145,162.80 26,213.01 (118,949.79)
OTHER FUND USES (65,230.00) - 65,230.00 (602,146.83) (59,913.03) 542,233.80
TOTAL OTHER FUND SOURCES (USES) (28,730.00) - 28,730.00 139,162.80 19,057.66 (120,105.14)
     
EXCESS REVENUES & OTHER SOURCES OVER(UNDER) EXPENDITURES & OTHER FUND USES 66,270.00 (16,077.98) (82,347.98) 31,163.86 20,214.95 (10,948.91)
     
BEGINNING FUND BALANCE 384,767.65 384,767.65 - 9,089,344.62 9,089,344.62 -
     
ENDING FUND BALANCE 451,037.65 368,689.67 (82,347.98) 9,120,508.48 9,109,559.57 (10,948.91)