Publication number: ELQ-70604-1
View all versions & Certificate
Hotel Development Project Excel Financial Model
Excel financial modeling template for a Hotel Development business plan, using the DCF method approach.
This model is for educational purposes. You can edit it for your own plan but you must first read the guide to edit my template.
Indicators for the business plan included are: Net Present Value, Internal Rates of Return, Average Projection Break Event Point, Pay Back Period, Discounted Pay Back Period and PI on feasibility tab.
Hotel Operation Ratio, Financial Ratio on Ratio Tab and Sensitivity Analysis on sensitivity tab.
About this model:
This financial model is for learning purposes, and not for a profit business purpose. As the creator I do not take responsibility about misjudgment assumptions.
Cases in which the Model can be used:
1. Project financing for hotel development
2. Discount factor use investment loan interest, not use WACC formula
3. Hotel development will be completed at 2020
4. Hotel operations will start at 2021
5. Growth price and cost is 5% each year
6. Use Indonesia currency and interest rate
How to edit the template?
1. You cannot edit the Excel formula in cell
2. You must input manually the value or number (hard code) in the cell fill with green colour, but don’t edit or delete formula that contain words that refer to another cell
3. You do not delete row or column, if you delete, it will result in error
4. You do not cut row, column or cell, if you delete, it will result in error
5. You can copy cell
6. You can insert rows or columns but beware remember about the equation type function, (sum or only +) and formula range
7. You may edit cells that I mark with red font according your business plan
This template is latest version available.
This Best Practice includes
1 PDF File and 1 Spreadsheet Excel Template
Acquire business license for $3.00
Add to cart
Add to bookmarks
- Be the first to review this Downloadable Best Practice
Write a review
People using this Best Practice also downloaded
Mobile App Startup Excel Financial Model TemplateA complete mobile app startup financial model excel template for you to build your own from.business planstartupfinancial projectionsfinancial modelingfinancial statements4,798add_shopping_cart
2016 Round 1, Section 4: Going Around In CirclesExcel training/competition model from the 2016 Financial Modeling World Championshipscompetitionfinancial modelingexcel trainingmodeloffmodel training186add_shopping_cart
2016 Round 1, Section 3: Roll the DiceExcel training/competition model from the 2016 Financial Modeling World Championshipscompetitionfinancial modelingexcel trainingfinancial modeling trainingmodeloff235add_shopping_cart
2013 Round 2: Data AnalysisExcel training/competition model from the 2013 Financial Modeling World Championshipsfinancial modelingexcel skillsexcel trainingfinancial modeling trainingfinancial modeling competition265add_shopping_cart
Telecoms Financial ModelTelecom Financial Model presents the case of an already operating business in the telecom sector (mobile communications,financial modelfinancial modelinginternetexcelmobile739add_shopping_cart
2015 Round 1: TaxExcel training/competition model from the 2015 Financial Modeling World Championshipsfinancial modelingexcel skillsfinancial modeling skillsfinancial modeling trainingworld championships172add_shopping_cart
2015 Round 2: The Price Is RightExcel training/competition model from the 2015 Financial Modeling World Championshipsexpensesfinancial modelingcash flow statementexcel skillsexcel training216add_shopping_cart
DCF Model of a Pharma CompanyThis is the Discounted Cash Flow Model of DR. Reddy's Laboratories (India) prepared in October 2020dcffinancial modelingdiscounted cash flowpharmaceutical company417add_shopping_cart
Author Case Study: Lance RubinDiscover the story of Eloquens Author Lance Rubin and how Eloquens.com has been useful for him.case studyfinancial modelingmarketplacefinancial modelsauthor155
2015 Round 1: Bread and ButterExcel training/competition model from the 2015 Financial Modeling World Championshipsp&lirrbalance sheetfinancial modelingcash flow statement704add_shopping_cart
Any questions on Hotel Development Project Excel Financial Model?
The user community and author are here to help. Go ahead!