AIA CES Credits
AV Office
321M Fayerweather Hall
Abstract Publication
415 Avery Hall
Academic Affairs
400 Avery Hall
Academic Calendar, Columbia University
Academic Calendar, GSAPP
Admissions Office
407 Avery Hall
1172 Amsterdam Avenue
New York, New York 10027
Advanced Standing Waiver Form
Must be printed and returned to 400 Avery Hall
Alumni Board
Alumni Office
405 Avery Hall
1172 Amsterdam Avenue
New York, New York 10027
Architecture Studio Lottery
Assistantships
Avery Library
300 Avery Hall
1172 Amsterdam Avenue
New York, NY 10027
Avery Review
Avery Shorts
Black Student Alliance at Columbia GSAPP
Building Science & Technology Waivers
Bulletin Archive
Career Services
300M Avery Hall
Columbia Books on Architecture and the City
Commencement
Communications Office
415 Avery Hall
Conversations podcast
Counseling and Psychological Services
Courses
Credentials Verification
Credit Transfer
Cross Registration
Dean’s Letter
Dean’s Office
402 Avery Hall
1172 Amsterdam Avenue
New York, NY 10027
Development Office
404 Avery Hall
Directory of Classes (All Columbia University)
Disability Services
Dodge Fitness Center
3030 Broadway Dodge
Dual Degree Program Requirements
End of Year Show
Events Office
415 Avery Hall
External Funding Sources
Faculty Directory
Feedback
Finance Office
406 Avery Hall
Fitch Colloquium
Future Anterior Journal
GSAPP Community Fellowship Program
GSAPP Emergency Fund
GSAPPX+
Grades
Graduation
Graphics Project
Honor System
Human Resources
Hybrid Pedagogy Resources
IT Helpdesk Ticket, GSAPP
IT Office, GSAPP
IT, Columbia University (CUIT)
Identity
Incubator Prize
International Students and Scholars Office (ISSO)
News and Press Releases
Newsletter Sign Up
Non-Discrimination Statement and Policy
Onera Prize for Historic Preservation
Online Admissions Application
GSAPP Admissions 407 Avery Hall
Output Shop
116 Avery Hall
1172 Amsterdam Avenue
New York, NY 10027
Ownership of Student Work Policy
Paris Prize, Buell Center
Paul S. Byard Memorial Lecture Series
Percival & Naomi Goodman Fellowship
Plagiarism Policy
Policies & Resources
Press Releases
Publications Office
415 Avery Hall
1172 Amsterdam Avenue
New York, New York 10027
Registration
Registration: Add / Drop Form
Room Reservations
STEM Designation
Satisfactory Academic Progress
Scholarships
Skill Trails
Student Affairs
400 Avery Hall
Student Awards
Student Conduct
Student Council (All Programs)
Student Financial Services
Student Health Services at Columbia
Student Organization Handbook
Student Organizations
Student Services Center
205 Kent Hall
Student Services Online (SSOL)
Student Work Online
Studio Culture Policy
Studio Procedures
Summer Workshops
Support GSAPP
Structuring with Advanced Excel
Capital & Partnership Structuring with Excel Modeling examines the framework and dynamics of real estate investments, emphasizing the relationships between various stakeholders such as sponsors, lenders, investors, and fund managers.
Guest Speakers and Case Studies: The course features guest speakers from different industry roles. These experts will share case studies, offering practical insights into how financial modeling influences decision-making and understanding of capital structures.
Emphasis on Excel Modeling: A critical part of the course involves applying Excel modeling across various topics. This approach is designed to ensure that students not only understand the theoretical aspects of real estate finance but also develop practical skills in applying these concepts using Excel and understanding capital structures.
For MSRED students only and only be taken after an MSRED student has completed REF I and REF II.
113 AVERY
TH 6 PM - 8 PM
SES A: 1/22-3/1
REQUIRED
73446
| Course | Semester | Title | Student Work | Instructor | Syllabus | Requirements & Sequence | Location & Time | Session & Points | Call No. |
|---|---|---|---|---|---|---|---|---|---|
| PLAN6231‑1 | Spring 2026 |
Capital Structuring for Real Estate Operating Firms
|
Jose Lievano |
MSRED Only, Prerequisite or Program Approval |
209 Fayerweather
F 2 PM - 4 PM
|
Session A
1.5 Points
|
14283 | ||
| PLAN6231‑1 | Spring 2025 |
Advanced Excel Skills
|
Jose Lievano | Syllabus |
113 AVERY
TU 4 PM - 6 PM
|
SES A
1.5 Points
|
11741 | ||
| PLAN6231‑1 | Spring 2024 |
Capital Partnership Structuring with Advanced Excel Modeling
|
Jose Lievano |
209 FAYERWEATHER
TU 4 PM - 6 PM
|
SES A
1.5 Points
|
13901 | |||
| PLAN6231‑1 | Spring 2023 |
Capital Partnership Structuring with Advanced Excel Modeling
|
Jose Lievano, Saam Alikhani |
113 AVERY
TU 4 PM - 6 PM
|
SES A
1.5 Points
|
11568 | |||
| PLAN6231‑1 | Spring 2022 |
Capital Partnership Structuring with Advanced Excel Modeling
|
Jose Lievano |
(By application only for MSRED) |
113 AVERY
TH 2 PM - 4 PM
|
SES A
1.5 Points
|
14526 | ||
| PLAN6231‑1 | Summer 2021 |
Capital & Partnership Structuring with Advanced Excel Modeling
|
Jose Lievano |
MSRED ‘21 |
113 AVERY
W 11 AM - 1 PM
|
SES A
1.5 Points
|
12629 | ||
| PLAN6231‑1 | Spring 2020 |
Structuring with Advanced Excel
|
Arash Barati, Jose Lievano |
113 AVERY
TH 6:30 PM - 8:30 PM
|
SESSION A
1.5 Points
|
12831 | |||
| PLAN6231‑1 | Spring 2018 |
Advanced Excel Skills
|
Jiho Lee, Matthew Choi |
113 Avery
TH 6 PM - 8 PM
|
Session A: 1/16-3/2
1.5 Points
|
60529 | |||
| PLAN6231‑1 | Spring 2017 |
Advanced Excel Skills
|
Jiho Lee, Johnny Din | Syllabus |
Elective |
113 Avery Hall
Th 6 PM - 8 PM
|
Ses A 1/17-3/3
1.5 Points
|
29695 | |
| PLAN6231‑1 | Spring 2016 |
ADVANCED EXCEL SKILLS
|
Johnny Din |
ELECTIVE |
200 SOUTH FAYERWAETHER
TH 6 PM - 8 PM
|
SES A 1/19-¾
1.5 Points
|
19257 |