Build your career with our industry-related courses. call us now at +65 9730 4250

Corporate Finance Masterclass

Advanced Excel

The objective of this program is to provide Advanced Excel knowledge and practical experience about the creation of comprehensive and flexible financial models used in financial planning and fundraising purposes.
The participants will gain insights into the step-by-step process of creating financial models using Microsoft Excel, putting checks and audits and finally analyzing the same.

Overview of Advanced Excel

This course will equip all participants with various tools to aid in complex business decision making by incorporating multiple factors operating in the dynamic business environment. At the end of the course, each participant will be able to create a financial model independently and carry out analysis to take the best decision for their company.

Who should attend

All individuals who want to improve best financial modeling skills should attend this course

Methodology & Trainer

The non-theoretical methodology which includes interactive discussions, case studies, and assignments to understand the concepts and their applicability. As a policy, we limit the class size to 15 participants so that we can provide attention to each participant and ensure their objective is achieved.

We request you to please bring your laptop with Microsoft Excel installed to the class.

All our trainers are carefully chosen by us and possess a rich and vast experience in the financial sector. This course conducted by an experienced training consultant having more than 16 years of industry experience with some of the world’s leading business institutions, specializing in corporate finance, investment banking, and advanced private equity by professionals.


Module – 1: Setting up a financial model and building projections

Module – 2: Preparation of Income statement, cash flow statements and balance sheet

Module – 3: Importance of key schedules and their application

Module – 4: How to create working capital schedule

Module – 5: How to create Capex and funding schedules including multiple debts

Module – 6: Integration of income statement, balance sheet, and cash flow statement

Module – 7: Establish scenario and sensitivity analysis

Module – 8: How to analyze the data

Module – 9: How to apply different financial analysis techniques on the model

Module – 10: Approaches to applying different valuation techniques in the model

Tags


Course


Event

Public Courses

More Courses






Contact for more info.






bangkok/advanced-excel