Foundations Of Real Estate Financial Modelling

NAMED ONE OF THE BEST COMMERCIAL REAL ESTATE BOOKS BY THE MOTLEY FOOL "Staiger gives us the technical tools needed to build robust pro forma modeling around our real estate assets." –MillionAcres Now in its third edition, Foundations of Real Estate Financial Modelling equips a new generation of students and professionals with a resource MillionAcres guarantees they’ll "use throughout [their] commercial investing career[s]." Designed to provide increased scalable basis of pro forma modelling for real estate projects, this complete update and revision of the classic text offers a step-by-step introduction to building and understanding the models underlying investments in properties from single-family rentals to large-scale developments. Case studies drawn from the author’s storied investment career put models into real-world context while problem sets at the end of each chapter provide hands-on practice for learners at any stage of their real estate careers. This edition employs the innovative financial metric P(Gain) to quantify the probability of a Return of Capital, ensuring readers’ ability to answer the most fundamental question of investing—What is the probability I’ll get my money back? The fully revised and enhanced third edition is organized in three functional units: (1) Real Estate Valuation Basics, Theory, and Skills, (2) Real Estate Pro Forma Modelling, and (3) Real Estate Pro Forma (Enhancements). Chapters cover: Interest Rates (Prime, LIBOR, SOFR) Amortization (Cash-Out Refinance modelling) ADC (Acquisition, Development, Construction) Module Rent Roll Module (including seasonality) Waterfall Hotel Consolidation Stochastic Modelling and Optimization Additional chapters are dedicated to risk quantification and include scenario, stochastic, and Monte Carlo simulations, equity waterfalls, and integration of US GAAP financial statements. A companion website provides the real estate pro forma models to readers as a reference for their own constructed models, www.pgainllc.com. An ideal companion in the classroom and the boardroom, this new edition of Foundations of Real Estate Financial Modelling will make even novices the "experts in the room on [their] chosen asset class" (MillionAcres).

Real Estate Financial Modelling is specifically designed to provide an overview of pro forma modelling for real estate projects. The book introduces students and professionals to the basics of real estate finance theory before providing a step-by-step guide for financial model construction using Excel. The idea that real estate is an asset with unique characteristics which can be transformed, both physically and financially, forms the basis of discussion.

Foundations of Real Estate Financial Modelling is specifically designed to provide an overview of pro forma modelling for real estate projects. The book introduces students and professionals to the basics of real estate finance theory before providing a step-by-step guide for financial model construction using Excel. The idea that real estate is an asset with unique characteristics which can be transformed, both physically and financially, forms the basis of discussion. Individual chapters are separated by functional unit and build upon themselves to include information on:AmortizationSingle-F.

NAMED ONE OF THE BEST COMMERCIAL REAL ESTATE BOOKS BY THE MOTLEY FOOL Foundations of Real Estate Financial Modelling, Second Edition is specifically designed to provide the scalable basis of pro forma modelling for real estate projects. The book introduces students and professionals to the basics of real estate finance theory prior to providing a step-by-step guide for financial real estate model construction using Excel. The book introduces an innovative new financial metric, P(Gain), which quantifies the probability of a Return of Capital and answers the most basic question for investing, "What is the probability I get my money back?". This new second edition has been fully revised and expanded. The book is separated into three functional units: (1) Real Estate Valuation Basics, Theory and Skills, (2) Real Estate Pro Forma Modelling, (3) Real Estate Pro Forma (Enhancements). New and enhanced Chapters cover: Interest rates Amortization Single- and multi-family unit Development module Rent roll module Waterfall (equity bifurcation) Hotel, retail/office and townhouse. In addition, this new edition includes problem sets and solutions at the end of each chapter as well as case studies underpinning the chapter topics. Further chapters are dedicated to risk quantification and include scenario, stochastic and Monte Carlo simulations, equity waterfalls, and adding U.S. GAAP financial statements to existing real estate pro forma models. This book is the ideal textbook for a Real Estate Finance class, providing the theoretical basis of real estate finance as well as valuable modelling skills for the workplace. This book provides individuals with a step-by-step instruction on how to construct a real estate financial model starting with a new spreadsheet. The resultant model is portable, scalable, and modular. A companion website provides the pro forma models to readers as a reference for their own constructed models. Companion web material available at: https://pgainllc.com/

This text provides an introduction to the real estate investment process, including the basics of the investment decision, the environment in which the investment decision is made, the development of cash flow statements, and the applications of various investment criteria. The Third Edition represents a revision aimed at updating material and improving methodologies for learning.

"...Provides a state-of-the-art overview of real-estate derivatives, covering the description of these financial products, their applications, and the most important models proposed in the literature...The book examines econometric aspects of real-estate index prices time series and financial engineering non-arbitrage principles that govern the pricing of derivatives...examples are based on real-world data from exchanges, major investment banks or financial houses in London. The numerical analysis is easily replicable with Excel and Matlab."--back jacket cover.