Name: Definitive SIP for engineers
Price: 2367 GBP
Availability: InStock

Redhill

<h3>WCNA training course description</h3>
 
 Wireshark is a free network protocol analyser. This hands-on course provides a comprehensive tour of using Wireshark to troubleshoot networks. The course concentrates on the information needed in order to pass the WCNA exam. Students will gain the most from this course only if they already have a sound knowledge of the TCP/IP protocols.
 
				<h5>What will you learn</h5>
				<ul>
				 
 
					<li>Analyse packets and protocols in detail.</li>
<li> Troubleshoot networks using Wireshark.</li>
<li>Find performance problems using Wireshark.</li>
<li> Perform network forensics.</li>
 </ul>
 
 <h5>
 WCNA training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Technical staff looking after networks.
 
							<li>Prerequisites:</li>
							
 TCP/IP Foundation for engineers
 
							<li>Duration</li>
							
 5 days
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>WCNA training course contents</h3>
				<ul>	<li>What is Wireshark?</li>
Network analysis, troubleshooting, network traffic
flows. Hands on Download/install Wireshark.
<li>Wireshark introduction</li>
Capturing packets, libpcap, winpcap, airpcap.
Dissectors and plugins. The menus. Right click.
 Hands on Using Wireshark.
<li>Capturing traffic</li>
Wireshark and switches and routers. Remote
traffic capture. Hands on Capturing packets.
<li>Capture filters</li>
Applying, identifiers, qualifiers, protocols,
addresses, byte values. File sets, ring buffers.
 Hands on Capture filters.
<li>Preferences</li>
Configuration folders. Global and personal
configurations. Capture preferences, name
resolution, protocol settings. Colouring traffic.
Profiles. Hands on Customising Wireshark.
<li>Time</li>
Packet time, timestamps, packet arrival times,
delays, traffic rates, packets sizes, overall bytes.
 Hands on Measuring high latency.
<li>Trace file statistics</li>
Protocols and applications, conversations, packet
lengths, destinations, protocol usages, strams,
flows. Hands on Wireshark statistics.
<li>Display filters</li>
Applying, clearing, expressions, right click,
conversations, endpoints, protocols, combining
filters, specific bytes, regex filters. Hands on
Display traffic.
<li>Streams</li>
Traffic reassembly, UDP and TCP conversations,
SSL. Hands on Recreating streams.
<li>Saving</li>
Filtered, marked and ranges. Hands on Export.
<li>TCP/IP Analysis</li>
The expert system. DNS, ARP, IPv4, IPv6, ICMP,
UDP, TCP. Hands on Analysing traffic.
<li>IO rates and trends</li>
Basic graphs, Advanced IO graphs. Round Trip
Time, throughput rates. Hands on Graphs.
<li>Application analysis</li>
DHCP, HTTP, FTP, SMTP. Hands on Analysing
application traffic.
<li>WiFi</li>
Signal strength and interference, monitor mode
and promiscuous mode. Data, management and
control frames. Hands on WLAN traffic.
<li>VoIP</li>
Call flows, Jitter, packet loss. RTP, SIP. Hands on Playing back calls.
<li>Performance problems</li>
Baselining. High latency, arrival times, delta
times. Hands on Identifying poor performance.
<li>Network forensics</li>
Host vs network forensics, unusual traffic
patterns, detecting scans and sweeps, suspect
traffic. Hands on Signatures.
<li>Command line tools</li>
Tshark, capinfos, editcap, mergecap, text2pcap,
dumpcap. Hands on Command tools. 

				</ul>

Systems & Network Training

Network & Security

Network Engineer

Wireshark Certified Network Analyst

General Admission

<h3>Network design training course description</h3>
 This course provides you with the knowledge needed to
perform the design of a network infrastructure that
supports desired network solutions to achieve effective
performance, scalability, and availability. We recognise
that the role of design does not normally require hands
on skills but hands on sessions are used to reinforce the
theory not to teach configuration or troubleshooting.
 
				<h5>What will you learn</h5>
				<ul>
				 
 <li>Create HA enterprise network designs.</li>
 <li>Develop optimum Layer 3 designs.</li>
 <li>Design effective modern WAN and data center
networks.</li>
 <li>Develop effective migration approaches to IPv6.</li>
 <li>Create effective network security designs.</li>
 							 </ul>
 <h5>
 Network design training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Anyone involved with network design.
 
							<li>Prerequisites:</li>
							
 TCP/IP Foundation for engineers
 
							<li>Duration</li>
							
 5 days
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>Network design training course contents</h3>
 
				<h6>Part I Reliable, resilient enterprise L2/3 network design</h6>
 Optimal Enterprise Campus Design: Enterprise campus
				design principles, hierarchy, modularity, flexibility, resiliency. 
				EIGRP design: EIGRP Design, Should you use EIGRP? 
				OSPF design: OSPF scalability designs, OSPF area design,
OSPF Full-Mesh Design, OSPF Hub-and-Spoke Design, OSPF convergence design and optimization techniques.
				 IS-IS Design: The protocol, IS-IS hierarchical architecture,
IS-IS vs OSPF, IS-IS Deep Dive, IS-IS Design Considerations.
				 BGP design: BGP overview, Designing Scalable iBGP
Networks, BGP Route Reflector Design, Enhancing the Design
of BGP Policies with BGP Communities, Case Study:
Designing Enterprise wide BGP Policies Using BGP
Communities, BGP Load-Sharing Design. 
<h6>Part II Enterprise IPv6 Design Considerations</h6>
				IPv6 Design Considerations in the Enterprise: IPv6
Deployment and Design Considerations, Considerations for
Migration to IPv6 Design, IPv6 Transition Mechanisms, Final
Thoughts on IPv6 Transition Mechanisms.
				 Challenges of the Transition to IPv6: IPv6 Services, Link
Layer Security Considerations.
		<h6>Part III Modern Enterprise Wide-Area Networks Design</h6>
		Service Provider-Managed VPNs: Choosing Your WAN
Connection, Layer 3 MPLS VPNs, Case Study: MPLS VPN
Routing Propagation, Layer 2 MPLS VPN Services.
		 Enterprise-Managed WANs: Enterprise-Managed VPNs,
GRE, Multipoint GRE, Point-to-Point and Multipoint GRE,
IPsec, IPsec and dynamic VTI, DMVPN, Case Study: EIGRP
DMVPN, DMVPN and Redundancy, Case Study: MPLS/VPN
over GRE/DMVPN, SSL VPN.
		 Enterprise WAN Resiliency Design: WAN Remote-Site
Overview, MPLS L3 WAN Design Models, Common L2 WAN
Design Models, Common VPN WAN Design Models, 3G/4G
VPN Design Models, Remote Site Using Local Internet,
Remote-Site LAN, Case Study: Redundancy and Connectivity,
NGWAN, SDWAN, and IWAN Solution Overview, IWAN
Design Overview, Enterprise WAN and Access Management.
		
<h6>Part IV Enterprise Data Center Designs</h6>
		Multitier Data Center Designs: Case Study: Small Data
Centers (Connecting Servers to an Enterprise LAN), Case
Study: Two-Tier Data Center Network Architecture, Case
Study: Three-Tier Data Center Network Architecture. 
		Trends and Techniques to Design Modern Data Centers: 
The Need for a New Network Architecture, Limitations of
Current Networking Technology, Modern Data Center Design
Techniques and Architectures, Multitenant Data Center.
		 SDN: SDN characteristics, How SDN addresses current
Networking Limitations, SDN Architecture Components, SDN
Network Virtualization overlays.
		 Data Center Connections: Data Center Traffic Flows, The
Need for DCI, IP Address Mobility, Case Study: Dark Fiber
DCI, Pseudowire DCI.
				<h6>Part V Design QoS for Optimized User Experience</h6>
	QoS Overview: QoS Overview, IntServ versus DiffServ,
