Name: Sew a skirt in a day - Ramona
Price: 90 GBP
Availability: InStock

Ipswich

<h1 dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Overview:</h1>This training based on leading teams will help you to develop anyone that leads a team or is involved in a leadership role. It is also useful for those that are about to embark on a position of leadership or need to develop their leadership skills.Course Contents:Having an effective team around you is crucial. However, it is an area that is often left to chance, which can lead to de-motivated individuals that do not feel part of the business and consequently do not perform. This course looks at what it takes to lead an effective team and how you can get the best out of the people in it by understanding the role of the leader, both personally and from the point of view of the team.Course Topics:<ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Qualities of an Effective Leader&nbsp;&ndash; Identifying the key characteristics of effective leaders, rating themselves against them and establishing key actions to develop the skills.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Leader or Manager?&nbsp;&ndash; Establishing the difference between the two and comparing themselves to those qualities.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">That Vision Thing&nbsp;&ndash; Making the business vision &lsquo;live&rsquo; for the team by answering key questions.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Developing Your Team Goals&nbsp;&ndash; Reviewing an action plan that develops clear goals for their team based on the business vision.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Motivation&nbsp;&ndash; Determining the &lsquo;Why&rsquo; for their staff and developing an understanding of emotions in a business context.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">What Motivates?&nbsp;&ndash; Looking at specific motivators for individuals and understanding that everyone is motivated by different things.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Being Consistently Different&nbsp;&ndash; Going against popular leadership theory and identifying that each staff member needs to be treated differently.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Dealing With Difficult Team Members&nbsp;&ndash; Understanding why team members are difficult. Looking at different behavior types and strategies for responding to them. Also, realizing that &lsquo;difficult&rsquo; behavior sometimes has its benefits.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Coaching&nbsp;&ndash; Using a simple method of coaching, including action plans.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Three Key Skills of Coaching&nbsp;&ndash; Looking at the skills required to be an effective coach.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Instant Results Coaching&nbsp;&ndash; Coaching in a hurry!</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Can Do Coaching Practice&nbsp;&ndash; Putting the learning into practice</li></ul>Course Feature:By the end of this training you will be able to:<ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the qualities of an effective leader</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Benchmark themselves against those qualities and develop actions to improve</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the difference between leading and managing</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the value of sharing the business vision with the team</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Develop team goals based on the business vision</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Motivate their staff by understanding their drivers and developing actions to support them</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Deal with difficult staff members</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Challenge staff in a meaningful and effective way</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Coach staff effectively using a simple process</li></ul>Certification:Once after the training you receive course completion certificate from MangatesWho can Attend?Anybody who is interested in learning Effective Skills to Lead a Team.

Certificate: Course Completion Certificate | Language: English
Duration: 1 Day | Credits: 8 PDUs
Course Delivery: Classroom | Virtual Live
Lunch and Beverages are included in a classroom session

Course Overview:
Disagreements, differences of opinion and conflicting perspectives on key issues inevitably arise in any context where people are working together.
Research has shown that workplace conflicts can become highly destructive. Negative emotions may be stirred up, poisoning team morale, creating stress and destroying relationships.
Conflict may emerge between managers and their staff, between team members or departments.
Conflict may be expressed openly, but it may also be hidden, in the form of irritation, resentment, loss of morale and lack of commitment. Hidden conflict is easy to miss and therefore can be particularly damaging.
Ultimately, this is likely to have an adverse effect on team and company performance, costing time and money.
It is therefore vital to manage conflict constructively.
As a team member and leader, your ability to deal with and resolve conflicts defines your success in the longer term.
Our one day workshop in Conflict Management and Communication Skills immerses you in the most advanced conflict management tools, strategies and practices applicable today. You will gain hands-on practice on proven frameworks, go through simulations and exercises that will train you to be a highly effective professional and leader, starting day one.
Target Audience:
Anybody who is interested in learning Conflict Management Skills

Learning Objectives:
Getting a handle on and gaining insights into your conflict management style through self-assessments (TKI®).
Role playing to practice techniques and new skills in a safe environment.
Proven best practices for approaching conflict management.
Practices for resolving conflict as a third party mediator.
Scientifically validated frameworks on effective communication in stressful situations.
Transferring your learning back to your work environment using job aids, templates and other resources.
How Will You Benefit?
Build trust and credibility with colleagues and team members
Leverage potential conflict situations as opportunities for critical conversations that enhance work relationships.
Gain confidence in holding difficult conversations calmly and assertively.
Manage difficult situations proactively.
Increase your effectiveness in managing conflict.
See growth in your overall performance
Agenda:
Science behind workplace conflicts
Understanding Human Behavior
Different Personality Types
Conflict Management Styles
Conflict Management Strategies
Workplace Conflicts
Conflict Resolution Agreements
Working with difficult people
Relationship and reputation management
Certification:
Once after the training we will provide you with the course completion certificate.

Mangates

Conflict Management

Conflict Management 1 Day Training in Ipswich

The sale ends 5 days before the event starts.

Early Bird Fee

The sale ends 10 days before the event starts.

Standard Fee

Heathrow

Conflict Management 1 Day Training in Heathrow

Gloucester

Conflict Management 1 Day Training in Gloucester

Dumfries

Conflict Management 1 Day Training in Dumfries

Darlington

Conflict Management 1 Day Training in Darlington

Cork

Conflict Management 1 Day Training in Cork

Chatham

Conflict Management 1 Day Training in Chatham

Certificate: Course Completion Certificate | Language: English

Duration: 1 Day | Credits: 8 PDUs

Course Delivery: Classroom | Virtual Live

Lunch and Beverages are included in a classroom session

Course Overview:

Personal time management skills are essential for professional success in any workplace. Those able to successfully implement time management strategies are able to control their workload rather than spend each day in a frenzy of activity reacting to crisis after crisis - stress declines and personal productivity soars! These highly effective individuals are able to focus on the tasks with the greatest impact to them and their organization.
The Time Management workshop will cover strategies to help participants learn these crucial strategies. You will be given a skill set that includes personal motivation, delegation skills, organization tools, and crisis management. We"ll cover all this and more during this workshop.

Learning Objectives:

After completing this course, the learners will be able to: 

Explore why time management issues arise
Improve ability to plan and prioritize work
The importance of setting clear goals
Minimize wasted time and distractions in the workplace
How to avoid being deflected from your priorities
Self-motivation as a time management tool
Dealing with unexpected events that steal time
Tools and techniques for effective delegation
How to say 'no' to some 'now' requests

