STEM help / Calculation framework

Results beginning with ‘C’

Calendar Year

The current year of the model run.

The Model Start Date input plus the Relative Year.

Include: Advanced

Cap. Ex. – Intangible

Expenditure on Resources with input Tangible = No, such as capitalised licence fees.

Include: Standard

Cap. Ex. – Tangible

Expenditure on Resources with input Tangible = Yes.

Include: Standard

Capacity Mode

Include: Standard

Capital Employed

The net operating assets of the business, i.e., the written-down value of tangible and intangible assets plus net current assets.

For the Network: Total Assets, less Cash Deposits and Investments, less Current Liabilities.

For a Service: Net Fixed Assets plus Debtors minus Creditors.

Note: The definition of Capital Employed for Services is simpler than that for the network, as financing, tax and dividends are only modelled for the network as a whole.

Include: Standard

Capital Expenditure

For a Resource: Incremental Units multiplied by the Unit Cost, which is governed by the Calibration Period per-unit Capital Cost input, together with the Capital Cost Structure and any Economies of Scale.

Consolidation: Sum.

Include: Essential

Cash

The amount of money in the ‘current account’, used to service the day-to-day financial requirements of the network, if positive. (A negative amount is shown as Overdraft.)

The same as Current Account, if the latter is positive, otherwise zero.

Include: Standard

Cash Deposits

Surplus cash in short-term investments, such as marketable securities, earning interest at the Deposit Rate.

Surplus Cash multiplied by one minus the Long Term Investment Proportion input.

Include: Standard

Cashflow after Financing

The amount of cash coming into the business during the year, after investment and financing, which should match Change in Cash plus Deposits on the cashflow statement.

Cashflow before Financing plus Change in Total Borrowing plus Change in Share Capital minus Dividends Paid.

Include: Essential

Cashflow before Financing

The amount of cash coming into the business during the year, after investment.

Cashflow from Operations minus Capital Expenditure minus Change in Investments.

Include: Essential

Cashflow Check

A cross-check to ensure that the cashflow statement adds up (i.e., iteration complete).

Cashflow after Financing minus Change in Cash plus Deposits (should be zero).

Include: Advanced

Cashflow from Operations

The amount of cash coming into the business from operations, allowing for interest and tax, but not including investment.

Pre-Tax Profit plus Depreciation plus Amortisation minus Change in Debtors Less Creditors minus Tax Paid.

Note: Depreciation and Amortisation are added back to the Pre-Tax Profit result.

Include: Essential

Ch. in Cash plus Cash Deposits

The movement in current-account cash plus short-term investment between two consecutive years, which should match Cashflow after Financing on the cashflow statement.

Note: Overdraft is counted as financing, and any movement is included in Changes in Total Borrowing, which is added into Cashflow after Financing.

The difference between Cash plus Cash Deposits for the current year and the same results for the previous year, taking the Initial Current Account (if positive) and Initial Cash Deposits inputs as starting points.

Include: Standard

Ch. in Debtors less Creditors

Variations in the amount of working capital between two consecutive years.

The sum of Change in Working Capital over Services.

Include: Standard

Change in Investments

Variations in the amount of long-term investment between two consecutive years.

The difference between the Investments result for the current year and the previous year, taking the Initial Investments input as the value for the beginning of year zero.

Include: Standard

Change in Share Capital

The book value of any newly-issued shares.

The difference between Share Capital for the current year and the previous year, taking the Initial Share Capital input as the value for the beginning of year zero.

Include: Standard

Change in Stock

The net impact on network cashflow of purchases and consumption of stock.

For the network: Stock Purchases minus Stock Charge.

Consolidation: Sum.

Include: Standard

Change in Total Borrowing

Variations in the amount of overdraft and long-term borrowing between two consecutive years.

The difference between Total Borrowing for the current year and the previous year, taking the Initial Long-Term Borrowing input minus the Initial Current Account input (if negative) as the value for the beginning of year zero.

Include: Standard

Change in Working Capital

Variations in the net amount of money owed to the business, used to calculate cashflows.

The difference between Working Capital for the current year and the previous year.

Include: Standard

Churn Cost

The explicit financial impact of the turnover in connections to Services.

For a Resource: the product of the Calibration Period per-unit Churn Cost input, the normalised global and Resource Churn Cost Trends, the Churn Age Factor and the respective Churn Proportions and usage by Services, divided by the Capacity.

Include: Standard

Churn Proportion

The Churn Proportion input, defined as an explicit result for easier reference in derived-result definitions.

Include: Standard

Churn Revenue

The one-off revenue collected for churned connections to a Service.

The product of the number of Connections, the Churn Proportion and the Churn Tariff.

Include: Standard

Churn Tariff

The one-off tariff charged per churned connection.

The Churn Tariff input.

