Background
What are the green cells used for?
How do I link the data file to my existing model?
Can I reconcile the model part way through the process?
Why do I have to split out the movement in short -term debt and
long -term debt in the cash flow forecast?
What type of flexes will the corporation carry out?
Can I use the zoom function on the model?
Q: What are the green cells used
for?
A: Data must be entered in the green cells for reconciliation purposes. For
example, if appropriate, the Gross Rental Income for Housing Accommodation must
be entered so that the model can reconcile the value it calculates using other
input assumptions against this input value. If the two values don’t match
precisely the model will create a reconciliation factor. This allows the model
to mimic the output from your own business plan exactly.
The values in cells with no fill are calculated by the model.
Blue cells require data to be entered, if appropriate, whether the model is
to be used for an original forecast or for reconciliation purposes.
Yellow cells only require data if the model is being used for an original forecast
as the model will derive values if being used for reconciliation purposes.
Back to top
Q: How do I link the data file to
my existing model?
A: The CAPACITY model is a calculation engine only. Data is not saved with the
model but as a separate data sheet. This allows you to create as many data sheets
as you wish and load them through the menu structure into the model as required.
By entering data into the model and then “saving”, the model will
create a data sheet. Alternatively you can use the data sheet and create links
to your own model. The data sheet is colour coded with labels to help you define
the links. Once you have created the linked sheet you can copy the sheet and
paste the values into a second blank data sheet that the model can read and
load. Be sure to give the two files different names and make sure you don’t
try to load the linked file into the model. Attaching the linked sheet to your
own model as a sheet within your model’s workbook would safeguard against
this.
Back to top
Q: Can I reconcile the model part
way through the process?
A: No. The model can only complete the reconciliation process when all relevant
data has been input.
Back to top
Q: Why do I have to split out the
movement in short -term debt and long -term debt in the cash flow forecast?
A: You don’t have to unless you have movements in long-term and short-term
debt on the balance sheet. The input and output formats of the financial statements
in the model follow the SORP and separate short-term and long-term debt. If
there are movements in short-term debt on the balance sheet these should be
reflected in the cash flow as should any other movements.
Back to top
Q: What type of flexes will the
corporation carry out?
A: The standard flexes to be carried out are as follows:
• Floating interest rates up 1%
• Real management cost increases up 1%
• Real repair cost increases up 1%
• Build costs up 5%
• Number of units up 10%
• Stop all development from year five onwards
Back to top
Q: Can I use the zoom function on
the model?
A: No. This is a “one-size-fits-all” standardized model and to prevent
changes being made to the model it is controlled by a macro shell that disables
the Excel menus.
Back to top
All enquiries about CAPACITY or the website should
be addressed to :
faenquiries@housingcorp.gsx.gov.uk