Stabilized hotel screening

Hotel Quick

Run a compact hotel underwriting using the audited select-service profile.

Quick assumptions

Property economics

Model name A name for this synthetic underwriting.

Keys Available hotel rooms.

Purchase price Acquisition price before closing costs.

PIP Property improvement plan capital.

Revenue mode Choose how current room revenue is supplied.

Current occupancy (decimal) Enter 0.643 for 64.3%.

Current ADR Current average daily rate.

Stabilized occupancy (decimal) Target occupancy after stabilization.

Stabilized ADR Target average daily rate.

Stabilization months Months to reach stabilized assumptions.

Projection months One to 360 monthly periods.

Audited profile

Profile ID Default illustrative_v1 · Hotel Quick v1 illustrative assumption: profile_id

Profile version 1 Default illustrative_v1 · Hotel Quick v1 illustrative assumption: profile_version

Debt Summary

Debt Ltv Default Jai calculator · calculator input: debt_ltv

Debt Rate Default Jai calculator · calculator input: debt_rate

Amortization Months Default Jai calculator · calculator input: amortization_months

Loan Term Months Default Jai calculator · calculator input: loan_term_months

Valuation Cap Rate Default Jai calculator · calculator input: valuation_cap_rate

Minimum Dscr Default illustrative_v1 · Hotel Quick v1 illustrative assumption: minimum_dscr

Interest Only Months Default illustrative_v1 · Hotel Quick v1 illustrative assumption: interest_only_months

Advanced assumptions

Operating, sources and scenario assumptions

Fb Revenue Pct Room Default Hyatt 3-pack manager pro forma · manager pro forma operating assumption: fb_revenue_pct_room

Other Revenue Pct Room Default Hyatt 3-pack manager pro forma · manager pro forma operating assumption: other_revenue_pct_room

Room Department Expense Pct Room Default Hyatt 3-pack manager pro forma · manager pro forma operating assumption: room_department_expense_pct_room

Fb Department Expense Pct Fb Default Hyatt 3-pack manager pro forma · manager pro forma operating assumption: fb_department_expense_pct_fb

Other Department Expense Pct Other Default Hyatt 3-pack manager pro forma · manager pro forma operating assumption: other_department_expense_pct_other

Ga Pct Total Revenue Default Hyatt 3-pack manager pro forma · manager pro forma operating assumption: ga_pct_total_revenue

Sales Marketing Pct Total Revenue Default Hyatt 3-pack manager pro forma · manager pro forma operating assumption: sales_marketing_pct_total_revenue

Franchise Pct Room Revenue Default Hyatt 3-pack manager pro forma · manager pro forma operating assumption: franchise_pct_room_revenue

Repairs Maintenance Pct Total Revenue Default Hyatt 3-pack manager pro forma · manager pro forma operating assumption: repairs_maintenance_pct_total_revenue

Utilities Pct Total Revenue Default Hyatt 3-pack manager pro forma · manager pro forma operating assumption: utilities_pct_total_revenue

Management Fee Pct Total Revenue Default Hyatt 3-pack manager pro forma · manager pro forma operating assumption: management_fee_pct_total_revenue

Property Tax Pct Total Revenue Default Hyatt 3-pack manager pro forma · manager pro forma operating assumption: property_tax_pct_total_revenue

Insurance Pct Total Revenue Default Hyatt 3-pack manager pro forma · manager pro forma operating assumption: insurance_pct_total_revenue

Ff And E Pct Total Revenue Default Hyatt 3-pack manager pro forma · manager pro forma operating assumption: ff_and_e_pct_total_revenue

Adr Growth Rate Default illustrative_v1 · Hotel Quick v1 illustrative assumption: adr_growth_rate

Fixed Expense Growth Rate Default illustrative_v1 · Hotel Quick v1 illustrative assumption: fixed_expense_growth_rate

Closing Cost Pct Purchase Default illustrative_v1 · Hotel Quick v1 illustrative assumption: closing_cost_pct_purchase

Working Capital Per Key Default Suraj screening workbook · screening sources and uses: working_capital_per_key

Operating Deficit Reserve Per Key Default Suraj screening workbook · screening sources and uses: operating_deficit_reserve_per_key

Financing Fee Pct Loan Default illustrative_v1 · Hotel Quick v1 illustrative assumption: financing_fee_pct_loan

Disposition Cost Pct Default illustrative_v1 · Hotel Quick v1 illustrative assumption: disposition_cost_pct

Soft Occupancy Delta Default illustrative_v1 · Hotel Quick v1 illustrative assumption: soft_occupancy_delta

Soft Adr Multiplier Default illustrative_v1 · Hotel Quick v1 illustrative assumption: soft_adr_multiplier

Soft Other Undistributed Delta Default illustrative_v1 · Hotel Quick v1 illustrative assumption: soft_other_undistributed_delta

Hard Occupancy Delta Default illustrative_v1 · Hotel Quick v1 illustrative assumption: hard_occupancy_delta

Hard Adr Multiplier Default illustrative_v1 · Hotel Quick v1 illustrative assumption: hard_adr_multiplier

Hard Other Undistributed Delta Default illustrative_v1 · Hotel Quick v1 illustrative assumption: hard_other_undistributed_delta

Fund Acquisition Fee Pct Purchase Default illustrative_v1 · Hotel Quick v1 illustrative assumption: fund_acquisition_fee_pct_purchase

Loan Sizing Basis Default illustrative_v1 · Hotel Quick v1 illustrative assumption: loan_sizing_basis

Other Uses Default illustrative_v1 · Hotel Quick v1 illustrative assumption: other_uses

Other Sources Default illustrative_v1 · Hotel Quick v1 illustrative assumption: other_sources

Sale Month Default illustrative_v1 · Hotel Quick v1 illustrative assumption: sale_month

Reserve Release Month Default illustrative_v1 · Hotel Quick v1 illustrative assumption: reserve_release_month

Server-calculated

Key results

Monthly P&L at stabilization start

Server-returned operating bridge for the stabilization-start month
Line item	Monthly value

Scenario comparison

Base, soft and hard server-returned scenarios
Scenario	Occupancy	ADR	Stabilized NOI	DSCR	Indicated value

Monthly cash flow

Monthly operating, debt and equity cash flow returned by the server
Month	Revenue	NOI before FF&E	NOI after FF&E	Debt service	After-debt cash	Equity contribution	Distribution	Ending debt	Net liquidation value

Hotel Quick

Hotel Quick

Quick assumptions

Key results

Monthly P&L at stabilization start

Scenario comparison

Monthly cash flow

Model checks