Name: Time Management 1 Day Training in Paisley
Price: 595 GBP
Availability: InStock

Management

Glasgow

<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: 2 Days | Credits: 16 PDUs

Course Delivery: Classroom | Virtual Live

Lunch and Beverages are included in a classroom session

Course Description:

In the competitive construction industry, the need for training is more vital than ever. Organizations that devote resources to professional development are more likely to see higher productivity and greater efficiency. On-the-job training can provide crucial knowledge to perform tasks at hand, but the best professionals constantly seek to learn about new techniques and technologies to improve their performance on-site and in the office.

Our Construction Project Manager Course (PMC) provides project managers the chance to sharpen the skills necessary to work more efficiently, increase productivity, and propel your construction business to the next level. PMC provides the ideal opportunity for project managers to gain crucial knowledge and leadership skills to stay competitive. This program will provide participants with skills they can immediately implement on the job and in the field. Everyone who goes through the program has something to gain over an intense week of workshops, assignments, and team-building activities.

PMC participants experience an interactive program that explores 15 critical areas of project management that seasoned project managers tackle on a daily basis. PMC provides participants with practical solutions to current industry challenges they can take back to immediately impact performance and improve project results.

Learning Objectives: 

Upon successful completion of this course, the learner will be able to:

● Identify the importance of pre-planning and its correlation with a company’s bottom line.
● Discuss the impact of low job site productivity on the project contractor, craftsperson, project owner, and designer.
● Discuss information required to evaluate and select subcontractor and vendor services and material and equipment purchases.
● Identify legal actions, or lack thereof, that can have far-reaching legal consequences for the project manager, their company, and many others.

Course Topics:

Day 1:

1.Project Planning
Importance of pre-planning.
Developing comprehensive project plans.
Correlation between planning and profitability.
Tools and techniques for effective planning.

2.Safety Management
Importance of safety in construction.
Developing and implementing safety plans.
OSHA regulations and compliance.
Risk assessment and mitigation.

3.Construction Productivity
Factors affecting job site productivity.
Techniques to improve productivity.
Measuring and tracking productivity.
Case studies of productivity improvements.

4.Subcontractor & Vendor Management
Evaluating and selecting subcontractors and vendors.
Contract negotiation and management.
Performance monitoring and quality control.
Building and maintaining strong relationships.

5.Critical Path Method (CPM) Scheduling
Basics of CPM scheduling.
Developing and maintaining project schedules.
Identifying and managing critical paths.
Tools and software for scheduling.

Day 2:

1.Claims Management
Types of claims in construction.
Preventing and managing claims.
Documentation and communication strategies.
Dispute resolution methods.

2.Legal Issues & Contract Clauses
Key legal concepts in construction.
Important contract clauses and their implications.
Managing legal risks and liabilities.
Case studies of legal issues in construction.

3.Cost Control
Budgeting and cost estimation.
Tracking and controlling project costs.
Analyzing cost performance.
Techniques for cost reduction.

4.Project Recordkeeping
Importance of accurate recordkeeping.
Types of project records and documentation.
Best practices for maintaining records.
Tools for efficient recordkeeping.

5.Communication
Importance of effective communication.
Strategies for improving communication.
Tools and technologies for communication.
Case studies of communication failures and successes.

6.Time Management
Techniques for effective time management.
Prioritizing tasks and managing deadlines.
Tools for time tracking and management.
Case studies of time management in construction.

7.Problem Solving & Decision Making
Techniques for problem-solving.
Decision-making frameworks.
Analyzing and evaluating options.
Case studies of problem-solving in construction.

8.Innovation
Importance of innovation in construction.
Identifying and implementing new technologies.
Encouraging a culture of innovation.
Case studies of successful innovation.

Conclusion: 

The PMC course aims to equip project managers with the skills and knowledge necessary to excel in the construction industry. By addressing the critical areas of project management, participants will leave the course with practical strategies and tools to enhance their performance and drive their projects to success.
Who Can Attend?
The Construction Project Manager (PMC) 2 Days Training course is designed for:

