Single asset office model with cashflow projections over a period of 10 years. Key assumptions are dynamically built into the model, and can be flexibly tailored to analyse any other hotel assets of interest. 
 
10 year forecast period, with projections and calculations done on a quarterly basis. Allows for more complex analysis / more specific cashflow projections.
Simple to handle, with only 6 tabs: i) Dashboard & output, ii) Assumptions, iii) Consolidated Cashflows, iv) Debt, v) Rent Roll, vi) Leasing Schedule.
Detailed rent roll sheet and leasing schedule: Allows for inputs of up to 40 tenants. Dynamic and provides for tenancy renewals, rent free and downtime inputs, and change in rents upon renewals.
Assumptions can be easily tweaked to suit your asset of interest: Input cells (in yellow) can be easily and quickly tweaked in minutes to generate an underwriting model for your asset of interest.
Output focused model to facilitate ease of analysis (refer to the “Dashboard & Output” tab):
Includes a neat and simple summary of the key investment assumptions and metrics (eg. LTV, entry yield).
Displays typical investment profit metrics to such as IRR, Equity Multiple, Yield-on-Cost vs Cap Rate, profit psf, and annual cash-on-cash return.
Model guides: Comments (hidden in grouped columns) are included to guide you in your use of the model.
 
Please reach out if you have any questions on the model functionality, and how it can be tweaked to suit your specific asset of interest. Always here to help!
 
Thumbnail image credit: Dylan Nolte