Agenda:

Module One: Goal Setting
The Three P"s
S.M.A.R.T. Goals
Prioritizing Your Goals
Visualization

Module Two: Prioritizing Your Time
The 80/20 Rule
The Urgent Versus Important Matrix
Assertiveness

Module Three: Planning Wisely
Creating Your Productivity Journal
Maximizing the Power of Your Productivity Journal
The Glass Jar: Rocks, Pebbles, Sand, and Water
Chunck, Block, and Tackle
Ready, Fire, Aim!

Module Four: Tackling Procrastination
Why We Procrastinate
Nine Ways to Overcome Procrastination
Eat That Frog!

Module Five: Crisis Management
When the Storm Hits
Creating a Plan
Executing the Plan
Lessons Learned

Module Six: Organizing Your Workspace
Declutter
Managing Workflow
Dealing with Email
Using Calendars

Module Seven: Delegating Made Easy
When to Delegate
To Whom Should You Delegate?
How Should You Delegate
Keeping Control
The Importance of Full Acceptance

Module Eight: Setting a Ritual
What is a Ritual?
Ritualizing Sleep, Meals, Exercise
Examples of Rituals
Using Rituals to Maximize Time

Module Nine: Meeting Management
Deciding if a Meeting is Necessary
Using the PAT Approach
Building the Agenda
Keeping Things on Track
Making Sure the Meeting Was Worthwhile

Module Ten: Alternatives to Meetings
Instant Messaging and Chat Rooms
Teleconferencing
Email Lists and Online Groups
Collaborating Applications

Module Eleven: Wrapping Up
Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Target Audience:

Anybody who is interested in Learning Time Management Skills.

Time Management 1 Day Workshop in Cork

Edinburgh

On this Introduction to lino printing onto fabric workshop, local artist Suzanne Kemplay will help you explore ways of creating simple images and striking patterns from which you will print your own, unique tote bag or tea towel.
This is a hands-on, practical and fun workshop where you will learn how to create an original design, cut your design onto lino, add ink, and print onto fabric. You will gain the confidence you need to create beautiful prints at home without the need for expensive equipment. You can bring your own fabric, or plain t-shirt to the workshop if you wish.
The price includes access to all the equipment and materials you will need.

More information&nbsp;
The Arienas Collective workshops, courses and events are run from a supportive and welcoming home-based environment within a Georgian mews home in Edinburgh&rsquo;s City Centre New Town. We invite you to join us, leave any day-to-day worries behind, and immerse yourself in being creative.
Spaces on our workshops and courses are limited so that our creative team of artists and makers can offer you the hands-on help and support you need to make the most of your time with us.&nbsp;
All the equipment and materials you will need are included in the price, unless stated otherwise, plus light refreshments (a selection of Shibui teas, coffee, hot chocolate, and sweet or savoury snacks). On full day workshops you are welcome to bring your own lunch to eat inside or out; or there are a wide range of independent sit-in or takeaway delis, caf&eacute;s, and restaurants, plus supermarkets, within a 5-10 minute walk.
PLEASE NOTE: Our workshop space is on the first-floor of a Georgian mews building and unfortunately we do not have lift access. The workshop space is in our home which is&nbsp;not&nbsp;nut free. Please let us know of any skin or food allergies before booking.
Private workshop bookings
Most of our workshops are also available to book for small private get-togethers; themed wedding and birthday celebrations; corporate team building and well-being purposes; and as in-store retail events. For larger groups, many of our workshops can be brought to a location of your choice. Please email Lynn or phone 07732 901150 for more information.
Age restrictions
Our workshops are planned with adults in mind. Many are suitable for teenagers, but some may require under 16s to be accompanied for insurance purposes. Please check with us before booking.

On this Introduction to lino printing onto fabric workshop, local artist Suzanne Kemplay will help you explore ways of creating simple images and striking patterns from which you will print your own, unique tote bag or tea towel.
This is a hands-on, practical and fun workshop where you will learn how to create an original design, cut your design onto lino, add ink, and print onto fabric. You will gain the confidence you need to create beautiful prints at home without the need for expensive equipment. You can bring your own fabric, or plain t-shirt to the workshop if you wish.
The price includes access to all the equipment and materials you will need.
Please note: the May 2025 workshop may be held in a different venue.



More information 
The Arienas Collective workshops, courses and events are run from a welcoming and supportive environment within a Georgian mews home in Edinburgh’s City Centre New Town. We invite you to join us, leave any day-to-day worries behind and immerse yourself in being creative.
Spaces on our workshops and courses are limited so that our creative team of artists and makers can offer you the hands-on help and support you need to make the most of your time with us. 
Our taster and introductory workshops focus on teaching creative skills and methods you can continue practising at home, using affordable materials and equipment. Where more expensive equipment is required we will mention this in the workshop description.
All the equipment and materials you need are included in the price, unless stated otherwise. 
Light refreshments from local suppliers are provided. On full day workshops you are welcome to bring your own lunch to eat inside or out. There is also a wide range of independent sit-in or takeaway delis, cafés, and restaurants, plus a range of supermarkets all within a 5-10 minute walk.
Accessibility
The workshop space is on the first-floor of our Georgian mews home and unfortunately we do not have lift access. Blue badge holders can park outside our front door on the single yellow line by arrangement.
Allergies
The workshop space is in our open plan living space and is not nut free. Please let us know about any skin or food allergies before booking. We offer a dairy-free milk and gluten free snack alternative.
Minimum number no refund policy
To ensure we can always pay our creatives a fair fee, we require a minimum number of bookings for each workshop and for this reason bookings are non-refundable. Should we have to cancel due to low numbers, we will offer you the option to swap to an alternative date or workshop, or to request a refund.
We do our very best to avoid cancellations. Since we often get late bookings, we keep our workshops on sale for as long as possible. We realise that some of you travel from afar, so if you book a space and have not yet received an email confirming your workshop is going ahead and need to make plans for your trip, please get in touch before booking any travel or accommodation so we can update you on booking numbers. Or check in before booking.
Private workshop bookings
Most of our workshops are also available to book for: private get-togethers with family and friends; themed wedding and birthday celebrations; corporate team building and well-being purposes; and in-store retail events for your customers. If you’d like to know more please Email Lynn.
Age restrictions
Our workshops are planned with adults in mind. Many are suitable for teenagers, but some may require under 16s to be accompanied for insurance purposes. Please check with us before booking.

