Name: Voice over LTE
Price: 2367 GBP
Availability: InStock

Redhill

<h3><b>MPEG training course description</b></h3>
        <p> This course studies the MPEG standards for video and
audio compression. A major focus is on MPEG-4 and
MPEG-TS. Hands on includes decoding and analysing
MPEG streams.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
          <li>Recognise the main MPEG standards.</li>
											<li>Describe the techniques used in MPEG video
and audio compression.</li>
											<li>Compare MPEG2m MPEG4 and MPEG-H.</li>
           <li>Describe the MPEG-TS.</li>
											<li>Analyse MPEG streams.</li>
                  </ul>
       
        <h5>
        <b>MPEG training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone working with MPEG. </p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>None.</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>MPEG training course contents</b></h3>
      <ul>
				<li>Introduction</li><p>
What is MPEG? MPEG and VCEG, MPEG 1,
MPEG 2, MPEG-3, MPEG-4, MPEG-H, others,
codecs and containers, licensing and patents,
parts and layers (System, Video, Audio, others).
</p><li>MPEG2</li><p>
DVD, DVB, characteristics, MPEG2 Part2, audio
MPEG2 Part 7 (AAC).
</p><li>MPEG tools</li><p>
Wireshark, vlc, analysers, decoders, ffmpeg,
wowzer.
</p><li>MPEG2 Video compression</li><p>
Sampling, bit rates, resolution. Inter and Intra
frame coding, I, B, P frames, GOP, slices,
blocks, macroblocks. Motion estimation. 
				<br /><span>Hands on</span> Analysing MPEG frames.
</p><li>MPEG4</li><p>
Profiles and levels, Enhancements, Parts 1,2,3,
Part 10 and AVC, Part 14 and mp4.
Performance versus MPEG2.
</p><li>MPEG audio</li><p>
Coding, frequencies, bit rates.
</p><li>MPEG-TS</li><p>
PES, Transport Streams, TS elements, packets,
PID, Programs, PSI, PAT, PMT, synchronisation,
PCR, PTS.
</p><li>MPEG-H Part 2</li><p>
HEVC, benefits, improvements.
	</p><li>Video codecs</li><p>
What is a CODEC, pictures and audio,
digitisation, sampling, quantisation, encoding,
compressing. </p>
      </ul>

Systems & Network Training

Network & Security

Network Engineer

Total MPEG for engineers

General Admission

<h3><b>LTE Backhaul training course description</b></h3>
      <p> 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.</p>
        
				<h5><b>What will you learn</b></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>
        <b>LTE Backhaul training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone working with LTE.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Mobile communications demystified
							</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>LTE Backhaul training course contents</b></h3>
      <ul>
				<li>Introduction </li><p>
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.

</p><li>Architecture of the radio access network </li><p>
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.

</p><li>Transport of data and signalling in LTE </li><p>
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).

</p><li>The S1 application protocol </li><p>
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.

</p><li>The X2 application protocol </li><p>
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.

</p><li>High level system operation </li><p>
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.</p>
      </ul>

LTE backhaul

<h3><b>LTE Architecture and Protocols course description</b></h3>
      <p> This course provides a comprehensive tour of the LTE
architecture along with services provided and the
protocols used.</p>
        
				<h5><b>What will you learn</b></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>
        <b>LTE Architecture and Protocols course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone working with LTE.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Mobile communications demystified
							</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>LTE Architecture and Protocols course contents</b></h3>
      <ul>
				<li>Introduction </li><p>
History, LTE key features. The 4G ITU process. The LTE 3GPP specifications. Specifications.

</p><li>System Architecture </li><p>
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.

</p><li>Radio transmission and reception </li><p>
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.

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

</p><li>Security in LTE networks </li><p>
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.

</p><li>Mobility management </li><p>
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.

</p><li>QoS, policy control and charging </li><p>
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.

</p><li>Delivery of voice and text messages over LTE </li><p>
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.

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

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

</p><li>OAM and self organising networks </li><p>
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.</p>
      </ul>

LTE Architecture and Protocols

<h3><b>Voice over LTE training course description</b></h3>
      <p> This course provides a basic understanding of the 3G
