CATEGORY TYPE: Finance & Accounting

COURSE NAME:Cash Flow Analysis


UPCOMING EVENTS


START DATE END DATE CITY/COUNTRY PRICE Request
This course can be scheduled at your convenience, to request this course please click here
OUTLINE:

 

Authoring of Projections:

The introductory section deals with the ownership and authoring issues of projections and the importance of having Borrower provided projections as a basis of analysis.  The use of in-house prepared statements and CPA prepared statements are discussed.

  • Borrower Responsibilities
  • Internally Prepared Projections
  • Financial Statement Preparation
  • CPA Compilations
  • CPA Reviews
  • CPA Audits
  • CPA Projection Responsibilities
Classical Analysis:

This section deals with external and internal factors that could influence a company.  This classical approach to business analysis is reviewed as a foundation to the sources of data and likelihood of attaining sales forecast numbers.

EXTERNAL FACTORS:

  • Economy
  • Company Position
  • Industry
  • Financial Strength
  • Management

 INTERNAL FACTORS:

    • Nonrecurring Items
    • Bad Debt
    • Inventory Write-offs
    • Salaries
    • Family members as employees
    • Non-business expenses
  • Fringes
  • Pension and retirement expenses
  • Bad debts not written-off
  • Capitalized or expensed items
  • Interest on subordinated debts
  • Affiliated debts, rents, payments
  • Insurance costs
  • Salary changes for new management
  • MIS, accounting procedures
Internet Resources:

The exciting new tools of the internet are discussed and shown.  Students gain a basic understanding of the tools available on the internet for company research.

  • Introduction to the internet 101
  • Industry information
  • Company information
  • Trade Associations
  • Periodicals
  • Commodity prices
  • Equipment prices
  • News Groups
Historical Analysis:

Historical data is used as a basis of comparison to the projections.  Adjustments to historical numbers are discussed with a variety of ways to gain comfort with adjustments from historical numbers.  Monthly and annual formats are also discussed.

  • Overview of historical approach
  • Revenue projections
  • Cost of Sales projections
  • S, G&A projections
  • Add-backs and Add-ins
  • Allocations from a parent company
  • Field Examination data
  • Monthly projections
  • Annual Projections
  • Operating cycles
  • Operating Cycles and Turnover Interpretations
Projection Model Overview:

Cash Flow Model assumptions and inputs are discussed here, allowing students to gain an overview of the model and layout of the spreadsheet.  Basic setup requirements and a list of required items for easier input are discussed.

  • Model Introduction
  • Review of Model sections
  • Spreadsheet layout
  • Gathering data
  • EBITDA
  • TNW
  • Additional training courses available
Hands-On Cash Flow Model:

Several hours are spent with a case study to allow students to use the cash flow model and study the affects of various assumptions.  Students learn to balance and test inputs verses outputs for reasonableness.  The importance of loan formula setup, line caps and advance rates are highlighted.

  • Case study
  • Case study inputs
  • Debugging input errors
Analysis of Model Results:

Outputs are reviewed with the case answers.  A problem solving format is used to illustrate any errors made by students in the case study and the meaning of the cash flow analysis is discussed page-by-page.  Users will see the difference between income, debt coverage, interest coverage and line availability.  Sensitivity to a variety of inputs (i.e., interest rate and gross margin changes) are illustrated.

  • Case Study Answers
  • Page-by-page discussion of results
  • Cash Flow verses line availability
  • Sensitivity analysis
DURATION:
    • 5 Day(s)
  •  


    The presentation is generally appealing to me. The dedication & devotion of the instructor are both laudable & admirable.
    Mohammed F. Alotaibi
    Sabic

    Really this course is important for any inspector, so I will recommended it for our employees. And thanks a lot!
    Ahmed Al-Yami
    Sabic

    You are doing excellent bringing such very talented instructor. Please keep it up.
    Ahmed Afifi
    Al-Zamil CoolCare

    I would like to appreciate you as well as the instructor for a good training due to the fact that the helping to gain new information about the types of valve with advantages and disadvantage as well. Many thinking.
    Zaki Ali Aldawood
    Sabic

    This course was very beneficial and helpful to understand one of the Major NDT method. I encourage ITC to continue with this performance.
    Talal Saad AlHasawi
    Sabic

    ITC service was in overall excellent. Thanks.
    Wael M. Morsy
    Mobily

    This course was good and a nice guide to the PMP exam. Thanks.
    Yazeed Mohamed Mreki
    General Authority of Civil Aviation (GACA)

    It was good course & good preparation with excellent instructor. Thanks a lot.
    Faisal Mahdi Al-Qahtani
    Sabic

    It was a nice course to have. I suggest taking this course with the same instructor to other people. Thanks for the instructor for his kindness & helfull during the course.
    Abdul-Moniem Al-Humoud
    Sabic

    It is very important course, which enable us to improve our knowledge to work approaching our big account and can be recall us the key account. This is will support us to active result for the best of the Co.
    Mohammed Amjad
    Al-Suwadi Services

    The instructor is highly and technical knowledgeable in explaining all the subject in the course taken.
    Noel V. Garan
    Coldstorec Group Of Saudi Arabia

    Instructor was well prepared and knowledgeable I gain lot of useful information.
    Gulam Khan
    Saudi Aramco

    It was a good learning experience. Got to know the concept involved in key account.
    Muthuraman Nachiappan
    Al-Suwadi Services

    The instructor Mr. Ahmed Sabry has a very nice spirit.
    Salam Fakhoury
    Al Khodari Company

    It is very useful to us and increase our knowledge.
    Mohammed Rashed Afifi
    Al Khodari Company

    The course is excellent and helpful. It help me in organizing the work in more safe manner.
    Muzammil Hayat
    Al Khodari Company

    The instructor is very knowledge and hard working, his way of teaching is very good.
    Ibrahim Darwish
    Al Khodari Company