|
This page contains links to examples of our work, case studies, online financial models that you can work with, and downloadable spreadsheets.
We've tried to put up a mix of items so that potential clients can better understand what we're capable of producting.
Videos of Real Estate Finance classes
Our principal, Joshua Kahr, teaches real estate finance at Columbia University in their MS in Real Estate Development program. If you would like to view the videos of the lectures for his entire Real Estate Finance III classes from the Spring 2010 semester, click here and you can download the videos from iTunes.
The videos are entirely free to download and will contain all 13 lectures (which is 26 hours) from the course by the time the semester is over.
Online Live Models
Enter real data online and see the result in your web browser.
Manual Iterations - See how to calculate construction loans more effectively and without using circular references in Excel.
IRR Lookback - The IRR Lookback is a commonly used financial structure in partnerships. Enter your cash flows and "hurdle" rates, and this model will tell you the internal rate of return for the developer and the investor.
Simple Commercial Cash Flow Analysis - This is a simple five tenant cash flow model.
Downloadable Excel Code
Downloadable, and disabled, Excel Models
The functions in these models have been disabled but you can review the structure and better understand the complexity and quality of our work.
Residential Sample Model
Mixed Use Sample Model
Excel Videos
Automatic vs. manual iterations for construction loans, AVI video file
Goal Seek video (in Zip file)
Data Table video (in Zip file)
Solver video (in Zip file)
Scenario Manager video (in Zip file)
Other Videos
One hour presentation on the state of the real estate financial markets with Joshua Kahr, 9/16/09
Case Studies
NE Corridor
Parkhouse
Virginia Avenue
West 25th Street
Arverne
Hazelton
L Partners
Samples of Work Product
Market Analysis and Feasibility
Atlantic Yards Feasibility Study, 8/31/09
Cleveland Waterfront Market Demand and Development Options, 10/15/09
Tax Assessment Ratio Study, 10/20/04
Market Study, Arverne East
Financial Due Diligence
Condo/Retail Model
General Financial Models
Mixed Use Model
Capital Advisory
Partial Sample of Fund Offering Book, Distressed Debt
Partial Sample of Fund Offering Book, Medical Office
Partial Sample of Offering Book for Private Placement
| 
