What is the hidden risk in your company?

What is the hidden risk in your company?

I was recently talking with a friend who was presenting on “Risks within Your Business” to company directors. This topic made me think of all the companies that I had worked with over the years and what was the most significant unrealized threat they faced within the organization. Upon reflection of all of 2 minutes, I concluded that it was Excel!

Yes, it is Excel! Excel has taken over our corporate environments where it is used by finance, marketing, sales, HR, etc. to do everything from planning, budgeting, forecasting, pricing, reconciliation, and analysis. While Excel is a marvelous tool, which undoubtedly made many of these tasks much more manageable, the problem is that anyone can use it and change a model without anyone else realizing it.

There are three areas of concern:

1. Incorrect models.
Many people within organizations develop Excel models to solve problems that they are currently facing. However, many of these models are built using the improper practices that I’ve highlighted in previous blogs. As a result of these practices, other users of the models are not always aware of the model’s shortcomings but still rely on the output to make significant decisions.

In one case, the model’s author had linked all but two of the assumptions to the assumptions page, thus changing the assumptions all but two of them change within the model. As a result, no one was aware that these two assumptions when “off-line” for the model and were making decisions based on incorrect conclusions. While appearing to be an insignificant problem, the lack of connection of these assumptions led to the approval of some projects because they had positive NPVs and good IRRs, but in reality, were terrible projects with negative returns.

2. Hard-Coded Models.
Many models are built using the corrupt practices I have mentioned before. While I have come across many of these, I cannot meet the example given by my friend Rob Brown in his blog post. To have an organization making decisions with an error in their spreadsheet of the order of magnitude of $200 million that no one was aware of is scary. Do you have one of these in your company? Before you answer “No,” are you sure!

3. “Fixed Models.”
More worrying are those models where there is a good model, but then hard-coded change is made to prevent a #N/A or #DIV/0! result. Unfortunately, no one tells anyone about this change, and it left unnoticed for ages. As a consequence, massive errors can arise.
Recently I was working with a company whose budgeting model had some hardcoded adjustments in formulas to adjust sales, compensation, and other budget items. When reviewing this model with the company’s finance department, there was no explanation of why they made these changes. When asked how good the design was for budgeting, the answer I received was, “Last year was a horrible surprise!” As a result, I wrote CEOs Beware: Problems with Financial Modeling. At last check, the company was still using the model!

Recently I was working with a Fortune 500 company that had a model to drive dashboards for the executive team. Somewhere the data had not all been supplied, and so there was a #DIV/0! result. Rather than fix this, someone had changed some formulae to exclude the offending cells and their related data. However, when entering proper results into the offending cells, the dashboard didn’t update to reflect this. The dashboard continued to exclude these outcomes in the actual and historical averages. Who knows how many ad campaigns and how much marketing spend resulted in improving the results when the results were probably already exceeded expectations.

So what to do?
Companies, departments, etc. should review all their models regularly. This review involves someone checking all the calculations, cell references, and links to ensure that the model is performing as expected. A painful task, but undoubtedly better than to keep walking off the cliff, hoping you can survive the landing.

 

© 2015 Marc Borrelli All Rights Reserved

Recent Posts

The Downfall of Boeing: A Lesson in Core Values

The Downfall of Boeing: A Lesson in Core Values

Boeing’s 737 Max issues highlighted the company’s sacrifice of safety for financial performance, resulting in a tarnished reputation. The prioritization of profit over core values also damaged the FAA’s credibility and revealed a lack of accountability for top executives. This downfall serves as a reminder of the importance of maintaining core values and prioritizing them over short-term financial gains.

Resolutions, Here We Go Again.

Resolutions, Here We Go Again.

In reflecting on 2021 resolutions, the author scored themselves in three categories and sought to improve success in 2022 by addressing friction points. Drawing on advice from social psychologist Wendy Wood, the author identified areas to reduce or increase friction in their failed resolutions. By making these adjustments, the author aims to enhance their goal achievement and encourages others to consider friction when setting resolutions.

Understanding and Optimizing Your Cash Conversion Cycle

Understanding and Optimizing Your Cash Conversion Cycle

Understanding and optimizing the Cash Conversion Cycle is crucial for business growth, as it impacts cash flow and the ability to access external capital. This cycle consists of four components: Sales, Make/Production & Inventory, Delivery, and Billing and Payments. To improve the Cash Conversion Cycle, companies can eliminate mistakes, shorten cycle times, and revamp their business models.

