Create a P&L budget for a fictional NCAA football team usin...

  1. Home
  2. Homework Library
  3. Business
  4. Accounting
  5. Create a P&L budget for a fictional NCAA football team usin...

QuestionQuestion

Create a P&L budget for a fictional NCAA football team using the data points in attachment.
1.Assume Auxiliary Income is only concession revenue and the team gets 100% of the per caps.
-Assume 1M people attend games this season.
-Assume the university sports program operates at a 10% margin.
-Assume the division 1-A revenue and expense breakdowns are representative of the football program (the percent mix noted on page 115 is percent of revenue and percent of expense where noted as percent of income)

2.What if the team had a bad season and fired all the coaches.
-Assume salaries and benefits doubled and recruiting doubled.
-Assume home gate receipts and cash gifts dropped by 30%
-Create a new forecast for the year.

3.Is the university sports program still profitable, why?
Write up 2 ideas to improve the forecast.

Solution PreviewSolution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

Fictional NCAA Football Team
P&L Budget
REVENUES USD USD
Home gate receipts $26,927,143
Cash gifts        11,938,571
Radio and television        10,980,000
Postseason compensation          6,187,143
Auxiliary income          6,100,000
Institutional support          6,100,000
Student fees          5,751,429
Away-game guarantees          5,054,286
Other income          4,967,143
Investment income          1,742,857
State aid          1,307,143
**Error margin (0.1%)              87,143
Gross Revenue $87,142,857
EXPENSES
Salaries and benefits        22,665,857
Grants-in-aid        12,940,714
Other expenses          7,215,429
Operations and maintenance          5,097,857
Team travel          5,019,429
Opponents' payments          4,784,143 ...

By purchasing this solution you'll be able to access the following files:
Solution.docx and Solution.xlsx.

$30.00
for this solution

or FREE if you
register a new account!

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

Find A Tutor

View available Accounting Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.

Decision:
Upload a file
Continue without uploading

SUBMIT YOUR HOMEWORK
We couldn't find that subject.
Please select the best match from the list below.

We'll send you an email right away. If it's not in your inbox, check your spam folder.

  • 1
  • 2
  • 3
Live Chats