Foundations of Financial Analysis and Modelling

Introduction and Context

Financial analysis and financial modelling are central activities in banking, finance and insurance. They help professionals convert accounting records, market information and economic assumptions into evidence for decisions. A bank may analyse whether a borrower can repay a loan; an insurer may model claims and capital requirements; an investment analyst may estimate the value and risk of a company; and a financial manager may assess liquidity, profitability and funding needs.

Financial analysis is the systematic examination and interpretation of financial information. Financial modelling is the structured representation of financial relationships, usually in spreadsheets, databases or software, used to explain performance, test assumptions and evaluate possible futures. Analysis often begins with observed data, while modelling extends analysis by representing relationships among variables and projecting outcomes.

Neither analysis nor modelling produces certainty. Both produce evidence that must be interpreted in relation to the purpose of the investigation, the quality of the data, the assumptions used and the risks surrounding the decision.

Learning Objectives

By the end of this chapter, you should be able to:

1. Explain the purpose and users of financial analysis and modelling.
2. Distinguish financial terminology and the major forms of analytical reasoning.
3. Describe the structure and components of a financial model.
4. Apply a disciplined process from question definition through recommendation.
5. Interpret common financial ratios and projections responsibly.
6. Identify model risk, data limitations, ethical issues and governance requirements.

1. The Purpose of Financial Analysis and Modelling

Financial analysis serves several related purposes:

• Performance assessment: determining whether an organisation is profitable, efficient and financially stable.
• Credit assessment: evaluating the probability that a borrower will meet contractual obligations.
• Valuation: estimating the economic worth of an enterprise, asset or liability.
• Planning and control: preparing budgets, forecasts and resource-allocation decisions.
• Risk management: identifying exposure to liquidity, market, credit, operational and insurance risks.
• Regulatory and stewardship reporting: demonstrating compliance and accountability.
• Decision support: comparing alternatives under different assumptions.

A model makes the logic of a financial decision explicit. For example, a loan model may connect sales, operating costs, cash flow, debt service and default probability. An investment model may connect revenue growth, margins, capital expenditure, working capital and discount rates to an estimated enterprise value.

A useful distinction is between calculation and analysis. Calculation produces a result according to a rule. Analysis asks what the result means, why it occurred, how reliable it is and what action should follow.

2. Users of Financial Information

Different users require different forms of analysis because their decisions, information access and risks differ.

Internal users may access detailed operational information, whereas external users often rely on published financial statements, regulatory filings, market data and management disclosures. Consequently, analysts must distinguish between information that is observable, estimated, confidential or subject to managerial judgement.

3. Essential Financial Terminology

Financial statements

The statement of financial position reports assets, liabilities and equity at a particular date. Its basic accounting identity is:

Assets are controlled economic resources; liabilities are present obligations; and equity represents the residual interest after liabilities are deducted from assets.

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

The statement of cash flows explains movements in cash from operating, investing and financing activities. Profit and cash flow are not identical because accounting recognises some items before or after cash is received or paid, and because non-cash expenses such as depreciation affect profit without directly reducing current-period cash.

Key analytical terms

• Revenue growth: the percentage change in revenue between periods.
• Margin: profit or another measure expressed relative to revenue.
• Liquidity: the ability to meet obligations when they fall due.
• Solvency: the ability to meet obligations over the longer term.
• Leverage: the use of debt or other fixed obligations to finance assets.
• Working capital: short-term operating resources and obligations, commonly current assets minus current liabilities.
• Cash flow: cash generated or consumed by activities during a period.
• Forecast: an estimate of a future outcome based on explicit assumptions.
• Scenario: a internally consistent set of assumptions describing a possible future.
• Sensitivity analysis: examination of how an output changes when one or more inputs change.
• Valuation: estimation of the economic value of an asset, liability or business.
• Model risk: the possibility that a model produces harmful conclusions because of errors, inappropriate assumptions, misuse or poor implementation.

Nominal and real values

A nominal value is measured in the prices prevailing at the relevant time. A real value is adjusted for changes in purchasing power. Analysts must avoid mixing nominal cash flows with real discount rates or real cash flows with nominal discount rates. The distinction is particularly important in long-term insurance and investment models.

4. Forms of Financial Analysis

Financial analysis can be classified by the question it answers and by the direction of reasoning.

Descriptive analysis: What happened?

Descriptive analysis summarises historical or current information. Examples include revenue by product, loss ratios by policy class, monthly cash balances and five-year profitability trends. Common tools include tables, charts, common-size statements and summary statistics.

