100 likes | 232 Views
Community Land Trusts Conference 29 June 2010. CLTF Project appraisal tool. Background. Understanding of housing development & funding of housing – particularly affordable Tenure & affordability options Expectations of affordable housing viability
E N D
Community Land Trusts Conference 29 June 2010 CLTF Project appraisal tool
Background • Understanding of housing development & funding of housing – particularly affordable • Tenure & affordability options • Expectations of affordable housing viability • Time spent re-inventing the wheel in TAF commissions
Objective • To generate a long term financial appraisal tool and associated guidance notes which will be usable by CLTs or their professional advisors
Process • Briefing/inception • Collect information from funders & stake holders • Draft work book & guidance notes • Share with reference group • Feedback • Show-case at CLTs conference
Guidance notes • Policy context • Financing development • Tenure & affordability options • Lenders’ requirements • HCA requirements • TSA requirements • Viability assessments
The appraisal tool • 19 linked work sheets: navigate by tabs • Guidance notes • Range of procurement options • Range of tenure types • Risk • Options • Sensitivity analysis
Data input • Project information sheet • Development cash flow sheet • Tenure/affordability options: social rent, intermediate market rent, market rent, equity share, HomeBuy, outright sale, Mutual Home Ownership
Outputs • KPIs • Summary • Cash flow: development period and long term • Balance sheet • I&E account
Access & use • Free to CLTs and their advisors • To be hosted on CLTF web site • Down-loadable macro-enabled Excel spreadsheet • Alerts from wrong/missing data