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.
Real Estate Acquisitions Integrating ARGUS and ExcelCornell Course
and Excel
Cornell CourseReal Estate Acquisitions Integrating ARGUS and Excel ()
Tell me more!Online
Course Overview
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
Course Length
3 weeks
Effort
4-5 hours per week
Format
100% online, instructor-led
Course Author
Daniel Lebret
Senior Lecturer, Real Estate Finance
Cornell Nolan School of Hotel Administration
Senior Lecturer, Real Estate Finance, Cornell Nolan School of Hotel Administration
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
Get It Done
100% Online
100% Online
Our programs are expressly designed to fit the lives of busy professionals like you.
Learn From
cornell's Top Minds
cornell's Top Minds
Courses are personally developed by faculty experts to help you gain today's most in-demand skills.
Power Your
career
career
Cornell's internationally recognized standard of excellence can set you apart.
Stack To A Certificate
Request Information Now by completing the form below.
Act today—courses are filling fast.