9.6 The EFN Formula Explained

The EFN Formula Explained

You will observe that the EFN formula has three parts (separated by two minus signs).

EFN = [(A0/S0ΔS)]    –    [(AP0/S0ΔS]    –    [(M0) (S1) (RR0)]

The first part represents the required increase in total assets [(A0/S0ΔS)] needed to sustain the projected sales increase. Last year, assets equal to A0 were required by the firm to sustain a sales level equal to S0.Hence, we formulate the ratio A0/S0. Assuming this ratio remains static, next year, the firm will require so much more in assets; this is arrived at by multiplying the ratio by ΔS, the projected sales increaseΔS = S1 – S0.

However, some of this “gross requirement will be spontaneously” or “automatically” met by the normal business generation of internal funds in the manner of spontaneous liabilities, by which we primarily refer to accounts payable (not notes payable or the current portion of long-term debt payable). Last year, such internal funds represented a certain percentage of sales: (A0/S0). If we multiply this dollar figure by the projected sales increase (ΔS), we may see to what extent spontaneous liabilities reduce the original “gross requirement.

Finally, the firm will also – hopefully – generate and retain some of its earnings, thereby further reducing its “gross requirement. If we take the firms net profit margin (NI/S = M0and multiply it by next year’s sales (S1), we get next year’s projected net profits: (M0) (S1) = NI1If we the net profit margin (i.e., M0= NI/S) times next year’s sales, we get next year’s net profits. If we further multiply this by the firm’s retention rate (RR0), we get the firm’s projected retained earnings.

After all is said and done, we have a figure – the dollar amount of EFN – that enables the firm to plan for next year’s acquisition of external financing, and hence increased asset levels in support of the planned sales increase. Interestingly, this formula does not instruct us relative to the extent to which the external requirement should be met by either debt or equity, and in what Debt-to-Equity proportion. 

Note:

For simplicity of presentation only, below we will ignore the “rule” of using an average balance sheet datum when concocting mixed ratios (i.e., those that include both balance sheet and income statement data). This simplification is in addition to the static analysis already assumed.

Some useful formulae:

  • ΔS = S1 – S0
  • M0 = NI / S
  • RR = (NI – D) / NI = A.R.E. / NI = 1 – PR

 

License

Icon for the Creative Commons Attribution 4.0 International License

Introduction to Financial Analysis Copyright © 2022 by Kenneth S. Bigel is licensed under a Creative Commons Attribution 4.0 International License, except where otherwise noted.

Share This Book