IPO Evaluation & Modeling

Course details

This course on Initial Public offering of Wonderla will help you to carry out the Financial modeling and Valuation of Wonderla for the future 5 years. Based on the valuation analysis we are going to judge the offer price of the company and come to an analysis whether it is over-valued or under- valued. 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, charting and 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 evenwhether 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.