Training

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.

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
• Charts
• 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.

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.

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

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.

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.

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.