Are Your 'What If' Scenarios Based on Yesterday's Technology?

If your clients are still in the Excel era, they've got plenty of company. But they may find cloud computing provides more nimble forecasting of their business needs. That's a key finding in an online survey in April of 325 financial professionals by Adaptive Insights in Palo Alto, Calif., which provides cloud-based business and financial analytics solutions for more than 2,200 customers worldwide. Even Adaptive found the number of Excel users surprising, says company senior vice president of marketing Greg Schneider.

Released this month, the survey report indicates that 86 percent of respondents would prefer not to use legacy systems. But of those, 46 percent want Excel while 40 percent opt for the cloud.

Yet that Excel use is why 60 percent of companies say they re-forecasted or created "what if" scenarios only zero to two times in the last six months, Schneider says. And that's not often enough.

"The best practice in the marketplace right now is to move to rolling forecasting, which means that you do reforecasting monthly for the next 12 to 18 months," he says. But Excel's manual process means users can't respond as quickly to rapidly changing business scenarios, Schneider continues.

"We've moved beyond annual budgets and then mid-year forecasting," he says. "So those [reforecasting] numbers are lower than you would expect and they reflect the use of Excel versus more modern automated solutions."

Along those lines, only 27 percent of respondents said they could respond or re-forecast in days to an external or internal impact on their business. The majority (73 percent) said it would take weeks or months.

So what kind of internal or external factors are we talking about that could affect businesses through December?

Externally, 49 percent cited the Affordable Care Act and a rise in gas prices, and 25 percent said the current hurricane season and upcoming midterm elections. The bulk of internal problems (43 percent) included executive changes and mergers and acquisitions, and 27 percent cited new hires and layoffs.

The takeaway here, Schneider says, is that "we live in a very dynamic environment with a lot of changes in business. What we're seeing is that the interest in solutions is driven by the need for companies to be more nimble and agile. So if there are any kind of changes in underlying economics or drivers, companies need to respond and understand how it'll impact their cost structure and demand."

And if companies can do that, and put together scenarios about these potential changes, they'll be one-up on their competitors, he adds.

So whether your clients are in the Excel or cloud camp, we'll bet a competitive advantage is a goal they've all got in common.

You may like these other stories...

Bank Leumi said to face $300 million demand in tax caseDavid Voreacos and Greg Farrell of Bloomberg reported on Wednesday that New York’s banking regulator will ask for more than $300 million to settle an investigation...
Deal to lock in US tax cuts is bubbling up on the HillSome US lawmakers are exploring a post-election deal that would lock in permanent tax cuts for major corporations and low-income families, Richard Rubin of Bloomberg...
Judge dismisses AICPA lawsuit against the IRSMichael Cohn of Accounting Today reported on Tuesday that a federal judge has dismissed a lawsuit against the IRS by the American Institute of CPAs (AICPA) over its new program...

Already a member? log in here.

Upcoming CPE Webinars

Nov 5Join CPA thought leader and peer reviewer Rob Cameron and learn ways to improve the outcome of your peer reviews while maximizing the value of your engagement workflow.
Nov 18In this session Excel expert David Ringstrom, CPA tackles what to do when bad things happen to good spreadsheets.
Nov 19How do you minimize redundant work and unnecessary steps to maximize the amount of work moving through your firm?
Nov 20Kristen Rampe will share how to uncover new opportunities with your clients by asking powerful questions.