Showing posts with label Reporting. Show all posts
Showing posts with label Reporting. Show all posts

8/30/10

How to Evaluate Your Company’s Financial Position

Bank balances don't tell you enough to gauge your financial health. Here's where to look in your financial statements and other data for a full checkup.

The Great Recession has made checking in on the basics of your company’s financial position more than just a to-do item: it’s become an absolute necessity. Unfortunately, understanding how healthy your company is financially takes more than just logging in to your online bank account and checking balances. And that’s where most entrepreneurs get turned off. Who wants to really dig into those complicated balance sheets and income statements anyway? Isn’t that what I have an accountant for?

In general, yes, you should have a competent CPA to help you organize the financial details of your business. But that doesn’t let you off the hook: as the leader and/or owner of your business, the onus is on you to make sure you’re headed in the right direction. The good news is that you don’t necessarily have to fully immerse yourself in those financial statements to take your company’s financial temperature.

What you do need to do, however, is look at a combination of both financial and operational metrics that benchmark your company’s current financial performance against your competition and your own past results. Start by taking a crash course in understanding your company’s critical numbers. Then, consider these tips on a few additional metrics that will help your company stay on the right financial path:

Scrutinize Your Cash Position

As the old saying goes, cash is king. A financially well-run business will have an improving cash position at the end of each and every month, says Victor Cheng, a CEO coach and author of the book, Extreme Revenue Growth. Said another way, a healthy company generates a positive cash flow, meaning the money coming in exceeds the funds flowing out the door. Keeping a running tally of your cash position over the past three months is a great way to see if your business is generating cash over a sustained period of time. “It is pretty much impossible to go out of business if you are paying your bills on time and your bank account balance keeps growing each month,” says Cheng.

Cheng says that you want to look at a three-month trend because it will help you identify red flags. For example, if sales have increased 20 percent, but your cash position is rapidly declining, there’s likely an issue with your accounts receivable. “It means that there is a cash flow timing problem on those sales and it’s incredibly risky for a business to do that, especially if they don't realize they are doing it,” he says. If, on the other hand, the cash position is improving but sales are declining, it means the company is making good improvement in internal operations, efficiency, and financial management - but the company has a serious external or market problem to solve.

Dig Deeper: How to Read an Income Statement

Check Your Solvency

One way to check the financial health of your business is to calculate the following:

  • Cash in Bank / Monthly Expenses = Number of Months Until Bankruptcy

This ratio shows you how many months your business can survive if sales suddenly stopped and none of your customers paid their bills that month, says Cheng. “It is ratio I developed to freak out non-finance entrepreneurs so they will start paying much more attention to cash management and not just sales,” he says.

For example, Cheng says it is very possible for a business doing $1 million a year in revenue to double sales and go bankrupt in the process. Whether this happens or not depends on how quickly the cash is collected from customers and deposited in the bank relative to when you have to pay the bills for the increased expenses associated with the new revenue. “If the entrepreneur has to increase expenses today, but collects that additional $1 million six months from now, they can very easily go bankrupt before they collect their money," Cheng says. "In cash management, timing is everything."

As such, another useful exercise is to chart your company’s accounts receivable and accounts payable aged in thirty-day buckets, says Frank Stitely, a CPA in Chantilly, Virginia, who also pens the blog, “How to Screw Up Your Small Business.” The accounts receivable numbers reveal the cash coming into the business and highlight any problems with old receivables, meaning money you have had trouble collecting from customers. The accounts payable numbers show the cash commitments of the business over the next thirty days to vendors. Since you’re on the hook to pay your bills, any aging trend in the amount of money you’re owed could spell trouble. “When a business owner sees a quarter of accounts receivable over sixty days old, he or she should panic,” says Stitely.

Dig Deeper: 5 Ways to Improve Cash Flow

Keep an Eye on Overhead Costs

While most business owners focus on growing revenues, they also need to keep an eye on how much they’re spending on overhead (rent, salaries, etc.) to support those sales. A quick way to do that, says Cheng, is to calculate what percentage of your revenues are used to pay overhead:

  • Overhead Expense Percentage (OEP) = Overhead Expenses / Sales

