Download
financial highlights as of october 31 2018 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Financial Highlights as of October 31, 2018 PowerPoint Presentation
Download Presentation
Financial Highlights as of October 31, 2018

Financial Highlights as of October 31, 2018

487 Views Download Presentation
Download Presentation

Financial Highlights as of October 31, 2018

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Financial Highlights as of October 31, 2018

  2. HIGHLIGHTS of INTERIM FINANCIAL REPORT (unaudited) • October 31, 2018 • and • BUDGET AMENDMENT REPORT • for the November 14, 2018 Board Meeting • Click below for a 1 minute Briefing: • https://www.showme.com/sh/?h=8hx0YLI • Prepared by: Business Support Services Division

  3. Posted on our website at http://www.hcde-texas.org/default.aspx?name=013.BusinessHome Linked from State Comptroller’s website http://www.texastransparency.org/local/schools.php

  4. INTERIM FINANCIAL REPORT (unaudited) GENERAL FUND Balance Sheet as of October 31, 2018

  5. INTERIM FINANCIAL REPORT (unaudited)ASST. SUPERINTENDENT FOR BUSINESS SERVICES’ MESSAGEAs of October 31, 2018 The General Fund balance at 10/31/18 is $28,050,197 As year end adjustments are completed, a budget amendment will be submitted to the board for items assigned, restricted and committed that will roll forward into FY 2019. As of October 31, 2018 activity includes:

  6. INTERIM FINANCIAL REPORT (unaudited)As of October 31, 2018 Financial Ratios • Level One - Indicator of financial strength • Level Two - Indicator of efficient leverage • Level Three - Indicators of efficiency • Level Four - Indicator of revenue growth

  7. INTERIM FINANCIAL REPORT (unaudited)As of October 31, 2018Indicator of Financial Strength • Percent of Fund Balance to G/F Expenditures Ratio • What is the percent of rainy fund balance? (*)Unadjusted • Working Capital Ratio • What is the cash flow availability for the organization? Total Current Assets Less Total Current Liabilities • Unassigned Fund Balance $ 14,538,904 ------------------------------ ---------------- Total G/F Expenditures$ 6,723,986 Goal : > 30% of G/F Exp. Benchmark: 10% to 29% Danger: Under 10% $30,238,999 - $1,903,854 = $28,335,145 Goal : >$15,000,000 Benchmark : $10M to $15M Danger : Under < $10M 188% FY18 28M FY19 216% FY19 28M FY18 Details on Schedule 1 Details on Schedule 3 Budgeted $30M Budgeted 30%

  8. INTERIM FINANCIAL REPORT (unaudited)As of October 31, 2018Indicator of Efficient Leverage Reserves • Unassigned Fund Balance Ratio • How much is available in reserves? • Debt to Income Ratio • What is the ability of HCDE to cover its debt payments? Annual Principal and Interest Payments on Term Debt and Capital Leases $0 ____________________________________________________________________ • Unassigned Fund Balance $ 14,538,904 ------------------------------ ---------------- TotalFund Balance $ 28,335,145 Goal : > 75% Benchmark: 50% to 75% Danger: <50% G/F Revenue Less Facility Charges $4,029,730 – 900,263 Goal : <25% of annual revenue Benchmark : 25% to <49% Danger : Over > 50% 42% FY18 0% FY19 51% FY19 0% FY18 Details on Schedule 5 Details on Schedule 1 Budgeted 7% Budgeted 74%

  9. INTERIM FINANCIAL REPORT (unaudited)As of October 31, 2018Indicators of Efficiency • Tax Revenue to Total Revenue Ratio • How Efficient is HCDE at leveraging local • Taxes? (Current) • Indirect Cost to Tax Ratio • How much dependency on indirect cost from grants? • Indirect Cost General Fund $115,315 ------------------------------ ---------------- Total General Fund Revenue$ 4,029,730 Goal : > 5% Benchmark: 2% to 5% Danger: Under < 2% • Current Tax Revenue $246 ------------------------------ ---------------- Total Revenue$ 8,925,072 Goal : <20% of revenue Benchmark: 20% to 30% Danger: Over > 30% 0% FY18 3% FY19 0% FY19 1% FY18 Details on Schedule 3 Details on Schedule 2 Budgeted 3% Budgeted 23%

  10. INTERIM FINANCIAL REPORT (unaudited)As of October 31, 2018Indicators of revenue growth • Fee for Service Revenue Growth Ratio • What is the market growth for fee on services? • Fee for Service Revenue Ratio • How are revenues spread across All Funds? Fee for Services Current Year Less Fee for Services Last Year $4,913,035 – $5,345,482 Fees for Service Last Year $5,345,482 Total Fee for Service Revenues (G/F) $4,913,035 ------------------------------------- Total Revenues $8,938,461 Goal : >30% of annual revenue Benchmark: 10% to 29% Danger: Under 10% ----------------------------------------------------- Goal : >3% + growth Benchmark : 0% to 3% Danger : Under < 0% 55% FY18 -8% FY19 55% FY19 -8% FY18 Details on Schedule 14 Details on Schedule 14 Budgeted 21% Budgeted 2%

  11. FY 2018-19 FUND BALANCE – BUDGETED ACTIVITY

  12. INTERIM FINANCIAL REPORT (unaudited)GENERAL, SPECIAL REVENUE, DEBT SERVICE FUNDS, CAPITAL PROJECTS, AND INTERNAL SERVICE FUNDS REVENUES Budget to Actual at October 31, 2018 *Federal funding is the main source for special revenue grants. The $29,215,915 Federal Program Revenues includes $3,449,688 for Adult Education, $5,764,182 for CASE, $19,985,445 for Head Start, and $16,600 for various other divisions.

  13. ADOPTED BUDGETS AND AMENDMENTS 2018-2019

  14. INTERIM FINANCIAL REPORT (unaudited)GENERAL, SPECIAL REVENUE, DEBT SERVICE FUNDS, CAPITAL PROJECTS, AND INTERNAL SERVICE FUNDS EXPENDITURES Budget to Actual at October 31, 2018

  15. INTERIM FINANCIAL REPORT (unaudited) FY 2018-19 Donations Report All Funds as of October 31, 2018

  16. INTERIM FINANCIAL REPORT (unaudited) FY 2018-19 Donations Report All Funds as of October 31, 2018

  17. INTERIM FINANCIAL REPORT (unaudited) FY 2018-19 Donations Report Continued… All Funds as of October 31, 2018

  18. INTERIM FINANCIAL REPORT (unaudited) FY 2018-19 Donations Report Continued… All Funds as of October 31, 2018

  19. INTERIM FINANCIAL REPORT (unaudited) FY 2018-19 Donations Report Continued… All Funds as of October 31, 2018

  20. INTERIM FINANCIAL REPORT (unaudited) TAX COLLECTIONS COMPARATIVE ANALYSIS Fiscal Year –To-Date at October 31, 2018 See Tax Calculator at http://www.hcde-texas.org/default.aspx?name=TaxCalculator $451B

  21. INTERIM FINANCIAL REPORT (unaudited)TAX COLLECTIONS Fiscal Year-To-Date at October 31, 2018 (2nd month / 12 months)

  22. INTERIM FINANCIAL REPORT (unaudited) TAX COLLECTIONS Fiscal Year-To-Date at October 31, 2018 (2nd month / 12 month) a) 2018 Tax Rate = $0.005190/$100 Property Assessment/Appraisal - --> Annual Tax on a $200,000 - $40,000 = $160,000/100 x .005190 = Residential Property = $8.32 (net of 20% homestead exception.) b) $655,000/$23,475,040 = 2.78% Collection and assessment costs

  23. INTERIM FINANCIAL REPORT (unaudited)DISBURSEMENT – ALL FUNDS October 31, 2018 Notes: All Purchase Orders and Payment Authorizations are reviewed before disbursement. All Procurement Card charges are reviewed by cardholder, supervisor, and business office staff each month. A report on CH Local Expenditures is included in the monthly report.

  24. INTERIM FINANCIAL REPORT (unaudited) Segment Division Data As of October 31, 2018

  25. HIGHLIGHTS Of BUDGET AMENDMENT REPORT November 14, 2018 Board Meeting (unaudited) Amendments General Fund = $455,000 Special Revenue Fund= ($137,020)

  26. INTERIM FINANCIAL REPORT (unaudited) FY 2018-19 BUDGET AMENDMENT REPORT November 14, 2018 General Fund

  27. INTERIM FINANCIAL REPORT (unaudited) FY 2018-19 BUDGET AMENDMENT REPORT November 14, 2018 Special Revenue Fund

  28. INTERIM FINANCIAL REPORT (unaudited) FY 2018-19 BUDGET AMENDMENT REPORT November 14, 2018 Special Revenue Fund Continued…

  29. Construction PFC UpdateNovember 14, 2018

  30. Closing on 2016 PFC Bond Series $225,000 Budgeted Value…Opportunity…Service

  31. Available October 2018 PFC Bond Series Funds

  32. Availablefundsand arbitrage Add a footer

  33. Timeline pending review by the Development Plan Committee

  34. INTERIM FINANCIAL REPORT (unaudited) I certify that the foregoing information is true and accurate to the best of my knowledge. /s/ Jesus J. Amezcua, RTSBA,CPA, Ph.D., Asst. Supt. for Business Support Services /s/ Rosa Maria Torres, RTSBA, Chief Accounting Officer Value…Opportunity…Service