0% found this document useful (0 votes)
11 views24 pages

Financial Planning and Forecasting Guide

The document discusses strategic planning and financial forecasting. It provides details on developing a mission statement, corporate scope, objectives and strategies. It also discusses operating and financial plans. The document includes an example of a preliminary financial forecast for a company with balance sheets, income statements and key assumptions. It then shows how to determine additional funds needed using the AFN equation and discusses revising the forecast based on management feedback.
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
11 views24 pages

Financial Planning and Forecasting Guide

The document discusses strategic planning and financial forecasting. It provides details on developing a mission statement, corporate scope, objectives and strategies. It also discusses operating and financial plans. The document includes an example of a preliminary financial forecast for a company with balance sheets, income statements and key assumptions. It then shows how to determine additional funds needed using the AFN equation and discusses revising the forecast based on management feedback.
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd

CHAPTER 4

Financial Planning and Forecasting


Forecasting sales Projecting the assets and internally generated funds Projecting outside funds needed Deciding how to raise funds
17-1

Strategic Planning

Mission Statement

- A condensed version of a firms strategic plan.

Corporate Scope

- defines a firms lines of business and geographic areas of operation.


17-2

Strategic Planning

Statement of Corporate Objectives

- sets forth specific goals to guide management. broad approaches developed for achieving firms goals

Corporate Strategies

17-3

Strategic Planning

Operating Plan Provides management with detailed implementation guidance based on the corporate strategy to help meet corporate objectives. Financial Plan The document that includes assumptions, projected financial statements, and projected ratios and ties the entire planning process together.
17-4

Sales Forecast

Starting Point of a financial plan. Increase in sales = increase in cost

17-5

Primary Capital Sources


1. Spontaneously Generated Funds Funds that arise out of normal business operations that reduce the firms need for external financing. 2. Addition to Retained Earnings Portion of earnings that is not given out as dividends 3. AFN = Additional Funds Needed The amount of external capital needed to acquire the needed assets.

17-6

The AFN equation


AFN = (A*/S0)S (L*/S0) S M(S1)(RR)
AFN = Projected increase in assets-Spontaneous increase
in liabilities increase in retained earnings
The equation that shows the relationship of external funds needed by a firm to its projected increase in assets, the spontaneous increase in liabilities, and its increase in retained earnings.
17-7

The AFN equation


AFN = (A*/S0)S (L*/S0) S M(S1)(RR)
A* = Assets tied directly to sales L* = Spontaneous Liab that will be affected by sales S0 = Sales during the last year S1 = Total Sales projected next year S = change in sales between S0 and S1 M = Profit Margin or profit per unit of sales M(S1)= Projected Net Income RR = Retention Ratio from NI and is calculated as (1-payout ratio)
17-8

The AFN equation


AFN = (A*/S0)S (L*/S0) S M(S1)(RR)
(A*/S0) = Capital Intensity Ratio
The ratio of assets required per dollar of sales.

(L*/S0) = Spontaneous Liability Ratio

17-9

Sustainable Growth Rate

The maximum achievable growth rate without the firm having to raise external funds. It is the growth rate at which the firms AFN equals zero.
EXTERNAL CAPACITY ADJUSTMENTS

Changes made to the existing asset forecast because the firm is not operating at full capacity

17-10

Preliminary financial forecast: Balance sheets (Assets)


2005 Cash and equivalents Accounts receivable Inventories Total current assets Net fixed assets Total assets $ 20 240 240 2006E $ 25 300 300

$ 500 500 $1,000

$ 625 625 $1,250

17-11

Preliminary financial forecast: Balance sheets (Liabilities and equity)


Accts payable & accrued liab. Notes payable Total current liabilities Long-term debt Common stock Retained earnings Total liabilities & equity 2005 $ 100 100 200 100 500 200 $1,000 2006E $ 125 190 315 190 500 245 $1,250
17-12

Preliminary financial forecast: Income statements


2005 Sales Less: Variable costs Fixed costs EBIT Interest EBT Taxes (40%) $2,000.0 1,200.0 700.0 $100.0 16.0 $84.0 33.6 2006E $2,500.0 1,500.0 875.0 $125.0 16.0 $109.0 43.6

