Online Financial Modeling, Investment Banking, Excel Training

REAL ESTATE DEVELOPMENT MODELING

Package: $300 (Save 40%)

Property specific modeling for master plan & hotel development (more)

Overview of Courses
Real estate takes a different twist from traditional companies in that it doesn't sell or produce any goods. As such, the process of building up the P&L requires a different logic. From quantifying the costs of a development project to the revenue build-up, we explore a master plan for community and condo development to a commercial hotel project.

Real Estate Development - Master Plan

($250)

Course Goals & Overview:
Evaluate the financial feasibility of a greenfield real estate development project. Determine the valuation of an empty plot of land by developing and building different lots, houses and condos. First, incorporate infrastructure costs required for a master plan development. Then dynamically differentiate among developing empty lots, building single family houses, and constructing & selling condominiums. Account for variability in construction timelines for different types of properties and sensitize the master financial model for various per unit and per square foot costs as the project is in planning, construction and post-construction phases. Learn how to quickly modify assumptions to customize the model to reflect a poor operating environment as the pace of lot sales significantly decline. In addition, learn how to determine optimal funding mix of equity vs. debt based on project cash flows and IRR.

Learning Objectives:

Build a sample master plan which involves buying raw land, creating community-wide infrastructure (shared utilities and resources that didn�t previously exist) and then constructing buildings for sale or rent

Understand timeline and construction costs associated with common land and unit specific development

Model out monthly revenues based on assumptions regarding pre-sales volume, deposits, and various phases of planning, construction and post-construction

Map out draw down of construction costs and final cash flow stream which dictate capital required, influencing IRR and multiple of capital

Prerequisites:

Accounting & Financial Statements Integration

Corporate Valuation Methodologies

Basic Financial Modeling

Video Length / Estimated Total Course Time:
2 hours / 3 hours

Individual Course Price:

$250

Click here to register now!

Hotel Development

($250)

Course Goals & Overview:
Evaluate and analyze the acquisition, construction and renovation of a boutique hotel. Quantify hotel-specific construction costs and Sources & Uses of Funds. Perform detailed construction loan analysis that rolls into larger debt funding facility. Funnel into the core projection, estimating REVPAR (Revenue per available room), various revenue streams and operating expenses. Compute management incentives and ultimately roll into Net Cash Flow and IRR.

Learning Objectives:

Build a sample hotel investment analysis which involves buying land, constructing or renovating a new boutique hotel, industry standards in raising debt capital and of course ultimately, P&L and cash flow analysis to determine returns

Model out detailed construction loan analysis with various drawdown percentages and interest reserves which feeds the amortization schedule of larger debt funding facility

Construct projection model based on key factors such as room-nights available, occupancy rates, daily room rate, REVPAR and other relevant factors

Prerequisites:

Accounting & Financial Statements Integration

Corporate Valuation Methodologies

Basic Financial Modeling

Video Length / Estimated Total Course Time:
1.5 hours / 2 hours

Individual Course Price:

$250

Click here to register now!