top of page

FINANCIAL MODELLING  I  ANALYTICS  I  BID & TRANSACTION SUPPORT

Typical Client

Typical Client

Clients engage ModelScenario to:

  • seek confidence in a strategic decision

  • interrogate the status quo

  • improve data collection and presentation

​

Prospective clients are:

  • considering project finance and corporate finance transactions

  • raising finance backed by credible financial projections

  • improve FP&A functionality with robust forecasts and data visualisation

  • tendering for a contract

  • pursuing cost-saving measures and revenue growth

  • needing robust business templates

 

Clients are government departments, SMEs and multi-nationals across a diverse range of sectors.

 

Contact ModelScenario to discuss your requirements and understand how we can assist your organisation.

BG_Image_3.jpg

Approach

ModelScenario tailor solutions to your needs; we acknowledge your circumstances are unique. We consult with stakeholders at all levels, good consultancy cannot occur in a vacuum.

 

We offer clients a contingent workforce, a resource held off their books. You co-opt our capability for a discrete project. ModelScenario supplements your in-house capacity, acting alone or as a member of a project team. 

 

We place emphasis on delivering a quality and timely service.To this end ModelScenario consults to a select group of clients at any given time.

​

Where your needs extend beyond our expertise we recommend third party expertise.

Approach

Financial Modelling

Properly conceived and constructed, a financial model can provide great insight into the future. Conversely, a poor financial model can be limiting, misleading and commercially damaging. ModelScenario adhere to the principles of the FAST Standard Organisation, an internationally recognised approach to financial modelling.  

 

We believe a sound financial model should be:

  • scoped thoughtfully with involvement from all stakeholders

  • fit for purpose and suit the requirements of the end user(s)

  • sensitised, offering scenarios and 'what-if' analysis to challenge the 'base' or expected case

  • understandable, easy to navigate and audit

  • presentable, yielding outputs for inclusion in corporate material

  • downstream compatible for sophisticated risk modelling (e.g. monte carlo simulation)

​

ModelScenario builds Excel spreadsheet financial models for:

  • project finance and acquisitions (M&A, MBO/LBO)

  • property finance transactions

  • bank debt and capital raising

  • cash flow forecasts and working capital analysis

  • pricing commercial contracts

 

Our people have provided financial modelling services to:

  • the preferred bidder in a £1.3bn social regeneration PPP

  • the NZTA preparation of a 30-year capex and cash flow forecast

  • an IPO pursued by Hirepool

  • a multi-national retailer requiring complex operational forecasts

  • Department of Corrections in support of a $250mn business case

  • property financiers of  transactions exceeding $250mn in value

  • a merchant bank for a train leasing transaction

  • a manufacturer assessing the cash flow impact of its growth strategy

BG_Image_5_R.jpg
Financial Modelling
Services
Spreadsheet Consulting
BG_Image_4.jpg

Spreadsheet Consulting

Appropriate business templates and timely reporting suites are critical to any organisation. Such tools assist staff to perform their daily duties and inform management.

 

ModelScenario provides consultancy to clients for:

  • business templates

  • data visualisation using Power BI and information dashboards

  • ad-hoc financial analysis

​

Our people have provided analytical consultancy to:

  • a national distributor renewing a service contract with a listed company

  • a multi-national manufacturer requiring analysis of its local facility

  • a multi-national retailer monitoring performance metrics

Transaction Support

Transaction Support

ModelScenario has considerable transaction experience across property finance, project finance, SME capital raising and commercial tendering.

 

We support management and/or project teams to prepare:

  • information memorandums and bank funding submissions

  • requests for proposals (RfP) and expressions of interest (EoI)

 

Our people have provided transaction support services to:

  • numerous property developers seeking bank and mezzanine debt

  • the vendor of a national head franchise

  • a SME manufacturer seeking equity capital and bank funding

Brainstorming%20over%20paper_edited.jpg
People

People

ModelScenario is headed by David Macmillan, a commercial analyst with over 20 years’ experience in banking and corporate finance in New Zealand and the United Kingdom.

​

David has a depth of commercial experience drawn from corporate advisory and transaction support roles in merchant banks, professional services firms and as an independent consultant.

 

David has specialisms in financial modelling, financial and credit analysis and the preparation of offer documentation for capital raising and commercial tenders.  Consultative and collegial, David interacts effectively at all levels.

 

With industry experience taken from the property, manufacturing and retail sectors, David brings adaptability and versatility to client engagements.

 

David holds a Bachelor of Arts (Econ) and has attained credit analyst certifications from Moody’s Analytics and Omega Performance.  He has held the Authorised Financial Advisor certification previously.

 

Contact ModelScenario to discuss your requirements and understand how we can assist your.

  • LinkedIn
Credibility

"David provided financial modelling and analysis to SATO New Zealand to help us to better understand the financial mechanics of our production operations. David's financial modelling skills and his mature approach to commercial matters assisted us to make good investment decisions and to change the way we approach production. David worked well with staff across SATO New Zealand and we continue to use his models to deliver deeper reporting and analysis."

—  Paul Ryan, Managing Director

Contact

Contact us

Contact ModelScenario to discuss your requirements and understand how we can assist your organisation.

+64 (0)21 400 206

Thanks for submitting!

bottom of page