LTE Air Interface, SAE, as well as Voice over LTE
options and LTE Advanced features. Investigating the
standards for the EPS , formulated by the 3GPP
standards body, the course will set out to examine and
explain the 4G environment from user equipment to
border gateway and beyond. This course will ensure
the delegate has a grasp of all aspects of the current
global deployments, the next steps in upgrades and the
promise of things to come.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
			
                <li>Describe the complete EPC architecture.</li>
																				<li>Explain the use of QoS within the air interface &amp;
core network.</li>
                    <li>Explore the features of LTE advanced.</li>
                    <li>Describe the various methods of supporting voice
services with 3G LTE.</li> 
                    
                    <li>Describe IMS structure and control entities.</li>
																				<li>Explain an IMS session.</li>
                  </ul>
        <h5>
        <b>Voice over LTE training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Any engineers who are assisting in the deployment of
voice services within their LTE networks.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Intro to Data comms &amp; networking<br />
								Telecommunications Introduction
							</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Voice over LTE training course contents</b></h3>
      <ul>
				<li>3GPP standards body </li><p>
Release 8 - Release 12, Supported and expected features.

</p><li>The EPC revisited </li><p>
EPC revisited 3G LTE &amp; EPC Architecture, NB, MME, SGW, PDNGW, PCRF, Interworking capabilities, Protocol stack explored, NAS signalling, Default EPS bearer, Slot allocation algorithms, Scheduling algorithms, Quality of Service requirements, Dedicated EPS bearers.

</p><li>VoLTE deployment strategies </li><p>
Common networks everywhere, GSM/WCDMA view, CDMA view.

</p><li>VoLTE system architecture </li><p>
LTE radio, LTE Radio background, LTE radio architecture, Evolved packet core, EPC entities &amp; functions, EPS mobility management, MS entities, Home subscriber server, Policy &amp; charging rules function.

</p><li>VoLTE functionality </li><p>
Radio functionality, Bearers &amp; schedulers, Mobility, Circuit switched fall back handover, Mobility from 2G/3G back to LTE, Power Saving Features, Positioning services, UE radio access capabilities for VoLTE users.
EPC functionalities, LTE subscriber identification, PDN connectivity establishment, EPS dedicated bearer setup, IMS identification, IP multimedia identification module, Public user identity, Private user identity, Relationship between public &amp; private identity, identification of users device, identification of network entities, identification of services, identification without ISIM.
IMS service provisioning, Enforcement of allowed services, Service triggering information, Selection of the AS, AS behaviour, Service provisioning in action.

</p><li>VoLTE end-to-end &amp; signalling </li><p>
VoLTE subscription &amp; device configuration.
EPS attach for CSFB/IMS VoIP &amp; default bearer.
IMS registration, Constructing the REGISTER request, From UE to P-CSCF, From P-CSCF to I-CSCF, From I-CSCF to S-CSCF, S-CSCF challenges the UE, UE's response to the challenge, Registration at the S-CSCF, The 200 OK response, Third-party registration to application servers, Subscription to registration event package, Re-registration &amp; re-authentication, De-registration, Related standards.
IMS VoIP session, Constructing the INVITE request, Routing, Media negotiation, Media resource reservation &amp; policy control, Charging, Session release.
Voice continuity, PS - PS intersystem handover, Single radio voice call continuity.
IMS emergency session, PDN Connection setup for emergency session, Emergency registration, Emergency session.
CS fallback for EPS call case, Architecture of CS fallback in EPS, Description of SGs interface, Idle mode signalling reduction, Idle mode vs active mode, CS fallback attachment, Mobile originating call using CSFB, Mobile terminating call using CSFB, Call unrelated CSFB procedures, Mobile terminating roaming retry &amp; forwarding.
VoLTE Messaging, Native IMS messages, SMS interworking, Multimedia messaging service.
Unstructured supplementary services data simulation in IMS.

</p><li>IMS services </li><p>
VoLTE radio performance
Coverage, Latency, Capacity.

</p><li>LTE advanced features </li><p>
Carrier aggregation, Coordinated mMulti-point Operation (CoMP), ICIC &amp; eICIC, Relay node deployment &amp; donor eNBs, Improved cell edge coverage, Reduced control plane latency, Heterogeneous networks, HeNB, security gateways, HeNB gateways.</p>
      </ul>