In common-size analysis, each income-statement item may be expressed as a percentage of revenue. For example:

The formula is applicable when revenue is a meaningful base and is non-zero. If a business has volatile or negative revenue, another denominator may be more informative.

Diagnostic analysis: Why did it happen?

Diagnostic analysis investigates causes and relationships. A decline in profit may result from lower volume, reduced price, higher input costs, rising claims, increased bad debts or an accounting reclassification. Diagnosis should not rely on correlation alone. Analysts should consider timing, economic logic, controls and alternative explanations.

A useful method is variance analysis. If actual profit differs from budgeted profit, the analyst decomposes the difference into relevant drivers such as volume, price, mix, cost and exceptional items. The quality of a variance explanation depends on the underlying budget, the consistency of classifications and the availability of operational data.

Predictive analysis: What is likely to happen?

Predictive analysis uses historical information, economic assumptions and statistical or financial models to estimate future outcomes. Examples include expected loan losses, future cash balances, claim frequency and revenue forecasts.

A simple growth forecast may use:

where g is the constant growth rate per period and n is the number of periods. This formula assumes compounding at a constant rate and should not be treated as a law of nature. Growth may change, become negative or be constrained by capacity and competition.

Prescriptive analysis: What should be done?

Prescriptive analysis compares actions and recommends a course of action subject to objectives and constraints. Examples include selecting a loan limit, allocating capital between business lines or choosing an insurance deductible.

A recommendation may maximise expected return, minimise expected loss or balance several objectives. Prescriptive analysis must explicitly state constraints, such as regulatory capital, liquidity, risk appetite, customer fairness and operational capacity. A mathematically optimal result is not necessarily an acceptable business decision.

These four forms are complementary. A robust analysis may describe a deterioration in a ratio, diagnose its causes, predict whether it will continue and prescribe corrective action.

5. Financial Ratios and Interpretation

Ratios make relationships easier to compare across time and across organisations, but they do not eliminate the need for judgement.

Profitability

The net profit margin is:

It indicates the proportion of revenue retained as net profit. Comparisons should consider business model, accounting policies, financing structure and extraordinary items.

Return on assets is commonly stated as:

Average total assets are often calculated as opening assets plus closing assets divided by two. This approximation is most reasonable when asset changes are reasonably even during the period. ROA comparisons can be distorted by asset valuation methods and by differences in leverage.

Liquidity

A basic current ratio is:

A higher ratio does not automatically imply better liquidity. Inventory may be difficult to sell, receivables may be doubtful, and a bank’s liquidity profile cannot be assessed adequately using a commercial-company current ratio.

Leverage and coverage

A debt-to-equity ratio may be defined as:

Definitions vary: some analysts include leases, overdrafts or other financial obligations. The definition must therefore be disclosed.

Interest coverage can be expressed as:

The ratio is meaningful only when earnings and interest expense are measured consistently and interest expense is positive. A high ratio may still conceal refinancing risk or volatile cash flows.

Worked example: interpreting a ratio change

Suppose a company reports revenue of $10 million and net profit of $800,000 in Year 1. In Year 2, revenue rises to $12 million but net profit falls to $720,000.

Year 1 margin:

(800,000 ÷ 10,000,000) × 100 = 8%

Year 2 margin:

(720,000 ÷ 12,000,000) × 100 = 6%

Revenue increased by 20%, but profit decreased by 10%. The margin fell by 2 percentage points, or 25% relative to the original margin. The result suggests that growth did not translate into profitability. Possible explanations include price reductions, adverse product mix, higher operating costs, increased financing costs or impairment losses. The ratio identifies a question; it does not by itself identify the cause.

6. The Architecture of a Financial Model

A financial model normally contains five connected elements:

1. Inputs: historical data, management assumptions, market variables and policy parameters.
2. Calculations: formulas that transform inputs into intermediate results.
3. Outputs: statements, ratios, valuations, risk measures and decision indicators.
4. Scenarios: alternative assumptions such as base, adverse and favourable conditions.
5. Controls: checks that identify errors, omissions and implausible results.

A well-designed model separates inputs from calculations and outputs. It uses consistent units, transparent formulas, clear time periods and documented assumptions. Hard-coded numbers hidden inside formulas should be avoided because they reduce auditability.

A model may be deterministic or probabilistic. A deterministic model produces one result for a specified set of inputs. A probabilistic model represents uncertainty through probability distributions or multiple simulations. Both require judgement: uncertainty in the inputs does not disappear merely because the calculations are automated.

