Daniel Lebret is a senior lecturer in real estate finance at the Cornell Nolan School of Hotel Administration. He has been at Cornell University since he received his Ph.D. in 2008, and his teaching responsibilities have included undergraduate and graduate courses on real estate finance, real estate financial modeling, real estate statistical modeling, urban economics, securitization, and structured finance, along with coaching teams of students for real estate finance case competitions.
In this course, you will apply real estate financial modeling skills to a real-world example, offering the advantages of immersive decision-making but also assessment of that decision based on the outcome of a real example. You will examine an opportunity to invest in a Class B building located within the New York City submarket of Hell's Kitchen on the west side of Manhattan. You will walk through the process of carefully underwriting the deal and, ultimately, deciding whether or not to invest.
In the process of this example transaction, you will gain experience using the industry's commonly adopted approach: utilizing widely used modeling tools including Microsoft Excel and ARGUS, which is used to model office, retail, and industrial operating cash flows. By adjusting crucial variables, you will discover new insights in the process of creating a dynamic model using these industry best practices. Finally, you will delve into the step-by-step market analysis behind each one of the tenant scenarios to inform a final recommendation. By experiencing the whole project process, you will be equipped to apply these skills to your projects across the industry.
You are required to have completed the following courses or have equivalent experience before taking this course:
- Discounted Cash Flows in Real Estate
- Unlevered Real Estate Acquisitions
- Real Estate Debt Financing and Scenario Analysis
- Real Estate Development Financing
- Equity Waterfalls in Joint Ventures
Key Course Takeaways
- Integrate ARGUS outputs into Excel-based models to create a market analysis
- Build and organize financial scenarios within the context of a development project
- Apply an equity waterfall to a development project which distributes equity cash flows based on a partnership agreement
- Create data tables to produce a summary of outputs for reporting purposes
How It Works
Who Should Enroll
- Acquisition and asset managers
- Financial analysts
- Real estate investors
- Real estate development professionals
- Individuals looking to invest in commercial real estate
- MBA students
- City and regional planning professionals