Cheng notes that the number by itself is not that useful. What makes it powerful is when you track it over a 12- to 24-month timeframe. Any fluctuation can reveal problems. “If a company’s sales drop 30 percent, but the OEP skyrockets, it means the company’s overhead has stayed the same while sales dropped, and the company is taking on significant financial risk if they don't cut overhead to get the OEP back to it’s historical level,” Cheng says. He further noted that many small businesses collapsed during the Great Recession because their owners failed to cut enough overhead to compensate for their loss in sales.

Dig Deeper: How to Read a Balance Sheet

Look Beyond Your Financial Statements

Checking up on the health of your business requires more than just the numbers in your financial statements, says Dave Haviland, president of Phimation, a consulting company based in Ann Arbor, Michigan. “Since financials are generally backward looking, they measure results,” he says. “To look forward, you need to look at operational metrics.”

Haviland suggests tracking metrics in each area of your business. For instance:

  • Marketing and sales: track the “backlog” (work already signed but not yet billed/produced) and “sales pipeline” (prospective work in the sales process). These are important because they give you a forward-looking view at what the revenue line will look like, says Haviland.
  • Production: track your “utilization,” which measures how efficiently your company is using its resources.
  • Human Resources: By tracking “suggestions and complaints” (such as notes put in a suggestion/complaint box) you can learn how engaged your employees are. Another suggestion is take a “green/yellow/red” measure, where people put the color dot that represents how their day went. When you count up all the dots and track it over time, you can begin to get a sense of how productive your staff feels they are.

Haviland says you should prioritize what matters most to your business when coming up with other potentially helpful metrics, such as ones built around customer satisfaction and supplier performance.

Greg Alexander, CEO of Sales Benchmark Index, a sales consulting company based in Atlanta, advises tracking your New Business-to-Repeat Business ratio. This ratio tells you the revenue contribution from new prospects and the revenue contribution from existing clients. “Healthy businesses depend on bringing in new clients as well as generating repeat business from existing clients,” says Alexander. “However, if new business is outpacing existing business, you may have a customer retention problem. If business generated from existing clients is outpacing new business, you may have a marketing and sales problem.” Alexander says the right ratio for your company will depend on what kind of business you’re in, noting that his is a 1:5, where repeat business outpaces new business by a five-to-one ratio.

Dig Deeper: How to Choose the Right Finance Professional

Think Strategically

While monitoring a daily dashboard is great for tactical adjustments, says Haviland, there are also monthly or quarterly metrics that can highlight more strategic changes in your business. Examples of metrics that tell you if you’re staying relevant to the market (and which markets are best) include:

  • Percentage of revenue from new products/services
  • Revenue mix by product
  • Revenue mix by customer segment

Again, the best way to keep on top of your company’s financial picture – and to ensure that you sound the alarm before big trouble has already arrived - is to use a mix of current and long range metrics taken both from your financials as well as the operational side of your business.

By seeing how individual parts contribute to the whole, you'll be able to best identify where your business is stumbling. Once you've zeroed in the trouble spots, you'll have the chance to take the necessary steps to fix them.

http://www.inc.com/guides/2010/08/how-to-evaludate-your-financial-position.html

5/12/10

SQL Server APPLY operator

If you would love two scoops of yummy SQL Server query goodness, the APPLY operator is for you.

As I've said before, rarely a day goes by when I don't say "D'oh!" in surprise (and embarrassment) at being unaware of a tool or technology that I probably should have known about, but just didn't.

The SQL Server APPLY operator is one of those gems that I should have known about 5 years ago. I really need to start buying those "What's New In SQL Server" books, and actually reading them.

Imagine this Microsoft Dynamics GP scenario: You need to query vendors and include the vendor's PRIMARY address information, as well as their REMIT TO address information. But it's not quite that simple (it never is).

You find that the client has inconsistent vendor address IDs in their database. Sometimes they just use the address ID of "REMIT", sometimes "REMIT TO" and sometimes "REMIT ADDRESS", among others. And naturally, there are some vendors who don't have a separate REMIT TO address at all. In theory, some vendors may have two or more remit addresses, so you have to handle that situation as well--in which case you only want the TOP 1 remit address record.

While trying to figure out how to write such a query, I came across this article that discussed the OUTER APPLY operator.

Think of it as an OUTER JOIN, but without needing the ON keyword and subsequent matching columns from the two tables. It's also a bit like a subquery, but with the flexibility of a JOIN.

In short, it will make your inner SQL geek salivate.

Here is an example query that retrieves basic vendor information, along with the TOP 1 primary and remit to address records, allowing me to reference the fields in my query through a derived table.

