Hey welcome to Big4WallStreet !
The models available might be used by companies, individuals or educators that would like to upgrade their existing models (check our models in various industries here)
Our 12-year experience in the finance industry secures that our models are professionally made with the end user in mind.
Furthermore these models can be tailor made upon your request in order to meet any special requirements for your projects should you not find something that suits you (check our services for our rates here).
Most importantly, these models have been designed for the busy professional / student / aspiring financial analyst to fit smoothly into his schedule and to be as time efficient as possible.
In all the models you will receive, we conform to the following principles, and we would advise you to do the same when modeling:
Structure your models, take a paper and draw a logical flow for your model. This might be cumbersome in the beginning but it will prove useful for you and others when your models reach insane complexity!!!
Separate inputs from outputs, you won't be able to easily track your inputs if model them in a random way. Especially when it's 2 am and you have to deliver by 6 am.
Color coding to distinguish between historical data, inputs, call ups and calculations. You don’t want to search your 3000 lines model for inputs, when your manager asks you for a weird scenario analysis.
Be consistent with formats, fonts, timeline etc. This will save you considerable time when performing repetitive work and will also be more presentable to your clients.
Model as simply as possible. Small formulas, small errors, better tractability and audit. If you want to do something complex break it down to more steps.
No data links. Avoid any links to other models. Try to have everything you need in the same workbook.
Perform checks. 90% of the models used in the industry do not have logical checks in place.
During the buildup of the model take notes in order to be able to come up with a mini model manual.
After finishing your model, before handing it always stress test the inputs in order to see any irregularities in the outputs.
Always assign a responsible that will be in charge of the model use / updates. The more people on the model, the more the issues that arise.
In case you want to be one of the first to hear news from us don't forget to subscribe here.
That's it ! Thank you for your time!
Hotel Financial Excel Model and Valuation Template
Hotel financial Excel model which generates the 3 financial statements as well as a valuation (incl. sensitivity analysis). The model structure is as follows:Timing: main conventions used in the model + 5 scenarios that can be used in order to evaluate the business plan and valuation.Inputs (in yellow whatever can...