Financial Statement and Cash-Flow Analysis

Introduction

Credit decisions depend less on reported profit alone than on a borrower’s ability to generate cash in the amount and at the time required to service debt. Financial statement analysis converts accounting information into evidence about liquidity, operating efficiency, leverage, profitability, financial resilience and repayment capacity.

A lender should therefore analyze the balance sheet, income statement, statement of cash flows and accompanying notes as an integrated system. Historical analysis explains how the business has performed; projections test whether future cash generation can support proposed and existing obligations. Because accounting policies and managerial estimates affect reported figures, quantitative analysis must be combined with an assessment of earnings quality and financial reporting integrity.

Learning Objectives

After studying this chapter, students should be able to:

1. explain the relationships among the principal financial statements;
2. perform horizontal, trend and common-size analysis;
3. calculate and interpret liquidity, efficiency, leverage, profitability and debt-service ratios;
4. analyze working capital and the cash conversion cycle;
5. distinguish profit, cash flow from operations and cash available for debt service;
6. prepare and interpret a short-term cash budget and funds-flow analysis;
7. identify accounting distortions and normalize reported results; and
8. evaluate repayment capacity using historical and projected cash flows.

1. The Integrated Financial Statement Framework

1.1 Balance sheet

The balance sheet reports financial position at a specific date. Its governing identity is:

Assets represent controlled economic resources. Liabilities are present obligations, while equity is the residual interest after deducting liabilities from assets.

For credit analysis, classification and realizability matter. Trade receivables may be legally current but economically weak if overdue or disputed. Inventory may have a recorded value that cannot be realized quickly. Similarly, related-party loans classified as assets may not provide usable liquidity.

1.2 Income statement

The income statement reports revenue, expenses and profit over a period. A simplified structure is:

EBITDA is earnings before interest, taxes, depreciation and amortization. It is not cash flow because it excludes working-capital movements, taxes, capital expenditure and other cash items.

1.3 Statement of cash flows

The cash-flow statement classifies cash movements into:

• Operating activities: cash generated or used by core business operations;
• Investing activities: acquisition and disposal of long-term assets and investments; and
• Financing activities: borrowing, repayment, equity transactions and distributions.

The statements are linked through the cash reconciliation:

where CFO is cash flow from operating activities, CFI is cash flow from investing activities and CFF is cash flow from financing activities. All amounts must refer to the same reporting period and currency.

Figure: Integrated financial statement analysis for credit assessment.

2. Analytical Methods

2.1 Horizontal analysis

Horizontal analysis measures changes between periods:

The percentage formula is meaningful only when the base amount is non-zero and economically comparable. Negative or very small bases can produce misleading percentages.

2.2 Trend analysis

Trend analysis assigns the base year an index of 100:

If sales rise from 800 to 900, the sales trend index is 900 ÷ 800 × 100 = 112.5. Sales therefore increased by 12.5% relative to the base year.

Trend analysis is stronger when it covers several periods and controls for acquisitions, inflation, exchange-rate movements and changes in accounting policy.

2.3 Common-size analysis

A common-size income statement expresses each item as a percentage of revenue:

A common-size balance sheet normally expresses each item as a percentage of total assets:

Common-size analysis permits comparison between entities of different sizes. However, differences in industry, business model and accounting policy must still be considered.

3. Worked Financial Statement Analysis

Consider the following simplified statements for Meridian Manufacturing. Amounts are in currency units (CU millions).

3.1 Balance sheets

3.2 Income statements

Revenue increased by 12.5%, but EBITDA fell by 5%. EBITDA margin declined from 12.5% to 10.6%:

Growth has therefore not produced stronger operating profitability. The lender should investigate pricing pressure, input costs, operating inefficiency or an unfavorable product mix.

4. Ratio Analysis

Ratios should be interpreted against prior periods, forecasts, industry norms, loan covenants and the borrower’s business model. No ratio should be used mechanically.

4.1 Liquidity ratios

For 2024:

Assuming no marketable securities:

The current ratio exceeds one, but the quick ratio shows dependence on inventory conversion. Ratios also ignore timing: receivables due in 90 days cannot necessarily fund a debt payment tomorrow.

4.2 Efficiency ratios

