Hotel Acquisition Model (HOTA010)
Hotel Acquisition Model (HOTA010)
$1,550.00
TSM’s Excel-based model for Hotel Acquisition. We know it works because we have used it ourselves to underwrite over $1.0 Billion in transactions.
This model contains base +2 tiers of Waterfall Calculations, with mezzanine debt, and with ability to refinance.
The model is a 100% unlocked Excel file with fully transparent formulas. The TSM real estate financial model will be precise and error free. While it is fully customizable, we are confident you won’t need to make time-consuming adjustments because we have done everything for you.
The purchase includes a 1-hour complimentary consultation with the analyst that developed the model - valued at $250.
The base model includes the following features:
Investor Summary - Printable 2-page formatted summary with return calculations
Model Outputs - used for investor relations reports/packages and includes sources/uses, capital stack, hypothetical investor returns, equity walk, etc.
Error check - allows for quick insight into the accuracy of the financial model
Assumptions - general assumptions, hotel specs, room breakdown, operating assumptions, timing assumptions, annual inflation control, annual expense margin control, disruption capabilities, exit assumptions, construction debt, permanent debt, and waterfall assumptions. Also includes sensitivity table
Hotel Ops - industry standard hotel operations breakout to calculate NOI and EBITDA
Construction Budget - with ability to control timing on each specific line item and select if the calculation is fixed, $/sf, $/key or percentage (%)
Monthly Cashflow - with hyperlinks, circular break, and detailed analysis of unlevered and levered cashflows
Annual Cashflow - with hyperlinks and detailed analysis of unlevered and levered cashflows
Waterfall - with the number of tiers selected in the custom model builder
Comp - Hotel - ability to project future business plan based on penetration analysis of competitive hotel set for Occupancy, ADR, and RevPAR
STR - Data - insert data from STR Trend report to analyze subject property to the competitive set
STR - Hotel - Response Report from STR Trend report
LIBOR - forward LIBOR curve used for floating rate debt
Instruction Manual - Embedded manual to assist in using the model