Analyst Perspectives

Our recent benchmark research project, Spreadsheet Use in Today’s Enterprise, demonstrated that some companies have made modest progress in addressing spreadsheet issues, but there’s still much left to be done. Desktop spreadsheets can be an important source of productivity but, as I’ve noted, you need to understand their limitations and understand the practical alternatives. Users underestimate the impact of spreadsheet problems on their productivity because they tend to overlook the myriad...

I’ve been using electronic spreadsheets for more than 30 years. I consider this technology among the 20th century’s top five most important advances in business management. Spreadsheets have revolutionized every aspect of running any organization. A spreadsheet (specifically, VisiCalc) was the original “killer app” that made business people feel the necessity to buy a personal computer.

Profit Velocity Solutions’ PV Accelerator is an analytic application designed to enable capital-intensive companies to consistently achieve substantially wider margins and higher return on assets (ROA). Companies in industries such as specialty chemicals, building materials, integrated steel mills and silicon chip fabrication (to name just four) routinely fail to make the right decisions about pricing, production and sales management because they use analytic methods that, from an economic...

One of the important lessons company executives should have learned over the past 15 years is that it’s dangerous not to do contingency planning, a subject that I’ve written about before. By this I mean real, think-outside-the-box contingency planning (not just extrapolating), which is especially important when doing long-range planning. The past decade or so has been punctuated by periods of elevated volatility in financial and product markets, and there’s a good probability it will occur...

To mark the fourth anniversary of the Securities and Exchange Commission’s (SEC) interactive data mandate, Columbia Business School (my alma mater) and its Center for Excellence in Accounting and Security Analysis (CEASA) published a review of the current state of eXtensible Business Reporting Language (XBRL) that notes the manifold issues that plague this promising technology. From its perspective, three key issues hamper greater use of XBRL. The first is the high error rate in the tagging...

You would think that all organizations would want to maximize the value of every customer relationship, but my research over the last couple of years suggests otherwise. Three particular insights stick in my mind. My research into customer analytics shows that overall customer lifetime value ranked only sixth most important customer-related metric, compared to the highest-ranked, customer service costs, which was selected by 54 percent of respondents versus 31 percent for customer lifetime...

The electronic spreadsheet is among the top five most important advances in business management to come along in the last hundred years. It revolutionized almost all aspects of running an organization. It was the original “killer app” that made it necessary for people to go out and buy a personal computer. Yet our recent benchmark research project Spreadsheet Use in Today’s Enterprise confirmed advice we have been giving for the past decade: Spreadsheets are a fabulous tool but they have...

Taxes – both indirect (sales or value added taxes, for example) and direct (income taxes) – are one the largest expense items on the corporate income statement. In recent years it has become common for large and even midsize companies to automate their indirect tax management process, but direct tax management has remained a bastion of manual processes built on a heap of desktop spreadsheets. In previous blog posts I discussed this issue and the role of the tax data warehouse as a necessary...

Managing payroll has long been viewed as an administrative task, time-consuming and focused on ensuring that everyone is paid correctly and on time. In fact, in the American Payroll Association’s most recent annual study, the main metrics tracked for payroll performance are payroll cost per employee, payroll processing accuracy rate and dollar value of overpayments – all of which focus only on cost or accuracy. So payroll management is rarely viewed as having any strategic value to the business...

Banking giant JP Morgan raised eyebrows in 2012 when it revealed that it had lost a substantial amount of money because of poorly conceived trades it had made for its own account. The losses raised questions about the adequacy of its internal controls, and broader questions about the need for regulations to reduce systemic risk to the banking system. At the heart of the matter were the transactions made by “the London Whale,” the name given to a JP Morgan’s trading operation in the City by its...