4. Financial Forecast & FeedbackAs the manager of A & R Entertainment, you are required to complete the cash flow forecast andprovide a feedback to the director. Your cash flow forecast will predict the bank balance at the end ofeach month for every month of the year. Use the information below to complete this task.a. A & R Entertainment has on its books four (4) major events to run, which will take place in March,May, August, and October.b. The total of $2,850,000.00 in ticket sales will be earned in the months that the events are held.The March event will earn $650,000.00, and the other events in May, August, and October, willearn $700,000, $850,000, and $650,000.00 respectively.c. Expenditure on casual salaries, travel and transport, and venue hire, will occur only in the monthsin which the four events take place. These expenditures will be the same for each event.d. Salaries and office and administration expenses will occur evenly every month.The company's opening bank balance on 1st January is $50,000.00.f. The company will receive a grant of $500,000.00 in July.g. The company will make a small income from merchandising during the months in which the fourevents are staged. The event in March will earn $13,000.00 in merchandising income, and theother events in May, August, and October will earn $16,000.00, $18,000.00, and $13,000.00respectively.● Additional information:e.ExpenditureSalariesCasual WagesOffice and Administrative ExpensesTravel & TransportVenue Hire$1,200,000.00100,000.00360,000.00560,000.00240,000.00You are required to:a. Generate the cash flow forecast for January to December 2017.b. Prepare a summarised report of the forecast for the year with a cover letter to the director of thecompany.

Cashflow forecast : Particluars Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Cash inflows…

Answered: Generate the cash flow forecast for…

Business

Accounting

Generate the cash flow forecast for January to December 2017.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Use the information supplied to prepare the following for Silver City Traders for the three months ending 31 March 2022. 1.1 Debtors collection schedule. 1.2 Cash budget statement.
Classify the following activities as primarily managerlal accounting or financlal accounting: a. Preparing a cash budget for the next quarter. b. Analyzing the profitability of a request from a potential customer. c. Accumulating the transactions for the previous six months to prepare an income statement. d. Preparing a weekly performance report for the branch manager. e. Preparing an announcement to be released to the financial analysts.
PLEASE USE MS WORD TO DO THE THREE PARTS. WITH THE LAST PART HAVING OCTOBER NOVEMBER DECEMBER AND A TOTAL COLUMN. The business needs to have a sense of its future cashflows and therefore requires the preparation of the following: A schedule of budgeted cash collections for trade receivables (sales on account) for each of the months October to December. A schedule of expected cash disbursements for accounts payable (purchases on account) for each of the months October to December. A cash budget, with a total column, for the quarter ending December 31, 2021, showing the expected cash receipts and payments for each month and the ending cash balance for each of the three months, given that no financing activities took place.
The business needs to have a sense of its future cashflows and therefore requires the preparation of the following: A schedule of expected cash disbursements for accounts payable for each of the months January to March.
crane company management wants to maintain a minimum monthly cash balance of $26,500. At the begining of April, the cash balance is $26,500, expected cash receipts for April are $259,700, and cash disbursements are expected to be $270,300. How much cash, if any, must be borrowed to maintain the desired minimum monthly balance? Amount to be borrowed to maintain the desired minimum monthly balance ?
Required: A) The business needs to have a sense of its future cash flows and therefore requires the preparation of the following: ▪ A cash budget, with a total column, for the quarter ending March 31, 2022, showing the expected cash receipts and payments for each month and the ending cash balance for each of the three months, given that no financing activities took place. B) Another team member who is preparing the Budgeted Balance Sheet for the business for the same quarter ending March 31, 2022 and has asked you to furnish him with the figures for the expected trade receivables and payables to be included in the statement. Is that a reasonable request? If yes, what should these amounts be? C) Upon receipt of the budget, the team manager, June Jackson, has now informed you that, in keeping with industry players, the management of Pelican Merchandising have indicated an industry requirement to maintain a minimum cash balance of $185,000 each month. She has also noted that management is…
(a) Prepare a schedule of expected cash collections for October, November and December and for the quarter in total. (b) Prepare a cash budget for the fourth quarter ended 31 December (show monthly columns and a total for the quarter). (c) The company is considering a dividend payout of $300,000 to shareholders. If the company needs to maintain a minimum cash balance of $100,000 for operating purposes, propose and explain the month for which dividend payment should be planned. please do not provide solution in image format thank you!
You are the Management Accountant of Cari’s shoe store and you are involved in the budgetary process, including operating and financial budgets, for the income year ending December 2020. One component of the financial budget is the cash budget. The opening cash balance on 1st January was expected to be $30000. The sales budgeted were as follows: Month $ November 80000 December 90000 January 75000 February 75000 March 80000 Analysis of records shows that debtors settle in the following pattern: 60%-------------Within the month of sale 25%-------------The month following 15%-------------The month following Extracts from the purchases budget were as follows: Month $ December 60000 January 55000 February 45000 March 55000 All purchases are on credit and past experience shows that 90% are settled in the month following purchase and the balance settled the month after. Wages are $15000 per month and overheads are $20000 per month (including $5000 depreciation) are settled monthly. Taxation…
a .Prepare an estimate of cash position for three months from April to June b. Based on the budget prepared, evaluate the cash position of the comupany, give your comments and provide suitable suggestion to the management on effective cash managenent.
The controller of Optimum wishes to improve the company's control system by preparing a monthly cash budget. The following information relates to the month ending July 31, 2021: June 30, 2021, cash balance Dividends were declared on June 15 Cash expenditures to be paid in July for operating expenses Depreciation expense Cash collections to be received Herchandise purchases to be paid in cash Equipment to be purchased for cash Optimun wishes to naintain a ninimum cash balance of $ 98,000 28, 000 75,600 9,800 182,000 114,400 42, 200 38,000 DIvidends are payable to shareholders of record on declaration date, 30 days after declaration. Required: 1. Prepare a cash budget for the month ending July 31, 2021, indicating how much, if anything, Optimum will need to borrow to meet its minimum cash requirement. (Leave no cells blank - enter "0" wherever required). ARROWROOT COMPANY Cash Budget for July 31, 2021 Total cash available before current financing Less disbursements Total disbursements
Student Exercise 2: Cash Flow Budget The purpose of this exercise is provide hands-on learning in how to create a Cash Flow Forecast that predicts the month-end bank balance for every month of the year. In this scenario, you are the manager in a pharmaceutical company ABC. You are required to complete a cash flow forecast using the template provided. Your cash flow forecast will predict the bank balance at the end of each month for every month of the year The information you have at your disposal to complete this task is as follows: 1. The pharmacy has on its books four (4) major marketing events to run which will take place in March, May, August, and October. 2. The total of $285,000 of product sales will be earned in the months that the events are held. The March event will ean $65,000, and the other events in May, August and October will earn $70,000, 85,000 and $65,000 respectively. 3. Expenditure on casual salaries, travel and transport, and venue hire will occur only in the…
Use the information given below to prepare the following for the first three months of operations (i.e. July,August and September 2023): (template provided)1. Debtors Collection Schedule 2. Cash Budget