Real Estate Financial Modelling In Excel

Get ahead of your peers with Real Estate Financial Modelling in Excel, a book specifically designed to ensure that the next generation of property professionals become experts in the quantitative analysis of real estate investments.

Get ahead of your peers with Real Estate Financial Modelling in Excel, a book specifically designed to ensure that the next generation of property professionals become experts in the quantitative analysis of investments by teaching them how to create automated spreadsheets for the analysis of risk and return.

Real estate financial modelling has become an essential skill to investment analysts as the global property industry has seen huge transformations as a result of more institutional investors, especially private equity funds, increasing their interest in the asset class. Consequently, the industry requires a new skill set from real estate professionals and graduates.

Real Estate Financial Modelling in Excel will help current finance and real estate students, as well as practitioners, to harness the power of Microsoft Excel in the context of real estate investments and explain in an easy-to-follow manual style how to create financial models that will predict financial returns and the risks related to them. Readers will learn to use Excel for automation, data analysis, and data visualisation to inform their capital allocation decisions, giving them the edge with those technical skills in high demand in the investment markets and in particular with sophisticated investors such as pension and insurance funds, private equity, and specialised debt funds.

This book will address the needs of busy real estate professionals and students in the final year of a real estate bachelor’s degree or master’s degree, who want to apply the theories of finance and investment into practice and build models to help make decisions regarding acquisitions, disposals, and management of real estate assets.

Acknowledgements

Preface

Session 1: Real Estate Financial Modelling - The Property and It’s Income-Generation Potential

Chapter 1: What are financial models and how are they used in the real estate sector?

Chapter 2: Real Estate Valuation Terminologies

Chapter 3: Real Estate Valuation Using Capitalisation Methods

Chapter 4: Introduction to Discounted Cash Flow Modelling and Analysis

Chapter 5. Advanced Discounted Cash Flow Modelling and Analysis

Session 2: Financial Modelling of Commercial Real Estate Debt – Gearing (or Leveraging)

Chapter 6: Debt Structures

Chapter 7: Comparing Debt Structures And Analysing Results

Session 3: Real Estate Development Financial Modelling

Chapter 8: Development Valuation and Analysis

Chapter 9: Geared Development Investment

Session 4: Risk Modelling

Chapter 10: Sensitivity Analysis

Maria Wiedner is the Founder and CEO of Cambridge Finance, a company she founded in 2016 to provide real estate financial modelling courses and consultancy. She is also the Founder and CEO of Real Estate Women, CIC, an organisation which advocates for equality and inclusion and the fair representation of women and minorities in senior positions. In addition, Maria serves as a Real Estate Finance Specialist and APC Assessor for the Royal Institution of Chartered Surveyors (RICS). Maria currently teaches Real Estate Modelling in the Global Masters in Real Estate Development program at IE School of Architecture and Design in Madrid, Spain, and is a D&I Editorial Advisor for Property Week, the leading news magazine in the commercial and residential property market in the United Kingdom. Maria’s career has been built upon highly quantitat