Voice over LTE

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The course on Covid-19 risk management for workers returning to work is a timely resource that aligns with the latest guidelines from the UK government and the NHS. As of the most recent updates, healthcare staff who exhibit symptoms of a respiratory infection are no longer required to test for Covid-19, and those who test positive are advised to return to work in accordance with locally decided protocols. Moreover, essential frontline staff may return to work following a negative PCR test if they have been in contact with Covid-19, provided they adhere to subsequent negative daily LFD tests for a minimum of 7 days and comply with appropriate use of PPE and other infection prevention and control measures. These guidelines reflect a shift towards managing Covid-19 alongside other respiratory infections, with an emphasis on local risk assessments and the balance of risks between staff absence and potential patient safety impacts. The course content should be updated regularly to reflect these evolving guidelines, ensuring that both employers and employees are equipped with the knowledge to navigate the challenges of returning to work during the ongoing pandemic.</p>

The course on Covid-19 risk management for workers returning to work is a timely resource that aligns with the latest guidelines from the UK government and the NHS. As of the most recent updates, healthcare staff who exhibit symptoms of a respiratory infection are no longer required to test for Covid-19, and those who test positive are advised to return to work in accordance with locally decided protocols. Moreover, essential frontline staff may return to work following a negative PCR test if they have been in contact with Covid-19, provided they adhere to subsequent negative daily LFD tests for a minimum of 7 days and comply with appropriate use of PPE and other infection prevention and control measures. These guidelines reflect a shift towards managing Covid-19 alongside other respiratory infections, with an emphasis on local risk assessments and the balance of risks between staff absence and potential patient safety impacts. The course content should be updated regularly to reflect these evolving guidelines, ensuring that both employers and employees are equipped with the knowledge to navigate the challenges of returning to work during the ongoing pandemic.

Twig Services Ltd

Infection Prevention & Control

Occupational Health & Wellbeing

Health & Safety At Work

COVID-19 for Safer Work Environments Approved Online Training

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Real Estate Development cash flows require greater skill and flexibility from Analysts, and an ability to work with simultaneously with project partners. Value add and opportunistic property investments are complex both in their initial scope and their cash flow projections.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course will show delegates how to appraise projects in Excel, incorporate and communicate updates as they happen and ultimately understand how to convert an opportunistic property investment into a core asset that can be sold on.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Residual models (profit &amp; site) are demonstrated first to illustrate the main components of any scheme and the traditional methods of evaluation such as profit on cost ratio, rental yield and interest cover. Development cash flows are then constructed in detail looking in particular at phased income as well as fixed, variable and incidental construction costs and their impact on the net cash flow. Additional performance metrics are calculated including geared IRR and return on equity.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Development financing can be trickier than straightforward senior debt investment financing. This is because finance is often required in stages. The brought forward carried forward method demonstrated on the course, is the easiest way to deal with programmed debt drawdown functions and rolled-up interest.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The assessment of project specific risk is arguably much more important in development schemes. Sensitivity analysis and scenario analysis are covered in the final section of the course.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course you will&hellip;</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Learn how to calculate land and profit residuals</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Learn how to structure a full development cash flow, including phased sales, S-curve and straight line cost functions</li><li value="3" fr-original-style="" style="box-sizing: border-box;">You will be taught how to find maximum bidding prices for site development and building refurbishments</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Understanding development financing considerations and learn how to optimise financing</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analyse financial and project completion risks</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Employ best practice and find solutions to common modelling problems</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Developers</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;">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Fund 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;">Land managers</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Planning managers</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Lenders</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day One</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learn how to build a discounted cash flow, analyse returns and understand the components of development models</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Gross versus Net Yields, calculating Net Development Value (NDV)</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Profit residual, with and without financing</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Site residual, how to calculate profit without knowing your costs.</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Introducing financing to site residual calculations</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Purchase price and acquisition costs</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Phased Sales, marketing and disposal costs</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Modelling construction costs using straight line basis, fixed costs, variable costs, incidental costs and construction fees</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Professional fees</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Income and expenditure project functions</li><li value="10" fr-original-style="" style="box-sizing: border-box;">Logic functions, logic tables and array formulae</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Two</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learn how to build a detailed property development project cash flow, add financing and perform risk analysis on commercial development projects</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Multiple IRRs, competing projects, scoping and linear programming, maximising performance</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Return metrics: Equity profit ratio (EPR), Costs paid out of proceeds (POP), Profit on cost ratio (PCR)</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Alternative site calculation, Net present value (NPV),</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Modelling construction costs using S-curve , variable costs, incidental costs and construction fees</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Switching between scenarios</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Introduction to Development financing, Pari Passu versus Equity First Financing</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Debt scheduling: brought forward and carried forward method</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Consideration of the impact of development finance interest, fees and covenants</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></p><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" 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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Developer such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <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></p>