Classification and Marking, Policers and Shapers, Policing
Tools: Single-Rate Three-Color Marker, Policing Tools: TwoRate Three-Color Marker, Queuing Tools, Dropping Tools.
	QoS design principles and best practices: QoS overview,
classification and marking design principles, policing and
remarking design principles, queuing design principles,
dropping design principles, Per-Hop behavior queue design
principles, RFC 4594 QoS Recommendation, QoS Strategy
Models. Campus QoS, WAN QoS, Data Center QoS. 
	MPLS VPN QoS Design: The Need for QoS in MPLS VPN,
Layer 2 Private WAN QoS Administration, Fully Meshed
MPLS VPN QoS Administration, MPLS DiffServ Tunneling
Modes, Sample MPLS VPN QoS Roles.
	 IPsec VPN QoS Design: The Need for QoS in IPsec VPN,
VPN Use Cases and Their QoS Models, IPsec Refresher,
Encryption and Classification: Order of Operations, MTU
Considerations, DMVPN QoS Considerations.
	<h6>Part VI IP Multicast Design</h6>
	Enterprise IP Multicast Design: How Does IP Multicast
Work? Multicast Protocols, Multicast Forwarding and RPF
Check, Multicast Protocol Basics, PIM-SM Overview, Multicast
Routing Table, Basic SSM Concepts, Bidirectional PIM. RP
discovery, Anycast RP Features, MSDP.
	<h6>Part VII Designing Optimum Enterprise Network Security</h6>
	Designing Security Services and Infrastructure Protection 
Network Security Zoning, Designing Infrastructure Protection. 
	Designing firewall &amp; IPS solutions: Firewall architectures,
virtualized firewalls. Case Study: Application Tier separation,
Case Study: Firewalls in a Data Center, Case Study: Firewall
High Availability, IPS Architectures, Case Study: Secure
Campus Edge Design (Internet and Extranet Connectivity).
 IP Multicast Security: Multicast Security Challenges,
Multicast Network Security Considerations.
	 Designing Network Access Control Solutions: IEEE
802.1X, EAP, 802.1X supplicants, 802.1X phased
deployment, Case Study: Authorization Options.
	<h6>Part VIII Design scenarios</h6>
	Design Case Studies: 1: Enterprise Connectivity, 2:
Enterprise BGP with Internet Connectivity, 3: IPv6, 4: Data
Center Connectivity, 5: Resilient Enterprise WAN, 6: Secure
Enterprise Network, 7: QoS in the Enterprise Network.

Network design

<h3>Definitive IP routing training course description</h3>
 An intensive hands on IP routing course leading to
 LINX Accredited Internet Technician stage 2 focusing
 on routing in an IP environment. The course
 concentrates on OSPF and IS-IS but also covers BGP
 and MPLS. Hands on sessions are used to reinforce
 the theory rather than teach specific manufacturer
 equipment. 
 A multiple choice exam, leading to the LAIT II
 certification, is available after the course. The exam
 consists of 60 questions and lasts 2.0 hours. 
 
				<h5>What will you learn</h5>
				<ul>
				 
 <li>Calculate subnet numbers in seconds.</li>
 <li>Configure and troubleshoot static routes.</li>
 <li>Explain how OSPF works.</li>
 <li>Build resilient networks with VRRP and OSPF.</li>
 <li>Implement and troubleshoot OSPF, IS-IS and
 VLANS.</li>
 <li>Evaluate and choose appropriate routing protocols for particular scenarios.</li>
 </ul>
 An optional multiple choice exam, leading to the LAIT II certification, is included at the end of the course. The exam consists of 60 questions and lasts 2.0 hours.
 <h5>
 Definitive IP routing training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Network engineers 
 
							<li>Prerequisites:</li>
							
 TCP/IP Foundation for engineers
 
							<li>Duration</li>
							
 5 days
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>Definitive IP routing training course contents</h3>
 <ul>
 <li>Basic routing</li>
 Review of LAIT I routing, reading routing tables. 
 
 Hands on Setting up a routed network. 
 <li>Static routes</li>
 Why use static routes? Default routes. 
 
 Hands on Configuring static routes. 
 <li>First hop redundancy</li>
 Default gateways, VRRP/HSRP/GLBP. Load
 sharing, critical IP addresses. 
 Hands on VRRP. 
 <li>Basic OSPF</li>
 What is OSPF? Process IDs, passive interfaces. 
 Hands on Simple OSPF. 
 <li>Subnetting</li>
 Bit boundary subnetting, calculating network
 numbers. 
 
 Exercise: Subnetting. 
 <li>OSPF overview</li>
 Metrics, convergence, DV vs. Link state, IGPs,
 classless, OSPF features, load sharing, OSPF
 authentication. 
 Hands on OSPF features. 
 <li>OSPF within an area</li>
 How OSPF works, LSAs, LSDB, router IDs, hellos,
 configuring hellos, exchange protocol. 
 Hands on Investigating OSPF structures.
			
 
 <li> OSPF areas</li>
 
 Scalability, why areas? Area IDs, area 0, ABRs,
 ABR resilience, areas &amp; LSDBs &amp; LSAs, virtual
 links. 
 Hands on Multi area OSPF. 
 <li>Redistribution</li>
 Multiple routing protocols, common scenarios,
 routing distance, External LSAs, E1 and E2. Type
 4 LSAs. OSPF and default routes. 
 Hands on Configuring static route redistribution. 
 <li>Route aggregation</li>
 Route summarisation. How to aggregate, CIDR,
 ASBR summarisation. 
 Hands on OSPF address
 summarisation. 
 <li>OSPF packet formats</li>
 OSPF packets, protocol stack, packet flows,
 OSPF headers, neighbours, neighbour states,
 DRs, adjacencies, BDRs, DR election. 
 Hands on Analysing OSPF packets, troubleshooting. OSPF 
 <li>OSPF stub areas</li>
 LSA types, area types, area architecture, stub
 areas, default routes, benefits &amp; disadvantages of
 stub areas, TSSAs, NSSAs, Type 7 LSAs. 
 Hands on Stub and TSSA configuration. 
 <li>IS-IS</li>
 End systems, Intermediate systems, how IS-IS
 works, IS-IS router ID, Level 1, Level 2, IS-IS
 hierarchy. 
 Hands on Configuring IS-IS,
 troubleshooting IS-IS. 
 <li>The Internet</li>
 Autonomous systems, Peering, transit, looking
 glasses. 
 Hands on Internet routing tables. 
 <li>Basic BGP</li>
 IGPs, EGPs, What's BGP? BGP RIB, in/out
 process, tables peers, adding routes. 
 Hands on Simple configuration and troubleshooting. 
 <li>Routing IPv6</li>
 Multi protocol routing, IPv6 addressing, IPv6
 routing tables, IPv6 static routes, OSPFv3, IS-IS
 and IPv6. 
 Hands on Routing IPv6. 
 <li>STP and L2 routing</li>
 STP, RSTP, L2 IS-IS, Multi system link
 aggregation. 
 Hands on RSTP. 
 <li>MPLS</li>
 Core MPLS, MPLS and the 7 layer model, MPLS
 protocol, MPLS standard, MPLS runs on routers,
 MPLS history, Why MPLS?, LSRs, PE and P
 router roles, FEC, swapping labels, MPLS packet
 format. 
 Hands on Enabling MPLS. Testing and
 troubleshooting of MPLS. 
 <li>Appendix</li>
 EIGRP: How EIGRP works, DUAL. 
 </ul>

Definitive IP routing for engineers

<h3>LINX II training course description</h3>
 An intensive hands on IP routing course leading to
LINX Accredited Internet Technician stage 2 focusing
on routing in an IP environment. The course
concentrates on OSPF and IS-IS but also covers BGP
and MPLS. Hands on sessions are used to reinforce
the theory rather than teach specific manufacturer
equipment.
 A multiple choice exam, leading to the LAIT II
