How is the closing bank balance calculated in a cash flow forecast?

The closing balance equals the opening balance plus the net cash flow for the month. Each month's closing balance becomes the next month's opening balance.

A Newry law firm expects receipts of £48,000 and payments of £53,500 in March, with an opening balance of £3,200. What is its closing balance?

The closing balance is an overdraft of £2,300. The working is £48,000 − £53,500 = −£5,500, then £3,200 − £5,500 = −£2,300.

A consultancy opens January with £6,000 in the bank. Its net cash flows are −£2,500 in January, −£4,700 in February and +£3,900 in March. What is the closing balance each month?

The closing balances are £3,500 in January, −£1,200 in February and £2,700 in March. The working is £6,000 − £2,500 = £3,500, then £3,500 − £4,700 = −£1,200, then −£1,200 + £3,900 = £2,700.

CCEA A-Level Professional Business Services 3210

The Business Environment

Topic overview Primary, secondary, tertiary and quaternary production Private, public and voluntary sector objectives Sole traders and partnerships Private and public limited companies Stakeholder interests and conflicts Factors of production

The Professional Business Services Sector

Topic overview The nature of professional business services The range of consultancy services Tangible goods and intangible services Local, national and global firms Why businesses use consultancy services

The Consultancy Process

Topic overview The consultancy process and the entry phase The diagnosis phase The action planning phase Implementation and termination phases

Understanding the Client's Market

Topic overview Market size, market share and market growth Reasons for market research and using its findings Primary market research methods Secondary market research and choosing a method Sampling methods in market research Market segmentation

Client Relationships

Topic overview Why client relationships matter Communication, personal contact and client needs Business culture and professionalism Trust, ethical behaviour, intellect and ideas

Business Ethics

Topic overview Fairness, integrity and freedom from bias Trust, confidentiality, transparency and openness The benefits of an ethical code

Persuading, Negotiating and Influencing

Topic overview Persuasion techniques for consultants Negotiation stages and strategies Influencing clients and stakeholders

Business Planning and Risk Management

Topic overview Strategic planning and cost–benefit analysis SWOT and PESTEL analysis in strategic planning The Ansoff matrix and the Boston matrix Assessing and managing business risk

Government Regulation

Topic overview The purpose of business regulation Regulators and compliance in Northern Ireland Codes of conduct versus external regulation

Organisational Structure and Culture

Topic overview Human resources and effective HR management Tall, flat, centralised and decentralised structures Roles, chain of command, span of control and delayering Changing and comparing organisational structures Culture, Schein's model and the McKinsey 7S framework

Recruitment and Selection

Topic overview Internal and external recruitment methods Job descriptions and person specifications Interviews and psychometric testing Competency profiling, situational judgement tests and EI questionnaires Contracts of employment and effective recruitment

Learning and Development

Topic overview Why learning and development matters to a business Induction, on-the-job, off-the-job training and CPD Outcomes of learning and development

Employee Well-Being and Motivation

Topic overview What employee well-being is and why employers value it Methods of supporting employee well-being Causes of low workplace well-being Maslow and Taylor on motivation Herzberg and Mayo on motivation Financial and non-financial methods of motivation

Managing Conflict

Topic overview Functional and dysfunctional conflict Causes of conflict at work Effects of conflict on performance, motivation and behaviour Improving employer–employee relations

Business Research Methods

Topic overview Research aims, objectives and literature searches Questionnaires, interviews and designing research tools Sampling, reliability, validity and research ethics Presenting, analysing and evaluating research findings

Sources of Finance

Topic overview Financial decision making in a client business Internal sources of finance Loans, overdrafts and share issues Leasing, hire purchase and trade credit Choosing the right source of finance

Cash Flow

Topic overview Types of budget and why firms set them Adverse and favourable variances Cash flow, profit and why firms forecast Constructing and analysing a cash flow forecast

Financial Statements

Topic overview Revenue, cost of sales and gross profit Expenses and net profit Assets on the statement of financial position Equity and liabilities

Ratio Analysis

Topic overview Profit margins and return on capital employed The current ratio, liquidity and gearing Trade receivables and trade payables days Earnings per share and return on equity Using and evaluating ratio analysis

Investment Appraisal and Financial Decisions

Topic overview The payback method Net present value and discounting Average rate of return and choosing a method Appraising an investment for a client Using financial data for growth and staffing decisions

IT Systems and Communication Technology

Topic overview The role of technology in business Management information and performance management systems Choosing and integrating IT systems Email, messaging, telephone and text Websites, document sharing, conferencing and social media

Technology for People and Operations

Topic overview Performance management software HR information systems Customer relationship management software Transaction processing technology Inventory management technology

Technology for Finance and Disaster Recovery