Note that I used the OUTER APPLY version, since I want to return the vendor information even if there is no primary or remit to address. If you only want to return records that have a match in your apply operation, you can use CROSS APPLY, which works like an INNER JOIN. (hence the two scoops of yummy goodness)


SELECT
RTRIM(v.VENDORID) AS VENDORID,
RTRIM(v.VENDNAME) AS VENDNAME,
RTRIM(ISNULL(vpa.VNDCNTCT, '')) AS CONTACT,
RTRIM(ISNULL(vpa.ADDRESS1, '')) AS ADDRESS1,
RTRIM(ISNULL(vpa.ADDRESS2, '')) AS ADDRESS2,
RTRIM(ISNULL(vpa.CITY, '')) AS CITY,
RTRIM(ISNULL(vpa.STATE, '')) AS STATE,
RTRIM(ISNULL(vpa.ZIPCODE, '')) AS ZIPCODE,
RTRIM(ISNULL(vra.ADDRESS1, '')) AS REMITADDRESS1,
RTRIM(ISNULL(vra.ADDRESS2, '')) AS REMITADDRESS2,
RTRIM(ISNULL(vra.CITY, '')) AS REMITCITY,
RTRIM(ISNULL(vra.STATE, '')) AS REMITSTATE,
RTRIM(ISNULL(vra.ZIPCODE, '')) AS REMITZIPCODE,
RTRIM(ISNULL(vpa.PHNUMBR1, '')) AS PHONE1,
RTRIM(ISNULL(vpa.PHNUMBR2, '')) AS PHONE2,
RTRIM(ISNULL(vpa.FAXNUMBR, '')) AS FAX
FROM PM00200 v
OUTER APPLY (SELECT TOP 1 * FROM PM00300 vpa WHERE VENDORID = v.VENDORID AND ADRSCODE LIKE '%PRIMARY%') AS vpa
OUTER APPLY (SELECT TOP 1 * FROM PM00300 vpa WHERE VENDORID = v.VENDORID AND ADRSCODE LIKE '%REMIT%') AS vra


I told you it was tasty! Bon Appétit!


Here are a few more articles on the topic:

http://msdn.microsoft.com/en-us/library/ms175156.aspx

http://www.sqlteam.com/article/using-cross-apply-in-sql-server-2005

http://decipherinfosys.wordpress.com/2007/10/08/apply-operator-in-sql-server-2005/

FROM: http://dynamicsgpland.blogspot.com/2010/05/sql-server-apply-operator.html

5/6/10

What financial data business owners neeed to know everyday

Yesterday Sales
Yesterday Cashflow
Last 30 Day Sales
Last 30 Day Cash Flow
Last 30 Day Top Selling Items
Last 365 Day Sales
Last 365 Day Cash Flow
Low Inventory Items

4/14/10

The Dashboard Demystified

by Victoria Hetherington, Dundas Data Visualization
Wednesday, September 23, 2009

This article aims to provide a fundamental understanding of what a dashboard is and provide a brief look at what dashboards can do for an organization. There is an abundance of dashboard literature out there and this article is a good starting point for those interested in a high level understanding of dashboards.

A dashboard is a business tool that displays a set of PIs (performance indicators), KPIs (key performance indicators), and any other relevant information to a business user. Dashboard data is often displayed in real-time after retrieval from one or more data sources in a business. Dashboards are interactive, allowing an executive to drill into particular aspects of the display or switch between facets or views of the data. Key performance indicators need special consideration because they are high-level measurements of how well an organization is doing in achieving critical success factors – in other words, the goals or targets set by an organization in their strategic plani. Dashboards are composed of data visualization tools like charts, grids, gauges and maps. Many different sectors of many different businesses benefit from dashboards: both a miner determining where to drill from a map of a geographical area and a CEO deciding where to channel funds would benefit from dashboard use.

Dashboards can provide an effective solution to the overwhelming amount of data that business users experience every dayii. A dashboard can save employees time - and companies money - by making everything more intuitive, easier to observe, and allowing for extensive, real-time access instead of going through papers and emails to compile information. In order to have a significant return on the investment of a dashboard, it is important that the dashboard be exactly tailored to suit the needs of a company or a particular role within a company. In addition, it is important that a dashboard have metrics that are meaningful and useful to its target audience. Dashboard vendors, and those looking to invest in dashboards, must consider dashboard options such as interface – i.e., would a primarily graphical interface or an integration of graphics and text suit best? How about a static display or an interactive displayiii? Would it be necessary to invest in an ODS (operational data store) to store and support access to data and metadataiv?

