FINANCIAL MODELLING I ANALYTICS I BID & TRANSACTION SUPPORT
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.
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.
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
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
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
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.
"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 us
Contact ModelScenario to discuss your requirements and understand how we can assist your organisation.
+64 (0)21 400 206