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
| << Scenarios and Sensitivities | Index of Topics >> |