FINANCIAL ANALYSIS & MODELLING
FINANCIAL ANALYSIS & MODELLING
Modelling techniques that this course teaches are used in investment appraisal, capital planning, budgeting, valuation, financial analysis, and forecasting to make accurate financial and business decisions at the right time. The course will deliver competencies in the use of Financial Tools designed for finance management. This course is for people who already can create moderately complex spreadsheets and want to add greater sophistication, and automation and build models.
Learning Objectives
At the end of this course, participants will be proficient in:
• Advanced financial performance presentation and analysis
• Loan management and loans schedules determination
• Product sales, marketers and distributors’ performance analysis
• Product costing and pricing decisions
• Investment appraisals and capital rationing solutions
• Cost of capital determination
• Cash flow planning
• Business forecasting
Pre-Requisite
Participants should already be using Excel on a regular basis.
Learning Contents
• Data Modeling
• Formula Auditing Tools
• Conditional Functions and Date Calculation
• Business and Financial Forecasting Techniques
• Building Financial Models
• Ratio Analysis and Ratio Interpretation from the Model
• What If Analysis (Sensitivity Testing)
• Capital Budgeting Techniques (Linear Programming)
• Cost of Capital
• Project Evaluation Techniques
• Present Value (PV)
• Introduction to Macro and VB scripting
PhysicalVirtual (local)Virtual (International)
| ₦ 199,500.00 | ₦ 165,000.00 | ﹩ 165.00 |
Available as in-plant. Fee: Negotiable.
Date:
April 23 – 25,
July 10 – 12,
August 5 – 7
October 16 – 18, 2024.
Who Should Attend?
People in Risk Management, Financial Control, Management accounts Financial and Investment Analysis
Property of Impact Consulting Nigeria.