certification, is available after the course. The exam
consists of 60 questions and lasts 2.0 hours.
 
 
				<h5>What will you learn</h5>
				<ul>
				 
 <li>Calculate subnet numbers in seconds.</li>
					<li>Configure and troubleshoot static routes</li>
 <li>Explain how OSPF works.</li>
 <li>Build resilient networks with VRRP and OSPF.</li>
 <li>Implement and troubleshoot OSPF, IS-IS, simple
BGP and simple MPLS.</li>
 <li>Evaluate and choose appropriate routing protocols for particular scenarios.</li>
 </ul>
 <h5>
 LINX II training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Network engineers.
 
							<li>Prerequisites:</li>
							
 LAIT I attendance and 55%+ exam score OR 
 LAIT I exam only and pass (70%+) OR CCNA and take LAIT I exam on this course.
 
							<li>Duration</li>
							
 5 days
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>LINX II training course contents</h3>
 <ul>
 <li>Basic routing</li>
 Review of LAIT I routing, reading routing tables. 
 
 Hands on Setting up a routed network. 
 <li>Static routes</li>
 Why use static routes? Default routes. 
 
 Hands on Configuring static routes. 
 <li>First hop redundancy</li>
 Default gateways, VRRP/HSRP/GLBP. Load
 sharing, critical IP addresses. 
 Hands on VRRP. 
 <li>Basic OSPF</li>
 What is OSPF? Process IDs, passive interfaces. 
 Hands on Simple OSPF. 
 <li>Subnetting</li>
 Bit boundary subnetting, calculating network
 numbers. 
 
 Exercise: Subnetting. 
 <li>OSPF overview</li>
 Metrics, convergence, DV vs. Link state, IGPs,
 classless, OSPF features, load sharing, OSPF
 authentication. 
 Hands on OSPF features. 
 <li>OSPF within an area</li>
 How OSPF works, LSAs, LSDB, router IDs, hellos,
 configuring hellos, exchange protocol. 
 Hands on Investigating OSPF structures.
			
 
 <li> OSPF areas</li>
 
 Scalability, why areas? Area IDs, area 0, ABRs,
 ABR resilience, areas &amp; LSDBs &amp; LSAs, virtual
 links. 
 Hands on Multi area OSPF. 
 <li>Redistribution</li>
 Multiple routing protocols, common scenarios,
 routing distance, External LSAs, E1 and E2. Type
 4 LSAs. OSPF and default routes. 
 Hands on Configuring static route redistribution. 
 <li>Route aggregation</li>
 Route summarisation. How to aggregate, CIDR,
 ASBR summarisation. 
 Hands on OSPF address
 summarisation. 
 <li>OSPF packet formats</li>
 OSPF packets, protocol stack, packet flows,
 OSPF headers, neighbours, neighbour states,
 DRs, adjacencies, BDRs, DR election. 
 Hands on Analysing OSPF packets, troubleshooting. OSPF 
 <li>OSPF stub areas</li>
 LSA types, area types, area architecture, stub
 areas, default routes, benefits &amp; disadvantages of
 stub areas, TSSAs, NSSAs, Type 7 LSAs. 
 Hands on Stub and TSSA configuration. 
 <li>IS-IS</li>
 End systems, Intermediate systems, how IS-IS
 works, IS-IS router ID, Level 1, Level 2, IS-IS
 hierarchy. 
 Hands on Configuring IS-IS,
 troubleshooting IS-IS. 
 <li>The Internet</li>
 Autonomous systems, Peering, transit, looking
 glasses. 
 Hands on Internet routing tables. 
 <li>Basic BGP</li>
 IGPs, EGPs, What's BGP? BGP RIB, in/out
 process, tables peers, adding routes. 
 Hands on Simple configuration and troubleshooting. 
 <li>Routing IPv6</li>
 Multi protocol routing, IPv6 addressing, IPv6
 routing tables, IPv6 static routes, OSPFv3, IS-IS
 and IPv6. 
 Hands on Routing IPv6. 
 <li>STP and L2 routing</li>
 STP, RSTP, L2 IS-IS, Multi system link
 aggregation. 
 Hands on RSTP. 
 <li>MPLS</li>
 Core MPLS, MPLS and the 7 layer model, MPLS
 protocol, MPLS standard, MPLS runs on routers,
 MPLS history, Why MPLS?, LSRs, PE and P
 router roles, FEC, swapping labels, MPLS packet
 format. 
 Hands on Enabling MPLS. Testing and
 troubleshooting of MPLS. 
 <li>Appendix</li>
 EIGRP: How EIGRP works, DUAL. 
 </ul>

LINX 2

<h3>Total H.248 training course description</h3>
 A course focusing purely on the H.248 protocol. Anyone working through the ITU standards documents can testify to the need of a training course to explain how H.248 really works. This course already assumes knowledge of other VoIP protocols and starts by positioning H.248 in relation to the other protocols. The course then looks at H.248 architectures and concepts before analysing H.248 messages and call flows. 
 
				<h5>What will you learn</h5>
				<ul>
				 
 <li>Describe what H.248 is</li>
 <li>Recognise where H.248 fits in relation to other VoIP protocols.</li>
 <li>Explain how H.248 works.</li>
 <li>Analyse H.248 packets</li>
 </ul>
 
 <h5>
 Total H.248 training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Technical staff working with H.248 
 
							<li>Prerequisites:</li>
							
 Voice Over IP.
 
							<li>Duration</li>
							
 2 days
						
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>Total H.248 training course contents</h3>
 <ul>
				<li>What is H.248?</li> Review of VoIP protocols: RTP, RTCP, SIP, SDP, H.323. The PSTN and SS7. Where H.248 fits into the picture. H.248 history. MGCP. The IETF. Megaco. ITU standards. H.248v1, v2, v3. 
 
 
<li>H.248 architectures</li> Media Gateways, Media Gateway Controllers, Gateway Control functions, Signalling Gateways. Reference architectures: IMS/TISPAN: IBCF, IWF, I-BGF, SPDF. MSF: S-SBG-NC, D-SBG-NC. GSMA: IPX Proxy. Softswitches. 
 
 
<li>H.248 concepts</li> The connection model, terminations, streams, contexts. Termination properties: descriptors, context properties. Events, signals, packages. 
 
 
<li>H.248 messages</li> Protocol stack, UDP, TCP. Message structure. Transactions, actions, commands. Requests, replies, acknowledgements. Sample message flows. Binary encoding, ASN syntax, Text encoding. 
 
 
<li>H.248 commands</li> Termination manipulation: Add, Subtract, Move, Modify. Event reporting: Notify. Management: AuditCapability, AuditValue, ServiceChange. 
 
 
<li>H.248 Descriptors</li> What are descriptors? Relationship with messages and commands. Basic descriptors, Descriptors composed of other descriptors. The 19 descriptors. Defaults. 
 
 
<li>H.248 Transactions</li> Groups of commands, transaction Ids, relationship with actions and commands. Requests and replies. 
 
 
	<li>H.248 wrap up</li> What is a package? Basic packages. H.248 security. H.248 - SIP interoperation. H.248 interoperation with other protocols. 
 

 </ul>

Total H.248 for Engineers

<h3>LTE Architecture and Protocols course description</h3>
 This course provides a comprehensive tour of the LTE
architecture along with services provided and the
protocols used.
 
				<h5>What will you learn</h5>
				<ul>
				 
			
 <li>Describe the overall architecture of LTE.</li>
																				<li>Explain the information flows through LTE.</li>
 <li>Describe the LTE security.</li>
 <li>Describe LTE mobility management.</li> 
 <li>Recognise the next steps for LTE.</li>
 </ul>
 <h5>
 LTE Architecture and Protocols course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Anyone working with LTE.
 
							<li>Prerequisites:</li>
							
 Mobile communications demystified
							
 
							<li>Duration</li>
							
 3 days
						
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>LTE Architecture and Protocols course contents</h3>
 <ul>
				<li>Introduction </li>
