Financial Modeling Project#9 – Cox & Kings

eduCBA brings you the course on Financial Modeling - Tourism Sector. You will get to analyze the Tourism company thoroughly through projecting the financial statements. We will learn to project the revenues, cost, depreciation, debt etc.

175

 12h 38m | 116 Videos | 80199 Views |   Intermediate| English[Auto-generated]

About Financial Modelling Project # 10 – Cox and Kings

The “Financial Modelling Tourism Sector Course” is brought to you by eduCBA. This course is for all the people who have interest in learning about financial modelling right from the very beginning and want to apply the concepts that are related to it in the preparation of the financial model for the tourism sector. The main topics that form a part of this course are –

Basic Excel – The purpose of this section is to help in providing a base so that the people are able to work in excel so that a smooth financial model can be prepared.

Advanced Excel – The purpose of this section is to deal with an understanding of the different excel functions that are advanced and which are used often by the analysts.

Comprehensive Financial Modelling – The purpose of this section is to deal with an understanding related to the preparation of a financial model by making use of the different types of schedules and then forming their association with the financial model.

Overview of the Tourism Sector

The tourism sector in India has developed to be a significant growth driver among the Indian service sectors. Travel as well as tourism in India is a creator of employment and also a source of foreign exchange for the nation in a substantial proportion. Besides this, it is also economic activity which provides assistance to the host and the local population.

In 2013, the “travel and tourism industry” made an addition of INR 2.17 trillion (US$ 36 billion) or 2 percent to the Gross Domestic Product (GDP) of the country. By 2024, there is a likelihood that it will increase to INR 4.35 trillion (US$ 72.17 billion).

In India, the market size of the “travel and tourism sector” is placed at US$ 117.7 billion and by 2022 it is expected to touch US$ 418.9 billion.

India has been slated to be among the tourism destinations that are developing very rapidly. As per “Booming Tourism in India”, a recent report, it was expected that the tourism industry of India will register a compound growth (CAGR) of over 20 percent in the period between 2013 and 2015 as a consequence of the generation of a huge investment opportunities.

This course will be helpful to you in making a professional excel based financial as well as valuation model pertaining to the tourism sector. This module will also help the participant in gaining a realistic knowledge of the tourism industry’s performance and its contribution towards the economy’s development and also the future of the industry.

What will you be learning as a part of the “Financial Modeling Tourism Sector Course”

• The use of excel tools
• The sector of tourism in India
• Overview of the industry, “Horizontal and Vertical analysis of Income Statement” and Ratio Analysis and Balance Sheet
• Building a step by step financial model of Cox and Kings, get to know about the vital linkages pertaining to the Income Statement, Cash Flow and Balance Sheet and also learn about valuations

Course Description

The curriculum of the “Financial Modelling Course” consists of the following sections –

Basic Excel – This section will be introducing you to the basic excel. It will comprise the following subsections –

• How to get started with Ribbons Quick Access Toolbar
• How to get started with Surfing Excel HELP function
• Case Study of Excel
• Data Entry in Excel
• How to populate the case study in Excel
• Calculations – Addition, Subtraction, Multiplication and Division
• Formulas – SUM, MAX, MIN, AVERAGE
• Formatting of Number Formats
• Formatting of Table Formats
• How to update a calculation
• Absolute References and Percentages
• Conditional Formatting
• IF Function
• COUNTIF Function
• SUMIF Function
• How to create Graphs and charts
• How to create Pie Charts
• Filter
• Sorts
• Pivot Table
• Split and Freeze
• Presentation Table Formats
• Presentation Formatting Charts and Indents
• How to print the Worksheets
• How to print the Titles and Headers
• Shortcuts for Navigation and Formatting
• Shortcuts for Formulae and Selection of Data
• Common Errors
• How to download the PDF and Excel Files

Advanced Excel 2010 – This section comprises the following subsections –

• Paste Function and Office Button
• Screenshots and Sparklines Custom Ribbons
• Equation Editor and Conditional Formatting
• Paste Special
• The logical functions of IF AND OR
• Arithmetic functions MAX, MIN, ABS, etc
• COUNT COUNTBLANK COUNTA COUNTIF
• Cell Information ISBLANK ISERROR etc
• VLOOKUP Function
• HLOOKUP Function
• CHOOSE Function
• MATCH INDEX
• Functions of Database DCOUNT DAVERAGE DSUM
• OFFSET Function Part 1
• OFFSET Function Part 2
• FORECAST Function
• One Dimensional Data Tables
• Two Dimensional Data Tables
• Goal Seek
• Solver
• Introduction of Array Function
• Array Function of Row and Columns
• Array Function FREQUENCY
• Array Function TRANSPOSE
• FIND CLEAN REPT CONCATENATE
• PROPER UPPER LIMIT LEFT RIGHT MID
• Pivot Charts
• Pivot Tables
• Pivot Table Filter Slicer
• Naming a Range and a Cell
• Naming Dynamic Ranges
• Auditing of Toolbar
• Watch Window
• Options Button and Group Boxes
• Check Boxes
• Combo Boxes and List Boxes
• Spinners and Scroll Bar
• Text to Columns
• Pivot Grouping Tools
• SUBTOTAL Function
• Data Validation
• Hyperlinks
• Custom View
• Random Numbers
• Excel 2010 Sparklines
• Protection of Workbook and Worksheets
• Range Charts Type 1 Part a
• Range Charts Type 1 Part b
• Range Charts Type 2 Part a
• Range Charts Type 2 Part b
• Average Line
• Graph Funding
• Two Axis Graphs
• Scenario Graphs Part 1
• Scenario Graphs Part 2
• Bar to Pie Chart
• Combo Charts
• Creation of Histogram
• Invert Negatives
• Scrolling Chart Part 1
• Scrolling Chart Part 2
• Download of all PDF and Excel Files

