Chapter 9 - Financial Planning and External Financing Requirement (EFR): A Practical Guide Using Balance Sheet Forecasting



Introduction

Financial planning is a fundamental component of financial management that enables organizations to estimate future financial requirements and arrange adequate funds to support business growth. Every business organization aims to expand its operations, increase sales, improve profitability, and strengthen its market position. However, growth requires resources, and resources require financing.

A company may have strong demand for its products and services, but without sufficient financial resources, it may not be able to achieve its growth objectives. Therefore, financial planning serves as the bridge between organizational goals and the financial resources required to achieve them.

This article explains the concept of financial planning, the role of sales forecasting, projected financial statements, budgeting, and the calculation of External Financing Requirement (EFR) using a practical balance-sheet-based approach.


Understanding Financial Planning

What is Financial Planning?

Financial planning is the process of estimating future financial needs and determining the most suitable sources of finance to meet those needs.

It involves:

  • Forecasting future sales

  • Estimating future assets and liabilities

  • Determining financing requirements

  • Preparing projected financial statements

  • Arranging internal and external funds

Financial planning ensures that organizations have adequate resources available when needed and can pursue growth opportunities without facing liquidity constraints.


Objectives of Financial Planning

The primary objectives of financial planning include:

ObjectivePurpose
Estimating Financial RequirementsAssess future funding needs
Ensuring Availability of FundsPrevent shortages of capital
Supporting GrowthFacilitate business expansion
Risk ManagementReduce financial uncertainty
Performance MonitoringEstablish measurable targets
Resource OptimizationImprove allocation of resources

A well-designed financial plan enables management to make proactive decisions rather than reacting to financial challenges after they arise.


The Relationship Between Growth and Financing

Business growth is generally measured through growth in sales.

When sales increase:

  • Production requirements increase

  • Inventory levels increase

  • Receivables increase

  • Working capital requirements increase

  • Asset requirements increase

Consequently, financing requirements also increase.

This creates a direct relationship between sales growth and financial requirements.

Organizations must therefore estimate:

  1. Expected growth in sales.

  2. Additional assets required.

  3. Sources of financing required to support growth.


Sales Forecasting: The Foundation of Financial Planning

Financial planning begins with sales forecasting.

Sales forecasting helps answer critical questions:

  • How much will the company sell next year?

  • How much production will be required?

  • What resources will be needed?

  • How much financing must be arranged?

Without reliable sales forecasts, financial planning becomes ineffective because all financial projections depend on expected revenue growth.


Sources of Business Financing

Before calculating financing requirements, it is important to understand the different sources of finance available to businesses.

1. Long-Term Financing

Long-term financing is used for long-term investments and strategic growth.

Examples include:

  • Equity Share Capital

  • Retained Earnings

  • Long-Term Loans

  • Debentures

  • Bonds


2. Short-Term Financing

Short-term financing is used to meet working capital requirements.

Examples include:

  • Bank Overdrafts

  • Cash Credit

  • Short-Term Loans


3. Spontaneous Financing

Spontaneous financing arises automatically through business operations.

Examples include:

  • Trade Creditors

  • Accounts Payable

  • Outstanding Expenses

  • Provisions

Spontaneous financing generally increases automatically as business activity increases.


External Financing Requirement (EFR)

Meaning

External Financing Requirement (EFR) refers to the amount of additional external funds required by a company to support projected growth.

These funds may be obtained through:

  • Bank loans

  • Financial institutions

  • Bonds

  • Debentures

  • Equity issues

  • Venture capital

EFR helps management determine whether planned growth is financially feasible.


Formula for External Financing Requirement

Website-Friendly Formula:

EFR = [(A/S) - (L/S)] × ΔS - [M × S1 × (1 - D)]

Where:

A/S = Assets to Sales Ratio

L/S = Spontaneous Liabilities to Sales Ratio

ΔS = Change in Sales

M = Profit Margin

S1 = Forecast Sales

D = Dividend Payout Ratio

Balance Sheet Approach to EFR Calculation

Consider the following balance sheet of ABC Ltd.

Balance Sheet of ABC Ltd.

Liabilities

ParticularsAmount (₹ Lakhs)
Share Capital50
Retained Earnings60
Long-Term Borrowings80
Short-Term Borrowings60
Trade Creditors50
Provisions20
Total320

Assets

ParticularsAmount (₹ Lakhs)
Fixed Assets130
Inventory90
Accounts Receivable80
Cash20
Total320

Additional Information

ItemValue
Current Sales₹400 Lakhs
Forecast Sales₹500 Lakhs
Profit Margin5%
Dividend Payout Ratio50%

Step 1: Calculate Change in Sales

ΔS = S1 - S0

Where:

S0 = Current Sales

S1 = Forecast Sales

Calculation:

ΔS = 500 - 400

ΔS = ₹100 Lakhs

Step 2: Calculate Asset-to-Sales Ratio

Total Assets:

₹320 Lakhs

Current Sales:

₹400 Lakhs

Therefore:

A/S = 320 / 400

A/S = 0.80

Step 3: Calculate Spontaneous Liability-to-Sales Ratio

Only spontaneous liabilities are included:

Trade Creditors = 50

Provisions = 20

Total Spontaneous Liabilities:

70 Lakhs

Therefore:

L/S = 70 / 400

L/S = 0.175

Step 4: Apply EFR Formula

Substituting values:

EFR = [(0.80 - 0.175) × 100]

      - [0.05 × 500 × (1 - 0.50)]

Solving:

EFR = (0.625 × 100)

      - (25 × 0.50)
EFR = 62.5 - 12.5
EFR = ₹50 Lakhs

Interpretation of Results