The Arienas Collective

Arts & Crafts

Learn how to lino print onto fabric in this workshop run by local artist Suzanne Kemplay at The Arienas Collective in Edinburgh City Centre

Lino printing onto fabric

General admission

Brackley

Description

Its time to develop your me made wardrobe and what better garment to include but the Ramona Pencil / Mini Skirt by Tilly and the Buttons. This beginners workshop is also a great first garment as we have time to cover the basic dressmaking skills of measuring, choosing sizes and reading a pattern.




What you will learn/achieve
To measure your body to find the best size for you
How to construct the skirt using a sewing machine and iron to press seams
Inserting an invisible zip using an invisible zip foot
Finishing the skirt with a neat hem




What's included
Tuition: full instruction and support in a small class (maximum of 6).

Use of our Pfaff machines in Stitching Kitchen's fully equipped studio.

A paper copy of the Ramona pattern worth £18.50 is included, fabric bundles will be available to buy too just add to the cart along with your ticket, images of the fabric choices are in the photos above.

Tea and cake.




What to bring
Fabric and notions unless you have purchased a bundle from us. A packed lunch as we will break for lunch half way through. 


Please note that this workshop is held in our light and spacious first floor studio at Stitching Kitchen, which is accessible by stairs. 




About your tutor
Priti loves to sew. Her mum was a seamstress and she loved to watch her work. Priti found time during lockdown to get back into sewing, she teaches in her day job and is blending her skills to run beginner sewing workshops.





If you have any questions, please feel free to get in touch.


Stitching Kitchen

Make a pencil skirt or mini skirt in a day at Stitching Kitchen

Sew a skirt in a day - Ramona 

General Admission

Real Estate Financial Modelling School (5 days)The Real Estate Financial Modelling School is an intensive week meticulously designed to teach the best practices to create flexible and robust cash flows in Excel.This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance &amp; Risk.The school combines three of our courses:<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Analyst</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Investor</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Modelling Masterclass</li></ul> All of the courses are interlinked to give you a full understanding of the subject using Excel. On this course you will&hellip;<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Implement cash flows in excel throughout the whole week.</li><li value="2" fr-original-style="" style="box-sizing: border-box;">In the first two days you will learn how to develop rent functions and net operating income. We will show you how to value and appraise property investments and analyse the results.</li><li value="3" fr-original-style="" style="box-sizing: border-box;">On the third and fourth day you will learn how to model and analyse development projects using both residuals and cash flow methods. It will show you how to interrogate and compare alternative return metrics such as profit-equity multiples, profit and cost, net present value, worth and internal rate of return. Additionally you will cover how to model cash flow from different sector office, retail and leisure.</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Finally on the fifth day debt structures will be covered as well as joint ventures and partnership financing. You will also learn how to implement the full spectrum of the risk analysis from sensitivity to Monte Carlo.</li></ul> Who will benefit from this school?<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Real Estate Managers who would like to gain an understanding of the dynamics of debt and financial return fluctuations in more detail</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Property industry modellers who would like to be fully proficient in building complex financial models</li></ul> Course OutlineDay OneReal Estate Analyst IKnow how to build a property asset cash flow, analyse geared, and un-geared IRRs.<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Term &amp; Reversion and Layer Method Valuation (Intro to Excel)</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Equivalent Yield (Solver, Scenario and Goal Seek functions)</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Single-Let Discounted Cash Flow</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analysis and use of date series</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Internal Rate of Return (IRR) and Net Present Value (NPV)</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Comparing Value, Price and Worth</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Adding borrowing and analysing geared returns</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Introducing Rent Reviews and other &lsquo;events&rsquo; into cash flows</li><li value="10" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; concept and Logic functions (IF,OR,AND)</li><li value="11" fr-original-style="" style="box-sizing: border-box;">Sensitivity analysis</li></ul> Day TwoReal Estate Analyst IIKnow how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; and Multi-let cash flows</li><li value="2" fr-original-style="" style="box-sizing: border-box;">The &lsquo;date problem&rsquo; and assumptions in property asset cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Reducing the rent function, intermediate calculations and modelling theory</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Modelling lease expiries, break clauses, voids, and upward only covenants</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Incorporating time-varying rental growth rates</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Analysing multi-let cash flows to see if the leases are sufficiently diversified</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Further IRR analysis (XIRR, MIRR)</li></ul> Day ThreeReal Estate Investor I<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Modelling international variations in real estate income streams i.e. Includes indexation patterns, rent caps, discounts / premiums to indexation, rent free periods, as well as how to deal with costs during vacancy</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Modelling sector variations in real estate income streams i.e. Office versus industrial, retail &amp; leisure</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Further senior debt covenants</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Advance Rent Function techniques to manage feature rich lease structures</li></ul> Day FourReal Estate Investor II<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Introduction to development appraisals</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Residual models, site and profit calculations</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Development cash flows versus Investment cash flows</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Introduction to straight line versus S-curve costing</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Phased asset sales in development appraisals</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Discounting development cash flows</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Complimentary return metrics for development appraisals</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Introduction to development finance</li></ul> Day FiveReal Estate Modelling Masterclass<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Mezzanine debt modelling</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Joint Venture structures between developers and lender/equity partners</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Promote and profit share structure calculations</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Advance project cash flows with mezzanine debts</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Key Real Estate and investment risks, risk adjustment of exit yields</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Sensitivity and Scenario Analysis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Monte Carlo Analysis</li></ul> Included in the Course<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul> For more information about the Real Estate Financial Modelling School such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:E - s.musgrave@bayfieldtraining.comT - 01223 517851W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a>



Real Estate Financial Modelling School (5 days)
The Real Estate Financial Modelling School is an intensive week meticulously designed to teach the best practices to create flexible and robust cash flows in Excel.
This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance & Risk.
The school combines three of our courses:
Real Estate Analyst
Real Estate Investor
Real Estate Modelling Masterclass


All of the courses are interlinked to give you a full understanding of the subject using Excel.


