Financial Modeling

Financial Modeling Using Advanced Features of Excel

INTRODUCTION

The Advanced Financial Modeling is a skill one can acquire through practice using MS
Excel. It involves building financial models sometimes from scratch or sometimes
maintaining and updating the existing financial models. It ranges from simple formulas
to complex computer programs that may take hours to run. An increasing need to build
financial models purposefully to aid in taking business decisions as well as the need to
integrate financial statements has made it essential to master the use of Microsoft
Excel’s financial tools in this regard.

TARGET AUDIENCE
- Accountants
- Finance Directors
- Financial Analysts
- Chief Financial Officers
- Financial planners

Course Objectives
- To apply the use of automation functions features to enhance efficiency
- To Validation of data to increase accuracy of data quality
- To Test for statistical differences in financial appraisals
- To appreciate the key concepts of financial modeling
- To examine the importance, implications and uses of financial Modeling in both
organizational decision making and strategy implementation
- To appreciate the analytical tools available within financial modeling
- To provide hands-on model design and construction

Benefits
At the end of this module, participants will be able to
- Make Financial performance projections
- Forecast income statements and balance sheets
- Conduct sensitivity analysis
- Make budgetary projections
- See roadmaps to profitability
- Check investment requirements
- Quantify and predict Risk
- Identify under Valued securities Statements

COURSE OUTLINE
Module 1: Introduction to Excel Power Functions
Module 2: Financial Models
Module 3: Financial Modeling Computation
Module 4: Financial Analysis
Module 5: Annuity
Module 6: Goal Seek
Module 7: Financial

Related Courses

KTI FACILITY MANAGEMENT

FACILITIES MANAGEMENT

This course is designed for professionals who wish to acquire the requisite skills for effective
facilities management. It will provide particip ….

Asset_Management_Blog_Graphic

FIXED ASSETS MANAGEMENT

This course is designed to provide participants with the tools, knowledge, and
confidence to successfully manage fixed asset, be able to ct information to …

FINANCIAL ANALYSIS PLANNING AND CONTROL

Public Financial Management (PFM) is the system by which financial resources are
planned, directed ….