Financial Analysis: Liquidity & Solvency
Financial Analysis: Liquidity & Solvency
[Link]
3. Financial Analysis
[Link]
Liquidity
➢ Liquidity - Ability to convert assets into cash or to
obtain cash to meet short-term obligations
[Link]
Liquidity
• Current Assets - Cash and other assets reasonably expected to be (1)
realized in cash, or (2) sold or consumed, during the longer of one-
year or the operating cycle
• Current Liabilities - Obligations to be satisfied within a relatively short
period, usually a year
• Current Ratio – Current Assets/Current Liabilities
• Relevant measure of current liability coverage, buffer against
losses and reserve of liquid funds
• Limitations – A static measure
[Link]
Working Capital
O Indicador Fundo de Maneio (FM)
• Static definition
Investment point of view: the excess of current
assets over current liabilities
[Link]
Comment on the following statement/Comente a
seguinte afirmação:
[Link]
Working capital requirements
Necessidades de Fundo de Maneio (NFM) ou FM necessário
• Dynamic definition:
Working capital requirements – amount of money tied up
in the operating cycle that has to be funded and can
significantly drain the resources required for investment in
assets
• Receivables + Inventories - Payables
• It is necessary to study the operating cycle of a company
to know its working capital requirements/needs
• depend on the type and volume of business
[Link]
Operating cycle
[Link]
Net Trade Cycle (Ciclo de Caixa)
or Cash Conversion Cycle
Payable Days Net trade cycle
Goods Payment to
purchase suppliers
[Link]
Net Trade Cycle (Ciclo de Caixa)
or Cash Conversion Cycle
• Example 1
• Inventory Days = 78
• Receivable Days = 60
• Payable Days = 15
[Link]
Net Trade Cycle (Ciclo de Caixa)
or Cash Conversion Cycle
• Example 2
• Inventory Days = 15
• Receivable Days = 0
• Payable Days = 45
Net trade cycle = ?
Conclusion about Working capital requirements:
________________________________________________
________________________________________________
[Link]
12
[Link]
13
[Link]
How to compute Working capital
requirements?
I) Indirect method (Using net trade cycle)
3) Compute Working capital requirements
Working capital requirements =
Net trade cycle in days of sales*Sales/365
[Link]
How to compute Working capital
requirements?
II) Direct method
• This method consists in obtaining working capital requirements
from the Functional Balance Sheet (Balanço Funcional)
• The Functional Balance sheet is an adjusted balance sheet
that presents the assets and sources of financing according
to the different financial cycles of the company
• The financial cycles are the financial result of the decisions
made at different levels: strategic decisions, operating
decisions and financial decisions,...
[Link]
Functional Balance Sheet
The financial cycles
• Three type of financial cycles:
• Investment cycle (Ciclo de Investimento)
• Operating cycle (Ciclo de Exploração)
• Financing cycle (Ciclo de Operações Financeiras)
• Long-term financing (Ciclo de Operações de Capital)
• Short-term financing (Ciclo de Operações de Tesouraria)
[Link]
Functional Balance Sheet
The Financial cycles
• The functional balance sheet obtained is:
CYCLE INVESTMENTS FINANCING CYCLE
17 [Link]
Functional Balance Sheet
N N+1
1) Shareholders' Equity
2) Long-term or stable liabilities
3) Long-term or stable financing (1+2)
4) Non-current Assets
5) Working Capital (3-4)
6) Inventories
7) Accounts Receivable
8) Other operating receivables
…
9) Operating current assets (6+7+8+…)
10) Accounts Payable
11) Other operating payables
…
12) Operating current liabilities (10+11+…)
13) Working capital requirements (9 -12)
14) NET LIQUIDITY (5-13)
[Link]
Functional Balance Sheet
• Net Liquidity = Financial resources – Financing Needs
• Working Capital = Long-term financing – Non-current assets
• Working capital requirements = Operating current assets-
operating current liabilities
• Then
Net Liquidity = Working Capital – Working Capital Requirements
The Fundamental Treasury Relation
19 [Link]
Net Liquidity
(+) Working Capital (-)
requirements
(c) NL > 0
(e) NL > 0
(d) NL > 0
(f) NL< 0
Source: Adapted from Moreira, 1997, p.150
20
[Link]
Functional Balance Sheet
Limitations
• Critics to the functional balance sheet:
21 [Link]
Liquidity ratios
• Ratios that compare current assets with current
liabilities:
• Current ratio (Rácio Liquidez Geral)
• Quick ratio or Acid-test ratio (Rácio Liquidez Reduzida)
• Cash-to-current liabilities ratio (Rácio Liquidez Imediata)
[Link]
Operating Activity Analysis of Liquidity
[Link]
Operating Activity Analysis of Liquidity
• Measures the average rate of speed at which inventories move through and
out of a company.
[Link]
Operating Activity Analysis of Liquidity
• Overcomes the static nature of the current ratio since its numerator reflects a flow
variable.
• Financial flexibility - Ability to take steps to counter unexpected
interruptions in the flow of funds
• Ability to borrow from various sources; to raise equity capital; to sell and
redeploy assets; to adjust the level and direction of operations to meet
changing circumstances; levels of prearranged financing and open lines of
credit
[Link]
Solvency Analysis
[Link]
Solvency Analysis
[Link]
Capital Structure Analysis
• Shareholders’ Equity vs Debt
• Equity financing
• Risk capital of a company
• Uncertain and unspecified return
• Lack of any repayment pattern
• Contributes to a company’s stability and solvency
• Debt financing
• Must be repaid with interest
• Specified repayment pattern
[Link]
Capital Structure Analysis
• Motivation for Debt:
• From a shareholder’s perspective, debt is a preferred
external financing source:
• Interest on most debt is fixed and if interest cost is
less than the generated return, the excess return
is to the benefit of equity investors
• Interest is a tax-deductible expense
• Financial leverage - the amount of debt financing in a
company’s capital structure
[Link]
Solvency Ratios
[Link]
Solvency Ratios
• Capital structure ratios
• Shareholders’ equity to total assets ratio (Autonomia
Financeira) = Shareholders’ Equity/Total Assets
• Long-term financing to non-current assets ratio
(Cobertura do Imobilizado) = Long-term
financing/Non-current assets
• Earnings coverage ratios
• Interest coverage ratio (Cobertura dos Encargos
Financeiros) = EBIT/Interest Expense
• ...
[Link]
Solvency Ratios
[Link]
Loss and Recovering of Solvency
• When does a company become insolvent?
• When a company cannot meet its current liabilities (as
they come due), when it does not have liquidity and its
financial structure does not allow its recovering
• How is insolvency detected?
• A gradual and systematic detioration of the solvency
ratios reflecting a situation in which a company is
increasingly dependent on its creditors
[Link]
Loss and Recovering of Solvency
[Link]
Loss and Recovering of Solvency
• An insolvent company may be recovered if it is possible to
restore its financial equilibrium in the future
[Link]
Loss and Recovering of Solvency
• Financial Restructuring Measures (medidas de saneamento
financeiro ou de consolidação financeira e reestruturação
empresarial)
• Consolidation of liabilities (Consolidação do Passivo):
creditors’ agreement to extend payment deadlines (short-
term debts become long-term debts);
• Transformation of debt into equity (Transformação das
dívidas em capital): creditors’ agreement in which some
creditors become shareholders;
[Link]
Loss and Recovering of Solvency
[Link]
Loss and Recovering of Solvency
• Portuguese legislation:
• D.L. 132/93
• D.L. 315/98
• D.L. 53/2004 de 18 de Março (CIRE - Código de Insolvência e
Recuperação de Empresas)
• Lei nº 16/2012 de 20 Abril established processo especial de
revitalização
[Link]
[Link]
Bibliography:
- Subramanyam (2014). Financial Statement Analysis,
McGraw-Hill International Edition (chapter 10)
- Neves, J. C. (2012). Análise e Relato Financeiro – um visão
integrada de gestão, Texto Editores (Parte III – Solidez
financeira e equilíbrio financeiro, cap. 9, 10 e 11)
[Link]
3. Financial Analysis
[Link]
The concept of Cash-Flow
• Cash Flow (fluxo de caixa): difference between cash inflows/cash
receipts and cash outflows/cash disbursements.
• Alternative Cash Flow Measures:
1) Statement of Cash Flows
• reports cash receipts and cash payments by operating, financing, and
investing activities
• Cash flow analysis helps in assessing liquidity, solvency, and financial
flexibility.
[Link]
The concept of Cash-Flow
2) Net income plus depreciation and amortization
• Based on the Income Statement:
Earnings before income tax expense
+ Depreciation, Amortization and Impairments
(losses/reversals)
+/- Provisions (Increases/decreases)
+/- Decreases/Increases in Fair Value
= Gross Cash Flow
- Income tax expense
= Net Cash Flow
• EBITDA (Earnings before interest, taxes, depreciation, and
amortization)
[Link]
The concept of Cash-Flow
Issues with Net Income plus depreciation & amortization
• The using up of long-term depreciable assets is a real expense
that must not be ignored
• The add-back of depreciation expense does not generate cash.
It merely zeros out the noncash expense from net income.
Cash is provided by operating and financing activities, not by
depreciation
• Net income plus depreciation ignores changes in working
capital accounts that comprise the remainder of net cash
flows from operating activities. Yet changes in working
capital accounts often comprise a large portion of cash
flows from operating activities
[Link]
Cash-Flow vs Self-financing
Self-financing (Autofinanciamento): the financing that
is generated by the company and is obtained by
retained earnings
Earnings before Income tax expense
+ Depreciation, Amortization and Impairments
(losses/reversals)
+/- Provisions (Increases/decreases)
+/- Decreases/increases in Fair Value
- Income tax expense
- Dividends payable
= Self-financing
Thus, self-financing is a portion of the Cash Flow
[Link]
Self-financing
[Link]
Self-financing
[Link]
Statement of Cash Flows
Demonstração de Fluxos de Caixa (DFC)
[Link]
Statement of Cash Flows
• Operating activities: are the earning-related activities of a
company. They include the net inflows and outflows of cash
resulting from related operating activities like extending
credit to customers, investing in inventories, and obtaining
credit from suppliers
• Investing activities: are means of acquiring and disposing of
noncash assets. These activities involve assets expected to
generate income for a company such as purchases and sales
of PPE and investment in securities. They also include other
non-current assets such as lending funds and collecting the
principal on these loans
50 [Link]
Statement of Cash Flows
51 [Link]
Statement of Cash Flows
• Methods for reporting cash flows from operations:
• Direct method: each income item is adjusted for its
related accruals.
• Indirect method: net income is adjusted for noncash
income (expense) items and accruals to yield cash flows
from operations. An advantage is the disclosure of a
reconciliation of differences between net income and
operating cash flows that may aid some users to predict
cash flows
• The format for computing net cash provided by
investing and financing activities is the same for both
methods. Only the presentation of net cash flows from
operations differs.
52 [Link]
Statement of Cash Flows
• Indirect method
53 [Link]
Statement of Cash Flows
57 [Link]
[Link]
Statement of Cash Flows
Implications to financial analysis
Interpreting Cash Flows and Net Income
• An Income Statement records revenues when earned and
expenses Limitations in Cash Flow Reporting
when incurred
– It does not show the timing of cash inflows and outflows, nor the effect
of operations on liquidity and solvency
– This information is available in the Statement of Cash Flows
• Cash flows from operations (CFO) is a broader view of
operating activities than is net income
– It is not a measure of profitability
• Note: A net measure, be it net income or cash flows from
operations, is of limited usefulness. The key is information
about components of these net measures.
[Link]
Statement of Cash Flows
Implications to financial analysis
• In evaluating sources and uses of cash, the analyst should
focus on questions like:
✓Are asset replacements financed from internal or external
funds?
✓What are the financing sources of expansion and business
acquisitions?
✓Is the company dependent on external financing?
✓What are the company’s investing demands and opportunities?
✓What are the requirements and types of financing?
✓Are managerial policies (such as dividends) highly sensitive to
cash flows?
✓…
60 [Link]
Statement of Cash Flows
Implications to financial analysis
[Link]
Statement of Cash Flows
Implications to financial analysis
Limitations in Cash Flow Reporting
• Some limitations of the current reporting of cash flow:
• Practice does not require separate disclosure of cash
flows pertaining to either extraordinary items or
discontinued operations
• Income taxes are classified as operating cash flows
• Removal of pre-tax (rather than after-tax) gains or losses
on sale of plant or investments from operating activities
distorts our analysis of both operating and investing
activities (this is because their related taxes are left in
total tax expense among operating activities)
62 [Link]
Statement of Cash Flows
Demonstração de Fluxos de Caixa
Método Directo Método Indirecto
Actividades Operacionais: Actividades Operacionais:
Alternative model Recebimentos de Clientes Resultados Operacionais
suggested by Neves Outros Recebimentos Operacionais
Pagamentos a Fornecedores
+ Amortizações do exercício
+ Provisões do exercício
(2012, p. 209) Pagamentos ao Pessoal - Acréscimos das NFM
Outros Pagamentos Operacionais - Investimentos de substituição
Investimentos de substituição
Fluxos de caixa operacional (1) Fluxos de caixa operacional (1)
Actividades Compulsivas:
Encargos financeiros
Recebimentos/pagamentos extraordinários
Imposto sobre lucros
Fluxos de caixa compulsivos e extraordinários (2)
Meios disponíveis para decisões estratégicas
(3=1+2)
Investimentos de expansão (4)
Meios libertos pelo negócio (5=3-4)
Investimentos de diversificação (6)
Meios disponíveis para accionistas e credores
(7=5-6)
Fluxos de financiamento estável (8)
Meios libertos líquidos (9=7-8)
Fluxos de financiamento curto prazo (10)
Variação dos depósitos bancários e caixa
(11= 9-10)
63 [Link]
Bibliography:
- Subramanyam (2014). Financial Statement Analysis,
McGraw-Hill International Edition (Chapter 7)
- Neves, J. C. (2012). Análise e Relato Financeiro – uma visão
integrada de gestão, Texto Editores (Parte III – Solidez
financeira e equilíbrio financeiro, cap. 7 e 12)
[Link]
3. Financial Analysis
[Link]
Profitability Analysis
• Aim of Profitability Analysis/Economic Analysis:
• To analyze the economic efficiency of a company - its
ability to generate earnings to meet the claims of all the
entities with whom the company interact (customers,
suppliers, creditors, shareholders, employees,...)
• It includes the profitability analysis and productivity
analysis
[Link]
Profitability Analysis
[Link]
Profitability Analysis
[Link]
Profitability Analysis
Return on Assets (ROA)
[Link]
Profitability Analysis
Return on Assets (ROA)
[Link]
Profitability Analysis
Decomposing ROA
ROA is affected both by the Profit Margin (ROS) and the Assets
Turnover
[Link]
Question: In the table below you have the Assets
Turnover and the Return on Sales ratios of two
companies: one is a food retailing company and the
other is an oil and gas exploration company. Identify
each of the companies and justify your choice.
Company Company
Ratios A B
[Link]
74
Profitability Analysis
Return on Equity (or Financial return)
Return on Equity or ROE (Rendibilidade dos capitais
próprios)
= Net Income/Shareholders’ Equity
• This ratio measures the efficiency with which the
company uses Shareholders’ capital
• As higher the ROE, the more attractive is the
company for potential investors and the greater the
likelihood of the company to develop its future
activities with recourse to self-financing
[Link]
Profitability Analysis
Decomposing ROE
[Link]
Profitability Analysis
Decomposing ROE
• The relationship between the different return measures (Dupont analysis):
[Link]
Profitability Analysis
Decomposing ROE
• Other alternative decompositions
Additive model:
𝐷
𝑅𝑂𝐸 = 𝑂𝑝𝑒𝑟𝑎𝑡𝑖𝑛𝑔 𝑅𝑂𝐴 + × 𝑂𝑝𝑒𝑟𝑎𝑡𝑖𝑛𝑔 𝑅𝑂𝐴 − 𝐼𝑛𝑡𝑒𝑟𝑒𝑠𝑡 × 1−𝑡
𝐸
Multiplicative method:
𝐸𝐵𝐼𝑇 𝑆𝑎𝑙𝑒𝑠 𝐴𝑠𝑠𝑒𝑡𝑠 𝐸𝐵𝑇 𝑁𝐼
ROE = × × × ×
𝑆𝑎𝑙𝑒𝑠 𝐴𝑠𝑠𝑒𝑡𝑠 𝐸𝑞𝑢𝑖𝑡𝑦 𝐸𝐵𝐼𝑇 𝐸𝐵𝑇
[Link]
Profitability Analysis
Financial leverage
• The Financial Leverage Effect: is the positive or negative
effect of financial leverage on the ROE. Considering
ROA=NI+[Interest Expenses*(1-t)]/Assets and assuming there
is no income tax:
• ROE > ROA, the financial leverage effect is ______________
• ROE < ROA, the financial leverage effect is ______________
• ROE = ROA, the financial leverage effect is ______________.
[Link]
Profitability Analysis
Financial leverage
• Ex.: Company A
[Link]
Profitability Analysis
Financial leverage
1) ROA = NI+[Interest Expenses*(1-t)]/Assets=
(1200+1395)/20000 = 12.975%
2) Average cost of Debt
= Interest Expense/Debt = 1395/15000 = 9.3%
• The average cost of debt is 9.3% while the operating ROA is
almost 13%.
• As ROA > cost of debt the Financial Leverage Effect is positive.
3) ROE = Net Income/Equity = 1200/5000 = 24%
•Comparing ROE with ROA we reach the same conclusion
•ROE > ROA the Financial Leverage Effect is positive.
[Link]
81
Profitability Analysis
Financial leverage
[Link]
82
Profitability Analysis
Financial leverage
• Ex.: Company B
Total Assets = 15000 €
Equity = 5000 €
Debt = 10000 €
Net Income= 600 €
Interest Expense 1500 €
1) ROA = NI+[Interest Expenses*(1-t)]/Total Assets
= (600 + 1500)/15000 = 14%
[Link]
Profitability Analysis
Financial leverage
84 [Link]
Productivity Analysis
85
[Link]
Productivity Analysis
• Two alternative methods of computation:
• Production approach (subtractive method)
86 [Link]
Productivity Analysis
• Income approach (additive method)
Gross Value Added= Income earned by the production of goods and services
+ Direct taxes (except Income tax)
+ Personnel Costs
+ Impairment losses
+ Provisions
• The Gross Value Added is used to pay
+ Deprectation and Amortization
employees, creditors, the State and to
+ other operating costs
ensure the company’s maintenance and
+ Interest Expense
growth..
- Other operating revenues
- Interest Income
+ Income Tax
+ Net Income
+…
= Gross value added
87 [Link]
Productivity Analysis
• Productivity ratios
• Labor Productivity (Produtividade do trabalho)
= Gross Value Added/Nº of employees
= Gross Value Added/Personnel Costs
88 [Link]
Risk Analysis
Business Risk or Operational Risk (Risco de negócio ou
risco operacional)
89 [Link]
Business Risk
Break-even sales point
• Break-even point (sales unit):
Q0 * SP1 - Q0 * VC1 - FC = 0 Q0 (SP1 –VC1) = FC
Q0 = FC / (SP1– VC1)
90
[Link]
Business Risk
• Margin of Safety (MoS)
(Q * SP1 )
MS = −1
(Q 0 * SP1 )
91 [Link]
“The break-even sales point should be a
company’s profitability and risk target”
92
[Link]
Risk Analysis
Financial risk
[Link]
Bibliography:
- Subramanyam (2014). Financial Statement Analysis,
McGraw-Hill International Edition (Chapter 8).
- Neves, J. C. Análise e Relato Financeiro – um visão
integrada de gestão, Texto Editores (Parte IV – Eficiência e
rendibilidade, cap. 13, 14, 15 e 16 e Parte V – Risco, cap.
18)
94 [Link]