On this course you will…
Implement cash flows in excel throughout the whole week.
In the first two days you will learn how to develop rent functions and net operating income. We will show you how to value and appraise property investments and analyse the results.
On the third and fourth day you will learn how to model and analyse development projects using both residuals and cash flow methods. It will show you how to interrogate and compare alternative return metrics such as profit-equity multiples, profit and cost, net present value, worth and internal rate of return. Additionally you will cover how to model cash flow from different sector office, retail and leisure.
Finally on the fifth day debt structures will be covered as well as joint ventures and partnership financing. You will also learn how to implement the full spectrum of the risk analysis from sensitivity to Monte Carlo.


Who will benefit from this school?
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
Mid-level to senior Real Estate Analysts
Real Estate Managers who would like to gain an understanding of the dynamics of debt and financial return fluctuations in more detail
Property industry modellers who would like to be fully proficient in building complex financial models


Course Outline
Day One
Real Estate Analyst I
Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.
Term & Reversion and Layer Method Valuation (Intro to Excel)
Equivalent Yield (Solver, Scenario and Goal Seek functions)
Single-Let Discounted Cash Flow
Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)
Analysis and use of date series
Internal Rate of Return (IRR) and Net Present Value (NPV)
Comparing Value, Price and Worth
Adding borrowing and analysing geared returns
Introducing Rent Reviews and other ‘events’ into cash flows
The ‘Rent Function’ concept and Logic functions (IF,OR,AND)
Sensitivity analysis


Day Two
Real Estate Analyst II
Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.
The ‘Rent Function’ and Multi-let cash flows
The ‘date problem’ and assumptions in property asset cash flows
Reducing the rent function, intermediate calculations and modelling theory
Modelling lease expiries, break clauses, voids, and upward only covenants
Incorporating time-varying rental growth rates
Analysing multi-let cash flows to see if the leases are sufficiently diversified
Further IRR analysis (XIRR, MIRR)


Day Three
Real Estate Investor I
Modelling international variations in real estate income streams i.e. Includes indexation patterns, rent caps, discounts / premiums to indexation, rent free periods, as well as how to deal with costs during vacancy
Modelling sector variations in real estate income streams i.e. Office versus industrial, retail & leisure
Further senior debt covenants
Advance Rent Function techniques to manage feature rich lease structures


Day Four
Real Estate Investor II
Introduction to development appraisals
Residual models, site and profit calculations
Development cash flows versus Investment cash flows
Introduction to straight line versus S-curve costing
Phased asset sales in development appraisals
Discounting development cash flows
Complimentary return metrics for development appraisals
Introduction to development finance


Day Five
Real Estate Modelling Masterclass
Mezzanine debt modelling
Joint Venture structures between developers and lender/equity partners
Promote and profit share structure calculations
Advance project cash flows with mezzanine debts
Key Real Estate and investment risks, risk adjustment of exit yields
Sensitivity and Scenario Analysis
Monte Carlo Analysis


Included in the Course
CPD Accredited Certificate & LinkedIn Proficiency Badge
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Real Estate Financial Modelling School such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Bayfield Training

Real Estate Finance

Microsoft Excel

Professional Development

Continuous Professional Development (CPD)

This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance & Risk.

Real Estate Financial Modelling School

Chelmsford

This five-day course is a must for anyone who is considering or already working in a role with site manager responsibilities. This course covers all relevant legislation affecting safe working in the building, construction, and civil engineering industries.
It is endorsed by Build UK as the standard training for all construction managers.
Aims
To give a clear understanding of health, safety, welfare, and environmental legislation that affects your management role. It highlights the need for risk assessment in the workplace, the implementation of the necessary control measures and adequate communication to sustain a health and safety culture within the workforce.
Course Content
To give a clear understanding of health, safety, welfare, and environmental legislation that affects your management role. It highlights the need for risk assessment in the workplace, the implementation of the necessary control measures and adequate communication to sustain a health and safety culture within the workforce.
Course Content
• Health, safety, welfare and environmental legislation affecting your daily work
• New guidance and industry best practice
• Duties and responsibilities with regards to health, safety, welfare, and the environment
• Safe working
Prerequisites
This course is for you if you’re considering, or already have management responsibilities for planning, organising, monitoring, controlling and administering groups of staff e.g. site manager.
Assessment
At the end of this course, all delegates will have a clear understanding of controlling health and safety on site from a manager’s role.
Certificate
The certification for this course is valid for 5 years and is endorsed by Build UK as a standard training for all site managers.
To remain certified in this area, you will need to take a refresher course before the expiry date on your certificate, otherwise the full course will need to be retaken.
Instructions
Please note all online Site Management Safety Training Scheme courses with the venue “Online” will be delivered by a tutor over a video call.
This training will be delivered and assessed in English language; therefore, a good standard is required to complete the course.
Further attendee information will be sent in a separate email, please check your inbox.

SMC Safety Solutions

Site Management Safety Training Scheme (SMSTS) 5 day course

Stratford

The Temporary Works Coordinator course will provide you with knowledge of the role. You will also gain a good understanding of risk management on a temporary works site.
Course Objectives:
By the end of the course, the delegate will gain knowledge of:
The need for a temporary works co-ordinator
The day-to-day roles of others involved in the temporary works procedures
Risk assessments and method statements
Best procedures as stated in BS 5975:2019
Course Content:
The content covered by the CITB course includes:
Various groups and types of Temporary Works
Case studies, procedures and policies of Temporary Works
BS5975:2019
CDM Regulations
Legislation and relevant Codes of Practice
Register for Temporary Works, design requirements and checks
Standard solutions and guidance design documents
Temporary works Co-ordinator – job role and responsibilities
Assessment:
To successfully complete the course, you will need to get 72% or above in the final exam. The trainer encourages the delegates to be interactive and involved throughout the training.
Certificate:
The certificate for this course is valid for 5 years.
Instructions
Please note all Temporary Works Coordinator courses with the venue “Remote Learning” will be delivered by a tutor over a video call.
This training will be delivered and assessed in English language; therefore, a good standard is required to complete the course.
Further attendee information will be sent in a separate email, please check your inbox.

Temporary Works Coordinator (TWC) - 2 Day Course

Our Site Management Safety Training Scheme (SMSTS) refresher training courses, available both online and in-person, are designed for managers and individuals in positions of authority who completed their original SMSTS training program less than three years ago.

Aims
Participants will undertake a concise yet equally engaging training program covering all essential aspects of enforcing health and safety codes of practice at construction sites. Topics include in-depth discussions on risk assessments and effective methods for monitoring and managing industry-specific hazards.
Instructions
For online courses labeled “Remote Learning,” a tutor will deliver the training via video call.
All SMSTS courses are delivered and assessed in English. Participants must have a good command of the language to successfully complete the program.
Additional attendee information will be provided via email. Please ensure you check your inbox.