Net income
Dividends (30% of NI) Addition to retained earnings

$50.4
$15.12 $35.28

$65.40
$19.62 $45.78
17-13

Key financial ratios


Basic earning power Profit margin Return on equity Days sales outstanding Inventory turnover Fixed assets turnover Total assets turnover Debt/assets Times interest earned Current ratio Payout ratio 2005 10.00% 2.52% 7.20% 2006E 10.00% 2.62% 8.77% Ind Avg 20.00% 4.00% 15.60% Comment Poor Poor Poor Poor Poor Poor Poor OK Poor Poor OK
17-14

43.8 days 43.8 days 32.0 days 8.33x 8.33x 11.00x 4.00x 4.00x 5.00x 2.00x 2.00x 2.50x 30.00% 40.34% 36.00% 6.25x 7.81x 9.40x 2.50x 1.99x 3.00x 30.00% 30.00% 30.00%

Key assumptions in preliminary financial forecast


Operating at full capacity in 2005. Each type of asset grows proportionally with sales. Payables and accruals grow proportionally with sales. 2005 profit margin (2.52%) and payout (30%) will be maintained. Sales are expected to increase by $500 million. (%DS = 25%)
17-15

Determining additional funds needed, using the AFN equation


AFN = (A*/S0)S (L*/S0) S M(S1)(RR) = ($1,000/$2,000)($500) ($100/$2,000)($500) 0.0252($2,500)(0.7) = $180.9 million.

17-16

Managements review of the financial forecast

Consultation with some key managers has yielded the following revisions: Firm expects customers to pay quicker next year, thus reducing DSO to 34 days without affecting sales. A new facility will boost the firms net fixed assets to $700 million. New inventory system to increase the firms inventory turnover to 10x, without affecting sales. These changes will lead to adjustments in the firms assets and will have no effect on the firms liabilities on equity section of the balance sheet or its income statement. 17-17

Revised (final) financial forecast: Balance sheets (Assets)


2005 Cash and equivalents Accounts receivable Inventories Total current assets Net fixed assets Total assets $ 20 240 240 2006E $ 67 233 250

$ 500 500 $1,000

$ 550 700 $1,250

17-18

Key financial ratios final forecast


Basic earning power Profit margin Return on equity Days sales outstanding Inventory turnover Fixed assets turnover Total assets turnover Debt/assets Times interest earned Current ratio Payout ratio 2005 10.00% 2.52% 7.20% 2006F 10.00% 2.62% 8.77% Ind Avg 20.00% 4.00% 15.60% Comment Poor Poor Poor OK OK Poor Poor OK Poor Poor OK
17-19

43.8 days 34.0 days 32.0 days 8.33x 10.00x 11.00x 4.00x 3.57x 5.00x 2.00x 2.00x 2.50x 30.00% 40.34% 36.00% 6.25x 7.81x 9.40x 2.50x 1.75x 3.00x 30.00% 30.00% 30.00%

What was the net investment in operating capital?

OC2006 = NOWC + Net FA = $625 - $125 + $625 = $1,125


OC2005 = $900

Net investment in OC = $1,125 - $900 = $225


17-20

How much free cash flow is expected to be generated in 2006?


FCF = = = = = NOPAT Net inv. in OC EBIT (1 T) Net inv. in OC $125 (0.6) $225 $75 $225 -$150.

17-21

Suppose fixed assets had only been operating at 85% of capacity in 2005

The maximum amount of sales that can be supported by the 2005 level of assets is:

Capacity sales = Actual sales / % of capacity = $2,000 / 0.85 = $2,353

2006 forecast sales exceed the capacity sales, so new fixed assets are required to support 2006 sales.

17-22

How can excess capacity affect the forecasted ratios?

Sales wouldnt change but assets would be lower, so turnovers would improve. Less new debt, hence lower interest and higher profits

EPS, ROE, debt ratio, and TIE would improve.


17-23

How would the following items affect the AFN?

Higher dividend payout ratio?

Higher profit margin?

Increase AFN: Less retained earnings.


Decrease AFN: Higher profits, more retained earnings. Increase AFN: Need more assets for given sales.

