Data, Market Analysis, Sales forecasting and finanial/non-financial performance

Define data

Data is information that has been collated in a way that allows it to be used to inform decision making

Define Index Numbers

Index Numbers allow for comparisons to be made over time. An index starts on a given number, usually 100, which is the base number.

Define market analysis

Market analysis is concerned with collecting and interpreting data about customers and the market so that businesses adopt a relevant marketing strategy

Define PED and give its equation

Price elasticity of demand - measures how sensitive demand is to a change in price

(Percentage change in quantity demanded) / (Percentage change in price)

*Always shown as a negative

Define YED and give its equation

YED = (Percentage change in Quantity Demanded) / (Percentage Change in Income)

What is a price elastic product and what is its PED Value

• PED Value >1

• Change in price will cause more than a proportional change in quantity demanded

• Demand is sensitive to a change in price

• E.g. goods w/ many substitutes, luxury goods

What is a price inelastic product and what is its PED Value

• PED Value <1

• Change in price causes less than proportional change in quantity demanded

• Demand is not sensitive to a change in price

• E.g. Necessities, Addictive goods, strong brands

What is a normal good and what is its YED Value

• YED value less than 1 and positive

• As income increases, demand increases

• Inelastic

What is a luxury good and what is its YED Value

• YED value is greater than 1

• As income increases, the demand for luxury goods will grow faster than the increase in income

• Elastic

What is an inferior good and what is its YED Value

• negative income elasticity

• YED value is less than 0

• If income rises, demand will fall

What is sales forecasting

Sales forecasting is the process of predicting future demand by anticipating what consumers are likely to do in a given set of circumstances

What are quantitative forecasting

Quantitative forecasting methods are used when there is historical data available

Can include:

• Time series analysis

• Extrapolation and trend analysis

• Correlation analysis

• Use of market Research data

What is qualitative forecasting

Qualitative forecasting methods are used when historical data is not available.

Can include:

• Delphi technique

• Brainstorming

• Expert opinion

• Intuition

What are the three main external factors that could make sales forecast inaccurate

• Economy

• Consumer trends

• Competition actions

What is time-series analysis

Time-series analysis uses evidence from past sales records to predict future sales patterns

Uses moving averages to smooth out fluctuations in data to identify trend

What is extrapolation

Extrapolation is determining future trends through the extension of past trends using a line of best fit

What is correlation analysis

A measurement of the strength of the relationship between two variables

What 3 types of market research data can be used for sales forecasting

• Surveys of consumer intentions

• Direct sales information

• Test marketing

What is the Delphi method

1. Select a panel of experts – e.g. industry specialists, senior managers, consultants.

2. First round of questionnaires – each expert gives their independent forecasts or views on future sales.

3. Results are summarised – a facilitator collects and summarises the responses, then shares the summary back with the group (without revealing individual names).

4. Further rounds – experts review the summary and may adjust their forecasts, aiming for a more refined, reasoned consensus.

5. Consensus forecast – after several rounds, the group tends to converge on a forecast that represents the collective judgment.

What are the advantages and disadvantages of using the Delphi Method as a way of sales forecasting

Advantages

• Uses the knowledge of experts, so can consider qualitative factors (e.g. market trends, competitor moves, new technology).

• Reduces bias compared to relying on one person’s opinion.

• Useful when there is little past data (e.g. for a new product).

Disadvantages

• Can be time-consuming and expensive (experts’ time and multiple rounds needed).

• Still subjective, as it depends on opinions.

• Quality of forecast depends on the quality of experts chosen.

What is a budget

A budget is a financial plan for the future, It includes expected levels of expenditure and revenues of a business

What is a balance sheet and what are its components

A balance sheet is a statement of a business’s assets and liabilities at a specific point in time.

The components of a balance sheet are as follows:

• Fixed (or non-current) assets - Expected to be retained within the business for more than a year, therefore having a long term role in the business and are used to produce the output of the business

• Current Assets - Expected to change value often due to the normal course of business trading

• Current Liabilities - Debts that are normally paid within a year

• Long term (or non-current) liabilities - repaid over more than a year

• Net Assets - calculated by adding both current and non-current assets and deducting all liabilities

• Net Current Assets - Difference between current assets and current liabilities

• Shareholders funds - money invested into business by the owners, and also includes retained profit and reserves

What is working capital and how is it calculated

Working capital is the money required for the day-to-day operations of the business. Working capital is a good measure of a firms short term financial health, providing an indication of whether a business hold enough current assets to cover their current liabilities

Working Capital = Current Assets - Current Liabilities

What is capital employed and how is it calculated (2)

Capital employed is the total amount of capital used for the acquisition of profits by a firm. Provides an insight into how well a company is investing its money to generate profit

Capital employed = Non-current liabilities + Owners Equity (Shareholders funds)

OR

Total assets - current liabilities  

What is return on capital employed

Return on capital employed shows the profitability of the investment by calculating its percentage return. This measures the efficiency with which the business generates profits from the capital invested in it. Over 15% is a desirable figure

Can be improved by reducing capital employed and raising profit.

ROCE = (Net profit before tax/ Shareholder’s funds + non-current liabilities) x 100

What is liquidity

Refers to how quickly assets can be converted into cash

How is the current ratio calculated

= Current assets / current liabilities

Always shown to 1

Should be between 1.5:1 - 2:1

Below 1.5:1 is due to over borrowing

Above 2:1 is bot ideal as money is just sitting around and not used productively

What is acid ratio

(Current assets - stock) / Current liabilities

Ideal = 1:1

Less - not enough current assets to cover liabilities

What is the gearing ratio

Gearing ratio = (Non current liabilities / Capital employed) x 100

• >50% = highly geared - majority of business funded by debt

• <40% = low geared - low level borrowing

What does it mean to window dress accounts

Window dressing involves the organisation of financial information in such a way that it presents the business in the best possible light to investors

What are the main methods of window dressing accounts

• Exceptional items - asset sales might be presented as part of the firm’s normal sales revenue, disguising the real reason behind a rise in profits

• Brand Valuation - Intangible assets like brands could be revalued much higher by a firm. Or depreciate intangible assets to reduce tax and improve ROCE

• Presentation - Distorting chart sales and being selective about which data is used

• Rush to sell stock at end of financial year

• Delay payments for expenses

• Keep ‘bad debtors’ even though there is little to no chance of them paying back - increases total assets and makes the business appear more liquid

Why would a business want to window dress its accounts 

• Strengthen share price to attract investors

• Manager praise and recognition 

• Lower tax by artificially reducing profits

• Improve credit score by raising profits

• Minimise risk of takeover by raising company valuation

What is depreciation

Depreciation involves recognising that fixed asset are not worth the same value throughout their useful life due to becoming damaged, outdated or obsolete.

Cost of the asset is spread out over its lifetime, providing a more realistic statement of a firms financial position and prevents assets from being overvalued

Define historic costs 

How much a fixed asset is originally purchased for

Define Net book value

How much a fixed asset is worth after depreciation is subtracted

Define useful life of an asset

An estimate of how long a fixed asset is going to be in use for

Define residual value

The worth of a fixed asset at the end of its useful life

How is annual depreciation calculated

Annual depreciation = (Historic Cost Value - Residual Value) / Useful life of asset