Discovering Your Niche: Why You Need to Be Famous for Something

Discovering Your Niche: Why You Need to Be Famous for Something

As an entrepreneur, it’s crucial to specialize in a specific area and become famous for something, allowing you to generate referrals and build your brand. Understanding the “job” you’re hired for helps you stand out in the marketplace and communicate your value proposition effectively. By providing value to your clients, you can adopt a value-based pricing approach, ensuring your business remains competitive and maintains a strong market presence.

Rethinking Your Pricing Model: Maximizing Margins and Providing Value

Rethinking Your Pricing Model: Maximizing Margins and Providing Value

Rethink your pricing model by focusing on the value you provide and your customers’ Best Alternative To a Negotiated Agreement (BATNA). This approach can help you maximize margins while delivering better value to your clients. Assess your offerings and brainstorm with your team to identify pricing adjustment opportunities or eliminate commodity products or services.

Do you know your Profit per X to drive dramatic growth?

Do you know your Profit per X to drive dramatic growth?

I recently facilitated a workshop with several CEOs where we worked on the dramatic business growth model components. One of the questions that I had asked them beforehand was, "What is Your Profit/X?" The results showed that there this concept is not clear to many....

The War for Talent: 5 Ways to Attract the Best Employees

The War for Talent: 5 Ways to Attract the Best Employees

In today’s War for Talent, attracting the best employees requires a focus on value creation, core customer, brand promise, and value delivery. Clearly articulate your company’s mission, identify your “core employee” based on shared values, and offer more than just a salary to stand out as an employer. Utilize employee satisfaction metrics and showcase your company’s commitment to its workforce on your website to make a strong impression on potential candidates.

Are you killing your firm’s WFH productivity?

Are you killing your firm’s WFH productivity?

Productivity remained during WFH with COVID. However, further analysis found that hourly productivity fell and was compensated for by employees working more hours. What was the culprit – Meetings. Want to increase productivity, have fewer meetings.

Precision v. Accuracy: How about using a range?

Precision v. Accuracy: How about using a range?

The precision versus accuracy concept was first brought home to me back in the depths of time while I was doing Physics “A” Level in high school and calculating measurement errors in experiments. From this, I learned that no matter how precise one’s measurements were, there is an inherent error in the tool used to measure the results. Taking into account that lack of precision provided more accurate results, which is what we sought.

When I got involved in finance during my time in business school, the measurement tool was the currency, and so precision was deemed to be the smallest currency unit, i.e., a cent. This precision was encouraged by the beautiful computing power of Lotus 1-2-3 and then Excel, which allowed you to do forecasts that were precise to the cent going out years based on a few assumptions. While the precision was there, accuracy was foregone as we built huge models on a few simplistic assumptions.

However, upon leaving business school and entering the real world, my illusions were quickly dashed. After my first week at work, I presented my boss with a ten-year forecasting model that showed profit and loss statements, balance sheets, cash flow statements, and of course, a discounted cash flow valuation. He looked at it and asked how confident I was in my forecasting. As I defended it, he looked at me and asked in a sort of Bayesian way, “Would you bet your bonus on the company making the revenue numbers you have for this year?” (we were a quarter of the way into the year).

“No!” was my quick reply.

“In that case, how can you defend ten years of numbers which all build off that initial number?” he asked. This has lived with me ever since that we quickly get sucked into the precision of our models, but the numbers are so inaccurate.

During my career, I have to see precise projections for sales, projects, costs being bandied around in companies by everyone, including the CFO. Yet few, if any, would bet a modest amount, let alone their bonuses, on those numbers being the final results. Thus we end up with the corporate situation where everyone knows the numbers are wrong but cannot admit it.

However, when working with these same companies and trying to get them to accept the concept of ranges in forecasts and probability distributions, I am regarded as though I had just stated that the earth was flat and supported by elephants. One CFO of a public company looked at me with total distance and asked: “Why would anyone ever need something like that?”.

When I responded that I was seeking more accuracy, albeit with less precision, in financial projections, it was apparent that had I reverted to speaking Fanagalo. Another CFO used precise numbers (down to the dollar when their revenue was over $20 million). None of their forecasts were ever correct, but he could not accept that forecasting to the million was acceptable. I heard that their last results were a huge surprise given the forecasts; however, I was not surprised at all given the forecasting process.

