Question
Bluewater Football Association- Ivey case Prepare a report to the executive members providing an analysis of whether or not to add a new varsity team.
Bluewater Football Association- Ivey case
Prepare a report to the executive members providing an analysis of whether or not to add a new varsity team. An excel template has been provided for the cash budget analysis (do not add/delete rows or columns within the given template area. Note not all cells within the template will have inputs required (for example, loan interest may not apply in all months)). Your report should include the following items:
a projected cash budget (base case) for a new varsity team for the 2013 seven month operating period (February to August). (excel worksheet base case)
A revised cash budget to reflect an increase in registration fees.
A revised cash budget to reflect the decision that the new varsity teams players must purchase their own equipment.
a revised cash budget to combine both of the options (increase registration fees and team players buying their own equipment).
| BUS2010 Bluewater Football Case | |||||||||
| Cash Budget | |||||||||
| February | March | April | May | June | July | August | Total | ||
| Inflows: | |||||||||
| Registration fees | |||||||||
| Fundraising | |||||||||
| Admission revenue | |||||||||
| Concession revenue | |||||||||
| Total inflows | |||||||||
| Outflow: | |||||||||
| Concession food costs | |||||||||
| Equipment | |||||||||
| Practice field maintenance | |||||||||
| OFC team registration | |||||||||
| Insurance | |||||||||
| Field rental | |||||||||
| Referees | |||||||||
| Busing | |||||||||
| Team food and water | |||||||||
| Player and coach apparel | |||||||||
| Loan interest | |||||||||
| Total outflows | |||||||||
| Net cash flow | |||||||||
| Opening balance | |||||||||
| Ending balance | |||||||||
| BUS2010 Bluewater Football Case | |||||||||
| Cash Budget | |||||||||
| February | March | April | May | June | July | August | Total | ||
| Inflows: | |||||||||
| Registration fees | |||||||||
| Fundraising | |||||||||
| Admission revenue | |||||||||
| Concession revenue | |||||||||
| Total inflows | |||||||||
| Outflow: | |||||||||
| Concession food costs | |||||||||
| Equipment | |||||||||
| Practice field maintenance | |||||||||
| OFC team registration | |||||||||
| Insurance | |||||||||
| Field rental | |||||||||
| Referees | |||||||||
| Busing | |||||||||
| Team food and water | |||||||||
| Player and coach apparel | |||||||||
| Loan interest | |||||||||
| Total outflows | |||||||||
| Net cash flow | |||||||||
| Opening balance | |||||||||
| Ending balance | |||||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Gleim CIA Review Part 2 Practice Of Internal Auditing
Authors: Irvin N. Gleim
2020 Edition
1618542648, 978-1618542649
