Training can be integrated into a wider package of work delivered by Beacon Partnership. This could include training on how to create and interpret financial appraisals as part of training on the use of Optimix or to help embed new policies and procedures developed by Beacon Partnership.
In addition to the specific training provided for the use of Optimix, we can provide training on a variety of topics, including:
- The development process
- How to carry out financial appraisals of a development scheme
- The factors underpinning financial viability
Free training events
How much grant is reasonable?
In this session we will run through land, works and on-costs by region in order to present a range of costs per unit type.
We will then present our estimates of the borrowing that can be supported from the rental income for each type of home.
The difference between the costs and sales/rental income will leave us with a subsidy gap, which is the maximum grant requirement.
The format of the session will be a 50 minute presentation followed by an open discussion.
We will not record the sessions nor allow recording in order to allow attendees to discuss their experiences and our findings informally and in confidence.
Introduction to Excel (Basic)
10am to 12pm
This on-line session is for people that are new to excel or are not confident in using excel for basic tasks. By the end of the session attendees should understand how to enter information into existing excel models and create their own basic spreadsheets.
This session is free to attend if you work for a Council or Registered Provider that uses Optimix. It is open to all employees including those working in all departments. We will issue a certificate to those that attend and we are looking to register the session for CPD points.
The session is 2 hours and will cover the following.
- Opening and closing workbooks
- Excel Screen layout (worksheets, cells, ribbons, scroll bars)
- Entering Data
- Basic Formulae (add, subtract, multiply, divide, average, minimum, maximum, sumproduct)
- Formatting cells, text, adding comments
- Copying formulae, freezing cell references
- Freeze pains / viewing options
- Adding and removing protection
- Hide/Unhide cells and sheets
- Printing, page layout, print area, fit to page
Depending on numbers we intend to run this course once a quarter and we will introduce a free follow up intermediate course if attendees want to go into further depth.
Optimix – Basic Introduction
These sessions are for people that are new to Optimix. The session covers inputting schemes and analysing performance of schemes and individual unit types. The session will include an overview of assumptions, finacnial hurdles and reporting.
Optimix – Intermediate
These sessions are for people that can already input a basic scheme but want to learn about more advanced features. The session will cover using Optimix for stock transfers, incorporating rent loss from demolition, adjusting cashflows for income strips and/or taxation. It will also cover importing old appraisals and creating bespoke input and output sheets
Optimix – Consolidator
This session covers consolidations of schemes and phases using the Optimix Consolidator. It will cover reporting on monthly/annual spend, completions, programme viability and importing into HRA and RP business plans.
Building a basic viability model
In this fast paced session we will build a basic rented viability model from scratch in excel and explain how the model is put together. By the end of the session attendees should understand the inputs and assumptions that feed into a viability model and how they combine to produce and calculate loan calculations and net present value.
Building Shared Ownership Appraisals
In this fast paced session we will build a basic shared ownership viability model from scratch in excel and explain how the model is put together. By the end of the session attendees should understand the inputs and assumptions that feed into a viability model and how they combine to produce and calculate loan calculations and net present value.
Feedback and testimonials from previous training sessions
“I really liked the pace of it. I also liked building an appraisal from scratch rather than just inputting figures into existing fields that already have been pre-formatted. I also liked the market evidence and insights on common assumptions and operating parameters that Steve brought to the training.
Nick Enge, Homes England
“The Optimix tool is more logical and user friendly than other appraisal systems and Steve delivered training really well and pace was good. Plus he clearly knows it inside out.
Peter Blake, Head of Regeneration, One Housing Group
“I enjoyed the detailed explanation of each element of the model as it was being built. Steve was really helpful in explaining the interrelationship between elements also.
Lauren Sinclair, Interim Programme Manager, London Borough of Haringey
“I felt the length of the presentation was appropriate and effectively demonstrated modelling the viability of a scheme from beginning through to the end.
Abdi Rahman, Project Manager – Strategic Partnerships, L&Q
“Covered all the basics. Having Steve present and Vince assist worked well. The anecdotal info was helpful.
Steve Connor, Phoenix Community Housing