SmartHelping / Agency Planning / Excel
Sports Agency Financial Model
Forecast agency commissions from player contracts and endorsement deals across up to three athlete types. Adjust athlete growth, contract values and commission rates, then review financial statements, funding needs and investor returns.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the model in action
Follow the athlete assumptions through the agency forecast.
Watch the walkthrough to see the revenue setup, financial reports and funding logic. Open the screenshots below to preview the workbook.
Three athlete configurations
Build revenue from athlete counts, contract values and commissions.
Configure up to three athlete types with separate assumptions for their playing careers and endorsement deals.
Start month and initial roster
Set the start month and starting athlete count for each configuration.
Monthly athlete additions
Enter the number of athletes added per month. Decimal inputs are supported, and the model reports year-ending athlete counts.
Playing-contract value
Define the average annual athlete contract value and adjust it over time.
Playing-contract commissions
Set the agency’s average commission earned on player contracts. Adjustments over time apply to all existing contracts.
Endorsement-deal value
Define the average annual value of athlete endorsement deals and adjust that value over time.
Endorsement commissions
Set a separate average commission assumption for endorsement income, with adjustments over time.
How earnings develop over a career
Give player contracts and endorsements different earnings paths.
Use separate schedules to define how the starting values change over an athlete’s career.
120-month schedules
On the Validation tab, define the percentage earned from the base value over 120 months, with different schedules for playing-career and endorsement-career earnings.
Different athlete strategies
Compare a smaller roster with higher average contract values, a larger roster with lower average values, or a mix across the three athlete configurations.
Commission and cash flow effects
Change contract values, endorsement assumptions and commission rates to review the effect on agency revenue, cash requirements and returns.
Startup costs, financing and ownership
Connect the operating plan to the capital it requires.
Model startup spending, financing and the ownership structure alongside the agency’s revenue assumptions.
Startup and asset spending
Use schedules for one-time startup costs and depreciable capital asset purchases.
Income and capital gains taxes
Include the model’s income-tax and capital-gains-tax assumptions in the financial forecast.
Optional debt funding
Fund initial startup costs and operating burn with a regular principal-and-interest loan.
Minimum equity requirement
By default, the model solves for the minimum equity investment needed after debt funding so forecast balance-sheet cash does not fall below zero.
Cap table and owner funding
Use the detailed cap table for investor participation. For an owner-funded case, the cap table can be zeroed out except for the “overflow” row in the top section.
Optional terminal value
Use the yes/no selector to include a terminal value in the DCF analysis. When enabled, the model assumes the debt is fully repaid in the exit month.
Dynamic financial reports
Review the operating forecast, cash requirements and returns.
The model brings the revenue and funding assumptions into monthly and annual reporting.
Three financial statements
Review the income statement, balance sheet and cash flow statement on monthly and annual bases.
Detailed pro forma
Work through monthly and annual pro forma detail behind the financial summaries.
Annual executive summary
Use the annual executive summary to review the agency’s financial outlook.
DCF analysis
Review discounted cash flow at the project level and for inside and outside investors when applicable.
Investment-return metrics
Evaluate IRR, NPV, ROI and equity multiple under the assumptions you enter.
Visualizations
Use the model’s visualizations to review and communicate the financial forecast.
How to use the model
Start with the roster you expect to represent.
Configure the athlete types
Set each type’s start month, starting athlete count and monthly athlete additions.
Build the two revenue streams
Enter player-contract and endorsement values, their commission assumptions, and the separate career earnings schedules on the Validation tab.
Add costs and financing
Configure operating and startup spending, capital assets, tax assumptions, debt funding, cap table participation and the optional terminal value.
Review and compare the plan
Check the financial statements, minimum equity requirement, pro forma, annual summary and investment returns. Change assumptions to compare another agency strategy.
Who this model is for
For sports agencies and similar representation businesses.
Sports agency founders and owners
Plan the economics of starting or running an agency, from athlete acquisition and commission revenue to capital requirements.
Talent and other representation agencies
Adapt the two revenue streams to businesses with playing or acting career income and endorsement deals.
Also available in these bundles
Need more business and financial-analysis templates?
This model is included in the Industry-Specific Financial Model Bundle and the Super Smart Bundle.
Industry-Specific Financial Models
Explore operating forecasts built around the revenue drivers, costs and funding needs of different businesses.
View the Industry-Specific bundleSuper Smart Bundle
Access the complete public SmartHelping template collection across industries and financial-analysis needs.
View the Super Smart BundleComplementary tools and reading
Explore valuation, forecasting and ownership resources.
Small Business Valuation Tool
Explore a separate template for comparing small-business valuation methods.
Explore the templateReal Estate IRR Sensitivity
Explore a separate real estate template for testing how investment assumptions affect IRR.
Explore the templateRolling Revenue Forecast
Explore a separate rolling-revenue forecasting tool for SaaS businesses.
Explore the templateFinancial Statement Generator
Explore a separate Excel accounting template for preparing financial statements.
Explore the templateGeneral Rental Business Model
Explore an operating model for a business that earns revenue from renting assets.
Explore the templateJoint Venture & Waterfall Models
Browse additional models for partner cash flows, preferred returns and distribution waterfalls.
Explore the collectionEquity Ownership Considerations
Read the discussion of considerations when giving up equity in a business.
Read the articleQuestions before you buy
A few useful details.
How many athlete types can I configure?
The model supports up to three athlete configurations, each with its own starting count, additions, contract values and commission assumptions.
Can monthly athlete additions be a decimal?
Yes. The monthly athlete-addition input accepts decimals, and the model reports year-ending athlete counts.
Are player contracts and endorsements modeled separately?
Yes. They have separate annual-value and commission assumptions, plus separate percentage-of-base earnings schedules over 120 months on the Validation tab.
Does the model include three financial statements?
Yes. It includes monthly and annual income statements, balance sheets and cash flow statements, as well as pro forma detail, an annual executive summary, DCF analysis, return metrics and visualizations.
Can I fund the agency entirely as the owner?
Yes. For owner-provided equity, the detailed cap table can be zeroed out except for the “overflow” row in its top section. The default funding logic calculates the minimum equity needed after any debt funding.
What happens to the debt if I include an exit?
When the terminal-value option is enabled, the model assumes the debt is fully repaid in the selected exit month.
Can the model work for an acting or talent agency?
Yes. It can be adapted to a similar representation business with two main income streams: playing or acting career income and endorsements.
Build the financial plan behind the agency
Connect the athlete roster to revenue, funding and returns.
Get the Sports Agency Financial Model for $45 and plan around player contracts, endorsements and the cost of growing the agency.
