Greetings from Corevents company,
We are in collaboration with internationally renowned Financial and Management Accounting consultant Mr. Duncan Williamson for a 2 days face to face master class on "Advanced Financial Modelling With Business Valuation" which is scheduled to be held on 23 & 24 September 2024 in Kuala Lumpur, Malaysia.
This Advanced Financial Modeling training takes you beyond the basics of Excel, unveiling hidden tools and functions that enhance your proficiency. It equips you with time-saving techniques to expedite financial modeling and automation, allowing you to achieve reliable and robust models. The course empowers you to navigate complex frameworks with confidence, positioning you as a specialist in Financial Modeling using Excel.
At the end of the program, participants will gain an understanding of:
-
Financial Modelling Fundamentals: How to use advanced Excel functions that will allow faster model development and provide greater reliability.
-
Review of Financial Modelling Techniques: Calculating the cost of equity, debt, and WACC The steps involved in building financial models Terminal value and its uses Calculating discounted cash flows NPV v IRR v RRR ... in plain English!
-
Advanced Modelling Techniques: Revenue: Create a detailed revenue schedule that considers allocations by division, geography, capacity constraints & Operating Costs: Create a detailed cost structure that includes tiered pricing on variable costs, multi-currency costing.
-
Depreciation: Incorporate accelerated depreciation build functionality to prevent over-depreciation of assets & Working Capital: Detailed inventory modeling, forecast Accounts Receivable and Accounts Payable in a monthly model.
-
Advanced Modelling Applications: Introduction to Dynamic Array Functions: the latest Excel functions
-
Multivariable Monte Carlo Simulations and stochastic modeling, Produce and manage financial model documentation to provide models that are easily understood and reviewed Model auditing/review and control.
-
How to create, manage, and present multiple scenarios and perform sensitivity analysis & How to apply the new features of Microsoft Excel 365 to increase advanced financial modelling productivity.
-
Power Query: Model automation using controls to enhance usability, Techniques for working with linked workbooks to ensure robust and reliable linking.
-
Techniques to create and use dynamic array functions and many more...
Please find attached detailed brochure of this training program.
Early Bird Registration:
Register before 16 August, 2024, and pay USD 1585 per person.
Standard Registration:
Register after 16 August, 2024, and pay USD 1985 per person.
To Register: Simply complete the last page of the program brochure and send the scan copy in reply to this email. Should there be anything further required, please do not hesitate to contact undersigned.
Best Regards,
Syed Ali
Business Development executive
Training@corevents-global.com