Financial Modeling and Analysis 

Overview and Intro

This 2 days is designed as a first course for people who would like an opportunity to practise and improve their ability for financial modelling cash flows in Excel. The course is conducted in a workshop format, with the emphasis on “learning by doing”.
Financial modeling demands a logical consistent approach and this workshop builds a financial analysis and a valuation model through a series of practical stages. Upon completion, delegates will have a comprehensive understanding of financial modeling, as well as how each technique can applied.

The course covers:

• Cash flow modelling
• Determining debt capacity
• Developing key outputs for credit analysis
• Scenario analysis
• Guidelines for good modelling practice
• Excel tips and tricks
Financial modelling methodology

Video Preview Download PDF Download PDF Download PDF Price: N60,000

Schedule and Venue

Week-Ends: 4 days – 1 weekend (Sat/Sun) from 11.00am – 5.00pm.
Week-Days: 2 days – 1 weekday (Mon, Tue, Wed & Thurs) from 5.00pm – 7.30pm.
Online Tutoring: 4 days – 1 week (Mon, Tue, Wed & Thurs)  2 hours Anytime.
Training Type: Classroom Instructor –led Training

Lagos Venue: 3, Faramobi Ajike Street, Off Bush Street, Anthony Village, Lagos
PortHarCourt Venue: 6, Erabor Close, PortHarcourt. Rivers
Abuja Venue: 8 River Trent Street, Off Thames Street, Maitama, Abuja
Refreshment: Tea, Coffee, Cakes, Snacks and light Lunch.

Start & End Date: See Week-Day Calendar and Week-End Calendar
Price: N60,000

Topics and Outline


Day One
• Financial analysis and valuation framework model
• Core financial Modelling
• Planning assumptions
• Structuring assumptions and scenario analysis
• Modelling and formatting best practice
• Good model structure
• Good model design
• Optimum Structure and Targeting
• Accounting methods
• Market-based methods – EPS and multiples


Day Two
• Forecasting and Equity Valuation
• Forecasting Methods
• Reviewing Performance and Adding a Forecast.
• Modelling with Excel
• Excel helps - Excel as a tool for financial modeling
• Modeling growth drivers, depreciation, cost drivers, asset & debt schedules
• Modelling Fixed Assest
• Completing the balance Sheet
• Cash Flow Analysis
• Adding Free Cash Flow to the Model.
• Alternative Cash Flow Valuation:
• Management Reporting and Model Review
• Building financial models best practices
• Audit Review

Video Preview Download PDF Download PDF Download PDF Price: N60,000

Enroll and Register Now:

First/Last Name *

Invalid Input
Email Address *

Invalid Input
Phone Number *

Invalid Input

Course *

Invalid Input
Location *

Invalid Input
Payment *

Invalid Input
GT Bank
YOU ARE HERE: CBAP/Business Financial Modeling & Analysis