Project Managers: Experienced project managers looking to enhance their skills and stay updated with the latest industry practices and technologies.
Construction Managers: Individuals responsible for overseeing construction projects who want to improve their management techniques and project outcomes.
Site Supervisors: Supervisors and foremen seeking to gain a deeper understanding of project management principles and practices to better support project managers.
Engineers and Architects: Professionals involved in the planning, design, and execution of construction projects who want to enhance their project management knowledge and skills.
Construction Professionals: Anyone in the construction industry, including estimators, planners, and coordinators, aiming to improve their project management capabilities and advance their careers.
Business Owners and Executives: Owners and executives of construction companies who want to ensure their project managers and teams are well-equipped with the necessary skills to drive project success and business growth.
Aspiring Project Managers: Individuals aspiring to move into project management roles within the construction industry, seeking foundational knowledge and skills to prepare for the transition.
HR and Training Managers: Human resource and training managers responsible for the professional development of their company's construction management teams.
Prerequisites
While there are no strict prerequisites for attending the PMC course, having a basic understanding of construction processes and some experience in construction project management will be beneficial. Participants should come prepared to engage in interactive discussions and practical exercises that require critical thinking and problem-solving skills.
Benefits of Taking the Construction Project Manager (PMC) 2 Days Training Course In-House
1. Customization to Your Needs:
● The course can be tailored to address the specific challenges and requirements of your organization, ensuring the content is relevant and directly applicable to your projects and team dynamics.

2. Convenience and Flexibility:
● Conducting the training in-house eliminates the need for travel, saving time and reducing costs for your employees. It also allows for scheduling flexibility to fit the course around your team's availability.

3. Team Building and Collaboration:
● In-house training fosters a collaborative learning environment, encouraging team building and improved communication among your employees. It provides an opportunity for your team to work together on practical exercises and case studies, strengthening their ability to collaborate effectively on future projects.

4. Immediate Application:
● The skills and knowledge gained during the course can be immediately applied to your current projects, leading to quick improvements in productivity, efficiency, and project outcomes.

5. Cost-Effective:
● In-house training is often more cost-effective than sending multiple employees to external courses. You save on travel and accommodation expenses, and there are often discounts available for group bookings.

6. Consistent Training:
● Ensuring that all relevant team members receive the same high-quality training ensures consistency in the application of project management principles and practices across your organization.

7. Confidentiality:
● In-house training allows your team to discuss sensitive and proprietary information freely without concerns about confidentiality. This can lead to more open discussions and practical problem-solving sessions.

8. Enhanced Engagement:
● Training conducted in a familiar environment can increase engagement and participation. Employees may feel more comfortable and willing to engage in discussions, ask questions, and participate in activities.

9. Long-Term Benefits:
● Investing in in-house training demonstrates your commitment to employee development, which can boost morale, job satisfaction, and retention rates. Employees are more likely to stay with an organization that invests in their professional growth.

10. Direct Access to Trainers:
● Having trainers on-site allows for more personalized interaction, immediate feedback, and the opportunity to address specific concerns or questions that arise during the training.

11. Aligns with Organizational Goals:
● In-house training can be aligned with your organizational goals and strategies, ensuring that the skills and knowledge gained are directly contributing to your company's overall objectives.

12. Follow-Up Support:
● Trainers can offer follow-up support and coaching to ensure that the concepts and techniques learned during the course are successfully implemented in your organization.

13. Increased Productivity:
● With the entire team trained together, there is a reduced learning curve, leading to quicker implementation of new practices and increased productivity.

14. Industry-Relevant Case Studies:
● Trainers can incorporate industry-relevant case studies and examples specific to your organization, making the learning experience more relatable and impactful.

By choosing to conduct the PMC 2 Days Training course in-house, your organization can maximize the benefits of professional development, ensuring that your team is equipped with the essential skills and knowledge to excel in the competitive construction industry.

Mangates

Construction Management

Project Manager

Construction Project Manager 2 Days Training in Glasgow

The sale ends 10 days before the event starts.

Early Bird Fee

The sale ends 5 days before the event starts.

Standard Fee

Paisley

Construction Project Manager 2 Days Training in Paisley

Hamilton, UK

Construction Project Manager 2 Days Training in Hamilton, UK

Airdrie

Construction Project Manager 2 Days Training in Airdrie

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.

Conflict Management

Conflict Management 1 Day Training in Glasgow