Site Management Safety Training Scheme (SMSTS) Refresher

Brightcore Consultancy delivers Senior Mental Health Lead training in schools and colleges which meets the Department for Education&rsquo;s quality criteria, and our course is in fact the highest rated of all the nationally DfE approved Senior Mental Health Lead training courses, scoring a perfect 5/5 in each of the 9 DfE quality assurance standards during the quality assurance process. It also has an incredible average delegate rating of 4.97 out of 5 for overall quality, with 100% of former delegates recommending the course (please see our many fantastic testimonials&nbsp;<a href="https://www.brightcoreconsultancy.com/brightcore-testimonials" target="_self" style="color: inherit; user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: inherit;">here</a>).The highly acclaimed Senior Mental Health Lead Training and Certificate is an extensive and authoritative training course that ensures schools/colleges have the most comprehensive, effective and financially viable whole-school/college approach to mental health and wellbeing in place. Since September 2021, this course has been fully funded by the DfE for eligible schools&nbsp;and colleges. Schools and Colleges that are ineligible for the grant are, of course, more than welcome to enrol on the course but will need to self-fund their place.Working with an&nbsp;expert trainer and a highly experienced Senior Mental Health Lead, who has&nbsp;trained Senior Mental Health Leads in over 1000 schools and colleges nationwide, you will be introduced to the DfE&rsquo;s requirements for the role of the DSMHL, and learn proven, long-term, evidence-based strategies to create, lead and promote a dynamic, bespoke mental health and wellbeing approach for your setting.<ul style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"><li fr-original-style="" style="box-sizing: border-box;">Our course consists of three days of live instructor-led training as well as an additional 1-2-1 review and coaching session, and costs&nbsp;&pound;520+VAT per delegate.&nbsp;(For schools and colleges who have already completed the training with us and now wish to train further colleagues, we offer a&nbsp;subsidised rate for additional delegates of &pound;390+VAT&nbsp;- please just email us if this is an offer you would like to take up.)</li><li fr-original-style="" style="box-sizing: border-box;">Places are limited to a maximum of 15 delegates per course to ensure high quality, bespoke training.</li><li fr-original-style="" style="box-sizing: border-box;">An overview of the course structure can be found&nbsp;<a href="https://www.brightcoreconsultancy.com/_files/ugd/5bc70a_c7b3efd99188442fa7d20449bb8fd0ec.pdf" target="_blank" style="color: inherit; user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: inherit;">here.</a></li></ul>Our Course is suitable for those who are new to the role of Senior Mental Health Lead or those who are looking to take on this role in the near future, and is designed to meet the DfE&rsquo;s&nbsp;<a href="https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/995681/Learning_outcomes_for_senior_mental_health_leads_in_schools_and_colleges.pdf" target="_blank" rel="noreferrer noopener" style="color: inherit; user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: inherit;">Learning Outcomes for Senior Mental Health Leads</a>&nbsp;by developing and supporting their knowledge and understanding of how to design, implement and sustain an effective whole school/college approach in accordance with the eight key principles as set out by Public Health England.<a href="https://www.brightcoreconsultancy.com/brightcore-testimonials" target="_blank" style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); font-weight: bold; text-decoration: none; border-radius: 5px; background-color: rgb(61, 86, 224); border-width: 12px 18px; border-style: solid; border-color: rgb(61, 86, 224); display: inline-block; user-select: auto; box-sizing: border-box; cursor: pointer;" rel="noopener noreferrer" fr-original-style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: #ffffff; font-weight: bold; text-decoration: none; border-radius: 5px; background-color: #3D56E0; border-top: 12px solid #3D56E0; border-bottom: 12px solid #3D56E0; border-right: 18px solid #3D56E0; border-left: 18px solid #3D56E0; display: inline-block;" fr-original-class="wysiwyg_bold_link_cls">View all testimonials </a>

Brightcore Consultancy delivers Senior Mental Health Lead training in schools and colleges which meets the Department for Education’s quality criteria, and our course is in fact the highest rated of all the nationally DfE approved Senior Mental Health Lead training courses, scoring a perfect 5/5 in each of the 9 DfE quality assurance standards during the quality assurance process. It also has an incredible average delegate rating of 4.97 out of 5 for overall quality, with 100% of former delegates recommending the course (please see our many fantastic testimonials here).
The highly acclaimed Senior Mental Health Lead Training and Certificate is an extensive and authoritative training course that ensures schools/colleges have the most comprehensive, effective and financially viable whole-school/college approach to mental health and wellbeing in place. 
Working with an expert trainer and a highly experienced Senior Mental Health Lead, who has trained Senior Mental Health Leads in over 1000 schools and colleges nationwide, you will be introduced to the DfE’s requirements for the role of the DSMHL, and learn proven, long-term, evidence-based strategies to create, lead and promote a dynamic, bespoke mental health and wellbeing approach for your setting.
Our course consists of three days of live instructor-led training as well as an additional 1-2-1 review and coaching session, and costs £520+VAT per delegate. (For schools and colleges who have already completed the training with us and now wish to train further colleagues, we offer a subsidised rate for additional delegates of £390+VAT - please just email us if this is an offer you would like to take up.)
Places are limited to a maximum of 15 delegates per course to ensure high quality, bespoke training.
An overview of the course structure can be found here.
Our Course is suitable for those who are new to the role of Senior Mental Health Lead or those who are looking to take on this role in the near future, and is designed to meet the DfE’s Learning Outcomes for Senior Mental Health Leads by developing and supporting their knowledge and understanding of how to design, implement and sustain an effective whole school/college approach in accordance with the eight key principles as set out by Public Health England.
View all testimonials



Brightcore Consultancy

Mental Health

Brightcore Consultancy delivers Senior Mental Health Lead training in schools and colleges which meets the Department for Education’s quality criteria, and our course is in fact the highest rated of all the nationally DfE approved Senior Mental Health Lead training courses, scoring a perfect 5/5 in each of the 9 DfE quality assurance standards during the quality assurance process.

Designated Senior Mental Health Lead Course (Three full days plus 1-2-1 session)

