Overview and Intro

This 2 days course 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

Schedule and Venue


WEEKDAYS-14th-15th

WEEKEND- 12th- 13th


Time : 10 am - 5pm

Venue: 3, Faramobi Ajike street, Anthony Village, Lagos state.

FOR INQUIRY; 234-8180-224477 |08185588771/ BBPIN: 33422647

http://www.sijisontraining.com

Price: N48,000


COURSE 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