Conflict Management 1 Day Training in Paisley

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:
Emotional intelligence describes the ability to understand one’s own feelings. It also provides great insight into how emotion influences motivation and behavior. The concept of Emotional Intelligence has been around since the early 20th century, but the term was first introduced by Wayne Payne in 1985.
With our Emotional Intelligence workshop, you will gain a better understanding of self-management and self-awareness. This in turn will give you better insight and control over your actions and emotions. With a greater understanding of emotions, you will experience a positive impact on your professional and personal lives.
Target Audience:
Anybody who is interested in learning Emotional intelligence Skills
Learning Objectives:
Understand the Emotional Intelligence competency framework.
Assess and understand current Emotional Intelligence level.
Understand techniques for being highly positive and energetic.
Understand how emotions can influence thoughts, goals, relationships, decision-making ability, etc.
Understand the importance of high expectations and pressure and how to go through it.
Understand how to be an emotionally strong person, who can handle emotions.
Understand how to be a responsible person, who does not believe in blame/complaint.
Understand techniques to develop your emotional intelligence on the job.
Agenda:
Module One: What is Emotional Intelligence?
Self-Management
Self Awareness
Self-Regulation
Self-Motivation
Empathy
Module Two: Four Skills in Emotional Intelligence
How to Accurately Perceive Emotions
Use Emotions to Facilitate Thinking
Understand Emotional Meanings
Manage Emotions
Module Three: Verbal Communication Skills
Focused Listening
Asking Questions
Communicating with Flexibility and Authenticity
Module Four: Non-Verbal Communication Skills
Body Language
The Signals You Send to Others
It’s Not What You Say, It’s How You Say It
Module Five: Social Management and Responsibility
Benefits of Emotional Intelligence
Articulate your Emotions Using Language.
Module Six: Tools to Regulate Your Emotions
Seeing the Other Side
Self-Management and Self Awareness
Giving in Without Giving Up
Module Seven: Gaining Control
Using Coping Thoughts
Using Relaxation Techniques
Bringing it All Together
Module Eight: Business Practices (I)
Understand Emotions and How to Manage Them in the Workplace
Role of Emotional Intelligence at Work
Disagreeing Constructively
Module Nine: Business Practices (II)
Optimism
Pessimism
The Balance Between Optimism & Pessimism
Module Ten: Making an Impact
Creating a Powerful First Impression
Assessing a Situation
Being Zealous without Being Offensive
Module Eleven: Wrapping Up
Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Basic

Emotional Intelligence (EQ)

Emotional Intelligence 1 Day Training in Glasgow

Emotional intelligence 1 Day Training in Glasgow

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 Training in Glasgow

Emotional Intelligence 1 Day Training in Paisley

Emotional intelligence 1 Day Training in Paisley

Time Management 1 Day Training in Paisley

Oldham

<div data-id="707b00e3" data-element_type="container" data-settings='{"content_width":"full"}' style="color: rgb(9, 13, 24); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(9, 13, 24);"><div data-id="1c97cfcc" data-element_type="widget" data-widget_type="woocommerce-product-content.default" style="color: rgb(50, 74, 109); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);">This introduction course is aimed at those involved in the importing of goods.The course will cover import documentation and procedures, commercial considerations, the importance of your purchase order, calculating VAT and duty, and how to reduce import customs clearance delays. Incoterms&reg; and their impact on importing will be shown, along with an introduction to duty regimes to help importers.Course Contents:<ul data-rte-list="default" 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;">Import documentation and procedures</li><li fr-original-style="" style="box-sizing: border-box;">Calculating VAT and duty</li><li fr-original-style="" style="box-sizing: border-box;">Incoterms&reg;</li><li fr-original-style="" style="box-sizing: border-box;">Customs regimes and import controls</li><li fr-original-style="" style="box-sizing: border-box;">Changes coming in January 2021</li><li fr-original-style="" style="box-sizing: border-box;">Sources of help and advice</li></ul>&nbsp;Who should attend? This introduction course is suitable for administrators, managers, directors, and owners of businesses who need to purchase from overseas.The course is valuable for both newcomers wanting an introduction and overview, and experienced staff needing a refresher on current requirements.&nbsp;It will also be valuable for companies who are already importing so they can ensure they have the correct processes in place and are meeting their compliance obligations.Please note: If you are working towards your British Chamber of Commerce (BCC) Foundation Award, this course will count towards 1 of your 6 modules. Please make sure you select the &lsquo;Yes&rsquo; option in the dropdown option for BCC when booking.</div></div><div data-id="60285c8" data-element_type="container" data-settings='{"content_width":"full"}' style="color: rgb(9, 13, 24); box-sizing: border-box;" fr-original-style=" color: rgb(9, 13, 24);"> </div>

