Part C

Rename the third sheet "P&L and complete the following:

The financial performance of Moorabbin Baseball Club for 2021 appears in the Profit and Loss (Surplus and Deficit) Statement below.

Recreate on excel using formulae where possible.

Moorabbin Baseball Club
	2021
Profit & Loss Statement for the year ended 31st December 2021	$
Income
Virtual Events	37000
Senior weekend and midweek competition	29000
Sponsorship	10000
Interest income	800
Total Income
Expenses
Administration	33000
Finance and accounting	12500
Function expenses	1500
Senior weekend and midweek competition	25200
Marketing and advertising	2000
Umpires	6200
Sponsorship marketing costs	1500
Umpire development courses	2000
External Consulting	2000
Uniforms	4500
Equipment	3300
Stadium maintenance	4800
Total Expenses
Operating Surplus/Deficit

Reviewing the Profit and Loss statement for 2021 above, answer the following questions:

1. What is the total dollar amount of surplus or deficit made up by sponsorships?
2. The club manager wants to grow virtual events income by at least 10% in 2022. Give an idea of how virtual events income could grow by 10%.
3. After reviewing the expense items and values, identify and explain how two items could be reduced by at least 10%.
4. What is the surplus or deficit in dollars for the senior competition?