Key Features of Estate Master HF

Data Entry

• User friendly spreadsheet input environment allowing you to create custom formulas, links to other worksheets or run your own Microsoft.
• Single data entry area that contains all your assumptions which drives the rest of the program.
• Menu and toolbar that allows you to run all the major functions of the software from one location - sensitivity analysis, refreshing charts, inserting worksheets, printing, etc.
• Input preference tool to set currency options, hurdle rate assumptions and other general preferences.
• Facility to insert additional worksheets to assist you in customising the program to your personal requirements.
• 10-year cash flows with variable acquisition and disposal dates.
• Lower risk of errors with background calculations checking and correcting input errors, cell validation and warnings to highlight data input errors.

Hotel Cost and Revenue Assumptions

• Enter acquisition costs such as:
  • Land Acquisition
  • Construction Costs
  • Pre Opening Expenses
  • Development Profit
• Enter Hotel revenues such as:
  • Room Revenue
  • F&B income
  • Meeting Space Income
  • Income from other operating departments
• Enter Base Management and Incentive fees
• Apply up to 10 years of escalation  rates on all costs and revenues.

Financing

• Nominate equity/debt financing structure on an interest only or Principal and Interest method.
• Enable the reporting of KPI’s on an unleveraged or leveraged basis. 

Performance Analysis

• Summary Report which includes analysis of stabilized years income
• Key performance indicators such as such as net present value, internal rate of return, return on capital employed (ROCE), etc.

Advanced Functions

• Ability to store and recall up to 8 options/ stages in one file for comparison/consolidation purposes.
• Consolidate report to enable the user to compare multiple development options or view consolidated stages of a single project.
• Sensitivity analysis of development variables such as acquisition costs, room revenue, occupancy levels, terminal yields etc.

For a printable version of our Key Features, please download our Datasheet