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.
Breakdown of training
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
Hard Copy Course Manual
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
This Two day Financial Modelling in Excel course is also available in the classroom, please feel free to contact the Bayfield Training Sales team for more details on this and any other questions you may have:
E - Info@bayfieldtraining.com
W - 
www.bayfieldtraining.com
Information Source: Bayfield Training Ltd | eventbrite

倫敦

英國

正在搜尋Bayfield Training - Real Estate Developer (Development DCF Modelling) | London的資訊及門票嗎？Trip.com 樂意為您服務。立即查看關於Bayfield Training - Real Estate Developer (Development DCF Modelling) | London的日期、行程及其他資訊，並在參與Bayfield Training - Real Estate Developer (Development DCF Modelling) | London之前先訂好實惠又合適的機加酒！Trip.com 還準備了更多類似的精彩活動，當然也包含優惠的機票及飯店組合。立即啟程！

Bayfield Training - Real Estate Developer (Development DCF Modelling) | London的日期及行程 | Trip.com

Bayfield Training - Real Estate Developer (Development DCF Modelling) | London

Bayfield Training - Real Estate Developer (Development DCF Modelling) | Trip.com

探索更多倫敦相關的內容

null | Trip.com

看看您好友的想法？分享您的答案就能開始聊天！

倫敦麗茲飯店

倫敦, 鄰近大英博物館|聖詹姆斯

奢華飯店

多切斯特飯店

白金漢宮

明日可用

人氣景點

歷史建築

夜景

Lola Coveñas

白金漢宮是歷史愛好者必去的地方，擁有令人驚嘆的建築和美麗的花園。它是英國君主的官邸，其歷史可追溯到 1703 年，是皇家儀式和活動的場所。遊客可以一睹皇室生活，其中換崗儀式是最受歡迎的景點。

倫敦動物園

隨買隨用

即日可用

家庭友善景點

Janexx08

非常棒的體驗，探索這個地方並看到不同的動物，非常有趣。裡面有咖啡店可以休息一下。

倫敦柏麗大道四季飯店

倫敦 OWO 萊佛士飯店

倫敦半島飯店

倫敦, 鄰近維多利亞火車站|貝爾格萊維亞

攝政公園

喜欢猫的虎

攝政公園(The Regent&rsquo;s Park)位於倫敦的西北端，緊鄰福爾摩斯博物館和杜莎夫人蠟像館，是倫敦市中心的第二大公園，僅次於海德公園。公園佔地500多英畝，原為亨利八世的狩獵場。園內設有花園、湖泊、玫瑰園、球場和兒童樂園等。除了北部的倫敦動物園外，還設有露天劇場，夏天經常上演莎士比亞的劇目。

與Bayfield Training - Real Estate Developer (Development DCF Modelling) | London相關

時間：	Jul 17, 2025 (UTC+1) 結束
地點：	London