Budget Overview for Fiscal Year 2014 Analysis

annual budget fiscal year 2014 n.w
1 / 24
Embed
Share

Explore the detailed breakdown of the fiscal year 2014 budget, including revenues, expenditures, fund balances, and comparisons with the previous year's budget. Gain insights into governmental, fiduciary, and expendable fund categories, along with revenue sources and fund usage analysis.

  • Budget
  • Fiscal Year 2014
  • Analysis
  • Revenues
  • Expenditures

Uploaded on | 1 Views


Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.

E N D

Presentation Transcript


  1. Annual Budget Fiscal Year 2014 Jason W. Taylor September 5, 2013 1

  2. Fiscal Year 2014 Budget (Proposed) ` ACTUAL BUDGET $ VAR % BUDGET GOVERNMENTAL FIDUCIARY EXPENDABLE -------------- SPECIAL REVENUE -------------- -------------- -------------- DEBT SERVICE CAPITAL PROJECTS TOTAL (Memo Only) REVENUES GENERAL $ 169,795 TRUST STATE REVENUES $ 108,078,774 $ 107,908,979 0.1% FEDERAL REVENUES 845,251 1,422,767 (577,516) -0.3% REVENUES STATE REVENUES FEDERAL REVENUES LOCAL REVENUES OTHER REVENUES LOCAL REVENUES 96,243,298 1,097,897 24,212,718 9,326,211 250,000 34,886,826 92,987,042 $ 74,971,841 3,256,256 $ 397,500 1.6% 182,164,220 $ 24,889,603 104,938,511 250,000 312,242,334 108,196,347 $ 676,885 93,112,935 201,986,167 $ $ - - - - - 72,869,976 - - OTHER REVENUES 371,957 10,000 361,957 0.2% - TOTAL REVENUES 205,539,280 202,328,788 3,210,492 1.6% 2,101,865 397,500 EXPENDITURES: - - - INSTRUCTIONAL SERVICES TOTAL REVENUES 121,540,151 119,636,495 (1,903,656) -1.0% INSTRUCTIONAL SUPPORT SERVICES 30,241,415 35,237,781 4,996,366 2.5% OPERATIONS & MAINTENANCE EXPENDITURES: INSTRUCTIONAL SERVICES INSTRUCTIONAL SUPPORT SERVICES OPERATIONS & MAINTENANCE AUXILIARY SERVICES GENERAL ADMINISTRATIVE SERVICES CAPITAL OUTLAY DEBT SERVICES OTHER EXPENDITURES TOTAL EXPENDITURES 24,359,609 23,324,132 (1,035,476) -0.5% AUXILIARY SERVICES 5,899,051 6,370,789 85,825,000 6,959,509 94,424,509 471,738 0.2% 130,031,075 43,793,690 27,411,907 19,396,353 8,235,751 86,225,000 10,620,772 4,754,899 330,469,447 117,299,607 35,656,744 25,916,807 7,367,986 7,286,360 400,000 3,168,629 197,096,133 11,683,598 3,661,263 3,661,263 - - - - - - 900,000 (3,795,371) 343,627 147,870 186,257 GENERAL ADMINISTRATIVE SERVICES 11,214,224 7,950,689 755,100 12,028,367 949,391 1,576,770 34,943,915 7,418,853 -1.9% - DEBT SERVICES 1,227,753 1,227,753 - 0.0% 740,000 - - - - - OTHER EXPENDITURES 1,957,572 5,236,836 3,279,264 1.7% - - TOTAL EXPENDITURES 196,439,775 198,452,640 2,012,865 1.0% OTHER FUND SOURCES (USES): 323,193 - - TRANSFERS IN - 323,193 34.1% - OTHER FUND SOURCES 1,908,749 2,149,033 (240,284) -25.3% - - 9,500 TRANSFERS OUT 1,500,132 3,098,053 1,597,922 168.4% TOTAL OTHER FUND SOURCES (USES) 731,810 (949,020) 1,680,831 177.1% EXCESS REVENUES & OTHER SOURCES OTHER FUND SOURCES (USES): OTHER FUND SOURCES OTHER FUND USES TOTAL OTHER FUND SOURCES (USES) 2,989,113 7,879,147 (4,890,034) 2,314,644 2,000,000 314,644 7,564,503 7,564,503 2,927,128 - - - 6,904,188 - - - 235.9% 12,868,260 9,879,147 2,989,113 OVER(UNDER)EXPENDITURES & OTHER FUND USES 9,831,316 - BEGINNING FUND BALANCE 844,421 844,421 - ENDING FUND BALANCE EXCESS REVENUES & OTHER SOURCES OVER (UNDER) EXPENDITURES & OTHER FUND USES $ 10,675,737 $ 3,771,549 $ 6,904,188 183.1% - 257,555 3,903,240 (19,452,668) 53,873 (15,238,000) 1,625,597 43.1% RESERVED FUND BALANCE (ENDING) 1,625,597.38 - 5,278,591 140.0% 68,537,355 UNRESERVED FUND BALANCE (ENDING) BEGINNING FUND BALANCE - OCT 1 9,050,139.77 3,771,549.09 3,250,000 17,900,000 7,056,969 40,000,000 330,386 6,904,188 183.1% 10,675,737.15 3,771,549.09 17,900,000 $ 7,314,524 $ 7,153,240 $ 20,547,332 $ $ 384,259 53,299,355 $ ENDING FUND BALANCE - SEP 30 REQUIRED FUND BALANCE (ALSDE) 16,369,981.23 16,369,981.23 32.2% % COVERAGE OF REQUIRED FUND BALANCE 55.3% 23.0% 2

  3. General Fund Activity Fiscal Year 2014 vs. 2013 ACTUAL BUDGET $ VAR % BUDGET FY 2013 BUDGET -------------- -------------- (AMENDED) -------------- -------------- FY 2014 BUDGET $ VAR % VAR REVENUES STATE REVENUES $ 108,078,774 $ 107,908,979 $ 169,795 0.1% REVENUES STATE REVENUES FEDERAL REVENUES LOCAL REVENUES OTHER REVENUES FEDERAL REVENUES 845,251 52.8% 0.3% 45.4% 1.5% 100.0% 1,422,767 (577,516) $ (10,192,457) -0.3% 108,196,347 676,885 93,112,935 2,989,113 204,975,280 $ 106,839,479 1,570,788 101,695,037 5,062,433 215,167,737 $ 49.7% 0.7% 47.3% 2.4% 100.0% 1,356,868 (893,903) (8,582,102) (2,073,320) 1.3% LOCAL REVENUES 96,243,298 92,987,042 3,256,256 1.6% -56.9% -8.4% -41.0% -4.7% OTHER REVENUES 371,957 10,000 361,957 0.2% TOTAL REVENUES 205,539,280 202,328,788 3,210,492 1.6% EXPENDITURES: INSTRUCTIONAL SERVICES TOTAL REVENUES 121,540,151 119,636,495 (1,903,656) -1.0% INSTRUCTIONAL SUPPORT SERVICES 30,241,415 35,237,781 4,996,366 2.5% OPERATIONS & MAINTENANCE EXPENDITURES: INSTRUCTIONAL SERVICES OPERATIONS & MAINTENANCE AUXILIARY SERVICES GENERAL ADMINISTRATIVE SERVICES DEBT SERVICES OTHER EXPENDITURES TOTAL EXPENDITURES 24,359,609 23,324,132 (1,035,476) -0.5% AUXILIARY SERVICES 5,899,051 74.6% 12.6% 3.6% 3.6% 0.0% 5.6% 100.0% 6,370,789 471,738 (2,945,942) 0.2% 204,975,280 152,956,351 25,916,807 154,398,872 27,069,245 6,937,393 11,576,989 1,263,878 6,674,845 207,921,222 74.3% 13.0% 3.3% 5.6% 0.6% 3.2% 100.0% (1,442,521) (1,152,438) 430,593 (4,290,629) (1,263,878) 4,772,931 -0.9% -4.3% 6.2% GENERAL ADMINISTRATIVE SERVICES 11,214,224 7,418,853 (3,795,371) -1.9% 1,227,753 DEBT SERVICES 1,227,753 7,367,986 7,286,360 - 0.0% OTHER EXPENDITURES 1,957,572 5,236,836 3,279,264 1.7% TOTAL EXPENDITURES 196,439,775 198,452,640 2,012,865 1.0% -37.1% -100.0% 71.5% -1.4% - OTHER FUND SOURCES (USES): 11,447,776 TRANSFERS IN 323,193 - 323,193 34.1% OTHER FUND SOURCES 1,908,749 2,149,033 (240,284) -25.3% TRANSFERS OUT 1,500,132 3,098,053 1,597,922 168.4% TOTAL OTHER FUND SOURCES (USES) EXCESS REVENUES & OTHER SOURCES OVER(UNDER) EXPENDITURES & OTHER FUND USES 731,810 (949,020) 1,680,831 177.1% - 7,246,515 (7,246,515) -100.0% EXCESS REVENUES & OTHER SOURCES OVER(UNDER)EXPENDITURES & OTHER FUND USES 9,831,316 2,927,128 6,904,188 235.9% BEGINNING FUND BALANCE BEGINNING FUND BALANCE 17,900,000 10,671,591 7,228,409 844,421 844,421 - ENDING FUND BALANCE ENDING FUND BALANCE $ 10,675,737 $ 3,771,549 17,918,106 $ $ 6,904,188 $ 183.1% $ 17,900,000 (18,106) -0.1% 1,625,597 43.1% RESERVED FUND BALANCE (ENDING) % COVERAGE OF REQUIRED FUND BALANCE 1,625,597.38 109% - 109% 0% 5,278,591 140.0% UNRESERVED FUND BALANCE (ENDING) 9,050,139.77 3,771,549.09 6,904,188 183.1% 10,675,737.15 3,771,549.09 REQUIRED FUND BALANCE (ALSDE) 16,369,981.23 16,369,981.23 32.2% % COVERAGE OF REQUIRED FUND BALANCE 55.3% 23.0% 3

  4. Revenue/Expenditures As % of Total Revenues 70.0% 63.0% 63.0% 60.0% 50.0% 40.0% 29.0% 30.0% Expenditures 23.1% 20.0% 11.4% 11.4% Revenues 10.0% 2.3% 1.1% 0.1% 0.1% 0.0% GENERAL FUND SPECIAL REVENUE FUND DEBT SERVICE FUND CAPITAL PROJECTS FUND OTHER REVENUES 4

  5. Revenues (by Source) * $250,000 Sales Sales STATE REVENUES - 46.7% FEDERAL REVENUES - 10.2% $104,938,511 $114,151,888 LOCAL REVENUES - 43.0% OTHER REVENUES - 0.1% Federal State State Federal Local Local $24,889,603 Other Other * Percentage allocations are presented net of capital bond proceeds (~$68,000,000) in order to normalize the revenue allocation between funding sources. 5

  6. Expenditures (by Function) * $15,375,671 $8,235,751 Sales Sales $19,396,353 INSTRUCTIONAL -71.2% OPS & MAINT -11.2% $27,411,907 AUXILIARY - 7.9% Federal State GEN & ADMIN - 3.4% OTHER USES -6.3% $173,824,765 State Federal Local Local Other Other * Percentage allocations are presented net of capital construction outlay (~$86,225,000) in order to normalize true direction of District expenditures. 6

  7. Fiscal Year 2014 Special Initiatives EXHIBIT F-I-A ACCT GROUPS F/A & L/T DEBT -------------- FUND TYPES & ACCOUNT GROUPS PRE-KINDERGARTEN PROGRAMS $ 700,000 GOVERNMENTAL SPECIAL REVENUE -------------- PROPRIETARY ENTERPRISE INTERNAL -------------- FIDUCIARY TRUST & AGENCY -------------- DEBT SERVICE -------------- CAPITAL PROJECTS -------------- DESCRIPTION GENERAL -------------- -------------------------------------- ASSETS & OTHER DEBITS: CASH & CASH EQUIVALENTS INVESTMENTS RECEIVABLES ALLOWANCE FOR DOUBTFUL ACCTS INTERFUND RECEIVABLES OTHER RECEIVABLES INVENTORIES OTHER ASSETS FIXED ASSETS ACCUMULATED DEPRECIATION OTHER DEBITS AMT AVAILABLE IN DEBT SVC AMT PROV FOR PMT OF L-T DEBT OTHER DEBITS TOTAL ASSETS & OTHER DEBITS 9,770,165.15 2,094.75 9,733,973.38 4,500.26 0.00 64,873,420.93 0.00 0.00 529,508.68 0.00 0.00 EXHIBIT F-I-A ACCT GROUPS F/A & L/T DEBT -------------- 0.00 0.00 0.00 FUND TYPES & ACCOUNT GROUPS GOVERNMENTAL SPECIAL REVENUE -------------- PROPRIETARY ENTERPRISE INTERNAL -------------- FIDUCIARY TRUST & AGENCY -------------- DEBT SERVICE -------------- CAPITAL PROJECTS -------------- STEM PROGRAMS 900,000 DESCRIPTION GENERAL -------------- 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -------------------------------------- ASSETS & OTHER DEBITS: CASH & CASH EQUIVALENTS INVESTMENTS RECEIVABLES ALLOWANCE FOR DOUBTFUL ACCTS INTERFUND RECEIVABLES OTHER RECEIVABLES INVENTORIES OTHER ASSETS FIXED ASSETS ACCUMULATED DEPRECIATION OTHER DEBITS AMT AVAILABLE IN DEBT SVC AMT PROV FOR PMT OF L-T DEBT OTHER DEBITS TOTAL ASSETS & OTHER DEBITS 1,500,000.00 5,321,734.39 4,111,162.47 316,421.31 730.39 0.00 0.00 0.00 0.00 9,770,165.15 2,094.75 9,733,973.38 4,500.26 0.00 64,873,420.93 0.00 0.00 529,508.68 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 475,653,053.75 1,500,000.00 5,321,734.39 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 ELL PROGRAMS 4,111,162.47 316,421.31 150,000 730.39 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 27,802,277.77 475,653,053.75 0.00 0.00 16,593,994.29 14,161,557.16 4,500.26 64,873,420.93 530,239.07 503,455,331.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 400,000 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 27,802,277.77 LIABILITIES & FUND EQUITY: LIABILITIES: SALARIES & BENEFITS PAYABLE PAYROLL W/H & DED PAYABLE CLAIMS PAYABLE OTHER PAYABLES INTERFUND PAYABLES OTHER PAYABLES OTHER LIABILITIES LONG-TERM LIABILITIES TOTAL LIABILITIES 0.00 COLUMBIA STAGE LIGHTING/SOUND 16,593,994.29 14,161,557.16 4,500.26 64,873,420.93 530,239.07 503,455,331.52 274,082.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 56,931.71 LIABILITIES & FUND EQUITY: LIABILITIES: SALARIES & BENEFITS PAYABLE PAYROLL W/H & DED PAYABLE CLAIMS PAYABLE OTHER PAYABLES INTERFUND PAYABLES OTHER PAYABLES OTHER LIABILITIES LONG-TERM LIABILITIES TOTAL LIABILITIES 18,950.00 5,362.88 0.00 274,082.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 340,000 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 56,931.71 0.00 1,500,000.00 53,425.10 1,855,799.78 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 18,950.00 5,362.88 0.00 3,491,350.69 ENHANCED SUPPLEMENTS* 0.00 1,500,000.00 53,425.10 1,855,799.78 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,133,874.44 5,918,257.14 0.00 27,802,277.77 27,802,277.77 2,133,874.44 5,918,257.14 3,491,350.69 0.00 3,414,587.76 56,931.71 0.00 27,802,277.77 27,802,277.77 3,414,587.76 56,931.71 FUND EQUITY: INVESTMENT IN FIXED ASSETS RETAINED EARNINGS CONTRIBUTED CAPITAL RESERVED FUND BALANCE UNRESERVED FUND BALANCE TOTAL FUND EQUITY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 475,653,053.75 FUND EQUITY: INVESTMENT IN FIXED ASSETS RETAINED EARNINGS CONTRIBUTED CAPITAL RESERVED FUND BALANCE UNRESERVED FUND BALANCE TOTAL FUND EQUITY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 475,653,053.75 TOTAL REVENUES $ 2,490,000 0.00 0.00 0.00 0.00 1,625,597.38 9,050,139.77 10,675,737.15 485,435.30 10,261,534.10 10,746,969.40 1,854,033.30 63,019,387.63 64,873,420.93 1,625,597.38 9,050,139.77 485,435.30 10,261,534.10 10,746,969.40 1,854,033.30 63,019,387.63 64,873,420.93 4,500.26 4,500.26 473,307.36 473,307.36 4,500.26 4,500.26 473,307.36 473,307.36 475,653,053.75 10,675,737.15 475,653,053.75 TOTAL LIABILITIES & FUND EQUITY 16,593,994.29 14,161,557.16 4,500.26 64,873,420.93 0.00 530,239.07 503,455,331.52 16,593,994.29 TOTAL LIABILITIES & FUND EQUITY 14,161,557.16 4,500.26 64,873,420.93 0.00 530,239.07 503,455,331.52 7

  8. Huntsville City Schools Supplements Purpose Attract and retain HCS faculty/staff to participate in extracurricular academic and character development activities to further promote our students to higher levels of mental and physical performance and personal growth to help them succeed in life.

  9. Huntsville City Schools Supplements Overview Supplements are given at the discretion of the district Governed by HCS Policy 5.4, Supplemental Duties By appointment at district level (with principal input) NOT an entitlement or guaranteed by tenure Assignments to be made and approved on an annual basis May be removed or resign from supplemental (i.e., coaching) position at any time

  10. Huntsville City Schools Supplements Overview Regardless of whether they are certified or classified employees or non-HCS employees, athletic and academic coaches will receive the same supplement amount With the exception of classified employees whose job duties are substantially similar to their coaching duties, classified athletic and academic coaches are considered volunteers Volunteer coaches will not receive overtime for any of the volunteer activities performed in their coaching capacity

  11. Huntsville City Schools Supplements Examples Academic: Academic Competition; Math Team; National Honor Society; Science Team; Career Tech; Debate; Foreign Language; Robotics; Cyber Security, etc. Athletics: High School/Middle School Athletic Directors; Head/Assistant Coaches (Football, Basketball, Baseball, Cheerleading, Wrestling, etc.) Arts: Band Directors/Assistants; Choral; Art Club; Drama; Newspaper/Journalism; Literary Publications Community: Junior/Senior Class; Service Clubs; Student Council; Yearbook; Webmaster; Safety Coordinator

  12. Huntsville City Schools Supplements New Supplements: High School/Middle School Athletics Directors: Oversee all athletics programs for the school; will also manage their school s supplement program (with the exception of their own) Career Tech: Regional/ International-level performance teams (Green Car Team/Culinary Arts) IB Coordinators (moved from principal s books) Cyber Security Robotics Student to Student STEM Coordinators School Webmasters School Safety Coordinators District Scholarship Coordinator Deleted: Credit Recovery Coordinator

  13. Huntsville City Schools Supplements Rate Changes Increase in Current Supplements All will see an increase Rates will meet or exceed those paid in Madison City and Madison County for comparable duties Larger supplement increases will be stepped Last year s (2012-2013) rate will be Step 1 Those in second year or more will receive Step 2 Increase each year to Step 4 Effective Date: 2014 Budget Year (Oct 1, 2013)

  14. Huntsville City Schools Supplements Examples (Not All Inclusive) Madison County Madison City Huntsville City Schools Program School Level Athletic Director High School $ - $4,000 $4,000 Band (Head) High School $6,000 $8,000 $8,500 Baseball (Head) High School $4,700 $6,000 $6,025 Basketball (Head) High School $8,000 $9,000 $9,025 Career Readiness High School $ - $ - $3500 - $8500 Competitive Academic Team High School $1,000 $1,800 $2,200 Cross Country Boys and Girls High School $600 $1,500 $1,500 Cyber Security High School $ - $ - $1,000 - $5,000 Football (Head) High School $8,000 $10,000 $13,000 Football Assistant OC/DC High School $4,500 $6,250 $6,250 Football Assistant High School $3,200 $5,000 $5,000 Robotics High School $ - $ - $1,000 - $5000 STEM Coordinator High School $ - $ - $2,000 Service Clubs High School $ - $200 $250

  15. Huntsville City Schools Supplements Examples (Not All Inclusive) Madison County Madison City Huntsville City Schools Program School Level Webmaster K-12 $ - $ - $1,000 - $2000 Artist Director Choreographic Magnet $ - $ - $6,000 Artist Director Ensemble Production Magnet $ - $ - $6,000 Artist Director Orchestra Magnet $ - $ - $6,000 Artist Director Vocal Magnet $ - $ - $6,000 Band Middle School $ - $2,400 $3,850 Cheerleaders Middle School $ - $1,800 $1,870 Choral Middle School $ - $900 $1,320 Football (Head) Middle School $ - $4,000 $4,400 IB Coordinator Middle School $ - $ - $4,000 STEM Coordinator Middle School $ - $ - $2,000 Academic Competition Coordinator Other $ - $ - $6,050 Scholarship Coordinator Other $ - $ - $1,000 School Safety Coordinator Other $ - $ - $275

  16. Fiscal Year 2014 Capital Projects EXHIBIT F-I-A ACCT GROUPS F/A & L/T DEBT -------------- FUND TYPES & ACCOUNT GROUPS 70,000,000 GOVERNMENTAL SPECIAL REVENUE -------------- PROPRIETARY ENTERPRISE INTERNAL -------------- FIDUCIARY TRUST & AGENCY -------------- DEBT SERVICE -------------- CAPITAL PROJECTS -------------- DESCRIPTION GENERAL -------------- -------------------------------------- ASSETS & OTHER DEBITS: CASH & CASH EQUIVALENTS INVESTMENTS RECEIVABLES ALLOWANCE FOR DOUBTFUL ACCTS INTERFUND RECEIVABLES OTHER RECEIVABLES INVENTORIES OTHER ASSETS FIXED ASSETS ACCUMULATED DEPRECIATION OTHER DEBITS AMT AVAILABLE IN DEBT SVC AMT PROV FOR PMT OF L-T DEBT OTHER DEBITS TOTAL ASSETS & OTHER DEBITS 9,770,165.15 2,094.75 9,733,973.38 4,500.26 0.00 64,873,420.93 0.00 0.00 529,508.68 0.00 0.00 EXHIBIT F-I-A ACCT GROUPS F/A & L/T DEBT -------------- 60,000,000 0.00 0.00 0.00 FUND TYPES & ACCOUNT GROUPS GOVERNMENTAL SPECIAL REVENUE -------------- PROPRIETARY ENTERPRISE INTERNAL -------------- FIDUCIARY TRUST & AGENCY -------------- DEBT SERVICE -------------- CAPITAL PROJECTS -------------- DESCRIPTION GENERAL -------------- 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -------------------------------------- ASSETS & OTHER DEBITS: CASH & CASH EQUIVALENTS INVESTMENTS RECEIVABLES ALLOWANCE FOR DOUBTFUL ACCTS INTERFUND RECEIVABLES OTHER RECEIVABLES INVENTORIES OTHER ASSETS FIXED ASSETS ACCUMULATED DEPRECIATION OTHER DEBITS AMT AVAILABLE IN DEBT SVC AMT PROV FOR PMT OF L-T DEBT OTHER DEBITS TOTAL ASSETS & OTHER DEBITS 1,500,000.00 5,321,734.39 4,111,162.47 316,421.31 730.39 0.00 0.00 0.00 0.00 9,770,165.15 2,094.75 9,733,973.38 4,500.26 0.00 64,873,420.93 0.00 0.00 529,508.68 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 50,000,000 0.00 0.00 0.00 475,653,053.75 1,500,000.00 5,321,734.39 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4,111,162.47 316,421.31 730.39 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 27,802,277.77 475,653,053.75 0.00 40,000,000 0.00 16,593,994.29 14,161,557.16 4,500.26 64,873,420.93 530,239.07 503,455,331.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 27,802,277.77 LIABILITIES & FUND EQUITY: LIABILITIES: SALARIES & BENEFITS PAYABLE PAYROLL W/H & DED PAYABLE CLAIMS PAYABLE OTHER PAYABLES INTERFUND PAYABLES OTHER PAYABLES OTHER LIABILITIES LONG-TERM LIABILITIES TOTAL LIABILITIES 0.00 16,593,994.29 14,161,557.16 4,500.26 64,873,420.93 530,239.07 503,455,331.52 274,082.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 56,931.71 LIABILITIES & FUND EQUITY: LIABILITIES: SALARIES & BENEFITS PAYABLE PAYROLL W/H & DED PAYABLE CLAIMS PAYABLE OTHER PAYABLES INTERFUND PAYABLES OTHER PAYABLES OTHER LIABILITIES LONG-TERM LIABILITIES TOTAL LIABILITIES 30,000,000 18,950.00 5,362.88 0.00 274,082.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 56,931.71 0.00 1,500,000.00 53,425.10 1,855,799.78 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 18,950.00 5,362.88 0.00 3,491,350.69 0.00 1,500,000.00 53,425.10 1,855,799.78 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,133,874.44 5,918,257.14 0.00 27,802,277.77 27,802,277.77 2,133,874.44 5,918,257.14 3,491,350.69 20,000,000 0.00 3,414,587.76 56,931.71 0.00 27,802,277.77 27,802,277.77 3,414,587.76 56,931.71 FUND EQUITY: INVESTMENT IN FIXED ASSETS RETAINED EARNINGS CONTRIBUTED CAPITAL RESERVED FUND BALANCE UNRESERVED FUND BALANCE TOTAL FUND EQUITY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 475,653,053.75 FUND EQUITY: INVESTMENT IN FIXED ASSETS RETAINED EARNINGS CONTRIBUTED CAPITAL RESERVED FUND BALANCE UNRESERVED FUND BALANCE TOTAL FUND EQUITY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 475,653,053.75 0.00 0.00 0.00 0.00 10,000,000 1,625,597.38 9,050,139.77 10,675,737.15 485,435.30 10,261,534.10 10,746,969.40 1,854,033.30 63,019,387.63 64,873,420.93 1,625,597.38 9,050,139.77 485,435.30 10,261,534.10 10,746,969.40 1,854,033.30 63,019,387.63 64,873,420.93 4,500.26 4,500.26 473,307.36 473,307.36 4,500.26 4,500.26 473,307.36 473,307.36 475,653,053.75 10,675,737.15 475,653,053.75 TOTAL LIABILITIES & FUND EQUITY 16,593,994.29 14,161,557.16 4,500.26 64,873,420.93 0.00 530,239.07 503,455,331.52 16,593,994.29 TOTAL LIABILITIES & FUND EQUITY 14,161,557.16 4,500.26 64,873,420.93 0.00 530,239.07 503,455,331.52 - Grissom High School North Huntsville High School Huntsville HS 9th Grade Academy Whitesburg P-8 University Place Elem School Milton Frank - Phase II FY 2014 Budget Total Program Budget 17

  17. Fund Balance Historical/Projected $20,000,000 $17,900,000 Sales Sales $15,000,000 $10,675,737 $10,000,000 $5,000,000 $844,421 $485,806 Fund Balance $- 2009 2010 2011 2012 2013 Federal State $(5,000,000) State Federal Local Local $(10,000,000) Other Other $(15,000,000) $(20,000,000) $(19,766,842) $(25,000,000) 18

  18. Fund Balance Coverage Historical/Projected 150.0% Sales Sales 108.5% 100.0% 64.7% 50.0% 5.1% 2.9% Federal State 0.0% 2009 2010 2011 2012 2013 State Federal Local Local -50.0% Other Other -100.0% -119.8% -150.0% 19

  19. Financial Forecast: Fiscal Year 2014 ALSDE Foundation Funding: FUND TYPES & ACCOUNT GROUPS Education Trust Fund appropriations (~$50M) diverted to fund private school transfer credits (Alabama Accountability Act). EXHIBIT F-I-A ACCT GROUPS F/A & L/T DEBT -------------- GOVERNMENTAL SPECIAL REVENUE -------------- PROPRIETARY ENTERPRISE INTERNAL -------------- FIDUCIARY TRUST & AGENCY -------------- DEBT SERVICE -------------- CAPITAL PROJECTS -------------- DESCRIPTION GENERAL -------------- -------------------------------------- ASSETS & OTHER DEBITS: CASH & CASH EQUIVALENTS INVESTMENTS RECEIVABLES ALLOWANCE FOR DOUBTFUL ACCTS INTERFUND RECEIVABLES OTHER RECEIVABLES INVENTORIES OTHER ASSETS FIXED ASSETS ACCUMULATED DEPRECIATION OTHER DEBITS AMT AVAILABLE IN DEBT SVC AMT PROV FOR PMT OF L-T DEBT OTHER DEBITS TOTAL ASSETS & OTHER DEBITS While HCS saw a modest increase in pupil enrollment, there is a decrease in the number funded teaching units (5.7 units, loss of $355,000 in funding). 9,770,165.15 2,094.75 9,733,973.38 4,500.26 0.00 64,873,420.93 0.00 0.00 529,508.68 0.00 0.00 EXHIBIT F-I-A ACCT GROUPS F/A & L/T DEBT -------------- 0.00 0.00 0.00 FUND TYPES & ACCOUNT GROUPS GOVERNMENTAL SPECIAL REVENUE -------------- PROPRIETARY ENTERPRISE INTERNAL -------------- FIDUCIARY TRUST & AGENCY -------------- DEBT SERVICE -------------- CAPITAL PROJECTS -------------- DESCRIPTION GENERAL -------------- 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -------------------------------------- ASSETS & OTHER DEBITS: CASH & CASH EQUIVALENTS INVESTMENTS RECEIVABLES ALLOWANCE FOR DOUBTFUL ACCTS INTERFUND RECEIVABLES OTHER RECEIVABLES INVENTORIES OTHER ASSETS FIXED ASSETS ACCUMULATED DEPRECIATION OTHER DEBITS AMT AVAILABLE IN DEBT SVC AMT PROV FOR PMT OF L-T DEBT OTHER DEBITS TOTAL ASSETS & OTHER DEBITS 1,500,000.00 5,321,734.39 4,111,162.47 316,421.31 730.39 0.00 0.00 0.00 0.00 9,770,165.15 2,094.75 9,733,973.38 4,500.26 0.00 64,873,420.93 0.00 0.00 529,508.68 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 475,653,053.75 1,500,000.00 5,321,734.39 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4,111,162.47 316,421.31 730.39 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 27,802,277.77 475,653,053.75 0.00 0.00 16,593,994.29 14,161,557.16 4,500.26 64,873,420.93 530,239.07 503,455,331.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 27,802,277.77 LIABILITIES & FUND EQUITY: LIABILITIES: SALARIES & BENEFITS PAYABLE PAYROLL W/H & DED PAYABLE CLAIMS PAYABLE OTHER PAYABLES INTERFUND PAYABLES OTHER PAYABLES OTHER LIABILITIES LONG-TERM LIABILITIES TOTAL LIABILITIES 0.00 16,593,994.29 14,161,557.16 4,500.26 64,873,420.93 530,239.07 503,455,331.52 274,082.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 56,931.71 LIABILITIES & FUND EQUITY: LIABILITIES: SALARIES & BENEFITS PAYABLE PAYROLL W/H & DED PAYABLE CLAIMS PAYABLE OTHER PAYABLES INTERFUND PAYABLES OTHER PAYABLES OTHER LIABILITIES LONG-TERM LIABILITIES TOTAL LIABILITIES 18,950.00 5,362.88 0.00 274,082.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 56,931.71 0.00 1,500,000.00 53,425.10 1,855,799.78 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 18,950.00 5,362.88 0.00 3,491,350.69 0.00 1,500,000.00 53,425.10 1,855,799.78 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,133,874.44 5,918,257.14 0.00 27,802,277.77 27,802,277.77 2,133,874.44 5,918,257.14 3,491,350.69 0.00 3,414,587.76 56,931.71 0.00 27,802,277.77 27,802,277.77 3,414,587.76 56,931.71 FUND EQUITY: INVESTMENT IN FIXED ASSETS RETAINED EARNINGS CONTRIBUTED CAPITAL RESERVED FUND BALANCE UNRESERVED FUND BALANCE TOTAL FUND EQUITY Although Foundation revenues allocated for fringe benefits and other current expenses increased by $1.5M, so did the required 10 Mill Foundation match (paid from local funds). 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 475,653,053.75 FUND EQUITY: INVESTMENT IN FIXED ASSETS RETAINED EARNINGS CONTRIBUTED CAPITAL RESERVED FUND BALANCE UNRESERVED FUND BALANCE TOTAL FUND EQUITY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 475,653,053.75 0.00 0.00 0.00 0.00 1,625,597.38 9,050,139.77 10,675,737.15 485,435.30 10,261,534.10 10,746,969.40 1,854,033.30 63,019,387.63 64,873,420.93 1,625,597.38 9,050,139.77 485,435.30 10,261,534.10 10,746,969.40 1,854,033.30 63,019,387.63 64,873,420.93 4,500.26 4,500.26 473,307.36 473,307.36 4,500.26 4,500.26 473,307.36 473,307.36 475,653,053.75 10,675,737.15 475,653,053.75 TOTAL LIABILITIES & FUND EQUITY 16,593,994.29 14,161,557.16 4,500.26 64,873,420.93 0.00 530,239.07 503,455,331.52 16,593,994.29 TOTAL LIABILITIES & FUND EQUITY 14,161,557.16 4,500.26 64,873,420.93 0.00 530,239.07 503,455,331.52 20

  20. Financial Forecast: Fiscal Year 2014 (contd) ALSDE Foundation Funding (continued): Meaning the cost burden for the Foundation units salary increase, FUND TYPES & ACCOUNT GROUPS which will take effect in October 2012, and the 1.73% increase in TRSA match will fall on the District. Total estimated cost of the changes in the Foundation Program to Huntsville City Schools in Fiscal Year 2014 is approximately $2M. EXHIBIT F-I-A ACCT GROUPS F/A & L/T DEBT -------------- GOVERNMENTAL SPECIAL REVENUE -------------- PROPRIETARY ENTERPRISE INTERNAL -------------- FIDUCIARY TRUST & AGENCY -------------- DEBT SERVICE -------------- CAPITAL PROJECTS -------------- DESCRIPTION GENERAL -------------- -------------------------------------- ASSETS & OTHER DEBITS: CASH & CASH EQUIVALENTS INVESTMENTS RECEIVABLES ALLOWANCE FOR DOUBTFUL ACCTS INTERFUND RECEIVABLES OTHER RECEIVABLES INVENTORIES OTHER ASSETS FIXED ASSETS ACCUMULATED DEPRECIATION OTHER DEBITS AMT AVAILABLE IN DEBT SVC AMT PROV FOR PMT OF L-T DEBT OTHER DEBITS TOTAL ASSETS & OTHER DEBITS 9,770,165.15 2,094.75 9,733,973.38 4,500.26 0.00 64,873,420.93 0.00 0.00 529,508.68 0.00 0.00 EXHIBIT F-I-A ACCT GROUPS F/A & L/T DEBT -------------- 0.00 0.00 0.00 FUND TYPES & ACCOUNT GROUPS GOVERNMENTAL SPECIAL REVENUE -------------- PROPRIETARY ENTERPRISE INTERNAL -------------- FIDUCIARY TRUST & AGENCY -------------- DEBT SERVICE -------------- CAPITAL PROJECTS -------------- DESCRIPTION GENERAL -------------- 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -------------------------------------- ASSETS & OTHER DEBITS: CASH & CASH EQUIVALENTS INVESTMENTS RECEIVABLES ALLOWANCE FOR DOUBTFUL ACCTS INTERFUND RECEIVABLES OTHER RECEIVABLES INVENTORIES OTHER ASSETS FIXED ASSETS ACCUMULATED DEPRECIATION OTHER DEBITS AMT AVAILABLE IN DEBT SVC AMT PROV FOR PMT OF L-T DEBT OTHER DEBITS TOTAL ASSETS & OTHER DEBITS 1,500,000.00 5,321,734.39 4,111,162.47 316,421.31 10 Mill Foundation Match 730.39 0.00 0.00 0.00 0.00 9,770,165.15 2,094.75 9,733,973.38 4,500.26 0.00 64,873,420.93 0.00 0.00 529,508.68 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 475,653,053.75 1,500,000.00 5,321,734.39 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4,111,162.47 316,421.31 730.39 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 27,802,277.77 475,653,053.75 0.00 0.00 $23,000,000 16,593,994.29 14,161,557.16 4,500.26 64,873,420.93 530,239.07 503,455,331.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 27,802,277.77 LIABILITIES & FUND EQUITY: LIABILITIES: SALARIES & BENEFITS PAYABLE PAYROLL W/H & DED PAYABLE CLAIMS PAYABLE OTHER PAYABLES INTERFUND PAYABLES OTHER PAYABLES OTHER LIABILITIES LONG-TERM LIABILITIES TOTAL LIABILITIES 0.00 16,593,994.29 14,161,557.16 20.5%* 4,500.26 64,873,420.93 530,239.07 503,455,331.52 274,082.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $22,500,000 0.00 56,931.71 LIABILITIES & FUND EQUITY: LIABILITIES: SALARIES & BENEFITS PAYABLE PAYROLL W/H & DED PAYABLE CLAIMS PAYABLE OTHER PAYABLES INTERFUND PAYABLES OTHER PAYABLES OTHER LIABILITIES LONG-TERM LIABILITIES TOTAL LIABILITIES 18,950.00 5,362.88 0.00 274,082.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 56,931.71 0.00 1,500,000.00 53,425.10 1,855,799.78 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 18,950.00 5,362.88 0.00 3,491,350.69 $22,000,000 0.00 1,500,000.00 53,425.10 1,855,799.78 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,133,874.44 5,918,257.14 0.00 27,802,277.77 27,802,277.77 2,133,874.44 5,918,257.14 3,491,350.69 0.00 3,414,587.76 56,931.71 0.00 27,802,277.77 27,802,277.77 3,414,587.76 56,931.71 $21,500,000 FUND EQUITY: INVESTMENT IN FIXED ASSETS RETAINED EARNINGS CONTRIBUTED CAPITAL RESERVED FUND BALANCE UNRESERVED FUND BALANCE TOTAL FUND EQUITY Local Match 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 475,653,053.75 FUND EQUITY: INVESTMENT IN FIXED ASSETS RETAINED EARNINGS CONTRIBUTED CAPITAL RESERVED FUND BALANCE UNRESERVED FUND BALANCE TOTAL FUND EQUITY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 475,653,053.75 0.00 0.00 0.00 0.00 1,625,597.38 9,050,139.77 10,675,737.15 485,435.30 10,261,534.10 10,746,969.40 1,854,033.30 63,019,387.63 64,873,420.93 $21,000,000 1,625,597.38 9,050,139.77 485,435.30 10,261,534.10 10,746,969.40 19.2% * 1,854,033.30 63,019,387.63 64,873,420.93 4,500.26 4,500.26 473,307.36 473,307.36 4,500.26 4,500.26 473,307.36 473,307.36 475,653,053.75 10,675,737.15 475,653,053.75 TOTAL LIABILITIES & FUND EQUITY 16,593,994.29 14,161,557.16 4,500.26 64,873,420.93 0.00 530,239.07 503,455,331.52 16,593,994.29 TOTAL LIABILITIES & FUND EQUITY 14,161,557.16 4,500.26 64,873,420.93 0.00 530,239.07 503,455,331.52 $20,500,000 18.9% * $20,000,000 2012 2013 2014 21 * Percentage of total Foundation Revenues

  21. Financial Forecast: Fiscal Year 2014 (contd) USDE Federal Funding: FUND TYPES & ACCOUNT GROUPS Reduction(s) in 2014 Federal Funding for HCS EXHIBIT F-I-A ACCT GROUPS F/A & L/T DEBT -------------- GOVERNMENTAL SPECIAL REVENUE -------------- PROPRIETARY ENTERPRISE INTERNAL -------------- FIDUCIARY TRUST & AGENCY -------------- DEBT SERVICE -------------- CAPITAL PROJECTS -------------- DESCRIPTION GENERAL -------------- -------------------------------------- ASSETS & OTHER DEBITS: CASH & CASH EQUIVALENTS INVESTMENTS RECEIVABLES ALLOWANCE FOR DOUBTFUL ACCTS INTERFUND RECEIVABLES OTHER RECEIVABLES INVENTORIES OTHER ASSETS FIXED ASSETS ACCUMULATED DEPRECIATION OTHER DEBITS AMT AVAILABLE IN DEBT SVC AMT PROV FOR PMT OF L-T DEBT OTHER DEBITS TOTAL ASSETS & OTHER DEBITS 9,770,165.15 2,094.75 9,733,973.38 4,500.26 0.00 64,873,420.93 0.00 0.00 529,508.68 0.00 0.00 EXHIBIT F-I-A ACCT GROUPS F/A & L/T DEBT -------------- 0.00 0.00 0.00 FUND TYPES & ACCOUNT GROUPS $ 380,000 GOVERNMENTAL SPECIAL REVENUE -------------- PROPRIETARY ENTERPRISE INTERNAL -------------- FIDUCIARY TRUST & AGENCY -------------- DEBT SERVICE -------------- CAPITAL PROJECTS -------------- Title I, Part A DESCRIPTION GENERAL -------------- 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -------------------------------------- ASSETS & OTHER DEBITS: CASH & CASH EQUIVALENTS INVESTMENTS RECEIVABLES ALLOWANCE FOR DOUBTFUL ACCTS INTERFUND RECEIVABLES OTHER RECEIVABLES INVENTORIES OTHER ASSETS FIXED ASSETS ACCUMULATED DEPRECIATION OTHER DEBITS AMT AVAILABLE IN DEBT SVC AMT PROV FOR PMT OF L-T DEBT OTHER DEBITS TOTAL ASSETS & OTHER DEBITS 1,500,000.00 5,321,734.39 4,111,162.47 316,421.31 730.39 0.00 0.00 0.00 0.00 9,770,165.15 2,094.75 9,733,973.38 4,500.26 0.00 64,873,420.93 0.00 0.00 529,508.68 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 475,653,053.75 1,500,000.00 5,321,734.39 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Title I, Part D $ 127,000 4,111,162.47 316,421.31 730.39 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 27,802,277.77 475,653,053.75 0.00 0.00 16,593,994.29 14,161,557.16 4,500.26 64,873,420.93 530,239.07 503,455,331.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 27,802,277.77 LIABILITIES & FUND EQUITY: LIABILITIES: SALARIES & BENEFITS PAYABLE PAYROLL W/H & DED PAYABLE CLAIMS PAYABLE OTHER PAYABLES INTERFUND PAYABLES OTHER PAYABLES OTHER LIABILITIES LONG-TERM LIABILITIES TOTAL LIABILITIES Title I, School Improvement $ 350,000 0.00 16,593,994.29 14,161,557.16 4,500.26 64,873,420.93 530,239.07 503,455,331.52 274,082.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 56,931.71 LIABILITIES & FUND EQUITY: LIABILITIES: SALARIES & BENEFITS PAYABLE PAYROLL W/H & DED PAYABLE CLAIMS PAYABLE OTHER PAYABLES INTERFUND PAYABLES OTHER PAYABLES OTHER LIABILITIES LONG-TERM LIABILITIES TOTAL LIABILITIES 18,950.00 5,362.88 0.00 274,082.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 56,931.71 0.00 1,500,000.00 53,425.10 1,855,799.78 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 18,950.00 5,362.88 0.00 3,491,350.69 Title II, Part A $ 553,000 0.00 1,500,000.00 53,425.10 1,855,799.78 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,133,874.44 5,918,257.14 0.00 27,802,277.77 27,802,277.77 2,133,874.44 5,918,257.14 3,491,350.69 0.00 3,414,587.76 56,931.71 0.00 27,802,277.77 27,802,277.77 3,414,587.76 56,931.71 FUND EQUITY: INVESTMENT IN FIXED ASSETS RETAINED EARNINGS CONTRIBUTED CAPITAL RESERVED FUND BALANCE UNRESERVED FUND BALANCE TOTAL FUND EQUITY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 475,653,053.75 FUND EQUITY: INVESTMENT IN FIXED ASSETS RETAINED EARNINGS CONTRIBUTED CAPITAL RESERVED FUND BALANCE UNRESERVED FUND BALANCE TOTAL FUND EQUITY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 475,653,053.75 IDEA, Special Education $ 180,000 0.00 0.00 0.00 0.00 1,625,597.38 9,050,139.77 10,675,737.15 485,435.30 10,261,534.10 10,746,969.40 1,854,033.30 63,019,387.63 64,873,420.93 1,625,597.38 9,050,139.77 485,435.30 10,261,534.10 10,746,969.40 1,854,033.30 63,019,387.63 64,873,420.93 4,500.26 4,500.26 473,307.36 473,307.36 4,500.26 4,500.26 473,307.36 473,307.36 475,653,053.75 10,675,737.15 475,653,053.75 TOTAL LIABILITIES & FUND EQUITY 16,593,994.29 14,161,557.16 4,500.26 64,873,420.93 0.00 530,239.07 503,455,331.52 16,593,994.29 TOTAL LIABILITIES & FUND EQUITY $ 1,590,000 14,161,557.16 4,500.26 64,873,420.93 0.00 530,239.07 503,455,331.52 Total Reduction(s) 22

  22. Financial Forecast: Fiscal Year 2014 (contd) Huntsville City/Madison County Funding: FUND TYPES & ACCOUNT GROUPS Based on current projections, we anticipate sustaining a General Fund balance between 105% and 110% of the required balance through fiscal year 2015 (barring proration or unanticipated decline in the local economy). No solid projection beyond 2015 at this point. Requires that we exercise caution when considering new/future recurring expenditures not otherwise included in this budget. EXHIBIT F-I-A ACCT GROUPS F/A & L/T DEBT -------------- GOVERNMENTAL SPECIAL REVENUE -------------- PROPRIETARY ENTERPRISE INTERNAL -------------- FIDUCIARY TRUST & AGENCY -------------- DEBT SERVICE -------------- CAPITAL PROJECTS -------------- DESCRIPTION GENERAL -------------- -------------------------------------- ASSETS & OTHER DEBITS: CASH & CASH EQUIVALENTS INVESTMENTS RECEIVABLES ALLOWANCE FOR DOUBTFUL ACCTS INTERFUND RECEIVABLES OTHER RECEIVABLES INVENTORIES OTHER ASSETS FIXED ASSETS ACCUMULATED DEPRECIATION OTHER DEBITS AMT AVAILABLE IN DEBT SVC AMT PROV FOR PMT OF L-T DEBT OTHER DEBITS TOTAL ASSETS & OTHER DEBITS 9,770,165.15 2,094.75 9,733,973.38 4,500.26 0.00 64,873,420.93 0.00 0.00 529,508.68 0.00 0.00 EXHIBIT F-I-A ACCT GROUPS F/A & L/T DEBT -------------- 0.00 0.00 0.00 FUND TYPES & ACCOUNT GROUPS GOVERNMENTAL SPECIAL REVENUE -------------- PROPRIETARY ENTERPRISE INTERNAL -------------- FIDUCIARY TRUST & AGENCY -------------- DEBT SERVICE -------------- CAPITAL PROJECTS -------------- DESCRIPTION GENERAL -------------- 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -------------------------------------- ASSETS & OTHER DEBITS: CASH & CASH EQUIVALENTS INVESTMENTS RECEIVABLES ALLOWANCE FOR DOUBTFUL ACCTS INTERFUND RECEIVABLES OTHER RECEIVABLES INVENTORIES OTHER ASSETS FIXED ASSETS ACCUMULATED DEPRECIATION OTHER DEBITS AMT AVAILABLE IN DEBT SVC AMT PROV FOR PMT OF L-T DEBT OTHER DEBITS TOTAL ASSETS & OTHER DEBITS 1,500,000.00 5,321,734.39 4,111,162.47 316,421.31 730.39 0.00 0.00 0.00 0.00 9,770,165.15 2,094.75 9,733,973.38 4,500.26 0.00 64,873,420.93 0.00 0.00 529,508.68 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 475,653,053.75 1,500,000.00 5,321,734.39 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4,111,162.47 316,421.31 730.39 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 27,802,277.77 475,653,053.75 0.00 0.00 16,593,994.29 14,161,557.16 4,500.26 64,873,420.93 530,239.07 503,455,331.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 27,802,277.77 LIABILITIES & FUND EQUITY: LIABILITIES: SALARIES & BENEFITS PAYABLE PAYROLL W/H & DED PAYABLE CLAIMS PAYABLE OTHER PAYABLES INTERFUND PAYABLES OTHER PAYABLES OTHER LIABILITIES LONG-TERM LIABILITIES TOTAL LIABILITIES Anticipate that long term rates on municipal debt are likely to increase in the near term. Will recommend selling of final increment of debt to complete the capital plan this Fall. At current rates, HCS has sufficient capacity to service the cost of additional capital. 0.00 16,593,994.29 14,161,557.16 4,500.26 64,873,420.93 530,239.07 503,455,331.52 274,082.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 56,931.71 LIABILITIES & FUND EQUITY: LIABILITIES: SALARIES & BENEFITS PAYABLE PAYROLL W/H & DED PAYABLE CLAIMS PAYABLE OTHER PAYABLES INTERFUND PAYABLES OTHER PAYABLES OTHER LIABILITIES LONG-TERM LIABILITIES TOTAL LIABILITIES 18,950.00 5,362.88 0.00 274,082.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Regarding Capital Projects : 0.00 56,931.71 0.00 1,500,000.00 53,425.10 1,855,799.78 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 18,950.00 5,362.88 0.00 3,491,350.69 0.00 1,500,000.00 53,425.10 1,855,799.78 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,133,874.44 5,918,257.14 0.00 27,802,277.77 27,802,277.77 2,133,874.44 5,918,257.14 3,491,350.69 0.00 3,414,587.76 56,931.71 0.00 27,802,277.77 27,802,277.77 3,414,587.76 56,931.71 FUND EQUITY: INVESTMENT IN FIXED ASSETS RETAINED EARNINGS CONTRIBUTED CAPITAL RESERVED FUND BALANCE UNRESERVED FUND BALANCE TOTAL FUND EQUITY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 475,653,053.75 FUND EQUITY: INVESTMENT IN FIXED ASSETS RETAINED EARNINGS CONTRIBUTED CAPITAL RESERVED FUND BALANCE UNRESERVED FUND BALANCE TOTAL FUND EQUITY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 475,653,053.75 0.00 0.00 0.00 0.00 1,625,597.38 9,050,139.77 10,675,737.15 485,435.30 10,261,534.10 10,746,969.40 1,854,033.30 63,019,387.63 64,873,420.93 1,625,597.38 9,050,139.77 485,435.30 10,261,534.10 10,746,969.40 1,854,033.30 63,019,387.63 64,873,420.93 4,500.26 4,500.26 473,307.36 473,307.36 4,500.26 4,500.26 473,307.36 473,307.36 475,653,053.75 10,675,737.15 475,653,053.75 TOTAL LIABILITIES & FUND EQUITY 16,593,994.29 14,161,557.16 4,500.26 64,873,420.93 0.00 530,239.07 503,455,331.52 16,593,994.29 TOTAL LIABILITIES & FUND EQUITY 14,161,557.16 4,500.26 64,873,420.93 0.00 530,239.07 503,455,331.52 23

  23. EXHIBIT F-I-A ACCT GROUPS F/A & L/T DEBT -------------- FUND TYPES & ACCOUNT GROUPS GOVERNMENTAL SPECIAL REVENUE -------------- PROPRIETARY ENTERPRISE INTERNAL -------------- FIDUCIARY TRUST & AGENCY -------------- DEBT SERVICE -------------- CAPITAL PROJECTS -------------- DESCRIPTION GENERAL -------------- -------------------------------------- ASSETS & OTHER DEBITS: CASH & CASH EQUIVALENTS INVESTMENTS RECEIVABLES ALLOWANCE FOR DOUBTFUL ACCTS INTERFUND RECEIVABLES OTHER RECEIVABLES INVENTORIES OTHER ASSETS FIXED ASSETS ACCUMULATED DEPRECIATION OTHER DEBITS AMT AVAILABLE IN DEBT SVC AMT PROV FOR PMT OF L-T DEBT OTHER DEBITS TOTAL ASSETS & OTHER DEBITS 9,770,165.15 2,094.75 9,733,973.38 4,500.26 0.00 64,873,420.93 0.00 0.00 529,508.68 0.00 0.00 EXHIBIT F-I-A ACCT GROUPS F/A & L/T DEBT -------------- 0.00 0.00 0.00 FUND TYPES & ACCOUNT GROUPS GOVERNMENTAL SPECIAL REVENUE -------------- PROPRIETARY ENTERPRISE INTERNAL -------------- FIDUCIARY TRUST & AGENCY -------------- DEBT SERVICE -------------- CAPITAL PROJECTS -------------- DESCRIPTION GENERAL -------------- 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -------------------------------------- ASSETS & OTHER DEBITS: CASH & CASH EQUIVALENTS INVESTMENTS RECEIVABLES ALLOWANCE FOR DOUBTFUL ACCTS INTERFUND RECEIVABLES OTHER RECEIVABLES INVENTORIES OTHER ASSETS FIXED ASSETS ACCUMULATED DEPRECIATION OTHER DEBITS AMT AVAILABLE IN DEBT SVC AMT PROV FOR PMT OF L-T DEBT OTHER DEBITS TOTAL ASSETS & OTHER DEBITS 1,500,000.00 5,321,734.39 QUESTIONS 4,111,162.47 316,421.31 730.39 0.00 0.00 0.00 0.00 9,770,165.15 2,094.75 9,733,973.38 4,500.26 0.00 64,873,420.93 0.00 0.00 529,508.68 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 475,653,053.75 1,500,000.00 5,321,734.39 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4,111,162.47 316,421.31 730.39 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 27,802,277.77 475,653,053.75 0.00 0.00 16,593,994.29 14,161,557.16 4,500.26 64,873,420.93 530,239.07 503,455,331.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 27,802,277.77 LIABILITIES & FUND EQUITY: LIABILITIES: SALARIES & BENEFITS PAYABLE PAYROLL W/H & DED PAYABLE CLAIMS PAYABLE OTHER PAYABLES INTERFUND PAYABLES OTHER PAYABLES OTHER LIABILITIES LONG-TERM LIABILITIES TOTAL LIABILITIES 0.00 16,593,994.29 14,161,557.16 4,500.26 64,873,420.93 530,239.07 503,455,331.52 274,082.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 56,931.71 LIABILITIES & FUND EQUITY: LIABILITIES: SALARIES & BENEFITS PAYABLE PAYROLL W/H & DED PAYABLE CLAIMS PAYABLE OTHER PAYABLES INTERFUND PAYABLES OTHER PAYABLES OTHER LIABILITIES LONG-TERM LIABILITIES TOTAL LIABILITIES 18,950.00 5,362.88 0.00 274,082.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 56,931.71 0.00 1,500,000.00 53,425.10 1,855,799.78 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 18,950.00 5,362.88 0.00 3,491,350.69 0.00 1,500,000.00 53,425.10 1,855,799.78 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,133,874.44 5,918,257.14 0.00 27,802,277.77 27,802,277.77 2,133,874.44 5,918,257.14 3,491,350.69 0.00 3,414,587.76 56,931.71 0.00 27,802,277.77 27,802,277.77 3,414,587.76 56,931.71 FUND EQUITY: INVESTMENT IN FIXED ASSETS RETAINED EARNINGS CONTRIBUTED CAPITAL RESERVED FUND BALANCE UNRESERVED FUND BALANCE TOTAL FUND EQUITY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 475,653,053.75 FUND EQUITY: INVESTMENT IN FIXED ASSETS RETAINED EARNINGS CONTRIBUTED CAPITAL RESERVED FUND BALANCE UNRESERVED FUND BALANCE TOTAL FUND EQUITY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 475,653,053.75 0.00 0.00 0.00 0.00 1,625,597.38 9,050,139.77 10,675,737.15 485,435.30 10,261,534.10 10,746,969.40 1,854,033.30 63,019,387.63 64,873,420.93 1,625,597.38 9,050,139.77 485,435.30 10,261,534.10 10,746,969.40 1,854,033.30 63,019,387.63 64,873,420.93 4,500.26 4,500.26 473,307.36 473,307.36 4,500.26 4,500.26 473,307.36 473,307.36 475,653,053.75 10,675,737.15 475,653,053.75 TOTAL LIABILITIES & FUND EQUITY 16,593,994.29 14,161,557.16 4,500.26 64,873,420.93 0.00 530,239.07 503,455,331.52 16,593,994.29 TOTAL LIABILITIES & FUND EQUITY 14,161,557.16 4,500.26 64,873,420.93 0.00 530,239.07 503,455,331.52 24

  24. 25

More Related Content