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.

Entrepreneurial Finance

6th Edition

ISBN:9781337635653

Author:Leach

Publisher:Leach

Chapter6: Managing Cash Flow

Section: Chapter Questions

Problem 12SEP

See similar textbooks

Similar questions

a) Prepare a projected cash flow statement for the six months ending 30 November that shows the cash balance at the end of each month b) Compute the projected inventories levels at the end of each month for the six months to 30 November c) Prepare a projected income statement for the six months ending 30 November. d) What problems is Newtake Records Ltd likely to face in the next six months? Can you suggest how the business might deal with these problems
creat a balence sheet Assume all 12 months have 30 days to make the calculations easier. This is commonly done in the business world. a. Beginning cash balance on January 1, 20xx is projected to be $25,000. This money was raised through issuing common stock and should be recorded accordingly. b. All Sales are on account. Sales are as follows: January: $1,406,095; February: $1,645,258; and March: $1,884,420. c. Customers paid in cash each month as follows: Utilities bills are as follows: January, $478,072; February, $1,037,460; and March, $1,481,309. d. Direct material packets costing $145 each are purchased on the first day of January and payable immediately, $327,600. e. Direct material packets costing $144 each are purchased on account as follows: January (due in February), $251,641; February, $313,445; and March, $350,280. Direct materials are payable in the month after the purchase. f. Direct Labor (production employee wages) are paid as follows: January, $252,588;…
Please answer the D It is typical for Jane to plan, monitor, and assess her financial position using cash flows over a given period, typically a month. Jane has a savings account and her bank loans money at 6%per year while it offers short-term investment rates of 5%. Jane's cash flows during August were as follows: a. Determine Jane's total cash inflows and cash outflows. b. Determine the net cash flow for the month of August. c. If there is a shortage, what are a few options open to Jane? d. If there is a surplus, what would be a prudent strategy for her to follow? a. Jane's total cash inflows are $4840. (Round to the nearest dollar.) Jane's total cash outflows are $4700. (Round to the nearest dollar.) b. Jane's net cash flow for the month of August is $140 (Round to the nearest dollar. Remember that a positive number indicates a surplus and a negative number indicates a shortage.) c. If there is a shortage, what are a few options…
Required: The business needs to have a sense of its future cash flows and therefore requires the preparation of the following: a. A schedule of expected cash disbursements for accounts payable (purchases on account) for each of the months July to September.
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.
Explain and give example of the following Management Reports Procedures Activities: Six Week Cash Flow Report
Required: (a) The business needs to have a sense of its future cash flows 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 July to September. • A schedule of expected cash disbursements for accounts payable (purchases on account) for each of the months July to September
Effect of transactions on cash flows The financial year for Gamma Limited ends on 30 June 2019. Management has asked you what effect each of the following June transactions will have on net profit before tax, cash flow from operations, cash flow from investing and cash flow from financing for the year ended 30 June 2019: 1. Sent invoices for $40 000 to customers during June for work carried out in June; $19 000 of this had been collected by year-end. 2. Borrowed $300 000 from the bank on 10 June, with principal and interest repayable in six months. Accrued interest at 30 June is $2500. 3. Paid salaries for the month of $80 000, with $5000 in wages owing at year-end. 4. Received $30 000 deposit on a job that will be carried out in July 2019. 5. Paid accounts payable of $35 000 which was outstanding at 31 May 2019. 6. Sold old equipment for $20 000. The equipment originally cost $300 000 with accumulated depreciation at the time of sale of $250 000. 7. Purchased new equipment on 20 June…
Imagine you are the finance manager of Al Mohsin Company. The company management feels that the cash management of the company should be made more effective. The following information from the company’s records is available to you: Miscellaneous Month Sales Purchase Wages expenses February 40,000 20,000 7,000 1,000 March 55,000 14,000 8,000 3,000 April 60,000 28,000 9,000 2,000 May 74,000 30,000 9,000 2,000 June 90,000 32,000 8,800 3,500 Additional Information Al Mohsin LLC expects to have RO 8,000 cash balance at the beginning of April. Period of credit allowed by suppliers – 2 months 40% of the total sale is for cash. Half of the credit sale is collected in the next month of sale and the remaining half in the following month after that. Delay in payment of wages 1/4 month Delay in payment of expenses 1/2 month Income tax to be paid in the month of June RO 1,500. You are required to :…
Imagine you are the finance manager of Al Mohsin Company. The company management feels that the cash management of the company should be made more effective. The following information from the company’s records is available to you: Additional Information Miscellaneous Month Sales Purchase Wages expenses February 40,000 20,000 7,000 1,000 March 55,000 14,000 8,000 3,000 April 60,000 28,000 9,000 2,000 May 74,000 30,000 9,000 2,000 June 90,000 32,000 8,800 3,500 Al Mohsin LLC expects to have RO 8,000 cash balance at the beginning of April. Period of credit allowed by suppliers – 2 months 40% of the total sale is for cash. Half of the credit sale is collected in the next month of sale and the remaining half in the following month after that. Delay in payment of wages 1/4 month Delay in payment of expenses 1/2 month Income tax to be paid in the month of June RO 1,500. You are required to :…
5. You are trying to estimate the free cash flow to the firm for Wadhwa Inc. and are looking at its most recent financial filings: the annual report for the last fiscal year and its most recent quarterly report for the first three quarters of the current year. Estimate the free cash flow to the firm over the most recent twelve months.
Cash flow of accounts receivable. Myers and Associates, a famous law firm in California, bills its clients on the first of each month. Clients pay in the following fashion: 40% pay at the end of the first month, 30% pay at the end of the secondmonth, 20% pay at the end of the third month, 5% pay at the end of the fourth month, and 5% default on their bills. The company has hired a new accountant, who promises to increase the speed of payment by clients. The new collection times will be 60% at the end of the first month, 25% at the end of the second month, and 10% at the end of the third month. The uncollectible accounts will remain at 5%. What will be the new cash flow with this change for the first quarter of 2015 if the new system takes effect in January? Assume payments from the fourth quarter will stay on the old payment schedule. Fourth Quarter Actual Billings First Quarter Anticipated Billings Oct. Nov. Dec. Jan. Feb. Mar.…