Budgeting requires you to use the skills gained in Module/Week 2 to develop a pro forma budget for a university…

Budgeting requires you to use the skills gained in Module/Week 2 to develop a pro forma budget for a university athletic department. 

If you were to advise the UNL (from Chapter 19 of the Fried, DeSchriver, and Mondello textbook) athletic department on financial planning for the future, what information would you need and where would you obtain it? Using such information, develop your ideal pro forma budget for the athletic department based on your plan for the future. Be sure your proposals are consistent with the department’s mission, goals, and proposed goals and include in your proposal a recommendation to drop 1 men’s sport and add 1 women’s sport that is based strictly on a financial analysis.

Specifically, provide a pro forma budget in spreadsheet or table format and an approximately 500 word executive summary of the budget that provides a clear rationale for your proposals emphasizing how the proposals align with the department’s mission, goals and proposed goals. Formally cite at least 2 relevant, external sources (not including the course textbook) in your summary.