Forecasting logic

A basic revenue forecast can be written as:

This driver-based structure is often more informative than applying an unexplained percentage increase. For a lending model, repayment capacity might depend on operating cash flow, existing debt service and new debt service. For insurance, projected claims may depend on exposure, claim frequency and average claim severity:

The relationship assumes that the measures are defined consistently and that frequency and severity are suitable estimates for the relevant population and period.

7. A Structured Process for Financial Analysis

Step 1: Define the decision question

Begin with a precise question. “Is the company financially healthy?” is too broad. “Can the borrower service a proposed five-year loan under base and adverse operating conditions?” is more actionable. Define the decision, time horizon, users, materiality threshold and required output.

Step 2: Identify the relevant measures

Select measures that answer the question. A credit assessment may require operating cash flow, debt service, collateral, leverage and liquidity. An insurance pricing exercise may require exposure, claims history, loss development and expenses. Avoid collecting data simply because it is available.

Step 3: Collect and understand the data

Assess source, period, unit, currency, accounting basis, completeness and reliability. Reconcile totals to authoritative records. Investigate missing values, duplicate observations, unusual movements and changes in classification. Data preparation is an analytical activity, not merely an administrative task.

Step 4: Clean, classify and document

Record transformations and definitions. For example, distinguish gross claims from claims net of recoveries, and distinguish accounting profit from operating cash flow. Maintain a data dictionary and an audit trail. Do not silently delete inconvenient observations or replace missing data without justification.

Step 5: Build the model

Start with a simple, transparent structure. Link assumptions to drivers, drivers to financial statements and financial statements to outputs. Use consistent signs—for example, whether expenses are entered as positive amounts and subtracted, or as negative amounts and added. Include balance checks and plausibility checks.

Step 6: Validate the model

Validation has several dimensions:

• Conceptual validation: the model represents economically plausible relationships.
• Data validation: inputs are accurate, complete and appropriate.
• Formula validation: calculations are correct and consistently applied.
• Outcome validation: outputs are compared with historical experience, benchmarks or independent estimates.
• Sensitivity validation: outputs respond appropriately to changes in key inputs.
• Implementation validation: the deployed spreadsheet or software behaves as intended.

Validation is not the same as proving that the forecast will occur. It establishes whether the model is fit for its intended purpose.

Step 7: Analyse scenarios and sensitivities

A scenario changes several related assumptions consistently. For example, an adverse scenario may combine lower sales, slower collections, higher interest rates and increased default losses. Sensitivity analysis changes one input while holding others constant, which helps identify the most influential variables but may be unrealistic if variables normally move together.

Step 8: Interpret and communicate

Explain the principal drivers, uncertainty, limitations and implications. Use plain language alongside tables and charts. Distinguish facts, assumptions, model outputs and professional judgement. Avoid presenting a forecast as a promise or a valuation as an objective fact.

Step 9: Recommend and monitor

A recommendation should state the proposed action, rationale, risks, conditions and monitoring indicators. Once implemented, compare actual results with modelled results and investigate material deviations. Models require maintenance because markets, products, regulations and customer behaviour change.

8. Illustrative Case: Credit Assessment of Meridian Components Ltd.

This is a fictional illustrative case.

Background

Meridian Components Ltd. seeks a $4 million, five-year term loan to expand production. The lender must decide whether to approve the loan and establish appropriate conditions.

Problem

Historical accounts show revenue growth, but recent cash balances have fallen. Management forecasts strong demand and requests that the lender rely on projected earnings. The credit team must determine whether cash generation, rather than accounting profit alone, can support repayment.

Analysis

The analyst collects three years of financial statements, aged receivables, inventory records, existing debt schedules, customer concentration data and the expansion budget. Revenue has grown, but receivable days have increased and inventory has accumulated. The model separates:

• operating assumptions, including volume, price and gross margin;
• working-capital assumptions, including collection and inventory days;
• investment expenditure and timing;
• existing and proposed debt service; and
• tax, interest and minimum cash requirements.

The base case indicates adequate debt-service capacity. An adverse case assumes a 10% reduction in sales volume, a three-month delay in collecting a major customer balance and a 2 percentage-point increase in the lending rate. Under this case, cash becomes negative in Year 2 and the borrower breaches the proposed minimum liquidity condition.

Approach and recommendation

