If you have any questions, please contact me at josh@kahrrealestate.com, my office at (212) 566-4085 x111, or my cell at (646) 286-0128.

Syllabus

Core Tools
Cash Flow
Construction
Partnerships
Solutions to Common Problems

Chapter 3 Excel
Chapter 4, 5, 6 Excel
Chapter 9, 10, 11 Excel
Chapter 12 Excel
Chapter 13 spreadsheets
Chapter 14 spreadsheets
Chapter 15 spreadsheets
Chapters 16 and 17 spreadsheets
Chapter 18 spreadsheets
Slides 3
Slides 4
Slides 5
Slides 6
Slides 9
Slides 10
Slides 11
Slides 12
slides 13
slides 14
slides 15
slides 16
slides 17
slides 18

Sample Partnership Materials

Big Institution Partnership Docs
FundSummaryTerms
PROP-TEASER_London
Real Estate Alert 4/1/09
US Fund Structure
WM Securities First Stamford Place

Sample MBS Materials

Goldman Greenwich 2007-GG11
Petra CDO Final

Random Materials

Banks by Market Cap from 2007 to 2009
Madoff Aksia Letter
Subprime debacle explained with stick figures
The Spiral. Has to be seen to be believed. Potentially offensive, especially to I-bankers. Very large document (180 MB)
Presentation on current real estate markets, York University, June 2009
Sample Acquisition and Construction Loan Commitment Letter
Another construction term sheet

Homework Assignments, Answers, Mid-Terms, and Finals

The address for submitting the homework is:

columbiaref11@gmail.com

HW 1

Chapter 3, Problems 1, 3, 7, 9, 13, 18 (parts a and b)
Chapter 4, Problems 10, 14, 16, 18, 20
Chapter 5, Problems 2, 7, 10

HW 2

The due date is 7/9.

Chapter 6, Problems 1, 2, 4, 5, 8
Chapter 9, Problems 1, 3, 5, 6
Chapter 10, Problems 4, 5, 9, 10, 13

HW 3

Chapter 11, Problems 1, 2, and 3
Chapter 12, Problems 1, 3, 6, and 8
Chapter 13, Problems 1, 3, and 4
Chapter 14, Problems 1, 2, and 3

HW 4

Chapter 15, Problem 1
Chapter 16, Problem 3
Chapter 17, Problem 3

All homework is due by 9:00 am of the due date.

Midterm and Final Samples

Sample midterm Fall 2007 with answers
Sample midterm Fall 2008 with answers
Summer 2009 Midterm Answers