History, LTE key features. The 4G ITU process. The LTE 3GPP specifications. Specifications.

<li>System Architecture </li>
LTE hardware architecture. UE architecture and capabilities. E-UTRAN and eNB. EPC, MME functions, SGW, PGW and PCRF. System interfaces and protocol stacks. Example information flows. Dedicated and default bearers. EMM, ECM, RRC state diagrams.

<li>Radio transmission and reception </li>
OFDMA, SC-FDMA, MIMO antennas. Air interface protocol stack. Logical, transport and physical channels. Frame and slot structure, the resource grid. Resource element mapping of the physical channels and signals. Cell acquisition, data transmission and random access. MAC, RLC, PDCP protocols. LTE spectrum allocation.

<li>Power-on procedures </li>
Network and cell selection. RRC connection establishment. Attach procedure, including IP address allocation and default bearer activation. LTE detach procedure.

<li>Security in LTE networks </li>
LTE security features, identity confidentiality, ciphering and integrity protection. Architecture of network access security in LTE. Secure key hierarchy. Authentication and key agreement procedure. Security mode command procedure. Network domain security architecture. Security associations using IKE and IPSec.

<li>Mobility management </li>
RRC_IDLE, RRC_CONNECTED. Cell reselection, tracking area updates. Measurement reporting. X2 and S1 based handovers. Interoperation with UMTS, GSM and non-3GPP technologies such as cdma2000.

<li>QoS, policy control and charging </li>
QoS in LTE, EPS bearers, service data flows and packet flows. The architecture and signalling procedures for policy and charging control. Data transport using GPRS, differentiated services and MPLS. Offline and online charging in LTE.

<li>Delivery of voice and text messages over LTE </li>
Difficulties and solutions for Voice over LTE. Architecture and call setup procedures for circuit switched fallback. Architecture, protocols and call setup procedures in IP multimedia subsystem.

<li>Enhancements in release 9 </li>
LTE location services. Multimedia broadcast / multicast service and MBSFN. Cell selection, commercial mobile alert service.

<li>LTE Advanced and release 10 </li>
Impact of carrier aggregation on LTE air interface. Enhanced MIMO processing on uplink and downlink. Relaying. Release 11 and beyond.

<li>OAM and self organising networks </li>
Operation, administration, maintenance and provisioning for LTE. Self-configuration of base station parameters. Fractional frequency re-use, inter-cell interference co-ordination. Self-optimisation of base station procedures. Self-healing to detect and recover from faults.
 </ul>

LTE Architecture and Protocols

<h3>4G training course description</h3>
 This course is designed to give the delegate an
understanding of the technologies used within a 3G
UMTS mobile network. During the course we will
investigate the UMTS air interface and the use of
Wideband-Code Division Multiple Access (WCDMA) to
facilitate high speed data access, together with HSPA
to offer mobile broadband services. We will describe
the use of soft handover rather than hard handover
procedures and soft capacity sharing. The course
includes a brief exploration of the UMTS protocol stack
and the use of PDP Context and QoS support features.
 
				<h5>What will you learn</h5>
				<ul>
				 
				<li>Explain the 3G UMTS architecture.</li>
																				<li>Describe the role of a Drifting &amp; Serving RNC.</li>
 <li>Explain the use of ARQ &amp; HARQ for mobile broadband.</li>
 <li>Describe how IMS integrates into the architecture.</li>
 <li>Describe the use of Media Gateway Controllers.</li>
 <li>Identify the temporary identities used within 3G UMTS.</li>
 </ul>
 <h5>
 4G training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Anyone working within the telecommunications area,
especially within the mobile environment.
 
							<li>Prerequisites:</li>
							
 Mobile communications demystified Telecommunications Introduction
							
 
							<li>Duration</li>
							
 2 days
						
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>4G training course contents</h3>
 <ul>
				<li>LTE Introduction </li>
The path to LTE, 3GPP. LTE to LTE advanced.

<li>LTE Architecture </li>
The core, Access, roaming. Protocols: User plane, Control plane. Example information flows. Bearer management. Spectrum allocation.

<li>LTE technologies </li>
Transmission, reception, OFDMA, multiple antenna, MIMO.

<li>LTE Air interface </li>
Air interface protocol stack. Channels, Resource Grid, cell acquisition. Up and downlink controls. Layer 2 protocols.

<li>Cell acquisition </li>
Power on, selecting networks and cells. RRC connection. Attach procedure.
 
<li>Mobility management </li>
Roaming, RRC_IDLE, RRC_CONNECTED, cell reselection, handover, interoperation with UMTS and GSM networks.

<li>Voice and text </li>
IMS, QoS, policy and charging.
 </ul>

4G demystified

<h3>LTE Airside training course description</h3>
 This course provides a concise insight into the LTE
airside. Key parts of the course are detailed looks at the
air interface protocol stack, cell acquisition,
transmission and reception of data and of he layer 1
procedures along with layer 2 procedures.
 
				<h5>What will you learn</h5>
				<ul>
				 
			
 <li>Explain the RF optimisation flowchart.</li>
																				<li>Describe the importance of Reference Signal
Received Power (RSRP).</li>
 <li>List many of the 3GPP recommended KPIs.</li>
 <li>Describe the concept of APN AMBR and UE AMBR
within LTE.</li> 
 
 <li>Describe the use of planning and optimisation
computer tools.</li>
 </ul>
 <h5>
 LTE Airside training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Anyone working with LTE.
 
							<li>Prerequisites:</li>
							
 Essential LTE
							
 
							<li>Duration</li>
							
 2 days
						
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>LTE Airside training course contents</h3>
 <ul>
				<li>Introduction and review of LTE </li>
This section describes the requirements of LTE and key technical features, and reviews the system architecture. LTE Architecture, UE, E-UTRAN and EPC. Specifications.

<li>OFDMA, SC-FDMA and MIMO antennas </li>
This section describes the techniques used in the LTE air interface, notably orthogonal frequency division multiple access (OFDMA) and multiple input multiple output (MIMO) antennas. Communication techniques for fading multipath channels. OFDMA, FFT processing and cyclic prefix insertion. SC-FDMA in the LTE uplink. Multiple antenna techniques including transmit &amp; receive diversity and spatial multiplexing.

<li>Introduction to the air interface </li>
This section covers the operation of the air interface, the channels that it uses, and the mapping to the time and frequency domains of OFDMA and SC-FDMA. Air interface protocol stack. Logical, transport and physical channels. Frame and slot structure, the resource grid. Resource element mapping of the physical channels and physical signals. LTE spectrum allocation.

<li>Cell acquisition </li>
This is the first of three sections covering the air interface physical layer. Here, we cover mobile procedures to start low-level communications with the cell, and base station transmission of the corresponding information. Primary/secondary synchronisation signals. Downlink reference signals. The master information block. Physical control format indicator channel. Organisation and transmission of the system information.

<li>Data transmission and reception </li>
In this section, we cover procedures used for data transmission and reception on the shared channels, and describe in detail the individual steps. Data transmission and reception on the uplink and downlink. Scheduling commands and grants on the PDCCH. DL-SCH and UL-SCH. Physical channel processing of the PDSCH and PUSCH. Hybrid ARQ indicators on the PHICH. Uplink control information on the PUCCH. Uplink demodulation and sounding reference signals.

<li>Additional physical layer procedure </li>
This section concludes our discussion of the air interface physical layer, by discussing a number of procedures that support its operation. Transmission of the physical random access channel. Contention and non-contention based random access procedures. Discontinuous transmission in idle and connected modes. Uplink power control and timing advance.

<li>Air interface layer 2 </li>
This section describes the architecture and operation of layer 2 of the air interface protocol stack. MAC protocol, interactions with the physical layer, use for scheduling. RLC protocol, transparent, unacknowledged and acknowledged modes. PDCP, including header compression, security functions and recovery from handover.
 </ul>

LTE airside

