Please help, due tommorow. I will rate well whoever can help!!!
As a manager of an event management company, you are required to complete a cash flow forecast using the template provided. Your cash flow forecast will estimate the amount of cash at the end of each month for each month of the year. This information will be used to make critical decisions on an on-going basis to make sure that positive cash flow is always maintained. The information to complete the task is as follows: - The event management company has secured four major events to run in 2022 which will take place in March, May, August, and October. - Tickets sales from these events will total $285,000 and will be received in the month each event is held. The receipts are as follows: March - $65,000, May $70,000, August $85,000, October $65,000. - Costs of casual salaries, travel and transport, and venue hire will occur only in the months in which the four events take place. These costs will be the same for each event. - Salaries and Office and administrative expenses will occur evenly every month. - The company's opening bank balance on January 1st is $5,000. - The company will receive a government grant of $50,000 in July. - The company will generate a small income from Merchandising during the months the four events are staged. The receipts will be as follows: March - \$1,300, May - $1,600, August $1,800, October $1,300. Complete the Cash Flow template attached and be prepared to discuss in class. Make a list of approaches, programs, etc. that can be instituted to address projected negative cash flow situations before they occur. Also, what can be done when a negative cash flow situation does occur? CASH FLOW FORECAST TEMPLATE As a manager of an event management company, you are required to complete a cash flow forecast using the template provided. Your cash flow forecast will estimate the amount of cash at the end of each month for each month of the year. This information will be used to make critical decisions on an on-going basis to make sure that positive cash flow is always maintained. The information to complete the task is as follows: - The event management company has secured four major events to run in 2022 which will take place in March, May, August, and October. - Tickets sales from these events will total $285,000 and will be received in the month each event is held. The receipts are as follows: March - $65,000, May $70,000, August $85,000, October $65,000. - Costs of casual salaries, travel and transport, and venue hire will occur only in the months in which the four events take place. These costs will be the same for each event. - Salaries and Office and administrative expenses will occur evenly every month. - The company's opening bank balance on January 1st is $5,000. - The company will receive a government grant of $50,000 in July. - The company will generate a small income from Merchandising during the months the four events are staged. The receipts will be as follows: March - \$1,300, May - $1,600, August $1,800, October $1,300. Complete the Cash Flow template attached and be prepared to discuss in class. Make a list of approaches, programs, etc. that can be instituted to address projected negative cash flow situations before they occur. Also, what can be done when a negative cash flow situation does occur? CASH FLOW FORECAST TEMPLATE
