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 Kleinbrook Consulting is a commercial real estate advisory firm specializing in institutional-grade financial modeling and underwriting support for developers, sponsors, investors, and lenders. It was founded in 2023, and is headquartered in Nashville, Tennessee, US, with a workforce of 2-10 employees. Its website is