Final Project Milestone Two: Budget Proposal Spreadsheet
Submit the proposed budget and rationale for your final project assignment.
please refer to the rubric and use the spread sheet as well
SPT 620 Milestone Two Guidelines and Rubric
Overview
In a sport management role, you may find yourself in a position where you will need to analyze financial data and make important decisions based on that information. Imagine that you are in such a position, and that you need to present to stakeholders and explain the impact of a proposed project from a financial perspective. Having a solid foundation in financial and economic concepts will help you communicate financial information and its impacts in a meaningful way.
For Milestone Two, you will submit a draft of the budget proposal spreadsheet portion of the final project. You must use the Final Project Budget Spreadsheet template . This assignment is due in Module Five.
Prompt
Specifically, the following critical elements must be addressed:
I. Executive Summary
C. Determine the sport organization’s financial health based on what you discovered, and support your response with information from the most recent balance sheet.
D. Estimate the costs that the sport organization will need to cover as a result of the proposed project, and explain how the estimate was reached.
E. Identify potential sources of revenue that the project will bring to the organization to fund the project, supported by specific examples.
F. Discuss economic impacts across departments for the additional costs incurred as a result of the proposed project.
Note: Part G of the executive summary portion of the final project will be due in Module Nine with the final submission.
What to Submit
Your milestone should be submitted using the provided Final Project Budget Spreadsheet template.
,
Sheet1
Budget | ||
Category | Millions ($) | |
Revenue | (Sum of Total Revenue) | |
Direct Costs | (Sum of Total Costs) | |
Gross Profit | ||
Game Expenses (schedule 1) | ||
Team Expenses (schedule 2) | ||
Administrative Expenses (Schedule 3) | ||
Debt Service (Schedule 4) | ||
Total Expenses: | ||
Operating Income: | (Gross Profit minus Total Expenses) | |
Sources of Revenue: | ||
Ticket Revenue | ||
Media Rights | ||
etc. | ||
etc. | ||
etc. | ||
Direct Costs: | ||
Advertising Costs | ||
Concessions | ||
Inventory | ||
etc. | ||
etc. | ||
Schedule 1: Game Expenses: | ||
Stadium Rent | ||
Utilities | ||
etc. | ||
etc. | ||
etc. | ||
Total Game Expenses: | ||
Schedule 2: Team Expenses: | ||
Transportation | ||
Lodging | ||
etc. | ||
etc. | ||
etc. | ||
Total Team Expenses: | ||
Schedule 3: Administrative Expenses: | ||
Payroll | ||
Dues and Fees | ||
etc. | ||
etc. | ||
etc. | ||
Total Admin. Expenses: | ||
Schedule 4: Debt Service: | ||
Interest | ||
Depreciation | ||
etc. | ||
etc. | ||
etc. | ||
Total Debt Service: |