jagomart
digital resources
picture1_Excel Sheet Download 30841 | Copy Of Locarla Financial Comparison Data Analysis 2020 75 Has


 267x       Filetype XLSX       File size 0.11 MB       Source: housingnet.co.uk


File: Excel Sheet Download 30841 | Copy Of Locarla Financial Comparison Data Analysis 2020 75 Has
sheet 1 notes locarla financial data analysis for 75 housing associations 20192020 where figures are not available in report we have calculated using the formulae below and coloured them operating ...

icon picture XLSX Filetype Excel XLSX | Posted on 08 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: NOTES
LOCARLA - Financial Data Analysis for 75 Housing Associations (2019/2020)




Where figures are not available in report, we have calculated using the formulae below and coloured them


Operating Cost Per Home (£) = Operating costs on social housing lettings / Combined Group Stock


R & M Cost Per Home (£) = (Routine Repairs & Maintenance Expenditure + Planned Maintenance Expenditure) / Combined Group Stock


Management Cost Per Home (£) = Management cost / Combined Group Stock


Cost / property of the Repairs Service (£) = Routine Repairs & Maintenance Expenditure (£) / Combined Group Stock


Chief Executive Pay Per Home (£) = Chief Executive Pay / Combined Group Stock

Sheet 2: LOCARLA_Data Analysis_2019_2020
LOCARLA - Financial Data Analysis for 75 Housing Associations (2019/2020)




Turnover - 2020 Turnover - 2019 Difference % Change
£11,705.63M £11,413.27M (£292.36M) (2.56)








Operating Surplus - 2020 Operating Surplus - 2019 Difference % Change
£3,352.32M £3,537.16M (£185.84M) (5.23)








Operating Margin - 2020 Operating Margin - 2019 Difference % Change
24.82% 27.78% (2.96%) (10.65)








EBITDA MRI Interest Cover - 2020 EBITDA MRI Interest Cover - 2019 Difference % Change
178.99% 200.33% (21.33%) (10.65)








Repairs Satisfaction - 2020 Repairs Satisfaction - 2019 Difference % Change
89.70% 88.00% (1.70%) (1.93)








Operating Cost Per Home - 2020 Operating Cost Per Home - 2019 Difference % Change
£4263.77 £4079.54 £184.23 4.52








R & M Cost Per Home - 2020 R & M Cost Per Home - 2019 Difference % Change
£1,218.12 £1,168.68 (£49.44) (4.23)








Management Cost Per Home - 2020 Management Cost Per Home - 2019 Difference % Change
£1,233.43 £1,224.91 (£8.52) (0.70)








Responsive Repairs Service Cost Per Home - 2020 Responsive Repairs Service Cost Per Home - 2019 Difference % Change
£790.72 £817.89 (£27.17) (3.32)








Average Days to Relet - 2020 Average Days to Relet - 2019 Difference % Change
25.69 25.62 0.07 0.27








Routine Repairs & Maintenance Expenditure - 2020 Routine Repairs & Maintenance Expenditure - 2019 Difference % Change
£1,203.43M £1,194.65M £8.78 0.74








Planned Maintenance Expenditure - 2020 Planned Maintenance Expenditure - 2019 Difference % Change
£538.35M £532.48M £5.88M 1.10








Major Repairs Expenditure - 2020 Major Repairs Expenditure - 2019 Difference % Change
£224.09M £206.68M £17.41M 8.42








Void Losses - 2020 Void Losses - 2019 Difference % Change
£101.49M £98.58M £2.91M 2.95








Improvement Works Spend - 2020 Improvement Works Spend - 2019 Difference % Change
£1,828.72M £1,793.47M £35.25M 1.97








Number of Employees - 2020 Number of Employees - 2019 Difference % Change
66,372 63,791 2,581 4.05








Wages / Bill - 2020 Wages / Bill - 2019 Difference % Change
£2,138M £2,001M £137M 6.85








Chief Executive pay - 2020 Chief Executive pay - 2019 Difference % Change
£13.08M £12.43M £0.65M 5.25








Chief Executive pay per home - 2020 Chief Executive pay per home - 2019 Difference % Change
£23.48 £23.85 (£0.82) (3.44)

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet notes locarla financial data analysis for housing associations where figures are not available in report we have calculated using the formulae below and coloured them operating cost per home pound costs on social lettings combined group stock r amp m routine repairs maintenance expenditure planned management property of service chief executive pay turnover difference change surplus margin ebitda mri interest cover satisfaction responsive average days to relet major void losses improvement works spend number employees wages bill...

no reviews yet
Please Login to review.