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