Pro Excel: Finance &amp; Investment

Hotel Three-Statement Budget Model

Monthly hotel budget with a linked P&L, balance sheet and cash flow

Hotel Market Demand & Fair-Share Occupancy Projection

fair-share hotel feasibility model with a 5-year occupancy forecast

Hotel Development Budget & Construction Draw Schedule

hotel development cost budget with S-curve construction draws

Hotel Development JV Equity Waterfall Model

JV equity waterfall with pref, catch-up, IRR hurdles and promote

Hotel Acquisition DCF & Valuation Model

10-year hotel DCF with IRR, NPV and sensitivity grids

Hotel Owner Monthly Report Builder with Departmental Schedules

monthly owner report and departmental P&L template for hotels

Hotel Portfolio Consolidation & Ranking Dashboard

Multi-Hotel Consolidation Excel with KPI Ranking and Variance Analysis

Branded Residence Rental Pool Distribution Model

Condo-hotel rental pool distribution, owner statements and yield

Hotel Lease vs Management vs Franchise Comparison Model

compare hotel operating structures on owner NPV, IRR and risk

Hotel Hold vs Sell Decision Model

sell the hotel now or hold it 3, 5 or 7 more years

Hotel Debt Sizing & Loan Covenant Model

hotel loan sizing with DSCR, LTV and debt yield covenant tests

Hotel Labour Productivity Standards & Payroll Budget Model

Build the hotel payroll budget from labour standards, not last year

Hotel Rooms Renovation Displacement & Payback Model

Phased hotel renovation displacement, payback, NPV and IRR in Excel

Hotel Fixed-Variable Cost Regression & Break-Even Analyzer

Hotel Cost Regression Model and Break-Even Occupancy Calculator

Hotel FF&E Reserve Adequacy & 20-Year Lifecycle Model

FF&E reserve study and 20-year replacement plan for hotels

Hotel Management Agreement Performance Test Calculator

two-part GOP and RevPAR index operator performance test

$10.40~~$13~~ DOCX / PDF / XLSX

Hotel Foreign Exchange Exposure & Rate Parity Calculator

FX exposure, hedge ratio and currency rate parity model for hotels

Hotel Fixed Asset Register & Depreciation Schedule

Hotel Fixed Asset Register Excel with Depreciation Schedule and Book vs Tax

Hotel Financial Ratio & Benchmark Analysis Toolkit

Hotel Financial Ratio Analysis Excel with Benchmark Bands and Red Flags

$9.60~~$12~~ DOCX / PDF / XLSX

Hotel Capex Project Appraisal Toolkit

rank hotel capex projects on NPV, IRR, payback and PI

$9.60~~$12~~ DOCX / PDF / XLSX

Hotel Franchise Total Cost of Affiliation Calculator

franchise fee calculator with break-even RevPAR premium

Hotel City Ledger Aging & Bad Debt Provision Model

hotel accounts receivable aging and bad debt provision template

Hotel Variance Bridge & Flow-Through Analyzer

hotel budget vs actual variance analysis with GOP bridge

Hotel Cost of Capital & Discount Rate Builder

WACC and discount rate model for hotel valuations

$8.80~~$11~~ XLSX