Hotel/Guesthouse/Resort Development Model and Valuation – 20 year Three Statement Analysis

This Hotel / Holiday Resort Development Model will take you through a 20-year period of Three Statement Analysis and provide you with key valuation data. We have now brought a Business Plan Template into the Business Model for ease of use, and have automated the import of certain Financial Data from your Business Model into the Business Plan. The model also caters to the Investor’s Data and Analysis and also takes into consideration the CGT effects on exit values and the resultant IRR and NPV. The easy-to-use and coherent Input sheet will guide you every step of the way.

, , , , , , , ,
, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

This Hotel / Holiday Resort Development Model will take you through a 20-year period of Three Statement Analysis and Provide you with key valuation data.

The Input fields are simple and understandable, the same as the Data provided in the Cash Flow Statements, Income Statements, and Balance Sheets. Another great feature is the Basic Business Plan, with some of the Financial Data automatically imported from your Business Model into the Business Plan.

One of the key elements of this model is the ability to time your development costs as they happen and within a certain number of months within your tax cycle to provide accurate analysis. You are also able to time your revenue to start period within certain tax periods depending on how long it takes for the development to become operational.

We make use of the PE RATIO methodology to continually re-evaluate the Hotel according to its Net Operating Income generated. The Dashboard and Valuation Sheet provides you with key valuation formulae such as NPV and IRR.

The Model allows you to provide for annual income escalations generated as well as expenditure increments. The Balance Sheets contain an annual re-valuation account, which makes use of the cost method until the PE RATIO method exceeds the development costs.

The model also makes use of separate expenditures for the Suites and the Food and Beverage Restaurant and Entertainment aspects of the Hotel or Resort. You are easily able to ascertain the net contributions generated from the Suites compared to the Entertainment aspect.

There is a built-in Loan Amortization dependent on the level of finance required, and the balance or shortfall is brought into the owner’s loan account.

The model will provide you with an excellent idea of the viability of developing Hotels and the ongoing valuation thereof.

You must log in to submit a review.