A program for experienced professionals who plan to enhance current financial modeling and business valuation skills
- Preparation for interviews with investment banks and private equity funds
- Expansion of financial modeling and business valuation skills
- Development of leadership skills
- Setting long-term career goals and objectives
- Regular consultations with a mentor
Target Audience:
- Current students, recent graduates with entry-level work experience who plan to pursue careers in international financial companies
- Employees of finance departments of industry companies that use modeling and valuation practices in their day-to-day work
Course Schedule:
Module 1 (2 hours)
Overview of the main approaches to business valuation. The market multiples method. The method of historical transactions. Discounted cash flow (DCF) analysis.
Module 2 (6 hours)
Practical aspects of financial accounting for lease liabilities, finished goods inventories, deferred tax assets and liabilities, financial investments, working capital, depreciation. Key differences between IFRS and US GAAP accounting policies.
Module 3 (6 hours)
Methods of accounting for investments in associates and subsidiaries. Calculation of goodwill in acquisitions. Analysis of changes in net earnings per share resulting from a transaction (accretion/dilution). Calculation of potential synergies in mergers and acquisitions. Modelling and forecasting in MS Excel of consolidated financial statements of a company after an acquisition.
Module 4 (6 hours)
Overview of the basic stages of a buy-side M&A or sell-side M&A transaction. The economics of SPAC transactions. Analysis of recent US and international M&A and SPAC transactions.
Module 5 (3 hours)
The main stages of the company’s preparation for public offering (IPO). Analysis of recent US and international IPO transactions.
Module 6 (16 hours)
Consideration of industry specifics in valuation of companies of oil and gas, metallurgical and mining, banking and telecommunication industries and modelling in MS Excel.
Module 7 (5 hours)
Possible methods of financing a company’s operations. Modeling an LBO and calculating a return on investment (return analysis) in MS Excel.
Throughout the course (22 hours)
- Homework and independent work
- Mentor program with speakers from School of Finance
- Career consulting
- Preparing for selection for internships and applying for open positions
- Team case studies
- Preparatory interviews
Exam (6 hours)
Written exam covering theoretical and practical aspects of the course. Financial modeling in MS Excel. Oral interview on course topics with program speakers.