Hotel Development Model - 20 year Three Statement Analysis and Valuation

Description
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 added a Business Plan template and imported some financial data into your business plan in order to save time. The Input fields are simple and understandable, the same as the Data provided in the Cash Flow Statements, Income Statements, and Balance Sheets. One of the key elements of this model is the ability to time your development costs as they happen and within a certain no, 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.