Job Post: Expert Excel (VBA), Python & Power BI Consultant for Commercial Real Estate Acquisition Model Project Type: Hourly / Ongoing Industry: Commercial Real Estate (Acquisitions, Fund Modeling, Investor Reporting) Location: Remote Experience Level: Expert Only Project Overview We are seeking a world‑class financial modeling consultant with deep expertise in: Advanced Microsoft Excel (including VBA automation) Python for data processing and model automation Power BI for dashboarding, data visualization, and reporting Strong understanding of commercial real estate (CRE) financial analysis This project involves building a fully integrated commercial real estate acquisition model capable of forecasting asset‑level cash flows, generating tiered promote/waterfall structures, and rolling individual deals into a consolidated fund‑level model. If you live for complex modeling, airtight logic, and turning messy data into clean intelligence—this one’s for you. Scope of Work 1. CRE Acquisition Model Development Build a robust, dynamic Excel‑based cash flow model incorporating: Revenue, expense, debt, and capital structure assumptions Detailed pro‑forma forecasting Sensitivity and scenario testing Automate repetitive components with VBA where appropriate. 2. Multi‑Tier Waterfall / Promote Structure Develop investor waterfalls that handle: Multiple tiers and return hurdles Preferred returns Carried interest splits Sponsor fees and acquisition/disposition fees Allow for toggling of fee structures and investment scenarios. 3. Python Automation & Data Handling Use Python to: Streamline data ingestion and transformation Automate scenario runs Support modular, scalable model architecture Integrate with Excel and Power BI data flows 4. Executive Dashboard & Power BI Integration Build a Power BI dashboard (or Excel‑based equivalent) summarizing: Key deal‑level metrics IRRs, equity multiples, cash‑on‑cash returns Sensitivities and return distributions Ensure that the dashboard automatically updates from refreshed model inputs. 5. Fund‑Level Rollup Create a fund aggregation model that consolidates: Multiple individual deal models Capital calls, distributions, and commitments Real‑time performance metrics across the portfolio Build clean pipelines from deal‑level Excel/Python outputs into fund‑level reporting modules. Ideal Candidate You should have hands‑on CRE experience and a toolkit that includes: Expert Excel financial modeling (index/match, arrays, nested logic, audit‑ready structure) Clean, efficient VBA for model automation Strong Python skills (Pandas, NumPy, model automation workflows) Power BI (DAX, data modeling, custom visuals) Prior experience building CRE acquisition or development models Comfortable working in a high‑stakes, fast‑moving environment If you’ve built waterfalls, fund models, institutional‑grade dashboards, or automated underwriting pipelines before—tell us. Deliverables Fully documented CRE acquisition model Multi‑tier waterfall module Automated data flows via Python Executive‑level dashboard in Power BI Fund‑level rollup model Clear user instructions and technical documentation How to Apply Please provide: Relevant CRE modeling experience (samples welcome with redactions) Examples of Excel/VBA and Python automation you’ve built Power BI dashboards or analytics work you’ve delivered Hourly rate + availability A short summary of why you're a fit for this project