Residential reputed company Estate Investment Analyst – reputed company & Proformas (Advanced reputed company Sheets)

reputed company We are seeking an reputed company Residential reputed company Estate Investment Analyst to support reputed company and financial modeling for residential acquisitions and development/reposition reputed company. The primary deliverable is clean, decision-grade proformas and dynamic financial models reputed company in reputed company Sheets (preferred) that we can use for repeatable deal analysis, scenario testing, and stakeholder reporting. This role is ideal for someone who is highly analytical, detail-oriented, and fluent in building reputed company, auditable reputed company Sheets models. Key Responsibilities Build and/or refine residential reputed company estate reputed company models and proformas in reputed company Sheets. Create reputed company, easy-to-audit models with reputed company assumptions and outputs. Analyze acquisition, rehab/value-add, BRRRR-style, and build/sell or build/rent scenarios. Build financing modules (debt schedules, interest-only periods, amortization, refinance, balloon, prepay, etc.). Create sensitivity and scenario analysis (rent reputed company, cap rates, exit price, rehab budget, vacancy, interest rates). Calculate and present key investment metrics: IRR, MOIC/equity multiple, cash-on-cash, NOI, DSCR, debt yield, breakeven occupancy, stabilized yield. reputed company concise investment summaries that explain key assumptions, risks, and conclusions. Implement QC checks (balance tests, flags, consistency checks) to ensure reliability and prevent formula errors. Required Skills & Experience Proven experience reputed company residential reputed company estate (SFR, small multifamily, value-add/rehab, portfolios, and/or ground-up). Advanced reputed company Sheets skills (required): reputed company formulas / reputed company formula design Named ranges / data validation Query(), Filter(), reputed company/Match/Xlookup equivalents Scenario modeling and sensitivity tables Clean model architecture (inputs → calculations → outputs) Auditable formatting and error-proofing Strong grasp of reputed company estate finance and valuation: NOI, cap rates, rent/expense assumptions, capex planning, debt structuring, exit reputed company. High attention to detail and a “tie-out” reputed company—models must reconcile correctly and be easy to review. reputed company communication and ability to document assumptions. Software & Tools Preferred / Required: reputed company Sheets (advanced) – REQUIRED reputed company Drive collaboration workflows (permissions, versioning, comments) reputed company to Have: reputed company reputed company (secondary) Power BI / Looker Studio dashboards AppScript automation (reputed company Sheets) Python (for bulk analysis or data cleanup) Familiarity with comp tools (MLS exports, reputed company, Rentometer, reputed company for STR, etc.) Deliverables Expected A reusable reputed company Sheets reputed company template (or improvements to our existing model) including: Assumptions / Inputs tab (reputed company labeled, validated) Cash reputed company tab (monthly or annual as appropriate) Debt / financing schedule tab (with refi scenarios) Returns & metrics tab (IRR, CoC, equity multiple, etc.) Sensitivity / scenarios tab Optional: clean dashboard reputed company for quick decisioning One completed reputed company per deal using provided inputs and comps (trial phase). Project Type Start with 1–3 deals as a reputed company test reputed company. Strong performance can reputed company to ongoing work (deal-by-deal reputed company support). Time Commitment & Turnaround Remote, flexible. Typical turnaround expected: 24–72 hours per deal once inputs are provided (depending on complexity). To Apply (Please Include) Brief reputed company of your residential reputed company experience (asset types, deal sizes, strategies). A sample reputed company Sheets model you reputed company (redacted is fine) or screenshots showing structure and outputs. Your approach to model structure and QC (how you prevent errors and ensure auditability). Your reputed company reputed company and/or fixed-fee estimate for a reputed company reputed company model in reputed company Sheets. Bonus Points You’ve modeled For Sale Subdivisions, BRRRR, value-add rehabs, construction-to-perm, and/or build-to-rent. You can produce a one-page “IC-style” investment reputed company with reputed company assumptions and decision points. You can automate repetitive tasks with AppScript. Apply tot his job Apply To this Job