This introduction course is aimed at those involved in the importing of goods.
The course will cover import documentation and procedures, commercial considerations, the importance of your purchase order, calculating VAT and duty, and how to reduce import customs clearance delays. Incoterms® and their impact on importing will be shown, along with an introduction to duty regimes to help importers.
Course Contents:
Import documentation and procedures
Calculating VAT and duty
Incoterms®
Customs regimes and import controls
Changes coming in January 2021
Sources of help and advice
 
Who should attend?
This introduction course is suitable for administrators, managers, directors, and owners of businesses who need to purchase from overseas.
The course is valuable for both newcomers wanting an introduction and overview, and experienced staff needing a refresher on current requirements. It will also be valuable for companies who are already importing so they can ensure they have the correct processes in place and are meeting their compliance obligations.
Please note: If you are working towards your British Chamber of Commerce (BCC) Foundation Award, this course will count towards 1 of your 6 modules. Please make sure you select the ‘Yes’ option in the dropdown option for BCC when booking.

Export Unlocked Limited

International Trade

British Chambers of Commerce (BCC)

Import/Export

Customs

Business Admin

This course covers import documentation and procedures, commercial considerations, the importance of your purchase order, calculating VAT and duty, and how to reduce import customs clearance delays.

IMPORT PROCEDURES & DOCUMENTATION

General Admission

Start your Compassionate Safety journey with this WebWorkshop.

In this WebWorkshop, you will learn:
How to get everyone home safe every day.
How to shift from ‘doing’ safety to ‘being’ safe.
How to accommodate humans for being human. 
How the definition of safety must move beyond the physical to include psychological, emotional and spiritual.

PPWD Consulting

PPWD WebWorkshop

London

<div>
	 <h5>Excel Macros and VBA Course summary</h5>
	 </div>
	 <div></div>
	 
				 
				 For Excel users. Extend the capabilities of Excel with Macros and VBA code.
	 

				 
				 
				 
	 <div>
	 <div>
	 <h5>Excel Macros and VBA Course Description</h5>
	 </div>
	 <div></div>
	 
	 
					 
					 
					 
	 

	 		 Create simple macros using the macro recorder and run them from shortcuts or buttons on the ribbon

						 Setting Excel Macro Options
						 Record and Run Simple Macros
						 Assign Macros to the Quick Access Toolbar

					 Introduction to the Excel VBA Editor

					 Use the VBA Editor to navigate projects and explore object properties. Create, copy and import/export modules

						 Starting the Visual Basic Editor
						 Using the Project Explorer
						 Using the Properties Window
 

					 Creating Procedures and Functions

					 Create simple macro procedures in code that use variable to store data and communicate with the user

						 Creating Sub and Function Procedures
						 Declare and Use Variables
						 Displaying Message to the User
						 Getting Input from the User

					 Controlling Program Flow

					 Using decision making and looping structures to control the way your program works

						 Using the IF Statement
						 Using the Select Case Statement
						 Using For Next Loops
						 Using Do Loops
						 Using For Next Loops
			 

					 Interacting with the spreadsheet :

						 Referencing Cells and Ranges
						 Gathering Cell and Range Information
						 Using the Offset Method
						 Using With Blocks
						 Referencing Workbooks and Worksheets
						 Updating values in the spreadsheet 

					 Functions

						 Using standard Excel functions in VBA
						 Creating new custom functions
						 Calling functions and sub procedures

					 User Forms

						 Basic design and display
						 Getting information via forms and update cells
					

					 Practical project and examples
					 
					
			 
			<h4>Other Excel Courses</h4>
			 
 
 
 
 
	 </div>
	 <div id="cincluded">
	 <div>
	 <h5>What is included in the Excel VBA Courses:</h5>
	 </div>
	 <div>
	 <ul>
	 <li>Excel VBA Course Certificate on completion </li>
	 <li>Excel VBA Course notes</li>
	 <li>Practical Excel VBA Course exercises, Excel VBA Course Homework / Excel VBA Course Revision work</li>
	 
	 <li>After the course, 1 free session for questions online Excel VBA Course via Gotomeeting.com.</li>
	 <li>Max group size, online and in classroom, on this Excel VBA Course is 4. </li>
	 </ul>
	 </div>
	 </div>

