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 yearly basis.
Simple to handle, with only 4 tabs: i) Dashboard & output, ii) Assumptions, iii) Consolidated Cashflows and iv) Debt.
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: Chuttersnap