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

London

United Kingdom

Searching for information and tickets regarding Bayfield Training - Real Estate Developer (Development DCF Modelling) | London taking place in London on Jul 17, 2025 (UTC+1)? Trip.com has you covered. Check the dates, itineraries, and other information about Bayfield Training - Real Estate Developer (Development DCF Modelling) | London now! Trip.com has also prepared more similar exciting activities and discounted flight and hotel packages.

Bayfield Training - Real Estate Developer (Development DCF Modelling) | London: Tickets, Dates & Itineraries | Trip.com

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

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

null | Trip.com

Spread the word! Share your result with friends and discover their opinions!

The Ritz London

Luxury Hotels

The Dorchester

The British Museum

Best Things to Do

Museums

西沙群岛司马亮

Walking among the Egyptian mummies, I came across the glass reflection of the Rosetta Stone. Under the cold stone folds of the Parthenon sculptures, there are always tourists looking up and frozen into silhouettes. The display cabinets are more crowded than the exhibits. In the cracks of the celadon in the East Asian Hall, I caught a glimpse of my own hazy reflection - like those wandering cultural relics, with no idea when they will return.

Westminster Abbey

Night Attractions

苏河家园

Westminster Abbey is a world-famous Gothic building, both with a magnificent exterior and exquisite interior sculptures that are breathtaking. The church is a frequent visitor to royal coronations, weddings, state funerals, and the tombstones and monuments of great figures such as Newton and Darwin are also here, and the cultural atmosphere is bursting!

Four Seasons Hotel London at Park Lane

Raffles London at the Owo

Near London Eye|Buckingham Palace, London

The Peninsula London

Near Victoria Railway Station|Belgravia, London

Buckingham Palace

The Buckingham Palace Changing of the Guard ceremony is a symbolic royal cultural event in London. You should occupy a favorable position in advance. At the appointed time, the guards, wearing red uniforms and bearskin hats, enter the venue to the sound of the military band &quot;God Save the King&quot;. The old and new guards take over their posts. The scene is very shocking. A large number of tourists gather outside the iron gate, vying to witness the changing of the guard ceremony of the royal guard.

London Eye

Immediate access

Book now for today

Night view

I was shivering in the cold and queued for 40 minutes. I spent all the money I saved by booking tickets online on hot cocoa. My feet were numb when the glass cabin rose to the middle of the air - the Thames River was twisted into a tinfoil ribbon, and Big Ben was as small as a Lego block. The night view was really amazing. When the purple ring lit up, the whole river looked like it was splashed with fluorescent paint. When I landed, my legs were weak. I looked back and saw the purple ring that had collapsed into a rag. I thought: It was worth it, but I will buy a fast ticket next time.

Windsor Castle

Historic buildings

康泰时

Windsor Castle is a place worth punching in. Walk into the ancient castle to witness the history of the Royal British History. If you are tired, you can sit in the coffee shop in the castle. Aftertaste the luxurious buildings in the palace, wait after 3 pm. Take a few blockbusters when the light is good. You can also see the sentry changing in Windsor Castle.

Time:	Jul 17, 2025 (UTC+1) ENDED
Location:	London

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

Details

Vote

Are you interested in Bayfield Training - Real Estate Developer (Development DCF Modelling)?

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

The Ritz London

The Dorchester

The British Museum

Westminster Abbey

Four Seasons Hotel London at Park Lane

Raffles London at the Owo

The Peninsula London

Buckingham Palace

London Eye

Windsor Castle

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

Details

Vote

Are you interested in Bayfield Training - Real Estate Developer (Development DCF Modelling)?

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

The Ritz London

The Dorchester

The British Museum

Westminster Abbey

Four Seasons Hotel London at Park Lane

Raffles London at the Owo

The Peninsula London

Buckingham Palace

London Eye

Windsor Castle

More contents about London