Excel Macros and VBA Course summary
 For Excel users. Extend the capabilities of Excel with Macros and VBA code. 
Excel Macros and VBA Course Description
Create a simple mile/km converter with a frontend, user-input for, click button to start and update a spreadsjeet 
What is included in the Excel VBA Courses:
Excel VBA Course Certificate on completion
Excel VBA Course notes
Practical Excel VBA Course exercises, Excel VBA Course Homework / Excel VBA Course Revision work
After the course, 1 free session for questions online Excel VBA Course via Gotomeeting.com.
Max group size, online and in classroom, on this Excel VBA Course is 4.

PCWorkshops

Visual Basic

Access VBA

Microsoft Excel

For Excel users. Extend the capabilities of Excel with Macros and VBA code. 

Excel Macros and VBA Course, 1-Hour Taster

General admission

<div style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Start running Paid Ads on social&nbsp;media, and&nbsp;reach more customers than ever before!&nbsp;</div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Want to level up your social media channels and skills, and learn how to run smart and effective paid social media campaigns on Facebook and Instagram? Join the course from&nbsp;Let&rsquo;s&nbsp;Do Marketing and follow the&nbsp;whole process&nbsp;with an expert social media coach, where&nbsp;you&rsquo;ll&nbsp;learn how to dive deeper into and create a more targeted marketing strategy, and how to plan and set up sophisticated Paid Ad campaigns from Facebook Ads Manager.&nbsp;</div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">&nbsp;📅 Date: Tuesday 5th November🕒&nbsp;Time: 10am - 1pm📌 Location: Online Webinar&nbsp;<span style='background: url("https://cdnjs.cloudflare.com/ajax/libs/emojione/2.0.1/assets/svg/1f4b7.svg"); display: inline-block; font-family: "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-weight: 400; line-height: 1; box-sizing: border-box; font-size: inherit; height: 1em; margin: -0.1em 0.1em 0.1em; min-height: 20px; min-width: 20px; vertical-align: middle; width: 1em;' fr-original-style="background: url(https://cdnjs.cloudflare.com/ajax/libs/emojione/2.0.1/assets/svg/1f4b7.svg);" fr-original-class="fr-emoticon fr-deletable fr-emoticon-img">&nbsp;💷&nbsp;Cost: &pound;30PP </div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">During this course,&nbsp;we&rsquo;ll&nbsp;cover:&nbsp;&nbsp;</div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><ul fr-original-style="" style="box-sizing: border-box;"><li data-leveltext="-" data-font="Calibri" data-listid="1" data-list-defn-props='{"335551671":0,"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Calibri","469769242":[8226],"469777803":"left","469777804":"-","469777815":"hybridMultilevel"}' data-aria-posinset="0" data-aria-level="1" fr-original-style="" style="box-sizing: border-box;">Developing your customer personas online &ndash; investigating habits, social media usage, trends and more&nbsp;</li><li data-leveltext="-" data-font="Calibri" data-listid="1" data-list-defn-props='{"335551671":0,"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Calibri","469769242":[8226],"469777803":"left","469777804":"-","469777815":"hybridMultilevel"}' data-aria-posinset="0" data-aria-level="1" fr-original-style="" style="box-sizing: border-box;">Ways you can use data better &ndash; from installing a Facebook Pixel to using your Mailing Lists to create targeted audiences for your Paid Ads&nbsp;</li><li data-leveltext="-" data-font="Calibri" data-listid="1" data-list-defn-props='{"335551671":0,"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Calibri","469769242":[8226],"469777803":"left","469777804":"-","469777815":"hybridMultilevel"}' data-aria-posinset="0" data-aria-level="1" fr-original-style="" style="box-sizing: border-box;">Learning about Meta Business Suite &ndash; useful tools included, as well as how to navigate the platform&nbsp;</li><li data-leveltext="-" data-font="Calibri" data-listid="1" data-list-defn-props='{"335551671":0,"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Calibri","469769242":[8226],"469777803":"left","469777804":"-","469777815":"hybridMultilevel"}' data-aria-posinset="0" data-aria-level="1" fr-original-style="" style="box-sizing: border-box;">Different formats and types of ads&nbsp;</li><li data-leveltext="-" data-font="Calibri" data-listid="1" data-list-defn-props='{"335551671":0,"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Calibri","469769242":[8226],"469777803":"left","469777804":"-","469777815":"hybridMultilevel"}' data-aria-posinset="0" data-aria-level="1" fr-original-style="" style="box-sizing: border-box;">Creating graphic design content for Paid Ads using Canva&nbsp;</li><li data-leveltext="-" data-font="Calibri" data-listid="1" data-list-defn-props='{"335551671":0,"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Calibri","469769242":[8226],"469777803":"left","469777804":"-","469777815":"hybridMultilevel"}' data-aria-posinset="0" data-aria-level="1" fr-original-style="" style="box-sizing: border-box;">Walkthrough of creating a Paid Ad Campaign on Facebook Ads Manager &ndash; from creating your campaign and narrowing down your audience, to creating Ad copy and Call to Actions.&nbsp;</li><li data-leveltext="-" data-font="Calibri" data-listid="1" data-list-defn-props='{"335551671":0,"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Calibri","469769242":[8226],"469777803":"left","469777804":"-","469777815":"hybridMultilevel"}' data-aria-posinset="0" data-aria-level="1" fr-original-style="" style="box-sizing: border-box;">Measuring the results of your Paid Ad campaigns&nbsp;</li></ul></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">&nbsp;</div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">As well as a dedicated Q&amp;A session, where you can ask a social media expert any questions you have about running and creating your own paid advertisements on social media.&nbsp;</div>