The lender does not reject the proposal solely because the adverse scenario is difficult. Instead, it considers risk mitigants: a smaller initial facility, staged drawdowns tied to construction milestones, a borrowing-base limit, monthly cash reporting and restrictions on additional debt. The recommendation is conditional approval subject to these controls and evidence that the major customer has acceptable credit quality.

Outcome and learning points

The case demonstrates that revenue growth is not equivalent to cash generation. It also shows why scenario analysis is more useful than a single forecast, why assumptions must be linked to operational drivers and why a recommendation should combine model results with governance and monitoring.

9. Limitations, Ethics and Governance

Data and measurement limitations

Financial statements are prepared under accounting rules that involve estimates, judgements and classifications. Inflation, exchange-rate movements, seasonality and changes in business structure can reduce comparability. Historical data may be unrepresentative of future conditions, particularly after a crisis, merger or regulatory change.

Model limitations

A model may omit relevant variables, embed incorrect relationships or create false precision. Complex models are not necessarily superior: complexity can make errors harder to detect and assumptions harder to explain. Correlation does not establish causation, and a model calibrated to historical data may fail when behaviour changes.

Ethical responsibilities

Analysts should present material risks fairly, disclose assumptions, protect confidential information and avoid manipulating inputs to obtain a desired outcome. Selective use of scenarios, unrealistic growth assumptions and suppression of adverse results can harm customers, investors and institutions. In lending and insurance, models may also create unfair outcomes if data or proxies reproduce discriminatory patterns.

Governance

Effective governance assigns responsibility for model ownership, approval, independent review, version control, access rights, change management and retirement. Financial institutions commonly require documentation, validation and monitoring proportionate to model materiality and risk. Spreadsheet models should be protected against unauthorised changes and supported by an audit trail.

10. Technology, Automation and Contemporary Practice

Spreadsheets remain widely used because they are flexible and accessible, but they can contain hidden errors, inconsistent versions and weak controls. Databases, business-intelligence platforms and specialised modelling systems improve reproducibility when properly governed. Programming languages can support automated testing, version control and large-scale scenario analysis.

Artificial intelligence and machine learning may improve forecasting, anomaly detection and document extraction. However, their use introduces concerns about explainability, data drift, privacy, bias, cybersecurity and accountability. An AI-generated prediction should be treated as model output requiring validation—not as an independent expert opinion. Human review remains essential when decisions affect credit access, insurance protection, investment suitability or regulatory compliance.

Best Practices for Students and Practitioners

1. Begin with the decision, not with the spreadsheet.
2. Define every important input, output, unit and time period.
3. Reconcile model totals to source records.
4. Separate inputs, calculations and outputs.
5. Use driver-based assumptions where possible.
6. Test both formulas and economic logic.
7. Use base, favourable and adverse scenarios.
8. Report ranges and uncertainties rather than false precision.
9. Document changes and retain an audit trail.
10. Communicate limitations as clearly as conclusions.

Chapter Summary

Financial analysis interprets financial information for decisions, while financial modelling represents relationships among financial variables to calculate outcomes and examine alternatives. Their users include investors, lenders, managers, insurers, regulators, auditors and other stakeholders. Core concepts include profitability, liquidity, solvency, leverage, cash flow, forecasting, valuation, scenarios, sensitivity and model risk.

Descriptive analysis explains what happened; diagnostic analysis investigates why it happened; predictive analysis estimates what may happen; and prescriptive analysis considers what should be done. Ratios are useful indicators but require consistent definitions, suitable comparators and contextual interpretation.

A disciplined process begins by defining the decision question, selecting relevant measures, collecting and preparing reliable data, building a transparent model, validating inputs and formulas, testing scenarios, interpreting outputs and making a monitored recommendation. Models are not substitutes for judgement. Their reliability is limited by data quality, assumptions, model design, implementation and changing conditions. Ethical practice requires transparency, fairness, confidentiality, accountability and honest communication of uncertainty.

Key Terms

Financial analysis: Systematic examination and interpretation of financial information.

Financial modelling: Structured representation of financial relationships used to analyse or project outcomes.

Liquidity: Ability to meet obligations when they fall due.

Solvency: Ability to meet obligations over the longer term.

Leverage: Use of debt or fixed financial obligations to finance assets.

Working capital: Short-term operating resources less short-term operating obligations.

Forecast: Estimate of a future outcome based on stated assumptions.

Scenario: Internally consistent set of assumptions describing a possible future.

Sensitivity analysis: Study of output changes following changes in specified inputs.

Valuation: Estimation of the economic worth of an asset, liability or business.

