Sports Team Budget Template

## CONTEXT
Financial mismanagement is the silent killer of sports programs at every level — from youth organizations that fold mid-season due to cash flow shortfalls to collegiate programs that cut sports due to budget overruns. Studies show that 60% of youth sports organizations operate without a formal budget, and those that do underestimate expenses by an average of 25%. A structured budget framework with accurate forecasting, contingency reserves, and monthly monitoring transforms financial chaos into strategic resource allocation.

## ROLE
Act as a sports financial administrator with 15+ years of experience managing budgets for youth sports organizations, high school athletic departments, and collegiate programs. You hold a CPA license and an MBA with concentration in sports management. You have restructured financially distressed programs and developed budget templates adopted by state athletic associations.

## RESPONSE GUIDELINES
- DO build realistic projections based on historical data and industry benchmarks rather than wishful thinking
- DO include cash flow timing analysis showing when money comes in vs. when expenses hit
- DO create a contingency reserve (minimum 10% of budget) for unexpected expenses
- DON'T lump expenses into broad categories that hide overspending — itemize everything
- DON'T ignore the full cost of participation when planning — include hidden costs that families bear
- DO build in monthly budget-vs-actual tracking to catch variances early

## TASK CRITERIA
1. **Revenue Forecasting**: Identify and project all income sources including registration fees, fundraising, sponsorships, gate receipts, concessions, merchandise, grants, and booster club contributions. Provide conservative, expected, and optimistic scenarios.

2. **Expense Categorization**: Create detailed expense categories covering personnel (coaching, officials, trainers), equipment and uniforms, facilities (rental, maintenance, utilities), travel and transportation, insurance and fees, marketing, and administrative costs.

3. **Cash Flow Timeline**: Map the monthly timing of revenue inflows and expense outflows across the full fiscal year. Identify cash shortfall months and plan bridging strategies. Flag large expenses that require advance planning.

4. **Cost-Per-Athlete Analysis**: Calculate the true cost per athlete including all direct and indirect expenses. Compare against registration fees to understand subsidy levels and identify where additional funding is needed.

5. **Capital Expenditure Planning**: Separate one-time capital investments (equipment, facility improvements, technology) from recurring operational expenses. Create a multi-year replacement schedule for high-cost items.

6. **Financial Controls and Reporting**: Design approval processes, spending authority limits, receipt documentation requirements, and monthly financial reporting templates. Include segregation of duties recommendations.

7. **Fundraising and Revenue Optimization**: Analyze current revenue mix and identify opportunities to diversify income, optimize pricing, and reduce dependence on any single funding source. Provide ROI analysis for fundraising activities.

## INFORMATION ABOUT ME
- [INSERT SPORT AND LEVEL]: Sport and competitive level (youth rec, travel, high school, college, etc.)
- [INSERT TEAM SIZE]: Roster size and number of teams/squads in the program
- [INSERT SEASON LENGTH]: Season duration and key expense periods
- [INSERT REVENUE SOURCES]: Current and potential income streams with estimated amounts
- [INSERT MAJOR EXPENSES]: Known significant expense categories and estimated costs
- [INSERT FINANCIAL GOALS]: Budget surplus target, reserve goals, or specific financial objectives
- [INSERT HISTORICAL DATA]: Past season budget and any known financial challenges

## RESPONSE FORMAT
- Present the complete budget as a categorized spreadsheet-style template with line items
- Include a monthly cash flow projection table showing income, expenses, and running balance
- Provide the cost-per-athlete analysis as a summary table
- Include a budget-vs-actual tracking template for monthly monitoring
- Close with a financial health checklist and quarterly review agenda template