Hotel Investment Appraisal Excel Model Template
Originally published: 26/09/2018 13:41
Last version published: 22/03/2019 15:48
Publication number: ELQ-71744-3
View all versions & Certificate

Hotel Investment Appraisal Excel Model Template

Download this read-to-use Hotel Investment Appraisal to help assess the viability of an investment into a hotel.

This Hotel Investment Appraisal, created by Mahender Kumar Punhani, is presented in an Excel Spreadsheet. It offers an in-depth tool for one to use when attempting to identify whether an investment is worth pursuing, with particular focus on a hotel.

This tool will be useful for those who want a ready-to-use downloadable tool that can assess many different aspects of the viability of the potential investment in a hotel.

There are a range of factors that have been included in this Hotel Investment Appraisal, some of which include:

- Assumptions: This covers the assumptions made on areas such as occupancy rate, average daily rate, revenue breakup, cost of revenue, overhead operational cost and more.

- Income statement: Also included is an income statement, which covers revenue, and covers tax and Return on Investment calculations.

- Cash Flows: Detailed tab incorporating unleveraged cash flows, free cash flow to equity, project IRR and NPV, equity IRR and NPV, land investor IRR and NPV, and construction investor IRR.

- Financing: Yearwise financing for cost of land, cost of permission and cost of construction.

- Sensitivity Analysis

- Loan Amortization Schedule

- Working Capital Requirement: Including inventory, accounts receivable, accounts payable and outstanding overhead operational expenses.

Download this Hotel Investment Appraisal now.

This Best Practice includes
1 Excel Spreadsheet

Acquire business license for $49.00

Add to cart

Add to bookmarks



People using this Best Practice also downloaded


More Best Practices from Mahender K. Punhani

See all

Any questions on Hotel Investment Appraisal Excel Model Template?

The user community and author are here to help. Go ahead!

5.0 / 5 (1 votes)

please wait...