Hotel Conversion Financial Model
Budget: $750 – $1,500 USD
I need a complete investment-valuation model that follows the entire lifecycle of turning a historic property into a boutique hotel and restaurant. The workbook should open with the purchase price, acquisition costs, and my already-identified debt terms, then move through phased construction/renovation spend, and finally roll into a fully linked 10-year operating projection.
Key pieces I expect to see:
• Acquisition, hard & soft costs, and a draw-down schedule that feeds the debt-financing module
• Detailed renovation timeline tied to both the building’s location specifics and its current condition (I’ll supply the data)
• Monthly, then annual, income statements, balance sheets, and cash-flow statements for ten years with clear assumptions tabs
• Debt amortization and covenant tests
• Sensitivity tables for ADR, occupancy, and exit cap rate to gauge equity returns
A clean, well-labeled Excel file is perfect—macros optional but no exotic add-ins, please. I will share the location metrics, building survey, and lender term sheet as soon as we start so the model reflects real numbers rather than placeholders.
Key pieces I expect to see:
• Acquisition, hard & soft costs, and a draw-down schedule that feeds the debt-financing module
• Detailed renovation timeline tied to both the building’s location specifics and its current condition (I’ll supply the data)
• Monthly, then annual, income statements, balance sheets, and cash-flow statements for ten years with clear assumptions tabs
• Debt amortization and covenant tests
• Sensitivity tables for ADR, occupancy, and exit cap rate to gauge equity returns
A clean, well-labeled Excel file is perfect—macros optional but no exotic add-ins, please. I will share the location metrics, building survey, and lender term sheet as soon as we start so the model reflects real numbers rather than placeholders.