Financial Modeling & Underwriting Analyst

Overlook Global; Ahmedabad District; Hybrid; INR 446,000 - 725,000; Full time

Job summary

Overlook Global in Ahmedabad seeks an Investment Analyst within the Acquisitions & Investments team to perform financial underwriting, investment analysis, market research, and transaction support across hospitality and other real estate investments.

You will produce accurate investment-grade underwriting and analytical materials for review by the U.S.-based Investment Associate and Managing Director, Head of Investments, contributing to debt sizing, capex, and exits.

Qualifications

• Experience building underwriting models for acquisitions.
• Ability to analyze historical operating statements and normalize property-level performance.
• Strong market research skills including submarket and competitive-set analysis.

Responsibilities

• Build comprehensive acquisition underwriting models.
• Analyze historical operating statements and normalize property-level financial performance.
• Prepare revenue projections based on occupancy, ADR, RevPAR and market conditions.
• Develop operating expense forecasts and margin assumptions.
• Model debt-service, DSCR, debt-yield, and other financing analyses.
• Model acquisition, refinance, recapitalization, and disposition scenarios.
• Prepare exit cap-rate and valuation analyses.
• Run base, upside, downside, and stress-case scenarios.

Skills

Financial modeling

Underwriting

Market research

Investment analysis

Transaction support

Tools

STR data

CoStar

Franchise data

Management-company data

Job description

Acquisitions & Investments team by performing financial underwriting, investment analysis, market research, and transaction support across hospitality and other real estate investments. The role is responsible for producing accurate, investment-grade underwriting and analytical materials for review by the U.S.-based Investment Associate and Managing Director, Head of Investments.

Financial Modeling & Underwriting

• Build comprehensive acquisition, renovation, redevelopment, and development underwriting models.
• Analyze historical operating statements and normalize property-level financial performance.
• Prepare revenue projections based on occupancy, ADR, RevPAR, market conditions, and business-plan assumptions.
• Develop operating expense forecasts and margin assumptions.
• Model CapEx requirements, renovation budgets, and hotel PIP obligations.
• Model senior debt, subordinate debt, seller financing, and other financing structures.
• Prepare debt-service, DSCR, debt-yield, and leverage analysis.
• Model acquisition, refinance, recapitalization, and disposition scenarios.
• Prepare exit cap-rate and valuation analyses.
• Run base, upside, downside, and stress-case scenarios.
• Calculate and analyze:
• Levered and unlevered IRRMOICCash-on-cash returnEquity multipleYield on costDebt yieldDSCR

Market & Investment Research

• Conduct market, submarket, and competitive-set research.
• Analyze historical and projected supply and demand.
• Review comparable hotel transactions and valuation benchmarks.
• Evaluate competitive positioning, brand performance, market segmentation, and operating trends.
• Support analysis of STR, CoStar, franchise, management-company, and other third-party data.
• Identify key investment risks and validate underwriting assumptions.

Transaction Support

• Assist with initial deal screening and preliminary underwriting.
• Maintain and update underwriting throughout the acquisition process.
• Incorporate diligence findings into financial models.
• Support analysis of franchise agreements, PIPs, management agreements, property condition reports, appraisals, and other transaction materials.
• Maintain transaction pipeline and underwriting trackers.
• Support diligence organization and data-room management.
• Assist with post-close comparison of actual performance against acquisition underwriting.

Investment Committee Materials

• Support preparation of Investment Memoranda.
• Prepare investment committee models, exhibits, charts, and analytical summaries.
• Develop sources-and-uses schedules.
• Prepare capital-stack summaries and return waterfalls.
• Produce sensitivity tables and downside cases.
• Clearly identify key underwriting assumptions, risks, and return drivers for senior leadership review.

Quality Control & Analytical Standards

• Ensure accuracy, consistency, and completeness of underwriting deliverables.
• Maintain standardized underwriting templates.
• Perform formula, assumption, and data-integrity checks.
• Maintain version control across financial models.
• Reconcile model inputs to source documents and financial statements.
• Flag inconsistencies, unusual assumptions, or missing information before senior review.
• Maintain organized supporting documentation for every material underwriting assumption.

Expected Deliverables

• Full acquisition underwriting model
• Historical financial normalization
• Revenue and expense projections
• Debt sizing analysis
• Sources & uses
• CapEx/PIP schedules
• IRR and MOIC analysis
• Cash-on-cash analysis
• Base/upside/downside cases
• Sensitivity tables
• Market and competitive analysis
• Investment Committee exhibits
• Investment Memorandum analytical support
• Updated underwriting throughout diligence

Work Location: Hybrid remote in Ahmedabad, Gujarat

Compensation: 40,000.00 - 65,000.00 per month

Work Location: Hybrid remote in Ahmedabad, Gujarat.