Real Estate Development cash flows require greater skill and flexibility from Analysts, and an ability to work with simultaneously with project partners. Value add and opportunistic property investments are complex both in their initial scope and their cash flow projections.
This course will show delegates how to appraise projects in Excel, incorporate and communicate updates as they happen and ultimately understand how to convert an opportunistic property investment into a core asset that can be sold on.
Residual models (profit & site) are demonstrated first to illustrate the main components of any scheme and the traditional methods of evaluation such as profit on cost ratio, rental yield and interest cover. Development cash flows are then constructed in detail looking in particular at phased income as well as fixed, variable and incidental construction costs and their impact on the net cash flow. Additional performance metrics are calculated including geared IRR and return on equity.
Development financing can be trickier than straightforward senior debt investment financing. This is because finance is often required in stages. The brought forward carried forward method demonstrated on the course, is the easiest way to deal with programmed debt drawdown functions and rolled-up interest.
The assessment of project specific risk is arguably much more important in development schemes. Sensitivity analysis and scenario analysis are covered in the final section of the course.


On this course you will…
Learn how to calculate land and profit residuals
Learn how to structure a full development cash flow, including phased sales, S-curve and straight line cost functions
You will be taught how to find maximum bidding prices for site development and building refurbishments
Understanding development financing considerations and learn how to optimise financing
Analyse financial and project completion risks
Employ best practice and find solutions to common modelling problems


Who will benefit from this course?
Developers
Surveyors
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Fund managers
Asset managers
Land managers
Planning managers
Lenders


Course Outline
Day One
Learn how to build a discounted cash flow, analyse returns and understand the components of development models
Gross versus Net Yields, calculating Net Development Value (NDV)
Profit residual, with and without financing
Site residual, how to calculate profit without knowing your costs.
Introducing financing to site residual calculations
Purchase price and acquisition costs
Phased Sales, marketing and disposal costs
Modelling construction costs using straight line basis, fixed costs, variable costs, incidental costs and construction fees
Professional fees
Income and expenditure project functions
Logic functions, logic tables and array formulae


Day Two
Learn how to build a detailed property development project cash flow, add financing and perform risk analysis on commercial development projects
Multiple IRRs, competing projects, scoping and linear programming, maximising performance
Return metrics: Equity profit ratio (EPR), Costs paid out of proceeds (POP), Profit on cost ratio (PCR)
Alternative site calculation, Net present value (NPV),
Modelling construction costs using S-curve , variable costs, incidental costs and construction fees
Switching between scenarios
Introduction to Development financing, Pari Passu versus Equity First Financing
Debt scheduling: brought forward and carried forward method
Consideration of the impact of development finance interest, fees and covenants


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

Microsoft Excel

Financial Risk Management

Professional Development

Continuous Professional Development (CPD)

This course will show delegates how to appraise projects in Excel, incorporate and communicate updates as they happen and ultimately understand how to convert an opportunistic property investment into a core asset that can be sold on.

4 PCR courses in Glasgow

Total MPEG for engineers

By Systems & Network Training

LTE backhaul

By Systems & Network Training

LTE Architecture and Protocols

By Systems & Network Training

Voice over LTE

By Systems & Network Training

Online Options

COVID-19 for Safer Work Environments Approved Online Training

By Twig Services Ltd

Real Estate Developer (Development Cash Flow Modelling in Excel)

By Bayfield Training

Search By Location