Start running Paid Ads on social media, and reach more customers than ever before!
Want to level up your social media channels and skills, and learn how to run smart and effective paid social media campaigns on Facebook and Instagram?

Join the course from Let’s Do Marketing and follow the whole process with an expert social media coach, where you’ll learn how to dive deeper into and create a more targeted marketing strategy, and how to plan and set up sophisticated Paid Ad campaigns from Facebook Ads Manager.
Event details:
Time: 10am - 1pm
Location: Online (ZOOM)
Cost: £35pp
During this course, we’ll cover:  
Developing your customer personas online – investigating habits, social media usage, trends and more
Ways you can use data better – from installing a Facebook Pixel to using your Mailing Lists to create targeted audiences for your Paid Ads
Learning about Meta Business Suite – useful tools included, as well as how to navigate the platform
Different formats and types of ads
Creating graphic design content for Paid Ads using Canva
Walkthrough of creating a Paid Ad Campaign on Facebook Ads Manager – from creating your campaign and narrowing down your audience, to creating Ad copy and Call to Actions.
Measuring the results of your Paid Ad campaigns

As well as a dedicated Q&A session, where you can ask a social media expert any questions you have about running and creating your own paid advertisements on social media. 




Meet the Host:
Kerry Madge | Marketing Executive, Let's Do Marketing


Kerry Madge is a dynamic Marketing Executive at Let's Do Marketing, bringing nearly six years of diverse experience collaborating with businesses of all sizes. Holding a BA in Marketing Management, Kerry excels in social media advertising, graphic design, and copywriting. Her passion lies in crafting creative solutions and developing comprehensive marketing strategies that empower small businesses to visualise and achieve their overarching goals.



Privacy Notice
By registering for this event, you agree to Let’s Do Business Group processing and managing your personal data in accordance with our Privacy Policy. Your data will only be used for the purposes of managing your event registration and any relevant communications.

Let’s Do Business Group

Social Media Strategy

Social Media Marketing

Social Media

Social Media Management

Start running Paid Ads on social media, and reach more customers than ever before!

Social Media Advanced: Paid Ads

Chesterfield

Mental Health and Wellbeing Training Courses
Building resilience
CPD Accredited, Interactive Workshops

Enquire about this course
2-5 hour workshops
Suitable for anyone who'd like to improve their mental wellbeing and resilience
Giving them the chance to cope with life's challenges


Pochat Training

Stress Management

Health & Wellbeing

Occupational Health & Wellbeing

Emotional Wellbeing

Psychological Wellbeing

Emotional Resilience

Physical Wellbeing

Wellbeing

Mental Resilience

Resilience

Building Resilience

