Building a resilient multi-year budget model for Texas public universities
A multi-year budget model gives university leaders a forward-looking view of financial capacity, operating risk, and strategic choices. Unlike an annual budget, it connects current decisions with the effects they may have over three, five, or more years. For Texas public universities, that longer view is especially important because state appropriations, enrollment trends, tuition revenue, employee costs, capital commitments, and legislative priorities can shift on different timelines.
The strongest models are practical management tools rather than complicated spreadsheets created for a single budget cycle. They help senior business officers test assumptions, compare scenarios, communicate tradeoffs, and identify potential gaps before those gaps become urgent. A well-designed model can also connect financial planning to academic priorities, facilities needs, technology investments, and institutional strategy.
Texas institutions operate within a distinctive public higher education environment. Biennial state funding, formula allocations, tuition and fee authority, designated tuition, restricted grants, auxiliary operations, and debt obligations all require careful treatment. The model should reflect these realities while remaining clear enough for cabinet leaders, governing boards, and budget managers to use.
Start with a clear planning purpose
Before selecting formulas or building worksheets, define what the model must help the institution decide. A model intended to support a legislative appropriation request will have different requirements from one designed for enrollment planning, a facilities program, or a system-level consolidation analysis. Establishing the purpose prevents the workbook from becoming an oversized collection of disconnected forecasts.
A useful planning horizon often includes a current-year estimate, the next budget year, and at least three additional out-years. Some institutions may need a longer horizon for major capital projects, pension-related obligations, research infrastructure, or long-term debt. The model should distinguish between the adopted budget, the latest forecast, and the planning case so users understand which figures are official and which are estimates.
Define ownership at the beginning. The budget office may maintain the core model, while finance, institutional research, human resources, facilities, procurement, and information technology provide inputs. Each major assumption should have an owner, a source, a refresh schedule, and a documented rationale. This accountability makes the forecast easier to defend and update.
Map the university’s revenue structure
Revenue forecasting begins with a detailed inventory of recurring and nonrecurring sources. Common categories include state appropriations, tuition and designated tuition, mandatory and course-related fees, grants and contracts, auxiliary enterprises, gifts, investment income, indirect cost recovery, and transfers. Separating restricted revenue from flexible operating resources is essential because a large increase in total revenue may have little effect on the funds available for core priorities.
Enrollment is often the most influential operating assumption. Build separate drivers for headcount, full-time equivalent enrollment, credit hours, residency mix, academic level, retention, completion, and modality where these variables affect revenue or funding. A single enrollment growth percentage can hide meaningful changes in student composition. For example, an increase in online or graduate enrollment may produce a different financial result from equivalent growth in resident undergraduate students.
Texas public universities should model state support with care. Appropriations may be affected by legislative actions, formula funding outcomes, performance measures, designated programs, and exceptional items. Since the state budget operates on a biennial cycle, the forecast should include a clear baseline for the current appropriation, a planning assumption for the next cycle, and alternative cases for changes in state support.
Build expenditure drivers from operational reality
Personnel expenses usually represent the largest recurring cost category, so the model should forecast them by employee group or major organizational unit. Salary increases, merit pools, faculty hiring plans, turnover, vacancies, benefits, compression adjustments, and position reclassifications may each require different assumptions. A blanket payroll inflation rate is easy to apply but often fails to capture the actual impact of staffing decisions.
Nonpersonnel costs need their own drivers. Utilities, insurance, contracted services, software licenses, maintenance, travel, supplies, and compliance requirements can follow different inflation patterns. Technology agreements may rise through contractual escalators, while energy costs may depend on consumption and market conditions. Linking expenses to operational measures produces a more credible forecast than applying one percentage to every department.
Capital and debt obligations should be integrated into the operating outlook. A new building can create debt service, maintenance, custodial, security, utility, and staffing costs long after construction begins. Similarly, deferred maintenance may appear inexpensive in the short term while increasing future renewal requirements. Model projects by phase, funding source, expected completion date, and recurring operating impact.
Connect assumptions through a transparent model
A reliable model separates inputs, calculations, outputs, and documentation. Input cells should be easy to identify, while formulas should be consistent and traceable. Avoid hard-coding figures inside complex formulas when a labeled assumption can be referenced instead. This approach makes scenario testing faster and reduces the risk of an unnoticed change.
Use a driver-based structure wherever possible. Tuition revenue might be calculated from enrollment, credit hours, rates, waivers, and collection assumptions. Compensation could be tied to position counts, salary bases, vacancy rates, and benefit percentages. Facilities costs might use square footage, utility rates, and project completion dates. These relationships make the model more useful for decision-making because leaders can see what causes a result.
Include a bridge between the current forecast and each future year. The bridge should explain changes caused by enrollment, state funding, compensation, inflation, new initiatives, debt service, and one-time items. A year-over-year change that cannot be explained is a warning sign. Documentation should also identify whether a figure is based on a confirmed commitment, management judgment, historical trend, or external forecast.
| Model component | Core drivers | Key review question |
|---|---|---|
| Tuition and fee revenue | Enrollment, credit hours, rates, waivers, collection rate | How sensitive is revenue to enrollment and pricing changes? |
| State support | Appropriations, formula outcomes, legislative assumptions | Which funding sources are recurring and which are uncertain? |
| Personnel | Positions, vacancies, salary actions, benefits | Can planned staffing be sustained across the horizon? |
| Operating expenses | Inflation, contracts, utilities, activity levels | Which costs are fixed, variable, or highly volatile? |
| Capital and debt | Project timing, financing, debt service, maintenance | What recurring costs begin when a project is completed? |
| Reserves and liquidity | Minimum balances, one-time funds, cash flow | Can the institution absorb a downside scenario? |
Use scenarios to expose financial risk
A single forecast creates false confidence. At minimum, create a base case, a favorable case, and a downside case. The scenarios should change meaningful drivers rather than simply apply arbitrary percentage adjustments. Examples include lower enrollment, slower retention improvement, reduced state support, higher salary growth, delayed capital funding, weaker auxiliary performance, or unexpected compliance costs.
Sensitivity analysis can show which assumptions deserve the most management attention. If a small change in resident enrollment produces a large operating gap, enrollment planning and recruitment metrics should receive close monitoring. If compensation growth is the dominant risk, the institution may need position controls, phased hiring, or a more deliberate compensation strategy. Scenario outputs should show effects on recurring balance, unrestricted reserves, cash flow, and fund-level results.
Set trigger points connected to action. A reserve ratio below a defined threshold, an enrollment variance beyond a specified range, or a projected structural deficit may require a budget review. Scenario planning becomes valuable when it tells leaders what they will do, when they will do it, and which indicators will prompt a response.
Create governance around the forecast
A model is only as dependable as the process surrounding it. Establish a calendar for monthly or quarterly updates, with formal refreshes before tuition-setting decisions, legislative sessions, board presentations, and annual budget development. Maintain version control so users can distinguish the approved forecast from working scenarios.
A cross-functional review group can improve both accuracy and institutional understanding. Representatives from finance, institutional research, human resources, facilities, academic affairs, student services, and information technology can challenge assumptions from their areas of expertise. Professional communities also provide useful perspective: peer networking benefits can help business officers compare forecasting practices and learn how other institutions approach shared pressures.
Governance should include model controls. Protect formulas, limit editing access, validate imported data, and retain a change log. Reconcile forecast totals to the general ledger, official enrollment reports, payroll records, and approved capital plans. A clear audit trail builds confidence when results are presented to executive leadership or a governing board.
Turn projections into decisions
The model should end with decision-ready outputs rather than a long list of figures. Useful dashboards may include recurring revenue and expenditure, structural balance, unrestricted reserves, cash flow, personnel growth, enrollment trends, debt service, and capital commitments. Show results by fund or operating category where aggregation would conceal risk.
Translate financial results into strategic choices. If the base case shows limited capacity, leaders may need to sequence initiatives, revise hiring plans, improve space utilization, adjust service delivery, or identify sustainable revenue opportunities. A forecast should make those choices visible while preserving the institution’s academic and public-service priorities.
Practices that strengthen the planning cycle
- Use a documented assumption register with owners, sources, dates, and confidence levels.
- Separate recurring resources from one-time funding and temporary savings.
- Test enrollment, state support, compensation, inflation, and capital timing independently.
- Reconcile model outputs to audited, budgeted, and operational data before each formal review.
- Present scenario results with clear management actions and trigger dates.
A multi-year budget model becomes most valuable when it is updated as part of normal institutional management. It should inform position decisions, tuition discussions, capital planning, strategic initiatives, and risk reviews throughout the year—not sit unused until the next budget cycle. For Texas public universities, disciplined forecasting creates a common language for navigating state funding uncertainty, enrollment change, rising costs, and long-term commitments.
Build the model around transparent assumptions, test it against credible scenarios, and connect every major result to an accountable decision. By making the forecast understandable and actionable, senior business officers can strengthen financial stewardship while giving university leaders a clearer path toward sustainable growth.