An Excel-based analysis tool for the ground-up development, operation and ultimate disposition of a hotel. The model is monthly in nature. It is a 100% unlocked Excel file with fully transparent formulas that can be further tailored to suit the particulars of your transactions.
User-friendly Features
- Compatible with both PC and Mac
- Includes instructions for use, with detailed annotations tied to select cells
- Two-page assumptions input and reporting screen optimized for dashboard-style viewing
- Persistent calculation checks and data validation protections to prevent faulty inputs
- Hyperlink navigation enables fast, intuitive access to all tabs
- Institutional-quality print-ready reporting tabs that are brandable to your company
- S-Curve distribution of Soft Costs by individual line item
- No circular references impacting the calculation of the construction loan size and funded interest
- Includes copy/paste tab for “next buyer” analysis to be housed and presented in REFM’s Valuate® web-based software
Functional Highlights
The model supports the following:
- Levels of service up through Full Service properties
- Land loan, one layer of construction financing, an interim loan, and a permanent loan
- Up to two joint venture equity partnership players, payable through an IRR-based Preferred Return and a single residual cash flow split.
Model Tabs
1 Back of the Envelope Model
2 Assumptions Input
3 Capital Structure Exhibit
4 Monthly Development Sources and Uses of Funds Input
5 Monthly Cash Flow Exhibit
6 Annual Sources and Uses of Funds Summary Exhibit
7 Annual Cash Flow Exhibit
8 Joint Venture Partnership Structure Input
9 Monthly Profit Sharing Exhibit
10 Joint Venture Partnership Returns Summary Exhibit
11 Transaction Summary Exhibit
12-13 Interim Loan Amortization Table Exhibits
14-15 Permanent Loan Amortization Table Exhibits
16 Soft Costs Budget Schedule Input
17 Hard Costs Budget Schedule Input
18 Construction Bell Curve Lookup Table
Model Timeline
15 years (expandable)
Reports
Print-ready, brandable reports are included in the model. See the Sample Reports link above.
License Type And Multiple-User Pricing
Licenses are sold on a per-user basis
Multi-user pricing quotes are available here
Included With Purchase
- Blank template (inputs are all set to zero) and a version of the template with a sample deal loaded in
- 1 year of online ticket-based support
- Ability to upgrade to the Pro model by just paying the difference in price