CPD Accredited, Interactive Workshop<ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">2 hr session</li><li fr-original-style="" style="box-sizing: border-box;">Learn how stress affects our mind and body</li><li fr-original-style="" style="box-sizing: border-box;">Learn how to manage your stress and reduce them to an acceptable level</li></ul><h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Contents:</h2><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">What is Stress</li><li fr-original-style="" style="box-sizing: border-box;">Stress versus Pressure</li><li fr-original-style="" style="box-sizing: border-box;">Statistics</li><li fr-original-style="" style="box-sizing: border-box;">Absenteeism, Presenteeism and Leaveism</li><li fr-original-style="" style="box-sizing: border-box;">Workplace Causes of Stress</li><li fr-original-style="" style="box-sizing: border-box;">Personal Causes of Stress</li><li fr-original-style="" style="box-sizing: border-box;">Short-Term and Long-Term Effects of Stress</li><li fr-original-style="" style="box-sizing: border-box;">Coping Strategies</li><li fr-original-style="" style="box-sizing: border-box;">Mental Resilience</li></ul><h2 fr-original-style="" style="box-sizing: border-box;">Benefits of this Workshop:</h2><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">In 2022/23. 875,000 people suffered from work-related stress, depression or anxiety</li><li fr-original-style="" style="box-sizing: border-box;">The affects of stress are far reaching, affecting one&#39;s mind, body, social and personal life</li><li fr-original-style="" style="box-sizing: border-box;">Become more aware of what stresses you, what is does to you and find ways to reduce those stress levels</li></ul><h2 fr-original-style="" style="box-sizing: border-box;"><img src="https://images.cademy.co.uk/pochat-training/4cad2d62-85d7-4e3a-bcea-1ac7f226aebb/original.png" style="width: 661px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 661px; display: block; vertical-align: top; margin: 5px auto; text-align: center;" fr-original-class="fr-draggable"></h2>

Tackle Stress Before It Tackles You!
Work-related stress affects 875,000 people every year, and its impacts go beyond the workplace—affecting your mind, body, and personal life. But it doesn’t have to be this way.
Join our Stress Management Workshops to:
✔️ Understand the difference between stress and pressure
✔️ Learn the causes of stress in and out of the workplace
✔️ Discover practical coping strategies and build mental resilience
These workshops are packed with insights, tools, and strategies to help you take control of your stress levels and improve your well-being—personally and professionally.
There are two different ones to choose from - a 2 hour workshop and a 4 hour workshop!
Course Contents of 2 hour course:
What is Stress
Stress versus Pressure
Statistics
Absenteeism, Presenteeism and Leaveism
Workplace Causes of Stress
Personal Causes of Stress
Short-Term and Long-Term Effects of Stress
Coping Strategies
Mental Resilience
Benefits of this Workshop:
In 2022/23. 875,000 people suffered from work-related stress, depression or anxiety
The affects of stress are far reaching, affecting one's mind, body, social and personal life
Become more aware of what stresses you, what is does to you and find ways to reduce those stress levels



Mental Health Awareness

Mental Health First Aid

Mental Health

Mental Health At Work

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

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

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

The Real Estate Investor course primarily focuses on financial modelling and commercial considerations in the real estate industry across various sectors, geographies, and project types. This course is designed to provide participants with an in-depth understanding of development cash flow modelling, including the representation of risks associated with costs, methods of development financing, and considerations of investment assets.Apart from modelling office sectors, the course includes modelling of commercial residential development and retail investment assets. The course also expands the geographical investment universe to include modelling of real estate cash flows in a pan-European context, accounting for different indexation rules and methods.Overall, the Real Estate Investor course provides participants with advanced skills and knowledge required to successfully undertake real estate investment projects in a global context. Pre-requisite:<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Completion of the Real Estate Analyst Course</li></ul> On this course you will&hellip;<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;">Revise operational models of real estate assets and stress for core income</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Apply modelling techniques to an expanded range of real estate sectors and geographies</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Consider both investment and development cash flows</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Understand the sources and use of funds</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn about typical debt covenants and how to incorporate them</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn how to optimise debt structures</li></ul> Who will benefit from this course?<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 professionals at any level with exposure to real estate financial models</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, debt structures and return metrics</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Analysts and Modellers who are making the transition from corporate finance to real estate investment and development</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Analysts and Investors</li></ul> Course OutlineDay One<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;">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" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Modelling sector variations in real estate income streams i.e. Office versus industrial, retail &amp; leisure</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Further senior debt covenants</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Advance Rent Function techniques to manage feature rich lease structures</li></ul> Day Two<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;">Introduction to development appraisals</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Residual models, site and profit calculations</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Development cash flows versus Investment cash flows</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Introduction to straight line versus S-curve costing</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Phased asset sales in development appraisals</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discounting development cash flows</li><li value="7" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Complimentary return metrics for development appraisals</li><li value="8" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Introduction to development finance</li></ul> Included in the Course<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;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">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" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Files</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">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 Investor 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>





