|

Click on a letter below to take you to the relevant
alphabetical section. The index format is as follows:
Keyword or term Website section in which page resides /
Link to specific web-page
A B
C D E F
G H I K
L M N O
P R S T
V W
A
Accumulated depreciation (£000s) Input
Guidelines / Non-Social
Housing
Accumulated depreciation (£000s) Input Guidelines
/ Social Housing Property
Based
Accumulated depreciation How the Forecast Works / Balance
Sheet
Accumulated grants (£000s) Input Guidelines / Social
Housing Property Based
Adjusted Leverage % (Net Debt % Gross Assets) Ratio 52 Ratio Definitions
/ Balance Sheet Capacity
- Gearing and Leverage
Additional FV5 data Background
Additional FV5 data How to use the
Model
Additional FV5 data Input Guidelines
Aggregate and analyse data How to Use the Model / Getting
Started
Aggregate data and comparative statistics Background
/ Logic of the Model
Aggregating and analysis of sector data How to Use the Model
/ Producing a New Business Plan
Aggregating and analysis of sector data How
to Use the Model
Analysis How to Use the Model / Producing
a New Business Plan
Analysis How to Use the Model / Flexing
a Plan
Analysis How to Use the Model / Getting
Started
Annual care / support costs per new unit (£'s) Input Guidelines
/ Social Housing Property
Based
Annual costs per unit (£'s) Input Guidelines /
Non-Social Housing
Annual major repairs and maintenance costs per new unit (£'s) Input
Guidelines / Social
Housing Property Based
Annual management and other costs % income (%) Input Guidelines
/ Social Housing Non-Property
Based
Annual management costs per new unit (£'s) Input Guidelines
/ Social Housing Property
Based
Annual ongoing costs per new unit (£'s) Input Guidelines
/ Social Housing Property
Based
Annual property revaluation rate (%) Input Guidelines
/ Business Plan Accounting
Data
Annual service cost per new unit (£'s) Input Guidelines
/ Social Housing Property
Based
Apply selected scenario How to Use the Model / Flexing
a Plan
Asset cover x repayment ability (7) Understanding the Analysis
/ Credit
and Capacity Maps
Asset cover x repayment ability Case Study Analysis /
Credit and Capacity
Maps
Asset / Employee (£000's) Ratio 31 Ratio Definitions
/ Profitability
Asset utilisation and composition Understanding the Analysis
/ Financial Profile
Asset utilisation and composition Ratio
Definitions
Association case How to Use the Model / Flexing
a Plan
Average Capex / New Units (£000's) Ratio 18 Ratio Definitions
/ Rent and Cost Structure
Average Care / Support Costs / Unit (£)Ratio 16 Ratio Definitions
/ Rent and Cost Structure
Average Home-Buy / equity loan (£000s) Input Guidelines
/ Home-Buy
Average Management Costs / Unit (£)Ratio 14 Ratio Definitions
/ Rent and Cost Structure
Average rate on fixed rate debt (%) Input Guidelines
/ Business Plan Accounting
Data
Average rate on floating rate (%) Input Guidelines /
Business Plan Accounting
Data
Average revenue deficit / surplus per loan granted (£000s) Input
Guidelines / Home-Buy
Average Service Costs / Unit (£)Ratio 15 Ratio Definitions
/ Rent and Cost Structure
Average SHG received (£000s) Input Guidelines /
Home-Buy
Average Total Repairs and Maintenance Costs / Unit (£) Ratio 17
Ratio Definitions / Rent
and Cost Structure
Average total repairs and maintenance costs / unit Case Study
Analysis / Charts
Average Weekly Charges for Support Services / Unit (£) Ratio 13
Ratio Definitions / Rent
and Cost Structure
Average weekly income per unit (£s) Input Guidelines
/ Social Housing Property
Based
Average weekly rental income (£s) Input Guidelines
/ Social Housing Property
Based
Average weekly rental income per unit (£s) Input Guidelines
/ Non-Social Housing
Average Weekly Rental Income / Unit (£)Ratio 11 Ratio Definitions
/ Rent and Cost Structure
Average weekly service income per unit (£s) Input Guidelines
/ Social Housing Property
Based
Average weekly service income per unit (£'s) Input Guidelines
/ Non-Social Housing
Average Weekly Service Income / Unit (£)Ratio 12 Ratio Definitions
/ Rent and Cost Structure
Back to top
B
Bad Debts and Voids % Gross Rent Receivable Ratio
20 Ratio Definitions / Rent
and Cost Structure
Bad Debts and Voids % Operating Surplus Ratio 19 Ratio Definitions
/ Rent and Cost Structure
Balance sheet How the Forecast Works / I&E
Account
Balance sheet capacity - (cover ratios) Ratio
Definitions
Balance sheet capacity (cover ratios) Understanding the Analysis
/ Financial Profile
Balance sheet capacity - (debt repayments) Ratio
Definitions
Balance sheet capacity (debt repayments) Understanding the Analysis
/ Financial Profile
Balance sheet capacity - (gearing and leverage) Ratio
Definitions
Balance sheet capacity (gearing and leverage) Understanding the
Analysis / Financial
Profile
Balance sheet capacity - (multi-period cover ratios) Ratio
Definitions
Balance sheet capacity (multi-period measures) Understanding the
Analysis / Financial
Profile
Balance sheet structure Case Study Analysis / Combined
Charts
Balance sheet structure Understanding the Analysis /
Combined Charts
Balance sheet How Reconciliation
Works
Balance sheet Understanding
the Analysis
Base case How to Use the Model / Flexing
a Plan
Best case How to Use the Model / Flexing
a Plan
Benchmark inflation Input Guidelines / Business
Plan Accounting Data
Build cost per unit (£000s Input Guidelines / Social
Housing Property Based
Build cost per unit (£000s) Input Guidelines /
Non-Social Housing
Building cost inflation Input Guidelines / Business
Plan Accounting Data
Business plan accounting data Background / Business
Stream Inputs Structure
Business plan accounting data How the Forecast Works
/ Introduction
Business plan accounting data How to Use the Model /
Producing a New Business Plan
Business plan accounting data Input Guidelines / Business
Plan Accounting Data
Business stream assumptions Background / Overview
of Input Screens
Business stream assumptions How
the Forecast Works
Business Stream Inputs Structure Background
Business stream-based expenditure How the Forecast Works
/ I&E Account
Business stream-based income How the Forecast Works /
I&E Account
Business stream-based items How Reconciliation Works
/ I&E Account
Back to top
C
Capital grants How the Forecast Works
/ Balance Sheet
Capitalised interest How the Forecast Works / I&E
Account
Capitalised interest (%) Input Guidelines / Business
Plan Accounting Data
Capitalised repairs and maintenance costs (£000s) Input
Guidelines / Social
Housing Property Based
Care and support cost inflation. Input Guidelines / Business
Plan Accounting Data
Cash and short-term investments (£000s) Input Guidelines
/ Business Plan Accounting
Data
Cash and tax ratios Understanding the Analysis / Financial
Profile
Cash and tax ratios Ratio
Definitions
Cash Cost of Capital % Ratio 27 Ratio Definitions / Profitability
Cash debt service cover Case Study Analysis / Charts
Cash Debt Service Cover (times) Ratio 46 Ratio Definitions
/ Balance Sheet Capacity
- Cover Ratios
Cash expenditure on new units and land (£000s) Input Guidelines
/ Non-Social Housing
Cash expenditure on new units and land (£000s) Input Guidelines
/ Social Housing Property
Based
Cash flow analysis Understanding
the Analysis
Cash Flow before Funding % Total Assets Ratio 38 Ratio Definitions
/ Cash and Tax Ratios
Cash flow drivers (5) Understanding the Analysis / Credit
and Capacity Maps
Cash flow drivers Case Study Analysis / Credit
and Capacity Maps
Cash flow funding % total assets Case Study Analysis
/ Charts
Cash flow statement How
Reconciliation Works
Cash flow statement How the Forecast Works / I&E
Account
Cash flow statement Understanding
the Analysis
Cash from sale (£000s) Input Guidelines /
Non-Social Housing
Cash from sale (£000s) Input Guidelines /
Social Housing Property Based
Cash Interest and Net Operating Cash Flow Ratio 39 Ratio Definitions/
Cash and Tax Ratios
Cash Interest Cover (times) Ratio 45 Ratio Definitions /
Balance Sheet Capacity
- Cover Ratios
Charts Case Study Analysis
Charts How to Use the Model / Getting
Started
Charts Understanding
the Analysis
Closing stock levels (units) Input Guidelines / Non-Social
Housing
Closing stock levels (units) Input Guidelines / Social
Housing Property Based
Combined charts Case
Study Analysis
Combined charts Understanding
the Analysis
Comparative analysis Background / Logic
of the Model
Consolidated vs non-consolidated data Input Guidelines
/ General Considerations
Cost of capital drivers (3) Understanding the Analysis
/ Profitability
& Cash Flow Maps
Cost of capital drivers Case Study Analysis / Profitability
and Cash Flow Maps
Costs in each category How the Forecast Works / I&E
Account
Create a new plan How to Use the Model / Getting
Started
Create new plan How to Use the Model / Producing
a New Business Plan
Create new plan How to Use the Model / Getting
Started
Create now How to Use the Model / Producing
a New Business Plan
Create now How to Use the Model / Getting
Started
Credit and Capacity maps Case
Study Analysis
Credit and Capacity Maps Understanding
the Analysis
Creditors and other liabilities (%) Input Guidelines
/ Business Plan Accounting
Data
Current Assets/Current Liabilities (times) Ratio 56 Ratio Definitions
/ Balance Sheet Capacity
- Gearing and Leverage
Back to top
D
Debt capacity (2003) Case Study Analysis
/ Charts
Debt capacity (2007) Case Study Analysis / Charts
Debt capacity (2012) Case Study Analysis / Charts
Debt capacity Case Study Analysis / Debt
Capacity
Debt capacity Understanding
the Analysis
Debt multiples Case Study Analysis / Combined
Charts
Debt multiples Understanding the Analysis / Combined
Charts
Debt servicing ¥ repayment ability (8) Understanding the Analysis
/ Credit
and Capacity Maps
Debt servicing x repayment ability Case Study Analysis
/ Credit and Capacity
Maps
Debtors and other current assets (%) Input Guidelines
/ Business Plan Accounting
Data
Demolition costs (£000s) Input Guidelines / Social
Housing Property Based
Depreciation charge How the Forecast Works / I&E
Account
Development department costs (£000s) Input Guidelines
/ Business Plan Accounting
Data
Back to top
E
Effective Interest Rate % Ratio 25 Ratio
Definitions / Profitability
Effective price per unit (£000s) Input Guidelines
/ Social Housing Property
Based
Effective tax rate (%) Input Guidelines / Business
Plan Accounting Data
Effective Tax Rate [I & E] Ratio 43 Ratio Definitions
/ Cash and Tax Ratios
EUV(SH) rent multiple Input Guidelines / Social
Housing Property Based
Existing costs (£000s) Input Guidelines / Non-Social
Housing
Expenditure components of operating cash flow Case Study Analysis
/ Combined Charts
Expenditure components of operating cash flow Understanding the
Analysis / Combined
Charts
Expenditure Input Guidelines / Non-Social
Housing
Expenditure Input Guidelines / Social
Housing Property Based
Expenses summary Understanding
the Analysis
Back to top
F
Finance income % financial assets Case
Study Analysis / Charts
Financial Assets % Net Total Assets Ratio 37 Ratio Definitions
/ Asset Utilisation
and Composition
Financial Income % Financial Assets Ratio 24 Ratio Definitions
/ Profitability
Financial Profile Understanding
the Analysis
Financing drivers (6) Understanding the Analysis / Credit
and Capacity Maps
Financing drivers Case Study Analysis / Credit
and Capacity Maps
Fixed Assets % Net Total Assets Ratio 35 Ratio Definitions
/ Asset Utilisation
and Composition
Fixed assets at cost How the Forecast Works / Balance
Sheet
Fixed rate debt % total debt (%) Input Guidelines / Business
Plan Accounting Data
Flexing a Plan How
to Use the Model
Free land at fair value treated as grant (£000s) Input Guidelines
/ Social Housing Property
Based
Funding Input Guidelines / Business
Plan Accounting Data
FV5 data Background
FV5 data How to use the Model
FV5 data Input Guidelines
Back to top
G
Gearing (net debt % reserves plus SHG) Case
Study Analysis / Charts
Gearing (Net Debt % Net Worth plus SHG) Ratio 50 Ratio Definitions
/ Balance Sheet Capacity
- Gearing and Leverage
General assumptions Background / Overview
of Input Screens
General assumptions How the Forecast Works / Introduction
General assumptions How to Use the Model / Producing
a New Business Plan
General assumptions How to Use the Model / Flexing
a Plan
General assumptions How to Use the Model / Getting
Started
General assumptions Input Guidelines / Business
Plan Accounting Data
General Considerations Input
Guidelines
Generating a forecast Background / Logic
of the Model
Getting Started How to Use
the Model
Gross rental income (£000s) Input Guidelines /
Non-Social Housing
Gross rental income (£000s) Input Guidelines /
Social Housing Property
Based
Growth in income (%) Input Guidelines / Other
Non-Social Housing
Growth in income (%) Input Guidelines / Social
Housing Non-Property Based
Growth in Income from Social Housing Lettings % Ratio 5 Ratio
Definitions / Nominal
Growth Rates
Growth in income from social housing lettings Case Study Analysis
/ Charts
Growth in Interest Paid % Ratio 7 Ratio Definitions /
Nominal Growth Rates
Growth in SBIT % Ratio 6 Ratio Definitions / Nominal
Growth Rates
Growth in SBIT Case Study Analysis / Charts
Growth in Total Assets % Ratio 8 Ratio Definitions /
Nominal Growth Rates
Growth in total assets Case Study Analysis / Charts
Growth in Total Capital & Reserves % Ratio 9 Ratio Definitions
/ Nominal Growth
Rates
Growth in total capital and reserves Case Study Analysis
/ Charts
Growth in Total Debt % Ratio 10 Ratio Definitions / Nominal
Growth Rates
Growth in total debt Case Study Analysis / Charts
Back to top
H
HALCR Case Study Analysis / Charts
HALCR (times) Ratio 59 Ratio Definitions / Balance
Sheet Capacity - Multi-period Cover Ratios
Home-Buy charges / income How the Forecast Works / I&E
Account
Home-Buy Input Guidelines
Housing accommodation How to Use the Model / Flexing
a Plan
Housing assets average depreciation rate (%) Input Guidelines
/ Business Plan Accounting
Data
Housing stock demolished Input Guidelines / Social
Housing Property Based
Housing stock sold (including part units) Input Guidelines
/ Social Housing Property
Based
Housing stock transferred Input Guidelines / Social
Housing Property Based
Back to top
I
I&E drivers (1) Understanding the Analysis
/ Profit & Cash
Flow Maps
I&E drivers Case Study Analysis / Profitability
and Cash Flow Maps
Identification details for the association How
the Forecast Works
Impairment cost (£000s) Input Guidelines / Business
Plan Accounting Data
Income (£000s) Input Guidelines / Social
Housing Non-Property Based
Income and expenditure account How
Reconciliation Works
Income and expenditure account How
the Forecast Works
Income and expenditure account Understanding
the Analysis
Income from Social Housing Lettings/Employee (£000's) Ratio 30 Ratio
Definitions / Profitability
Increase in Debt % Net Capital Expenditure Ratio 40 Ratio Definitions
/ Cash and Tax Ratios
Increase in debt % net capital expenditure Case Study Analysis
/ Charts
Increase in medium and long-term debt (£000s) Input Guidelines
/ Business Plan Accounting
Data
Input data How to Use the Model / Producing
a New Business Plan
Input data How to Use the Model / Getting
Started
Input requirements How
Reconciliation Works
Interest paid on fixed rate debt How the Forecast Works
/ I&E Account
Interest paid on floating rate debt How the Forecast Works
/ I&E Account
Interest rate input How the Forecast Works / I&E
Account
Interest received and paid calculations How the Forecast Works
/ I&E Account
Introduction and objectives Background
Introduction How
Reconciliation Works
Introduction How the
Forecast Works
Investment / deposit rate (%) Input Guidelines / Business
Plan Accounting Data
Back to top
K
Key items of income and expenditure How
the Forecast Works
Back to top
L
Land purchase cost [total] (£000s) Input
Guidelines / Non-Social
Housing
Land purchase cost [total] (£000s) Input Guidelines
/ Social Housing Property
Based
Leverage % (Net Debt % Net Assets) Ratio 51 Ratio Definitions
/ Balance Sheet Capacity
- Gearing and Leverage
Linking to RSL's data systems Input Guidelines / General
Considerations
LLCR (30 constant) (times) Ratio 58 Ratio Definitions
/ Balance Sheet Capacity
- Multi-period Cover Ratios
LLCR (30 reducing) (times) Ratio 57 Ratio Definitions
/ Balance Sheet Capacity
- Multi-period Cover Ratios
Load scenarios How to Use the Model / Flexing
a Plan
Logic of financial profiling & credit / capacity assessment Understanding
the Analysis / Financial
Profile
Logic of the model Background
Loss % rental, support and service income (%) Input Guidelines
/ Non-Social Housing
Loss % rental, support and service income Input Guidelines
/ Social Housing Property
Based
Losses (£000s) Input Guidelines / Non-Social
Housing
Losses (£000s) Input Guidelines / Social
Housing Property Based
Back to top
M
Major cash inflows and outflows Case Study
Analysis / Combined
Charts
Major cash inflows and outflows Understanding the Analysis
/ Combined Charts
Major repairs & maintenance cost inflation (%) Input Guidelines
/ Business Plan Accounting
Data
Major repairs grants (£000s) Input Guidelines /
Social Housing Property
Based
Management cost inflation Input Guidelines / Business
Plan Accounting Data
Margin over Cash Cost of Capital % Ratio 28 Ratio Definitions
/ Profitability
Margins over cash cost of capital Case Study Analysis
/ Charts
Measures of leverage Case Study Analysis / Combined
Charts
Measures of leverage Understanding the Analysis / Combined
Charts
Multi-period cover ratios Case Study Analysis / Combined
Charts
Multi-period cover ratios Understanding the Analysis
/ Combined Charts
Net Debt % EUV (SH) Asset Value Ratio 53 Ratio Definitions
/ Balance Sheet Capacity
- Gearing and Leverage
Back to top
N
Net debt % NPV (30 years constant) Case
Study Analysis / Charts
Net Debt % NPV (30 years constant) Ratio 54 Ratio Definitions
/ Balance Sheet Capacity
- Gearing and Leverage
Net Debt % NPV (30 years plus TV) Ratio 55 Ratio Definitions
/ Balance Sheet Capacity
- Gearing and Leverage
Net Debt/EBITDA (times) Ratio 47 Ratio Definitions /
Balance Sheet Capacity
- Debt Repayment
Net Debt/Cash Flow after Interest, before Capex (years) Ratio 48 Ratio
Definitions / Balance
Sheet Capacity - Debt Repayment
Net Interest Cover Ratio 44 Ratio Definitions / Balance
Sheet Capacity - Cover Ratios
Net interest cover Case Study Analysis / Charts
Net Operating Cash Flow % Net Capital Expenditure Ratio 41 Ratio
Definitions / Cash
and Tax Ratios
Net Properties % Turnover Ratio 33 Ratio Definitions
/ Asset Utilisation
and Composition
Net working assets % turnover Case Study Analysis / Charts
Net Working Assets % Turnover Ratio 32 Ratio Definitions
/ Asset Utilisation
and Composition
New housing stock Input Guidelines / Social
Housing Property Based
New rental stock / new units Input Guidelines / Non-Social
Housing
Nominal growth rates Ratio Definitions / Nominal
Growth Rates
Nominal growth rates Understanding the Analysis / Financial
Profile
Non business-stream-based expenditure How the Forecast Works
/ I&E Account
Non business-stream-based items How Reconciliation Works
/ I&E Account
Non-property-based business streams How the Forecast Works
/ I&E Account
Non-Social Housing business streams Background / Business
Stream Inputs Structure
Non-Social Housing Input
Guidelines
Number of loans granted each year (units) Input Guidelines
/ Home-Buy
Number of units completed during the year (units) Input Guidelines
/ Social Housing Property
Based
Number of units completed during the year (units) Input Guidelines
/ Non-Social Housing
Number of units demolished by year end (units) Input Guidelines
/ Social Housing Property
Based
Number of units sold during the year (units) Input Guidelines
/ Non-Social Housing
Number of units sold during the year (units) Input Guidelines
/ Social Housing Property
Based
Number of units transferred in / (out) during year (units) Input
Guidelines / Social
Housing Property Based
Back to top
O
Objectives Background / Introduction
and Objectives
Ongoing repairs & maintenance cost inflation (%) Input Guidelines
/ Business Plan Accounting
Data
Operating Margin % Ratio 21 Ratio Definitions / Profitability
Operating margin Case Study Analysis / Charts
Operating Surplus / Employee (£000's) Ratio 29 Ratio Definitions
/ Profitability
Operating Surplus % Total Operating Assets Ratio 23 Ratio Definitions
/ Profitability
Other Assets % Net Total Assets Ratio 36 Ratio Definitions
/ Asset Utilisation
and Composition
Other assets average depreciation rate (%) Input Guidelines
/ Business Plan Accounting
Data
Other inflation - margin above / (below) RPI Input Guidelines
/ Business Plan Accounting
Data
Other Non-Social Housing Input
Guidelines
Other Input Guidelines / Social
Housing Property Based
Overview of analysis screens Background
Overview of Input Screens Background
Overview of what you can do with the CAPACITY model How to Use
the Model / Getting Started
Back to top
P
Peer group How to Use the Model
/ Getting Started
Planning model How to Use the Model / Getting
Started
Print reports How to Use the Model / Getting
Started
Print How to Use the Model / Getting
Started
Producing a New Business Plan How
to Use the Model
Profit and cash cover ratios Case Study Analysis / Combined
Charts
Profit and cash cover ratios Understanding the Analysis
/ Combined Charts
Profit drivers (2) Understanding the Analysis / Profitability
& Cash Flow Maps
Profit drivers Case Study Analysis / Profitability
and Cash Flow Maps
Profit on disposals How the Forecast Works / I&E
Account
Profit on sale (£000s) Input Guidelines / Non-Social
Housing
Profit on sale per unit (£000s) Input Guidelines
/ Social Housing Property
Based
Profit on sale per unit (£000s) Input Guidelines
/ Non-Social Housing
Profitability and cash flow maps Case
Study Analysis
Profitability and cash flow maps Understanding
the Analysis
Profitability Ratio
Definitions
Profitability Understanding the Analysis / Financial
Profile
Properties at cost (£000s) Input Guidelines / Non-Social
Housing
Properties at cost (£000s) Input Guidelines / Social
Housing Property Based
Back to top
Q
Quit How to Use the Model / Getting
Started
Back to top
R
Reconcile and existing plan How to Use
the Model / Getting Started
Reconcile model forecast How to Use the Model / Producing
a New Business Plan
Reconciliation factors How
Reconciliation Works
Reconciliation factors How to Use the Model / Producing
a New Business Plan
Reconciliation factors Understanding
the Analysis
Reconciliation model How to Use the Model / Getting
Started
Reconciliation process How
Reconciliation Works
Reconciling a forecast Background / Logic
of the Model
Reconciling a forecast How Reconciliation Works / Introduction
Reconciling an existing plan How
to Use the Model
Re-formulation of input data Input Guidelines / General
Considerations
Rent and Cost Structure Ratio
Definitions
Rent and Cost Structure Understanding the Analysis /
Financial Profile
Rent receivable Input Guidelines / Social
Housing Property Based
Rental stock sold / units sold Input Guidelines / Non-Social
Housing
Rents receivable Input Guidelines / Non-Social
Housing
Retrieve new or existing plan How to Use the Model /
Getting Started
Retrieve / update existing plan How to Use the Model
/ Getting Started
Revenue grants How the Forecast Works / I&E
Account
Revenue grants % rental income Input Guidelines / Social
Housing Property Based
Revenue grants (£000s) Input Guidelines / Social
Housing Property Based
Revenue grants Input Guidelines / Social
Housing Property Based
Revenue summary Understanding
the Analysis
RPI differential + / - (%) Input Guidelines / Non-Social
Housing
RPI differential + / - (%) Input Guidelines / Social
Housing Property Based
Back to top
S
Sale price per unit (£000s) Input
Guidelines / Non-Social
Housing
Sale price per unit (£000s) Input Guidelines /
Social Housing Property
Based
Save scenario How to Use the Model / Flexing
a Plan
Save How to Use the Model / Producing
a New Business Plan
Save How to Use the Model / Getting
Started
SBIT % Total Assets Ratio 22 Ratio Definitions / Profitability
SHG Received % Payment on Properties Ratio 42 Ratio Definitions
/ Cash and Tax Ratios
Scenario manager How to Use the Model / Flexing
a Plan
Scenarios and sensitivities How to Use the Model / Flexing
a Plan
Scenarios Understanding the Analysis / Scenarios
and Sensitivities
Scheduled debt repayments (£000s) Input Guidelines
/ Business Plan Accounting
Data
Scheduled loan repayment % total debt Case Study Analysis
/ Charts
Scheduled Loan Repayments % Total Debt Ratio 26 Ratio Definitions
/ Profitability
Select a scenario name then load, apply or save How to Use the
Model / Flexing
a Plan
Scenarios and Sensitivities Understanding
the Analysis
Sensitivities Understanding the Analysis / Scenarios
and Sensitivities
Service cost inflation Input Guidelines / Business
Plan Accounting Data
Service income (£000s) Input Guidelines / Non-Social
Housing
Service income and charges for support services Input Guidelines
/ Social Housing Property
Based
Service income Input Guidelines / Non-Social
Housing
Service income / charges for support services (£000s) Input
Guidelines / Social
Housing Property Based
SHG paid back % revenue from sale (%) Input Guidelines
/ Social Housing Property
Based
SHG paid back (£000s) Input Guidelines / Social
Housing Property Based
SHG received % capital expenditure (%) Input Guidelines
/ Social Housing Property
Based
SHG received (£000s) Input Guidelines / Social
Housing Property Based
Show sensitivities How to Use the Model / Flexing
a Plan
Single association How to Use the Model / Producing
a New Business Plan
Single association How to Use the Model / Getting
Started
Size Ratio Definitions
Size Understanding the Analysis / Financial
Profile
Social Housing Non-Property Based business streams Background
/ Business Stream Inputs Structure
Social Housing Non-Property Based Input
Guidelines
Social Housing Property Based business Background / Business
Stream Inputs Structure
Social Housing Property Based Input
Guidelines
Summary of reconciliation factors How
Reconciliation Works
Back to top
T
Table of reconciliation factors How Reconciliation
Works / Reconciliation
Factors
Tax payable How the Forecast Works / I&E
Account
Total Assets (£000's) Ratio 2 Ratio Definitions
/ Size
Total Debt per Unit (£000's) Ratio 49 Ratio Definitions
/ Balance Sheet Capacity
- Gearing and Leverage
Total housing stock Input Guidelines / Social
Housing Property Based
Total Number of Employees (units) Ratio 4 Ratio Definitions
/ Size
Total number of employees (units) Input Guidelines /
Business Plan Accounting
Data
Total Number of Units (thousands) Ratio 3 Ratio Definitions
/ Size
Total rental stock / total units Input Guidelines / Non-Social
Housing
Total Rents Receivable (£000's) Ratio 1 Ratio Definitions
/ Size
Total rents receivable Case Study Analysis / Charts
Trends in balance sheet Case Study Analysis / Combined
Charts
Trends in balance sheet Understanding the Analysis /
Combined Charts
Trends in income and expenditure Case Study Analysis
/ Combined Charts
Trends in income and expenditure Understanding the Analysis
/ Combined Charts
Turnover / Total Operating Assets (times) Ratio 34 Ratio Definitions
/ Asset Utilisation
and Composition
Back to top
V
Value drivers (4) Understanding the Analysis
/ Profitability
& Cash Flow Maps
Value drivers Case Study Analysis / Profitability
and Cash Flow Maps
Values of debt to NPV of cash flows Understanding the Analysis
/ Combined Charts
Voids and bad debts Input Guidelines / Non-Social
Housing
Voids and bad debts Input Guidelines / Social
Housing Property Based
Back to top
W
Weeks in year (units) Input Guidelines
/ Business Plan Accounting
Data
Worst case How to Use the Model / Flexing
a Plan
Written-down value per unit (£000s) Input Guidelines
/ Social Housing Property
Based
Back to top
|