Call Colin at 082 888 1900
info@goalfix.co.za
GoalfixGoalfixGoalfixGoalfix
  • Home
  • About
  • Financial Models
    • Financial Model Building
    • Financial Model Reviewing
    • Online Model Evaluator
    • Financial Consulting
  • Training Courses
    • Online Live Training
    • Financial Modelling Courses
    • Certification Program
    • Public Course Dates
    • Course Selector
  • Articles
  • Contact

Foretelling the future – Modelling is the answer

    Home Financial Modelling Foretelling the future – Modelling is the answer
    Next

    Foretelling the future – Modelling is the answer

    By Colin Human | Financial Modelling | Comments are Closed | 15 Sep, 2015 | 0

    Fear of the future, and if not fear, then concern or hesitation is a common and understandable human emotion, which confronts all of us from time to time, even seasoned business executives.

    For centuries mankind has sought to predict or foretell the future, and modern business executives are no exception.
    The plethora of predictive business analytical tools is testimony to this fact.

    Whilst predicting the future may be a bridge too far, the proposition contained in this article is that through the application of modern financial modelling processes, executives can model or simulate the future of their organisations with remarkable accuracy.

    Properly constructed financial models, based on comprehensive and detailed analysis of the specific business structure, afford corporate executives the ability to explore alternative scenarios and conduct what-if analysis on all key business drivers.

    Successfully meeting the challenges of modern business, optimising shareholder value and managing for results, without using appropriate models, may indeed present management with an insurmountable challenge.

    Thanks to financial modelling techniques, the statement (adage) “if it can’t be measured, it can’t be managed”, need never apply to proposed business initiatives, irrespective of their nature.
    Financial Modelling defined.

    What is financial modelling?

    We at Goalfix define financial modelling as:

    “the assembly of all relevant components of a business case, in a logical and structured manner, into a predictive tool for the evaluation of financial performance.”

    Clearly to be effective, financial models must be properly researched, properly built, flexible and fit for purpose.

    Financial modelling is a general term that means different things to different users; for our purposes the reference usually relates to corporate performance and corporate financial applications.

    The financial modelling process has gained universal acceptance and rigor over the years, and in some cases, is an essential requirement for financing capital projects.

    Corporate Financial Modelling

    In corporate finance, investment banking and the accounting profession, financial modelling is synonymous with cash flow forecasting.

    This usually involves the preparation of large, detailed company specific models used for decision making purposes.

    These models are almost always discrete in time and are usually deterministic in nature (based on input assumptions).

    They are ideally suited to what-if analysis and determining the sensitivity of input assumptions.

    Applications include:

    • Evaluation of strategic initiatives
    • Scenario planning and management decision making ("what is"; "what if"; "what has to be done")
    • Mergers and acquisitions
    • Budgeting and budget evaluations
    • Capital budgeting
    • Cost of capital (i.e. WACC) calculations
    • Management reporting
    • 1, 2, 5-year forecasts
    • Rolling forecasts
    • Business optimisation involving financial analysis and / or financial statement analysis
    • Project finance
    • Business valuation, especially discounted cash flow, but including other valuation techniques

    Some Modelling Observations

    Modelling practitioners are sometimes referred to (tongue in cheek) as "number crunchers”.

    However, in reality, modelling requires insight, planning and analysis (see diagram) and by its very nature, demands the identification and quantification of the fundamental business drivers – the same drivers which derive from the determined business case or strategy.

    As such, it is the distillation of all the key elements of a business case, in a logical and structured manner, and the creation of a flexible dynamic predictive tool for business improvement.

    Patently to avoid model outputs which incorporate unrealistic assumptions and structural inconsistencies, it is critical that the business dynamics are fully researched. (for example, a forecast for growth in revenue but without corresponding increases in working capital, fixed assets and the associated financing, may imbed unrealistic assumptions about asset
    turnover, leverage and / or equity financing).

    What is required is that all key drivers of the business structure or strategy are carefully identified, and their relationships are explicitly and consistently forecasted.

    At all times a reality check based on the business model must be applied to crucial assumptions, and where appropriate, probability distributions and statistical measures such as regression analysis and Monte Carlo simulations may be required.

    Typically, financial modellers will have a completed an MBA or CA with (optional) coursework in financial modelling, but the process is in no way limited to persons with a background in finance.

    Modeller Knowledge

    The knowledge necessary for successful model building may be summarised as follows:

    a. Knowledge of essential spreadsheet functions and techniques required to build comprehensive models,

    b. Knowledge of accounting conventions and the composition of financial statements

    c. Knowledge of corporate financial principles and terminology, performance measurement, measurement of returns, Present Values, Internal Rates of Return, and net and free cash
    flows,

    d. Knowledge of best practice financial modelling methodology

    Model Anatomy

    Model Outputs

    Typical outputs from financial models include:-

    1. An executive summary, incorporating all key results, ratios, sensitivity analysis, alternative scenarios and supporting graphs.
    2. A comprehensive set of financial statements including an Income statement, Balance sheet, Cash Flow and all relevant supporting schedules.

    Modelling Benefits

    Stemming from the basic premise that the primary responsibility for all corporate executives is to maximise shareholder value, and given the complexity of modern business, financial modelling offers the following very real and tangible benefits:-

    1. “What if” analytical capability
    2. Multiple scenario evaluations
    3. Instant identification of key drivers – sensitivity analysis
    4. Identification and evaluation of risk 
    5. Answers to questions such as:
      • which components of performance optimise the creation of shareholder value?
      • what are the key drivers of RONA / ROCE / ROE?
      • what annual compound growth rates are achievable, and what effect will these have on working capital, cash flows and RONA / ROE?
      • what is the internal sustainable growth rate based on current profitability, activity and cash flows? 
      • what effect will gearing (leverage) have on shareholder returns (ROE)?
      • what is the dividend capability based on free cash flows? 
      • is the business performance adding value in relation to the WACC – Economic Value Added (EVA analysis)?                   

    Conclusion

    Clearly strategic planning and scenarios are a vital part of setting business objectives and goals, and properly constructed financial models are invaluable tools to quantify or measure the effects of such strategic plans. Unquantified strategy, in truth, is little better than wishful thinking.

    Historically whilst there may have been a modicum of scepticism about the art of modelling, the development of sustainable modelling process and best practice methodology has long since laid any reservations to rest.

    No tags.

    Colin Human

    Colin Human is one of South Africa’s leading financial modellers with extensive business experience. A chartered accountant, he has occupied various senior management positions in both public and private companies across a wide range of industries from Aluminum, Building, Ceramic Tiles and Engineering to Granite, Education, Hotel and Corporate Finance. He is currently a director of a number of companies and CEO of GoalFix (Pty) Ltd.

    More posts by Colin Human

    Related Posts

    • What’s the most important thing in a financial model?

      By Colin Human | Comments are Closed

      I recently had the opportunity to share one of my passions with more than 100 interested parties. I was asked to present “Ratio Analysis and related issues” by CPD Campus. Apparently my presentation was wellRead more

    • Financial Modelling – not muddling!

      By Colin Human | Comments are Closed

      Muddling can be defined as coping in a more or less satisfactory way despite a lack of understanding, expertise, planning, or equipment. Hence the expression “ I don’t really understand the problem or the solution,Read more

    • Hedgehog or Fox?

      By Colin Human | Comments are Closed

      Foxes are more adaptable of the environmental changes, whereas hedgehogs stick to believing that focus ultimately determines success.

    • Seeking A Career in Finance? Here Is Why You Should Learn Financial Modelling and Valuation!

      By Colin Human | Comments are Closed

      Financial modelling specialists summarise an organization’s expenditure and income in a spreadsheet, to understand how future decisions or events would impact the company financially.

    • Financial Modelling Summit Presentation by Colin Human

      By Colin Human | Comments are Closed

      Financial Modelling – What’s it all about from Colin HumanRead more

    Next

    Recent Posts

    • 15 Aug, 2022
      Comments Off on Fortune favours the prepared mind

      Fortune favours the prepared mind

    • 19 Jul, 2022
      Comments Off on What’s the most important thing in a financial model?

      What’s the most important thing in a financial model?

    • 5 Jan, 2022
      Comments Off on Financial Modelling – not muddling!

      Financial Modelling – not muddling!

    • 12 Oct, 2021
      Comments Off on Hedgehog or Fox?

      Hedgehog or Fox?

    Upcoming Courses

    22 - 25 Aug

    Financial Modelling Fundamentals Course

    Mon , Live Online Training
    Course Detail
    29 Aug
    01 Sep

    Real Estate Financial Modelling Course 

    Mon , Live Online Training
    Course Detail
    08 - 09 Sep

    Complete Introduction to Power BI Desktop

    Thu , Live Online Training
    Course Detail
    No event found!
    Load More

    Recent Posts

    • Fortune favours the prepared mind

      I recently sent an email to our Goalfix community – the message

      15 Aug, 2022
    • What’s the most important thing in a financial model?

      I recently had the opportunity to share one of my passions with

      19 Jul, 2022
    • Financial Modelling – not muddling!

      Muddling can be defined as coping in a more or less satisfactory

      5 Jan, 2022
    Goalfix © 2022 All Rights Reserved | Website by Adarna
    • Home
    • About
    • Financial Models
      • Financial Model Building
      • Financial Model Reviewing
      • Online Model Evaluator
      • Financial Consulting
    • Training Courses
      • Online Live Training
      • Financial Modelling Courses
      • Certification Program
      • Public Course Dates
      • Course Selector
    • Articles
    • Contact
    Goalfix