Description: We are seeking an experienced Excel modeler to develop a scalable, dynamic portfolio stress-testing model for commercial real estate (industrial and LRO) portfolios. This project focuses on quantifying portfolio-level financial volatility, policy and property-level deductible exposures, and scenario-driven risk. The ideal candidate will have advanced Excel skills, a strong quantitative background, and experience building financial or risk models that handle complex, row-driven datasets. Accuracy, scalability, and clean documentation are essential. Project Scope & Requirements: 1. Portfolio Engine • Model properties and policies with row-level calculations. • Automatically calculate: • Deductible allocation per property based on structure (Per Building / Per Occurrence / Per Policy). • Net Loss per property and policy. • Allocation (%) and deductible stacking. • Maximum single property and policy losses. • Allow additional properties or policies to be added without breaking formulas. 2. Scenario / Alternative Modeling • Create override controls for scenario testing: event type (Named Storm, Flood, EQ, AOP), state filter, damage ratio, deductible structure. • Automatically recalculate all impacted metrics when scenarios change. • Highlight potential stress points, correlations, and exposure stacking. 3. Policy & Portfolio Roll-Ups • Summarize data at the policy and portfolio levels: total net loss, gross loss, allocations, max single policy/property loss, etc. • Include portfolio-level metrics: total portfolio TIV, total portfolio market value, LTV, debt exposure, DSCR (optional), weighted average occupancy, and other relevant financial/risk indicators. 4. Data & Tables • All tables must use structured references or dynamic ranges. • Ensure headers, naming conventions, and data formats are consistent. • Include validation controls for input fields (dropdowns for event type, deductible structure, yes/no flags, etc.). 5. Documentation / Instructions • Provide step-by-step instructions for a non-technical user to: • Add new properties or policies. • Update scenario inputs. • Interpret calculated outputs and key stress metrics. • Run alternative scenario analyses. Deliverables: • Fully functioning Excel workbook with clear structured tables. • Scenario controls and dynamic calculations as described above. • User guide / instruction sheet explaining usage and workflow. • Optional: summary dashboards or charts highlighting key portfolio exposures and stress points.