Financial Management Chapter 9
Financial Management Chapter 9
Financial Management Chapter 9
ℂℍ𝔸ℙ𝕋𝔼ℝ 𝟡
𝔽𝕆ℝ 𝕊𝕋ℝ𝔸𝕋𝔼𝔾𝕀ℂ 𝔾ℝ𝕆𝕎𝕋ℍ 𝔽𝕀ℕ𝔸ℕℂ𝕀𝔸𝕃 𝔽𝕆ℝ𝔼ℂ𝔸𝕊𝕋𝕀ℕ𝔾
✎ Expected Learning Outcomes
After studying Chapter 9, you should able to:
1. Understand the concept and perspective of financial planning.
2. Explain the benefits that can be derived from financial planning.
3. Know the elements of a basic financial planning model.
4. Understand the determinants of a firm’s growth rates.
5. Know and apply the financial planning process using the Projected
Financial Statement Method (Percent of Sales Method).
INTRODUCTION
As discussed in the earlier chapters, the appropriate goal is for the financial
manager is increasing the market value of the owner’s equity and not just
growth by itself. If the firm is successful in doing this then growth will
usually result. Growth may thus be a desirable consequence of good decision
making but it is not an end unto itself. However, while growth rate is used in
the planning process, it is considered a convenient means if summarizing
Among the more significant benefits of derived from financial planning are
the following.
1. Provides a rational way of planning options or alternatives.
The financial plan allows the firm to develop, analyse and compare many
different business scenarios in an organized and consisted way. Various
investment and financing options can be explored, and their impact on the
firm’s shareholders can be evaluated. Questions concerning the firm’s future
lines of business and optimal financing arrangements are addressed.
Options such as introducing new products or closing plants might be
evaluated.
and its available financing choices. For example, if the firm is planning on
expanding or undertaking new investments and projects, all other relevant
variables such as source, terms and timing of financing are thoroughly
examined.
Financial planning process will differ from firm to firm, just as companies
differ in size and products. However, basic financial planning model will have
the following common elements; (a) economic environment assumptions, (b)
sales forecast, (c) pro forma statements, (d) asset requirements, (e) financial
requirement, and (f) additional funds needed.
Oftentimes, the sales forecast will be given as the growth rate in sales rather
than as an explicit sales figure. Perfect sales forecast is not possible, of
course, because sales depend on the uncertain future state of the economy.
To come up with its projections, firms could consult with some businesses
which specialize in macroeconomic and industry projections. Also,
evaluating alternative scenarios does not require sales forecast to be very
accurate because the financial planner’s goal is to examine the interplay
between investment and financing needs at different possible sales level, not
to pinpoint what we expect to happen.
6. Additional Funds Needed (AFN). After the firm has a sales forecast
and an estimate of the required spending on assets, some amount of
new financing will often be necessary because projected total assets
will exceed projected total liabilities and equity. In other words, the
statement of financial position will no longer balance.
Because new financing may be necessary to cover all the projected capital
spending, a financial “plug” variable must be selected. The plug is the
designated source(s) of external financing needed to deal with any shortfall
(or surplus) in financing and thereby bring the statement of financial
position into balance.
Once the “base-case” forecasted statements and ratios have been prepared,
top managers will ask questions such as:
Are the forecasted results as good as we can realistically expect, and if not,
how might we change our operating plans to produce better earnings and a
higher stock price?
How sure are we that we will be able to achieve the projected results? For
example, if our base-case forecast assumes a reasonably strong economy but
a recession occurs, would we be better off under an alternative operating
plan?
The additional financing needed will be raised by borrowing from the bank
as notes payable, by issuing long-term bonds, by selling new common stock
or by some combination of these actions.
The additional financing needed will be raised by borrowing from the bank
as notes payable, by issuing long-term bonds, by selling new common stock
or by some combination of these actions.
Apply the iteration process using the available financing mix until the AFN
would become so small that the forecast can be considered complete.
Income Statement
Sales ₱2,000,000
Cost of sales 1,200,000
Gross Profit 800,000
Operating expenses 380,000
Earnings before interests and 420,000
taxes 70,000
Interest expenses 350,000
Earnings before taxes 122,000
Taxes (35%) ₱227,500
Earnings after taxes ₱136,500
Dividends
Solution:
Step 1. Forecast the Income Statement.
The projected income statement will show the following:
Sales ₱2,400,000
Cost of sales 1,440,000
Gross profit ₱960,000
Operating expenses 456,000
Earnings before interests and ₱504,000
taxes 70,000
Interest expenses ₱434,000
Earnings before taxes 151,900
Taxes (35%) ₱282,100
Earnings after taxes ₱101,600
Dividends (36%) payment
Assets
Cash (1 ₱60,000
Account receivable ) 480,000
Inventory (2 900,000
Current assets ) 140,000
Fixed assets (net) (3 800,000
Total assets ) ₱2,240,000
(4
)
Supporting computations:
1. Cash = 2.5% x P 2.4M sales.
2. Accounts receivable = 20% of 2.4M sales
3. Inventory = 37.5% x 2.4M
4. No percentages are computed for fixed assets, notes payable, long-
term debt, ordinary shares and retained earnings because they are not
assumed to maintain a direct relationship with sales volume. For
simplicity, depreciation is explicitly considered.
5. Accounts payable = 12.5% of P2.4M
6. Accrued expenses = 0.5% of P2.4M
7. Accrued expenses = 1% of P2.4M
8. Retained earnings = P300,000 + P282,100 – P101,600
Formula Method:
*Additional financing needed (AFN) may also be computed as follows:
Additional funds needed = Required increased in assets – Spontaneous
increased in liabilities – Increased in retained earnings
Where;
Tamarind Company
Income Statement
Year 2014
(Thousands of Pesos)
Sales ₱ 6,000
Operating costs (inclusive of ₱200 5,432
depreciation) 588
Earnings before interest and taxes 176
Less interest expense 392
Earnings before taxes 157
Taxes (40%) 235
Net income before preference dividend 8
Dividend to preference ₱ 227
Net income available to ordinary ₱ 114
Dividends to ordinary
Tamarind Company
Statement of Financial Position
December 31, 2014
(Thousands of Pesos)
Assets
Cash ₱ 20
Account receivable 750
Inventories 1,230
Total current assets ₱ 2,000
Net plant and 2,000
equipment ₱ 4,000
Total assets
Year Sales
20x0 ₱ 4,116
20x1 5,068
20x2 4,944
20x3 5,700
20x4 6,000
20x5 6,000 (projected*)
REQUIRED:
I. Construct the pro forma financial statements using the projected financial
statement method. How much additional capital will be required? Assume
the firm operated at full capacity in year 2014. Do not include financing
feedback.
Solution:
Based on the data and assumptions given, the following projections are
made, and the additional financing needed determined.
Figure 9.1
Projected Income Statement (First Pass)
(Thousands of Pesos)
2015 Forecast
Actual Basis First Pass
Sales ₱6,000 110 % ₱6,000
Operating costs (inclusive of ₱200 depreciation) 5,432 110 % 5,975
Earnings before interest and taxes) 568 625
Less: interest expense 176 110 % 176
Earning before taxes 392 449
Taxes (40%) 157 180
Net income before preference dividend 235 269
Dividends to preference 8 8
Net income available to ordinary ₱227 ₱261
Dividends to ordinary 116 125
Addition to retain earnings 136
Figure 9.2
Projected Financial of Statement Position (First Pass)
(Thousand of Pesos)
2015 Forecast
Actual Basis First Pass
Assets
Cash ₱20 110 % ₱22
Account Receivable 750 110 % 825
Inventories 1,230 110 % 1,353
Total current assets ₱2,000 2,400
Net plant and equipment 2,000 110 % ₱4,400
Total assets ₱4,000
Liabilities and equity 110 % ₱132
Accounts Payable ₱120 110 % 220
Notes Payable 220 308
Accruals 280 ₱660
Total current liabilities 620 1,508
Long-term bonds 1,508 ₱2,168
Total liabilities ₱2,128 ₱80
Preference shares ₱80 260
Ordinary shares (50,000 shares) 260 + 136 1,668
Retained Earnings 1,532 ₱2,008
Total equity ₱1,872 ₱4,176
Total Liabilities and Equity ₱4,000
DISCUSSION:
Figure 9-1 shows Tamarind’s actual 2014 and forecasted 2015 income
statement. For year 2015 earnings before interest and taxes are projected at
₱625,000 and earnings after taxes of ₱269,000. Dividends to preference
shares and ordinary shares are projected at ₱8,000 and ₱125,000,
respectively.
Figure 9-2 contains Tamarind’s 2014 actual and projected 2015 statements
of financial position. Total assets are projected at ₱4,400,000 while the
forecasted liability and equity accounts total to only ₱4,176,000. Since the
resources or assets requires to support the higher shares level exceed the
available sources, it means that additional funds will have to be obtained.
The AFN of ₱224,000 will be raised by borrowing from the bank as notes
payable or by issuing long-term bonds or by selling new ordinary shares, or
by some combination of these actions.
II. Assume that after considering all the relevant factors, Tamarind decided
on the following funds financing mix to raise the AFN of ₱224,000:
Solution:
Figure 9.3
Project Income Statement (Second Pass)
For 2015
2014 2015 Forecast
Actual First Pass Feedback Second Pass
Sales ₱6,000 ₱6,000 ₱6,600
Operating Costs
(inclusive of ₱200 depreciation) 5,232 5,975 5,925
Earnings before interest and taxes 568 625 625
Lest: Interest expense - 176 176 +6 186
Earnings before taxes 392 449 439
Taxes (40%) 157 180 -4 176
Net income before preference 235 269 263
dividend 8 8 8
Dividends to preference ₱227 ₱261 ₱255
Net income available to ordinary 116 125 +6 131
Dividends to ordinary 136 124
Figure 9.4
Projected Statement of Financial Position (Second Pass)
Thousands of Pesos
2014 2015 Forecast
Actual First Pass Feedback Second Pass
Assets
Cash ₱20 ₱22 ₱22
Account Receivable 750 825 825
Inventories 1,230 1,353 1,353
Total Current Assets ₱2,000 ₱2,000 ₱2,000
Net plant and equipment 2,000 2,000 2,000
Total assets ₱4,000 ₱4,000 ₱4,000
In Figure 9-4 the second pass 2015 Statement of Financial Position shows
that a shortfall of ₱12,000 will still exist as a result of financing feedback
effects due to the additional interest (net of taxes) and dividend payments
that reduced the projected retained earnings. This amount raises the
cumulative AFN from ₱224,000 to ₱236,000.
If additional iterations are done (9.e., 3rd, 4th, 5th, etc.), the additional
financing needed would become smaller and smaller until the forecast would
be considered to be completed. Making a spreadsheet using Lotus 1-2-3 or
some other program can facilitate the iteration process and arrive at the final
forecast.
Next year’s forecast as developed above is only the first part of total
forecasting process. Forecasting is an iterative process, both in the way the
financial statements are generated and in the way the financial plan is
developed. For planning purposes, the consultant or financial staff develops
a preliminary forecast based on a combination of past policies and trends.
This will serve as a starting point or “baseline” forecast. The model is then
modified to see what effects alternative operating plans would have on the
firm’s earnings and financial condition. Likewise, alternative operating plans
are examined under different sales growth rate scenarios and linked to the
firm’s dividend policy and capital structure decisions. The revised forecast or
model can also be used to analyse alternative working capital policies.