<h3>LTE Backhaul training course description</h3>
 This course provides a concise insight into the LTE
backhaul. Key parts of the course are detailed looks at
the transport of messages and the S1 and X2
protocols.
 
				<h5>What will you learn</h5>
				<ul>
				 
			
 <li>Describe the overall architecture of LTE.</li>
					<li>Explain how data and signalling messages are
transported in LTE.</li>
 <li>Describe the S1 protocol.</li>
 <li>Describe the X2 protocol.</li>
 </ul>
 <h5>
 LTE Backhaul training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Anyone working with LTE.
 
							<li>Prerequisites:</li>
							
 Mobile communications demystified
							
 
							<li>Duration</li>
							
 2 days
						
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>LTE Backhaul training course contents</h3>
 <ul>
				<li>Introduction </li>
In the first section of the course, we review LTE and its hardware and software architecture. Requirements and key features of LTE. LTE Architecture and capabilities of the UE. Architecture of the E-UTRAN, functions of the eNB. EPC architecture, and functions of the MME, SGW, PGW and PCRF. System interfaces and protocol stacks. Example information flows. Dedicated and default bearers. EMM, ECM and RRC state diagrams.

<li>Architecture of the radio access network </li>
In this section, we look in more detail at the architecture of the evolved UMTS terrestrial radio access network (E-UTRAN). Logical and physical architecture of the E-UTRAN. Numbering, addressing and identification. E-UTRAN functions. E-UTRAN protocol stacks. Timing and frequency synchronisation in LTE.

<li>Transport of data and signalling in LTE </li>
Here, we look in more detail at the techniques and protocols that are used to transport data and signalling messages across the evolved UMTS terrestrial radio access network and the evolved packet core. Quality of service in LTE. The GPRS tunnelling protocol. Differentiated services Multi-protocol label switching (MPLS). The stream control transmission protocol (SCTP).

<li>The S1 application protocol </li>
This section gives a detailed account of the signalling procedures in the S1 application protocol, which the MME uses to control the operation of the eNB. The material looks at the procedures, messages and information elements, and relates them to the system-level procedures in which they are used. S1 setup procedure. UE context management procedures. Non access stratum information transport. Procedures for managing the evolved radio access bearer (E-RAB). Paging procedures. Mobility management procedures for S1-based handovers. Procedures in support of self-optimising networks.

<li>The X2 application protocol </li>
This section gives a detailed account of the signalling procedures in the X2 application protocol, which is used for peer-to-peer communication between eNBs. The material looks at the procedures, messages and information elements, and relates them to the system-level procedures in which they are used. X2 setup procedure. Mobility management procedures for X2-based handovers Procedures in support of self-optimising networks.

<li>High level system operation </li>
In the final section, we bring our discussions of the S1 and X2 application protocols together by reviewing the system-level operation of LTE. Attach procedure. Transitions between the states of RRC Idle and RRC Connected. Tracking area updates in RRC Idle. Handover procedures in RRC Connected.
 </ul>

LTE backhaul

<h3>SIP training course description</h3>
 A hands on course covering IP telephony with SIP. The course starts with a brief review of knowledge students should already possess including RTP and RTCP. The main focus is on SIP though, progressing from what SIP is through SIP signalling, call processing and architectures, moving onto more advanced issues including security, multimedia, and interoperability. Hands-on practicals follow each major theory session. 
 
				<h5>What will you learn</h5>
				<ul>
				 
 <li>Explain how SIP works.</li>
					<li>Analyse SIP packets.</li>
					<li>Deploy SIP IP telephony solutions.</li>
 <li>Integrate SIP with other telephony solutions.</li>
 </ul>
 
 <h5>
 SIP training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 Technical staff working with SIP. 
 
							<li>Prerequisites:</li>
							
 Definitive VoIP for engineers 
 
							<li>Duration</li>
							
 3 days
						
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>SIP training course contents</h3>
 <ul>
				<li>VoIP review</li>
What is VoIP? Brief review of IP, Brief review of
telephones and voice. RTP, RTCP, mixers and
translators. Hands on Analysing RTP packets.
				<li>What is SIP?</li>
Why SIP? SIP history, SIP standards, SIP
capabilities, key services, how SIP works, and a
basic SIP call. Hands on Peer to peer SIP.
<li>SIP messages</li>
SIP sessions, SIP flows, Message structure,
INVITE, ACK, BYE, CANCEL, OPTIONS,
REGISTER. Extension methods. Response codes.
SIP call flows. Hands on Analysing SIP packets.
<li>SIP architectures</li>
UA client, UA server, Proxy servers, Redirect
servers, registrars. SIP phones, gateways,
application servers, and other products. Stateful
and stateless servers. Various call scenarios.
 Hands on SIP proxies.
<li>SIP addressing</li>
URLs, SIP addresses, registration, Location and
Directory servers. Address tracking. Hands on SIP
and DNS.
<li>Supplementary services</li>
SIP signalling, signalling compression, Call hold,
Call forwarding, Home and away scenarios,
transfers, conferences, call control. Hands on
Analysing SIP supplementary services.
<li>SDP</li>
What is SDP? Multimedia, multimedia session
announcement, invitation and others. Relationship
with SIP. Hands on Video conferencing with SIP.
<li>SIP security</li>
Access control, Authentication, encryption,
firewalls. Hands on SIP authentication.
<li>Interoperability</li>
Inter working with PSTN, ISUP to SIP mapping,
SIP and 3G, SIP-T, SIP and SIGTRAN. SIP and
H323. Hands on SIP and gateways.
<li>SIP mobility</li>
Terminal mobility, service mobility, personal
mobility, Mobile IP, SIP signalling flows in 3G.


 </ul>

Definitive SIP for engineers

This Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.This is another One-Day course that is intended for the most ambitious modellers in the property industry, with a focus on constructing a flexible Real Estate Debt Model. This Real Estate Finance course follows on perfectly from our Real Estate Analyst and Real Estate Developer training courses. On this course delegates will... &bull; Learn how to build senior debt models with geared net cash flow. &bull; Explore and assess the influence of complex debt structures on returns. &bull; Develop advanced mezzanine debt models affecting project cash flows. &bull; Model joint venture structures for optimised partnerships. &bull; Calculate promote and profit share structures in Real Estate transactions. &bull; Construct sophisticated project cash flow models with mezzanine debts. Who will benefit from this course? &bull; Real Estate Professionals who have had exposure to Real Estate financial models &bull; Mid to Senior level Real Estate Analysts looking to develop their financial modelling skills in development, portfolio analysis &bull; Real Estate Developers &bull; Financial Analysts &bull; Investment Managers &bull; Banking and Finance Professionals in Real Estate Course Outline &bull; Mathematics of amortisation and debt finance. &bull; Basic senior debt models and geared net cash flow. &bull; Debt Cash Flow metrics: LTV, IRR and Interest Rate Dynamics. &bull; Mezzanine debt modelling. &bull; Joint Venture structures between developers and lender/equity partners. &bull; Promote and profit share structure calculations. &bull; Advanced project cash flows with mezzanine debt. 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;">A Bayfield Training Certificate</li><li value="2" 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 Finance 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 Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.
This is another One-Day course that is intended for the most ambitious modellers in the property industry, with a focus on constructing a flexible Real Estate Debt Model. This Real Estate Finance course follows on perfectly from our Real Estate Analyst and Real Estate Developer training courses.

On this course delegates will...
• Learn how to build senior debt models with geared net cash flow.
• Explore and assess the influence of complex debt structures on returns.
• Develop advanced mezzanine debt models affecting project cash flows.
• Model joint venture structures for optimised partnerships.
• Calculate promote and profit share structures in Real Estate transactions.
• Construct sophisticated project cash flow models with mezzanine debts.

Who will benefit from this course?
• Real Estate Professionals who have had exposure to Real Estate financial models
• Mid to Senior level Real Estate Analysts looking to develop their financial modelling skills in development, portfolio analysis
• Real Estate Developers
• Financial Analysts
• Investment Managers
• Banking and Finance Professionals in Real Estate

