0% found this document useful (0 votes)
53 views3 pages

Financial Forecasting Techniques Explained

Lucy collage

Uploaded by

tesfayealex02
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
53 views3 pages

Financial Forecasting Techniques Explained

Lucy collage

Uploaded by

tesfayealex02
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Unit Three

Financial forecasting
Contents:
1. Overview of financial forecasting
2. Forecasting growth rates and outside financing
3. Forecasting external financing needs
4. Financial statement forecasting; percentage of sales method
Overview of financial forecasting
• Financial forecasting is a process by which financial analysts estimate and project a
business’s future outlook (financially).
• A financial forecast predicts any given business’s future income and expenses, usually
over the next year.
• Financial forecasting refers to that process by which a business estimates or predicts how
it is likely to perform in the future.
• A forecast is the prediction of the future based on a certain set of circumstances that
could be related to the past or present data.
• It involves developing future estimates after a thorough analysis of different trends. In
other words, forecasting is a step-by-step process of predicting the future.
Three basic principles of forecasting are:
 Forecasts are rarely perfect,
 Forecasts are more accurate for groups than individual items,
 Forecasts are more accurate in the shorter term than longer time horizons.
The forecasting process involves five steps:
 Decide what to forecast
 Evaluate and analyze appropriate data
 Select and test model
 Generate forecast
 Monitor accuracy.
Advantage of financial forecasting
• It can be used as a control device in evaluating the results. It helps you to make a
blueprint for your business.
• It helps to explain the requirement of funds for the firm.
• It helps in recognizing the risks and financial crunches in the business.
• It also helps to explain the proper requirements of cash and their optimum utilization
• It gives an assessment of the future need for cash and enables you to take a decision
about whether money should be borrowed or not, It assists to secure a bank loan
• Allows comparison of strategic alternatives
• To understand the strengths and weaknesses of the business
• Represents a benchmark for assessing project development
Approaches of financial forecasting
• There are two ways of developing financial forecasting:
 Qualitative approach of Financial Forecasting: Qualitative methods – judgmental methods,
Forecasts generated subjectively by the forecaster
 Executive opinion  Delphi method
 Market research  Sales force polling
 Quantitative approach of Financial Forecasting
• Quantitative methods – based on mathematical modeling: Forecasts generated through
mathematical modeling
 Cause and effect method  Percentage of sales method
 Days sales financial forecasting  Time series method
The three financial statements most commonly used in financial forecasting are:
• Income Statement
• Balance Sheet
• Cash Flow Statement
External financing need forecasting
Instead of preparing a set of forecasted financial statements, you can also calculate your external
financing needs (EFN) by using a formula that looks at three changes:
1. Required increases to assets given a change in sales. Formula = (A/S) x (Δ Sales).
2. Required increases to liabilities given a change in sales. = (Ap/S)* (Δ sales) Note: Long term
debt does not increase with a change in sales and is typically excluded.
3. Profit Margin on Sales; i.e. net income / sales. = NI/Sales
4. Required increases to retained earnings as a result of income less any distributions. FS(1-d)
• The complete formula (EFN) is expressed as:
EFN = (A/S) x (Δ Sales) - (Ap/S) x (Δ Sales) - (PM x FS x (1-d))
• A / S: Assets that change given a change in sales, expressed as a percentage of sales.
• Δ = Symbol for Change
• Δ Sales: Change in sales between the last reporting period and the forecasted sales.
• Ap / S: Liabilities that change given a change in sales, expressed as a percentage of sales.
• PM: Profit Margin on Sales; i.e. net income / sales.
• FS: Forecasted Sales
• d: dividend payout percent
• (1 - d): Percent of earnings retained after paying out dividends; d is the dividend payout
ratio.
Example of financial forecasting
Assume ABC corporate business needs to forecast financial statement of an organization for the
year 2016 based on 2015 performance using percentage of sales growth forecasting method.
Given:
 Sales growth will be by 25%
 All income statement accounts will increase with relation to sales growth, except interest
expenses(based on long term notes payables)
 Current fixed asset utilization are 100%
 All asset accounts and account payable will be increase with relation to sales growth
 External financing will be:
EFN = (A/S) x (Δ Sales) - (L/S) x (Δ Sales) - (PM x FS x (1-d))
= ($1,000/$2,000)($500) - ($100/$2,000)($500) - 0.0270($2,500)(1 - 0.4) = $184.5 million.
 Tax rate constant at 40%
 Dividend payout ratio constant at 40%
 Stockholders equity accounts have no relation with sales growth
 Approximation to nearest number: the forecasted financial statements are as follows
Forecasting Income statement
2015 Percentage to sales 2016
Sales 2000 2500
Cost of sales 1200 0.6 1500
Gross profit 800 0.4 1000
Operating expenses 700 0.35 875
EBIT 100 125
Interest (10%) 10 20
EBT 90 105
Tax 40% 36 42
Net income 54 63
Dividend 40% 21.6 25.2
Retained earning 32.4 37.8

Forecasting Statement of Balance sheet


Percentage to Liabilities and Percentage
Assets
2015 sales 2016 equity 2015 to sales 2016
Cash 20 0.01 25 Account payable 100 0.05 125
Account receivable 240 0.12 300 Short –term N/P 100 100
Total current
Inventory
240 0.12 300 liabilities 200 225
Total current asset 500 625 Long- term N/P 100 284.5
Fixed asset net 500 0.25 625 Common stock 500 500
Total asset 1000 1250 Retained earning 200 237.8
Total claim 1000 1250

Common questions

Powered by AI