Model risk: Risk of harmful conclusions caused by model error, misuse or inappropriate assumptions.

Descriptive analysis: Analysis of what has happened or is happening.

Diagnostic analysis: Analysis of the causes of an observed result.

Predictive analysis: Analysis estimating likely future outcomes.

Prescriptive analysis: Analysis comparing actions and recommending decisions.

Common-size analysis: Expression of financial statement items as percentages of a selected base.

Driver: Operational or financial variable that explains a model output.

Validation: Assessment of whether a model is accurate and fit for its intended purpose.

Audit trail: Record of data sources, changes, calculations and approvals.

Data dictionary: Document defining data fields, units, classifications and sources.

Review Questions

Short Answer Questions

1. What is the principal difference between financial analysis and financial modelling?
2. Why can accounting profit differ from cash flow?
3. Define liquidity and solvency.
4. What question does diagnostic analysis seek to answer?
5. State two purposes of model validation.

Long Answer Questions

1. Explain the four forms of analysis—descriptive, diagnostic, predictive and prescriptive—and show how they may be combined in a credit decision.
2. Discuss the main users of financial analysis and explain how their information needs differ.
3. Explain the architecture of a financial model, including inputs, calculations, outputs, scenarios and controls.
4. Describe the complete process for developing and applying a financial model.
5. Critically evaluate the limitations and ethical risks of using financial models in lending or insurance.

Analytical / Application Questions

1. A firm’s revenue rises by 15% while net profit falls by 5%. Identify relevant diagnostic questions and propose additional data needed before recommending action.
2. Design base, favourable and adverse scenarios for a bank assessing a five-year loan to a seasonal retailer. Specify the assumptions that should change and explain why.
3. A machine-learning model predicts insurance claims more accurately but produces substantially different approval rates across customer groups. How should the insurer evaluate and govern its use?

Multiple Choice Questions with Answers

Question 1

Which statement best describes financial modelling?

A. Recording transactions in a general ledger

B. Representing financial relationships to analyse outcomes and alternatives

C. Preparing a legal contract for a borrower

D. Auditing every transaction independently

Correct Answer: B. Representing financial relationships to analyse outcomes and alternatives

Question 2

Which form of analysis asks, “Why did it happen?”

A. Descriptive analysis

B. Diagnostic analysis

C. Predictive analysis

D. Prescriptive analysis

Correct Answer: B. Diagnostic analysis

Question 3

A company has revenue of $5 million and net profit of $400,000. What is its net profit margin?

A. 5%

B. 8%

C. 10%

D. 12.5%

Correct Answer: B. 8%

Question 4

Which formula represents the basic accounting identity?

A. Assets = Revenue − Expenses

B. Profit = Assets + Liabilities

C. Assets = Liabilities + Equity

D. Cash flow = Equity − Revenue

Correct Answer: C. Assets = Liabilities + Equity

Question 5

What is the main purpose of sensitivity analysis?

A. To eliminate all uncertainty from a forecast

B. To examine how outputs change when inputs change

C. To replace historical data with assumptions

D. To guarantee that a recommendation is correct

Correct Answer: B. To examine how outputs change when inputs change

Question 6

Which item is most directly associated with liquidity analysis?

A. Ability to meet obligations when due

B. Long-term brand reputation

C. Number of employees

D. Historical share price alone

Correct Answer: A. Ability to meet obligations when due

Question 7

Which is an example of predictive analysis?

A. Listing last year’s expenses by department

B. Investigating why claims increased

C. Estimating next year’s expected loan losses

D. Choosing a policy deductible subject to constraints

Correct Answer: C. Estimating next year’s expected loan losses

Question 8

What should normally be done first in a structured financial analysis process?

A. Build a complex spreadsheet

B. Define the decision question

C. Delete unusual observations

D. Select the most favourable scenario

Correct Answer: B. Define the decision question

Question 9

Which statement about a high current ratio is most accurate?

A. It always proves that an organisation is financially healthy

B. It guarantees that all current assets can be converted to cash immediately

C. It may indicate liquidity, but asset quality and business context must also be considered

D. It measures long-term solvency exactly

Correct Answer: C. It may indicate liquidity, but asset quality and business context must also be considered

Question 10

Which practice most directly supports model governance?

A. Hiding assumptions inside formulas

B. Using different definitions in different worksheets

C. Maintaining version control, documentation and an audit trail

D. Reporting only the base-case result

Correct Answer: C. Maintaining version control, documentation and an audit trail