Financial Modeling
Training Program

Home / Financial Modeling Training Program

Course Overview

Key Takeaways

Course Outline

Review

Enquire Now

Course Overview

Financial Modeling Training Program

If you are looking for financial modeling training in Dubai or Abu Dhabi, then look no further. Join Lynchpin to construct Reliable Financial Models to Monitor, Valuate, Control and Grow Your Business! During the next year or so, the decisions your company makes and their consequences will establish how successful it is in riding out the current economic downturn. To determine a quantitative representation of your company’s actions, financial analysis and modeling can be used to calculate and compare the impact of business decisions and alternative scenarios on the company’s performance. Dubai, being the hub of regional financial decision making, had always attracted world’s best financial modeling skill set. Many of the past participants who have attended our advanced excel and financial modeling training in Dubai have enhanced their skills in both of these critical areas.

Course Details

Training Dates

26 & 27 March 2024

Training Fee

Start Course

Run This Course
In-House

Enjoy this certified
program at your premise of choice, with lower costs, and schedule that suits you best.

FULLY CUSTOMIZED
ACCORDING TO YOUR NEEDS!

Book In-House

Key Takeaways

Create

Create effective, accurate and robust financial models that meet your business needs

Understand

Understand the most widely-practiced and robust business valuation techniques

Learn

Learn to measure, interpret and predict company performance using Excel modeling

Effectively

Effectively communicate the results of your models to team members and senior management

Improve

Improve your decision-making processes and save time on financial analysis

Course Outline I

  • Financial Model vs Spreadsheet
  • Purpose of Financial Models
  • Right tool selection for Financial Modelling
  • Techniques of a wise Financial Modeler
  • Blueprint of a Financial Model
  • Golden Rules for Model design
  • Information gathering process
  • Addressing the key Design issues
  • Version-controlled Models
  • Gathering of Assumptions
  • Data entry best practices
  • Labeling & formatting of a Financial Model
  • Dynamic links & formulae
  • Overview of using Excel in Modelling
  • Most commonly used Excel Functions
  • Quick workarounds – Excel Shortcuts
  • Logical Functions; IF, AND, OR etc.
  • Nesting Logical Functions in Model
  • Aggregation Function; COUNTIF, SUMIF, COUNTIFS, SUMIFS etc.
  • Lookup Formulae; VLOOKUP, HLOOKUP
  • Nesting INDEX and MATCH

Course Outline II

  • NPV
  • IRR
  • XNPV
  • XIRR
  • Loan interest calculations
  • Loan Amortization Functions; PMT, IPMT, PPMT
  • Overview of Formatting a Model
  • Custom Formatting
  • Conditional Formatting
  • Creating sparklines for quick visuals
  • Array Formulae
  • Goal Seeking
  • Pivot Tables
  • Creating and using Macros in Financial Model
  • Calculating WACC
  • Modeling depreciation methods
  • Break-even analysis
  • Scenario analysis
  • Sensitivity analysis
  • Comparison of scenario methods
  • Working with Charts
  • Two axes chart creation
  • Waterfall charts
  • Bubble charts
  • Building individual Financial Model components
  • Connecting the components to prepare a dynamic Financial Model
  • Error-proofing of the financial model
  • Securing the contents of the financial model to avoid any unauthorized change

Trainer's Profile

Mr. Mirza Farrukh Baig,
FCA
Harvard Trained | CEO Lynchpin Group | Lead VAT Trainer & Consultant

Mirza Farrukh Baig-Harvard Trained, is one of our Decorated & Talented Trainer and Instructional Designer for Finance, Accounting, Risk Management training courses at Lynchpin Training. With him on the training venue, we guarantee the best style of delivery, team engagement, the energy level of the class and the WOW experience by your team is assured.

Mirza Farrukh Baig is a qualified Chartered Accountant and a career banker. He has over fifteen years of experience teaching CMA, ACCA, CFA and CA students. He is also the lead corporate trainer at Lynchpin delivering specialized training on Finance and Accounting He has served for eight years in a leading commercial bank in UAE where he was instrumental in strengthening the SME credit risk unit. Apart from approval of banking facilities for SME clients. He played an instrumental role in developing and implementing the SME credit risk policy of the bank.

Currently, he is the CEO of Lynchpin Training & Consulting and Chief Consultant for VAT Advisory, Consulting & Implementation. Farrukh carries extensive experience in dealing indirect taxes both for the UK and South Asia. Provided VAT (Value Added Tax) consultancy services with due care, experience, resources, and exposure to tax regimes.

Farrukh is an associate member of the Institute of Chartered Accountant of Pakistan (ICAP). He has been awarded a gold medal for outstanding performance in his CA final examination, by ICAP. He also went to Harvard Business School to Executive Entrepreneurship training program.

What our Clients have to say

I am implementing my real work in the training as it applies fully to what I do and it came to me at the right time, strategising now for my work based on the learnings from training
Manager Learning & DevelopmentThe Executive Council of Dubai
Excellent experience with Lynchpin and this session I will never forget. Their Trainer is very knowledgeable and has lots of examples from his experience. Keep up the good work lynchpin team !
Finance ManagerCivil Aviation Authority Abu Dhabi
Training was with live examples and case studies, Trainer has delivered the training with passion and sincerity. Both Venue and Training were Good.
Sr. Manager ReportingDubai World
Lynchpin workshop was great learning with my current tasks at work, which was taking me long time before the training.
Faiza NasirPortfolio Manager, NBAD
Fun learning and I am implementing my real work in the training as it applies fully to what I do and it came to me at the right time, strategising now for my work based on the learnings from training
Head of FinanceYAS Water World
Lynchpin’s session was informative and required for business heads. Trainer went to the required level of audience to make them understand the concept. (Head of Corporate Planning, Eurostar) Everything was well organized,Lynchpin is very respectable Training Company –
Accounts ManagerAl Wazan Oil & Gas
Trainer is very knowledgeable and patient and passionate with training. He make sure the trainees have fun ensuring they have learning as well. I have been with Lynchpin for CMA and now this and for both i felt well taken care of.”
DidithAccountant - Arthur D Little
Very Persuasive approach by Lynchpin , very accurate and worth for whole day listening to the trainer. The group work in inhouse program is worth attending.Excel is never delivered like this before.
Director SalesFerrari World
Lynchpin trainer is brilliant and have excellent delivery skills – a new way to learn Finance for Non-Finance.
VP Human ResourceThuraya UAE
Previous
Next
Master the Finance and related expertise with our unique and customized Finance Training options.

Explore

Contact Us

Stay Connected