Topic overview Spreadsheets for financial decisions Databases and accounting software Data security principles and cyber threats SSL, HTTPS and two-factor authentication Legislation on data and technology Disaster recovery planning and backup strategies

Big Data and the Ethics of Technology

Topic overview Big data, data analytics and KPIs Data storage systems Automated decisions, censorship and monitoring Personal data, the digital divide and acceptable use

Leadership and Management

Topic overview Leadership, management and emotional intelligence Fayol's functions and Mintzberg's roles The Tannenbaum–Schmidt continuum and leadership styles Transformational and transactional leadership The Blake Mouton grid and Adair's Action-Centred Leadership Performance management and review

Managing Teams

Topic overview Team working and Tuckman's stages Belbin's nine team roles Using and evaluating Belbin's model

Managing Change

Topic overview Reasons for change in the business environment Resistance to change Lewin, Kotter and Galbraith's change models Benefits and challenges of managing change

Project Management and Feasibility

Topic overview What a project is and why project management matters Project roles and responsibilities Project documents, plans and registers Client needs and feasibility research The business case and the project brief

Project Initiation and Planning

Topic overview The initiation stage and the project initiation document Project tolerances for time, cost, quality and risk The planning stage: scope, objectives and deliverables Resources, roles, quality and financial plans Gantt charts, risk plans and the stage review

Project Closure and Evaluation

Topic overview Monitoring and reviewing a project during execution Closing a project Evaluating a project and gathering stakeholder feedback

Cash Flow

Constructing and analysing a cash flow forecast

3 things to know
AS 3

Overview

Receipts, payments, net cash flow and closing balances with worked forecasts, drawings and loans, analysing a forecast and dealing with a cash shortfall.

What you need to know

Answer each one before you reveal it.

Your recallNot started

Key term

What are receipts in a cash flow forecast?

Key term

What are payments in a cash flow forecast?

Key term

What is net cash flow?

Questions from this subtopic

Each one with the model answer underneath.

1
What are receipts in a cash flow forecast?
Model answer
Receipts are the cash inflows a business expects in each month. Cash sales, payments from credit customers and new loans are examples.
2
What are payments in a cash flow forecast?
Model answer
Payments are the cash outflows a business expects to make in each month. Wages, rent, supplier bills and loan repayments are examples.
3
What is net cash flow?
Model answer
Net cash flow is total receipts minus total payments for the month. A negative net cash flow means more cash is leaving than arriving.
4
How is the closing bank balance calculated in a cash flow forecast?
Model answer
The closing balance equals the opening balance plus the net cash flow for the month. Each month's closing balance becomes the next month's opening balance.
5
A Newry law firm expects receipts of £48,000 and payments of £53,500 in March, with an opening balance of £3,200. What is its closing balance?
Model answer
The closing balance is an overdraft of £2,300. The working is £48,000 − £53,500 = −£5,500, then £3,200 − £5,500 = −£2,300.
6
A consultancy opens January with £6,000 in the bank. Its net cash flows are −£2,500 in January, −£4,700 in February and +£3,900 in March. What is the closing balance each month?
Model answer
The closing balances are £3,500 in January, −£1,200 in February and £2,700 in March. The working is £6,000 − £2,500 = £3,500, then £3,500 − £4,700 = −£1,200, then −£1,200 + £3,900 = £2,700.

See the rest and revise

Other ways to work this

The same content, four other ways.

What is inside Levo

Six ways to work the same material.

1Closed book

2Open book

3Closed book

The 3-step method, run for you

Answer cold, learn it, then prove it stuck. Levo tracks the jump between your first attempt and your last.

The Business Environment

The Professional Business Services Sector

The Consultancy Process

Understanding the Client's Market

Cram a whole paper in one sitting

Sort every topic into what you know and what you do not, then drill only the weak ones.

A payback is usually preferred.

shorterlongerslower

Blank Blitz makes facts automatic

Rapid timed gap-fills on the terms and numbers you need to recall without thinking.

AA firm might move its staff to a new office.

BA firm might install a new client database.

CA firm might run a graduate recruitment campaign.

Build It gets the exam shape right

Assemble a full-mark answer from its marking points, in the order an examiner wants them.

Equity means the owner's investment in the business.

TrueFalse

Test It catches misconceptions

Spot the fault in a statement. The traps are the mistakes students actually make.

721941163128510

Brain Breaks between sessions

Short focus games to reset attention, so the next set lands better than the last.

Every question in Cash Flow, on a schedule.

Attempt a question from memory, write the correct version, then attempt it again. Levo records the jump between your first attempt and your last, and brings each question back on the day you are due to forget it.

Start revising, £5 a month See how the method works

Or £46 a year, about £3.83 a month. Cancel anytime.