Back to News

Video example: profitability analysis of a Hotel construction investment project

Watch a 10-minute video tutorial to learn how to create and analyze a Real Estate investment project. In this tutorial, we will take a look at a Hotel construction example. Assume that we are planning to build a 4-star hotel with 50 rooms and we would like to understand how profitable this project would be.

For that, we will use Invest for Excel software, which according to the Invest for Excel users “speeds up work, eliminates errors and provides a professional result”.

Hotel construction profitability appraisal video

Calculation file structure:

1. Financial modelling

  • Step 1. Basic Values – (00:50)
  • Step 2. Investment Table – (01:47)
  • Step 3. Income Statement – (03:06)
  • Step 4. Working Capital – (04:37)
  • Step 5. Cash Flow Statement and Balance Sheet – (04:15)

2. Analysis:

  • Result Screen – (06:35)
  • Break-even Analysis – (07:18)
  • Sensitivity Analysis – (08:02)
  • Charts – (09:01)
  • Comparison Table – (09:41)