|
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.
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
|