The Real Estate Investor course primarily focuses on financial modelling and commercial considerations in the real estate industry across various sectors, geographies, and project types. This course is designed to provide participants with an in-depth understanding of development cash flow modelling, including the representation of risks associated with costs, methods of development financing, and considerations of investment assets.
Apart from modelling office sectors, the course includes modelling of commercial residential development and retail investment assets. The course also expands the geographical investment universe to include modelling of real estate cash flows in a pan-European context, accounting for different indexation rules and methods.
Overall, the Real Estate Investor course provides participants with advanced skills and knowledge required to successfully undertake real estate investment projects in a global context.


Pre-requisite:
Completion of the Real Estate Analyst Course


On this course you will…
Revise operational models of real estate assets and stress for core income
Apply modelling techniques to an expanded range of real estate sectors and geographies
Consider both investment and development cash flows
Understand the sources and use of funds
Learn about typical debt covenants and how to incorporate them
Learn how to optimise debt structures


Who will benefit from this course?
Real Estate professionals at any level with exposure to real estate financial models
Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, debt structures and return metrics
Analysts and Modellers who are making the transition from corporate finance to real estate investment and development
Real Estate Analysts and Investors


Course Outline
Day One
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 Two
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


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 Investor 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 Analysis

Financial Risk Management

The Real Estate Investor course primarily focuses on financial modelling and commercial considerations in the real estate industry across various sectors, geographies, and project types.

Real Estate Investor (Advanced Development Cash Flow Modelling in Excel)

<h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;"> </h2>This advanced financial modelling course will benefit Real Estate Professionals looking to develop their financial modelling skills to the next level. This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models. On this course you will...<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Understand how the application and use of Structured Finance products in Real Estate</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Learn how to introduce several tranches of debt in a development project</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Understand how to model different parties to a project</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Create Joint Venture structures between Developers, Lenders and Equity Partners</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Learn advanced modelling techniques to analyse underlying asset risk</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Understand how underlying asset risk impacts return to all parties to a project</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 professionals from a mid to senior level with exposure to Real Estate financial models</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, portfolio analysis, and risk analysis</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Real Estate Investors who would like to expand their knowledge and understanding of Real Estate cash flow models to an advanced level</li></ul> Course Outline:<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;">Advanced 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 Modelling Masterclass 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>



This advanced financial modelling course will benefit Real Estate Professionals looking to develop their financial modelling skills to the next level. This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.


On this course you will...
Understand how the application and use of Structured Finance products in Real Estate
Learn how to introduce several tranches of debt in a development project
Understand how to model different parties to a project
Create Joint Venture structures between Developers, Lenders and Equity Partners
Learn advanced modelling techniques to analyse underlying asset risk
Understand how underlying asset risk impacts return to all parties to a project


Who will benefit from this course?
Real Estate professionals from a mid to senior level with exposure to Real Estate financial models
Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, portfolio analysis, and risk analysis
Real Estate Investors who would like to expand their knowledge and understanding of Real Estate cash flow models to an advanced level


Course Outline:
Mezzanine debt modelling
Joint Venture structures between developers and lender/equity partners
Promote and profit share structure calculations
Advanced 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 Modelling Masterclass 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

Investment Management

This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.

723 Management courses in Glasgow

Construction Project Manager 2 Days Training in Glasgow

By Mangates

Construction Project Manager 2 Days Training in Paisley

By Mangates

Construction Project Manager 2 Days Training in Hamilton, UK

By Mangates

Construction Project Manager 2 Days Training in Airdrie

By Mangates

Conflict Management 1 Day Training in Glasgow

By Mangates

Conflict Management 1 Day Training in Paisley

By Mangates

Emotional intelligence 1 Day Training in Glasgow

By Mangates

Time Management 1 Day Training in Glasgow

By Mangates

Emotional intelligence 1 Day Training in Paisley

By Mangates

Time Management 1 Day Training in Paisley

By Mangates

Search By Location