Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 companys opening bank balance on January 1stis $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.

image text in transcribed

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 Beginning Cash Balance February 5,000 5,000 5,000 April May duly Auzust September October Navember December TOTAL income Ticket Sales Merchandising Total Income Expenses Salarics Casual Wages Office and Administrative Travel and Transport Total Expenses Ending Cash Balance

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Catechism Of Money

Authors: Joseph P. Root

1st Edition

1377114929, 978-1377114927

More Books

Students also viewed these Finance questions