Effective Use of MS Excel Basic To Intermediate
Course Features
Course Details
Program Introduction
Accounting and Finance concepts are quite challenging for Non-Finance Professionals to understand and apply in their daily work life. The rocket science of numbers and their interpretation as useable data need sufficient knowledge of concepts and principles. As a training company, we believe that the best way to make these concepts understand in simplest possible way is by adopting “Learning by Doing Approach”. Entire training program revolves around a ‘Simulation Board Game’ called “Fintellect” which encompasses all relevant accounting and finance areas of learning.
Learning Outcomes:
Finance & Accounting Knowledge
Thorough understanding of business analysis, operational and tactical challenges, cost & pricing structures, customer & product profitability analysis and ability to read and understand financial statements.
Business Acumen
How to run business efficiently through synchronizing sales, purchases, cash flows, debtors, creditors. Managing challenges like increasing cost, shrinking margins, discount offers and creating strategies to boost sales.
Performance Analysis
Setting financial and non-financial targets, KPIs, Financial Thresholds, managing covenants and measures to achieve profitability targets.
Financial Management
Understanding project evaluation techniques, Time value of money concepts, capital structuring, cost of capital & EVA, sources and uses of funds, acquisition & divestments etc.
Team Work
Team coherence, consultation and collective decision making is the essence of game. Managing differences, storming & norming, leadership challenges and owning failures and mistakes creates an unforgettable journey of teamwork.
Training Outline
- The Rocket Science of Accounting
- Accounting Fundamentals & Principles
- Double Entry Accounting, ledgers & Books
- Income Statement, Balance Sheet & Cash Flows
- Cash vs. Accrual Accounting, Business Dilemma
- Business Model Review
- Know your Business – Analysis & Analytics
- Comparative Financial Statements & Business Reports
- Ratios – Liquidity, Profitability & Solvency
- Capital Structure, Debt, Equity & Covenants
Formulate Business Plan
- Budgeting, Forecasting & Financial Plan
- Working Capital Cycle Review
- Control the Mad King – Cash
- Reign Receivable, Credit Sales, Creditors & Expenses
Business Cycle – Quarter 1
- Learn Accruals & Prepayments
- Capex vs. Opex, Buy vs. Lease
- EOQ & Inventory Management
- Deal with Challenging Debtors
- Prepare Quarterly Financial Statements
Business Cycle – Quarter 2
- Business Performance Review
- Stretch Arms – Manage Sales & Procurement
- Review Debtors Performance & Recovery Strategy
- Strategize liquidity & Inventory Management
- Prepare Half Yearly Financial Statements
Business Cycle – Quarter 3
- Manage Competitors, Pricing & Cost
- Ensure Breakeven, Review Customer & Product Profitability
- Avoid slowdowtn, Stretch Working Capital Cycle
- Deal with Challenging Sales, Vendors & Regulatory Issues
- Prepare Quarterly Financial Statements
Business Cycle – Quarter 4
- Learn Project Appraisal Techniques – TVM Concept
- Diversify, Divest & Spin off
- Acquire Subsidiaries & Equity Interest
- Learn Economic Value Addition (EVA)
- Prepare Yearly Financial Statements
Training Outcome
Finance & Accounting Knowledge
Thorough understanding of business analysis, operational and tactical challenges, cost & pricing structures, customer & product profitability analysis and ability to read and understand financial statements.
Business Acumen
How to run business efficiently through synchronizing sales, purchases, cash flows, debtors, creditors. Managing challenges like increasing cost, shrinking margins, discount offers and creating strategies to boost sales.
Performance Analysis
Setting financial and non-financial targets, KPIs, Financial Thresholds, managing covenants and measures to achieve profitability targets.
Financial Management
Understanding project evaluation techniques, Time value of money concepts, capital structuring, cost of capital & EVA, sources and uses of funds, acquisition & divestments etc.
Team Work
Team coherence, consultation and collective decision making is the essence of game. Managing differences, storming & norming, leadership challenges and owning failures and mistakes creates an unforgettable journey of teamwork.
Training Story
Finance & Accounting Knowledge
Thorough understanding of business analysis, operational and tactical challenges, cost & pricing structures, customer & product profitability analysis and ability to read and understand financial statements.
Business Acumen
How to run business efficiently through synchronizing sales, purchases, cash flows, debtors, creditors. Managing challenges like increasing cost, shrinking margins, discount offers and creating strategies to boost sales.
Performance Analysis
Setting financial and non-financial targets, KPIs, Financial Thresholds, managing covenants and measures to achieve profitability targets.
Financial Management
Understanding project evaluation techniques, Time value of money concepts, capital structuring, cost of capital & EVA, sources and uses of funds, acquisition & divestments etc.
Team Work
Team coherence, consultation and collective decision making is the essence of game. Managing differences, storming & norming, leadership challenges and owning failures and mistakes creates an unforgettable journey of teamwork.
Who should attend?
This course is considered essential for all non- finance professionals working in areas of Supply Chain, Procurement, Sales, Marketing, Information Technology, Administration and Human Resources. It is highly recommended for all those professionals in the management hierarchy who have significant responsibility for performance management and impact the financials and profitability of the company
Training Investment: PKR 32,500 + ST
Training Location: PSTD, Lahore& Karachi
Trainer Name: Aasim Alee
Karachi: 25th& 26th July 2022
Lahore: 21st& 22nd July 2022
Investment per participant: PKR 38,500 + ST
For Further Details
Email: babar.khan@wordpress-764963-3017117.cloudwaysapps.com / uzair.tariq@wordpress-764963-3017117.cloudwaysapps.com
Number: 0333-2406753 / 021-35857484/ 03319763144
Click here to Download Flyer
Payment Details:
The cheque will be made under the name of “Pakistan Society for Training and Development” and dispatch it to following address;
Pakistan Society for Training and Development
Plot # TC-3, 34th Street, Khayaban-e-Seher
Phase V, DHA, Karachi 75500.
Cancellation Policy:
PSTD Cancellation Policy – Cancellations made at least 5 working days prior to the program will be refunded 50%. If a booking is canceled in less than 5 working days, no refunds can be given. Cancellations must be confirmed by a letter or email. Substitutions may be made at any time for the same program only. In case of the participant not showing up on the day of the training a replacement can be sent.
More Courses by this Instructor
Asim Alee