When income-statement flows cover a full year, average balance-sheet amounts are generally preferable.

If purchases are unavailable, cost of goods sold is sometimes used as an approximation for payables days. This limitation must be disclosed.

For Meridian:

Using cost of goods sold as a disclosed approximation:

4.3 Leverage and coverage

Coverage above one indicates that EBIT exceeds accounting interest expense, but it does not prove that sufficient cash exists when payments fall due.

4.4 Profitability ratios

Meridian’s 2024 net margin is 31.5 ÷ 900 × 100 = 3.50%. Its return on average assets is:

Profitability supports repayment only when earnings are sustainable and convertible into cash.

5. Working-Capital Analysis

5.1 Net working capital

Meridian’s net working capital rose from CU90 million to CU108 million. This is not automatically favorable. The increase was driven partly by receivables and inventory, which absorbed cash.

For operating analysis, lenders often exclude cash and interest-bearing debt:

The exact components must be defined consistently. Typical operating assets are receivables and inventory; typical operating liabilities include trade payables and accrued operating expenses.

5.2 Cash conversion cycle

Using Meridian’s calculated values:

The cycle estimates the time for which cash is tied up between supplier payment and customer collection. A longer cycle usually increases financing requirements, although appropriate benchmarks vary by industry.

Seasonality can make year-end balances unrepresentative. Monthly or quarterly data, receivables aging, inventory aging and supplier terms provide stronger evidence than a single reporting date.

6. Cash-Flow Analysis

6.1 Direct and indirect methods

The direct method presents major operating cash receipts and payments. The indirect method begins with profit and reconciles it to CFO by adjusting for non-cash items and working-capital changes.

Meridian’s simplified indirect reconciliation is:

The signs reflect cash effects. An increase in an operating asset uses cash; an increase in an operating liability provides cash, subject to the quality and sustainability of that funding.

6.2 Capital expenditure

Where no disposals, acquisitions or revaluations occurred, capital expenditure can be estimated from net property, plant and equipment:

For Meridian:

This is a special-case reconstruction. If assets were sold, acquired through business combinations, leased, impaired or revalued, those movements must also be incorporated.

6.3 Free cash flow

A common simplified measure is:

For Meridian, free cash flow is 32.5 − 71 = −38.5 million. This measure includes growth expenditure and is therefore different from cash available after only maintenance capital expenditure.

6.4 Cash flow available for debt service

Cash flow available for debt service (CFADS) should represent cash generated before scheduled interest and principal payments. Definitions differ across institutions and loan agreements, so internal consistency is essential.

If reported CFO includes cash interest and income taxes, one possible reconciliation is:

Other adjustments may be required for exceptional receipts, non-operating cash flows or restricted cash. Income taxes should not be deducted again if they are already included in reported CFO. Under IFRS, classification choices for interest can differ; the analyst must inspect the cash-flow statement and notes.

A DSCR below 1.0 indicates that defined cash generation is insufficient for scheduled debt service. A ratio above 1.0 provides a margin, but the required margin depends on volatility, collateral, tenor and covenant terms.

7. Short-Term Cash Budgeting

Annual profitability can conceal a temporary cash shortage. A cash budget forecasts the timing of receipts and payments:

Consider a borrower with the following assumptions, in CU thousands:

• 20% of sales are collected in the month of sale and 80% in the following month.
• December sales were 100; January, February and March sales are 120, 160 and 180.
• Purchases are paid one month later. December purchases were 50; January and February purchases were 70 and 90.
• Other cash operating payments are 40, 50 and 67 for January to March.
• A principal payment of 25 is due in March.
• Opening January cash is 20, and minimum required cash is 20.

Collections are calculated as follows:

March closing cash is CU24 thousand. The business remains above its CU20 thousand minimum, but only by CU4 thousand. It therefore has no projected cash deficit under the stated assumptions, although its liquidity cushion is thin. A delay in collections or an unexpected payment could create a borrowing need.

Sensitivity testing improves the analysis. If only 70% rather than 80% of February sales were collected in March, March receipts would decline by CU16 thousand, reducing closing cash to CU8 thousand and creating a CU12 thousand shortfall against the minimum.

8. Funds-Flow Analysis