Before deciding on a dashboard and becoming familiar with dashboard categorization and the countless types of data visualization tools available, it is important to be aware of several traits all good dashboards have in common. All dashboards should display a quantitative analysis of what is going on with immediacy and intuitiveness. They should offer creative visual insight, such as an anatomy chart or heat map would offer a hospital – but the interface must not be overly complex: distractions, clichés, and unnecessary embellishments can create confusionv. Good dashboards offer appropriate context for data: for example, a gauge may show that Company X sold 1000 units this year, but compared to what? Highlighting relevant data, effective color use, and a visually appealing interface all help too. A good business dashboard, in other words, pairs dashboard technology with visual effectiveness. In more explicit terms, here are some key elements of a good dashboard:

  • It communicates with clarity; quickly, and compellingly. Simplicity is key.
  • It has minimal unnecessary distractions, no matter how interesting, which could cause confusion.
  • It organizes business information to support meaning and usability
  • It applies the latest understanding of human visual perception to the visual presentation of information
  • It is pleasant to look at

Due to the incredible array of available dashboard technologies, definitive categorization of dashboards is a difficult task. One can categorize dashboards in terms of role, or strategic, analytic, and operational dashboards. Vendors are probably most used to referring to dashboards in these termsvi; though there are several other categorizations that are very common as well.

Most often, dashboards are used for strategic purposesvii. The common executive dashboard, designed for a strategic manager of a medium-sized business, for example, is a strategic dashboard. The strategic dashboard allows for a quick overview of an organization’s ‘health,’ so to speak; assisting with executive decisions such as the formation of long-term goals. The strategic dashboard, therefore, doesn’t require real-time data: what is going on right now is not important, what is pressing is what has been going on. When designing a strategic dashboard, visual communications experts recommend keeping the interface simple – showing just what has been going. It should be noted that not only higher-up corporate people use strategic dashboards to monitor an organization. For example, a middle manager can monitor data on a dashboard, and then create a presentation to pitch to his CEO about the data he has observed.

The analytic dashboard, as the name suggests, assists with data analysis. This can include making comparisons, reviewing extensive histories, and evaluating performance. When using an analytic dashboard, a tactical manager can go beyond what is going on – as with the strategic dashboard – and drill into the causes. They can determine why sales targets were not met; why problems keep occurringviii. Through exploring these patterns, goals can be set to correct these issues over time.

The operational dashboard monitors functions which need constant, real-time, minute-by-minute attention, from a blood pressure monitor in an operating room to an assembly line in a refrigerator factory. As with the strategic dashboard, it is recommended that an operational dashboard have a simple interface: no statistics or analyzing. All that is required of a good operational dashboard is immediacy and practicality, like names of workers and sections of the workplace. They are generally used by those on a departmental, rather than executive levelix.

Categorization of dashboards can go another, equally common route: a vendor could categorize dashboards by the type of data they handle: either quantitative; or pertaining to data based on quantity or number – which is overwhelmingly more common – or qualitative; which could include scheduling and simple, pertinent lists. A vendor could also think of dashboards in terms of domains, both vertical and lateral. A vertical dashboard is specialized for a specific industry, such as mining, manufacturing, banking, or healthcare. Dashboards in lateral domains are designed for the internal departments that most organizations have: the financial, marketing, manufacturing, and human resources departments of a bank, a mining company, and a hospital could all use a similar dashboard to create goals and determine solutions for financial problems; likely from strategic and analytic dashboards for example. It is hard to have an understanding of one mode of categorization without the other.

There are many, many different kinds of dashboards, all tailored to fit specific roles and almost every lateral and vertical cross-section of the world’s industries. This article described three fundamental types of dashboards, but a dashboard does not need to fit one of the categories in order to be successful. Successful dashboards convey a great deal of dense necessary information with clarity and immediacy. Over time, a successful dashboard will improve an organization’s decision-making based on aggregated BI, assist in goal-setting, help monitor negative trends, and improve workplace productivity.

http://www.dashboardinsight.com/articles/digital-dashboards/fundamentals/the-dashboard-demystified.aspx?newsletterid=042010