In financial forecasting, the 'percentage to sales' affects various components by scaling them relative to changes in sales. For the income statement, components like cost of goods sold, operating expenses, and taxes are expressed as percentages of sales, thus fluctuating with sales growth proportions. For example, if sales increase by 25%, cost of sales, operating expenses, and tax amounts would also rise relative to their respective historical sales percentages . On the balance sheet, assets such as accounts receivable and inventory, and liabilities like accounts payable, also vary with sales levels. This relationship ensures that financial statements dynamically reflect potential future scenarios based on sales forecasts . By understanding these variations, businesses can better estimate future financial needs and performance.

The percentage of sales method predicts external financing needs by evaluating how various items on financial statements—such as assets, liabilities, and expenses—change in proportion to sales growth. Specifically, the external financing need (EFN) is calculated using the formula: EFN = (A/S) x (Δ Sales) - (Ap/S) x (Δ Sales) - (PM x FS x (1-d)), where A/S represents the proportion of assets that vary with sales, Ap/S represents the liabilities that change with sales, PM is the profit margin, FS denotes forecasted sales, and (1-d) accounts for retained earnings after dividends . This method provides an integrated approach linking sales projections directly to financial resource needs, thus enabling better planning for growth-related financing requirements.

The EFN formula incorporates changes in sales by calculating the needed changes in assets and liabilities proportional to sales growth, as well as profit margins and dividends. It uses the equation EFN = (A/S) x (Δ Sales) - (Ap/S) x (Δ Sales) - (PM x FS x (1-d)), where changes in sales, Δ Sales, drive the calculations of increased asset requirements ((A/S) x Δ Sales), increased liabilities ((Ap/S) x Δ Sales), profit margin influence, and impacts on retained earnings after dividends (PM x FS x (1-d)). This direct linkage implies that any sales variance will influence the company's balance sheet structure and financing requirements. For financial management, this means that sales forecasting becomes crucial, as it determines funding strategies and liquidity planning . It helps in anticipating future financing needs and aligning financial policy with growth targets.

The forecasting process enables businesses to handle potential financial crunches effectively by anticipating future financial needs and allowing for the timely mobilization of resources. By systematically evaluating and analyzing financial data, businesses can spot trends indicating impending crunches, such as cash flow deficiencies or rising debt burdens. Forecast modeling can identify periods of financial stress in advance, thus empowering organizations to take preemptive action, such as arranging alternative financing options, optimizing costs, or enhancing operational efficiency . These proactive measures reduce the risk of adverse outcomes and maintain financial stability even amidst challenging conditions.

Using financial forecasting as a control device provides businesses with several key benefits: it allows for the creation of benchmarks against which actual performance can be measured, enabling management to evaluate results effectively. Financial forecasting also aids in the early identification of deviations from expected results, thus allowing timely corrective measures through focused operational adjustments. Furthermore, it helps in tracking the utilization of funds, thus ensuring optimal financial resource allocation. By providing these insights, financial forecasting supports efficient decision-making and strategic planning .

A constant dividend payout ratio implies that the proportion of earnings distributed as dividends remains fixed, affecting retained earnings in financial forecasts. As earnings increase, dividends distributed also rise in line with the set percentage, leaving a consistent proportion of earnings to be retained. This stable retention ratio ensures predictable additions to retained earnings, crucial for forecasting future internal financing abilities and understanding growth potential. In accordance with the formula EFN = (A/S) x (Δ Sales) - (Ap/S) x (Δ Sales) - (PM x FS x (1-d)), retained earnings are impacted by the dividend factor (1-d), illustrating the direct influence that dividend policies exert on liquidity and capital structure .

The three basic principles of financial forecasting are: forecasts are rarely perfect, forecasts are more accurate for groups than individual items, and forecasts are more accurate in the shorter term than longer time horizons. These principles are important because they temper expectations and guide financial analysts to approach forecasting with caution. Understanding the limitations helps in setting realistic targets and adopting a flexible approach to business planning. By acknowledging the unpredictability of individual item forecasts, companies can prepare for a range of outcomes, and by focusing on shorter-term forecasts, they can make more reliable financial plans .

Financial forecasting assists businesses in recognizing risks and financial crunches by providing a forward-looking assessment of cash flows, income, and expenses. By predicting future financial scenarios, businesses can anticipate potential shortfalls in revenue or unexpected expenses, allowing them to devise strategies such as securing lines of credit or adjusting operational costs accordingly. It also enables businesses to simulate different scenarios, thereby identifying potential risk factors linked to market changes or operational inefficiencies . This proactive approach helps companies mitigate risks before they materialize into serious financial issues.

The forecasting process benefits strategic alternatives comparison by providing a structured framework to evaluate different business scenarios on a comparable basis. By generating financial forecasts, organizations can simulate various strategic paths, such as expansions, cost-cutting, or new product launches, and assess their financial implications. These simulations can help management understand the potential impact of each alternative on resources, cash flows, and profitability . Furthermore, it provides empirical data that aids in visualizing long-term impacts, risk assessment, and decision-making clarity by highlighting the most viable and financially sound strategies.

The qualitative approach to financial forecasting relies on judgmental methods and expert opinions, including executive opinion, market research, Delphi method, and sales force polling. These methods are subjective and often utilized when past quantitative data is lacking or when forecasting for new products or markets. In contrast, the quantitative approach uses mathematical models, such as the cause and effect method, days sales financial forecasting, percentage of sales, and time series method, to make objective predictions based on historical data. Quantitative methods are preferred when historical data is reliable and comprehensive; qualitative methods are preferred in dynamic or innovative markets where historical data may not fully capture upcoming trends .

You might also like