Traditional funds-flow analysis explains changes in net working capital between balance-sheet dates. Broader source-and-use analysis explains how long-term funds were generated and applied.

Typical sources include:

• operating funds generation;
• new long-term borrowing;
• new equity;
• asset disposals; and
• reductions in non-current assets.

Typical uses include:

• acquisition of fixed assets;
• debt repayment;
• dividends;
• investments; and
• increases in working capital.

For Meridian, net PPE rose by CU46 million after depreciation. The implied CU71 million capital expenditure exceeded CFO of CU32.5 million. The resulting gap helps explain the increase in interest-bearing debt and indicates reliance on external finance.

Funds-flow analysis is useful for strategic financing patterns, but the cash-flow statement is superior for identifying actual cash movements. Analysts should not treat increases in receivables or inventory as genuine cash sources merely because they increase accounting working capital.

9. Accounting Quality and Potential Distortions

Financial statements are shaped by recognition rules, estimates and managerial judgment. Credit analysis should distinguish sustainable economic performance from accounting presentation.

9.1 Common warning areas

9.2 Normalization

Normalized earnings remove items unlikely to recur or not reflecting normal operations:

Adjustments require evidence. A lender should avoid automatically excluding recurring “exceptional” costs, because repeated restructuring or litigation may be part of the borrower’s normal risk profile.

9.3 Red flags across statements

Important inconsistencies include:

• profit growing while CFO persistently declines;
• receivables increasing much faster than sales;
• inventory accumulation despite weak demand;
• heavy capital expenditure without corresponding capacity or revenue growth;
• repeated refinancing of short-term obligations;
• unexplained related-party balances; and
• significant differences between audited statements, tax returns and bank-account activity.

10. Forecasting Repayment Capacity

A forecast should integrate revenue, margins, working capital, capital expenditure, financing and taxes. Projected income statements without projected balance sheets and cash flows are incomplete.

A practical forecasting sequence is:

1. forecast sales volume, price and customer mix;
2. estimate operating costs and margins;
3. project receivables, inventory and payables using operating drivers;
4. estimate maintenance and growth capital expenditure;
5. calculate taxes and financing costs;
6. construct projected cash flows and closing balance sheets; and
7. test debt-service capacity under base and downside scenarios.

If receivables days are forecast at 45 days and annual credit sales at CU1,000 million, projected year-end receivables under a steady-sales approximation are:

This approximation is less reliable where sales are seasonal or growing rapidly. Monthly projections are then preferable.

Scenario and sensitivity analysis

A base case should represent the most supportable outcome, not an optimistic target. A downside case may include:

• reduced sales volume;
• lower gross margin;
• slower customer collections;
• inventory write-downs;
• higher interest rates; or
• adverse exchange-rate movements.

Break-even analysis can determine the maximum decline in EBITDA or collections that leaves DSCR at the covenant threshold. Lenders should also assess refinancing risk at loan maturity rather than assuming that debt can always be rolled over.

11. Illustrative Case: Northstar Components

Background

Northstar Components is an illustrative manufacturing borrower seeking renewal of a revolving working-capital facility and a new equipment loan. Its 2024 financial profile corresponds to Meridian’s statements above. Revenue grew, but margins weakened, inventory rose and debt increased.

Problem

Management emphasizes revenue growth and positive net income. The lender must determine whether historical and projected cash flows can support debt service.

Analysis

Reported 2024 CFO is CU32.5 million. This figure already includes income taxes paid and CU28 million of cash interest classified within operating activities. Maintenance capital expenditure is estimated at CU12 million; the balance of capital expenditure relates to expansion. No dividends were paid.

To avoid counting interest twice, cash interest is added back to reported CFO when calculating cash flow before debt service:

Scheduled principal repayment was CU15 million. Thus:

Income taxes are not deducted again because they are already reflected in reported CFO. The 1.13 times coverage is positive but weak for a cyclical manufacturer.

For 2025, the lender independently forecasts EBITDA of CU120 million, cash taxes of CU12 million, an increase in operating working capital of CU15 million and maintenance capital expenditure of CU14 million. Assuming no other relevant cash adjustments:

Projected cash interest is CU26 million and scheduled principal is CU35 million:

