| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Academy for Classical Education | |||||||||||||||||||||||||||
2 | 3rd Quarter Budget Report: 2021-2022 | |||||||||||||||||||||||||||
3 | Preliminary - Unaudited | |||||||||||||||||||||||||||
4 | ||||||||||||||||||||||||||||
5 | ||||||||||||||||||||||||||||
6 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2022 | 2022 | 2022 | 2022 | 2022 | |||||||||||||||||
7 | REVENUES | July | August | Sept | Oct | Nov | Dec | Jan | Feb | March | Apr | May | Actual Totals | Annual Budget | ||||||||||||||
8 | 8.33% | 16.67% | 25.00% | 33.33% | 41.67% | 50.00% | 58.00% | 66.67% | 75.00% | 83.33% | 91.67% | |||||||||||||||||
9 | After School Care Program | $11,735.00 | $40,540.00 | $40,173.48 | $33,078.90 | $39,875.00 | $28,864.00 | $38,258.10 | $32,277.00 | $35,972.00 | $48,434.00 | $37,012.00 | $386,219.48 | $385,000.00 | ||||||||||||||
10 | Activity and Principal Fundraising | $41,812.33 | $134,308.68 | $79,237.54 | $78,790.43 | $87,997.76 | $43,324.54 | $54,832.84 | $59,826.79 | $77,458.72 | $72,806.80 | $94,167.03 | $824,563.46 | $838,000.00 | ||||||||||||||
11 | Other Local Revenues | $0.00 | $12,465.01 | $1,326.47 | $2,271.96 | $894.32 | $1,399.38 | $1,632.58 | $746.61 | $797.64 | $1,075.57 | $2,217.84 | $24,827.38 | $28,900.00 | ||||||||||||||
12 | Scholar Legacy Fund | $824.82 | $2,293.69 | $738.04 | $1,594.31 | $615.97 | $1,649.27 | $13,494.59 | $3,096.66 | $1,173.38 | $5,067.38 | $2,932.96 | $33,481.07 | $34,000.00 | ||||||||||||||
13 | GADOE Grants | $13,125.00 | $0.00 | $2,351.00 | $198,374.47 | $0.00 | $0.00 | $50,528.00 | $0.00 | $0.00 | $0.00 | $0.00 | $264,378.47 | $264,378.00 | ||||||||||||||
14 | QBE Funding (reduced by SCSC fee) | $1,641,919.00 | $1,641,794.00 | $1,641,794.00 | $1,641,794.00 | $1,641,794.00 | $1,641,794.00 | $1,641,794.00 | $1,641,794.00 | $1,641,794.00 | $2,000,372.00 | $1,673,689.00 | $18,450,332.00 | $20,124,021.00 | ||||||||||||||
15 | Interest | $21.60 | $22.32 | $22.31 | $21.72 | $22.36 | $46.17 | $22.67 | $22.64 | $20.89 | $22.89 | $22.40 | $267.97 | $240.00 | ||||||||||||||
16 | ESSER Grant | $0.00 | $0.00 | $4,290.00 | $0.00 | $856,346.69 | $0.00 | $0.00 | $106,532.22 | $0.00 | $0.00 | $134,342.45 | $1,101,511.36 | $1,109,398.72 | ||||||||||||||
17 | Federal Grants (Title Programs) | $0.00 | $0.00 | $0.00 | $0.00 | $123,440.07 | $0.00 | $77,053.11 | $0.00 | $0.00 | $115,510.08 | $0.00 | $316,003.26 | $472,169.00 | ||||||||||||||
18 | ERATE | $0.00 | $0.00 | $64,411.70 | $0.00 | $0.00 | $49,715.20 | $0.00 | $0.00 | $3,619.20 | $0.00 | $0.00 | $117,746.10 | $117,745.00 | ||||||||||||||
19 | Total Revenue | $1,709,437.75 | $1,831,423.70 | $1,834,344.54 | $1,955,925.79 | $2,750,986.17 | $1,766,792.56 | $1,877,615.89 | $1,844,295.92 | $1,760,835.83 | $2,243,288.72 | $1,944,383.68 | $17,331,658.15 | $22,580,906.80 | ||||||||||||||
20 | ||||||||||||||||||||||||||||
21 | ||||||||||||||||||||||||||||
22 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2022 | 2022 | 2022 | 2022 | 2022 | |||||||||||||||||
23 | EXPENDITURES | July | August | Sept | Oct | Nov | Dec | Jan | Feb | March | Apr | May | Actual Totals | Annual Budget | ||||||||||||||
24 | 8.33% | 16.67% | 25.00% | 33.33% | 41.67% | 50.00% | 58.00% | 66.67% | 75.00% | 83.33% | 91.67% | |||||||||||||||||
25 | Instruction | $881,420.69 | $941,926.02 | $1,168,379.21 | $861,334.96 | $929,300.65 | $1,233,360.99 | $842,495.50 | $863,737.20 | $869,518.02 | $1,243,348.26 | $886,193.72 | $10,721,015.22 | $12,009,099.00 | ||||||||||||||
26 | Pupil Services | $69,989.93 | $69,633.01 | $80,934.61 | $98,188.14 | $100,102.99 | $73,775.61 | $67,983.56 | $85,287.43 | $71,614.10 | $109,236.29 | $124,657.47 | $951,403.14 | $1,074,531.84 | ||||||||||||||
27 | Instructional Staff Training | $4,920.00 | $8,260.00 | $9,554.81 | $2,489.40 | $1,150.00 | $1,375.10 | $6,671.71 | $2,995.32 | $2,882.43 | $2,814.99 | $1,500.00 | $44,613.76 | $54,045.00 | ||||||||||||||
28 | Educational Media Services | $11,448.35 | $15,529.68 | $17,678.85 | $22,281.53 | $14,826.19 | $16,348.00 | $14,826.25 | $21,450.19 | $16,301.64 | $27,415.27 | $14,869.15 | $192,975.10 | $219,026.00 | ||||||||||||||
29 | School Administration | $52,317.94 | $73,960.23 | $42,113.51 | $76,532.03 | $75,216.50 | $72,110.07 | $77,943.38 | $68,590.80 | $68,906.31 | $95,454.12 | $83,828.22 | $786,973.11 | $743,725.00 | ||||||||||||||
30 | Support Services - Business | $62,333.02 | $111,782.65 | $54,770.35 | $50,043.29 | $58,849.24 | $45,233.50 | $71,712.23 | $43,210.30 | $38,675.86 | $70,237.05 | $112,071.24 | $718,918.73 | $781,113.50 | ||||||||||||||
31 | Maintenance and Operation of Plant Services | $184,581.58 | $303,891.86 | $354,177.25 | $135,399.63 | $206,205.82 | $155,806.79 | $87,430.55 | $92,935.91 | $125,073.77 | $82,577.55 | $82,979.33 | $1,811,060.04 | $2,171,490.66 | ||||||||||||||
32 | Student Transportation Service | $0.00 | $0.00 | $713.00 | $5,221.00 | $9,268.00 | $2,395.00 | $3,860.00 | $5,400.00 | $5,595.00 | $14,785.00 | $6,172.00 | $53,409.00 | $58,450.00 | ||||||||||||||
33 | School Nutrition Program | $0.00 | $0.00 | $7,896.46 | $2,116.83 | $9,800.70 | $2,501.31 | $14,773.76 | $0.00 | $29.59 | $9,676.48 | $0.00 | $46,795.13 | $70,000.00 | ||||||||||||||
34 | Enterprise - After School Program | $0.00 | $7,776.31 | $36,345.74 | $21,899.17 | $27,382.31 | $18,600.49 | $21,204.66 | $22,684.08 | $47,811.70 | $28,767.11 | $31,726.72 | $264,198.29 | $271,815.00 | ||||||||||||||
35 | Enterprise - School Activities | $15,086.44 | $43,852.37 | $55,686.58 | $74,901.24 | $38,377.62 | $60,491.21 | $57,680.10 | $40,742.32 | $53,019.53 | $85,477.97 | $65,769.20 | $591,084.58 | $720,000.00 | ||||||||||||||
36 | Facilities Acquisition and Construction Services | $160,114.00 | $159,289.71 | $239,688.15 | $825,962.46 | $18,459.74 | $38,216.50 | $255,758.62 | $120,196.58 | $77,319.41 | $124,472.05 | $21,750.00 | $2,041,227.22 | $2,126,904.00 | ||||||||||||||
37 | Debt Service - Bibb BOE | $50,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $50,000.00 | $50,000.00 | ||||||||||||||
38 | Debt Service - Loan | $5,321.00 | $5,321.00 | $5,321.00 | $5,321.00 | $5,321.00 | $5,321.00 | $5,321.00 | $5,321.00 | $5,321.00 | $5,321.00 | $5,321.00 | $58,531.00 | $63,852.00 | ||||||||||||||
39 | Debt Service - Bond | $165,495.83 | $165,495.83 | $165,495.83 | $165,495.83 | $165,495.83 | $237,995.83 | $237,995.83 | $237,995.83 | $237,995.83 | $237,995.83 | $237,995.83 | $2,255,454.13 | $2,420,950.00 | ||||||||||||||
40 | Total Expenditures | $1,731,255.90 | $1,927,139.00 | $2,272,775.75 | $2,347,186.51 | $1,659,756.59 | $1,963,531.40 | $1,765,657.15 | $1,610,546.96 | $1,620,064.19 | $2,137,578.97 | $1,674,833.88 | $20,587,658.45 | $22,835,002.00 | ||||||||||||||
41 | Total Revenues | $1,709,437.75 | $1,831,423.70 | $1,834,344.54 | $1,955,925.79 | $2,750,986.17 | $1,766,792.56 | $1,877,615.89 | $1,844,295.92 | $1,760,835.83 | $2,243,288.72 | $1,944,383.68 | $21,519,330.55 | $23,373,851.72 | ||||||||||||||
42 | Budget Position | $21,818.15 | $95,715.30 | $438,431.21 | $391,260.72 | -$1,091,229.58 | $196,738.84 | -$111,958.74 | -$233,748.96 | -$140,771.64 | -$105,709.75 | -$269,549.80 | -$931,672.10 | -$538,849.72 | ||||||||||||||
43 | Encumbrances | $2,291,283.64 | $2,059,920.99 | $1,415,212.64 | $1,309,919.86 | $1,128,286.36 | $797,066.08 | $611,324.88 | $462,172.82 | $476,125.28 | $338,773.79 | $259,799.97 | ||||||||||||||||
44 | ||||||||||||||||||||||||||||
45 | For Management Use Only | |||||||||||||||||||||||||||
46 | ||||||||||||||||||||||||||||
47 | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | |||||||||||||||||
48 | Statement of Cash Flows | |||||||||||||||||||||||||||
49 | Cash Produced/(Used) in Operations | |||||||||||||||||||||||||||
50 | Accounts Receivable | -$555,290 | $555,282 | $8 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||
51 | Other Current Assets | $570,406 | $0 | $0 | $0 | $0 | $0 | $49,311 | $0 | $0 | $0 | $0 | $619,717 | |||||||||||||||
52 | Accounts Payable | -$162,049 | $10,865 | -$135,932 | $1,276 | $1,769 | $24,472 | -$28,065 | $1,173 | -$11,166 | -$2,090 | -$3,062 | -$302,809 | |||||||||||||||
53 | Payroll and Accrued Liabilities | -$103,676 | $43,197 | $274,686 | -$175,838 | $177,017 | -$217,453 | $244,362 | -$198,202 | -$10,539 | $181,284 | $5,742 | $220,580 | |||||||||||||||
54 | Net Cash Provided/(Used) by Operations | -$250,609 | $609,344 | $138,762 | -$174,562 | $178,786 | -$192,981 | $265,608 | -$197,029 | -$21,705 | $179,194 | $2,680 | $537,488 | |||||||||||||||
55 | ||||||||||||||||||||||||||||
56 | Cash Produced/(Used) in Asset Investment | |||||||||||||||||||||||||||
57 | Land and Buildings | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||
58 | IT Infrastructure and Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||
59 | FF&E | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||
60 | Net Cash Provided/(Used) by Investment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||
61 | ||||||||||||||||||||||||||||
62 | Cash Produced/(Used) in Financing | |||||||||||||||||||||||||||
63 | Debt Principal Payments | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||
64 | Debt Retirement Payments | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||
65 | New Debt Issuances | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||
66 | Net Cash Provided/(Used) by Financing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||
67 | ||||||||||||||||||||||||||||
68 | Change in Position | $46,409 | -$75,295 | -$404,411 | -$391,261 | $1,091,230 | -$196,739 | $111,959 | $233,749 | $140,772 | $105,710 | $269,550 | $931,672 | |||||||||||||||
69 | Adjustments to reconcile Net Rev to Net Cash | -$250,609 | $609,344 | $138,762 | -$174,562 | $178,786 | -$192,981 | $265,608 | -$197,029 | -$21,705 | $179,194 | $2,680 | $537,488 | |||||||||||||||
70 | Beginning Cash | $9,053,762 | $8,849,562 | $9,383,611 | $9,117,962 | $8,552,139 | $9,822,155 | $9,432,435 | $9,810,002 | $9,846,722 | $9,965,789 | $10,250,692 | $9,053,762 | |||||||||||||||
71 | Ending Cash | $8,849,562 | $9,383,611 | $9,117,962 | $8,552,139 | $9,822,155 | $9,432,435 | $9,810,002 | $9,846,722 | $9,965,789 | $10,250,692 | $10,522,922 | $10,522,922 | |||||||||||||||
72 | Cash Increase for Period | -$204,200 | $534,049 | -$265,649 | -$565,823 | $1,270,016 | -$389,720 | $377,567 | $36,720 | $119,067 | $284,904 | $272,230 | $1,469,160 | |||||||||||||||
73 | ||||||||||||||||||||||||||||
74 | ||||||||||||||||||||||||||||
75 | . | |||||||||||||||||||||||||||
76 | Statement of Assets, Liabilities and Net Assets | |||||||||||||||||||||||||||
77 | ||||||||||||||||||||||||||||
78 | Assets | |||||||||||||||||||||||||||
79 | Cash in Bank | $6,425,012 | $6,959,061 | $6,693,411 | $6,127,589 | $7,397,604 | $7,007,884 | $7,385,452 | $7,422,172 | $7,541,239 | $7,826,142 | $8,098,372 | $8,098,372 | |||||||||||||||
80 | Total Bond/Trustee Accounts | $2,424,550 | $2,424,550 | $2,424,550 | $2,424,550 | $2,424,550 | $2,424,550 | $2,424,550 | $2,424,550 | $2,424,550 | $2,424,550 | $2,424,550 | $2,424,550 | |||||||||||||||
81 | Accounts Receivable | $1,674,547 | $1,119,265 | $1,119,257 | $1,119,257 | $1,119,257 | $1,119,257 | $1,119,257 | $1,119,257 | $1,119,257 | $1,119,257 | $1,119,257 | $1,119,257 | |||||||||||||||
82 | Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||
83 | Prepaid items | $49,311 | $49,311 | $49,311 | $49,311 | $49,311 | $49,311 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||
84 | TOTAL ASSETS | $10,573,420 | $10,552,187 | $10,286,529 | $9,720,707 | $10,990,722 | $10,601,002 | $10,929,259 | $10,965,979 | $11,085,046 | $11,369,949 | $11,642,179 | $11,642,179 | |||||||||||||||
85 | ||||||||||||||||||||||||||||
86 | Liabilities and Net Assets | |||||||||||||||||||||||||||
87 | Accounts Payable | $140,468 | $151,333 | $15,401 | $16,677 | $18,446 | $42,918 | $14,853 | $16,025 | $4,859 | $2,769 | -$293 | -$293 | |||||||||||||||
88 | Other Current Liabilities | $104,020 | $91,720 | $400,426 | $224,588 | $401,605 | $184,152 | $428,515 | $230,313 | $219,774 | $401,058 | $406,800 | $406,800 | |||||||||||||||
89 | Salaries and benefits payable | $1,625,779 | $1,664,266 | $1,664,266 | $1,664,266 | $1,664,266 | $1,664,266 | $1,664,266 | $1,664,266 | $1,664,266 | $1,664,266 | $1,664,266 | $1,664,266 | |||||||||||||||
90 | ||||||||||||||||||||||||||||
91 | Fund Balance | $8,639,734 | $8,639,734 | $8,639,734 | $8,639,734 | $8,639,734 | $8,639,734 | $8,639,734 | $8,639,734 | $8,639,734 | $8,639,734 | $8,639,734 | $8,639,734 | |||||||||||||||
92 | Net Revenue | $46,409 | $5,134 | -$433,298 | -$824,558 | $266,671 | $69,932 | $181,891 | $415,641 | $556,413 | $662,122 | $931,672 | $931,672 | |||||||||||||||
93 | TOTAL LIABILITIES AND NET ASSETS | $10,556,410 | $10,552,187 | $10,286,529 | $9,720,707 | $10,990,722 | $10,601,002 | $10,929,259 | $10,965,979 | $11,085,046 | $11,369,949 | $11,642,179 | $11,642,179 | |||||||||||||||
94 | ||||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||||
97 | Ratio Analysis | |||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||||
99 | Net Change in Fund Balance | $931,672 | ||||||||||||||||||||||||||
100 | Add Debt Service Payments - Principal | $513,633 | ||||||||||||||||||||||||||