Home
Financial Modeling
Capital Advisory
Offering Memoranda
Market/Feasibility Analysis
Site search
 
 
Financial Modeling

"It's like I outsourced my CFO."
  - Developer of condominiums on the West Coast

A financial model is the heart of any successful investment or development project. As deals reach increasing levels of complexity, they require a level of analysis that is more precise and accurate than the 'back of the envelope' approach of yesteryear.

Many of our clients turn to KREG for their modeling needs. In this capacity, we work closely with them throughout the acquisition and development process to ensure a project's success. Unlike a software vendor, we are platform neutral and tailor the solution to the client instead of the other way around. The models that we deliver to our clients are not "canned"; they are unlocked, reusable, and may be modified by the client at their discretion.

We have worked on a wide range of projects that vary in both size and complexity from a single acquisition to complex mixed-use multi-phase developments.

Regardless of deal size, our key objective is always to build highly functional and automated models that can be controlled from a clearly defined set of input assumptions.

We can also review and analyze client’s existing financial models for inaccuracies and inefficiencies.  We will then optimize the model into a true acquisition or development tool that can be used for meaningful analysis.

Previous Assignments Include:

  • A $250 million acquisition of 25 retail and apartment buildings in New York City with a large percentage of rent regulated units
  • An eight building mixed-use multi-phase development project in Bethesda, Maryland
  • A 5.5 million SF mixed-use development in Mexico that will include a 75 story tower
 

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 partnership structure. Enter the required cash flows and "hurdle rates", and this model will tell you the internal rate of return for the developer and financial partner.
Simple Commercial Cash Flow Analysis - A basic 5 tenant cash flow model.

Downloadable Live Examples

Automatic vs. Manual Iterations, Excel file
Automatic vs. Manual Iterations, AVI video file

Downloadable Examples of Complete Models
The functions in these models have been disabled but you are still able to see how complex they are and you can see the quality of our work.

Residential Sample Model
Mixed Use Sample Model
 

Case Studies

Parkhouse Virginia Ave. Kahr models