Higher capital intensity ratio?

Pay suppliers in 60 days, rather than 30 days? Decrease AFN: Trade creditors supply more capital (i.e., L*/S0 increases).
17-24

Common questions

Powered by AI

Modifications to operational capacity, such as the introduction of a new facility, can increase net fixed assets, thereby altering the balance sheet projections. Additionally, improvements to inventory systems, leading to changes like increased inventory turnover, can optimize asset utilizations and improve ratios such as inventory turnover and total asset turnover. These changes help in better asset management, potentially lowering the need for additional financing by making better use of existing resources, thus impacting the AFN and other financial forecast metrics lessening the firm's dependency on external funds .

The primary components involved in determining the Additional Funds Needed (AFN) for a firm are (A*/S0)ΔS, (L*/S0)ΔS, and M(S1)(RR). The first component, (A*/S0)ΔS, represents the projected increase in assets proportional to the change in sales, impacting AFN by increasing it as sales grow. The second component, (L*/S0)ΔS, represents the spontaneous increase in liabilities proportional to sales, which reduces the need for external funds as the firm naturally generates more funds through its operations. The third component, M(S1)(RR), represents the increase in retained earnings from net income, inversely impacting AFN by decreasing it when higher retained earnings are projected .

Financial ratios in a firm's final forecast, such as return on equity, profit margin, and inventory turnover, provide critical insights into the firm's operational efficiency, profitability, and asset management. Poor ratios compared to industry averages indicate areas needing improvement to meet stakeholder expectations, while satisfactory ratios suggest effective management and financial health. Stakeholders may use these ratios to assess risk, the firm's growth potential, and make informed decisions regarding investments and operational changes .

The sustainable growth rate is the maximum growth rate a firm can achieve without needing external funds, meaning at this growth rate, the AFN is zero. If a firm attempts to grow at a rate exceeding this sustainable growth rate, it will require additional external capital, as internally generated funds will be insufficient to support the increased asset base required for higher sales .

Expected changes in customer payment behavior, such as quicker payments, would reduce the Days Sales Outstanding (DSO), improving liquidity and the cash conversion cycle. Improvements in inventory systems leading to higher inventory turnover would signify more efficient inventory management, lowering holding costs and potentially enhancing profitability. These changes can improve the firm's current ratio and overall profitability metrics, while also impacting asset utilization ratios like inventory turnover .

A firm's strategic plan, encapsulated through the mission statement, corporate scope, and objectives, sets the long-term goals and directions for the company. This strategic framework informs the financial plan by providing the basis for assumptions, projected financial statements, and ratios, which are necessary for tying together the broader financial planning process. The financial plan translates strategic goals into actionable financial projections, ensuring that objectives are met through operational and capital allocation strategies .

Maintaining a higher dividend payout ratio would increase the firm's Additional Funds Needed (AFN) because fewer earnings are retained, reducing the funds available internally for reinvestment in the business. Consequently, the shortfall in financing would need to be addressed by seeking more external capital to meet the firm's investment needs .

Operating at less than full capacity in the previous year implies that some assets were underutilized, allowing the firm to support a certain level of increased sales without needing additional fixed asset investments. This can result in lower capital requirements compared to a scenario where the firm was already at full capacity, thus potentially reducing the need to finance further asset expansion for the current year's sales projections .

A firm's preliminary financial forecast often assumes operating at full capacity and proportional growth in assets, payables, and accruals relative to sales, maintaining historical profit margins and payout ratios. These assumptions impact forecast accuracy as deviations from expected capacity utilization or growth patterns could lead to discrepancies in predictions. Rigid assumptions may not accommodate unexpected market shifts, affecting the reliability of the forecasted financial outcomes. Such assumptions need to be flexible and updated with changes to ensure more accurate financial planning .

Extending trade credit terms increases the spontaneous liabilities (L*/S0 term) in the AFN equation, effectively reducing the Additional Funds Needed (AFN) as suppliers provide more capital. This reduction in AFN suggests that the firm is less reliant on external financing, allowing it to focus financial strategies on optimizing internal operations and potentially taking on less debt, enhancing long-term financial stability .

You might also like