Course Outline
• Mathematics of amortisation and debt finance.
• Basic senior debt models and geared net cash flow.
• Debt Cash Flow metrics: LTV, IRR and Interest Rate Dynamics.
• Mezzanine debt modelling.
• Joint Venture structures between developers and lender/equity partners.
• Promote and profit share structure calculations.
• Advanced project cash flows with mezzanine debt.


Included in the Course
A Bayfield Training Certificate
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 Finance 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

Financial Modelling & Analysis

Real Estate Finance

Financial Modelling

Financial Analysis

Professional Development

Continuous Professional Development (CPD)

This Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.

Real Estate Finance (Debt Financing)

Swansea

ONLINE STUDY + ONE DAY ZOOM SESSION
NO CLASSROOM ATTENDANCE REQUIRED


Awarding Body: Dual Accreditation - Open College Network (OCN Credit4Learning) & The CPD Certification Service (21 CPD Points)
 
Award Level: UK - Level Three (Advanced) + 21 CPD Points
Ireland Level Five (Advanced) + 21 CPD Points
 
Minimum Age: 18 (16 with parental consent)
 
Entry requirements: None. English Level 2 desirable
 
Training Locations: Study online + virtual classroom.
 
Practical Training: Includes FREE Practise@Home Phlebotomy Training Kit worth £79.99
This comprehensive 76 piece practical training kit includes mini-arm trainer, sharps container and all medical grade supplies needed as well as a step-by-step 30 minute training video.



PART 1 (THEORY) - STUDY AT HOME ONLINE :
Complete your theory training online in the comfort of your own home or at work. Stop/start when it suits you and complete the online modules at your own pace. Can be completed on multiple devices such as laptop, smart-phone, desktop computer, kindle, tablet etc.
 
PART 2 (PRACTICAL SESSIONS) - JOIN US FOR A COMPREHENSIVE ONE DAY ZOOM SESSION:
Full instructions will be provided. We will send you a completely free Practise@Home Phlebotomy Training Kit, including a mini-arm trainer, for you to keep. You will follow your tutor's on-screen instructions during your Zoom virtual classroom sessions as you learn and develop your phlebotomy skills. The procedures and practices taught online are exactly the same as you would learn in the classroom. At any time before or after your course you can watch our 30 minute step-by-step video to refresh your knowledge and continue to use your training kit to practice your skills.
 
(THIS COURSE AWARDS THE SAME NATIONALLY RECOGNISED AND DUALLY ACCREDITED QUALIFICATION AS OUR CLASSROOM AND HYBRID COURSE VERSIONS)


Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.


COURSE ITINERARY

 
A dually-accredited hybrid modular venepuncture course awarding an
OCN Accredited Level Three Certificate (3 credits) & 21 CPD Points


Nationally Recognised Qualification


Part 1 - online (eLearning) Part 2 - Virtual Classroom (1 Day Zoom)


PRE-COURSE
Home study pack - download and complete before the virtual classroom sessions

PART 1 - ONLINE
M01: Course Overview
M02: History, Definitions and Roles
M03: Work-flow cycles
M04: Professionalism
M05: Health & Safety
M06: Blood Collection Systems
M07: Anatomy & Physiology
M08: Blood Composition
M09: Using the equipment
M10: Performing the venepuncture - see Classroom Part 2
M11: Lab Tests and Bottle Types
M12: Analytical Errors
M13: Informal Quiz – answers
M14: Award – accredited certificates, value, application and overview. Job Opportunities.


PART 2 - VIRTUAL CLASSROOM (ONE DAY ZOOM SESSION)
M01: Introduction: Welcome, Introductions and Overview.
M10: Performing the venepuncture (theory overview)
P01: Practical Session 1 – Equipment familiarisation - "Tools of the Trade"
P02A: Practical Session 2A – Unpacking your training kit
P02B: Practical Session 2B - A look at the mini-arm trainer and associated equipment
P03: Practical Session 3 – Using the tourniquet and identifying a vein
P04: Practical Session 4 – Handling and assembling the equipment. Familiarisation and procedures including initial skill-set development
P05: Practical Session 5 - Further skill-set development and consolidation. Discussing needle types including winged infusion sets (butterfly needles)
P06A: Practical Session 6A – Performing the venepuncture on the mini-arm trainer. Palpating the vein, performing the venepuncture. Sample handling and labelling.
P06B: Practical Session 6B – Consolidating pre- and post-venepuncture procedures.
 
Additional support material can be downloaded as you progress through the course online.





ZOOM SESSION

VIRTUAL CLASSROOM (ZOOM) SESSIONS 
Our Virtual Classroom training course consists of online study (Part 1 - theory) and Virtual Classroom Zoom sessions (Part 2 - practical skill-set development)
You must complete your Part 1 online study before joining us for your Zoom session(s).
Once you have enrolled on this course you will be sent a free Practise@Home Training Kit, This is yours to keep and can be reused any many time as you wish after you have completed the course.
Your Booking Confirmation will include your Zoom log-in details.



Geopace Training

Allied Health

Allied Health Professions (AHP)

Blood Taking

Healthcare Workers

Venepuncture

Phlebotomist

Phlebotomy

Accredited Phlebotomy

Healthcare

Learn how to take blood ... train as a Phlebotomist

    Nationally Recognised Qualification

    No previous experience or qualifications needed

    OCN Accredited - Level 3 (advanced)

    CPD Accredited (The CPD Certification Service)

    Covers all steps up to live blood draw

    Practise on artificial arm and fake blood!

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


Introduction to Phlebotomy Course (GPT003VC) - 1 DAY Virtual Classroom



The Real Estate Investment School is a four day course, that unravels the complexity of Investment Cash Flows through Advanced Modelling, Interpretation and Theory.
With a strong emphasis on practical application, you will gain a profound understanding of the complexities involved in analysing investment cash flows and interpreting their implications for effective decision-making.
Upon completion of the course, you will have the expertise to confidently model investment cash flows to a proficient level, empowering you to make informed financial decisions and drive positive outcomes for your investments.


The Investment focused school combines three of our courses:
Real Estate Analyst
Real Estate Modelling Masterclass
Understanding Key Principles of Real Estate Financial Modelling


On this course you will…
Construct Investment Financial Models starting from foundational principles
Learn how to value an appraise property investments.
Gain a comprehensive understanding of modelling tenancy schedules, including lease structures, rental income projections, lease expiry analysis, and lease renewal
Develop proficiency in creating robust models.
Understand how the application and use structure finance products in Real Estate
Learn advanced modelling techniques to analyse underlying asset risk
Appreciate the importance of data in investment cash flow modelling.
Gain a deep comprehension of the interrelationship between the metrics used in investment cash flow modelling


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


Day Four
Understanding Key Principles of Real Estate Financial Modelling
Real Estate Financial Modelling Mathematics
Time Value of Money
Net Present Value (NPV)
Internal Rare of Return (IRR)
Growth
What Discount Rate?
Certainty of a cash flow
Liquidity


Price, Value & Worth
Comparing Price, Value and Worth
Conventional Valuation Methods
Term and Reversion, Layer Method
Property Yields and Capitalisation Method
Exit calculations across Europe


Discounting Cash Flow Models
Investment Appraisal Models
Cash flow inputs: Rents, Yields, Growth Rates, Target Returns
Cash-on-Cash and Equity Multiple
Discount Rates & Exit Cap Rate
Operating Assumptions
Adding borrowing and analysing geared returns


