← Back to KerryTech

FINANCE · FINANCIAL MODELLING

Accounts & Cash Flow Analysis

Enter multi-year financial statements, build an indirect cash flow statement and test the reconciliation to reported cash.

MODEL SETUP

Company information

Local working model

INCOME STATEMENT

Profit & Loss Account

Enter income as positive figures and expenses as negative figures. Subtotals and profit measures are calculated automatically.

FINANCIAL POSITION

Balance Sheet

Enter closing balances. Changes between years feed into the cash flow model where appropriate.

INDIRECT METHOD

Cash Flow Statement

Cash flow is calculated automatically from the P&L and balance sheet for each year after the opening comparative year. Use supporting adjustments only where non-cash movements or exceptional transactions mean the balance-sheet movement is not a cash movement.

Automatic estimates assume no disposals, revaluations, non-cash acquisitions, debt conversions or other exceptional movements unless adjusted. Review the supporting adjustments below and enter corrections where required.

Supporting cash flow adjustments

Enter signed corrections to the automatically derived cash flow figures: positive for an increase in cash inflow / reduction in outflow, negative for the reverse. Asset disposal proceeds and other investing / financing cash flows are entered as actual cash movements.

FINANCIAL PERFORMANCE

Financial Ratios & Trends

Ratios are calculated automatically from the profit and loss account, balance sheet and cash flow statement. Review definitions and assumptions alongside the results.

Interpretation note: Ratio benchmarks are indicative only and vary by industry, business model and accounting policy. Average balance-sheet values are used where an opening and closing balance are available; the first year uses closing balances. Net debt includes the model's designated short- and long-term borrowings. Review classifications before relying on the results.

FORWARD-LOOKING FINANCIAL MODEL

Financial Projections

Build projected financial statements using historical performance, operating assumptions and proposed investment funding.

MODEL INTEGRITY

Validation & Reconciliation

Version 1 development build

This version calculates in the browser and does not yet save models to the server or export files. Check all classifications and supporting adjustments against the underlying accounts before relying on the output.