Real Estate Models for Hotel Properties - Adventures in CRE https://www.adventuresincre.com/re-modeling/excel-models/hotel/ Real Estate: AI, Financial Modeling, Careers, Education Wed, 02 Jul 2025 21:17:07 +0000 en-US hourly 1 https://wordpress.org/?v=6.8.2 https://www.adventuresincre.com/wp-content/uploads/2021/09/green-background-36x36.png Real Estate Models for Hotel Properties - Adventures in CRE https://www.adventuresincre.com/re-modeling/excel-models/hotel/ 32 32 Case Study #5 – The Jefferson Branded Condo Development – Case Only (Updated June 2024) https://www.adventuresincre.com/case-study-5-the-jefferson-branded-condo-development/ Tue, 04 Jun 2024 16:00:47 +0000 https://www.adventuresincre.com/case-study-4-the-stones-hotel-copy/ This is the fifth in a series of commercial real estate case studies shared by A.CRE. These case studies are meant to help you practice to master real estate financial modeling. The Jefferson Branded Condo Development puts you in the position of boutique condo developer considering investing in a to-be-built branded condo project. You are […]

The post Case Study #5 – The Jefferson Branded Condo Development – Case Only (Updated June 2024) appeared first on Adventures in CRE.

]]>
Hotel Development Model (Updated February 2024) https://www.adventuresincre.com/hotel-development-model/ Thu, 01 Feb 2024 13:00:41 +0000 https://www.adventuresincre.com/?p=94869 Excited to share the new A.CRE Hotel Development Model with everyone. As evidenced by the numerous requests we have gotten for this over the years, this model is long overdue so I’m quite happy to get it out there finally. At the core, the hotel development model is basically a hybrid of our Hotel Acquisition […]

The post Hotel Development Model (Updated February 2024) appeared first on Adventures in CRE.

]]>
Actual + Forecast Construction Draw Schedule with S-Curve (Updated Dec 2023) https://www.adventuresincre.com/actual-forecast-construction-draw-schedule-with-s-curve/ Wed, 20 Dec 2023 01:12:50 +0000 https://www.adventuresincre.com/?p=9275 Several times in the last month, I’ve been asked to tackle an interesting real estate financial modeling challenge – pare actual construction draw cash flows with s-curve cash flow forecasts to create an Actuals + Forecast Construction Draw schedule. The real challenge in this exercise, is to have the actual construction draws transition into the […]

The post Actual + Forecast Construction Draw Schedule with S-Curve (Updated Dec 2023) appeared first on Adventures in CRE.

]]>
A.CRE Hotel Valuation Model in Excel (Updated Sept 2022) https://www.adventuresincre.com/hotel-valuation-model/ Mon, 05 Sep 2022 14:00:56 +0000 https://www.adventuresincre.com/?p=17412 I am excited to introduce our new Hotel Valuation (Acquisition) Model to underwrite both stabilized and value-add hotel opportunities. This hotel pro forma is designed to allow users to do everything from a quick back of the envelope exercise to a fulsome and detailed underwriting exercise in which the user can get into the weeds […]

The post A.CRE Hotel Valuation Model in Excel (Updated Sept 2022) appeared first on Adventures in CRE.

]]>
Development Draw Schedule – Visually Customize Each Line Item (UPDATED APR 2022) https://www.adventuresincre.com/draw-schedule-custom-cash-flows/ Tue, 26 Apr 2022 13:00:52 +0000 https://www.adventuresincre.com/?p=8803 Working a lot with development draw schedules, I have always been looking for a catch all solution as to how one could easily model all the unique ways cash actually flows over time during the process. The norm for many is to model cash flows using a straight line method with even payments over time, […]

The post Development Draw Schedule – Visually Customize Each Line Item (UPDATED APR 2022) appeared first on Adventures in CRE.

]]>
Hotel Acquisition Model – The Basic Model (Updated 10.9.2019) https://www.adventuresincre.com/basic-hotel-acquisition-model/ Wed, 09 Oct 2019 05:42:45 +0000 https://www.adventuresincre.com/?p=80525 The initial goal for the original Hotel Acquisition Model was to design a hotel proforma that would enable users to get deep into the weeds of practically every line item in their hotel analysis. Although I am super happy with how that hotel proforma has turned out, there are many instances where that model may […]

The post Hotel Acquisition Model – The Basic Model (Updated 10.9.2019) appeared first on Adventures in CRE.

]]>
Tutorials For The Hotel Valuation Model (Updated 07.23.19) https://www.adventuresincre.com/hotel-valuation-model-tutorials/ Tue, 23 Jul 2019 18:05:41 +0000 https://www.adventuresincre.com/?p=19106 Welcome to the A.CRE Hotel Valuation Model‘s Tutorial Page. On this page you will find all the tutorials for the A.CRE Hotel Valuation model in Excel. There is a lot to learn within this model and over time, I’d like to show you both how to use it as well as how I built it. […]

The post Tutorials For The Hotel Valuation Model (Updated 07.23.19) appeared first on Adventures in CRE.

]]>
Hotel Proforma Basics – Hotel Cash Flow Projection https://www.adventuresincre.com/hotel-proforma-basics-hotel-cash-flow-projection/ Wed, 12 Dec 2018 05:04:42 +0000 https://www.adventuresincre.com/?p=19020 Hotels are a unique asset in the commercial real estate world and are underwritten differently as a result. Probably the most obvious difference is the duration of the ‘lease term’ of the tenant, which is usually daily to weekly. Another major difference is that hotels are more operating intensive and typically contain other complimentary services […]

The post Hotel Proforma Basics – Hotel Cash Flow Projection appeared first on Adventures in CRE.

]]>
Hotel Value-Add Assignment Example https://www.adventuresincre.com/hotel-valuation-model-assignment/ Thu, 16 Apr 2015 11:12:41 +0000 http://www.spencerburton.org/blog/?p=193 I built this multi-scenario , value-add hotel investmentĀ model from scratch in Excel for an assignment in one of my real estate finance courses at Cornell. Keep in mind, this model is not plug-and-chug ready. However, with a few tweaks it works great for both back-of-the-envelope, and more detailed financial analysis. This model is an example […]

The post Hotel Value-Add Assignment Example appeared first on Adventures in CRE.

]]>