Hotel Industry Templates

This financial model gives a classic and complete 360 degree view of Construction of a Hotel by taking Construction loan with option of refinancing. If you are acquiring a boutique Hotel and going for reconstruction of the same, this template will be useful to you.

Construction of such properties requires lot of capital expenditure. A construction loan is a short-term loan used to finance the building of a home or another real estate project. Considering the level of risk involved in such business, the builder or home buyer takes out a construction loan to cover the costs of the project before obtaining long-term funding. This template is a reference for taking such loans with refinance.

Key features of this template are:

This template is made considering the construction period of one year and post period hotel operations are taken for 5 years. The acquisition of funds, here are considered from three sources: Senior Debt, Junior Debt and a proportion in Equity. In this template we have taken Construction cost that is divided in two parts: Soft costs and hard costs.

We have taken interest reserve calculation in one of the tab (Interest Reserve is used to pay interest during the construction period). Also, we have created a capability to change the month of opting for refinancing in assumptions tab. This you can change according to the current condition of the business, exit cap rate, etc.

This template covers all the financials implications that arise in case of a construction loan with refinancing. You can make important financial decisions easily with the help of this model.

As an owner/ investor you would most likely want to test the feasibility of the project, chances of recovery of principal as well as interest amount on loan, determine if this business has potential to bring you your desired level of income in the given time frame or not.
If this is what you have in mind, then you are looking at the right financial model template. You just need to tweak it a little, based on your construction scenario and this will provide you with the projected figures for the next 5-6 years including calculation of construction budget, Interest reserves, Debt service coverage ratio, Investment returns, etc.