Mastering Financial Modelling
Johannesburg South Africa,
03-06 October 2011
Master! precise working knowledge of the most useful functions in Excel for financial modelling
Immense! gain in your productivity level and apply what you learn to your job to further your career.
Sound! understanding of financial modelling concepts
Design! effective solutions to real-world financial modelling challenges
Maximum! hands-on experience
Detect! and prevent errors from recurring
Comprehensive! course notes and CD which includes worked examples, suggested solutions, reference materials, and a large variety of templates that can be immediately applied to kickstart your projects!
About Our Premier Course
We firstly begin by precisely covering the advanced areas of Excel that are relevant to Financial Modelling, Valuations and Project Evaluation. This special focus will provide a huge productivity gain when working in these areas.
We next move on to the Financial Modelling & Project Finance component and this is where participants will develop sound understanding of both the principles of financial modelling and their application to real-world situations through the use of spreadsheets. We then build upon the financial modelling principles and best practices learned to apply these to company valuations and project finance. This is where participants improve their mastery of the principles and concepts and develop critical skills to apply in practical applications.
Finally, the course describes how to both detect and prevent errors from occurring to ensure models are effective, practical and robust.
*Participants are to bring their own laptops with Excel installed
What you are going to learn
Effective and practical working knowledge of the most useful functions in Excel for financial modelling.
- Robust and sound understanding of financial modelling and valuation concepts.
- Experience in designing solutions to real-world financial modelling challenges.
- Application of modelling principles to company valuation, project evaluation and costing models
- Financial Model Auditing
- Automated Model Generation Tools
WORKSHOP OUTLINE (4 DAYS)
Excel for Financial Modelling
This section covers the advanced areas of Excel that are relevant to Financial Modelling, Valuations and Project Evaluation and will provide a huge productivity gain when working in these areas.
AREAS COVERED
- Advanced range names, including formulas and naming conventions
- Advanced conditional formatting, including formula-driven formatting
- Aggregation functions
- Financial functions: e.g. IRR, NPV, PMT
- Goal Seek, Solver
- Pivot Tables
- Scenarios, sensitivity, data tables
- Key functions: e.g. VLOOKUP, INDEX, MATCH
- Advanced data validation techniques and controls
- Introduction to macros and user-defined functions
Included are explanations of how these could typically be applied to Financial Modelling and Company Valuation.
Financial Modelling, Valuations & Project Evaluation
Part 1: Financial Modelling Principles & Practices
Part 1 provides participants with an introduction to financial modelling and the use of different types of spreadsheet models.
INTRODUCTION TO FINANCIAL MODELLING
- What is a model?
- Spreadsheet models
- Types of models
PRINCIPLES OF FINANCIAL MODELLING
- Steps in model building
- Best practice guidelines and spreadsheet modelling standards
- Designing for flexibility and scalability
- Designing for consistency
- Designing for usability and functionality
- Designing checks and balances
- Using VBA macros in financial models
Part 2: Applications of Financial Modelling
Part 2 goes into detail about the principles of risk and return together with the application of this to company valuation and project evaluation.
PRINCIPLES OF RISK AND RETURN
- Volatility
- Capital Structures
- Weighted Average Cost of Capital (WACC)
COMPANY VALUATION & PROJECT FINANCE
- Role of valuation
- Free cash flow to the firm and financial statements
- Analysing the past to forecast the future
- Discounted cash flow modelling & valuation
- Sensitivity analysis and an introduction to Monte Carlo simulation
- Capitalisation of earnings and other valuation methodologies
- Calculating project ratios & measures e.g. DSCR, LLCR, ICR, CFADS, PLCR
- Calculating key project measures: Internal rate of return (IRR), Net Present Value (NPV), Payback period
- Interpreting & presenting the results
- Application of modelling principles to costing models
Part 3: Control of Financial Models
Part 3 provides participants with the necessary skills to be able to control financial models. Topics covered include auditing and review processes and automated financial modelling software that can save you time.
FINANCIAL MODEL AUDITING/REVIEW
- Why audit?
- Excel’s auditing tools
- Automated testing tools: role, purpose and limitations, demonstration
- Model documentation
AUTOMATED MODEL GENERATION TOOLS
- Overview: purpose, advantages, disadvantages, demonstration
For full agenda, please email us your detail contact information to enquiry@neo-edge.com. Please indicate subject title “Mastering Financial Modelling”.
About Your World-class Trainer
JEFF ROBSON
Founding Director, Access Analytic Solutions
Masters (Applied Finance & Investment),
B.Comm (Accounting & Information Systems),
Certified Information Systems Auditor (CISA),
Fellow of the Financial Services Institute of Australasia (F Fin),
Fellow of the Australian Institute of Management (FAIM),
Member of the Australian Institute of Company Directors (MAICD),
Microsoft Certified Excel Expert (MCEE).
Jeff is the Principal and Founding Director of Access Analytic, a specialist consultancy that specialises in financial modelling, forecasting, valuation, model auditing, and management reporting for clients worldwide.
He has over 20 years experience in the development and maintenance of analytical tools and financial models for middle-market companies and large corporations, at all levels of complexity, in both domestic and international settings.
He is known as “The Financial Modelling Guru” because of his extensive experience in financial modelling, forecasting, valuation, model auditing, and management reporting for clients throughout the world. His achievements have been recognised by his peers and he is a Fellow of both the Financial Services Institute of Australasia and the Australian Institute of Management.
He has worked with companies such as Chevron, BankWest, Petronas, Rio Tinto, Glencore, KPMG, Grant Thornton and Toyota. He provides training and financial modelling for companies throughout the world.
He has provided training in Advanced Financial Modeling, Company Valuation, Budgeting and Forecasting, and Finance for companies throughout the Middle East and Asia Pacific regions including Australia, New Zealand, Hong Kong, Singapore, Thailand, China, Indonesia, Malaysia, Qatar, Oman, Iran, UAE, South Africa and Kuwait.
Before working with Access Analytic, Jeff spent 6 years working in the Corporate and IT Consulting divisions of a large, multi-national Chartered Accounting firm. Earlier in his career, he spent five years in banking and finance. Jeff is the author of a number of white papers on financial modelling on subjects such as Financial Modelling Best Practices and Financial Model Auditing.
Who Should Attend
This course will immensely benefit participants from a broad range of industries from the energy sector, mining, banking and finance, shipping, government ministries and boards, manufacturing, logistics, telecommunications etc; especially in these job designations
- Business & Finance Analysts
- Investment & Corporate Bankers
- Finance team members
- Accountants
- Strategists
- CFOs / Finance Directors
- Financial Controller
- Anyone responsible for the finance function in an organization
Attain better, faster and much more informed and sounder business decisions! Increase your productivity and sharpen your decision-making skills! Benefit from better risk management, well rounded and balanced analysis with the mastery of Financial Modelling!
We firstly begin by precisely covering the advanced areas of Excel that are relevant to Financial Modelling, Valuations and Project Evaluation. This special focus will provide a huge productivity gain when working in these areas.
We next move on to the Financial Modelling & Project Finance component and this is where participants will develop sound understanding of both the principles of financial modelling and their application to real-world situations through the use of spreadsheets. We then build upon the financial modelling principles and best practices learned to apply these to company valuations and project finance. This is where participants improve their mastery of the principles and concepts and develop critical skills to apply in practical applications.
Finally, the course describes how to both detect and prevent errors from occurring to ensure models are effective, practical and robust.
*Participants are to bring their own laptops with Excel installed
What you are going to learn
Effective and practical working knowledge of the most useful functions in Excel for financial modelling.
- Robust and sound understanding of financial modelling and valuation concepts.
- Experience in designing solutions to real-world financial modelling challenges.
- Application of modelling principles to company valuation, project evaluation and costing models
- Financial Model Auditing
- Automated Model Generation Tools
Testimonials
“Very useful to develop modelling skills. Thanks!”
“Excellent course content, very relevant to my work.”
“Very well-taught and extremely relevant to practical job application.”
“Very good course with very knowledgeable presenter. Excellent CD with good live examples.”
“Very worthwhile, informative course. Very relevant in terms of my day-to-day work.”
“Very good course with great mix of Excel and finance methodology.”
Course Format
The course will be held in a highly interactive workshop format with case studies and real world examples for a small class.
Pre-course Questionnaire
A pre-course questionnaire will be sent upon registration which allows you to raise your specific areas of interest. Jeff will review and analyze these in advance seeking to fully satisfy your learning needs.
Certificate of Attendance
Upon the successful completion of this course, you will receive a Certificate of Attendance bearing the signatures from both the Trainer and the Organizer. This Certificate will testify your endeavour and serve towards your professional advancement.
Color printing of charts in Course Material for your easy reading!
Delegate Fee
Please contact us at enquiry@neo-edge.com or customer service hotline at +65 6557 9166 for details.
Payment Terms
Payment must be made within 5 working days upon your registration in order to guarantee your seat. All payments must quote the delegate name and event code.
Payment can be made via the following ways:
Cheque
Made payable to NeoEdge Pte. Ltd.
Credit card
We accept Mastercard, Visa and American Express
Bank Transfer
Please refer to the Invoice for our Bank A/C detail.
All bank charges to be borne by payer. Please ensure that NeoEdge receives the full invoiced amount.
Unpaid registrations will be billed 40% of the registration fee if you do not attend the event. A complete set of the conference documentation in CD-Rom will be post to you.
Substitutions & Cancellations
Should you be unable to attend, you may substitute delegates at any time before the event at no extra charge. Alternatively, you may choose to credit the full value of your registration towards another NeoEdge event for up to 18 months from the date of issuance. No refunds will be available for cancellations.
Take the first-mover advantage!
Mastering Financial Modelling offers you the most effective platform to demonstrate your thought leadership and showcase your products and services at a significant gathering of industry leaders in the world that includes senior management and decision makers from both private and public sectors.
We will tailor packages to suit your exact marketing requirements helping to make sure that your company is front of mind during any decision-making process.
Please contact:
Thomas Ooi
Head of Business Development
Tel: +65 6557 9168
Main: +65 6557 9166
Fax: +65 6223 5186
Email: thomas.ooi@neo-edge.com
We partner with leading publications, online media and associations etc in relevant sectors to achieve win-win results. Our extensive marketing campaigns will ensure you impress the right players at the forefront of the latest industry advancements and expand your business territory.
To find out detail potential benefit, please contact us today at eugene@neo-edge.com or call us at Tel: +65 6557 9185.
Media Sponsor:
Corporate Africa, Times Publications
Times Media Group T/a Times Publications has produced publications, reports, exhibitions, and conferences for the international investment and business community targeting Africa and her trading partners for the past 16 years. Corporate Africa was established in 1994 and fully supports development across Africa through coalitions of interest, collaborations, partnerships and sustainable development investments to build capacity, confidence, and deeper and broader relations www.corporate-africa.com and www.times-publications.com http://www.corporateafricahealthfoundation.org/
Media Partners:
Asia Monitor is internationally recognised as providing essential information for anyone doing business in, or with, Asia. The publication provides subscribers with systematic political risk assessment, economic forecasts and business analysis for every country across the region.
Published by Business Monitor International, the emerging market specialists, Asia Monitor is broken down into four sub regional publications, of which any combination can be subscribed to. The Asia Monitor website www.asia-monitor.com includes ALL the content from the publications, a 24-month archive, and gives the added flexibility of exploring that content by country, topic or keyword.
Our publications are subscribed to by over 50% of the Global Fortune 500 companies. Why not take the time to find out why? Click here to visit www.asia-monitor.com for a FREE trial.
BEDigest (www.BEDigest.com) is a specialized news compendium service providing subscribers with the latest oil, gas, business and economic developments in 12 countries in the MENA region: Algeria, Bahrain, Egypt, Iran, Iraq, Kuwait, Libya, Oman, Qatar, Saudi Arabia, UAE and Yemen. We also present unique analyses and assessments through our special editions. No other service brings you as much coverage in one convenient, searchable portal. In addition, our proprietary Project Activity Monitoring (PAM) database enables users to track the latest developments in oil and gas projects, newly completed fields, pipelines, refineries, exploration blocks, gas export projects, and much, much more.
Bizcommunity.com rose from the rubble of the turn of the century ‘dotbomb’ scenario. As the dust settled, André Rademan and Ken van Ginkel, started building the online platform that would succeed in uniting and giving voice to South African business communities. www.bizcommunity.com/
BizContactsAfrica.com is an online community of like-minded business people in Africa. We aim to be a unified and fully representative online directory of business contacts in Africa, providing real-time accessibility to vital business contacts in various industries, thereby enhancing business growth through synergistic business network of connections.
Our database includes all business contacts i.e. multimillionaires, BEE business moguls from all sectors and business leaders from small, medium and large business industries.
BizContactsAfrica.com will allow businesses and individuals to present their business resume (i.e. business interests, business products & services and the business contacts or countries in Africa they seek to expand) on the internet in order to gain from the strategic partnerships and alliances that are available to them, as a result of them being noticed, seen and contacted by potential business partners locally, regionally and internationally.
CSR Africa is an online publication established in September 2009 dedicated to promoting institutions that make a difference in Africa. The focal point of the company is corporate social responsibility (CSR) in Africa.
The website, www.csrafrica.net, which hosts the daily digest and the e-zine is a primary source of information on CSR activity in Africa..
CSR Africa’s mission is to offer its readers quality news, information and education on Corporate Social Responsibility (CSR) from the African region.
We seek to be the ultimate and authoritative publication of reference on CSR in the African continent.
Financial Veritas is the leading financial events portal.
Find courses and conferences that are provided by the leading providers in the financial industry. This includes large-scale gatherings to smaller, niche-focused industry events taking place around the globe. Save time, money and effort by using our easy to use events search facility. Find, compare and book seats for the industry’s leading courses and conferences. All on a single platform.
Website: http://financialveritas.com
Email: info@financialveritas.com
Contact Number: +44 208 800 3717
FinRoad is the leading online Financial Markets Community with members in over 100 countries. Relevant connections, content and exclusive tools are at the core of our strategy for business, career and networking opportunities. Moreover, FinRoad communicate on all the relevant financial events.
FinRoad also offers companies from the industry (brokers, buy side, exchanges, IT and data/software vendors…) highly targeted marketing tools based on its new B2B marketing platform and Social Media consulting for Finance.
Connect with the people who really matter: www.finroad.com
ITevent is the largest source of conferences, exhibitions, seminars and training courses in IT field. Our goal is to bring fast and easy-to-use service to all IT professionals who are looking for most actual events in IT industry. To provide the best user experience we’ve focused on three main principles: Simplicity, Growth, and Scale.itevent.net
Treasury Management International (TMI) is a well respected and independent voice in the treasury world, renowned globally for its sharp editorial focus and breadth of opinion. With real-life experiences from practitioners, TMI showcases topical, pragmatic solutions and strategic insights providing valuable material for all practitioners, from experienced treasurers and CFOs to those new to the profession.
- TMI is the official magazine for the EACT (European Association of Corporate Treasurers)
- TMI Online & Digital: free registration / free articles / free digital edition (visit www.treasury-management.com)
- iPad – we have an App for that! Search ‘TMI’ in iTunes App Store to download for free
Email: sclarke@treasury-management.com
Tel: +44 118 947 8057
This event will be held at The Reef Hotel
58 Anderson Street, Marshalltown,
Johannesburg, 2107, South Africa
Contact: Jade January
Administration Manager
Tel: +27 (0)11 689 1000
Fax: +27 (0)11 689 1111
Cell: +27 (0) 78 327 3178
Email: reservations1@reefhotels.co.za
Please quote Mastering Financial Modelling Workshop Organised by Neoedge Pte Ltd to enjoy Corporate Rate.
Please enter the following information for each delegate. All fields marked with an asterisk are required. Upon receiving your submission, we will contact you within one working day to confirm your participation.
Event Name: Mastering Financial Modelling
Venue: Johannesburg South Africa
Dates: 03-06 October 2011