304 Courses

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

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

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

Understanding property investment cash flows in all its complexity by type of investment and by purpose -------------------------------------------------------------------------------- ABOUT WHO COULD BENEFIT? This senior practitioner-led on-line course is aimed at c-suite/senior managers but is also suitable for junior staff keen to understand how cash flows get used higher up within the company or the various forms that cash flows can take, or service / database / software providers. Only £875+VAT pp on a public course. In this face-to-face course we drill down to all types of cash flows across the real estate spectrum and within the different levels within companies and by asset type. We help you get to grips with reality, and help you focus on the most important cash flow aspects across the property industry. Do you work as: * Board and Investment Committee Members, Managers and Team Leaders dealing in multi-asset classes as investor or manager to obtain a sound, comprehensive overview of the relevance and importance of understanding cash flow uses * Analysts and Associates in particular working in multi-disciplinary real estate teams engaged in investment, lending, asset management and development * Data, system and service providers keen to understand the various forms and uses of cash flows and its inputs across the property industry -------------------------------------------------------------------------------- MODULES DEEPER UNDERSTANDING OF RE CASH FLOWS Property investment is driven by the promise of quality cash flow over time. It is essential to gain a better understanding of the various forms cash flow can take, as each asset type and asset structure is unique. Financial modelling courses only provide you the tools how to model, but fail to provide a deeper understanding why or what you model in real-life in all its complexities. This course provides you with insight, detailed knowledge and experience on the assumptions. Cash Flows in reality vary wildly in construction and complexity. There are many types of cash flows, suited to its specific circumstance and use, and get used in different ways in decision making. Only £875+VAT pp for this 1-day course! This senior-practitioner-led course is aimed at c-suite/senior managers but is also suitable for junior staff keen to understand how cash flows get used higher up within the company or the various forms that cash flows can take. This course, in brief, provides: – a comprehensive overview of how cash flows differ across property –  applicable to a range of real estate investment deal types and asset classes such as office, shopping centres, residential (PRS), warehouse-logistics and industrial. – context in which information derived from cash flows is used – the contribution of cash-flow outputs in decision-making – high-level detail of the inputs, assumptions and outputs – sound understanding of how cash flow models enable analysis of financial statements, appraisals & risk sensitivities – highlights good practice for cash flow model structure set-up and controls, – highlights key metrics, terminology, etc Detailed course manual provided on the day. This course is taught by dedicated, friendly and seasoned practitioner Kaushik Shah Press ‘see content’ below to see detailed content. Next Date Available: Thursday 20 June 2024 | Location: On-line or C. London as desired IN-HOUSE COURSE “DEEPER UNDERSTANDING OF RE CASH FLOWS” In-house tailor-made course written and presented by senior property practitioners. In one engaging they will be providing you with a deeper understanding of the inputs, drivers and outputs of real estate cash flows – how do they differ, why, and how are they used? In the end it is (the promise of future) cash flows that drive real estate value. Only £3,850/day + VAT for this is an essential knowledge course to help you understand property in all its complexity. Next Date Available: in-house dates available upon request -------------------------------------------------------------------------------- PRICING FIND THE BEST PRICE.   Property Overview offers competitively priced training courses with unique practitioner-led content. Applied, relevant content in this retail property course leads to greater impact and value-for-money. Pricing below is shown for public courses for individual bookings, and for in-house courses. To book one or several individual places please fill in the booking form, or email kaushik@propertyoverview.co.uk For bookings of 4 or more staff an on-line in-house course is recommended, also as the content can be tailored around your needs and your products or services. -------------------------------------------------------------------------------- DEEPER UNDERSTANDING OF RE CASH FLOWS -------------------------------------------------------------------------------- £875PP +20% VAT Single place on a public course IN-HOUSE COURSE “DEEPER UNDERSTANDING OF RE CASH FLOWS” -------------------------------------------------------------------------------- £3,850/DAY + VAT @ 20% Detailed manual included. Includes up to 6 attendees. £60+VAT pp surcharge thereafter

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.

Move from Beginner to Professional Level in Financial Modelling and Analysis with this detailed Advanced Financial Modeler Certificate Course.

This one day course has been developed to teach essential real estate financial modelling theory, functions and formulas to individuals working in the real estate sector.

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.

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 [https://www.bayfieldtraining.com/]

Register on the Financial Modeling with Excel today and build the experience, skills and knowledge you need to enhance your expert development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Financial Modeling with Excel course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! WHY CHOOSE THIS COURSE? * Receive a e-certificate upon successful completion of the course * Get taught by experienced, expert instructors * Study at a time and pace that suits your learning style * Get instant feedback on assessments * 24/7 help and advice via email or live chat * Get full tutor support on weekdays (Monday to Friday) COURSE DESIGN The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of * Video lessons * Online study materials * Mock exams * Multiple-choice assessment CERTIFICATE OF ACHIEVEMENT Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £59.00. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. ENDORSEMENT This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. METHOD OF ASSESSMENT In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. COURSE CONTENT Financial Modeling with Excel Welcome to the Course! Get the Overview of What You'll Learn 00:04:00 Planning your Financial Model 00:09:00 Building a Model Template 00:12:00 Projecting the Income Statement 00:13:00 Projecting the Balance Sheet 00:17:00 Projecting Cash Flows 00:14:00 Advanced Financial Modeling 00:14:00 BONUS LESSON: Top 5 Excel Features for Financial Modellers 00:08:00 Resources Resources - Financial Modeling with Excel 00:00:00 Assignment Assignment - Financial Modeling With Excel 2 days, 10 hours Order Your Certificate Order your Certificate QLS 00:00:00 FREQUENTLY ASKED QUESTIONS Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.