Comprehensive Financial Modelling – This section comprises the following subsections –

• What is Financial Modelling
• Snapshot of a Financial Model
• A look at the Assumptions
• Calculation of the Historical Ratios
• Projection of the Income Statement Costs
• Projection of the Income Statement Revenues
• Calculation of the Turnover Ratios
• Forecast of the Working Capital
• Flow Diagram of Working Capital
• BASE Equation which projects the Capital expenditure
• Projection of Depreciation Part 1
• Projection of Depreciation Part 2
• Flow Diagram of Depreciation Schedule
• BASE Equation that projects the intangibles
• Projection of Amortization
• Flow Diagram of Amortization
• Projection of Other Items of the Long Term
• Flow Diagram of the Other Items of the Long Term
• BASE Equation of Shareholders Equity I
• BASE Equation of Shareholders Equity II
• Projection of Repurchase of Share Buy Back and Stock Option Effects
• Flow Diagram of Shareholders Equity Schedule
• Projection of Outstanding Shares
• Completion of the Cash Flow Statements
• Projection of Short Term and Long Term Debt
• Cash Sweep Revolver ending Concept
• Flow Diagram of Debt Schedule
• Importance of Understanding the Circular Reference in a Detailed way
• Downloading of all PDF and Excel Files

What are the requirements/pre-requisites?

The main pre-requisites of the Financial Modelling Project Course are as follows –

• The course has been structures in such a way that there is no requirement of pre-learning.
• The participant should possess a passion for learning.

Target Audience for this training

The target audience for the training on “Financial Modelling Project # 10 consists of the following people –

• Projects for winter and summer internships
• Equity and Financial analysts
• Professionals who are looking forward to polishing their financial skills further
• Graduates who may be from any background but who are inclined towards making their career in finance

FAQs – General Questions

1. I am new to this course of Financial Modelling Project. Will I face difficulties in pursuing this course?

No, you will not be facing any difficulties even if you are new to the Financial Modelling Project.The reason for this is that the course starts right from the beginning and the course has been structured in a manner that the participant does not need any pre-learning. The only that thing that the participant needs to possess is the passion for learning and an interest in the financial model of the tourism sector. The other things like the knowledge related to the subject will be taken care of by the training that eduCBA provides.

2. What are the various things that I will be learning from this course?

The various things that you will be learning as a part of the course of Financial Modelling Project consist of the ways in which the basic as well as the advanced tools of excel can be used and how they are helpful in the preparation of the financial model for the tourism sector. It will be teaching you about the sector of tourism of India. As a part of this course you will also be getting an overview of the tourism industry along with the horizontal as well as the vertical analysis of the income statement, ratio analysis and also the balance sheet.

3. How is this course going to be useful to me in practical situations?

The course will be useful to you in practical situations as it will provide you insights into the tourism sector of India, you will get an overview of the industry of tourism in India. You will also learn about the way in which you can build a financial model of Cox and Kings in a step by step manner and also learn about the crucial linkages that pertain to the Income Statement, Cash Flow as well as the Balance Sheet. Besides these things you will be also learning about the valuations.

Course Testimonials

Jesse Curnutt

I really like the courses that are offered by the eduCBA website. I pursued the course on Financial Modelling Project and it provided a thorough guidance which proved to be extremely useful. It helps you in getting a basic and advanced knowledge of working on Excel and also the way to develop a financial model for the tourism sector besides providing a lot of great information.

Surabhi Stephens

I found the eduCBA website to be extremely good as all the points related to any particular course are taught in an appropriate manner. The course on Financial Modelling that I undertook taught me the ways of forecasting a company’s future financials. It helped in making me an expert analyst by providing me with the skills that are required for being an analyst. I am thinking of pursuing other different courses from eduCBA. The best part about this website is that it offers courses form various subject areas and the training provided is amazing.

Career Benefits of this training

Cost Effective and Highly Practical

The Financial Modelling Project of eduCBA is very cost effective as you gain extensive knowledge of the tourism sector. The amount that you need to pay for pursuing the course is nothing in comparison to the extent of knowledge that you get regarding the tourism sector of India and the way to prepare a financial model for the sector. With the help of this course you can easily make a professional financial as well as valuation model that is excel based and pertains to the tourism sector.

Realistic Knowledge of the performance of the Tourism Sector

This module will provide you assistance in gaining a realistic knowledge related to the performance of the tourism industry and the contributions that it makes towards the development of the economy and also towards the future of the industry. It helps in making you an expert analyst by teaching you how to forecast a company’s future financials.