The company plans to increase sales from ₹400 lakhs to ₹500 lakhs.

To achieve this growth, the company will require:

₹50 Lakhs

of external financing.

This information is highly valuable because management can arrange funds before implementing growth plans.


Importance of Estimating EFR in Advance

Estimating financing requirements in advance offers several benefits:

Better Financing Decisions

Management can choose the most appropriate funding source.

Reduced Financial Risk

Unexpected funding shortages can be avoided.

Improved Planning

Growth strategies can be aligned with available resources.

Increased Investor Confidence

Well-planned growth improves credibility among investors and lenders.


Financial Planning and Economic Environment

Financial planning should never be conducted in isolation.

Managers must evaluate:

  • Economic conditions

  • Industry trends

  • Competitive environment

  • Interest rates

  • Inflation

  • Consumer demand

A strong financial plan considers both internal and external business factors.


EIC Analysis in Financial Planning

An important framework used in financial forecasting is EIC Analysis.

E – Economy Analysis

Examines:

  • GDP growth

  • Inflation

  • Interest rates

  • Government policies

I – Industry Analysis

Examines:

  • Industry growth

  • Competition

  • Technology trends

  • Market demand

C – Company Analysis

Examines:

  • Financial performance

  • Competitive advantage

  • Profitability

  • Growth potential

EIC analysis provides a comprehensive foundation for realistic financial forecasting.


Budgeting as a Financial Planning Tool

Budgeting is one of the most important tools used in financial planning.

Each department prepares its own budget.

Departments typically include:

  • Production

  • Purchasing

  • Marketing

  • Sales

  • Research & Development

  • Finance

These departmental budgets are consolidated into a master budget.


Projected Financial Statements

Financial planning ultimately results in the preparation of projected financial statements.

Projected Income Statement

Forecasts future profitability.

Projected Balance Sheet

Forecasts future financial position.

Projected Cash Flow Statement

Forecasts future liquidity.

These statements serve as financial roadmaps for the organization.


Why Financial Planning Creates Competitive Advantage

Organizations that plan effectively enjoy several advantages:

  • Better resource allocation

  • Faster decision-making

  • Improved profitability

  • Lower financing costs

  • Reduced uncertainty

  • Stronger growth potential

Companies that fail to plan often face liquidity shortages, financing difficulties, and operational disruptions.


Managerial Implications

Financial managers must understand:

  • How growth affects financing needs

  • How to estimate EFR

  • How to evaluate funding sources

  • How to balance growth and risk

  • How to prepare projected financial statements

These skills are essential for effective financial management.


Conclusion

Financial planning is a critical element of modern financial management. It enables organizations to estimate future financing requirements, support business growth, and maintain financial stability. By forecasting sales, preparing budgets, analyzing financial statements, and calculating External Financing Requirement (EFR), managers can make informed decisions that support sustainable growth.

The balance-sheet approach to EFR calculation provides a practical framework for estimating external financing needs and ensures that growth plans are supported by adequate financial resources. Organizations that integrate financial planning into their strategic decision-making process are better positioned to achieve long-term success.


MBA Interview Questions and Answers

Q1. What is financial planning?

Answer: Financial planning is the process of estimating future financial needs and arranging suitable sources of finance.

Q2. Why is sales forecasting important?

Answer: Sales forecasting provides the foundation for estimating future financing requirements.

Q3. What is External Financing Requirement (EFR)?

Answer: EFR is the amount of external funds required to support projected business growth.

Q4. What are spontaneous liabilities?

Answer: Liabilities that arise automatically through business operations, such as trade creditors and provisions.

Q5. Why are trade creditors considered spontaneous financing?

Answer: They arise naturally from credit purchases and do not require separate financing agreements.

Q6. What is the formula for EFR?

Answer:

EFR = [(A/S) - (L/S)] × ΔS - [M × S1 × (1 - D)]

Q7. What is the purpose of projected financial statements?

Answer: They forecast future profitability, financial position, and cash flows.

Q8. What is EIC Analysis?

Answer: Economy, Industry, and Company Analysis used for forecasting and investment decisions.

Q9. What is a master budget?

Answer: A consolidated budget that combines all departmental budgets.

Q10. Why is budgeting important?

Answer: It helps coordinate activities and allocate resources efficiently.

Q11. What is working capital?

Answer: The difference between current assets and current liabilities.

Q12. How does growth affect financing requirements?

Answer: Higher growth typically requires higher financing.

Q13. Why should firms estimate financing needs in advance?

Answer: To avoid funding shortages and improve decision-making.

Q14. What are projected sales?

Answer: Estimated future sales based on forecasts.

Q15. What is the primary goal of financial planning?

Answer: To ensure adequate funds are available at the right time and at the lowest possible cost.


Key Takeaways

  • Financial planning estimates future financial requirements.

  • Sales forecasting is the foundation of financial planning.

  • Growth and financing requirements are closely linked.

  • EFR measures additional funding needs.

  • Balance sheets can be used to estimate financing requirements.

  • Spontaneous liabilities reduce external financing needs.

  • Trade creditors are a major source of spontaneous financing.

  • Budgeting supports effective planning.

  • Projected statements act as financial roadmaps.

  • EIC analysis improves forecasting accuracy.

  • Economic conditions influence financial planning.

  • Asset growth often accompanies sales growth.

  • Financial planning reduces uncertainty.

  • Effective planning improves resource allocation.

  • EFR helps evaluate growth feasibility.

  • Managers must balance growth and risk.

  • Forecasting improves strategic decision-making.

  • Financial planning enhances organizational performance.

  • Adequate financing supports sustainable growth.

  • Strong financial planning creates competitive advantage.

Post a Comment

Previous Post Next Post