The workshop is practical with emphasis on skill transfer to the delegates. They will also build a number of models to reuse: a financial ratio mask sheet, loan calculator and amortization tables, and an EVA tracker. Delegates will also master a number of advanced MS Excel skills.
Date:
5-6 December 2024
Time:
8:30 – 16:30
CPD:
2 CPD Points- ECSA
1.4 CPD Credits- SACPCMP
Fees:
R6490 + vat (Early Bird)
R6999 + vat (Standard)
Course Objectives:
After this workshop, you will:
• Understand the interplay between the income statement and balance sheet and be able to interpret these. • Do a financial analysis, interpret the pointers, and know when to walk away.
• Understand and be able to share in accountant talk: EBIT, WACC, ROE, ROA, etc.
• Be able to use the investment process to score a project’s financial viability.
• Understand and be able to manage an Earned Value Management system.
• Be able to use statistics to do simple regressions for forecasting.
• Have improved your Excel skills.
About:
UNDERSTANDING FINANCIAL STATEMENTS
This is an introduction to financial statements to enable the delegate to both understand and interpret the statements. It also forms the foundation of all other financial skills in the workshop.
- The Income Statement
- Cost of Goods Calculation
- The Balance Sheet
- Cash Traps
- Problems with GAAP
MS EXCEL TIPS AND TECHNIQUES
All financial modelling is heavily based on MS Excel. In this module some relevant techniques, financial models and functions are demonstrated.
- Visual outlay
- ‘Ctrl’ shortcuts
- Conditional formatting
- If functions
- Lookups and queries
- Date functions
- Automated C charts
EARNED VALUE MANAGEMENT (EVM)
- The Building Blocks
– Planned Value (PV)
– Earned Value (EV)
– Actual Cost (AC) - Performance Indices
– Cost Performance Index (CPI)
– Schedule Performance Index (SPI) - Future Forecast Estimates
– Final Total Cost Prediction
– Final Total Time Prediction - Building an EVM Tracker with MS Excel
- Case Studies
WHEN IS A PROJECT VIABLE? (THE INVESTMENT DECISION)
An organization will only accept a project if the project will further its goals. In this module delegates master the financial skills that determine which projects are beneficent.
- Why Invest in a Project?
- Definitions
- The Time Value of Money
- Financing the Project
– Sources of Financing
– What the Bank Requires (The 4C’s of Banking)
– PMT and PPMT Functions
– Build a Repayment Calculator
– Build an Amortization Table with MS Excel - Steps to Determine Project Viability
– How to Calculate the Weighted Average Cost of Capital (WACC)
– How to Calculate Cash Flow with Excel’s Scenario Manager - Evaluation Methods
– Payback Period
– Calculating Cash Flow
– Net Present Value (NPV)
– Internal Rate of Return (IRR)
– Benefit Cost Ratio (BCR) - Build a Project Evaluator with MS Excel
- Case Study
PREDICTIVE ANALYTICS
Statistics are the best base to make forecasts and predictions from. In this module the techniques of simple regressions are discussed and demonstrated.
- Steps in the process
- Identifying drivers
- Identifying cost behaviour
- Testing the correlation
- Calculating the forecast formula
- Case studies
THE HEALTH OF AN ORGANIZATION (RATIO ANALYSIS)
Ratio Analysis is one of the best tools for performance evaluation. On the budget side, delegates will learn how to ‘balance’ budgets, realize why there is always a back and forth on budgets, as well as experience the dangers of a percent budget. They will alsomaster financial scoring of suppliers and clients, pick up some price and term negotiation tools and the danger signs to look out for
- Ratios Explained
– Profitability Ratios
– Liquidity Ratios
– Efficiency Ratios
– Gearing Ratios
– The DuPont Analysis - Building a Ratio Analysis Tool with MS Excel
- Building a Common Size Indicator with MS Excel
- Published Statements and Ratios
- Warning Signals in Financial Reports
- The Danger of the Percentage Budget
- Case Study
EXCEL NEXT GENERATION
This is the most exciting spreadsheet innovation in the last 20 years. Excel now has the function to capture data from
spreadsheets, files, the internet web, databases, Word and .pdf documents and newly from photos. The data is prepared
and analysed.
- The kaleidoscope views
- Grabbing data
- Transforming
- Creating a pivot table
- Using slicers and timelines
- Pivot charts
BALANCED SCORECARD
- Introduction
- The Four Fields
– Inherent Capability Metrics
– Product Metrics
– Customer Metrics
– Financial Metrics - Case Study
How Much?
Early Bird: R6490 + vat
Standard: R6999 + vat
When?
Date: 5-6 December 2024
Time: 08:00am 16:30pm (CAT Daily)
Discounts?
3-6: 5% off
7-11: 7% off
+12: 10% off
FAQ:
This is a 2-day interactive training webinar on financial management for built environment professionals, giving participants an introduction to financial statements to enable them to both understand and interpret the statements accurately.
The training is CPD Validated:
ECSA- 2 CPD Points
SACPCMP- 1.4 CPD Credits
Catering services will be offered by UBER Eats- Delegates to receive meal vouchers Daily, provided Uber Eats is available in your area*
What Do I Need?
Each delegate will need the following to attend:
- Steady Internet connection for the duration of the training
- Laptop / PC / Smart Phone and Power supply (Charger)
- Zoom Meeting Software installed onto your laptop /
- PC / Smart Phone
- Quiet Space
Preferable but not compulsory:
- Headset / Ear Phones to clearly hear the facilitator
About The Trainer?
Johan Bosman
Johan Bosman holds degrees in both law and financial management. During his management career, he was a lieutenant-colonel in the South African Police and subsequently became the CEO of several companies in South Africa, Tanzania, and Nigeria. Currently, he is a full-time trainer, drawing from his personal experience to deliver training sessions that focus on the aspects that contributed to his successful management career. His training fields encompass financial management, applied law, diversity, psychological communication skills, and general management skills.
Johan frequently conducts training workshops across Southern, Eastern, and Central Africa, as well as in Arabia. Occasionally, he also conducts workshops in Europe and the USA. He has gained popularity in the classroom and is dedicated to leaving behind a high-quality skill set in his trainees. Johan is married and resides in Mossel Bay, South Africa. Additionally, he maintains a farm just outside Pretoria, South Africa, where he breeds Nguni cattle and Dorper sheep. His extensive travels throughout Africa have fueled his passion for the continent, its people, and its cultures. Johan is one of the founding members of the Southern Africa Professional Trainers’ Association (SAPTA).
Terms & Conditions
Payment Terms:
- Payment is required within five (5) working days on receipt of tax invoice.
- Following completion and return of the registration form, full payment is required within five (5) working days from receipt of tax invoice.
- We reserve the right to refuse admission and withhold CPD points and certificate if payment is not received on time, a payment or an official purchase order must be received prior to the conference or training seminar.
Fees:
- Fees are exclusive of VAT
- Bulk discounts are not calculated on early bird price. Invoiced amounts need to be paid on or before the early bird date to receive the rate.
Cancellation Policy:
- All cancellations must be sent in writing at least 10 working days prior to the event.
- Cancellations within 10 working days before the event starts will not receive any refund and will be liable for the full invoiced amount, however, a substitution of the delegate will be allowed.
Indemnity:
- Should for any reason outside the control of BEST Training events, the dates or speakers change, or the event is cancelled due to an act of terrorism, extreme weather conditions or industrial action, BEST Training shall endeavour to reschedule but the client hereby indemnifies and holds BEST Training harmless from and against any and all costs, damages and expenses, including attorney’s fees, which are incurred by the client.
- The construction, validity and performance of this agreement shall be governed in all respects by the laws of South Africa and to the exclusive jurisdiction of whose courts the parties hereby agree to submit.
No-shows:
- Registrants who do not attend the event, without written notices as per the cancellation policy will be liable for 100% of the invoiced amount.
Important Notice:
- The booking form below constitutes as a legal binding contract.
Whilst every reasonable effort will be made to adhere to the advertised brochure(s), BEST Training reserves the right to change dates of events if the need arises.
Register
You have questions? Contact us today, we’re here to help.
You can also email us at info@besttraining.co.za
