By Oletta Stewart is a marketing specialist at MHR Analytics
With all of the talk about the importance of analytics for finance professionals, by now you probably understand its significance. The million dollar question is: are you actually taking full advantage of it?
In reality, ticking the analytics knowledge box or even having an analytics system in place is just the beginning of the story. There are many core capabilities that are often left untapped which lead to missed opportunities and many financial professionals only partially fulfilling their potential.
We’ve put together a list of the top analytics capabilities that are often neglected, but if carried out correctly, can provide a whole new level of insight that can work as a long-term strategic asset.
- Syncing data across the organisation
Having an analytics system isn’t just about optimising financial processes. To get a full picture of the financial state of your organisation, it’s essential to take a holistic view, and to do this, data from across your organisation must be synced and coordinated. Often, what rather tends to be the case is that teams across the organisation record and analyse their data using their own individual methods. This ultimately leads to mismatched and inconsistent financial data. Analytics can be used to store all of your organisational data in one centralised place. Using a data warehouse, it’s possible to even collaborate business processes in real-time so that you can see how changes in other areas of the organisation will directly impact the financials.
- Understanding key value drivers
Knowing your organisations’ key value drivers is key to financial growth. Unfortunately, many rely on rough estimates to determine what these key drivers are. For instance, it’s easy to assume that core factors like product pricing have a direct impact on revenue, when in fact, this is nothing more than an assumption until proven otherwise. If you fall into the above category, analytics can be used to “see what the data says” so that you can base this understanding on facts rather than mere theory. Having this capability will allow you to work directly with your organisation to employ a smart, data-driven strategy that will significantly increase the chances of realising your goals.
- Visibility of cash flow
Cash flow is the lifeblood of your organisation and it’s your job to oversee this. Understanding exactly what’s going into your organisation, what’s leaving it, and precisely when and how this is happening, is a crucial part of avoiding financial issues later down the line. Analytics can be used to get a multi-dimensional view of your cash flow – looking not just retrospectively, but in real-time, and even to predict what future cash flow will look like. Using this information and tools like scenario planning, you can plan and prepare in advance and ensure that cash is constantly being allocated to the right place at the right time.
- Automating financial processes
Are you still relying on manual methods to carry out your financial reporting? If your answer to this question is “yes”, then you’re seriously limiting your potential for growth. Research shows that 80% of spreadsheets contain errors, and reliance on these manual processes alone leave you at risk of non-compliance, not to mention taking up a good portion of your time. Instead of relying on manually inputting data into spreadsheets, analytics can be used to automate repetitive, low-value tasks; giving you peace of mind that your financial data is accurate and up to par. Another added benefit is that by freeing yourself from tedious tasks, you’ll have more time to spend on activities that fully utilise your skills so that you can provide greater value in your everyday role.
- Insight into profitability
Analytics can be used to drill-down to understand where profit is being generated and how much, as well as revealing areas of the business that are dwindling. It helps you to answer questions like: What product generated the most revenue for the business within a given time period? What is each customers’ lifetime value? And which areas of the business need extra support to reach revenue goals? These insights can be fed back to teams in other areas of the business so that the approach can be refined to promote activity that will increase the profitability of your organisation over time.
- Predicting sales in advance
Getting your budgeting and forecasting process to a point where you know your estimates are accurate isn’t an easy task – especially when this is left down to manual observation. Using historical data and a range of predictive techniques, it’s possible to present sales figures in digestible visualisations so that you can easily forecast and make accurate predictions about what future sales figures may look like. This also allows you to identify patterns and seasonal trends that may impact your organisations’ sales revenue, so that you can plan ahead and ensure that you have enough budget set aside to prevent any cash flow issues. Analytics is certainly gaining momentum in the conversation of how to be a more effective finance professional, but many are still in the early days of implementation. To compete in the ever-changing finance space, it’s important to equip yourself with an understanding of how you can use the latest technologies to increase your personal impact and value.
You can learn more about your own level of analytics capability by taking MHR Analytics’ Data Maturity quiz.
Airbus CEO urges trade war ceasefire, easing of COVID travel bans
By Tim Hepher
PARIS (Reuters) – The head of European planemaker Airbus called on Saturday for a “ceasefire” in a transatlantic trade war over aircraft subsidies, saying tit-for-tat tariffs on planes and other goods had aggravated damage from the COVID-19 crisis.
Washington progressively imposed import duties of 15% on Airbus jets from 2019 after a prolonged dispute at the World Trade Organization, and the EU responded with matching tariffs on Boeing jets a year later. Wine, whisky and other goods are also affected.
“This dispute, which is now an old dispute, has put us in a lose-lose situation,” Airbus Chief Executive Guillaume Faury said in a radio interview.
“We have ended up in a situation where wisdom would normally dictate that we have a ceasefire and resolve this conflict,” he told France Inter.
Boeing was not immediately available for comment.
Brazil, which has waged separate battles with Canada over subsidies for smaller regional jets, on Thursday dropped its own complaint against Ottawa and called for a global peace deal between producing nations on support for aerospace.
Faury said the dispute with Boeing was particularly damaging during the COVID-19 pandemic, which has badly hit air travel and led to travel restrictions or border closures. He expressed particular concern about widening bans within Europe.
“We are extremely frustrated by the barriers that restrict personal movement and it is almost impossible today to travel in Europe by plane, even domestically,” he said.
“The priority no. 1 for countries in general is to reopen frontiers and allow people to travel on the basis of tests and then eventually vaccinations.”
The comments come as businesses increase pressure on governments to reopen economies as coronavirus vaccine roll-outs gather pace across Europe.
France has defended recently introduced border restrictions, saying they will help the government avoid a new lockdown and stay in force until at least the end of February.
Germany installed border controls with the Czech Republic and Austria last Sunday, drawing protest from Austria and concerns about supply-chain disruptions.
Berlin calls the move a temporary measure of last resort.
Poland said on Saturday it had not ruled out imposing restrictions at the country’s borders with Slovakia and the Czech Republic due to rising COVID-19 cases.
(Reporting by Tim Hepher; Editing by Kirsten Donovan)
Why a predictable cold snap crippled the Texas power grid
By Tim McLaughlin and Stephanie Kelly
(Reuters) – As Texans cranked up their heaters early Monday to combat plunging temperatures, a record surge of electricity demand set off a disastrous chain reaction in the state’s power grid.
Wind turbines in the state’s northern Panhandle locked up. Natural gas plants shut down when frozen pipes and components shut off fuel flow. A South Texas nuclear reactor went dark after a five-foot section of uninsulated pipe seized up. Power outages quickly spread statewide – leaving millions shivering in their homes for days, with deadly consequences.
It could have been far worse: Before dawn on Monday, the state’s grid operator was “seconds and minutes” away from an uncontrolled blackout for its 26 million customers, its CEO has said. Such a collapse occurs when operators lose the ability to manage the crisis through rolling blackouts; in such cases, it can take weeks or months to fully restore power to customers.
Monday was one of the state’s coldest days in more than a century – but the unprecedented power crisis was hardly unpredictable after Texas had experienced a similar, though less severe, disruption during a 2011 cold snap. Still, Texas power producers failed to adequately winter-proof their systems. And the state’s grid operator underestimated its need for reserve power capacity before the crisis, then moved too slowly to tell utilities to institute rolling blackouts to protect against a grid meltdown, energy analysts, traders and economists said.
Early signs of trouble came long before the forced outages. Two days earlier, for example, the grid suddenly lost 539 megawatts (MW) of power, or enough electricity for nearly 108,000 homes, according to operational messages disclosed by the state’s primary grid operator, the Electric Reliability Council of Texas (ERCOT).
The crisis stemmed from a unique confluence of weaknesses in the state’s power system.
Texas is the only state in the continental United States with an independent and isolated grid. That allows the state to avoid federal regulation – but also severely limits its ability to draw emergency power from other grids. ERCOT also operates the only major U.S. grid that does not have a capacity market – a system that provides payments to operators to be on standby to supply power during severe weather events.
After more than 3 million ERCOT customers lost power in a February 2011 freeze, federal regulators recommended that ERCOT prepare for winter with the same urgency as it does the peak summer season. They also said that, while ERCOT’s reserve power capacity looked good on paper, it did not take into account that many generation units could get knocked offline by freezing weather.
“There were prior severe cold weather events in the Southwest in 1983, 1989, 2003, 2006, 2008, and 2010,” Federal Energy Regulatory Commission and North American Electric Reliability Corp staff summarized after investigating the state’s 2011 rolling blackouts. “Extensive generator failures overwhelmed ERCOT’s reserves, which eventually dropped below the level of safe operation.”
ERCOT spokeswoman Leslie Sopko did not comment in detail about the causes of the power crisis but said the grid’s leadership plans to re-evaluate the assumptions that go into its forecasts.
The freeze was easy to see coming, said Jay Apt, co-director of the Carnegie Mellon Electricity Industry Center.
“When I read that this was a black-swan event, I just have to wonder whether the folks who are saying that have been in this business long enough that they forgot everything, or just came into it,” Apt said. “People need to recognize that this sort of weather is pretty common.”
This week’s cold snap left 4.5 million ERCOT customers without power. More than 14.5 million Texans endured a related water-supply crisis as pipes froze and burst. About 65,000 customers remained without power as of Saturday afternoon, even as temperatures started to rise, according to website PowerOutage.US.
State health officials have linked more than two dozen deaths to the power crisis. Some died from hypothermia or possible carbon monoxide poisoning caused by portable generators running in basements and garages without enough ventilation. Officials say they suspect the death count will rise as more bodies are discovered.
THIN POWER RESERVE
In the central Texas city of Austin, the state capital, the minimum February temperature usually falls between 42 and 48 degrees Fahrenheit (5 to 9 degrees Celsius). This past week, temperatures fell as low as 6 degrees Fahrenheit (-14 degrees Celsius).
In November, ERCOT assured that the grid was prepared to handle such a dire scenario.
“We studied a range of potential risks under both normal and extreme conditions, and believe there is sufficient generation to adequately serve our customers,” said ERCOT’s manager of resource adequacy, Pete Warnken, in a report that month.
Warnken could not be reached for comment on Saturday.
Under normal winter conditions, ERCOT forecast it would have about 16,200 MW of power reserves. But under extreme conditions, it predicted a reserve cushion of only about 1,350 MW. That assumed only 23,500 MW of generation outages. During the peak of this week’s crisis, more than 30,000 MW was forced off the grid.
Other U.S. grid operators maintain a capacity market to supply extra power in extreme conditions – paying operators on an ongoing basis, whether they produce power or not. Capacity market auctions determine, three years in advance, the price that power generators receive in exchange for being on emergency standby.
Instead, ERCOT relies on a wholesale electricity market, where free market pricing provides incentives for generators to provide daily power and to make investments to ensure reliability in peak periods, according to economists. The system relied on the theory that power plants should make high profits when energy demand and prices soar – providing them ample money to make investments in, for example, winterization. The Texas legislature restructured the state’s electric market in 1999.
Since 2010, ERCOT’s reserve margin – the buffer between generation capacity versus forecasted demand – has dropped to about 10% from about 20%. This has put pressure on generators during demand spikes, making the grid less flexible, according to North American Electric Reliability Corporation (NERC), a nonprofit regulator.
That thin margin for error set off alarms early Monday morning among energy traders and analysts as they watched a sudden drop in the electrical frequency of the Texas grid. One analyst compared it to watching the pulse of a hospital patient drop to life-threatening levels.
Too much of a drop is catastrophic because it would trigger automatic relay switches to disconnect power sources from the grid, setting off uncontrolled blackouts statewide. Dan Jones, an energy analyst at Monterey LLC, watched from his home office in Delaware as the grid’s frequency dropped quickly toward the point that would trigger the automatic shutdowns.
“If you’re not in control, and you are letting the equipment do it, that’s just chaos,” Jones said.
By Sunday afternoon about 3:15 p.m. (CST), ERCOT’s control room signaled it had run out of options to boost electric generation to match the soaring demand. Operators issued a warning that there was “no market solution” for the projected shortage, according to control room messages published by ERCOT on its website.
Adam Sinn, president of Houston-based energy trading firm Aspire Commodities, said ERCOT waited far too long to start telling utilities to cut customers’ power to guard against a grid meltdown. The problems, he said, were readily apparent several days before Monday.
“ERCOT was letting the system get weaker and weaker and weaker,” Sinn said in an interview. “I was thinking: Holy shit, what is this grid operator doing? He has to cut load.”
Sinn said he started texting his friends on Sunday night, warning them to expect widespread outages.
‘SECONDS AND MINUTES’
Early Monday morning, one of the largest sources of electricity in the state – the unit 1 reactor at the South Texas Nuclear Generating Station – stopped producing power after the small section of pipe froze in temperatures that averaged 17 degrees Fahrenheit (9 degrees Celsius). The grid lost access to 1,350 MW of nuclear power – enough to power about 270,000 homes – after automatic sensors detected the frozen pipe and protectively shut down the reactor, said Victor Dricks, a spokesman for the U.S. Nuclear Regulatory Commission.
About 2:30 a.m. (CST), the South Plains Electric Cooperative in Lubbock said it received a phone call from ERCOT to cut power to its customers. Inside the ERCOT control room, staff members scrambled to call utilities and cooperatives statewide to tell them to do the same, according to operational messages disclosed by the grid operator.
Three days later, ERCOT Chief Executive Bill Magness acknowledged that the grid operator had only narrowly avoided the calamity of uncontrolled blackouts.
“If we hadn’t taken action,” he said on Thursday, “it was seconds and minutes (away), given the amount of generation that was coming off the system at the same time that the demand was still going up.”
(Reporting by Tim McLaughlin and Stephanie Kelly; additional reporting by Nichola Groom; editing by Simon Webb and Brian Thevenot)
UK could declare Brexit ‘water wars’ – The Telegraph
(Reuters) – Britain could restrict imports of European mineral water and several food products under retaliatory measures being considered by ministers over Brussels’ refusal to end its blockade on British shellfish, the Telegraph reported.
Senior government sources pointed to potential restrictions on the importing of mineral water and seed potatoes, the report said.
(Reporting by Maria Ponnezhath in Bengaluru; Editing by Daniel Wallis)
Former Bank of England Governor Carney joins board of digital payments company Stripe
By Kanishka Singh (Reuters) – Mark Carney, former head of the UK and Canadian central banks, has joined the board...
Airbus CEO urges trade war ceasefire, easing of COVID travel bans
By Tim Hepher PARIS (Reuters) – The head of European planemaker Airbus called on Saturday for a “ceasefire” in a...
Why a predictable cold snap crippled the Texas power grid
By Tim McLaughlin and Stephanie Kelly (Reuters) – As Texans cranked up their heaters early Monday to combat plunging temperatures,...
UK could declare Brexit ‘water wars’ – The Telegraph
(Reuters) – Britain could restrict imports of European mineral water and several food products under retaliatory measures being considered by...
Commerzbank to lose 1.7 million clients by 2024 – Welt am Sonntag
FRANKFURT (Reuters) – Commerzbank expects to lose 1.7 million customers by 2024 as part of its current restructuring, resulting in...
Bitcoin and ethereum prices ‘seem high,’ says Musk
(Reuters) – Billionaire CEO Elon Musk said on Saturday the price of bitcoin and ethereum seemed high, at a time...
Sunak to raise business tax to pay for COVID-19 support – The Sunday Times
(Reuters) – British finance minister Rishi Sunak is set to increase a tax on business to pay for an extension...
FTSE Russell to include 11 stocks from China’s STAR Market in global benchmarks
SHANGHAI (Reuters) – Index provider FTSE Russell will add 11 stocks from China’s STAR Market to its global benchmarks, according...
Foxconn chairman says expects “limited impact” from chip shortage on clients
TAIPEI (Reuters) – The chairman of Apple Inc supplier Foxconn said on Saturday he expects his company and its clients...
Bitcoin, ether hit fresh highs
SINGAPORE (Reuters) – Bitcoin hit a fresh high in Asian trading on Saturday, extending a two-month rally that saw its...