Commercial Real Estate Analyst Needed to Review and Correct Rent & Expense Prorations (Excel-Based)

---

I'm looking for an experienced Commercial Real Estate Analyst or transaction coordinator with deep familiarity in lease analysis and closing statement reconciliations. This project involves reviewing an Excel spreadsheet with rent, CAM, tax, and security deposit prorations for a shopping center sale closing on Thursday, May 15, 2025. Your task: Review the current spreadsheet to identify inaccuracies in rent and CAM proration logic. Correct the proration calculations based on: The closing date of May 15, 2025 Monthly rents paid in advance Proper allocation of income and expenses (e.g., seller keeps income before 5/15, buyer keeps income on/after 5/15) Reconcile prorated tax, CAM, and expense allocations to ensure fairness and conformity with commercial closing standards. Deliver a clean, revised Excel sheet with formulas and clear notes. Requirements: Proven experience in commercial real estate transactions (retail preferred) Expertise in Excel (including financial modeling/proration logic) Familiarity with U.S. lease structures and closing prorations Attention to detail and ability to clearly document assumptions Bonus if you have: Experience as a commercial real estate broker, paralegal, or closing coordinator Knowledge of North Carolina real estate practices Deliverable: Updated Excel workbook with accurate proration formulas Written summary of changes and logic used Timeframe: Immediate start; must be completed within 48 hours of acceptance. Please submit: A brief summary of similar projects A link to a comparable Excel proration or rent roll analysis (if available)

Keyword: Data entry

Microsoft Excel Financial Analysis Real Estate Real Estate Acquisition Real Estate Closing Real Estate Financial Modeling