Spreadsheet: 375fffee-b62c-44ad-a48a-08fd98856c46
Sheet: Estimate

Texas Higher Education Coordinating Board - General Academic Institution - Program Funding Estimation Tool
Instructions
Insert the credit hours projected to be taken for all students per semester into the appropriate field. Select the discipline and level from the drop-down menus. The spreadsheet will estimate the total amounts.
Assumptions
1. Calculations are based on hours taken, not Full-Time Student Equivalent (FTSE) or headcount. This model accounts for credit hours taken at different academic levels, across various disciplines, and at different loads during the fall, spring, and summer semesters. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Undergraduate Lower Level
2. Hours used to calculate formula funding are based on the summer and fall of even numbered years and the spring of odd numbered years. For example, summer and fall 2010 and spring 2011 (Base Year 2011) are used to allocated funds for both fiscal years 2012 and 2013 (September 1, 2011 through August 31, 2013). |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Undergraduate Upper Level
3. The program's formula funding forecast will include hours from the various disciplines that a student must take to complete the degree, not just hours from the named discipline of the program. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Masters
4. The level of the hours funded is the level of the course or the student's enrollment classification, whichever is lowest. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spring | Doctorate
5. The program's new cost to the state is the funding rate reduced by the institution's estimated statutory tuition. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summer | Special Professional
6. Funding is not generated for the first two years the program generates semester credit hours. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fall
7. The funding rate is held constant into future years.
8. This model's information and assumptions are subject to change, and the estimates are not a guarantee of funding.
Designated Tuition Rate | 0
Statutory Tuition Rate | 50
All Funds Rate  (FY 10-11) | 53.71
Five-Year Total
Total Student-Based Funding
Student Fees (TEC, Chapters 51, 54, and 55)
Board Authorized Tuition
Designated Tuition
General Revenue Estimate (State's Portion) |  |  | 0
Statutory Tuition Estimate (Student's Portion)
Note: The table above converts the table below from calendar year to fiscal year. The general revenue presented above represents the estimated allocated portion based on the "Base Year." See assumption 2.
Starting (Calendar) Year | 2011
Starting Semester | Spring |  |  |  | Fall |  | Spring | Summer | Fall |  |  | Spring | Summer | Fall |  |  | Spring | Summer | Fall |  | Spring | Summer | Fall
Total Student Based Funding
Student Fees |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
Board-Authorized Tuition |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
Designated Tuition (TEC, Section 54.0513)
[NAME]
General Revenue Estimate (State's Portion)
Statutory Tuition Estimate (Student's Portion) (TEC, Section 54.051)
Full-Time Student Equivalents
Semester Credit Hours
Course List: Discipline | Level
Liberal Arts | Doctorate
Estimated Formula Funding: Discipline | Level