Model Interpretation and Analysis
Sensitivity analysis and scenario analysis
Growth and inflation
Performance measures
Contemporary issues for analysis (such as the rise in interest rates


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 Investment 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

Property Investment

Microsoft Excel

The Real Estate Investment School is a four day course, that unravels the complexity of Investment Cash Flows through Advanced Modelling, Interpretation and Theory.

Real Estate Investment School (Investment Cash Flow Modelling)

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

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

<div id="course-pills-1">Duration4 Days24 CPD hoursThis course is intended forThis course is intended for both novice and experienced SharePoint users who wish to make full use of SharePoint Online.Overview#NAME?This course delivers the complete site owner story from start to finish in an engaging and practical way to ensure you have the confidence to plan and create new sites or manage your existing sites in SharePoint Online. Your goal is to learn how to make SharePoint online relevant to your team by using a sites functionality to help you share information and collaborate with your colleagues. During the class, you will also learn best practices and ?what not to do? as you watch live, interactive demonstrations and put theory into practice with hands on exercises in SharePoint Online.</div><div id="course-pills-2"><h3>1 - An Introduction to SharePoint Online</h3> <ul> <li>Introducing Office 365 and SharePoint</li> <li>Getting started with Office 365</li> <li>The cloud revolution</li> <li>Login to Office 365</li> <li>What is Office 365</li> <li>Using the app launcher</li> <li>What is SharePoint</li> <li>Office 365 settings</li> <li>Introducing Office 365 Groups</li> <li>Delve</li> <li>Ownership and Access</li> <li>OneDrive</li> </ul> <h3>2 - Creating Sites</h3> <ul> <li>Planning your sites</li> <li>Create new subsites</li> <li>The Office 365 tenant</li> <li>Site templates</li> <li>Web addresses</li> <li>Apply a them</li> <li>Site collections</li> <li>Building your navigation</li> <li>Create a new site</li> <li>Delete subsites</li> <li>Team site navigation</li> <li>User interface: classic vs modern</li> <li>Site contents: classic vs modern</li> <li>Where does classic come from?</li> </ul> <h3>3 - Creating and Managing Web Pages</h3> <ul> <li>The types of pages found in SharePoint</li> <li>Classic SharePoint pages</li> <li>Modern SharePoint pages</li> <li>How to use classic team site pages</li> <li>Create news and site pages</li> <li>Review features of publishing sites</li> <li>Web parts</li> <li>Save, publish, share and delete pages</li> <li>Communication sites</li> </ul> <h3>4 - Working with Apps</h3> <ul> <li>An introduction to apps</li> <li>Co-authoring</li> <li>Marketplace apps</li> <li>Check In ? Out</li> <li>Adding apps to a site</li> <li>Edit and view file properties</li> <li>Create and manage columns</li> <li>Quick edit view</li> <li>Public and personal views</li> <li>File commands</li> <li>Managing app settings</li> <li>Copy link and Share</li> <li>Content approval</li> <li>Folders</li> <li>Major and minor versioning</li> <li>The recycle bin</li> <li>Document sets</li> <li>Alerts</li> <li>Working with files in a library</li> <li>OneDrive sync</li> <li>Create, Upload and edit files</li> <li>Working with classic lists</li> </ul> <h3>5 - Building processes with Flow and PowerApps</h3> <ul> <li>What are business processes?</li> <li>Design and publish a Flow</li> <li>Classic tools for designing processes</li> <li>Getting started with PowerApps in SharePoint</li> <li>Design and test a classic workflow</li> <li>Enhance data capture with PowerApps</li> <li>Getting started with Flow in SharePoint</li> <li>Test a Flow and PowerApps enriched list</li> </ul> <h3>6 - Customizing Security</h3> <ul> <li>Office 365 Group access</li> <li>Share a file</li> <li>Updating Office 365 Group Security</li> <li>Remove a user</li> <li>Managing access to SharePoint</li> <li>Customizing SharePoint security</li> <li>New sites private vs public</li> <li>Create permission levels and groups</li> <li>Setup access requests</li> <li>Security inheritance</li> <li>Share a site</li> <li>Security best practices</li> </ul> <h3>7 - Working with Search</h3> <ul> <li>Delve</li> <li>Search tips</li> <li>An introduction to SharePoint search</li> <li>Accessing classic search</li> <li>Search in folders, libraries and sites</li> <li>Promoted results</li> <li>Search results</li> </ul> <h3>8 - Enterprise Content Management</h3> <ul> <li>Managed metadata service</li> <li>Information management policies</li> <li>An introduction to content types</li> <li>The records center</li> <li>Create and manage content type</li> <li>In-place records management</li> <li>Deploy content types</li> <li>The content organizer</li> <li>Using content types in apps</li> <li>Durable links</li> <li>The content type hub</li> </ul></div>

Nexus Human

Online Course Creation

Microsoft Power Apps

Microsoft Sharepoint

Power Apps

Microsoft Power Platform

SharePoint

55215 SharePoint Online Power User

Tom Reynolds

Product Management

Agile

Agile PM

Productivity

Kanban

Agile Coach

Attend our world class Kanban University accredited Certified Kanban System Design training course and learn to implement Kanban in your company

Certified Kanban System Design – KMP I - 24-26 September

Standard

Early Bird

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

Real Estate Modelling Masterclass (Advanced Cash Flow Modelling)

Reading

Nottingham

Dickson Training Ltd

ILM Level 3 Award in Leadership and Management

Online Course

Classroom Course

Real Estate Investments are unique in that they generate both rental income and capital appreciation, making cash flow modelling an essential tool for Real Estate Investors, Lenders, and Analysts.On this course, we will use case studies to enhance the delegates understanding of Real Estate financial appraisals, and help them fully appreciate the theory behind the numbers. We will cover topics such as discounting, compounding, forecasting rental income and expenses, calculating net operating income (NOI), factoring in capital expenditures, modelling debt service, and determining the internal rate of return (IRR).This course will provide you with a solid foundation for understanding and analysing real estate cash flows. On this course you will...<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;">Study the financial concepts of compounding, discounting and in-perpetuity</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Consider the importance of the timing and uncertainty of both fixed and growing income streams</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Contrast different property yield metrics</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Build-up risk premiums for discount rates, discuss the importance of liquidity, transparency and volatility</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Compare and contrast time and money-weighted measures of return</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn about valuation principles</li><li value="7" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Contrast value and worth</li><li value="8" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discuss the importance and sourcing of inputs and outputs</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;">Professional Real Estate Transaction Managers</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Asset Managers</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Portfolio Managers</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Recent graduates with exposure to real estate financial modelling</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">New employees with exposure to real estate financial modelling</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">People working in Argus, Anaplan or any commercial real estate software and would like to understand financial modelling key principles.</li></ul> Course Outline:MorningReal Estate Financial Mathematics<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;">Time Value of Money</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Net Present Value (NPV)</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Internal Rate of Return (IRR)</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Growth</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">What Discount Rate?</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Certainty of a cash flow</li><li value="7" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Liquidity</li></ul>Price, Value and Worth<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;">Comparing Price, Value and Worth</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Conventional Valuation Methods</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Term and Reversion, Layer Method</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Property Yields and Capitalisation Method</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Exit calculations across Europe</li></ul> AfternoonDiscounted Cash Flow Models<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;">Investment Appraisal Models</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Cash flow inputs: Rents, Yields, Growth Rates, Target Returns</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Cash-on-Cash and Equity Multiple</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discount Rates &amp; Exit Cap Rate</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Operating Assumptions</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Adding borrowing and analysing geared returns</li></ul>Model Interpretation and Analysis<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;">Sensitivity analysis and scenario analysis</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Growth and inflation</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Performance measures</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Contemporary issues for analysis (such as the rise in interest rates)</li></ul> Quizzes | Q&amp;A 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;">A Bayfield Training Certificate &amp; 7.5 CPD Hours</li><li value="2" style="font-size: 16px; box-sizing: border-box;" id="isPasted" 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 Understanding Key Principles of Real Estate Financial Modelling 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 Investments are unique in that they generate both rental income and capital appreciation, making cash flow modelling an essential tool for Real Estate Investors, Lenders, and Analysts.
On this course, we will use case studies to enhance the delegates understanding of Real Estate financial appraisals, and help them fully appreciate the theory behind the numbers. We will cover topics such as discounting, compounding, forecasting rental income and expenses, calculating net operating income (NOI), factoring in capital expenditures, modelling debt service, and determining the internal rate of return (IRR).
This course will provide you with a solid foundation for understanding and analysing real estate cash flows.


On this course you will...
Study the financial concepts of compounding, discounting and in-perpetuity
Consider the importance of the timing and uncertainty of both fixed and growing income streams
Contrast different property yield metrics
Build-up risk premiums for discount rates, discuss the importance of liquidity, transparency and volatility
Compare and contrast time and money-weighted measures of return
Learn about valuation principles
Contrast value and worth
Discuss the importance and sourcing of inputs and outputs


Who will benefit from this course?
Professional Real Estate Transaction Managers
Asset Managers
Portfolio Managers
Recent graduates with exposure to real estate financial modelling
New employees with exposure to real estate financial modelling
People working in Argus, Anaplan or any commercial real estate software and would like to understand financial modelling key principles.


Course Outline:
Morning
Real Estate Financial Mathematics
Time Value of Money
Net Present Value (NPV)
Internal Rate of Return (IRR)
Growth
What Discount Rate?
Certainty of a cash flow
Liquidity
Price, Value and Worth
Comparing Price, Value and Worth
Conventional Valuation Methods
Term and Reversion, Layer Method
Property Yields and Capitalisation Method
Exit calculations across Europe


Afternoon
Discounted Cash Flow Models
Investment Appraisal Models
Cash flow inputs: Rents, Yields, Growth Rates, Target Returns
Cash-on-Cash and Equity Multiple
Discount Rates & Exit Cap Rate
Operating Assumptions
Adding borrowing and analysing geared returns
Model Interpretation and Analysis
Sensitivity analysis and scenario analysis
Growth and inflation
Performance measures
Contemporary issues for analysis (such as the rise in interest rates)


Quizzes | Q&A


Included in the Course
A Bayfield Training Certificate & 7.5 CPD Hours
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 Understanding Key Principles of Real Estate Financial Modelling 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

Risk Management

Investment

Financial Risk Management

On this course, we will use case studies to enhance the delegates understanding of Real Estate financial appraisals, and help them fully appreciate the theory behind the numbers. 

Understanding Key Principles of Real Estate Modelling (Advanced Theoretical Course)



Bayfield Training and the University of Cambridge Department of Land Economy
This prestigious eight-week online Real Estate course is suitable for modellers new to Real Estate and experienced Real Estate Analysts looking to formalise their skill set. This course will equip you with skills to start building your own financial models and the certificate will give your employers and colleagues reassurance of your expertise.
If you want to enhance your financial modelling skills over an extended period, the Real Estate Financial Modelling Certificate is the course for you.
This online real estate course has been put together exclusively for the Real Estate Financial Modelling certificate, using state of the art digital resources such as animations, video-steps, digital whiteboard and video-interactions as well as the spreadsheets, text based resources and tutor contact you would expect from any of Bayfield Training’s classroom based courses.
 Assessment is in the form of a guided model build exercise and written model appraisal. Participants benefit from an additional months access to the course platform after submission of the assessment.


On this course you will:
Become a competent model builder, building Real Estate Financial Models from scratch
Learn tricks and concepts from financial modelling experts with decades of experience in practice and academia
Learn how to use Real Estate Financial Models to make informed investment decisions
Learn at a consistent pace over 8 weeks allowing you to take the time to fully grasp this important skill
This course is suitable for:
Chartered Surveyors
Asset Managers
Financial Controllers
Financial Analysts
Investment Managers
Property Managers
Real Estate Students/Recent Graduates
Course Outline:
Module 1 - Economic Context
Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models.
Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models.
Why Real Estate Asset Modelling is important
Understanding the occupier, asset and development markets and the relevant modelling approaches for each
Real Estate Sub-Sector Key Performance Indicators
Introduction to conventional valuations and financial mathematics
Understanding and minimising errors in Financial Models


Module 2 - Cash Flow Fundamentals
Constructing a financial model from first principles.
Understanding all the components of a basic cash flow model
Understand why Corporate Finance Models and Real Estate Models are different
Financial Model Design
Making the link between valuations, income mathematics and discounted cash flows
Internal Rate of Return, Net Present Value,Worth and other metrics
Features and techniques to aid fast model building


Module 3 - Developing the Cash Flow
Adapting financial models for different periodicities and building rent functions for different rent behaviour.
Understanding how leases vary with respect to rent over time: Rent Reviews, Break Clauses, Rent Free Periods, Lease Expiries etc.
Developing the concept of a Rent Function in Excel
Logic mathematics and Logic functions
Projecting rent to adapt to different lease contracts and growth patterns
Alternative solutions to Logic functions
Comparative analysis of lease structures in different jurisdictions and adapting financial models


Module 4 - Real Estate Data
Understanding the different sources of data, constructing basic time series models and recognising basic patterns.
Key Property market indicators
Characteristics and application of key input metrics for Real Estate Appraisals
Understanding the eight components of Real Estate Price Dynamics
Awareness of the different sources of data
Reading and using general property market reports
Constructing basic time series models and recognising basic patterns


Module 5 - Development Appraisals
Constructing a development appraisal from first principles and understanding development return metrics.
Understanding the key components of a development project
Understanding the difference between development and investment appraisals
Residual Appraisals and Profit Calculations
Cost orientated cash flows and phased sales
Cumulative construction cost patterns: incidental, fixed, loaded and S-curve
Development return metrics and Modified IRRs


Module 6 - Multi-let Cash Flows
Constructing an advanced multi-let cash flow model and learn different techniques to build flexible rent functions.
Multi-let and portfolio model design principles
Building complex date functions and date series
The three multi-let rent projection techniques
Perpendicular Rent Functions
Incorporate advanced rent adjustments into the Rent Function
Incorporate sector and period varying rental growth rates
Simplifying OPEX and CAPEX projections
Discounting techniques on complex and volatile cash flows


Module 7 - Project Finance
Constructing a flexible Real Estate Debt Finance model.
Revision of the Mathematics of amortisation and debt finance
Basic senior debt models and geared net cash flow
LTV, IRR and Interest Rate Dynamics
Flexible term, repayment options and deferred interest
Loan covenant tests
Understanding different tranches of debt
Understanding how complex debt structures impact the returns to different parties


Module 8 - Model Interpretation and Risk Analysis
Learn how to read, analyse and report on real estate financial models.
Understand how to read models and develop an investment narrative
Visualise model outputs using graph functions, conditional formatting, dynamic symbols and dashboards
Learn how to use built-in Sensitivity, Scenario Analysis tools and third-party add-ins
Learn how to construct varied project scenarios in a systematic way
Introduction to Monte Carlo Analysis and VBA
Optimising sale dates and other parameters
Create well written, attractive and persuasive reports


Included in the Course
Bayfield Training and University of Cambridge Accredited Certificate & LinkedIn Proficiency Badge
64 CPD Hours
1 Month Post-Course Access to the Digital Platform - 12 Months Post-Course Access to the Platform can be purchased for an additional fee
Course Files
Q&A Webinars and Guest Speaker Webinars
Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers


2024 Cohort Dates Include:
3rd June to 29th July
5th August to 25th September 2024
30th September to 25th November


For more information, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

159 Courses in Sheffield

Wireshark Certified Network Analyst

By Systems & Network Training

Network design

By Systems & Network Training

Definitive IP routing for engineers

By Systems & Network Training

LINX 2

By Systems & Network Training

Total H.248 for Engineers

By Systems & Network Training

LTE Architecture and Protocols

By Systems & Network Training

4G demystified

By Systems & Network Training

LTE airside

By Systems & Network Training

LTE backhaul

By Systems & Network Training

Definitive SIP for engineers

By Systems & Network Training

Search By Location