The 40-year modelling spreadsheet is also called the financial modelling spreadsheet, the Radical Routes spreadsheet, the 40-year spreadsheet or the business plan.
This spreadsheet gets updated regularly by Catalyst Collective. At the time of writing, in May 2025, the most up to date version is version 3.3.5. The spreadsheet is available in the RRModel Spreadsheet online file storage.
The spreadsheet works best when downloaded to a device, and opened in Libreoffice - in the .ods file format. Libreoffice is a free, open source office suite similar to Microsoft Office. Once Libreoffice is downloaded, the spreadsheet software we recommend using, and that the spreadsheet was designed to be used on, is called LibreOffice Calc. It is possible to use Google Sheets or Microsoft Excel however we have noticed glitches in the calculations and protected cells, therefore advise against it.
If you are trying to fill in the spreadsheet, it will help to have the following information to hand. This guidance has come about from filling in the spreadsheet for an already housed coop. Much of it will also be applicable to an unhoused coop, and in some places estimate figures will need to be used.
1. Cash in the bank - This is total money in the co-op's name, in all co-op bank accounts, including savings.
2. fixed assets - Find this information on the most recent balance sheet, representing the value of all property owned by the coop. This is zero if your co-op does not own any property.
3. rental income - Be careful to input this correctly, either per week or per month
4. most recent mortgage statement - The information needed from this document is 1) capital balance, 2) interest rate, and 3) monthly payment.
5. Radical Routes loan statement - The header of this document should say ""Co-operative & Community Finance"" as well as Radical Routes because CCF administer RR loans. The information needed from this document is 1) capital balance, 2) interest rate, and 3) monthly payment
6. outstanding loanstock details - This should include 1) starting dates, 2) length in years, 3) interest rate, 4) amount, 5) simple/compound interest. The name of the lender should only include the initials, so for example loanstock from Zara Chowdhary should appear as 'ZC'. This is so that when the spreadsheet is shared externally, the loanstock investors are not identifiable.
7. annual council tax
8. annual insurance cost
9. annual maintenance spend - This could be the average over 3 years, or an annual maintenance budget, or an estimate with a minimum of £250 per bedroom per year
10. Local Housing Allowance rate - LHA is calculated by inputting the postcode of the property on the [government LHA calulator. The figure we use generally is the shared accommodation rate - correlating to one person paying 1 rent per bedroom. However, other rates may be applicable if, for example, a member is entitled to the 1 bedroom rate if they are receiving disability benefits, more bedrooms if they have dependents etc.
11. bank charges - Many RR coops bank with Coop bank (free), or Unity Trust Bank (£72 per year, or £6 per month)
12. any other regular income - For example - regular donations
13. any other regular expenses - For example, travel, website hosting costs, internet or a building service charges. This should not include electric, gas or water bills as RR recommends these costs are dealt with as separate from the co-op's expenses, and housing co-ops charge separately for bills. The spreadsheet may or may not include internet expenses, depending on whether this is paid for by the coop.