This two-day course is a must for anyone who is considering or already working in a role with supervisory responsibilities. This course provides an understanding of health, safety, welfare, and environmental issues. It highlights legal responsibilities and the need to promote health and safety to supervise effectively.
It is endorsed by Build UK as the standard training for all supervisors working on Build UK sites.
Aims
To give a clear understanding of health, safety, welfare, and environmental legislation that affects your supervisory role. To help you fulfil your responsibilities regarding health, safety, welfare, and the environment. To help you implement new guidance and industry best practice affected by changes.
Course Content
• Health and safety law and how it will apply to supervisors.
• Your supervisory responsibilities in controlling site safety.
• Risk assessments and the need for method statements.
• Effective site inductions, toolbox talks and method statement briefings.
• Monitoring site activities effectively.
• Timely intervention when bad practice is identified.
Prerequisites
This course is for you if you are considering, or already have, supervisory responsibilities.
Assessment
At the end of this course, all delegates will have a clear understanding of controlling health and safety on site from a supervisor’s role.
Certificate
This certification for this course is valid for 5 years and is endorsed by Build UK as a standard training for all supervisors.
To remain certified in this area, you will need to take a refresher course before the expiry date on your certificate, otherwise the full course will need to be retaken.
Instructions
Please note all Site Supervisor Training courses with the venue “Remote Learning” will be delivered by a tutor over a video call.
This training will be delivered and assessed in English language; therefore, a good standard is required to complete the course.
Further attendee information will be sent in a separate email, please check your inbox

Site Supervisor Training Scheme (SSSTS) - 2 Day Course

Real Estate AnalystThe Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.Create flexible real estate investment focused financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property with both annual and quarterly discounted cash flows, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results. On this course, you will&hellip;<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Learn how to structure an investment cash flow from first principles and how to value and appraise property investments</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Build annual and quarterly discounted cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Build OPEX and CAPEX into your cash flow</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analyse risk using sensitivity tables and charts</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Employ best practice and find solutions to common modelling problems</li></ul> Who will benefit from this course?<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate Investors</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Surveyors</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Portfolio Analysts</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Investment Managers</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Asset Managers</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="9" fr-original-style="" style="box-sizing: border-box;">APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.</li></ul> Day OneKnow how to build a property asset cash flow, analyse geared, and un-geared IRRs.<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Term &amp; Reversion and Layer Method Valuation (Intro to Excel)</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Equivalent Yield (Solver, Scenario and Goal Seek functions)</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Single-Let Discounted Cash Flow</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analysis and use of date series</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Internal Rate of Return (IRR) and Net Present Value (NPV)</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Comparing Value, Price and Worth</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Adding borrowing and analysing geared returns</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Introducing Rent Reviews and other &lsquo;events&rsquo; into cash flows</li><li value="10" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; concept and Logic functions (IF,OR,AND)</li><li value="11" fr-original-style="" style="box-sizing: border-box;">Sensitivity analysis</li></ul> Day TwoKnow how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; and Multi-let cash flows</li><li value="2" fr-original-style="" style="box-sizing: border-box;">The &lsquo;date problem&rsquo; and assumptions in property asset cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Reducing the rent function, intermediate calculations and modelling theory</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Modelling lease expiries, break clauses, voids, and upward only covenants</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Incorporating time-varying rental growth rates</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Analysing multi-let cash flows to see if the leases are sufficiently diversified</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Further IRR analysis (XIRR, MIRR)</li></ul> Included in the Course<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul> For more information about the Real Estate Analyst such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:E - s.musgrave@bayfieldtraining.comT - 01223 517851W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a>



Real Estate Analyst
The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.
Create flexible real estate investment focused financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property with both annual and quarterly discounted cash flows, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results.


On this course, you will…
Learn how to structure an investment cash flow from first principles and how to value and appraise property investments
Build annual and quarterly discounted cash flows
Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry
Build OPEX and CAPEX into your cash flow
Analyse risk using sensitivity tables and charts
Employ best practice and find solutions to common modelling problems


Who will benefit from this course?
Real Estate Investors
Surveyors
Portfolio Analysts
Investment Managers
Asset Managers
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Mid-level to senior Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.


Day One
Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.
Term & Reversion and Layer Method Valuation (Intro to Excel)
Equivalent Yield (Solver, Scenario and Goal Seek functions)
Single-Let Discounted Cash Flow
Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)
Analysis and use of date series
Internal Rate of Return (IRR) and Net Present Value (NPV)
Comparing Value, Price and Worth
Adding borrowing and analysing geared returns
Introducing Rent Reviews and other ‘events’ into cash flows
The ‘Rent Function’ concept and Logic functions (IF,OR,AND)
Sensitivity analysis


Day Two
Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.
The ‘Rent Function’ and Multi-let cash flows
The ‘date problem’ and assumptions in property asset cash flows
Reducing the rent function, intermediate calculations and modelling theory
Modelling lease expiries, break clauses, voids, and upward only covenants
Incorporating time-varying rental growth rates
Analysing multi-let cash flows to see if the leases are sufficiently diversified
Further IRR analysis (XIRR, MIRR)


Included in the Course
CPD Accredited Certificate & LinkedIn Proficiency Badge
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Real Estate Analyst such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Financial Modelling & Analysis

Financial Modelling

Property & Real Estate Photography

The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual

Please note the dates for this course:<ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li fr-original-style="" style="box-sizing: border-box;">21st Apr - 18 May,&nbsp;2025 for self-paced study</li><li fr-original-style="" style="box-sizing: border-box;">19th - 21st May, 2025 for the 3 live days</li><li fr-original-style="" style="box-sizing: border-box;">21st Apr - 11th June 2025 for online access to the video materials</li></ul>Early access to the lecture materials will be granted from&nbsp;31st March to those registering early.Prices include VAT.Please note that payment is required before your attendance at the live course.COURSE OVERVIEWThis comprehensive course delves into the principles of research design and explores all main quantitative evaluation methods: randomised experiments, instrumental variables, sharp and fuzzy regression discontinuity designs, regression methods, matching methods and longitudinal approaches such as before-after, difference-in-differences and synthetic controls.The lectures are thoughtfully structured to accommodate participants with diverse backgrounds. Each topic is presented at various levels, ensuring accessibility through intuitive explanations, optional formal derivations, in-depth discussions, and practical examples. The live classes offer a summary of each topic and provide an interactive platform for participants to ask questions and actively engage in guided practical sessions where they will apply each evaluation method to real-world data.By the end of this course, participants will have acquired a solid foundation in research design principles and possess practical skills to implement quantitative evaluation methods effectively.FORMAT OF THE COURSEThe Remote PEM Course offers a flexible learning experience through a combination of self-paced study and live online meetings. The course is structured into two parts:Part 1) Pre-recorded Lectures (21.5 hours): The pre-recorded lecture videos will be made available four weeks (6 weeks for early registrants) prior to the course start date, allowing participants to study the material at their own pace. While the videos remain accessible for an additional three weeks starting from the live sessions, it is recommended that participants complete the lectures before the live meetings, which are designed to focus on questions and practical exercises.Part 2)&nbsp;Live Sessions (19.5 hours): The live classes are spread over three days and consists of the following:<ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li fr-original-style="" style="box-sizing: border-box;">Summary and Recap: Barbara, the instructor, will provide a brief summary and recap of each topic covered in the pre-recorded lectures. Participants will have the opportunity to ask questions related to the specific topic being discussed.</li></ul><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li fr-original-style="" style="box-sizing: border-box;">Guided Practical Work: Participants will be given dedicated time to work on guided practical exercises either individually or in breakout rooms. These exercises will involve utilizing Stata or R software to implement each evaluation method to real data.</li><li fr-original-style="" style="box-sizing: border-box;">Live Demonstration: Barbara will conduct a live demonstration of the practical exercise using Stata. She will guide participants through the process, explaining each step and discussing the key aspects of the exercise.</li></ul>For more information please contact <a href="mailto:cemmapevent@ifs.org.uk" style="color: rgb(119, 119, 119); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(119, 119, 119);">cemmapevent@ifs.org.uk</a>

Please note the dates for this course:
21st Apr - 18 May, 2025 for self-paced study
19th - 21st May, 2025 for the 3 live days
21st Apr - 11th June 2025 for online access to the video materials
Early access to the lecture materials will be granted from 31st March to those registering early.
Prices include VAT.
Please note that payment is required before your attendance at the live course.
COURSE OVERVIEW
This comprehensive course delves into the principles of research design and explores all main quantitative evaluation methods: randomised experiments, instrumental variables, sharp and fuzzy regression discontinuity designs, regression methods, matching methods and longitudinal approaches such as before-after, difference-in-differences and synthetic controls.
The lectures are thoughtfully structured to accommodate participants with diverse backgrounds. Each topic is presented at various levels, ensuring accessibility through intuitive explanations, optional formal derivations, in-depth discussions, and practical examples. The live classes offer a summary of each topic and provide an interactive platform for participants to ask questions and actively engage in guided practical sessions where they will apply each evaluation method to real-world data.
By the end of this course, participants will have acquired a solid foundation in research design principles and possess practical skills to implement quantitative evaluation methods effectively.
FORMAT OF THE COURSE
The Remote PEM Course offers a flexible learning experience through a combination of self-paced study and live online meetings. The course is structured into two parts:
Part 1) Pre-recorded Lectures (21.5 hours): The pre-recorded lecture videos will be made available four weeks (6 weeks for early registrants) prior to the course start date, allowing participants to study the material at their own pace. While the videos remain accessible for an additional three weeks starting from the live sessions, it is recommended that participants complete the lectures before the live meetings, which are designed to focus on questions and practical exercises.
Part 2) Live Sessions (19.5 hours): The live classes are spread over three days and consists of the following:
Summary and Recap: Barbara, the instructor, will provide a brief summary and recap of each topic covered in the pre-recorded lectures. Participants will have the opportunity to ask questions related to the specific topic being discussed.
Guided Practical Work: Participants will be given dedicated time to work on guided practical exercises either individually or in breakout rooms. These exercises will involve utilizing Stata or R software to implement each evaluation method to real data.
Live Demonstration: Barbara will conduct a live demonstration of the practical exercise using Stata. She will guide participants through the process, explaining each step and discussing the key aspects of the exercise.
For more information please contact cemmapevent@ifs.org.uk

Institute for Fiscal Studies

The course covers research design principles and all main quantitative evaluation methods: randomised experiments, instrumental variables, sharp and fuzzy regression discontinuity designs, regression methods, matching methods and longitudinal methods (before-after, difference-in-differences and synthetic controls).

Remote Policy Evaluation Methods May 2025

Higher Education

Charity or Government

Other Delegates

Oldham

Module 4This module aims to develop knowledge from research activities to gain an understanding of international trade theory, global economic development and growth, currency and exchange rates, trade policies and their impact on an organisation, free trade agreements, direct investment from financial sources outside the UK, tariffs and no trade barriers, supply chain and logistics, intercultural management and international law and treaties.Agenda<ul style="color: rgb(50, 74, 109); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);"><li fr-original-style="" style="box-sizing: border-box;">Importance of international trade</li><li fr-original-style="" style="box-sizing: border-box;">Trade barriers</li><li fr-original-style="" style="box-sizing: border-box;">Sanctions</li><li fr-original-style="" style="box-sizing: border-box;">Anti-dumping</li><li fr-original-style="" style="box-sizing: border-box;">Countervailing</li><li fr-original-style="" style="box-sizing: border-box;">FTA</li><li fr-original-style="" style="box-sizing: border-box;">Third country status</li><li fr-original-style="" style="box-sizing: border-box;">The role of the WTO.</li></ul>&nbsp;<ul style="color: rgb(50, 74, 109); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);"><li fr-original-style="" style="box-sizing: border-box;">Treaties</li><li fr-original-style="" style="box-sizing: border-box;">Trade agreements</li><li fr-original-style="" style="box-sizing: border-box;">Exchange rates</li><li fr-original-style="" style="box-sizing: border-box;">Foreign investment</li><li fr-original-style="" style="box-sizing: border-box;">Intercultural management</li></ul>&nbsp;Examination: Certificate on completion and Pass on Multiple Choice Multiple choice questionnaire Credits: 1

Module 4
This module aims to develop knowledge from research activities to gain an understanding of international trade theory, global economic development and growth, currency and exchange rates, trade policies and their impact on an organisation, free trade agreements, direct investment from financial sources outside the UK, tariffs and no trade barriers, supply chain and logistics, intercultural management and international law and treaties.
Agenda
Importance of international trade
Trade barriers
Sanctions
Anti-dumping
Countervailing
FTA
Third country status
The role of the WTO.
 
Treaties
Trade agreements
Exchange rates
Foreign investment
Intercultural management
 