Include: Standard

Connection Charge Multiplier

The margin applied to a Service’s cost per new connection, fed back from the previous year, in order to calculate the cost-dependent connection tariff for the current year.

The Charge Multiplier input.

Include: Advanced

Connection Cost

The one-off non-capitalised cost of leasing Resources.

For a Resource: the product of the Calibration Period per-unit Connection Cost input, the normalised global and Resource Connection Cost Trends, and the number of Incremental Units.

Include: Standard

Connection Cost Dependent Tariff

The cost-dependent part of the composite Connection Tariff.

The Connection Feedback Cost multiplied by the Charge Multiplier input.

Include: Advanced

Connection Cost Independent Tariff

The cost-independent part of the composite Connection Tariff.

The Cost Independent Tariff input.

Include: Advanced

Connection Feedback Cost

The cost per new connection, fed back from the previous year, in order to calculate the cost-dependent connection tariff for the current year.

The proportion of costs allocated to a Service, earmarked for the connection tariff, divided by the number of New Connections, including those arising from churn (both in the previous year).

Include: Advanced

Connection Independence Weighting

The factor used to weight the cost-independent part against the cost-dependent part when calculating the composite Connection Tariff.

The Independence Weighting input.

Include: Advanced

Connection Maximum Change

The maximum proportional change in the Connection Tariff permitted between one year and the next. The factor 1 allows 100% change.

The Max Change input.

Include: Advanced

Connection Revenue

The one-off revenue collected for new connections to a Service, not including churned connections.

The number of New Connections multiplied by the Connection Tariff.

Include: Standard

Connection Tariff

The one-off tariff charged per new connection to a Service.

The weighted average of the cost-independent and cost-dependent connection tariffs, calculated according to the Independence Weighting. If the weighting is 1 (the default), this result is just the cost-independent Connection Tariff input.

Include: Standard

Connections

The total number of connections to a Service.

For a Service: the Customer Base multiplied by the Penetration, which may be influenced by tariff feedback to demand.

Include: Essential for a service, market segment or service/resource, Standard for a network.

Consumed Units

The equivalent number of units of a resource actually consumed in a given period. Only available for a consumable resource, and may not be an integer.

For a consumable Resource: Consumption divided by unit Capacity.

Consolidation: Sum.

Include: Standard

Consumption

The portion of installed capacity of resources actually consumed in a given period. Only available for a consumable resource.

For a consumable resource: the same as Used Capacity, but with appropriate aggregate consolidation.

Consolidation: Sum.

Include: Essential

Cost Trend

A time series representing the relative development of a cost throughout the model run.

The Cost Trend input.

Include: Essential

Creditors

The amount of money owed to Creditors.

For a Service: the Average Creditor Days input multiplied by the average daily Operating Costs (i.e., Operating Costs divided by 365).

Note: The Creditors result is calculated from Operating Costs rather than Operating Expenditure – in line with the Current Account calculation – on the basis that deferred payment on capital investment is effectively a form of long-term borrowing. The Creditors result should only relate to short-term supplier payables.

Include: Standard

Cumulative Capital Expenditure

The cumulative Capital Expenditure, from the start of the model run, up to and including the current year.

Include: Standard

Cumulative Free Cashflow

The cumulative sum of Free Cashflow, from the start of the model run, up to and including the current year.

Include: Standard

Cumulative Operating Charge

The cumulative sum of the Operating Charge, from the start of the model run, up to and including the current year.

Include: Standard

Cumulative Operating Costs

The cumulative Operating Costs, from the start of the model run, up to and including the current year.

Include: Standard

Cumulative Operating Profit

The cumulative sum of the Operating Profit, from the start of the model run, up to and including the current year.

Include: Standard

Cumulative Revenue

The cumulative sum of Revenue, from the start of the model run, up to and including the current year.

Include: Standard

Cumulative Traffic

The cumulative sum of Traffic, from the start of the model run, up to and including the current year.

Include: Standard

Current Account

The amount of money in the ‘current account’, used to service the day-to-day financial requirements of the network. A positive amount is shown as Cash, while a negative amount is shown as (a positive) Overdraft, and attracts interest at the Overdraft Rate.

The Average Cash Days input multiplied by the average daily Operating Costs (i.e., Operating Costs divided by 365).

Include: Standard

Current Assets

The sum of assets which are readily convertible into cash (liquid), and debtors which should yield cash within a year.

Cash plus Cash Deposits plus Debtors.

Include: Standard

Current Liabilities

Debts which must be paid within a year.

Overdraft plus Long-Term Borrowing Payable plus Creditors plus Tax Payable plus Dividends Payable.

Include: Standard

Customer Base

The number of potential customers for a Service.

The Customer Base input.

Include: Standard

 

© Implied Logic Limited