What is what-if analysis in a spreadsheet?

What-if analysis changes one or more inputs to see the effect on the results. A consultant might test how profit changes if fees rise by 5%.

Goal seek is a spreadsheet tool that works backwards from a target result to find the input needed. A firm could find the number of clients needed to break even.

What is the difference between a relative and an absolute cell reference?

A relative reference changes when a formula is copied to another cell. An absolute reference, marked with dollar signs such as $B$1, stays fixed.

How can a spreadsheet help an adviser prepare a cash flow forecast for a client?

Monthly receipts and payments are entered and the closing balances calculate automatically. The client can see the months when an overdraft may be needed.

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

Technology for Finance and Disaster Recovery

Spreadsheets for financial decisions

3 things to know
A2 1

Overview

Spreadsheet formulas, what-if analysis and goal seek, relative and absolute references, cash flow and budget models, worked VAT and profit figures, and spreadsheet errors.

What you need to know

Answer each one before you reveal it.

Your recallNot started

Evaluation

Evaluate spreadsheets for managing the finances of a growing Armagh client business.

Key term

How do spreadsheets support financial decision making?

Key term

What is a spreadsheet formula?

Questions from this subtopic

Each one with the model answer underneath.

1
How do spreadsheets support financial decision making?
Model answer
Spreadsheets calculate figures from formulas, so budgets and forecasts update when any input changes. Managers can test options before committing money.
2
What is a spreadsheet formula?
Model answer
A formula is an instruction in a cell that calculates a value from other cells. A formula such as =SUM(B2:B6) adds a range of cells and updates when any of them changes.
3
What is what-if analysis in a spreadsheet?
Model answer
What-if analysis changes one or more inputs to see the effect on the results. A consultant might test how profit changes if fees rise by 5%.
4
What is goal seek?
Model answer
Goal seek is a spreadsheet tool that works backwards from a target result to find the input needed. A firm could find the number of clients needed to break even.
5
What is the difference between a relative and an absolute cell reference?
Model answer
A relative reference changes when a formula is copied to another cell. An absolute reference, marked with dollar signs such as $B$1, stays fixed.
6
How can a spreadsheet help an adviser prepare a cash flow forecast for a client?
Model answer
Monthly receipts and payments are entered and the closing balances calculate automatically. The client can see the months when an overdraft may be needed.

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

See a huge jump in your memorisation

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 consolidates the facts

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 trains answer structure

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 Technology for Finance and Disaster Recovery, 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.

Spreadsheets for financial decisions

Overview

What you need to know

Evaluate spreadsheets for managing the finances of a growing Armagh client business.

How do spreadsheets support financial decision making?

What is a spreadsheet formula?

Questions from this subtopic

How do spreadsheets support financial decision making?

What is a spreadsheet formula?

What is what-if analysis in a spreadsheet?

What is goal seek?

What is the difference between a relative and an absolute cell reference?

How can a spreadsheet help an adviser prepare a cash flow forecast for a client?

Other ways to work this

What is inside Levo

See a huge jump in your memorisation

Cram a whole paper in one sitting

Blank Blitz consolidates the facts

Build It trains answer structure

Test It catches misconceptions

Brain Breaks between sessions

Every question in Technology for Finance and Disaster Recovery, on a schedule.