ERP Training -
Foundation Level of
“SAP EC.6 FI/CO Module”
ISLAMABAD BRANCH COUNCIL
ICMAP
Dec. 1st & 2nd, 2012 (Saturday & Sunday) from 9 am to 5
it is impossible to create and maintain a custom designed software package which will cater to all their requirements and also be up-to-date.
OBJECTIVES OF THE TRAINING
By the end of this training, trainees will have an understanding of the capabilities of the SAP features, especially in the area of Payable Management, Cost Centre Accounting, Banks Management and Funds Management and the skills necessary to perform routine accounting tasks in these modules.
WHO SHOULD ATTEND?
All those who are desirous to enhance their skills by acquiring training of SAP Solution in Financial Module, Professionals planning to become SAP Consultant, ERP users or looking for some good job in Pakistan or abroad would find it an excellent opportunity to achieve their goals.
TRAINING CONTENTS
SAP R/3 Applications & Navigation
ASAP Methodology
Organizational Elements
Master Data Maintenance ISLAMABAD BRANCH COUNCIL
Document Control, Posting Tips
Payment Process
Funds Management
Cost Centre Accounting
GL Account Maintenance
Reporting
TRAINER’S PROFILE
Mr. Waqas Ahmed Paracha, FCMA is SAP EC.6 Certified Solution Consultant and Specialist in integration of SAP Different Modules. He is the CEO of Tally Marks Consulting (PVT) Limited (www.tallymarks.co). He has also worked in the areas of Standardization of Accounting Framework, Preparation of SOPs and Workflows, Implementation of Costing and Financial Accounting Systems, Development of Policies and Procedures manuals, Budgeting & Planning.
Financial Modeling using Excel
Dec. 8th & 9th, 2012 (Saturday & Sunday)
THIS PROGRAM IS DESIGNED FOR:
Finance and Accounting, business managers, research professionals, financial controllers, accounting managers, financial directors, senior accountants, financial analysts and general ledger accountants.
WHAT THE STAKHOLDERS’ ULTIMATE VISION IS?
- Profit & Loss forecast
- Cash Flow forecast
- Financial Analysis using critical Ratios
- Dashboard techniques
BY THE END OF THE PROGRAM, PARTICIPANTS WILL BE ABLE TO:
Learn and practice all the advanced tools in Excel 2010 by applying them to real-life business cases; Develop practical models in Finance,
Business,
Accounting and Research;
Build Dynamic Business Dashboards to assists professionals in measuring performance and enhance decision making;
Learn Capital Budgeting techniques & discover developing useful Investment appraisal models;
Build Automated Financial Models using forecasting and what-if analysis;
Perform MACROS to automate and manage models efficiently;
Building KPIs & other financial models.
Contents of the workshop :
I. FINANCIAL MODELING INTRODUCTION • What is Financial Modeling • Attributes of good Excel Models • Financial Modeling Tools • Steps in creating Financial a Model using Excel
MIRR, XIRR & ROI Calculators
Common mistakes in Financial Modeling • Customization of Excel view
II. INVESTMENT APPRAISAL • CalculatePV, FV, NPV and IRR in Excel • Payback & Discounted Payback
III. CAPITAL BUDGETING TECHNIQUES • Capital Budgeting Functions and Formulas • WeightedAverageCostofCapital (WACC) • Capital Asset Pricing Model (CAPM)
IV. BREAK-EVEN ANALYSIS • Break-even Analysis • Break-even Visualizer • Forecasting Sales & Profits using Target break-even approach
V. BANKING MODELS& LOAN MODELS USING FOLLOWING TOOLS • Advance Functions and Formulas(PMT, IPMT, ISPMT, NPER) • Data Validation & Scroll Bars • Using What-if-Analysis o Data Tables o Goal Seek o Scenarios • Conditional Formatting • Graphs & Charts • Macros & using buttons allotted to different scenarios • Name Ranges & Flexi fields • Protection to sheets & files
VI. CASH FLOW STATEMENT & RATIO ANALYSIS • Annual Cash Flow Analysis • Cash Flow to Equity approach • Financial History & Ratio Analysis
VII. DASH BOARDS AND DATA PRESENTATION TECHNIQUES • Creating Dynamic Charts • Two ways to build Dynamic Charts in Excel • Assigning Names & Forms Buttons to Charts • Insights for Management Reports
Course Facilitator:
Asif Hafeez ACMA, APA, MBA
Financial Modeling & Advance Excel Trainer
Mr.Asif HafeezACMA, APA & MBA is expert in Financial Modeling & Advance Excel. He has trained hundreds of excel users within his professional community and built a number of models. He is a Qualified Management Accountant & done Masters of Business Administration. He has more than 10 years of working experience in Oil & Gas sector. He is the member of following professional bodies.
1. Institute of Cost & Management Accountants of Pakistan (ICMAP)
2. Pakistan Institute of Public Finance Accountants (PIPFA)
Latest Training at ICMAP:
• He conducted a workshop at ICMAP-Islamabad during October 20th & 21st on “Financial Modeling Using Excel 2010”.
• Also conducted a workshop at ICMAP-Islamabad during August 2011 Four days’ workshop on “Advance Excel 2010”.
His Personal Key Developments:
Today Excel is a powerful tool to build various Models and Mr. Asif used Excel at the level which brushed up his Financial Modelling Skills and many of his trainees from the various organizations are using his own built time savor Excel Models. Quick reviews of his key developments are highlighted below;
Financial Models using Excel are still being used in his professional community.
Excel based Automatic linked Financial Statements Model from Trial Balance for Management Accounts (including Balance Sheet, Profit & Loss Account and Cash Flow Statement).
He built some excellent Dashboards Reporting Packages covering Cash flows and from other GL activity.
Aging Analysis Models using Advance Excel.
He has prepared some Financial Analysis spread-sheet Solutions and What-if-Analysis Models.
He has also developed some Excel based time saving Decision making Tools (Feasibility Reports).