This trade-off of precision in return for greater accuracy continually is rejected by many of the financial professionals that I meet. I have wondered if the cause of this focus on precision encouraged by the accounting profession makes it hard for these professionals to let it go.

Going back to my boss’ logic – if you would not bet on a single number being accurate, would you be prepared to bet on a range? For example, the forecast may say that next years’ revenue will be $10 million, but no one will bet their bonus on it when pushed. So would you be willing to be that it will be between $9 and $11 million or $8 and $12 million? When you reach a range that you would be willing to bet on, it is surely the range to use in the forecasts.

Using ranges like this and applying techniques like Monte Carlo simulations results in far higher accuracy in forecasts and an understanding of the risk profile of the results, i.e., there is a 50% probability that revenue will be between $9 million and $10 million or that profits will range between $0 and $1 million. Furthermore, one can see what items are critical to the final results, what is not. The company can focus on those essential items rather than getting distracted by the noise.

It is best to remember Nils Bohr’s quote, “Prediction is very difficult, especially if it’s about the future.” Therefore, to make the predictions more useful, it is best to forego precision in return for greater accuracy.

 

© 2013 Marc Borrelli All Rights Reserved

Recent Posts

The Downfall of Boeing: A Lesson in Core Values

The Downfall of Boeing: A Lesson in Core Values

Boeing’s 737 Max issues highlighted the company’s sacrifice of safety for financial performance, resulting in a tarnished reputation. The prioritization of profit over core values also damaged the FAA’s credibility and revealed a lack of accountability for top executives. This downfall serves as a reminder of the importance of maintaining core values and prioritizing them over short-term financial gains.

Resolutions, Here We Go Again.

Resolutions, Here We Go Again.

In reflecting on 2021 resolutions, the author scored themselves in three categories and sought to improve success in 2022 by addressing friction points. Drawing on advice from social psychologist Wendy Wood, the author identified areas to reduce or increase friction in their failed resolutions. By making these adjustments, the author aims to enhance their goal achievement and encourages others to consider friction when setting resolutions.

Understanding and Optimizing Your Cash Conversion Cycle

Understanding and Optimizing Your Cash Conversion Cycle

Understanding and optimizing the Cash Conversion Cycle is crucial for business growth, as it impacts cash flow and the ability to access external capital. This cycle consists of four components: Sales, Make/Production & Inventory, Delivery, and Billing and Payments. To improve the Cash Conversion Cycle, companies can eliminate mistakes, shorten cycle times, and revamp their business models.

Discovering Your Niche: Why You Need to Be Famous for Something

Discovering Your Niche: Why You Need to Be Famous for Something

As an entrepreneur, it’s crucial to specialize in a specific area and become famous for something, allowing you to generate referrals and build your brand. Understanding the “job” you’re hired for helps you stand out in the marketplace and communicate your value proposition effectively. By providing value to your clients, you can adopt a value-based pricing approach, ensuring your business remains competitive and maintains a strong market presence.

Rethinking Your Pricing Model: Maximizing Margins and Providing Value

Rethinking Your Pricing Model: Maximizing Margins and Providing Value

Rethink your pricing model by focusing on the value you provide and your customers’ Best Alternative To a Negotiated Agreement (BATNA). This approach can help you maximize margins while delivering better value to your clients. Assess your offerings and brainstorm with your team to identify pricing adjustment opportunities or eliminate commodity products or services.

Do you know your Profit per X to drive dramatic growth?

Do you know your Profit per X to drive dramatic growth?

I recently facilitated a workshop with several CEOs where we worked on the dramatic business growth model components. One of the questions that I had asked them beforehand was, "What is Your Profit/X?" The results showed that there this concept is not clear to many....

The War for Talent: 5 Ways to Attract the Best Employees

The War for Talent: 5 Ways to Attract the Best Employees

In today’s War for Talent, attracting the best employees requires a focus on value creation, core customer, brand promise, and value delivery. Clearly articulate your company’s mission, identify your “core employee” based on shared values, and offer more than just a salary to stand out as an employer. Utilize employee satisfaction metrics and showcase your company’s commitment to its workforce on your website to make a strong impression on potential candidates.

Are you killing your firm’s WFH productivity?

Are you killing your firm’s WFH productivity?

Productivity remained during WFH with COVID. However, further analysis found that hourly productivity fell and was compensated for by employees working more hours. What was the culprit – Meetings. Want to increase productivity, have fewer meetings.