Real Estate Financial Modeling Tools

Standard Version: Hotel Ground-Up Development Pro-Forma Template



Academic / U.S. Military Price

To get discounted pricing, click Credentials Verification in the header and follow the instructions. Once you are approved, the discounted pricing will show.

 Download Sample PDF Reports

SKU: SKU-390-1 Categories: , Tags: ,

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)


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

Need more power or flexibility?
Support Level

Standard Support, Priority Support

20% Off for Limited Time Use Coupon Code: holiday22
left to take 50% off with coupon code: yearend50