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

Financial Modelling in the Real World

    Home Case Studies Financial Modelling in the Real World
    NextPrevious

    Financial Modelling in the Real World

    By Colin Human | Case Studies | Comments are Closed | 15 Feb, 2016 | 0

    Financial modelling can be used in many scenarios in a variety of businesses. In our case studies we will have a look at how financial modelling works in the real world and how businesses use the financial models to make decisions.

    Client 1:

    A large plantation in the pulp industry.

    Background:

    The plantation wants to transfer expertise in Eucalyptus forestry management to biomass fuelled power plants in Africa. The power plants should be supplied by a dedicated forestry operation which started planting Eucalyptus trees in 2012.

    The Brief:

    To support discussions with potential investors, the Plantation needed a detailed financial model. Whilst the operation of power plants is well established and their modelling is relatively familiar, the dedicated forestry operation was proving more challenging to forecast. The growth of Eucalyptus trees increases with age early in their life and the challenge was to calculate how many hectares to plant and when, in order to fuel the power plants, without overplanting, which would incur extra cost.

    Challenges encountered:

    • The unusual requirement to track the growth and harvesting of crop, the growth rate of which varies by age.
    • Developing an optimal schedule for planting, to ensure that power station demand would be met in the most economical way.
    • Allowing for different construction scenarios for two power plants, the construction costs of which varied depending on the chosen construction schedule.
    • In order to support the financing of the business, the model was required to be able to present both the consolidated investment opportunity (plantation and power station together) and as two individual projects.
    • The interdependence of the plantation and biomass power stations, i.e. the plantation needs to grow enough crop to meet the demand, in m3, of the biomass power station, yet the power station demand, in m3, depends on the age (i.e. the density) of the crop being harvested.
    Approach Used:
    • Financial Modellers extracted data from feasibility studies, crop growth forecasts, engineering studies and various other reports, translating and compiling each of the numerous processes involved, along with their associated costs, into an integrated financial model.
    • They made intelligent use of links to feed data between the two main elements of the project (forestry operation and power plant), in order to overcome their inherent circularity.
    • Using VBA to utilise and automate MS Excel’s Solver add-in, allowing the client to effortlessly determine optimal solutions for different input scenarios.
    • Using switches to allow the client to present the business as either ‘Stand-Alone’ or ‘Combined’ investment projects to potential stake holders.
    • Generating a full set of financial statements; Profit & Loss, Balance Sheet and Cash Flow, accompanied by industry specific metrics; e.g. stumpage.

    The Outcome:

    The model supported the verification of management decisions to formulate an optimal construction and planting schedule, including the decision to push back opening of the first power station in order to allow the plantation to establish further and therefore produce considerably greater yields.

    Apply for a course today to learn more about Financial Modelling.

    Goalfix Financial Modellers have a wealth of experience in building models for countries, governments and multinational companies.  Established in 1998 Goalfix Financial Modellers has grown into a highly specialized firm of financial modellers and model trainers. To learn more about financial modelling services or financial modelling courses offered contact Goalfix today.

    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

    • Efficient vs Effective

      By Colin Human | Comments are Closed

      In my recent article – On the podium – which referred to the CIMA management series – “Rethinking the business model”, I omitted to mention a particular segment of the discussion relating to the termsRead more

    • On the podium

      By Colin Human | Comments are Closed

      Yesterday was a different day! A stimulating and interesting day.  A thought-provoking day! I shared the podium with some very erudite business thought leaders on the CIMA presentation series –  “Rethinking the business model” TheRead more

    • Turning Vision into Value

      By Colin Human | Comments are Closed

      Email from Michael Hi Colin, my name is Michael and I’m busy with my MBA at GIBS. Part of our prescribed reading is a book on corporate finance – “Turning Vision into Value”. Imagine my surpriseRead more

    • In search of Certainty – and Prediction

      By Colin Human | Comments are Closed

      Does certainty exist? Is it an exercise in futility? – akin to the search for the holy grail or the abominable snowman. For centuries mankind has searched – in vain – for certainty, often fromRead more

    NextPrevious

    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