Position Summary

Overlook Global is seeking a Senior Investment Analyst – Financial Modeling & Underwriting to support the acquisition and investment analysis of hospitality real estate opportunities.

The Analyst will be responsible for building and maintaining detailed acquisition underwriting models, analyzing historical hotel performance, forecasting operations, structuring debt, evaluating downside scenarios, calculating investment returns, and preparing investment materials for senior management and Investment Committee review.

The position requires more than simply building Excel models. The Analyst must be able to determine:

What is the hotel worth?
What should Overlook pay?
How much debt should we use?
What operational assumptions are realistic?
What happens if the business plan fails?
What return will investors actually earn?
Should Overlook buy, renegotiate, or pass?

Key Responsibilities

Acquisition Underwriting

- Build comprehensive acquisition and development financial models from the ground up.
- Analyze historical hotel operating statements and normalize financial performance.
- Spread monthly and annual P&Ls; into standardized underwriting templates.
- Evaluate historical Occupancy, ADR, RevPAR, GOP, EBITDA/NOI and operating margins.
- Identify non-recurring revenues, expenses, owner adjustments and questionable seller assumptions.
- Develop stabilized operating assumptions based on property history, market conditions and the proposed business plan.

Revenue & Operating Forecasting

- Forecast:
- Occupancy
- ADR
- RevPAR
- Rooms revenue
- Other hotel revenue
- Departmental expenses
- Labor expenses
- Franchise and management fees
- Utilities
- Insurance
- Property taxes
- FF&E; reserves
- Other operating expenses
- Build base, upside and downside operating scenarios.
- Analyze margin expansion opportunities and operating leverage.

Debt & Capital Structure Analysis

- Size debt based on:
- LTV
- LTC
- DSCR
- Debt yield
- Model fixed and floating interest rates.
- Model amortization and interest-only periods.
- Model lender fees, reserves and closing costs.
- Compare bank, bridge, CMBS,



debt-fund and other financing structures where appropriate.
- Evaluate refinance scenarios and potential return of equity.
- Determine how different debt structures affect investment returns and downside risk.

Investment Return Analysis

- Calculate and analyze:
- Levered IRR
- Unlevered IRR
- MOIC
- Cash-on-cash return
- Equity multiple
- Yield on cost
- Debt yield
- DSCR
- Break-even occupancy
- Model annual and cumulative cash distributions.
- Analyze sensitivity to purchase price, ADR, occupancy, margins, interest rates and exit cap rates.

CapEx & PIP Underwriting

- Incorporate hotel PIP requirements into acquisition underwriting.
- Prepare CapEx schedules.
- Model renovation timing and disruption.
- Analyze ROI from renovations and property improvements.
- Determine additional working-capital and reserve requirements.

Market & Competitive Analysis

- Analyze STR reports and competitive sets.
- Review supply pipeline and market demand.
- Analyze comparable hotel transactions.
- Research demand generators and market risks.
- Evaluate brand, location and competitive positioning.
- Support development of reasonable occupancy and ADR assumptions.

Exit & Refinance Analysis

- Model alternative exit scenarios.
- Evaluate different hold periods.
- Analyze exit-cap-rate sensitivities.
- Model refinance opportunities.
- Calculate equity returned through refinancing.
- Evaluate hold versus refinance versus sale decisions.

Investment Committee Materials

- Prepare financial exhibits for Investment Committee.
- Produce sensitivity tables and downside cases.
- Prepare charts and analytical summaries.
- Clearly identify:
- Investment thesis
- Key assumptions
- Key risks
- Downside protection
- Return expectations
- Recommended purchase price
- Walk-away price





Due Diligence Support

The analyst should help review and organize:

- Historical P&Ls;
- TTM financials
- Budgets and forecasts
- STR reports
- Franchise agreements
- PIP requirements
- Property tax information
- Insurance
- Debt terms
- Appraisals
- Market studies
- CapEx estimates
- Management agreements
- Comparable transactions

The analyst should actively identify discrepancies between seller information, actual performance and Overlook's underwriting assumptions.

Required Qualifications

- Bachelor's or Master's degree in Finance, Accounting, Economics, Real Estate, Business or related discipline.
- Strong financial modeling and Excel skills.
- Strong financial-statement analysis.
- Understanding of valuation and investment-return concepts.
- Ability to build and audit financial models independently.
- Robust analytical and problem-solving skills.
- Strong written and presentation skills.
- Ability to work accurately under transaction deadlines.

Preferred Qualifications

Experience with hospitality or commercial-real-estate underwriting is highly preferred.

Knowledge of:

STR • CoStar • Trepp • Hotel P&Ls; • USALI • PIP analysis • Cap rates • DSCR • Debt yield • IRR • MOIC • Excel modeling

would be especially valuable.

Expected Deliverables

The team should regularly produce:

- Full acquisition underwriting model
- Historical operating analysis
- Sources & Uses
- Debt sizing analysis
- IRR / MOIC / cash-on-cash analysis
- PIP and CapEx schedule
- Base / upside / downside scenarios
- Purchase-price sensitivity
- Exit-cap sensitivity
- Debt sensitivity
- Investment Committee exhibits
- Recommended bid price
- Maximum/walk-away price
- Written investment recommendation

Pay: ₹25,000.00 - ₹50,000.00 per month

Application Question(s):

- Do you have experience analyzing financial statements, including income statements, balance sheets, and cash-flow statements?

Education:

- Bachelor's (Required)

License/Certification:

- CFA Level 1 (Required)

Work Location: Hybrid remote in Ahmedabad, Gujarat

📌 Financial Modeling | Modeling & Underwriting (Ahmedabad)
🏢 Overlook Global
📍 Ahmedabad