Answered step by step
Verified Expert Solution
Question
1 Approved Answer
with explaniation please The purpose of this exercise is provide hands on caming n how to create a Cash Flow Forecast that predicts the month
with explaniation please
The purpose of this exercise is provide hands on caming n how to create a Cash Flow Forecast that predicts the month ond bank balance for every month of the your In this scenario, you are the manager in a pharmaceutical company ABC Youred to complete a cash flow forecast using the toplote provided Your cash bow forecast will predict the bank balance at the end of onch month for every month of the your The information you have at your disposal to complete this tasks as to 1. The pharmacy has on its books four (4) major marketing events for which will take place in March, Moy. August, and Odober 2 The total of $285.000 of producties will become the months that the events are nod The Morch event will com $65,000, and the other events in tay. And October wil om $70,000, 85.000 and $65,000 respectively 3 Expenditure on casual salaries, travel and transport, and while on the months in which the four events take place these expendium event 4. Salones and Office and administration expenses will occurvy veryone 5. The company's opening bank balance on 1 January is 35.000 6 The company will receive a government grant of $50.000 7. The company will make a small income from Marchandising dung the month which the four events are staged The event in Morch will earn $1.300 merchandising income, and the other events in May Apuest and October we can $1,600, 51,300 and $1300 rospectively You are provided with a template below to assist you to come Soroch Feb Mar A DER De Cash Flow Budgeting Exercise Total Opening come Locuri 785000 Merch 000 Govern 0.00 1000 120.000 100 30.000 BE CARLIN W203 Om Am Expenses vonport Avenue Hire OOO 24.000 Tot 290.000 100120 Closing 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