CFOtech New Zealand logo
Technology news for Kiwi CFOs and financial decision-makers
Story image

What, no crystal balls? Public Trust moves to dynamic forecasting

By Contributor
Thu 14 Jan 2021
FYI, this story is more than a year old

Crystal balls would have been useful this year, as the world grappled with the constant ebb and flow of unpredictability. Financial planning can be challenging in the best of times, but planning in a crisis takes it to another level. 

During the COVID-19 pandemic, Public Trust, New Zealand’s largest provider of wills and estate administration services, realised the importance of dynamic forecasting and scenario planning and implemented Workday Adaptive Planning to help it navigate the unpredictable times. 

Public Trust had spent several months preparing the FY21 Business Plan when COVID-19 hit and New Zealand went into lockdown. The plans then needed to be quickly updated for the new environment. Its executive team asked the finance team to prepare scenario analysis showing the impact of COVID-19 on revenue, profit, cash flow and liquidity. Its current systems didn’t allow for the dynamic forecasting and scenario planning needed, and it turned to Workday Adaptive Planning. 
 

The demise of Plan A and Plan B — now it’s Plan D: be Dynamic 

It’s likely all pre-COVID business plans were outdated once the pandemic’s full impact became evident. Greg Garland, Planning and Performance Manager at Public Trust, says its response was probably very similar to everyone else.

“We developed and analysed scenarios, talked a lot and tried to prepare plans based on what we thought might happen, but it was still based on ‘we don’t know what we don’t know,” says Garland.

“Even at this stage we found our traditional bottom-up approach to annual planning was not up to the job and we had to shift to dynamic planning.”

Garland indicates its new dynamic approach taught the team some critical lessons, including:

  • Identify key drivers of business performance
  • Model the impact each driver has on profit, cash flow and the balance sheet, and build scenarios
  • Assess the sensitivity of each driver to variation
  • Monitor key driver indicators weekly (sometimes daily) and update assumptions as required

“For example, for our investment business, we had to model the impact of each percentage point movement in financial markets on revenue and profit,” he says. 

The dynamic approach to performance and risk meant the executive and board could respond to the latest conditions and still focus on long-term strategic objectives. Public Trust found this essential as the situation changed swiftly and constantly, and the traditional linear approach to forecasting, planning, and acting became unfit for purpose. 

Plan E is to Plan Early 

Garland believes that if you are planning in a crisis, you are already too late. 

“Putting yourself in pole position so you can manage in challenging situations is a far better approach and from a governance perspective it’s paramount,” he said. 

“Planning needs to be done early and constantly, which is where scenarios are important. However, to do this in the best possible way it needs the right technology. This is where we had to look beyond Excel,” he added. 

Public Trust said when they knew they needed to upgrade from Excel, they wanted cloud-based products that were scalable, collaborative, easy to maintain, cost-effective, and most importantly, support business continuity. 

They also wanted a solution that was adaptable, simple, and fast to implement, and had advanced functionality for dynamic planning, reporting, and business intelligence.
A good implementation partner was one who understood its business and had a collaborative methodology.

“With this thinking, we identified Workday Adaptive Planning software and Deloitte as our business transformation partner,” says Garland.

“This gave us a powerful planning and reporting tool, and the right implementation, to be able to bring significant benefits to business insights, finance and wider management, whatever might be thrown at us.” 

Predicting the unpredictable and where to start?

Having robust financial forecasting is an important anchor in uncertain times, but it needs to have certain characteristics to ensure it’s right for the job: 

  • Simplicity - meaning it can be adapted
  • Work with what you know - defined information or relationships you can rely on
  • Agility - weekly and possibly daily reviews of different aspects of performance 
  • Compare - plot performance to find trends and compare financials with management data
  • Take action - be pragmatic and act on the information you find and then review and try something different if it doesn’t succeed.

“It’s been a juggle to navigate through unpredictable waters while ensuring we remain focused on our long-term strategic objectives,” adds Garland. 

“By being dynamic, planning scenarios constantly, and assessing risk we are now in a better position to respond. 

“While the future remains unpredictable and we don’t have crystal balls, dynamic planning gives us the ability to be prepared and to ensure we are in a strong position to continue to deliver on our long-term strategic objectives.”

