Commercial Real Estate Analyst
Kleinbrook Consulting is a boutique commercial real estate advisory firm specializing in institutional-grade financial modeling and underwriting. They are seeking a Commercial Real Estate Analyst to build, refine, and deliver complex financial models and provide analytical support for real estate transactions.
Responsibilities
- Build, refine, and optimize institutional-grade Excel models for acquisitions, development, refinancing, dispositions, and asset management
- Construct dynamic cash flow models, financing modules, and full pro forma architectures
- Develop multi-tier equity waterfalls, including preferred returns, promotes, GP catch-ups, and IRR hurdle structures (American and European)
- Build LIHTC underwriting models with layered capital stacks and complex financing structures
- Design scenario and sensitivity analyses across rents, cap rates, expenses, absorption, and capital structures
- Utilize VBA/macros where appropriate to enhance efficiency and accuracy
- Engage directly with clients to ensure deliverables meet scope and underwriting objectives
- Perform comprehensive underwriting, including rent roll analysis, expense modeling, market comps, and valuation
- Support transaction execution through due diligence coordination, third-party report review, lender interaction, and model updates
- Prepare investment memoranda, underwriting summaries, and client-facing financial exhibits
- Track deal assumptions, timelines, and deliverables to maintain an organized pipeline
Skills
- Strong analytical skills with exceptional attention to detail
- Advanced Excel proficiency and demonstrated financial modeling experience
- Solid understanding of real estate finance, underwriting, and capital markets
- Experience with due diligence, market research, and risk assessment
- Bachelor's degree in Finance, Real Estate, Economics, or a related field
- Excellent communication, time management, and problem-solving skills
- Experience with real estate software and VBA is a plus
Company Overview