Under a downside scenario, EBITDA falls to CU100 million and working-capital investment increases to CU22 million. With taxes of CU8 million and maintenance capital expenditure unchanged:

Approach and outcome

The lender approves the facilities subject to tighter controls rather than relying solely on the base case. Conditions include a minimum DSCR covenant, monthly receivables and inventory reporting, limits on dividends, a borrowing base linked to eligible receivables and inventory, and quarterly compliance testing.

Learning points

• Revenue growth does not necessarily improve cash generation.
• Reported CFO must be reconciled to its classification of interest and tax.
• Maintenance and growth capital expenditure serve different analytical purposes.
• Base-case coverage may conceal vulnerability under plausible stress.
• Loan structure and monitoring should respond to identified cash-flow risks.

12. Governance, Regulation and Technology

Financial analysis should use audited statements where available, but an unmodified audit opinion does not guarantee solvency or eliminate fraud risk. Analysts must review accounting policies, key audit matters, contingent liabilities, subsequent events and covenant disclosures. Applicable accounting standards, prudential regulations and institutional credit policies must be observed.

Ethical analysis requires consistent treatment of borrowers, protection of confidential information and documentation of adjustments. Analysts should not manipulate projections to justify a predetermined lending outcome.

Digital tools can import ledger data, analyze bank transactions, detect unusual journal entries and forecast cash flows. Artificial intelligence may identify anomalies such as duplicate invoices or abnormal revenue patterns. However, models can inherit poor data, hidden bias and false correlations. Human review, access controls, validation, explainability and audit trails remain necessary.

13. Limitations and Professional Best Practices

Financial statements are historical, partly estimate-based and sometimes affected by inflation, seasonality or changing accounting policies. Ratios differ across industries and may be manipulated near the reporting date. Forecasts are conditional rather than certain.

Professional best practice is to:

• reconcile all statements and verify internal arithmetic;
• use several years and interim periods;
• compare accounting results with bank transactions and tax records;
• examine notes and off-balance-sheet commitments;
• distinguish recurring from exceptional performance;
• analyze monthly cash timing, not merely annual totals;
• document assumptions and data limitations;
• perform downside and break-even tests; and
• combine quantitative findings with business, management and industry analysis.

Chapter Summary

Financial statement analysis integrates the balance sheet, income statement, cash-flow statement and accompanying disclosures. Horizontal, trend and common-size techniques reveal changes in scale and financial structure, while ratios evaluate liquidity, efficiency, leverage, profitability and coverage. Working-capital analysis explains how receivables, inventory and payables affect cash requirements.

Profit and EBITDA are not substitutes for cash flow. Lenders should reconcile reported CFO, distinguish maintenance from growth capital expenditure and define CFADS consistently with the debt-service denominator. Cash budgets expose timing gaps that annual statements may conceal, while projected and stressed cash flows test future repayment capacity. Reliable credit decisions also require normalization of accounting distortions, examination of reporting quality and disciplined professional judgment.

Key Terms

Balance sheet: Statement of assets, liabilities and equity at a specified date.

Cash conversion cycle: Estimated days between cash payment to suppliers and collection from customers.

Cash flow from operations: Cash generated or used by operating activities.

CFADS: Cash flow available for scheduled interest and principal payments.

Common-size analysis: Presentation of statement items as percentages of a common base.

Current ratio: Current assets divided by current liabilities.

Debt-service coverage ratio: CFADS divided by scheduled cash interest and principal.

EBIT: Earnings before interest and tax.

EBITDA: Earnings before interest, tax, depreciation and amortization.

Free cash flow: Cash flow remaining after a defined measure of capital expenditure.

Funds-flow analysis: Analysis of the sources and applications of funds between periods.

Horizontal analysis: Comparison of financial statement amounts across periods.

Interest coverage: EBIT divided by interest expense.

Net working capital: Current assets minus current liabilities.

Normalization: Adjustment of reported results for non-recurring or distorted items.

Quick ratio: Liquid current assets divided by current liabilities.

Repayment capacity: Ability to generate sufficient cash to meet debt obligations when due.

Trend analysis: Comparison of values with a selected base-period index.

Working capital: Short-term resources and obligations supporting operations.

Review Questions

Short Answer Questions

