Course Overview:

This course is designed to build strong, practical financial modelling skills using Excel, covering everything from core modelling fundamentals to advanced, decision-driven analyses. Participants will learn to develop fully integrated financial models, perform budgeting, forecasting, valuation, and scenario analysis, and apply interactive controls and visualization techniques to support effective financial decision-making.

Learning Outcomes:

• Create integrated financial models in Excel (Income Statement, Balance Sheet, Cash Flow).

• Build budgeting, forecasting, and valuation models using data-driven assumptions.

• Model key financial components such as revenue, costs, assets, liabilities, depreciation, financing, and taxation.

• Perform what-if, sensitivity, and scenario analysis to evaluate the impact of changing assumptions on financial outcomes.

• Analyze and interpret model outputs to support informed business and management decisions.

• Show time series data by plotting & displaying information.

• Determine how to model exponential growth & compound annual growth.

• Collaborate and share financial models effectively while maintaining data integrity and version control.

• Loan Scheduling, Make or Buy Decision, NPV, IRR, MIRR Analysis

Please note: We provide tailored versions of our courses to cater to the specific needs of organisations. The pricing for customised courses may differ from that of our open-enrollment courses. For more details on pricing and instructor information, kindly reach out to us via email at ces@lums.edu.pk

Course Outline

Dabeer Khalid

Dabeer Khalid is a Fellow Member of ICAP (Pakistan) and ACCA (UK) with 16+ years of experience at PxW, Deloitte, and Fatima Group. A recognized Data Analytics and Financial Modeling expert, he specializes in Excel-driven analytics, dashboards, and financial models, delivering hands-on, results-oriented training that turns data into confident business decisions.

Application Process:

Participants must register online through the CES website by clicking on their desired course and filling out a one-page form. Before starting the registration process, please ensure that you have the following:

- A passport-sized photograph for the CES smartcard. It should be against a white background.

- Correct CNIC details.

Incorrect information provided during the registration process will lead towards cancellation of your enrolment at any stage, and participants will not be entitled to claim a refund.

Once you have completed your online registration, you may proceed to the payment section. You have two options:

1. Pay online using your bank debit/credit cards through the LUMS online payment system https://pay.lums.edu.pk

2. Download the fee voucher and deposit cash in any branch of the designated banks specified on the fee voucher.

Once the payment has been made, you will receive a confirmation email within 24 to 48 working hours, and your payment status will be updated to "ENROLLED" in the online application portal.

Installment:

KalPay Taleem offers monthly installments for all CES on-campus courses and workshop fees. For more details, contact via WhatsApp at 0328 3044414 (working hours - 9:30 AM to 6:00 PM), or visit taleem.portal.kalpayfinancials.com/sign-up to apply!

Note: CES may cancel or postpone a course due to insufficient enrolment or unforeseen circumstances. In this case, the university will refund registration/processing fee (if any) but will not be responsible for any other related charges/expenses including cancellation/change charges by airline and travel agencies.

Please go through Policies & Code of Conduct