- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
University of Cambridge & Bayfield Training - Real Estate Financial Modelling Certificate (Online Self-Study)
(5)By Bayfield Training
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
Food Safety, Education and Social Care Training Courses What You Need To Know About Food Allergies CPD Accredited, Interactive Short Course 2 hr session Do you serve food, or have people with known allergies in your school or on your team? In this webinar we will explain what food allergies are, and why it is vital for you to understand, for the health and safety, and indeed life, of the person involved Course Contents: What is a food allergy The 14 Allergens The Immune System Consequences of Food Allergies The importance of good food hygiene Benefits of this Short Course: More than 20% of the population in industrialized countries suffer from food intolerance or food allergy About two million people live with a diagnosed food allergy in the UK, and 32 million in the US 600,000 people in the UK have coeliac disease This course will teach you the importance of ensuring food is safe to eat for all, without causing significant pain or even death
Preliminary Electronic Security Course
By Hi-Tech Training
The Preliminary Electronic Security Course is an introductory (or revision) course designed to provide participants who have no previous Electrical or Electronics experience with the background skills required to attend the CCTV Installation Course, Access Control Course or Fire Alarm Foundation Course. The course gives both an introduction to electronics and electronic security and shows how the two fields merge together. Ideal for a beginner wishing to learn more about this fascinating area. A large practical content is guaranteed. The day will be an excellent learning experience with a skilled instructor. It is a great introduction to the other courses we provide.
Course Introduction Covers B12 deficiency, pernicious anaemia, diagnosis, treatment and management. It also covers signs and symptoms. Please note: this course is for health care professionals or those working in Primary Care. It is not open to Beauticians unless you are a registered healthcare professional. If in doubt- please email annie at training@anniebarr.com or phone +44 7500048222 About this event Course Introduction This course concentrates on B12 deficiency, symptoms, treatments and management. The course covers B12 deficiency, pernicious anaemia, diagnosis, treatment and management. It also covers signs and symptoms of pernicious anaemia. This course is interactive and we include case studies and discuss issues regarding diagnostic testing. We review inclusion and exclusion criteria and identification of appropriate clients. Delegates will get the opportunity to review practice with hands on practical demonstrations of how to give injections correctly. We will cover administration techniques, where to give the injections and record keeping / documentation. We will discuss role and responsibilities and contraindications and precautions. The delegates will leave this course with an example of an individual protocol of Patient Specific Direction (PSD) and a competence based framework document to be used in practice. This course is very interactive. AIMS AND OBJECTIVES Understand the need for accountability and responsibility in relation to role development Demonstrate an understanding of safe practice Describe the signs and symptoms of pernicious anaemia Describe pernicious anaemia and its impact on patients Fully understand the principles, and practice B12 deficiency and B12 injections Understand the importance of safety issues related to giving injections Understand the law relating to role and function of the HCA and prescribing. Describe why patients require B12 injectionsBe able to correctly identify anatomical sites for injectionsDemonstrate correct administration techniquesDemonstrate how to correctly dispose of wasteDemonstrate correct infection control procedures and use of PPEDescribe when patients require referral and understand the importance of referral using correct clinical pathwaysDemonstrate an understanding of anaphylaxis and emergency proceduresUnderstand the need for correct prescribing proceduresBe able to document consultations following your organisations procedures COURSE CONTENTS Role and responsibilities Accountability guidelines and requirements Pernicious anaemia Blood- function B12 Deficiency Risk factors/groups Causes of B12 deficiency Diagnosis and reference ranges, testing Protocols and guidelines Factors affecting B12 diagnosis and treatment Factors affecting absorption B12 injections and common side effects Could it be B12 Deficiency Supplements Side effects and management including ADR’s Contraindications and Precautions Correct Administration and techniques including practical session Injection sites Legal Issues including consent Prescribing and Patient Specific Directions What to record Storage Disposal of injections/waste Infection control Needle stick injuries Competence and supervised practice Policies and procedures Facts and Figures Setting up and running a clinic Insurance/indemnity Research/evidence base and resources Please note Anaphylaxis is not covered on this course, however we do run a separate Anaphylaxis 1hr training course, which takes place at the end of this B12 webinar. If you wish to do the 1 hr Anaphylaxis also, you should book onto BOTH courses. WHO SHOULD ATTEND? HCAs Nurses Doctors Pharmacists Anyone interested in Vitamin B12 deficiency and pernicious anaemia and those working with clients with B12 deficiency AB Health Group awards CPD points / certificate of attendance for each course. If you would prefer an accredited certificate by our accrediting body Aim Qualifications we can organise this. The charge for the certificate including postage is £30.
One day foundation course in sexual health for staff who want to deliver the C Card in North Wales. This course is for staff who are not currently trained to deliver the C Card. We are also holding refresher courses for staff already trained - contact us for more details. We will cover: What is C Card? What needs to be in place for C Card providers to deliver the scheme What stock and support we provide The law and sex including Fraser Guidelines Key sexual health issues, including contraception and STI's Condoms, lube, dams, etc Inclusive practice How to use the online admin system - QES If you have any questions please get in touch with us at ccard@sexeducationcompany.org
