What you'll get
- 40h 54m
- 416 Videos
- Course Level - Intermediate| English[Auto-generated]
- Course Completion Certificates
- One-Year Access
- Mobile App Access
Curriculum:
Online Corporate Finance - Advanced Training
Corporate Finance is supposed to be a popular domain and highly associated with Investment Banking Concepts and it’s industry. It includes all the financial activities such as planning, raising, investing and monitoring of finance in order to run a corporation and achieve its financial goals primarily to maximize shareholders value. Any decision that has financial implications to the business and involves use of money is said to be a Corporate Finance decision. It is applicable to financial concerns of all kinds of firms.
Corporate Finance includes a range of activities; some of them are as follows:
- Investment Decisions
- Raising Finance
- Dividend decisions
- Advisory services in case of Mergers& Acquisitions
- Develop Financial Strategies
Why Corporate Finance - Advanced Training?
Specifically the course would equip the participants to:
- Gain Excel
- proficiency
- Perform project evaluation
- Learn Corporate Valuation techniques such as DCF and Relative valuation using EV/EBITDA‚ P/E‚ P/CF‚ P/BV‚ PEG‚ Dividend Yield.
- Build a Financial Model and Understand the Key Linkages of IS‚ BS and CF
- Learn Merger & Acquisition, Private Equity Modeling and Project Finance Modeling
- Understand the IPO process and Fund raising options
- Understand what a Pitch Book is and Report writing techniques. To efficiently represent your analysis
Target Audience for Online Corporate Finance - Advanced Training
- All those who want to learn the application of Corporate Finance techniques
- CFA members and aspiring students
- Professionals in the field of Credit, Investment Banking, Sales and trading.
- Management trainees/Corporate Finance executives
- Students of Finance or Non-finance background who want to make career in Corporate Finance/Investment Banking
Pre-requisites for Online Corporate Finance - Advanced Training
- Passion to learn
- Basic Computer Knowledge
-
CURRICULUM
[/tab][tab title="Testimonials"]
Testimonials
Arvind, IMT student of Advanced Corporate Finance Course in Delhi
The online course on Advanced Corporate Finance has been a steep learning curve right from day 1 of the course‚ learning the intricacies of excels based modeling and covers various corporate finance roles like Mergers and Acquisitions, IPO, Underwriting etc. The material has been judiciously designed so as to make the participants adept at satiating the growing demands of corporates.
Priyansh Ranawat, student of Advanced Corporate Finance Course in Mumbai
The online course has a superb style of explaining seemingly indigestible concepts of IPO and M&A in a rather simple manner. Thoroughly enjoyed the course for the various case studies and examples used making it interesting. Overall the experience has been very knowledgeable and enlightening.
Sachin Jhadav, student of Advanced Corporate Finance Course in Hyderabad, India
It was been a great learning experience at corporate bridge which help me to improve my excel skills and gain the practical experience of finance in a company. It was a comprehensive course that included all the roles that have to be played by one in the field of corporate finance, right from Financial Modeling to Report Writing. A great learning experience for budding analysts and finance guys for sure.
| Where do our learners come from? |
| Professionals from around the world have benefited from eduCBA's Comprehensive Corporate Finance courses. Some of the top places that our learners come from include New York, Dubai, San Francisco, Bay Area, New Jersey, Houston, Seattle, Toronto, London, Berlin, UAE, Hong Kong, Singapore, Australia, New Zealand, Bangalore, New Delhi, Mumbai, Pune, Kolkata, Hyderabad and Gurgaon among many. |
- CURRICULUM
[toggles type="accordion"][toggle title="Section 1: Excel For Corporate Finance"]
| 1 | Formatting a Financial Model |
| 2 | Paste Special Function |
| 3 | Logical functions ANDORIF |
| 4 | Arithmetic functions ABS INT LARGE MAX MIN SMALL TRUNCATE |
| 5 | Date functions DATE WEEKDAY |
| 6 | Learn to convert text to string |
| 7 | Auto Filter |
| 8 | Pivot Tables |
| 9 | Printing Setup Options |
| 10 | Comments |
| 11 | Grouping Tabs |
| 12 | Conditional Formatting |
| 13 | Protecting Worksheet |
| 14 | Data Validation |
| 15 | Cell Information |
| 16 | Creating text to column |
| 17 | Learn to convert text to string |
| 18 | Learn subtotal function |
| 19 | Check Boxes |
| 20 | Hyperlinks |
| 21 | List Boxes and Combo Boxes |
| 22 | Scroll Bar and Spinners |
| 23 | Group Boxes and Options Button |
| 24 | Download all Excel and PDF files |
[/toggle][toggle title="Section 2: Advanced Excel For Corporate Finance"]
| 25 | CHOOSE Function |
| 26 | VLOOKUP Function |
| 27 | HLOOKUP |
| 28 | Limitations of VLOOKUP |
| 29 | Match Index |
| 30 | Database Functions DSUM DAVERAGE DCOUNT |
| 31 | Using basic OFFSET Function |
| 32 | Dynamic Sum usding OFFSET function |
| 33 | Days Today Weekday Workday YearFrac |
| 34 | Day Date Datedif networkdays |
| 35 | Count Countif CountA Countblank |
| 36 | Forecast Function Part1 2 |
| 37 | One Dimensional Data Tables |
| 38 | Two dimensional Data Tables |
| 39 | Goal Seek |
| 40 | Watch Window |
| 41 | Solver |
| 42 | Adding an average |
| 43 | Creating histograms |
| 44 | Creating bar to pie charts |
| 45 | Creating Combo Charts |
| 46 | Dynamic Charts |
| 47 | Invert Negative in Chart |
| 48 | Creating scrolling charts |
| 49 | Creating thermometer charts |
| 50 | Creating Delta Charts |
| 51 | Understanding the PE Data |
| 52 | Creating the PE Graph |
| 53 | Google Inc PE Ratio Graph |
| 54 | Understanding the PE Band Chart Data |
| 55 | PE Band Chart Continued |
| 56 | Google Inc PE Band Chart |
| 57 | Setting up the Range Charts Part 1 |
| 58 | Setting up the Range Charts Part 2 |
| 59 | Setting up the Area Chart Part 1 |
| 60 | Setting up the Area Chart Part 2 |
| 61 | Funding Graph |
| 62 | Two Axis Graphs Part 1 and 2 |
| 63 | Setting up Scenario Graph Part 1 |
| 64 | Setting up Scenario Graph Part 2 |
| 65 | Download all Excel and PDF files |
[/toggle][toggle title="Section 3: Corporate Finance Foundation"]
| 66 | Capital Budgeting Part 1 |
| 67 | Capital Budgeting Part 2 |
| 68 | Capital Budgeting Part 3 |
| 69 | Capital Budgeting Part 4 |
| 70 | Capital Budgeting Part 5 |
| 71 | Capital Budgeting Part 6 |
| 72 | Capital Budgeting Part 7 |
| 73 | Capital Budgeting Part 8 |
| 74 | Capital Budgeting Part 9 |
| 75 | Time Value of Money Excel Applications Part 1 |
| 76 | Time Value of Money Excel Applications Part 2 |
| 77 | Time Value of Money Excel Applications Part 3 |
| 78 | Cost of Capital Part 1 |
| 79 | Cost of Capital Part 2 |
| 80 | Cost of Capital Part 3 |
| 81 | Cost of Capital Part 4 |
| 82 | Cost of Capital Part 5 |
| 83 | Cost of Capital Part 6 |
| 84 | Working Capital Management Part 1 |
| 85 | Working Capital Management Part 2 |
| 86 | Working Capital Management Part 3 |
| 87 | Measures of Leverage Part 1 |
| 88 | Measures of Leverage Part 2 |
| 89 | Measures of Leverage Part 3 |
| 90 | Budgetory Control Part 1 |
| 91 | Budgetory Control Part 2 |
| 92 | Budgetory Control Part 3 |
| 93 | Budgetory Control Part 4 |
| 94 | Budgetory Control Part 5 |
| 95 | Budgetory Control Part 6 |
| 96 | Marginal Costing part 1 |
| 97 | Marginal Costing part 2 |
| 98 | Marginal Costing part 3 |
| 99 | Marginal Costing part 4 |
| 100 | The Corporate Governance of Listed Companies A Manual for Investors Part 1 |
| 101 | The Corporate Governance of Listed Companies A Manual for Investors Part 2 |
| 102 | The Corporate Governance of Listed Companies A Manual for Investors Part 3 |
| 103 | The Corporate Governance of Listed Companies A Manual for Investors Part 4 |
| 104 | The Corporate Governance of Listed Companies A Manual for Investors Part 5 |
| 105 | The Corporate Governance of Listed Companies A Manual for Investors Part 6 |
| 106 | Download all Excel and PDF files |
[/toggle][toggle title="Section 4: Financial Modeling Using Excel"]
| 107 | What is Financial Modeling |
| 108 | Snapshot of Financial Model |
| 109 | Looking at the Assumptions |
| 110 | Calculating the Historical Ratios |
| 111 | Projecting Income Statement Revenues |
| 112 | Projecting Income Statement Costs |
| 113 | Calculating the Turnover Ratios |
| 114 | Forecasting the Working Capital |
| 115 | Working Capital Flow Diagram |
| 116 | BASE Equation Projecting Capital Expenditure |
| 117 | Projecting Depreciation Part 1 |
| 118 | Projecting Depreciation Part 2 |
| 119 | Depreciation Schedule Flow Diagram |
| 120 | BASE Equation Projecting Intangibles |
| 121 | Projecting Amortization |
| 122 | Amortization Schedule Flow Diagram |
| 123 | Projecting Other Long Term Items |
| 124 | Other Long Term Schedule Flow Diagram |
| 125 | BASE Equation Shareholders Equity I |
| 126 | BASE Equation Shareholders Equity II |
| 127 | Projecting ShareRepurchaseBuy Back and effect of Stock Options |
| 128 | Shareholders Equity Schedule Flow Diagram |
| 129 | Projecting Outstanding Shares |
| 130 | Completing the Cash Flow Statements |
| 131 | Projecting Debt Short term and Long |
| 132 | Concept of Cash Sweep Revolver Ending |
| 133 | Debt Schedule Flow Diagram |
| 134 | Important Understanding the Circular Reference in Detail |
| 135 | Download all Excel and PDF files |
[/toggle][toggle title="Section 5: Financial Modeling Paint Sector"]
| 136 | Preparing the Infrastructure of Asian Paints |
| 137 | Populating FY2010 Income Statement |
| 138 | Populating EPS and Unit Conversions |
| 139 | Populating FY2010 Balance Sheet |
| 140 | Populating FY2010 Balance Sheet Contd |
| 141 | FY 2010 BS Change of Units Error Rectification |
| 142 | Populating FY 2010 Cash Flow |
| 143 | Populating FY 2010 Cash Flow Contd |
| 144 | Income Statement Ratio Analysis |
| 145 | BS Calculation of Solvency Ratios |
| 146 | BS Working Capital Receivables Inventory Turnover |
| 147 | BS Working Capital Payables Turnover |
| 148 | BS Cash Conversion Cycle |
| 149 | IS BS Calculation of Operating Efficiencies |
| 150 | IS BS Dupont Analysis |
| 151 | IS BS Financial Risk Ratios |
| 152 | IS Projections Sales Material Costs |
| 153 | IS Projections Employee Cost |
| 154 | IS Projections PAT |
| 155 | IS Projections EBITDA PBT |
| 156 | Minority Interest Calculation |
| 157 | Dividends Forecasts |
| 158 | Completing the Income Statement Projections |
| 159 | BS Projections Shareholders Equity |
| 160 | BS Projections Minority Interest |
| 161 | BS Projections Deferred Tax Liability and Goodwill |
| 162 | BS Projections Working Capital Projections |
| 163 | BS Projections Working Capital Projections Contd |
| 164 | Provision for Dividends |
| 165 | Depreciation Schedule |
| 166 | Forecasting Debt |
| 167 | Cash Flow Projections Operating Activities |
| 168 | Cash Flow Projections Financing Activities |
| 169 | Cash Flow Projections Financing Activities and Reconciliation |
| 170 | Download all Excel and PDF files |
[/toggle][toggle title="Section 6: Mergers Acquisitions Modeling"]
| 171 | MA Introductory |
| 172 | MA Sector Overview |
| 173 | Investment Banking Sector Overview |
| 174 | MA Read me first |
| 175 | Introduction to MA 1 |
| 176 | Introduction to MA 2 |
| 177 | Introduction to MA 3 |
| 178 | Introduction to MA 4 |
| 179 | Introduction to MA 5 |
| 180 | Global Scenario 1 |
| 181 | Global Scenario 2 |
| 182 | M A India |
| 183 | India's MA Regulatory Environment 1 |
| 184 | India's MA Regulatory Environment 2 |
| 185 | India's MA Regulatory Environment 3 |
| 186 | India's MA Regulatory Environment 4 |
| 187 | India's MA Regulatory Environment 5 |
| 188 | India's MA Regulatory Environment 6 |
| 189 | India's MA Regulatory Environment 7 |
| 190 | India's MA Regulatory Environment 8 |
| 191 | India's MA Regulatory Environment 9 |
| 192 | Accounting for M A |
| 193 | Combination Model Overview |
| 194 | Combination Model Building 1 |
| 195 | Combination Model Building 2 |
| 196 | Combination Model Building 3 |
| 197 | Combination Model Building 4 |
| 198 | Combination Model Building 5 |
| 199 | Parkway acquisition of Apollo Hospital Mini Merger Model 1 |
| 200 | Parkway acquisition of Apollo Hospital Mini Merger Model 2 |
| 201 | Parkway acquisition of Apollo Hospital Mini Merger Model 3 |
| 202 | Parkway acquisition of Apollo Hospital Mini Merger Model 4 |
| 203 | Parkway acquisition of Apollo Hospital Mini Merger Model 5 |
| 204 | Parkway acquisition of Apollo Hospital Mini Merger Model 6 |
| 205 | Parkway acquisition of Apollo Hospital Mini Merger Model 7 |
| 206 | Parkway acquisition of Apollo Hospital Mini Merger Model 8 |
| 207 | Parkway acquisition of Apollo Hospital Mini Merger Model 9 |
| 208 | CBA Advanced Merger Model Part 1 |
| 209 | CBA Advanced Merger Model Part 2 |
| 210 | CBA Advanced Merger Model Part 3 |
| 211 | CBA Advanced Merger Model Part 4 |
| 212 | CBA Advanced Merger Model Part 5 |
| 213 | CBA Advanced Merger Model Part 6 |
| 214 | Download all Excel and PDF files |
[/toggle][toggle title="Section 7: Initial Public Offerings IPO"]
| 215 | Introduction to IPOs 1 |
| 216 | Introduction to IPOs 2 |
| 217 | Book Building |
| 218 | IPO In Detail |
| 219 | Role of Parties In Detail |
| 220 | The Life Cycle Of An IPO Prospectus |
| 221 | IPO Timeline 1 |
| 222 | IPO Timeline 2 |
| 223 | Price Discovery Process and IPO Allocation |
| 224 | Excel Template Mandhana IPO 1 |
| 225 | Excel Template Mandhana IPO 2 |
| 226 | Excel Template Mandhana IPO 3 |
| 227 | Excel Template Mandhana IPO 4 and 5 |
| 228 | Listing |
| 229 | Underwriting |
| 230 | Due Diligence in IPO |
| 231 | List of Documents to be Examined |
| 232 | IPO Grading |
| 233 | Grey Market Premium |
| 234 | IPO Index |
| 235 | Navigating the IPO Prospectus |
| 236 | Jubilant Foodworks Financial Model |
| 237 | IPO Resources httpswwwchittorgarhcom |
| 238 | Download all Excel and PDF files |
[/toggle][toggle title="Section 8: Fund Raising Options"]
| 239 | FPO Process Overview |
| 240 | Introduction to QIP Part 1 |
| 241 | Introduction to QIP Part 2 |
| 242 | QIP Case Studies Part 1 |
| 243 | QIP Case Studies Part 2 |
| 244 | QIP Process Overview |
| 245 | ADR GDR Process Overview Part 1 |
| 246 | ADR GDR Process Overview Part 2 |
| 247 | ADR GDR Process Overview Part 3 |
| 248 | Rights Process Overview |
| 249 | Rights Issue Activity Schedule Part 1 |
| 250 | Rights Issue Activity Schedule Part 2 |
| 251 | Rights Issue Activity Schedule Part 3 |
| 252 | Preliminary due diligence and Information check list for rights issues Part 1 |
| 253 | Preliminary due diligence and Information check list for rights issues Part 2 |
| 254 | Preliminary due diligence and Information check list for rights issues Part 3 |
| 255 | NCD and Warrant Overview Part 1 |
| 256 | NCD and Warrant Overview Part 2 |
| 257 | Summary of Alternatives Part 1 |
| 258 | Summary of Alternatives Part 2 |
| 259 | Download all Excel and PDF files |
[/toggle][toggle title="Section 9: Pitch Book Preparation"]
| 260 | Introduction to Pitchbook |
| 261 | Pitch Book Share Price Graphs part 1 |
| 262 | Pitch Book Share Price Graphs part 2 |
| 263 | Pitch Book Share Price Graphs part 3 |
| 264 | Pitch Book Share Price Graphs part 4 |
| 265 | Pitch Book Share Price Graphs part 5 |
| 266 | Pitch Book Share Price Graphs part 6 |
| 267 | Pitch Book Share Price Graphs Pharma Sector |
| 268 | Pitch Book Share Price Graphs Price Volume Chart 1 |
| 269 | Pitch Book Share Price Graphs Price Volume Chart 2 |
| 270 | Pitch Book Share Price Graphs Price Volume Chart 3 |
| 271 | Pitch Book Broker Summary 1 |
| 272 | Pitch Book Broker Summary 2 |
| 273 | Pitch Book Broker Summary 3 |
| 274 | Pitch Book Company Profiles 1 |
| 275 | Pitch Book Company Profiles 2 |
| 276 | Pitch Book Industry Analysis 1 |
| 277 | Pitch Book Industry Analysis 2 |
| 278 | Pitch Book Industry Analysis 3 |
| 279 | Pitch Book Industry Analysis 4 |
| 280 | Pitch Book Industry Analysis 5 |
| 281 | Pitch Book Industry Analysis 6 |
| 282 | Investment Bank's Credentials part 1 |
| 283 | Investment Bank's Credentials part 2 |
| 284 | Valuation Summaries |
| 285 | Pitch Book Case Study 1 Solvay part 1 |
| 286 | Pitch Book Case Study 1 Solvay part 2 |
| 287 | Pitch Book Case Study 1 Solvay part 3 |
| 288 | Pitch Book Case Study 1 Solvay part 4 |
| 289 | Pitch Book Case Study 2 Bayer part 1 |
| 290 | Pitch Book Case Study 2 Bayer part 2 |
| 291 | Pitch Book Case Study 2 Bayer part 3 |
| 292 | Pitch Book Case Study 2 Bayer part 4 |
| 293 | Pitch Book Case Study 2 Bayer part 5 |
| 294 | Pitch Book Case Study 2 Bayer part 6 |
| 295 | Pitch Book Case Study 2 Bayer part 7 |
| 296 | Pitch Book Case Study 2 Bayer part 8 |
| 297 | Pitch Book Case Study 2 Bayer part 9 |
| 298 | Pitch Book Case Study 2 Bayer part 10 |
| 299 | Pitch Book Case Study 2 Bayer part 11 |
| 300 | Pitch Book Case Study 2 Bayer part 12 |
| 301 | Pitch Book Case Study 2 Bayer part 13 |
| 302 | Pitch Book Preparations Advanced Comps |
| 303 | Calculating Market Rate for CAPM Model Part 1 |
| 304 | Calculating Market Rate for CAPM Model Part 2 |
| 305 | Advanced Computations for Pitch Book Preparations Infrastructure Sector |
| 306 | Download all Excel and PDF files |
[/toggle][toggle title="Section 10: Private Equity Modeling"]
| 307 | Introduction to Private Equity Part 1 |
| 308 | Introduction to Private Equity Part 2 |
| 309 | Introduction to Private Equity Part 3 |
| 310 | Introduction to Private Equity Part 4 |
| 311 | Introduction to Private Equity Part 5 |
| 312 | Private Equity Market Overview |
| 313 | Venture Capital Market Overview |
| 314 | Angel Investor Market Overview |
| 315 | PE Global Market |
| 316 | PE Indian Market |
| 317 | Private Placement Memorandum |
| 318 | Fund Structure and Investment Process part 1 |
| 319 | Fund Structure and Investment Process part 2 |
| 320 | Fund Structure and Investment Process part 3 |
| 321 | Fund Structure and Investment Process part 4 |
| 322 | Fund Structure and Investment Process part 5 |
| 323 | Fund Structure and Investment Process part 6 |
| 324 | Deal structuring Part 1 |
| 325 | Deal structuring Part 2 |
| 326 | Deal structuring Part 3 |
| 327 | Contructing a Term Sheet part 1 |
| 328 | Contructing a Term Sheet part 2 |
| 329 | Contructing a Term Sheet part 3 |
| 330 | Contructing a Term Sheet part 4 |
| 331 | Private Equity Financial Modeling 1 |
| 332 | Private Equity Financial Modeling 2 |
| 333 | Private Equity Financial Modeling 3 |
| 334 | Private Equity Financial Modeling 4 |
| 335 | Private Equity Financial Modeling 5 |
| 336 | Private Equity Financial Modeling 6 |
| 337 | Private Equity Financial Modeling 7 |
| 338 | Private Equity Financial Modeling 8 |
| 339 | Private Equity Financial Modeling 9 |
| 340 | A Fund Manager Perspective part 1 |
| 341 | A Fund Manager Perspective part 2 |
| 342 | A Fund Manager Perspective part 3 |
| 343 | A Fund Manager Perspective part 4 |
| 344 | Download all Excel and PDF files |
[/toggle][toggle title="Section 11: Project Finance Modeling"]
| 345 | Project Finance Introduction |
| 346 | Parties to Project Finance |
| 347 | Documentation Part 1 |
| 348 | Documentation Part 2 |
| 349 | Project Finance vs Corporate Finance |
| 350 | Project Finance vs Structured Finance |
| 351 | Human Apraisal |
| 352 | Market Appraisal Technical Appraisal |
| 353 | Financial Feasibility |
| 354 | Land and Building |
| 355 | Plant and Machinery |
| 356 | Other costs and Preliminary expenses |
| 357 | Preoperative Expenses |
| 358 | Means of Finance |
| 359 | Projections with Analysis and Evaluation |
| 360 | DCF based approach |
| 361 | NonDCF based approach |
| 362 | Construction Phase risk |
| 363 | Operation phase risk |
| 364 | Market risk |
| 365 | Ratios for project evaluation 1 |
| 366 | Ratios for project evaluation 2 |
| 367 | Break Even Analysis |
| 368 | IRR Calculation |
| 369 | BEP Calculation |
| 370 | Other ratios |
| 371 | Calculation of ratios |
| 372 | Sensitivity Analysis |
| 373 | Assumptions 1 |
| 374 | Assumptions 2 |
| 375 | Project Cost Calculation |
| 376 | Capex Schedule 1 |
| 377 | Capex Schedule 2 |
| 378 | Capex Schedule 3 |
| 379 | Capex Schedule 4 |
| 380 | Capex Schedule 5 |
| 381 | Capex Schedule 6 |
| 382 | Income Statement Projections |
| 383 | Depreciation Schedule 1 |
| 384 | Depreciation Schedule 2 |
| 385 | Working Capital Projections 1 |
| 386 | Working Capital Projections 2 |
| 387 | Tax Calculation |
| 388 | Calculating Cash Flows |
| 389 | Balance Sheet |
| 390 | Ratio Analysis |
| 391 | Sensitivity Analysis |
| 392 | Preparing a Project Finance Report |
| 393 | Download all Excel and PDF files |
[/toggle][/toggles]
Training 5 or more people?
Get your team access to 5,000+ top courses, learning paths, mock tests anytime, anywhere.
Drop an email at: [email protected]
40h 54m | 416 Videos | 
Intermediate| 