Financial Modeling & Valuation - Media Sector (Comcast)

Course details

In Financial Modeling you learn to gather historical information on companies and analyze company / industry performance on various financial parameters. This analysis is then used to build financial model, which in turn is key to projecting future financial performance. Based on this model, investors can arrive at suitable valuation. Our Financial Modeling course teaches you how to construct an integrated financial model from scratch. You will soon be building models that are robust, provide you with dynamic projections that can be used to thoroughly analyze a company from multiple standpoints such as operations, investment, financing and valuation. Financial Modeling training involves modeling of various projects on finance including Mergers and Acquisitions and Corporate valuation modules. Other application based modules covered in Financial Modeling with MS Excel training includes excel techniques such as its in-built functions, VBA coding, chartingand Dash-boarding which are used in different modeling applications.

This course has been designed to help the participants in:

• Understanding on usage of advanced MS Excel tools and techniques in financial analysis and decision making
• Understanding of Financial Modeling techniques
• Analyze future forecast and sustainability of business or project based on historical data
• Provide understanding on business data, and decision making for given business situation
• Understanding of spreadsheet-based modeling
• Knowledge on how much to invest, which project or asset to invest in, and even whether to invest at all etc.
• Understanding of Financial Modeling techniques
• Better management of financial models
• Improves job performance.

This course is ideal for MBA students, commerce graduates, Investment Banker, Business Analyst, Professional into Corporate Finance, Project Finance or any finance and commerce professionals looking forward to strengthen their knowledge of financial modeling techniques and implication are the ideal participants for Financial Modeling with Excel training. Also, the target audience for this course will be:

• Professionals working in financial service industry, investment banking, project management, corporate finance and treasury, real estate industry, accounting and finance department, equity research, business planning and strategy
• Any aspirants interested to work for financial service industry, investment banking, business planning and strategy
• Also candidates pursuing engineering or commerce graduation, CA, CFA, CS, FRM

We have covered the following modules in this course:

 Income statement, balance sheet and cash flow statement relationships

 Working capital, depreciation and capital expenditure schedules

 Intangibles amortization schedule

 equity schedule

 Debt and interest schedule

 Sensitivity analysis to match expected financial performance

There are no eligibility criteria for this course.

However, having knowledge on fundamentals of finance and excel basic skills is advised.