| 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 | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | AT | AU | AV | AW | AX | AY | AZ | BA | BB | BC | BD | BE | BF | BG | BH | BI | BJ | BK | BL | BM | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | FY 25/26 | Summit - Pro Forma 1 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2 | 2 | Annual Total | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3 | 3 | 10.455 | FY 25/26 estimated School Finance Act Levy | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
4 | 4 | $3,392,935,973 | FY 24/25 Assessed Value (exclude Tax Increment District AV) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5 | 5 | $3,878,885,495 | FY 25/26 projected Assessed Value (exclude Tax Increment District AV) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
6 | 6 | 14.32% | Assessed Value Growth | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
7 | 7 | 3,455.1 | FY 24/25 Funded Pupil Count | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
8 | 8 | 3,355.8 | FY 25/26 projected Funded Pupil Count | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
9 | 9 | -2.87% | Pupil Growth | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
10 | 10 | $12,637.20 | FY 25/26 projected Per Pupil Total Program Funding | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
11 | 11 | $42,407,902 | FY 25/26 projected Total Program Funding | July | July | July | July | August | August | August | August | September | September | September | September | October | October | October | October | November | November | November | November | December | December | December | December | January | January | January | January | February | February | February | February | March | March | March | March | April | April | April | April | May | May | May | May | June | June | June | June | |||||||||||||||
12 | 12 | 0 | July | Day 1 - 9 | Day 10 - 20 | Day 21 - end | Check | August | Day 1 - 9 | Day 10 - 20 | Day 21 - end | Check | September | Day 1 - 9 | Day 10 - 20 | Day 21 - end | Check | October | Day 1 - 9 | Day 10 - 20 | Day 21 - end | Check | November | Day 1 - 9 | Day 10 - 20 | Day 21 - end | Check | December | Day 1 - 9 | Day 10 - 20 | Day 21 - end | Check | January | Day 1 - 9 | Day 10 - 20 | Day 21 - end | Check | February | Day 1 - 9 | Day 10 - 20 | Day 21 - end | Check | March | Day 1 - 9 | Day 10 - 20 | Day 21 - end | Check | April | Day 1 - 9 | Day 10 - 20 | Day 21 - end | Check | May | Day 1 - 9 | Day 10 - 20 | Day 21 - end | Check | June | Day 1 - 9 | Day 10 - 20 | Day 21 - end | Check | Total | |||
13 | 13 | 1 | Beginning General Fund/Other Funds/Capital Reserve/Ins. Reserve Cash Balance (JULY 1, 2024 - PRIOR YEAR) | $16,878,801 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
14 | 14 | 10.455 | Beginning General Fund Cash Balance (JULY 1, 2025 - CURRENT YEAR) | $11,234,214 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
15 | 15 | Update Resolution | (plus) Beginning Other Funds Cash Balance (JULY 1, 2025 - CURRENT YEAR) (see note 2 below) | $3,786,906 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
16 | 16 | $27,107,882 | (plus) Capital Reserve and/or Risk Mgmt./Insurance Reserve Cash Balances (JULY 1, 2025 - CURRENT YEAR) | $89,672 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
17 | 17 | $25,000,000 | (less) TABOR Reserve (see note 1 below) | -$1,573,824 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
18 | 18 | Beginning Month Cash Balances (WITHOUT Cash Flow Loan Amount) | $13,536,968 | $13,536,968 | $8,985,613 | $11,003,501 | $10,579,880 | $10,579,880 | $6,085,805 | $7,558,737 | $8,184,003 | $8,184,003 | $3,639,824 | $4,220,773 | $3,199,025 | $3,199,025 | ($1,500,185) | ($1,015,222) | ($33,974) | ($33,974) | ($4,755,358) | ($4,155,361) | ($3,655,238) | ($3,655,238) | ($8,395,838) | ($8,213,519) | ($8,684,426) | ($8,684,426) | ($13,352,288) | |||||||||||||||||||||||||||||||||||||
19 | 19 | Beginning Month Cash Balances (WITH PRIMARY Cash Flow Loan Amount) | $13,536,968 | $13,536,968 | $8,985,613 | $11,003,501 | $10,579,880 | $10,579,880 | $6,085,805 | $7,558,737 | $8,184,003 | $8,184,003 | $3,639,824 | $4,220,773 | $3,199,025 | $3,199,025 | ($1,500,185) | ($1,015,222) | ($33,974) | ($33,974) | $359,651 | $959,648 | $1,592,184 | $1,592,184 | $1,578,199 | $1,760,518 | $1,289,611 | $1,289,611 | $726,913 | |||||||||||||||||||||||||||||||||||||
20 | 20 | Beginning Month Cash Balances (WITHOUT SECONDARY Cash Flow Loan Amount) | $726,913 | ($13,135,228) | $395,799 | $395,799 | ($4,383,289) | ($1,609,578) | ($1,904,533) | ($1,904,533) | ($6,501,917) | ($6,282,644) | ($5,831,860) | ($5,831,860) | ($10,435,954) | ($7,463,602) | ($8,404,587) | ($8,404,587) | ($13,028,681) | ($12,853,678) | ($5,331,607) | ($5,331,607) | ($10,085,701) | ($2,259,703) | ||||||||||||||||||||||||||||||||||||||||||
21 | 21 | Beginning Month Cash Balances (WITH SECONDARY Cash Flow Loan Amount) | $726,913 | $943,973 | $435,259 | $435,259 | $421,867 | $3,195,578 | $2,900,623 | $2,900,623 | $1,164,100 | $1,383,373 | $1,834,157 | $1,834,157 | $171,046 | $3,143,398 | $2,202,413 | $2,202,413 | $0 | $175,003 | $7,697,074 | $7,697,074 | $2,942,980 | $10,768,978 | ||||||||||||||||||||||||||||||||||||||||||
22 | 22 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
23 | 23 | Monthly Property Tax Total (Net Cash Received) | $1,548,402 | $1,548,402 | $1,058,084 | $1,058,084 | $243,452 | $243,452 | $167,857 | $167,857 | $269,884 | $269,884 | $3,217 | $3,217 | $4,982 | $4,982 | $2,372,074 | $2,372,074 | $16,935,329 | $14,325,368 | $2,609,961 | $2,533,066 | $2,533,066 | $15,190,942 | $7,899,290 | $7,291,652 | $9,445,673 | $7,650,995 | $1,794,678 | |||||||||||||||||||||||||||||||||||||
24 | 24 | Monthly Specific Ownership Tax Total (Net Cash Received) | $208,755 | $208,755 | $201,856 | $201,856 | $203,820 | $203,820 | $190,789 | $190,789 | $193,863 | $193,863 | $178,789 | $178,789 | $211,593 | $211,593 | $172,964 | $172,964 | $175,003 | $175,003 | $195,096 | $195,096 | $175,003 | $175,003 | $175,003 | $175,003 | ||||||||||||||||||||||||||||||||||||||||
25 | 25 | $0 | (plus) Current Month State Equalization Payment | $109,974 | $0 | $109,974 | $0 | OK | $109,974 | $0 | $109,974 | $0 | OK | $109,974 | $0 | $109,974 | $0 | OK | $109,974 | $0 | $109,974 | $0 | OK | $109,974 | $0 | $109,974 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | OK | $0 | $0 | $0 | OK | $549,872 | |||||
26 | 26 | 87% | $40,553,748 | (plus) Current Month Property Taxes (School Finance Act Portion Only) | $1,346,566 | $0 | $1,346,566 | $0 | OK | $920,161 | $0 | $920,161 | $0 | OK | $211,718 | $0 | $211,718 | $0 | OK | $145,977 | $0 | $145,977 | $0 | OK | $234,704 | $0 | $234,704 | $0 | OK | $2,798 | $0 | $2,798 | $0 | OK | $4,333 | $0 | $4,333 | $0 | OK | $2,062,871 | $0 | $2,062,871 | $0 | OK | $14,727,788 | $0 | $12,458,039 | $2,269,749 | OK | $2,202,877 | $0 | $2,202,877 | $0 | OK | $13,210,784 | $0 | $6,869,608 | $6,341,176 | OK | $8,214,418 | $0 | $6,653,678 | $1,560,739 | ERROR | $43,284,995 | |
27 | 27 | 13% | $6,078,582 | (plus) Current Month Hold Harmless, and Override Property Taxes | $201,836 | $0 | $201,836 | $0 | OK | $137,923 | $0 | $137,923 | $0 | OK | $31,734 | $0 | $31,734 | $0 | OK | $21,880 | $0 | $21,880 | $0 | OK | $35,180 | $0 | $35,180 | $0 | OK | $419 | $0 | $419 | $0 | OK | $649 | $0 | $649 | $0 | OK | $309,203 | $0 | $309,203 | $0 | OK | $2,207,541 | $0 | $1,867,329 | $340,212 | OK | $330,188 | $0 | $330,188 | $0 | OK | $1,980,158 | $0 | $1,029,682 | $950,476 | OK | $1,231,255 | $0 | $997,317 | $233,939 | ERROR | $6,487,967 | |
28 | 28 | 68% | $1,853,884 | (plus) Current Month Specific Ownership Taxes (School Finance Act Portion Only) | $141,092 | $0 | $141,092 | $0 | OK | $136,430 | $0 | $136,430 | $0 | OK | $137,757 | $0 | $137,757 | $0 | OK | $128,950 | $0 | $128,950 | $0 | OK | $131,027 | $0 | $131,027 | $0 | OK | $120,839 | $0 | $120,839 | $0 | OK | $143,011 | $0 | $143,011 | $0 | OK | $116,902 | $0 | $116,902 | $0 | OK | $118,280 | $0 | $118,280 | $0 | OK | $131,861 | $0 | $131,861 | $0 | OK | $118,280 | $0 | $118,280 | $0 | OK | $118,280 | $0 | $118,280 | $0 | OK | $1,542,710 | |
29 | 29 | 32% | $889,051 | (plus) Current Month Other Specific Ownership Taxes (Other Than From School Finance Act) | $67,663 | $0 | $67,663 | $0 | OK | $65,426 | $0 | $65,426 | $0 | OK | $66,063 | $0 | $66,063 | $0 | OK | $61,839 | $0 | $61,839 | $0 | OK | $62,836 | $0 | $62,836 | $0 | OK | $57,950 | $0 | $57,950 | $0 | OK | $68,582 | $0 | $68,582 | $0 | OK | $56,062 | $0 | $56,062 | $0 | OK | $56,723 | $0 | $56,723 | $0 | OK | $63,235 | $0 | $63,235 | $0 | OK | $56,723 | $0 | $56,723 | $0 | OK | $56,723 | $0 | $56,723 | $0 | OK | $739,824 | |
30 | 30 | $5,511,830 | (plus) Current Month Other General Fund Revenue | $1,401,229 | $0 | $0 | $1,401,229 | OK | $800,541 | $0 | $0 | $800,541 | OK | $370,890 | $0 | $0 | $370,890 | OK | $378,552 | $0 | $0 | $378,552 | OK | $300,631 | $0 | $0 | $300,631 | OK | $322,545 | $0 | $0 | $322,545 | OK | $235,625 | $0 | $0 | $235,625 | OK | $334,495 | $0 | $0 | $334,495 | OK | $368,332 | $0 | $0 | $368,332 | OK | $330,000 | $0 | $0 | $330,000 | OK | $334,495 | $0 | $0 | $334,495 | OK | $334,495 | $0 | $0 | $334,495 | OK | $5,511,830 | ||
31 | 31 | $13,093,785 | (plus) Current Month Other Funds Revenue (see note 2 below) | $240,964 | $0 | $150,757 | $90,207 | OK | $1,661,677 | $0 | $103,018 | $1,558,659 | OK | $534,454 | $0 | $23,703 | $510,751 | OK | $2,153,562 | $0 | $16,343 | $2,137,219 | OK | $1,232,455 | $0 | $26,276 | $1,206,179 | OK | $818,732 | $0 | $313 | $818,419 | OK | $379,778 | $0 | $485 | $379,293 | OK | $443,711 | $0 | $228,673 | $215,038 | OK | $2,447,156 | $0 | $1,632,594 | $814,562 | OK | $708,966 | $0 | $244,190 | $464,776 | OK | $2,546,110 | $0 | $0 | $2,546,110 | OK | -$73,781 | $0 | $0 | -$73,781 | OK | $13,093,785 | ||
32 | 32 | $0 | (plus) Current Month Other Capital Reserve and/or Risk Mgmt./Insurance Reserve Revenue (Exclude GF Transfers Into) | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | ||
33 | 33 | $67,980,880 | Current Month Revenue | $3,509,324 | $0 | $2,017,888 | $1,491,436 | $3,832,132 | $0 | $1,472,932 | $2,359,200 | $1,462,590 | $0 | $580,949 | $881,641 | $3,000,735 | $0 | $484,963 | $2,515,771 | $2,106,807 | $0 | $599,997 | $1,506,810 | $1,323,283 | $0 | $182,319 | $1,140,964 | $831,978 | $0 | $217,060 | $614,918 | $3,323,244 | $0 | $2,773,711 | $549,533 | $19,925,820 | $0 | $16,132,965 | $3,792,855 | $3,767,128 | $0 | $2,972,352 | $794,776 | $18,246,550 | $0 | $8,074,293 | $10,172,257 | $9,881,390 | $0 | $7,825,998 | $2,055,392 | |||||||||||||||
34 | 34 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
35 | 35 | $38,016,805 | (less) Current Month Salaries Expense (General Fund) - exclude charter schools | $3,136,418 | $3,136,418 | $0 | $0 | OK | $3,095,689 | $3,095,689 | $0 | $0 | OK | $3,083,673 | $3,083,673 | $0 | $0 | OK | $3,202,942 | $3,202,942 | $0 | $0 | OK | $3,217,467 | $3,217,467 | $0 | $0 | OK | $3,226,225 | $3,226,225 | $0 | $0 | OK | $3,180,948 | $3,180,948 | $0 | $0 | OK | $3,257,924 | $3,257,924 | $0 | $0 | OK | $3,121,520 | $3,121,520 | $0 | $0 | OK | $3,131,333 | $3,131,333 | $0 | $0 | OK | $3,131,333 | $3,131,333 | $0 | $0 | OK | $3,231,333 | $3,231,333 | $0 | $0 | OK | $38,016,805 | ||
36 | 36 | $12,437,800 | (less) Current Month Benefits Expense (General Fund) - include district share only - exclude charter schools | $1,016,744 | $1,016,744 | $0 | $0 | OK | $1,043,517 | $1,043,517 | $0 | $0 | OK | $1,027,811 | $1,027,811 | $0 | $0 | OK | $1,051,181 | $1,051,181 | $0 | $0 | OK | $1,058,009 | $1,058,009 | $0 | $0 | OK | $1,040,163 | $1,040,163 | $0 | $0 | OK | $1,032,157 | $1,032,157 | $0 | $0 | OK | $1,054,005 | $1,054,005 | $0 | $0 | OK | $1,019,452 | $1,019,452 | $0 | $0 | OK | $1,021,587 | $1,021,587 | $0 | $0 | OK | $1,021,587 | $1,021,587 | $0 | $0 | OK | $1,051,587 | $1,051,587 | $0 | $0 | OK | $12,437,800 | ||
37 | 37 | $6,455,121 | (less) Current Month Other General Fund Expenses | $907,121 | $0 | $0 | $907,121 | OK | $392,261 | $0 | $0 | $392,261 | OK | $719,963 | $0 | $0 | $719,963 | OK | $575,753 | $0 | $0 | $575,753 | OK | $355,120 | $0 | $0 | $355,120 | OK | $522,543 | $0 | $0 | $522,543 | OK | $487,104 | $0 | $0 | $487,104 | OK | $298,955 | $0 | $298,955 | OK | $593,005 | $0 | $0 | $593,005 | OK | $534,432 | $0 | $0 | $534,432 | OK | $534,432 | $0 | $0 | $534,432 | OK | $534,432 | $0 | $0 | $534,432 | OK | $6,455,121 | |||
38 | 38 | $4,036,593 | (less) Current Month Salaries Expense (Other Funds) - exclude charter schools | $311,570 | $311,570 | $0 | $0 | OK | $277,950 | $277,950 | $0 | $0 | OK | $323,894 | $323,894 | $0 | $0 | OK | $331,686 | $331,686 | $0 | $0 | OK | $334,803 | $334,803 | $0 | $0 | OK | $357,650 | $357,650 | $0 | $0 | OK | $343,128 | $343,128 | $0 | $0 | OK | $353,421 | $353,421 | $0 | $0 | OK | $343,757 | $343,757 | $0 | $0 | OK | $339,578 | $339,578 | $0 | $0 | OK | $359,578 | $359,578 | $0 | $0 | OK | $359,578 | $359,578 | $0 | $0 | OK | $4,036,593 | ||
39 | 39 | $1,286,221 | (less) Current Month Benefits Expense (Other Funds) - include district share only - exclude charter schools | $86,623 | $86,623 | $0 | $0 | OK | $76,919 | $76,919 | $0 | $0 | OK | $108,801 | $108,801 | $0 | $0 | OK | $113,401 | $113,401 | $0 | $0 | OK | $111,105 | $111,105 | $0 | $0 | OK | $116,562 | $116,562 | $0 | $0 | OK | $111,629 | $111,629 | $0 | $0 | OK | $113,738 | $113,738 | $0 | $0 | OK | $112,655 | $112,655 | $0 | $0 | OK | $111,596 | $111,596 | $0 | $0 | OK | $111,596 | $111,596 | $0 | $0 | OK | $111,596 | $111,596 | $0 | $0 | OK | $1,286,221 | ||
40 | 40 | $11,426,800 | (less) Current Month Other Funds Expense (see note 2 below) | $1,007,936 | $0 | $0 | $1,007,936 | OK | $1,341,673 | $0 | $0 | $1,341,673 | OK | $1,183,426 | $0 | $0 | $1,183,426 | OK | $958,771 | $0 | $0 | $958,771 | OK | $651,567 | $0 | $0 | $651,567 | OK | $1,089,328 | $0 | $0 | $1,089,328 | OK | $675,988 | $0 | $0 | $675,988 | OK | $545,533 | $0 | $545,533 | OK | $368,591 | $0 | $0 | $368,591 | OK | $1,201,329 | $0 | $0 | $1,201,329 | OK | $1,201,329 | $0 | $0 | $1,201,329 | OK | $1,201,329 | $0 | $0 | $1,201,329 | OK | $11,426,800 | |||
41 | 41 | $0 | (less) Current Month Capital Reserve and/or Risk Mgmt./Insurance Reserve Expense | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | ||
42 | 42 | (less) Current Month Deposit To Note Repayment Account | $18,294,167 | $0 | $15,913,692 | $2,380,475 | $8,813,715 | $0 | $7,899,290 | $914,425 | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
43 | 43 | $0 | (less) Charter School Transfer (Net) | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | ||
44 | 44 | $73,659,340 | Current Month Expenses | $6,466,412 | $4,551,355 | $0 | $1,915,057 | $6,228,009 | $4,494,075 | $0 | $1,733,934 | $6,447,568 | $4,544,179 | $0 | $1,903,389 | $6,233,734 | $4,699,210 | $0 | $1,534,524 | $5,728,071 | $4,721,384 | $0 | $1,006,687 | $6,352,471 | $4,740,600 | $0 | $1,611,871 | $5,830,954 | $4,667,862 | $0 | $1,163,092 | $5,623,576 | $4,779,088 | $0 | $844,488 | $23,853,147 | $4,597,384 | $15,913,692 | $3,342,071 | $6,339,855 | $4,604,094 | $0 | $1,735,761 | $15,173,570 | $4,624,094 | $7,899,290 | $2,650,186 | $6,489,855 | $4,754,094 | $0 | $1,735,761 | |||||||||||||||
45 | 45 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
46 | 46 | ENDING MONTH AVAILABLE BALANCES (WITHOUT Cash Flow Loan Amount) | $10,579,880 | $8,985,613 | $11,003,501 | $10,579,880 | OK | $8,184,003 | $6,085,805 | $7,558,737 | $8,184,003 | OK | $3,199,025 | $3,639,824 | $4,220,773 | $3,199,025 | OK | ($33,974) | ($1,500,185) | ($1,015,222) | ($33,974) | OK | ($3,655,238) | ($4,755,358) | ($4,155,361) | ($3,655,238) | OK | ($8,684,426) | ($8,395,838) | ($8,213,519) | ($8,684,426) | OK | ($13,352,288) | ($13,352,288) | ($13,135,228) | OK | ||||||||||||||||||||||||||||||
47 | 47 | ENDING MONTH AVAILABLE BALANCES (WITH PRIMARY Cash Flow Loan Amount) | $10,579,880 | $8,985,613 | $11,003,501 | $10,579,880 | OK | $8,184,003 | $6,085,805 | $7,558,737 | $8,184,003 | OK | $3,199,025 | $3,639,824 | $4,220,773 | $3,199,025 | OK | -$33,974 | ($1,500,185) | ($1,015,222) | ($33,974) | OK | $1,592,184 | $359,651 | $959,648 | $1,592,184 | OK | $1,289,611 | $1,578,199 | $1,760,518 | $1,289,611 | OK | $726,913 | $726,913 | $943,973 | OK | ||||||||||||||||||||||||||||||
48 | 48 | CURRENT MONTH CASH FLOW LOAN BORROWING - Primary | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $5,247,422 | $5,115,009 | $0 | $132,413 | OK | $4,726,615 | $4,726,615 | $0 | $0 | OK | $4,105,164 | $4,105,164 | $0 | OK | ||||||||||||||||||||||||||||||
49 | 49 | CUMULATIVE CASH FLOW LOAN BORROWING - Primary | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $5,247,422 | $5,115,009 | $5,115,009 | $5,247,422 | OK | $9,974,037 | $9,974,037 | $9,974,037 | $9,974,037 | OK | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | OK | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | |||||||||
50 | 50 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
51 | 51 | ENDING MONTH AVAILABLE BALANCES (WITHOUT SECONDARY Cash Flow Loan Amount) | $395,799 | ($1,904,533) | ($4,383,289) | ($1,609,578) | ($1,904,533) | OK | ($5,831,860) | ($6,501,917) | ($6,282,644) | ($5,831,860) | OK | ($8,404,587) | ($10,435,954) | ($7,463,602) | ($8,404,587) | OK | ($5,331,607) | ($13,028,681) | ($12,853,678) | ($5,331,607) | OK | ($1,940,072) | ($10,085,701) | ($2,259,703) | ($1,940,072) | OK | ||||||||||||||||||||||||||||||||||||||
52 | 52 | ENDING MONTH AVAILABLE BALANCES (WITH SECONDARY Cash Flow Loan Amount) | $435,259 | $2,900,623 | $421,867 | $3,195,578 | $2,900,623 | OK | $1,834,157 | $1,164,100 | $1,383,373 | $1,834,157 | OK | $2,202,413 | $171,046 | $3,143,398 | $2,202,413 | OK | $7,697,074 | $0 | $175,003 | $7,697,074 | OK | $11,088,609 | $2,942,980 | $10,768,978 | $11,088,609 | OK | ||||||||||||||||||||||||||||||||||||||
53 | 53 | CURRENT MONTH CASH FLOW LOAN BORROWING - Secondary | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $39,460 | $0 | $0 | $39,460 | OK | $4,765,696 | $4,765,696 | $0 | $0 | OK | $2,860,861 | $2,860,861 | $0 | $0 | OK | $2,940,983 | $2,940,983 | $0 | $0 | OK | $2,421,681 | $2,421,681 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | ||||||||||
54 | 54 | CUMULATIVE CASH FLOW LOAN BORROWING - Secondary | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $39,460 | $0 | $0 | $39,460 | OK | $4,805,156 | $4,805,156 | $4,805,156 | $4,805,156 | OK | $7,666,017 | $7,666,017 | $7,666,017 | $7,666,017 | OK | $10,607,000 | $10,607,000 | $10,607,000 | $10,607,000 | OK | $13,028,681 | $13,028,681 | $13,028,681 | $13,028,681 | OK | $13,028,681 | $13,028,681 | $13,028,681 | $13,028,681 | OK | ||||||||||
55 | 55 | Update Resolution | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
56 | 56 | $27,107,882 | CUMULATIVE CASH FLOW LOAN BORROWING - Primary & Secondary | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $5,247,422 | $5,115,009 | $5,115,009 | $5,247,422 | $9,974,037 | $9,974,037 | $9,974,037 | $9,974,037 | $14,118,661 | $14,079,201 | $14,079,201 | $14,118,661 | $18,884,357 | $18,884,357 | $18,884,357 | $18,884,357 | $21,745,218 | $21,745,218 | $21,745,218 | $21,745,218 | $24,686,201 | $24,686,201 | $24,686,201 | $24,686,201 | $27,107,882 | $27,107,882 | $27,107,882 | $27,107,882 | $27,107,882 | $27,107,882 | $27,107,882 | $27,107,882 | |||||||||||||||
57 | 57 | $25,000,000 | CASH FLOW LOAN RESOLUTION AMOUNT | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
58 | 58 | CUMULATIVE NOTE PAYMENT ACCOUNT | $0 | $15,913,692 | $18,294,167 | $18,294,167 | $18,294,167 | $18,294,167 | $18,294,167 | $26,193,457 | $27,107,882 | $27,107,882 | $27,107,882 | $27,107,882 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
59 | 59 | NOTE PAYMENT ACCOUNT REQUIREMENT - Primary | $0 | $14,079,201 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
60 | 60 | CUMULATIVE NOTE PAYMENT ACCOUNT BALANCE - Primary | $0 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | $14,079,201 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
61 | 61 | NOTE PAYMENT ACCOUNT REQUIREMENT - Secondary | $1,834,491 | $2,380,475 | $0 | $0 | $0 | $0 | $7,899,290 | $914,425 | $0 | $0 | $0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
62 | 62 | CUMULATIVE NOTE PAYMENT ACCOUNT BALANCE - Secondary | $0 | $1,834,491 | $4,214,966 | $4,214,966 | $4,214,966 | $4,214,966 | $4,214,966 | $12,114,256 | $13,028,681 | $13,028,681 | $13,028,681 | $13,028,681 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
63 | 63 | MARCH-MAY-JUNE PROPERTY TAX COLLECTIONS | $0 | $14,325,368 | $2,609,961 | $0 | $0 | $0 | $0 | $7,899,290 | $7,291,652 | $0 | $7,650,995 | $1,794,678 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
64 | 64 | CUMULATIVE MARCH-MAY-JUNE PROPERTY TAX COLLECTIONS | $0 | $14,325,368 | $16,935,329 | $16,935,329 | $16,935,329 | $16,935,329 | $16,935,329 | $24,834,619 | $32,126,271 | $32,126,271 | $39,777,266 | $41,571,944 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
65 | 65 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
66 | 66 | CASH FLOW LOAN BALANCE | $21,745,218 | $5,831,526 | $3,451,051 | $6,392,034 | $6,392,034 | $6,392,034 | $8,813,715 | $914,425 | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
67 | 67 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
68 | 68 | Memo: | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
69 | 69 | $0 | Current Month Capital Reserve and/or Risk Mgmt./Insurance Reserve Transfer (beginning of month transfer) | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | $0 | $0 | $0 | OK | $0 | ||
70 | 70 | 3 | 100.0% | 2.6% | 2.2% | 0.4% | 0.4% | 0.5% | 0.1% | 0.0% | 5.4% | 30.7% | 3.9% | 6.0% | 24.4% | 5.5% | 2.8% | 15.1% | 100.0% | |||||||||||||||||||||||||||||||||||||||||||||||
71 | 71 | 100.0% | FY 23/24 Property Tax % (see Property Tax and SOT spreadsheet) - Mar, May, June = 2 collections (sum to 100%) | 2.9% | 1.9% | 0.5% | 0.3% | 0.1% | 0.2% | 0.0% | 1.6% | 34.0% | 5.6% | 3.7% | 25.0% | 4.2% | 3.2% | 16.8% | 100.0% | |||||||||||||||||||||||||||||||||||||||||||||||
72 | 72 | 100.0% | FY 22/23 Property Tax % (see Property Tax and SOT spreadsheet) - Mar, May, June = 2 collections (sum to 100%) | 2.6% | 2.4% | 0.5% | 0.7% | 0.5% | 0.0% | 0.0% | 7.5% | 27.4% | 6.1% | 5.2% | 22.9% | 7.5% | 2.6% | 14.1% | 100.0% | |||||||||||||||||||||||||||||||||||||||||||||||
73 | 73 | 100.0% | FY 21/22 Property Tax % (see Property Tax and SOT spreadsheet) - Mar, May, June = 2 collections (sum to 100%) | 2.4% | 2.2% | 0.3% | 0.3% | 0.9% | 0.0% | 0.0% | 7.1% | 30.8% | 0.0% | 9.0% | 25.2% | 4.9% | 2.6% | 14.3% | 100.0% | |||||||||||||||||||||||||||||||||||||||||||||||
74 | 74 | 3 | 100.0% | 7.9% | 8.8% | 10.2% | 9.0% | 8.7% | 8.5% | 7.3% | 8.5% | 7.9% | 8.1% | 7.0% | 8.1% | 100.0% | ||||||||||||||||||||||||||||||||||||||||||||||||||
75 | 75 | 100.0% | FY 23/24 Monthly Specific Ownership Tax Collections (see Property Tax and SOT spreadsheet) (sum to 100%) | 8.5% | 8.6% | 9.5% | 8.9% | 8.9% | 8.3% | 7.7% | 8.6% | 7.8% | 7.7% | 7.7% | 7.8% | 100.0% | ||||||||||||||||||||||||||||||||||||||||||||||||||
76 | 76 | 100.0% | FY 22/23 Monthly Specific Ownership Tax Collections (see Property Tax and SOT spreadsheet) (sum to 100%) | 6.7% | 8.5% | 11.2% | 9.5% | 8.2% | 8.6% | 7.1% | 8.4% | 7.8% | 8.8% | 6.9% | 8.3% | 100.0% | ||||||||||||||||||||||||||||||||||||||||||||||||||
77 | 77 | 100.0% | FY 21/22 Monthly Specific Ownership Tax Collections (see Property Tax and SOT spreadsheet) (sum to 100%) | 8.4% | 9.4% | 10.0% | 8.7% | 9.1% | 8.6% | 7.2% | 8.4% | 8.0% | 7.7% | 6.4% | 8.1% | 100.0% | ||||||||||||||||||||||||||||||||||||||||||||||||||
78 | 78 | $0 | Additional Override From November 2021 Election (if successful) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
79 | 79 | $41,571,944 | March, May, and June Total Property Taxes | $16,935,329 | $15,190,942 | $9,445,673 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
80 | 80 | $27,107,882 | Maximum Actual Cash Flow Loan | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
81 | 81 | 65.2% | Cash Flow Loan % Of March, May, June Property Tax | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
82 | 82 | 22.2% | Beginning Cash Balances As A % Of Cash Revenue | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
83 | 83 | Ending Other Funds Balance (see note 2 below) | $2,621,741 | $3,388,713 | $3,539,470 | $2,621,741 | OK | $2,586,876 | $2,266,872 | $2,369,890 | $2,586,876 | OK | $1,505,209 | $2,154,181 | $2,177,884 | $1,505,209 | OK | $2,254,913 | $1,060,122 | $1,076,465 | $2,254,913 | OK | $2,389,893 | $1,809,005 | $1,835,281 | $2,389,893 | OK | $1,645,085 | $1,915,681 | $1,915,994 | $1,645,085 | OK | $894,118 | $1,190,328 | $1,190,813 | $894,118 | OK | $325,137 | $426,959 | $655,632 | $325,137 | OK | $1,947,290 | -$131,275 | $1,501,319 | $1,947,290 | OK | $1,003,754 | $1,496,116 | $1,740,307 | $1,003,754 | OK | $1,877,361 | $532,580 | $532,580 | $1,877,361 | OK | $131,077 | $1,406,187 | $1,406,187 | $131,077 | ERROR | ||||
84 | 84 | Ending Capital Reserve and/or Risk Mgmt./Insurance Reserve Balance | $89,672 | $89,672 | $89,672 | $89,672 | OK | $89,672 | $89,672 | $89,672 | $89,672 | OK | $89,672 | $89,672 | $89,672 | $89,672 | OK | $89,672 | $89,672 | $89,672 | $89,672 | OK | $89,672 | $89,672 | $89,672 | $89,672 | OK | $89,672 | $89,672 | $89,672 | $89,672 | OK | $89,672 | $89,672 | $89,672 | $89,672 | OK | $89,672 | $89,672 | $89,672 | $89,672 | OK | $89,672 | $89,672 | $89,672 | $89,672 | OK | $89,672 | $89,672 | $89,672 | $89,672 | OK | $89,672 | $89,672 | $89,672 | $89,672 | OK | $89,672 | $89,672 | $89,672 | $89,672 | OK | ||||
85 | 85 | TABOR Reserve | $1,573,824 | $1,573,824 | $1,573,824 | $1,573,824 | OK | $1,573,824 | $1,573,824 | $1,573,824 | $1,573,824 | OK | $1,573,824 | $1,573,824 | $1,573,824 | $1,573,824 | OK | $1,573,824 | $1,573,824 | $1,573,824 | $1,573,824 | OK | $1,573,824 | $1,573,824 | $1,573,824 | $1,573,824 | OK | $1,573,824 | $1,573,824 | $1,573,824 | $1,573,824 | OK | $1,573,824 | $1,573,824 | $1,573,824 | $1,573,824 | OK | $1,573,824 | $1,573,824 | $1,573,824 | $1,573,824 | OK | $1,573,824 | $1,573,824 | $1,573,824 | $1,573,824 | OK | $1,573,824 | $1,573,824 | $1,573,824 | $1,573,824 | OK | $1,573,824 | $1,573,824 | $1,573,824 | $1,573,824 | OK | $1,573,824 | $1,573,824 | $1,573,824 | $1,573,824 | OK | ||||
86 | 86 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
87 | 87 | Notes: | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
88 | 88 | $52,460,810 | 1. Prior Year (FY 23/24) TABOR District Spending (enter amount) - this will calculate negative value used in Cell E17 above | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
89 | 89 | 2. Exclude Cap. Res., Risk Mgmt./Ins. Res., Pupil Activity (non-GF supported revenue/spending), | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
90 | 90 | Self Insurance Funds, Bond Redemption, and Capital Project Funds using exclusively voted bond funding. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
237 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
249 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
252 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
261 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
262 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
265 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
266 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
267 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
268 |