Book Your Assignment at The Lowest Price Now

Operational Finance for Hospitality and Tourism

  • 100% Original Document
  • 376+ Ph.D. Certified Writers
  • 4.9 Rated Services

4 Pages 1099 Words 1870 Downloads

Introduction to Financial Modeling

By using this method income statement, balance sheet and cash flow statement is prepared. In the present case by using financial modeling method budget and income statement is prepared. Model that is prepared is highly flexible and integrated in nature which is its big positive point. When one cell in input table will be altered then other values of the output sheet will also changed. Hence, it can be said that every time managers does not need to prepare new budget on paper. They can be changing values of input sheet can prepare new budget.

Way or instruction for use of model

In order to use this model following instructions will be followed.

Inserting input data- In order to prepare budget on this spreadsheet it is very important to enter a value. User of this model can either directly enter values in input sheet section of this model or he may first enter values on paper and thereafter can copy same values in excel sheet. The approach user follow depend on the way in which he feel comfort.

Get Help in Any Subject

Our intention is to help numerous students worldwide through effective and accurate work.


Percentage table- Second table in input sheet is a percentage table in which percentage of cash sale, credit sales, credit purchase and cash purchase will be entered. These cells are linked to the budget and with change in the values of cell in this table entire budget values will get changed. Thus, user in future if any change comes in projected cash and credit sales as well as purchase percentage must make changes in values of variables that are in the percentage table.

Automatic carry forward of values on which credit and debit amount will be computed- This is third important table of the input sheet. Under this table formula of IF function of excel is inserted. In this table values of previous months are carry forward that are related to credit sales and purchase. In order to use this table it is instructed that user must double click on specific value and must change in last two values in formula. For example in case of facilities and room sales one month time is given to debtors. Hence, formula is =IF(C27>C26;C5) and if user think that credit period may change in future then he will make changes in last two values that are C26 and C5. When by replacing these values new cells name will be entered then model will automatically calculate credit sales and purchase. Hence, it is instructed that user must change only last two cell names.
Instruction for use of budget cash flow model- In order to use this model it is instructed that user must not change any formula that is inserted in this model. All cells of this model are linked to input sheet. When values of input sheet will change each and every value in this model will change automatically. Hence, it is instructed to user of this model that any sort of change he must not done on this model.

Instruction for use of P&L statement model- For making use of P&L statement model also it is instructed that user must not make any type of change in this model. All values of this model are linked to the budget model. Hence, change in budget model will directly affect income statement of the firm.

Features built in model

Flexibility- Flexibility is one of the most important feature of this model and under this model is prepared in such a way that new values can also be entered in to budget. It can be seen in the budget given in input table that additional column of other expenses is added in the table (Charnes, 2012). Same thing is added in the output budget sheet. If in future firm wants to add new things in budget then it can enter values in to column and row of other expenses. This model is not rigid and all cells are interlinked to each other. Thus, if change will come in one values all relevant values will automatically get changed. In order to do one change user of the model does not need to change several cells of the spreadsheet. He merely needs to make change in single cell in order to bring changes in values of all variables in which changes are required.

Integration- Integration refers to the interrelationship between different cells. This model is highly integrated in nature and input as well as output sheet are highly integrated to each other (Libman, 2011). Along with this all cells in single output model are connected to each other. Thus, integration among cells is another important feature of this spreadsheet.

Analysis and Interpretation of Financial Performance of an Organization

From analysis of budgeted figures it can be said that firm give good performance in its business. As cash surplus balance of the firm is increasing consistently. If we look at purchase value of food and drink purchase then it can be seen that their values are fluctuation consistent. Some times firm increase product sales but some times it increase product purchase. Sales of the firm is also fluctuating continuously. This means that firm in alignment to change in sales is bringing changes its purchase. This is the reason due to which firms cash balance is increasing continuously even its sales is fluctuating consistently. Hence, it can be said that firm is giving magnificent performance in its business. Net profit earned by the firm is also of high amount and it can be assumed that firm is earning good profit in its business.


On the basis of above discussion it is concluded that financial modeling is a very important method because by using same lots of time is saved easily. By using financial model all things that are related to problem are integrated easily and impact of change in one factor on the budget and firm profitability can easily be tested. Hence, it is concluded that financial model must be used by each and every type of manager.


  • Charnes, J., 2012. Financial modeling with crystal ball and excel. John Wiley & Sons
  • Libman, A., 2011. [Online]. Finacial modeling techniques. Available through <>. [Accessed on 5th May 2016].
Download Full Sample


Please enter valid details to complete your request.

  • img
Global Assignment Help Australia works with a motto of providing students with what they exactly need at the prices that won’t put a burden on their pockets. Our experts come together everyday to achieve this aim and make academic lives of students a bit easier. Through our high-quality writing services, we have been helping students achieve sky-high marks in their academic papers and pass their course with flying colors!
  • Sample of Tour Operation Management

    Introduction of Tour Operation Management This report helps in investigating the tour operators industry of the travel and tourism sector. It also includes different type of operators and products and services offered by them. It explores stages involved in creating a holiday package and...ReadMore

    18 Pages 4450 Words 391 Downloads
  • Sustainable Tourism Development Services

    Introduction to Sustainable Tourism Development Services Tourism is a major component of growth of economy in the whole world. Tourism affects the current and future economic, social and environmental factors. Along with this, they address the needs of visitors, industry as well as host...ReadMore

    32 Pages 7927 Words 1513 Downloads
  • Heritage And Cultural Tourism

    Introduction Heritage and cultural tourism is a sector that deals with a huge diversified culture of any country. The following assignment sets light in the tourism sector of Tibet that contributes heavily to the country’s economy. The growth and development of the culture, heritage and...ReadMore

    15 Pages 3755 Words 2618 Downloads
    Tag :
  • Sport And Event Tourism

    Introduction to Sport And Event Tourism Sport and event tourism is play significant role within the country for nation and personal development. It assists in enhancing the economic benefits by providing them with employment opportunity. It also increases interaction with new people and tourist...ReadMore

    13 Pages 3347 Words 8092 Downloads
    Tag :
  • Legislation and Ethics

    Introduction to Legislation and Ethics Travel and tourism industry is continuously expanding and providing significant contribution in the development of economy. By considering the continuous growth of the industry, it is essential to develop standard legal norms for the UK parliament for...ReadMore

    12 Pages 3114 Words 7072 Downloads
    Tag :
Exclusive Features
  • Free Turnitin Report
  • On-time Delivery
  • 24*7 Customer Support
  • Strict Refund Policy
  • Ownership Guarantee
  • Pocket-Friendly Prices
8,00,000+ STUDENTS Rely on Us

4.9/5 Ratings

  • Most experienced writer in physics

    Deborah Joseph I am an expert of Physics having masters credentia Hire Me

  • Marshall Ray

    Marshall Ray I hold more than twenty years of experience in Mar Hire Me

  • Best Aussie writers for law subjects

    Dr. Mike Johns After the completion of my doctorate in law , I st Hire Me

Subject Help
  • Economics Assignment Help
  • SPSS Assignment Help
  • Psychology Assignment Help
  • University Assignment Help
  • Cheap Assignment Writing
  • Science Assignment Help
  • College Assignment Help
Back To Top
Exciting Deals & offers on our AppInstall Now
Request Call Back
Request Call Back