1. Explain why positive net income does not necessarily imply positive operating cash flow.
2. Distinguish horizontal analysis from common-size analysis.
3. Why are average balance-sheet amounts generally used in turnover ratios?
4. What does the cash conversion cycle measure?
5. Why should income taxes not be deducted again from CFO when they are already included in it?

Long Answer Questions

1. Explain how the balance sheet, income statement and cash-flow statement are interconnected.
2. Discuss the strengths and limitations of liquidity, leverage and coverage ratios in credit analysis.
3. Explain how accounting policies can distort reported profitability and financial position.
4. Describe the process of constructing an integrated cash-flow forecast for a borrower.
5. Evaluate the roles of scenario analysis, sensitivity analysis and covenant monitoring in lending decisions.

Analytical / Application Questions

1. A borrower’s sales increase by 15%, receivables by 35% and CFO declines. Analyze the possible causes and identify additional evidence required.
2. Prepare a lender’s response to a borrower whose base-case DSCR is 1.30 times but downside DSCR is 0.90 times.
3. A company reports CFO of CU60 million, including CU20 million cash interest and income taxes paid. Maintenance capital expenditure is CU15 million, and scheduled principal is CU30 million. Calculate CFADS and DSCR, assuming no distributions or other adjustments.

Multiple Choice Questions with Answers

Question 1

A common-size income statement normally expresses each item as a percentage of which amount?

A. Total assets

B. Revenue

C. Equity

D. Operating cash flow

Correct Answer: B. Revenue

Question 2

A company has current assets of CU294 million and current liabilities of CU186 million. What is its current ratio?

A. 0.63 times

B. 0.77 times

C. 1.21 times

D. 1.58 times

Correct Answer: D. 1.58 times

Question 3

Twenty percent of sales are collected in the month of sale and 80% in the following month. If February sales are CU160 thousand and March sales are CU180 thousand, what are March collections?

A. CU152 thousand

B. CU160 thousand

C. CU164 thousand

D. CU176 thousand

Correct Answer: C. CU164 thousand

Question 4

In the chapter's cash budget, March opening cash is CU42 thousand, collections are CU164 thousand, and total March payments are CU182 thousand. What is closing cash?

A. CU18 thousand

B. CU24 thousand

C. CU42 thousand

D. CU66 thousand

Correct Answer: B. CU24 thousand

Question 5

Under the indirect method, an increase in inventory, with all else unchanged, has which effect on cash flow from operations?

A. It decreases CFO

B. It increases CFO

C. It has no effect on CFO

D. It increases financing cash flow

Correct Answer: A. It decreases CFO

Question 6

Inventory days are 50, receivables days are 40 and payables days are 30. What is the cash conversion cycle?

A. 20 days

B. 40 days

C. 60 days

D. 120 days

Correct Answer: C. 60 days

Question 7

Reported CFO is CU32.5 million and includes CU28 million of cash interest. Maintenance capital expenditure is CU12 million, while debt service consists of CU28 million interest and CU15 million principal. Assuming no other adjustments, what is DSCR?

A. 0.48 times

B. 0.76 times

C. 1.13 times

D. 1.41 times

Correct Answer: C. 1.13 times

Question 8

Why should cash taxes not be deducted again when deriving CFADS from reported CFO if those taxes are already included in CFO?

A. Taxes are non-cash expenses

B. It would double count the cash outflow

C. Taxes are part of financing activities in every jurisdiction

D. CFADS must always be calculated before tax

Correct Answer: B. It would double count the cash outflow

Question 9

Closing net PPE is CU306 million, opening net PPE is CU260 million and depreciation is CU25 million. Assuming no disposals, acquisitions, impairments or revaluations, what is capital expenditure?

A. CU21 million

B. CU46 million

C. CU71 million

D. CU91 million

Correct Answer: C. CU71 million

Question 10

Revenue rises from CU800 million to CU900 million while EBITDA falls from CU100 million to CU95 million. What is the most appropriate interpretation?

A. Revenue growth was accompanied by a weaker EBITDA margin

B. Operating profitability necessarily improved

C. The company generated positive free cash flow

D. Interest coverage necessarily increased

Correct Answer: A. Revenue growth was accompanied by a weaker EBITDA margin