PCN ICT Training Centre

TRAINING PROGRAMMES

Financial & Valuation Modelling

Duration: 12 hours

This aims to give mastery to persons interested in making financial analysis, projections, focasts using a speedsheet tool. If your duties require you to deal with large, complex financial calculations this course simplifies and automate your work to assist decision making

Targets : Accounting/Treasury, Finance & Investment, Equity research, Business Development and Analysis, Business planning & strategy, or Commercial banking, CA, ACCA, CFA , FRM, Masters in Finance or Accounting and thoses in Managerial roles. Also ideal for those with Degree, Diploma, B .TECH in engineering and Commerce who want a career in finance.

Planning Assumptions

  • Obtaining source data
  • Coding inputs
  • Structuring assumptions and anticipating scenario analysis
  • Modelling and formatting best practice
  • Good model structure
  • Good model design

Starting to forecast the income statement

  • Starting to forecast the P&L from key assumptions
  • How far can we progress?
  • What’s stopping us from continuing?
  • Key drivers for modelling
  • Key ratios driving the forecast
  • Drivers on revenues
  • Drivers on costs
  • Sources of data.

Modelling fixed assets

  • Forecasting assets
  • Key drivers on asset intensity
  • Capital expenditure
  • Depreciation
  • Forecasting depreciation

Completing the balance sheet

  • Drivers for balance sheet items
  • Which creditors can we stretch, and by how much?
  • How quickly can we collect debtors?
  • Forecasting the balance sheet
  • Impacts on cash flow
  • Is growth good?
  • Linking to other statements
  • Balancing the balance sheet

Completing a financial model

Modelling debt

  • Forecasting a simple debt schedule
  • Linking to other statements
  • Tools for resolving circularity
  • Setting debt paydown

Cash flow

  • Modelling the cash flow statement
  • Key linkages to other statements
  • Presenting the cash flow statement
  • Forecasting cash flow to equity
  • Forecasting unlevered cash flow

Excel modelling exercise: a new deal

  • Developing a new structure for a new deal the client is contemplating
  • Modelling sources & uses of funds
  • Developing a “first cut” debt structure
  • Calculating refinancing needs
  • The role of working capital and extra cap ex requirements
  • Typical financing and transaction fees
  • The impact on the model: calculating goodwill and the pro-forma balance sheet

Select Topics in Financial Modelling

Working with a financial model

Performing scenario and sensitivity analysis in the financial model

  • What scenarios make the most sense?
  • How can we structure the financial model to run those scenarios easily?
  • What happens to our outputs as the model is stressed?
  • How can we best present the information?
  • Instant scenario switching with drop down boxes

Defining key outputs in financial modelling

  • What are the most important outputs?
  • How can they be presented clearly?
  • How can we put for example, anticipated sales, capital expenditure and working capital plans into context?

Excel modelling help

  • Delegates are provided with the opportunity to ask for help with particular Excel functions
  • Use of these functions is demonstrated in class and supplemented with exercises which the class works through together

Lessons in good modelling practice

  • During the course delegates work to create their own models, establishing and observing spread sheeting best practice as they progress
  • Good modelling techniques are observed throughout the course, discussed in groups and demonstrated during the program
  • At the end their time participants finish with their own modelling work (which they have created following modelling best practice) plus a hard copy and permanent record of “modelling tips”

Payment Information

OPTION 1

Step1 - Fill a registration form for the course

Step2 - Make cash deposit into the Bank Accounts below

  • Fidelity Bank
  • PCN TRAINING CENTER:1300616905213
  • Branch : Kwame Nkrumah Avenue

Step3 - Send payment info: name, course title and pay-in slip to admissions@pcnicttrainingcenter.com

OPTION 2

Step1 - Fill a registration form for the course

Step2 - Submit a Bankers Draft with name below at the office

PCN TRAINING CENTER

Contact Address