Examination:
Certificate on completion and Pass on Multiple Choice
Multiple choice questionnaire
Credits: 1

Export Unlocked Limited

Trade & Commerce

Trade Skills

International Trade

Trade

Global Economics

This module aims to develop knowledge from research activities to gain an understanding of international trade theory, global economic development and growth, currency and exchange rates, trade policies and their impact on an organisation, free trade agreements, direct investment from financial sources outside the UK, tariffs and no trade barriers, supply chain and logistics, intercultural management and international law and treaties.

INTERNATIONAL TRADE RESEARCH

The psychological impact of critical incidents includes anxiety, depression, sleep disturbance and agitation. It can also lead to reduced motivation or morale at work, unsafe practices, and burnout.Health and social care professionals in hospitals, residential care, and support services, who are looking after vulnerable people in challenging environments, are often exposed to distressing events. Critical Incident Stress Debriefings (CISDs) are brief and effective interventions. They mitigate the impact of incidents and help promote resilience and well-being. &nbsp;CISD is a facilitated, time-limited group session intended to support participants with the emotional/psychological impact of an adverse event. The debrief is a structured group conversation about the facts, feelings, and thoughts related to the incident.&nbsp;A trained and competent facilitator helps the group support each other and process their reactions.&nbsp;This training is for managers, nurses, key workers, mental health professionals, counsellors/psychotherapists, or any person in charge of staff well-being in their organization.&nbsp;This excellent 2-day online training will cover theory and practice, including lectures, videos, and small-group work. When you complete the training you will be able to facilitate CISDs. Here is an outline of the training:Day 1: Critical Incidents and the Process of Debriefing&nbsp;09:00 - 10:30&nbsp; Introducing the facilitator and the group; outline of the day, expectations and outcomes. The Process of Debriefing: the practice of &lsquo;talking through&rsquo; and the therapeutic benefits of debriefing. Understanding Critical Incidents: defining Critical Incidents, what makes an incident &lsquo;critical&rsquo;? The psychological impact of a critical incident. 10:30 - 12:00&nbsp; Trauma and Post-Trauma Unpacking these important concepts and understanding their implications and relevance to CID Debriefing Critical Incidents Introducing existing models of CISDs, comparing and understanding the components of a CID 12:30 Lunch break&nbsp; 13:00 - 14:00&nbsp; Skills Practice and Experiential Learning Practice session, trying out models of debriefing using scenarios from experience Day 2: Facilitating Critical Incident Stress Debriefings &ndash; theory and practice 09:00 - 10:30&nbsp; The Competent Facilitator:&nbsp;qualities and skills of the competent facilitator Containment The role of the facilitator and the challenges of facilitating emotional conversations&nbsp; 10:30 - 12:00&nbsp; Facilitating critical incident debriefings: prompt cards - a tool for the facilitator. Ground rules, time-frames, and keeping &lsquo;on task&rsquo;. 12:30 Lunch break &nbsp; 13:00 - 14:00&nbsp; Skills Practice and Experiential Learning Working with scenarios and prompt cards: practice session - facilitating CISDs &lsquo;Debriefing&rsquo; the day &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

The psychological impact of critical incidents includes anxiety, depression, sleep disturbance and agitation. It can also lead to reduced motivation or morale at work, unsafe practices, and burnout.
Health and social care professionals in hospitals, residential care, and support services, who are looking after vulnerable people in challenging environments, are often exposed to distressing events. 

Critical Incident Stress Debriefings (CISDs) are brief and effective interventions. They mitigate the impact of incidents and help promote resilience and well-being. 
CISD is a facilitated, time-limited group session intended to support participants with the emotional/psychological impact of an adverse event.
The debrief is a structured group conversation about the facts, feelings, and thoughts related to the incident. A trained and competent facilitator helps the group support each other and process their reactions. 
This training is for managers, nurses, key workers, mental health professionals, counsellors/psychotherapists, or any person in charge of staff well-being in their organization. 
This excellent 2-day online training will cover theory and practice, including lectures, videos, and small-group work. When you complete the training you will be able to facilitate CISDs.

Here is an outline of the training:
Day 1: Critical Incidents and the Process of Debriefing 
09:00 - 10:30 
Introducing the facilitator and the group; outline of the day, expectations and outcomes.
The Process of Debriefing: the practice of ‘talking through’ and the therapeutic benefits of debriefing.
Understanding Critical Incidents: defining Critical Incidents, what makes an incident ‘critical’? The psychological impact of a critical incident.

10:30 - 12:00 
Trauma and Post-Trauma
Unpacking these important concepts and understanding their implications and relevance to CID
Debriefing Critical Incidents
Introducing existing models of CISDs, comparing and understanding the components of a CID

12:30 Lunch break 

13:00 - 14:00 
Skills Practice and Experiential Learning
Practice session, trying out models of debriefing using scenarios from experience

Day 2: Facilitating Critical Incident Stress Debriefings – theory and practice

09:00 - 10:30 
The Competent Facilitator: qualities and skills of the competent facilitator
Containment
The role of the facilitator and the challenges of facilitating emotional conversations 

10:30 - 12:00 
Facilitating critical incident debriefings: prompt cards - a tool for the facilitator.
Ground rules, time-frames, and keeping ‘on task’.

12:30 Lunch break
 
13:00 - 14:00 
Skills Practice and Experiential Learning
Working with scenarios and prompt cards: practice session - facilitating CISDs
‘Debriefing’ the day

  

Psychotherapy For Healthcare Ltd

Train with us to facilitate Critical Incident Stress Debriefings. CISD are effective interventions that help care professionals to process stressful events in the workplace.  A CISD helps restore well-being and protect from prolonged reactions. This excellent 2-day training will cover theory and practice, including lectures, videos, and small-group work. By the end you will be able to facilitate CISDs.

63242 Courses

Conflict Management 1 Day Training in Ipswich

By Mangates

Conflict Management 1 Day Training in Heathrow

By Mangates

Conflict Management 1 Day Training in Gloucester

By Mangates

Conflict Management 1 Day Training in Dumfries

By Mangates

Conflict Management 1 Day Training in Darlington

By Mangates

Conflict Management 1 Day Training in Cork

By Mangates

Conflict Management 1 Day Training in Chatham

By Mangates

Time Management 1 Day Workshop in Cork

By Mangates

Lino printing onto fabric

By The Arienas Collective

Sew a skirt in a day - Ramona

By Stitching Kitchen

Search By Location