Related stories
Top stories
Story image
Employment
Tech job moves - Forcepoint, Malwarebytes, SolarWinds & VMware
We round up all job appointments from May 13-20, 2022, in one place to keep you updated with the latest from across the tech industries.
Story image
Vectra AI
Understanding the weight on security leader’s shoulders, and how to shift it
Millions of dollars of government funding and internal budgets are being funnelled into cybersecurity to build resilience against sophisticated threats, indicating how serious this issue has become.
Story image
Cybersecurity
More than 40% of banks worried about cloud security - report
Publicis Sapient's new report finds security and the lack of cloud skills and internal understanding of business benefits are big obstacles for banks moving to the cloud.
Story image
SaaS
Maintaining secure systems with expectations of flexible work
Most office workers feel they've proved they can work successfully from home, and as much as employers try, things aren't going back to the way they were anytime soon.
Story image
Remote Working
How organisations can meet employees' changing expectations
The global employment market has shifted dramatically in favour of employees, sparking the so-called great resignation, in which people are leaving unsatisfying roles in search of greener pastures.
Story image
Artificial Intelligence
SAS launches human-focused responsible innovation initiative
SAS has launched a responsible innovation initiative, furthering its commitment to equity and putting people first.
Story image
Microsoft
Microsoft backing Māori and Pacific wāhine in tech industry
A new initiative focused on getting Māori and Pacific wāhine into the tech industry and backed by Microsoft, NZTech and the government is calling for tech companies to get involved.
Story image
Artificial Intelligence
Updates from Google Workspace set to ease hybrid working troubles
Google Workspace has announced a variety of new features which will utilise Google AI capabilities to help make hybrid working situations more efficient and effective.
Story image
Cybersecurity
NCSC advisory highlights poor security configurations
The GCSB's National Cyber Security Centre (NCSC) has released a cyber security advisory identifying commonly exploited controls and practices.
Story image
IT budget
$20m boost for digital technologies announced
The government is spending an extra $20m over four years on its plan to transform the digital technologies industry.
Story image
SaaS
Cloudflare launches instant serverless database for dev teams
"Today we’re announcing our first serverless database which we expect will quickly become one of the largest databases in the world."
Booster
Booster Innovation Fund. A fund of Kiwi ingenuity – for Kiwi investors.
Link image
Story image
Artificial Intelligence
SAS unveils AI experience to improve kids' batting abilities
SAS has created The Batting Lab, an interactive experience using AI, computer vision and IoT analytics to help kids improve their baseball and softball swings.
Story image
SAS
New SAS service overcomes subscription fatigue for media companies
SAS has launched SAS 360 Match which helps media companies move towards a AVOD model to generate revenue as subscribers cancel.
Story image
Cybersecurity
Hard numbers: Why ambiguity in cybersecurity no longer adds up
As cybersecurity costs and risks continue to escalate, CEOs continue to struggle with what their investment in cyber protection buys. Getting rid of ambiguity becomes necessary.
Story image
Digital Transformation
Trading up: It's time to swap core systems for flexible digital applications
This year will see more oranisations planning and commencing high tech renovations that will shake up the way they operate.
Story image
Adyen
Adyen expands partnership with Afterpay as BNPL payments increase
Adyen has expanded its partnership with AfterPay allowing more of Adyen’s merchants in more countries worldwide to use the BNPL provider.
Story image
Digital Transformation
The Huawei APAC conference kicks off with digital transformation
More than 1500 people from across APAC have gathered for the Huawei APAC Digital Innovation Congress to explore the future of digital innovation.
Story image
Attain
Revenue operations is taking centre stage
As the business world continues to evolve, new demands need to be met to keep up with the ever-changing landscape. 
Story image
Artificial Intelligence
CFOs using digital workers and AI to prevent unnecessary loss
New technology is now allowing CFOs to use digital workers to automate their accounting processes, making it easier for them to avoid unnecessary losses.
Story image
Phishing
Google reveals new safety and security measures for users
Google's new measures include automatic two step verification, virtual cards and making it easier to remove contact information on Google Search results.
Story image
Sisense
Data and analytics could be key to higher selling prices in APAC
Sisense's latest report has found that almost half of data professionals in APAC think customised data and analytics can create better selling prices for their products.
Story image
Tech job moves
Tech job moves - Datacom, Micro Focus, SnapLogic and VMware
We round up all job appointments from May 6-12, 2022, in one place to keep you updated with the latest from across the tech industries.
Story image
Microsoft
PwC NZ unveils new Cloud Security Operations Center
PwC New Zealand has unveiled its new Cloud Security Operations Center for the entire Microsoft technology stack.
Story image
Public Cloud
Cloud adoption still a work in progress, NetApp finds
NetApp has announced the results of the annual Cloud Infrastructure Report based on a survey of public cloud business and IT decision makers.
Story image
Kodari Securities (KOSEC)
NFT trends and opportunities: expert reveals all
The NFT market is growing at an exponential rate, with unprecedented liquidity. Here we explore how businesses can profit.
Story image
Vodafone
Vodafone NZ buys remaining stake in retail joint venture
Vodafone New Zealand has purchased the remaining 50% stake in the specialist joint venture (JV) with private equity company Millennium Corp.
Story image
Infrastructure
Nutanix study reveals financial services sector lagging with multicloud adoption
Nutanix has released new research that reveals the financial services sector is lagging behind when it comes to multicloud adoption.
Story image
Ransomware
A third of companies paying ransom don’t recover data - report
Veeam's report finds 76% of businesses who are victims of cyberattacks paid the ransom to recover data, but a third were still unable to get their information back.
Story image
Microsoft
Microsoft unveils adaptive accessories for disability access
Microsoft is introducing an expansive Inclusive Tech Lab to give people with disabilities greater access to technology through new software features and adaptive accessories.
Story image
Safety
Voxel hits total funding of $18M following ongoing wins
Since raising its seed round in September, Voxel has grown at pace, by decreasing on-site injuries by upwards of 80% and increasing operational productivity.
Story image
Commerce Commission
ComCom appeals $2.25 million fine in Vodafone FibreX case
The Commerce Commission has filed an appeal in the High Court against a $2.25 million fine imposed on Vodafone NZ for its offending under the Fair Trading Act.
Story image
Digital Transformation
Why enterprise records management should be part of any digital transformation strategy
Modern organisations create and rely upon an enormous volume of content, and digital records make up a significant proportion of that content.
Story image
Microsoft
SAS Viya on Microsoft Azure to deliver 204% return - study
The Forrester Total Economic Impact study finds SAS Viya on Microsoft Azure brings a 204% return on investment over three years.
Story image
Talend
Talend introduces new data health solutions for businesses
Talend has announced its latest version of Talend Data Fabric, with the release of Talend Trust Score enabling data teams to establish a foundation for data health.
Story image
Data Protection
Barracuda launches new capabilities for API Protection
"Every business needs this type of critical protection against API vulnerabilities and automated bot attacks," Barracuda says.
Story image
Fonterra
Fonterra to use automated guided vehicles by Dematic
New Zealand's dairy giant Fonterra is upgrading its manufacturing facility in Edendale with new automated guided vehicles (AGVs) from Dematic.
Exabeam
Find out how a behavioural analytics-driven approach can transform security operations with the new Exabeam commissioned Forrester study.
Link image
Story image
Artificial Intelligence
SAS announces new products amid cloud portfolio success
Analytics and AI company SAS is deepening its broad industry portfolio with offerings that support life sciences, energy, and martech.
Story image
Remote Working
IT teams deploy powerful technologies to enable remote work
"We found that IT teams mastered the challenges of remote work last year in large part by employing powerful yet easy-to-use technologies."
Story image
Artificial Intelligence
Clear Dynamics closes $35M funding round, invests in global growth
The funding is a major milestone and speaks to Clear Dynamics’ vision for AI-enabled ‘composable’ enterprise software, the company states.
Story image
Sift
Sift shares crucial advice for preventing serious ATO breaches
Are you or your business struggling with Account Takeover Fraud (ATO)? One of the latest ebooks from Sift can provide readers with the tools and expertise to help launch them into the new era of account security.
Story image
Mobility
Hands-on review: STM laptop bags
The advent of hybrid working has meant we need laptop bags. We got our hands on two of the most popular laptop bags from STM.
Story image
Excel
Could your Excel practices be harming your business?
While Excel has been the de-facto standard for budgeting, planning, and forecasting, is it alone, enough to support organisations in the global marketplace that’s facing rapid changes due to digital transformation?