| ALEXANDER CITY BOARD OF EDUCATION | |||||||||||||||
| COMBINED BALANCE SHEET - ALL FUND TYPES AND ACCOUNT GROUPS | |||||||||||||||
| FISCAL PERIOD ENDING MARCH 31, 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 | $ 7,730,522.60 | $ 1,136,313.91 | $ (94,402.21) | $ (43,592.09) | $ 470,489.92 | $ - | |||||||||
| Investments | - | 67,048.96 | - | - | 2,240.77 | - | |||||||||
| Receivables: | |||||||||||||||
| Interfund | - | - | - | - | - | - | |||||||||
| Other | 25,717.03 | 426,713.42 | - | - | 19,873.36 | - | |||||||||
| Inventories | - | 79,550.91 | - | - | - | - | |||||||||
| Other Assets | - | - | - | - | - | - | |||||||||
| Fixed Assets | - | - | - | - | - | 36,946,572.83 | |||||||||
| Other Debits: | |||||||||||||||
| Debt Service | - | - | - | - | - | 287,335.69 | |||||||||
| Long-Term Debt | - | - | - | - | - | 4,130,099.35 | |||||||||
| Total Assets and Other Debits | $ 7,756,239.63 | $ 1,709,627.20 | $ (94,402.21) | $ (43,592.09) | $ 492,604.05 | $ 41,364,007.87 | |||||||||
| Liabilities and Fund Equity | |||||||||||||||
| Liabilities | |||||||||||||||
| Salaries and Benefits | 1,206.08 | 106.28 | - | - | - | - | |||||||||
| Payroll Taxes | - | - | - | - | 47,435.45 | - | |||||||||
| Interfund | - | - | - | - | - | - | |||||||||
| Accounts Payable | 602,568.65 | 415,797.71 | - | - | 79,949.22 | - | |||||||||
| Long-Term Liabilities | - | - | - | - | - | 4,417,435.04 | |||||||||
| Total Liabilities | $ 603,774.73 | $ 415,903.99 | $ - | $ - | $ 127,384.67 | $ 4,417,435.04 | |||||||||
| Fund Equity | |||||||||||||||
| Investment in Gen. Fixed Assets | - | - | - | - | - | 36,946,572.83 | |||||||||
| Reserved Fund Balance | 250,000.00 | 79,550.91 | - | - | - | - | |||||||||
| Unreserved Fund Balance | 6,902,464.90 | 1,214,172.30 | (94,402.21) | (43,592.09) | 365,219.38 | - | |||||||||
| Total Fund Equity | $ 7,152,464.90 | $ 1,293,723.21 | $ (94,402.21) | $ (43,592.09) | $ 365,219.38 | $ 36,946,572.83 | |||||||||
| Total Liabilities and Fund Equity | $ 7,756,239.63 | $ 1,709,627.20 | $ (94,402.21) | $ (43,592.09) | $ 492,604.05 | $ 41,364,007.87 | |||||||||
| 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 MARCH 31, 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 | 8,425,616.52 | 1,300.00 | 60,624.00 | - | - | 8,487,540.52 | |||||||||
| FEDERAL REVENUES | 20,045.43 | 2,270,446.97 | - | - | - | 2,290,492.40 | |||||||||
| LOCAL REVENUES | 4,926,109.58 | 604,277.90 | 60,250.00 | - | 326,564.11 | 5,917,201.59 | |||||||||
| OTHER SOURCES | 31,738.60 | 40,075.77 | - | - | - | 71,814.37 | |||||||||
| TOTAL REVENUES | $ 13,403,510.13 | $ 2,916,100.64 | $ 120,874.00 | $ - | $ 326,564.11 | $ 16,767,048.88 | |||||||||
| EXPENDITURES: | |||||||||||||||
| INSTRUCTIONAL SERVICES | 7,239,442.34 | 1,082,916.05 | - | - | 76,756.96 | 8,399,115.35 | |||||||||
| INSTRUCTIONAL SUPPORT SERVICES | 1,995,613.13 | 342,608.70 | - | 2,155.87 | 153,143.02 | 2,493,520.72 | |||||||||
| OPERATION & MAINTENANCE | 822,926.40 | 63,355.03 | - | - | - | 886,281.43 | |||||||||
| AUXILIARY SERVICES | 1,002,215.11 | 1,126,878.13 | - | 524,232.35 | 5,201.36 | 2,658,526.95 | |||||||||
| GENERAL ADMINISTRATIVE SERVICES | 425,214.86 | 82,694.01 | - | 62,951.25 | - | 570,860.12 | |||||||||
| CAPITAL OUTLAY | 100,000.00 | - | - | - | - | 100,000.00 | |||||||||
| DEBT SERVICES | - | - | 503,070.12 | 1,587.00 | - | 504,657.12 | |||||||||
| OTHER EXPENDITURES | 495,316.55 | 160,090.10 | - | - | 89,163.21 | 744,569.86 | |||||||||
| TOTAL EXPENDITURES | $ 12,080,728.39 | $ 2,858,542.02 | $ 503,070.12 | $ 590,926.47 | $ 324,264.55 | $ 16,357,531.55 | |||||||||
| OTHER FUND SOURCES (USES): | |||||||||||||||
| TRANSFERS IN & OTHER FUND SOURCES | 104,842.08 | 157,541.85 | - | 455,455.00 | 3,422.17 | 721,261.10 | |||||||||
| TRANSFERS OUT | (68,494.06) | (94,762.38) | - | - | (17,830.95) | (181,087.39) | |||||||||
| TOTAL OTHER FUND SOURCES (USES) | $ 36,348.02 | $ 62,779.47 | $ - | $ 455,455.00 | $ (14,408.78) | $ 540,173.71 | |||||||||
| EXCESS REVENUES & OTHER SOURCES OVER(UNDER) EXPENDITURES & OTHER FUND USES | $ 1,359,129.76 | $ 120,338.09 | $ (382,196.12) | $ (135,471.47) | $ (12,109.22) | $ 949,691.04 | |||||||||
| BEGINNING FUND BALANCE - OCT 1 | $ 5,793,335.14 | $ 1,173,385.12 | $ 287,793.91 | $ 91,879.38 | $ 377,328.60 | $ 7,723,722.15 | |||||||||
| ENDING FUND BALANCE - OCT 31 | $ 7,152,464.90 | $ 1,293,723.21 | $ (94,402.21) | $ (43,592.09) | $ 365,219.38 | $ 8,673,413.19 | |||||||||
| ALEXANDER CITY BOARD OF EDUCATION | |||||||||||||||
| COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES | |||||||||||||||
| BUDGET AND ACTUAL | |||||||||||||||
| FISCAL PERIOD ENDING MARCH 31, 2017 | |||||||||||||||
| EXHIBIT F-III-A | |||||||||||||||
| FUND TYPE | GENERAL | SPECIAL | |||||||||||||
| DESCRIPTION | BUDGET | ACTUAL | VARIANCE | BUDGET | ACTUAL | VARIANCE | |||||||||
| REVENUES: | |||||||||||||||
| STATE REVENUES | 16,707,855.48 | 8,425,616.52 | (8,282,238.96) | - | 1,300.00 | 1,300.00 | |||||||||
| FEDERAL REVENUES | 61,934.00 | 20,045.43 | (41,888.57) | 4,459,542.05 | 2,270,446.97 | (2,189,095.08) | |||||||||
| LOCAL REVENUES | 7,768,467.00 | 4,926,109.58 | (2,842,357.42) | 1,165,998.00 | 604,277.90 | (561,720.10) | |||||||||
| OTHER SOURCES | 155,316.00 | 31,738.60 | (123,577.40) | 56,700.00 | 40,075.77 | (16,624.23) | |||||||||
| TOTAL REVENUES | 24,693,572.48 | 13,403,510.13 | (11,290,062.35) | 5,682,240.05 | 2,916,100.64 | (2,766,139.41) | |||||||||
| EXPENDITURES: | |||||||||||||||
| INSTRUCTIONAL SERVICES | 14,592,614.71 | 7,239,442.34 | (7,353,172.37) | 2,219,843.36 | 1,082,916.05 | (1,136,927.31) | |||||||||
| INSTRUCTIONAL SUPPORT SERVICES | 4,115,324.63 | 1,995,613.13 | (2,119,711.50) | 616,752.89 | 342,608.70 | (274,144.19) | |||||||||
| OPERATION & MAINTENANCE | 2,098,836.00 | 822,926.40 | (1,275,909.60) | 86,117.62 | 63,355.03 | (22,762.59) | |||||||||
| AUXILIARY SERVICES | 1,421,558.65 | 1,002,215.11 | (419,343.54) | 2,035,559.37 | 1,126,878.13 | (908,681.24) | |||||||||
| GENERAL ADMINISTRATIVE SERVICES | 1,052,155.01 | 425,214.86 | (626,940.15) | 188,930.79 | 82,694.01 | (106,236.78) | |||||||||
| CAPITAL OUTLAY | 100,000.00 | 100,000.00 | - | - | - | - | |||||||||
| DEBT SERVICES | - | - | - | - | - | - | |||||||||
| PRINCIPAL | |||||||||||||||
| INTEREST | |||||||||||||||
| OTHER EXPENDITURES | 905,367.95 | 495,316.55 | (410,051.40) | 429,154.71 | 160,090.10 | (269,064.61) | |||||||||
| TOTAL EXPENDITURES | 24,285,856.95 | 12,080,728.39 | (12,205,128.56) | 5,576,358.74 | 2,858,542.02 | (2,717,816.72) | |||||||||
| OTHER FUND SOURCES (USES): | |||||||||||||||
| TRANSFERS IN | 70,635.40 | 15,292.86 | (55,342.54) | 171,428.00 | 157,541.85 | (13,886.15) | |||||||||
| OTHER FUND SOURCES | 136,880.29 | 89,549.22 | (47,331.07) | - | - | - | |||||||||
| OTHER FUND USES | (64,500.00) | (68,494.06) | (3,994.06) | (158,758.40) | (94,762.38) | 63,996.02 | |||||||||
| TOTAL OTHER FUND SOURCES (USES) | 143,015.69 | 36,348.02 | (106,667.67) | 12,669.60 | 62,779.47 | 50,109.87 | |||||||||
| EXCESS REVENUES & OTHER SOURCES OVER(UNDER) EXPENDITURES & OTHER FUND USES | 550,731.22 | 1,359,129.76 | 808,398.54 | 118,550.91 | 120,338.09 | 1,787.18 | |||||||||
| BEGINNING FUND BALANCE | 5,793,335.14 | 5,793,335.14 | - | 1,173,385.12 | 1,173,385.12 | - | |||||||||
| ENDING FUND BALANCE | 6,344,066.36 | 7,152,464.90 | 808,398.54 | 1,291,936.03 | 1,293,723.21 | 1,787.18 | |||||||||
| ALEXANDER CITY BOARD OF EDUCATION | |||||||||||||||
| COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES | |||||||||||||||
| BUDGET AND ACTUAL | |||||||||||||||
| FISCAL PERIOD ENDING MARCH 31, 2017 | |||||||||||||||
| EXHIBIT F-III-B | |||||||||||||||
| FUND TYPE | DEBT SERVICE | CAPITAL PROJECTS | |||||||||||||
| DESCRIPTION | BUDGET | ACTUAL | VARIANCE | BUDGET | ACTUAL | VARIANCE | |||||||||
| REVENUES: | |||||||||||||||
| STATE REVENUES | 843,380.00 | 60,624.00 | (782,756.00) | - | - | - | |||||||||
| FEDERAL REVENUES | - | - | - | - | - | - | |||||||||
| LOCAL REVENUES | 60,250.00 | 60,250.00 | - | - | - | - | |||||||||
| OTHER SOURCES | 1,435,235.00 | - | (1,435,235.00) | - | - | - | |||||||||
| TOTAL REVENUES | 2,338,865.00 | 120,874.00 | (2,217,991.00) | - | - | - | |||||||||
| EXPENDITURES: | |||||||||||||||
| INSTRUCTIONAL SERVICES | - | - | - | - | - | - | |||||||||
| INSTRUCTIONAL SUPPORT SERVICES | - | - | - | 4,000.00 | 2,155.87 | (1,844.13) | |||||||||
| OPERATION & MAINTENANCE | - | - | - | - | - | - | |||||||||
| AUXILIARY SERVICES | - | - | - | 524,232.35 | 524,232.35 | - | |||||||||
| GENERAL ADMINISTRATIVE SERVICES | - | - | - | 139,606.27 | 62,951.25 | (76,655.02) | |||||||||
| CAPITAL OUTLAY | - | - | - | - | - | - | |||||||||
| DEBT SERVICES | 2,196,805.37 | 503,070.12 | (1,693,735.25) | 3,174.00 | 1,587.00 | (1,587.00) | |||||||||
| PRINCIPAL | |||||||||||||||
| INTEREST | |||||||||||||||
| OTHER EXPENDITURES | - | - | - | - | - | - | |||||||||
| TOTAL EXPENDITURES | 2,196,805.37 | 503,070.12 | (1,693,735.25) | 671,012.62 | 590,926.47 | (80,086.15) | |||||||||
| OTHER FUND SOURCES (USES): | |||||||||||||||
| TRANSFERS IN | - | - | - | 132,378.31 | - | (132,378.31) | |||||||||
| OTHER FUND SOURCES | - | - | - | 455,455.00 | 455,455.00 | - | |||||||||
| OTHER FUND USES | (132,378.31) | - | 132,378.31 | - | - | - | |||||||||
| TOTAL OTHER FUND SOURCES (USES) | (132,378.31) | - | 132,378.31 | 587,833.31 | 455,455.00 | (132,378.31) | |||||||||
| EXCESS REVENUES & OTHER SOURCES OVER(UNDER) EXPENDITURES & OTHER FUND USES | 9,681.32 | (382,196.12) | (391,877.44) | (83,179.31) | (135,471.47) | (52,292.16) | |||||||||
| BEGINNING FUND BALANCE | 287,793.91 | 287,793.91 | - | 91,879.38 | 91,879.38 | - | |||||||||
| ENDING FUND BALANCE | 297,475.23 | (94,402.21) | (391,877.44) | 8,700.07 | (43,592.09) | (52,292.16) | |||||||||
| ALEXANDER CITY BOARD OF EDUCATION | |||||||||||||||
| COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES | |||||||||||||||
| BUDGET AND ACTUAL | |||||||||||||||
| FISCAL PERIOD ENDING MARCH 31, 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,551,235.48 | 8,487,540.52 | (9,063,694.96) | |||||||||
| FEDERAL REVENUES | - | - | - | 4,521,476.05 | 2,290,492.40 | (2,230,983.65) | |||||||||
| LOCAL REVENUES | 554,531.00 | 326,564.11 | (227,966.89) | 9,549,246.00 | 5,917,201.59 | (3,632,044.41) | |||||||||
| OTHER SOURCES | - | - | - | 1,647,251.00 | 71,814.37 | (1,575,436.63) | |||||||||
| TOTAL REVENUES | 554,531.00 | 326,564.11 | (227,966.89) | 33,269,208.53 | 16,767,048.88 | (16,502,159.65) | |||||||||
| EXPENDITURES: | |||||||||||||||
| INSTRUCTIONAL SERVICES | 155,721.00 | 76,756.96 | (78,964.04) | 16,968,179.07 | 8,399,115.35 | (8,569,063.72) | |||||||||
| INSTRUCTIONAL SUPPORT SERVICES | 200,840.00 | 153,143.02 | (47,696.98) | 4,936,917.52 | 2,493,520.72 | (2,443,396.80) | |||||||||
| OPERATION & MAINTENANCE | 4,100.00 | - | (4,100.00) | 2,189,053.62 | 886,281.43 | (1,302,772.19) | |||||||||
| AUXILIARY SERVICES | 12,245.00 | 5,201.36 | (7,043.64) | 3,993,595.37 | 2,658,526.95 | (1,335,068.42) | |||||||||
| GENERAL ADMINISTRATIVE SERVICES | - | - | - | 1,380,692.07 | 570,860.12 | (809,831.95) | |||||||||
| CAPITAL OUTLAY | - | - | - | 100,000.00 | 100,000.00 | - | |||||||||
| DEBT SERVICES | - | - | - | 2,199,979.37 | 504,657.12 | (1,695,322.25) | |||||||||
| PRINCIPAL | |||||||||||||||
| INTEREST | |||||||||||||||
| OTHER EXPENDITURES | 116,004.00 | 89,163.21 | (26,840.79) | 1,450,526.66 | 744,569.86 | (705,956.80) | |||||||||
| TOTAL EXPENDITURES | 488,910.00 | 324,264.55 | (164,645.45) | 33,218,943.68 | 16,357,531.55 | (16,861,412.13) | |||||||||
| OTHER FUND SOURCES (USES): | |||||||||||||||
| TRANSFERS IN | 23,172.00 | 3,422.17 | (19,749.83) | 397,613.71 | 176,256.88 | (221,356.83) | |||||||||
| OTHER FUND SOURCES | - | - | - | 592,335.29 | 545,004.22 | (47,331.07) | |||||||||
| OTHER FUND USES | (41,977.00) | (17,830.95) | 24,146.05 | (397,613.71) | (181,087.39) | 216,526.32 | |||||||||
| TOTAL OTHER FUND SOURCES (USES) | (18,805.00) | (14,408.78) | 4,396.22 | 592,335.29 | 540,173.71 | (52,161.58) | |||||||||
| EXCESS REVENUES & OTHER SOURCES OVER(UNDER) EXPENDITURES & OTHER FUND USES | 46,816.00 | (12,109.22) | (58,925.22) | 642,600.14 | 949,691.04 | 307,090.90 | |||||||||
| BEGINNING FUND BALANCE | 377,328.60 | 377,328.60 | - | 7,723,722.15 | 7,723,722.15 | - | |||||||||
| ENDING FUND BALANCE | 424,144.60 | 365,219.38 | (58,925.22) | 8,366,322.29 | 8,673,413.19 | 307,090.90 | |||||||||