Posts from MBA Mondays

Budgeting In A Small Early Stage Company

Today and for the next two weeks, we are going to talk about budgeting on MBA Mondays. Since the budgeting process works differently in companies of various sizes, we are going to focus on three company sizes; 10 people, 75 people, and 150 people. Today we will talk about the 10 person company scenario.

As I said in a previous post, I have been working with Matt Blumberg and Jack Sinclair, CEO and COO/CFO of our portfolio company Return Path on these budgeting posts. I have been involved with Return Path for ten years now and I've watched Matt and Jack run excellent budgeting processes and so we are getting the benefit of their work and learning in these posts.

Last week we talked about projections. It is important to run a projections process before you turn to budgeting. Think of budgeting as a refinement of the projections process where the goal is to predict what is going to happen in a particular calendar year.

I believe that budgeting should be done on a yearly basis. If you want to start budgeting and you are in the middle of the year, that is fine. Just budget for the rest of the year and then do your first full year budget in the late fall.

The late fall is budgeting time. October and November are the best months to do it. If you have a board, you should be able to present your budget for the next year to the full board in December so they can approve it before the year starts. If you don't have a board, then you should be able to lock into a budget with your team in December.

The budgeting process starts with a financial model. If you have done projections, then you should have a financial model already built. If haven't done projections, then go back to the projections post, follow the directions, and do some projections. Then come back and read this post.

The first step in budgeting is to review the key business metrics and lock them down based on what is realistic for the next year. Be very realistic. A good budget is a conservative budget. In a ten person company, the budgeting process can be done by a couple of the senior managers, typically the CEO and the most financially savvy of the other team members. These two people can run the process all by themselves without any input from the rest of the team. That will change quickly as the company grows, but in a very small company you do not need to involve the entire team in budgeting.

If the company is pre-revenue as many 10 person companies are, then the focus will be on hiring and people costs. And the budgeting process will largely be about spending and how many people the company can hire and how much money the company can spend and how long its cash will last before needing another round of funding.

If the company has revenues, they will not likely be large yet at 10 people, so the revenue forecast will be a bit tricky. In the first few years of revenue generation, the revenue model changes a lot and the drivers of it change too. I would encourage everyone to be conservative about revenue budgeting early in a company's life. Most budgets are missed because revenue does not come in as planned.

Make sure to include a cash line item in your budget. Most budgets are done as profit and loss statements which is how they should be done. But you should back into a cash projection based on the profit and loss numbers and include that line item in your budget. If this is new material to you, go back to my posts on profit and loss, balance sheet, and cash flow to see how these three statements work together.

Once the budget has been locked down and approved by the board and/or by the senior team, you should share the budget with your entire company. Some executives don't like to share the entire line by line budget with the team and I can understand that. Some executives don't like to show a cash line that runs out with the team and I also understand that. But you should at least show the key business metrics and some of the most important line items in the budget with the entire company. This will be their roadmap for the next year and it is important that they understand it if they are going to be expected to help you deliver it. 

All that said, I favor being as transparent as you can possibly be with your company. It is hard to hide information from the company. The important information leaks out eventually and if and when it does, you won't be there to provide context. So the more information you provide, the better off you will be.

Once you have a budget, you need to measure yourself against it. Each month report the actual numbers versus the budget and track how you are doing against each key business metric and line item in the budget. At some point during the year, you may want to do a reforecast. We will talk about that exercise in a few weeks.

Next week we will talk about how this process changes as you grow to 75 people. It a very different process at that point.

Reblog this post [with Zemanta]

#MBA Mondays

Scenarios

In last week's MBA Mondays, I introduced the topic that we'll be focused on for the next month or so; projections, budgeting, and forecasting. In that post, I described projecting as a "what if" exercise that is done at a higher level of abstraction than the budgeting and forecasting exercises. I said this about projections:

These are a set of numbers, both financial and operational, that you
make about your business for various purposes, including raising
capital. They are aspirational and are often done with a "what could
be" perspective.

Since projections are not budgets and are much more "big picture" exercises, it is important to use a scenario driven approach to them. I generally like three scenarios; best case, base case, and worst case. But you could do as many scenarios as you like. It's not the results that matter so much, it's the process and the learning that comes from the projections exercise.

If you build your projections with a detailed set of assumptions and if you can assign probabilities to each assumption, you could easily do a monte carlo simulation in which literally thousands, or tens of thousands, of scenarios are run and the outcomes are charted on a bell curve. I don't recommend doing projections this way, but my point is simply that the number of scenarios is not important, it's the process by which you determine the key drivers of the business, the assumptions about them, and the probabilities associated with them.

A few weeks ago on MBA Mondays we talked about key business metrics. It is very important to identify your key business metrics before you do projections. These key business metrics will drive your projections and your assumptions about how these metrics will develop over time will determine how your scenarios play out.

Let's get specific here. I'll assume we are operating a software business and we are selling the software as a service over the internet using a freemium model. Everyone can use a lightweight version of the software for free, but to get the fully featured version the user must pay $9.95 per month. So here are some of the key business metrics you might use in projecting the business; productivity of the engineering team, feature release cycle, current outstanding known software bugs, total users, new free users per month, conversion rate from free to paid, marketing dollars invested per new free user, marketing dollars invested per new paid user; customer support incidents per day; cost to close a customer support incident. These are just examples of key business metrics you can use. Every business will have a different set.

The next step is to lay all of these metrics out in a spreadsheet and make assumptions about them. As I said, I like three assumptions, best case, base case, and worst case. Best case is not the best it could ever be but best you think it will ever be. Base case is what you genuinely expect it to be. And worst case should be the worst it could ever be. Worst case is really important. This is your nightmare scenario.

You then calculate your costs and revenues as a function of these metrics. There are some expenses that will not vary bases on the assumptions. Rent is a good example of that in the short term. But over time, rent will move up if you need to hire like crazy. I would go out at least three years in a projections exercise. Some people like to go out five years. I've even seen ten year projections. I don't think any technology driven business can project out ten years. I am not even sure about five years. I believe three years is ideal.

Getting the assumptions right and building up to a full blown projected profit and loss statement is an iterative process. You will not get it right the first time. But if you build the spreadsheet correctly the iterating process is not too painful. Do not do this exercise all by yourself. It should be done by a team of people. If you are a one person company right now, then show the results to friends, advisors, potential investors. Get feedback on your key business metrics, assumptions, and results. Think about the results. Do they make sense? Are they achievable?

In last week's comment thread we got into a conversation about "top down" vs "bottom up" analysis. Top down is when you say "the market size is $1bn, we can get 10% of it, so we'll be a $100mm business."  I think top driven analysis is not very rigorous and likely to produce bad answers .The kind of projection work I've been talking about in this post is "bottom up" and is based on what can actually be achieved. However, it is often best to take the results of a bottom up analysis and do a reality check using a top down analysis.

So when your best case scenario has your business at $100mm in revenues in year three, do yourself a favor and do a top down reality check on that. No matter how rigorous the projections process is, if the results are not believable then the whole exercise will have been wasted.

Most entrepreneurs do projections as part of a financing process. And it is a good idea to have projections for your business when you go out to raise money. But I would advise entrepreneurs to do projections for themselves too. It is a good idea to have some idea of what you are building to. Make sure it is not a waste of time for you and the team your recruit to join you.

It is true that most great tech businesses, possibly all businesses, are initially built to "scratch an itch." But once you get past the "I built this because I wanted it" and when you find yourself hiring people, raising capital, renting space, it's time to think about what you are doing as a business and having solid projections and a few scenarios is a really good way to do that.

#MBA Mondays

Projections, Budgeting and Forecasting

MBA Mondays is starting a new topic this week. It's a big one and I think we'll end up doing at least four and maybe even five posts on this topic in the coming weeks.

I said the following in one of my first MBA Mondays posts:

companies are worth the "present value" of "future cash flows"

The point being that the past doesn't matter too much when it comes to valuing companies. It's all about what is going to happen in the future. And that requires projecting the future.

There is another big reason why projections matter. They are used for goal and expectation setting. Generally speaking goal setting is used to manage the team and expectation setting is used to manage the board, investors, and other important stakeholders.

And finally, projections matter because they tell you what your financing needs are. It is critical to know when you will need additional financing so you can start planning and executing the process well in advance of running out of cash (I like 6 months).

There are three important kinds of projections. I'll outline each of them.

1) Projections – These are a set of numbers, both financial and operational, that you make about your business for various purposes, including raising capital. They are aspirational and are often done with a "what could be" perspective.

2) Budgets – These are a set of numbers, both financial and operational, that the management team prepares each year, usually in the fall, that outline what the company plans to achieve in the coming year. They are presented and approved by the board and the management team's compensation is often driven by them.

3) Forecasts – These are iterations of the budget that are done intra-year by the management team to indicate what is likely to occur. They reflect the fact that the actual performance is going to vary from budget (in both positive and negative ways) and it is important to know where the numbers will actually end up.

Over the coming weeks, I will go through the processes companies use to project, budget, and forecast. Because I do not do this work myself, I've enlisted one of our portfolio companies to help me with these posts. 

I've been working with Return Path for ten years now. Matt Blumberg, CEO, and Jack Sinclair, CFO and sometimes COO, have done over ten sets of projections, budgets, and forecasts for me and other investors, board members, and team members. In the process they have evolved from a raw startup to a well oiled machine. With their help, I will talk about the how three "model companies" go about projecting, budgeting, and forecasting. These companies will be 10 person, 75 person, and 150 person. These are the typical sizes of companies that I work with and are probably also the sizes of companies that most of the readers of this blog are dealing with.

I'll end this post with a picture that Matt sent me last week. This is ten years worth of board books that include Return Path's projections, budgets, and forecasts. The goal of MBA Mondays in the coming weeks will be to get all of you to a place where you can create something similar.

Rp budgets
 

Reblog this post [with Zemanta]

#MBA Mondays

Price: Why Lower Isn't Always Better

I want to tackle the issue of forecasting and projections next in the MBA Mondays series but I don't yet have an outline in my head of how I am going to approach this critical subject. So I am taking a breather this week and instead will tell a story I heard from a marketing professor in business school.

This professor did a lot of consulting on the side. He was known as a highly analytic marketing expert. He was asked to take on a french producer of champagne as a client. This champagne producer was trying to enter the US market but was not selling very much of their product in the US.

The professor did an analysis of the "five Ps"; product, price, people, promotion, and place. He determined that the champagne was of very high quality, it was being distributed in the right places, and that the marketing investment behind it was substantial. And yet it wasn't selling very well. 

He did an analysis of comparable quality champagnes and determined that this particular producer was pricing his product at the very low end of the range of comparable product.

So the professor's recommendation was to increase the wholesale price such that the retail price would double. The client was very nervous about the professor's recommendation but in the end did it. And the champagne started selling like crazy. They couldn't keep it in stock.

The morale of this story is that price is often used as a proxy for quality by customers, particularly when the product is a luxury item. By pricing the champagne at the very low end of the range of comparable product, the producer was signaling that its product was of lower quality than the competition. And by raising the price, they signaled it was of higher quality.

So when you are selling something, be it advertising, software, or something else, think carefully about how you are signaling the market with your pricing. Having the lowest price among your competition might be the right strategy but it might also be the wrong one.

#MBA Mondays

Key Business Metrics

The past five MBA Mondays posts have been about accounting concepts, financial statements, and related issues. I don't know about all of you, but I'm a bit tired of that stuff. So I'm moving on to something a bit different.

Every business should have a set of metrics that it tracks on a regular basis. These metrics could include some of the accounting stuff we've been talking about like cash, revenues, profits, etc but it should not be limited to those kinds of metrics.

Early on when the company is developing its first product or service, those metrics might be related to product development like development resources, features completed, known bugs, etc. Once the product or service is launched, the metrics might shift to include customers, daily active users, churn, conversions from free trial to paid customer, etc.

As the business grows and develops, the amount of data you can collect and publish to your team grows. If you aren't careful, you can overwhelm your team with data.

It becomes very important to distill the business down to a handful of key business metrics. There are usually four to six metrics that will be sufficient to determine the overall health and growth trajectory of the business and it is best to focus the team on them.

Our portfolio company Meetup has learned to focus on successful Meetup groups. Those are Meetup groups that are active, meeting regularly, have growing memberships, and are paying fees to Meetup. Meetup could focus on other data sets like monthly unique visitors, new Meetup groups, total registered users, revenues, profits, cash. They collect that data and share it with the team. But the number one thing they look at it successful Meetup groups and that has worked well for them. It is their key business metric.

Sometimes the most important data on your business is the hardest to collect. Twitter knows that the total number of times all tweets have been viewed each day, month, or year is a critical measure of the overall reach of the network. But because so many of those tweets are viewed on third party services, web pages, apps, etc, it is very hard to collect that data. The Company is only now starting to measure them.

Most key business metrics will be drivers of revenues and growth but not all of them. Etsy is focusing a lot of effort on its customer service metrics, which are a cost center not a revenue driver. But the Company knows that customer service is critical to the health of the marketplace, so customer service metrics are key business metrics for them.

The management team should spend time talking about and selecting the key business metrics to focus on. They should collect the data on a regular basis, the more real-time the better in my opinion, and they should publish the key business metrics to the entire team.

I do not believe it makes any sense to segment who gets to see what business metrics in a company. Sales metrics should be shared with development. Customer service metrics should be shared with finance. And so on and so forth.

Some companies buy big screens and mount them on the walls around the office and publish the key business metrics on them so everyone can see them. I like that approach. But I also like sending out a regular email to the entire company with the key business metrics and how they are trending. And of course, I think these metrics should be shared with the Board and key investors.

When you publish financial projections (a topic for the coming weeks), you should include your projections or assumptions for key business metrics in the periods for which you are projection financial performance. Many of these metrics will be drivers of your projections but they are also helpful to establish the overall progress of the business over time.

It is a good idea to evaluate what your company's key business metrics should be from time to time. I like to suggest at least once a year, probably around the annual budgeting exercise (another topic for the coming week). It is expected that you will change some of these metrics every year as the business grows and develops. Don't just keep adding new ones, you should also subtract old ones that don't seem as useful anymore. Keep the total number of key business metrics you are tracking to a small enough number that most people on the team could recite them from memory. Less is more when it comes to key business metrics.

Tracking key business metrics is important for a bunch of reasons, but probably the most important reason is cultural. It helps to keep everyone on the same page, aligns people across the different parts of the business, and leads to a culture of success when you see the key business metrics moving in the right direction. It's critical to celebrate when a key business metrics reaches a new and important milestone. These kinds of things seem silly to some but are incredibly important to building a strong company culture that can work together and grow rapidly.

#MBA Mondays

Analyzing Financial Statements

This topic could be and is a full semester course at some business schools. It is a deep and rich topic that I can’t cover in one single blog post. But it is also a relatively narrow skill set at its most developed levels. If you are going to be a public equity analyst, you need to understand this stuff cold and this post will not get you there.

But if you are an entrepreneur being handed financial statements from your bookkeeper or accountant or controller, then you need to be able to understand them and I’d like this post to help you do that. I’d also like this post help those of you who want to be more confident buying, holding, and selling public stocks. So that’s the perspective I will bring to this topic.

In the past three weeks, we talked about the three main financial statements, the Income Statement, the Balance Sheet, and the Cash Flow Statement. This post is going to attempt to help you figure out how to analyze them, at least at a cursory level.

In general, I like to start with cash. It’s the first line item on the Balance Sheet (it could be the first several lines if you want to combine it with short term investments). Note how much cash you have or how much cash the company you are analyzing has. Remember that number. If someone asks you how much cash you have in your business, or a business you are analyzing, and you can’t answer that to the last accounting period (at least), then you failed. There is no middle ground. Cash is that important.

Then look at how much cash the business had in a prior period. Last month is a good place to start but don’t end there. Look at how much cash went up or down in the past month. Then look much farther back, at least a quarter, and ideally six months and/or a year. Calculate how much cash went up or down over the period and then divide by the number of months in the period. That’s the average cash flow (or cash burn) per month. Remember that number.

But that number can be misleading, particularly if you did any debt or equity financings during that period (or if you paid off any debt facilities during that period). Back out the debt and equity financings and do the same calculations of average cash flow per month. Hopefully the monthly number, the quarterly average, the six-month average, and the annual average are in the same ballpark. If they are not, something is changing in the business, either for the good or the bad and you need to dig deeper to find out what. We’ll get to that.

If cash flow is positive for all periods, then you are done with cash. If it is negative, do one more thing. Divide your cash balance by the average monthly burn rate and figure out how many months of cash you have left. If you are burning cash, you need to know this number by heart as well. It is the length of your runway. For all you entrepreneurs out there, the three cash related numbers you need to be on top of are current cash balance, cash burn rate, and months of runway.

I generally like to go to the income statement next. And I like to lay out a few periods next to each other, ideally chronologically from oldest on the left to the newest on the right. For startups and early stage companies, a 12 month trended monthly presentation of the income statement is ideal. For more mature companies, including public companies, the current quarter and the four previous quarters are best.

Some people like to graph the key line items in the income statement (revenue, gross margin, operating costs, operating income) over time.  That’s good if you are a visual person. I find looking at the hard numbers works better for me. Note how things are moving in the business. In a perfect world, revenues and gross margins are growing faster than operating costs, and operating income (or losses) are increasing (or decreasing) faster than both of them. That is a demonstration of the operating leverage in the business.

But some early stage companies either have no revenue or are investing in the business faster than they are growing revenue. That is a sound strategy if the investments they are making are solid ones and if they have a timeline laid out during which they’ll do this. You can’t do that forever. You’ll run out of cash and go out of business.

From this analysis, you may see why the business is burning cash or burning cash more quickly or less quickly. You may see why the business is growing its cash flow rapidly. I am most comfortable when the monthly operating income (or losses) of a business are roughly equal to its cash flow (or cash burn). This does not have to be the case for the business to be healthy but it means the business has a relatively simple economic architecture, which is always comforting. From Enron to Lehman Brothers, we’ve learned that complex business architectures are hard to analyze and easy to manipulate.

One thing that bears mentioning here are “one time items” on the Income Statement. They make your life harder. If you go back to the Income Statement post and look at Google’s statement, you’ll see that in the first year of their presentation Google made a one-time contribution to the Google Foundation. That depressed earnings in that period. You need to back that one time charge out for a consistent presentation, but you also need to be somewhat suspicious of one-time charges. Companies can try to bury ongoing expenses in one-time charges and inflate their earnings. You don’t see that much in startups but you do in public companies and it’s a “red flag” if a company does it too often.

If the monthly operating income (after backing out one-time charges) doesn’t come close to the monthly cash burn rates, then something is going on with the balance sheet of the business. Many of these differences are normal for certain businesses. My friend Ron Schreiber told me about a software distribution business he and his partner Jordan Levy ran in the mid 80s. They would buy software from Microsoft, Lotus, and others in bulk and sell it in small quantities to mom and pop businesses. Microsoft and Lotus wanted to be paid upfront when the shipped the software but the mom and pop businesses were running on fumes and could not pay until they sold the software. So Ron’s business, called Software Distribution Services (of course), was always out of cash. In Ron’s words, they were a bank and a distribution company and weren’t getting paid for the banking part of their business. All during this time the revenue line and the operating income line was growing fast and furious as desktop software went from a niche business to a mainstream business. Eventually Ron and Jordan had to sell their business to Ingram, a large book distributor who had the financial resources to provide the “banking services”. They made a nice hit on that company, but not anything like what Microsoft and Lotus did even though they grew their topline just as fast as their suppliers.

Ron and Jordan’s business was “working capital intensive.” Working capital is the non cash current assets and liabilities of the business. When they grow rapidly in relation to revenues, it means you are financing other parts of the food chain in your industry and that’s a great way to run out of cash.

So if monthly income and monthly cash flow aren’t in the same ballpark, look at the changes in working capital month over month. We went over this a bit last week in preparing the cash flow statement. If working capital is the culprit soaking up the cash, you need to look at two things.

The first is if the revenues are real. A great way to inflate revenues is to “ship product” to people who aren’t going to pay you. A company that is doing that is operating fraudently so you don’t see it very often. But if someone is doing this, cash will be going down while profits are steady and accounts receivable are growing rapidly. I always look for that in a company that is supposed to be profitable but is sucking cash.

The second is the availability of working capital financing. If a business can finance its working capital needs inexpensively, then it can operate successfully with this business model. In times when debt is flowing freely, these can be good businesses to operate. When cash is tight, they are not.

The final thing to look for on the balance sheet is capex.  If a business is operating profitably, and growing profits, but its capex line is growing faster than profits, it’s got the potential for problems. Hosting companies are an example of a set of companies that might be in this situation. Again, the availability of financing is the key. Local cable operators operated profitably for years with big negative cash flows because of capex. The fiancial markets like the monopolies these busineses were granted and consistently provided them with financing to buy more capex. But if that party ends, it can be painful.

This post is three pages long in my editor so it’s time to stop. There is more to discuss on this topic so I’d like to know if I did this topic justice for most of you or if you’d like another post that digs a little deeper. My preference is to move on because I’m getting a bit tired of writing about accounting every Monday, but most of all I want to cover the stuff you want to learn or freshen up on. So let me know.

Enhanced by Zemanta
#MBA Mondays

Cash Flow

This week on MBA Mondays we are going to talk about cash flow. A few weeks ago, in my post on Accounting, I said there were three major accounting statements. We’ve talked about the Income Statement and the Balance Sheet. The third is the Cash Flow Statement.

I’ve never been that interested in the Cash Flow Statement per se. The standard form of a cash flow statement is a bit hard to comprehend in my opinion and I don’t think it does a very good job of describing the various aspects of cash flow in a business.

That said, let’s start with the concept of cash flow and we’ll come back to the accounting treatment.

Cash flow is the amount of cash your business either produces or consumes in a given period, typically a month, quarter, or year. You might think that is the same as the profit of the business, but that is not correct for a bunch of reasons.

The profit of a business is the difference between revenues and expenses. If revenues are greater than expenses, your business is producing a profit. If expenses are greater than revenues, your business is producing a loss.

But there are many examples of profitable businesses that consume cash. And there are also examples of unprofitable businesses that produce cash, at least for a period of time.

Here’s why.

As I explained in the Income Statement post, revenues are recognized as they are earned, not necessarily when they are collected. And expenses are recognized as they are incurred, not necessarily when they are paid for. Also, some things you might think of as expenses of a business, like buying servers, are actually posted to the Balance Sheet as property of the business and then depreciated (ie expensed) over time.

So if you have a business with significant hardware requirements, like a hosting business for example, you might be generating a profit on paper but the cash outlays you are making to buy servers may mean your business is cash flow negative.

Another example in the opposite direction would be a software as a service business where your company gets paid a year in advance for your software subscription revenues. You collect the revenue upfront but recognize it over the course of the year. So in the month you collect the revenue from a big customer, you might be cash flow positive, but your Income Statement would show the business operating at a loss.

Cash flow is really easy to calculate. It’s the difference between your cash balance at the start of whatever period you are measuring and the end of that period. Let’s say you start the year with $1mm in cash and end the year with $2mm in cash. Your cash flow for the year is positive by $1mm. If you start the year with $1mm in cash and end the year with no cash, your cash flow for the year is negative by $1mm.

But as you might imagine the accounting version of the cash flow statement is not that simple. Instead of getting into the standard form, which as I said I don’t really like, let’s talk about a simpler form that gets you to mostly the same place.

Let’s say you want to do a cash flow statement for the past year. You start with your Net Income number from your Income Statement for the year. Let’s say that number is $1mm of positive net income.

Then you look at your Balance Sheet from the prior year and the current year. Look at the Current Assets (less cash) at the start of the year and the Current Assets (less cash) at the end of the year. If they have gone up, let’s say by $500,000, then you subtract that number from your Net Income. The reason you subtract the number is your business used some of your cash to increase its current assets. One typical reason for that is your Accounts Receivable went up because your customers are taking longer to pay you.

Then look at your Non-Current Assets at the start of the year and the end of the year. If they have gone up, let’s say by $500k, then you also subtract that number from your Net Income. The reason is your business used some of your cash to increase its Non-Current Assets, most likely Property, Plant, and Equipment (like servers).

At this point, halfway through this simplified cash flow statement, your business that had a Net Income of $1mm produced no cash because $500k of it went to current assets and $500k of it went to non-current assets.

Liabilities work the other way. If they go up, you add the number to Net Income. Let’s start with Current Liabilities such as Accounts Payable (money you owe your suppliers, etc). If that number goes up by $250k over the course of the year, you are effectively using your suppliers to finance your business. Another reason current liabilities could go up is Deferred Revenue went up. That would mean you are effectively using your customers to finance your business (like that software as a service example earlier on in this post).

Then look at Long Term Liabilities. Let’s say they went up by $500k because you borrowed $500k from the bank to purchase the servers that caused your Non-Current Assets to go up by $500k. So add that $500k to Net Income as well.

Now, the simplified cash flow statement is showing $750k of positive cash flow. But we have one more section of the Balance Sheet to deal with, Stockholders Equity. For Stockholders Equity, you need to back out the current year’s net income because we started with that. Once you do that, the main reason Stockholders Equity would go up would be an equity raise. Let’s say you raised $1mm of venture capital during the year and so Stockholder’s Equity went up by $1mm. You’d add that $1mm to Net Income as well.

So, that’s basically it. You start with $1mm of Net Income, subtract $500k of increased current assets, subtract $500k of increased non-current assets, add $250k of increased current liabilities, add $500k of increased long-term liabilities, and add $1mm of increased stockholders equity, and you get positive cash flow of $1.75mm.

Of course, you’ll want to check this against the cash balance at the start of the year and the end of the year to make sure that in fact cash did go up by $1.75mm. If it didn’t, then you have to go back and check your math.

So why would anyone want to do the cash flow statement the long way if you can simply compare cash at the start of the year and the end of the year? The answer is that doing a full-blown cash flow statement tells you a lot about where you are consuming or producing cash. And you can use that information to do something about it.

Let’s say that your cash flow is weak because your accounts receivable are way too high. You can hire a dedicated collections person. You can start cutting off customers who are paying you too late. Or you can do a combination of both. Bringing down accounts receivable is a great way to improve a business’ cash flow.

Let’s say you are spending a boatload on hardware to ramp up your web service’s capacity. And it is bringing your cash flow down. If you are profitable or have good financial backers, you can go to a bank and borrow against those servers. You can match non-current assets to long-term liabilities so that together they don’t impact the cash flow of your business.

Let’s say your current liabilities went down over the past year by $500k. That’s a $500k reduction in your cash flow. Maybe you are paying your bills much more quickly than you did when you started the business and had no cash. You might instruct your accounting team to slow down bill payment a bit and bring it back in line with prior practices. That could help produce better cash flow.

These are but a few examples of the kinds of things you can learn by doing a cash flow statement. It’s simply not enough to look at the Income Statement and the Balance Sheet. You need to understand the third piece of the puzzle to see the business in its entirety.

One last point and I am done with this week’s post. When you are doing projections for future years, I encourage management teams to project the income statement first, then the cash flow statement, and then end up with the balance sheet. You can make assumptions about how the line items in the Income Statement will cause the various Balance Sheet items to change (like Accounts Receivable should be equal to the past three months of revenue) and then lay all that out as a cash flow statement and then take the changes in the various items in the cash flow statement to build the Balance Sheet. I like to do that in monthly form. We’ll talk more about projections next week because I think this is a very important subject for startups and entrepreneurial management teams to wrap their heads around.

#MBA Mondays

The Balance Sheet

Today on MBA Mondays we are going to talk about the Balance Sheet.

The Balance Sheet shows how much capital you have built up in your business.

If you go back to my post on Accounting, you will recall that there are two kinds of accounts in a company's chart of accounts; revenue and expense accounts and asset and liability accounts.

Last week we talked about the Profit and Loss statement which is a report of the revenue and expense accounts.

The Balance Sheet is a report of the asset and liability accounts. Assets are things you own in your business, like cash, capital equipment, and money that is owed to you for products and services you have delivered to customers. Liabilities are obligations of the business, like bills you have yet to pay, money you have borrowed from a bank or investors.

Here is Google's balance sheet as of 12/31/2009:

Google balance sheet 

Let's start from the top and work our way down.

The top line, cash, is the single most important item on the balance sheet. Cash is the fuel of a business. If you run out of cash, you are in big trouble unless there is a "filling station" nearby that is willing to fund your business. Alan Shugart, founder of Seagate and a few other disk drive companies, famously said "cash is more important than your mother." That's how important cash is and you never want to get into a situation where you run out of it.

The second line, short term investments, is basically additional cash. Most startups won't have this line item on their balance sheet. But when you are Google and are sitting on $24bn of cash and short term investments, it makes sense to invest some of your cash in "short term instruments". Hopefully for Google and its shareholders, these investments are safe, liquid, and are at very minimal risk of loss.

The next line is "accounts receivable". Google calls it "net receivables' because they are netting out money some of their partners owe them. I don't really know why they are doing it that way. But for most companies, this line item is called Accounts Receivable and it is the total amount of money owed to the business for products and services that have been delivered but have not been collected. It's the money your customers owe your business. If this number gets really big relative to revenues (for example if it  represents more than three months of revenues) then you know something is wrong with the business. We'll talk more about that in an upcoming post about financial statement analysis.

I'm only going to cover the big line items in this balance sheet. So the next line item to look at is called Total Current Assets. That's the amount of assets that you can turn into cash fairly quickly. It is often considered a measure of the "liquidity of the business."

The next set of assets are "long term assets" that cannot be turned into cash easily. I'll mention three of them.  Long Term Investments are probably Google's minority investments in venture stage companies and other such things. The most important long term asset is "Property Plant and Equipment" which is the cost of your capital equipment. For the companies we typically invest in, this number is not large unless they rack their own servers. Google of course does just that and has spent $4.8bn to date (net of depreciation) on its "factory". Depreciation is the annual cost of writing down the value of your property plant and equipment. It appears as a line in the profit and loss statement. The final long term asset I'll mention is Goodwill. This is a hard one to explain. But I'll try. When you purchase a business, like YouTube, for more than it's "book value" you must record the difference as Goodwill.  Google has paid up for a bunch of businesses, like YouTube and Doubleclick, and it's Goodwill is a large number, currently $4.9bn. If you think that the value of any of the businesses you have acquired has gone down, you can write off some or all of that Goodwill. That will create a large one time expense on your profit and loss statement.

After cash, I believe the liability section of the balance sheet is the most important section. It shows the businesses' debts. And the other thing that can put you out of business aside from running out of cash is inability to pay your debts. That is called bankruptcy. Of course, running out of cash is one reason you may not be able to pay your debts. But many companies go bankrupt with huge amounts of cash on their books. So it is critical to understand a company's debts.

The main current liabilities are accounts payable and accrued expenses. Since we don't see any accrued expenses on Google's balance sheet I assume they are lumping the two together under accounts payable. They are closely related. Both represent expenses of the business that have yet to be paid. The difference is that accounts payable are for bills the company receives from other businesses. And accrued expenses are accounting entries a company makes in anticipation of being billed. A good example of an accounts payable is a legal bill you have not paid. A good example of an accrued expense is employee benefits that you have not yet been billed for that you accrue for each month.

If you compare Current Liabilities to Current Assets, you'll get a sense of how tight a company is operating. Google's current assets are $29bn and its current liabilities are $2.7bn. It's good to be Google, they are not sweating it. Many of our portfolio companies operate with these numbers close to equal. They are sweating it.

Non current liabilities are mostly long term debt of the business. The amount of debt is interesting for sure. If it is very large compared to the total assets of the business its a reason to be concerned. But its even more important to dig into the term of the long term debt and find out when it is coming due and other important factors. You won't find that on the balance sheet. You'll need to get the footnotes of the financial statements to do that. Again, we'll talk more about that in a future post on financial statement analysis.

The next section of the balance sheet is called Stockholders Equity. This includes two categories of "equity". The first is the amount that equity investors, from VCs to public shareholders, have invested in the business. The second is the amount of earnings that have been retained in the business over the years. I'm not entirely sure how Google breaks out the two on it's balance sheet so we'll just talk about the total for now. Google's total stockholders equity is $36bn. That is also called the "book value" of the business. 

The cool thing about a balance sheet is it has to balance out. Total Assets must equal Total Liabilities plus Stockholders Equity. In Google's case, total assets are $40.5bn. Total Liabilities are $4.5bn. If you subtract the liabilities from the assets, you get $36bn, which is the amount of stockholders equity.

We'll talk about cash flow statements next week and the fact that a balance sheet has to balance can be very helpful in analyzing and projecting out the cash flow of a business.

In summary, the Balance Sheet shows the value of all the capital that a business has built up over the years. The most important numbers in it are cash and liabilities. Always pay attention to those numbers. I almost never look at a profit and loss statement without also looking at a balance sheet. They really should be considered together as they are two sides of the same coin.

Enhanced by Zemanta
#MBA Mondays

The Profit and Loss Statement

Today on MBA Mondays we are going to talk about one of the most important things in business, the profit and loss statement (also known as the P&L).

Picking up from the accounting post last week, there are two kinds of accounting entries; those that describe money coming into and out of your business, and money that is contained in your business. The P&L deals with the first category.

A profit and loss statement is a report of the changes in the income and expense accounts over a set period of time. The most common periods of time are months, quarters, and years, although you can produce a P&L report for any period.

Here is a profit and loss statement for the past four years for Google. I got it from their annual report (10k). I know it is too small on this page to read, but if you click on the image, it will load much larger in a new tab.

Google p&l

The top line of profit and loss statements is revenue (that's why you'll often hear revenue referred to as "the top line"). Revenue is the total amount of money you've earned coming into your business over a set period of time. It is NOT the total amount of cash coming into your business. Cash can come into your business for a variety of reasons, like financings, advance payments for services to be rendered in the future, payments of invoices sent months ago.

There is a very important, but highly technical, concept called revenue recognition. Revenue recognition determines how much revenue you will put on your accounting statements in a specific time period. For a startup company, revenue recognition is not normally difficult. If you sell something, your revenue is the price at which you sold the item and it is recognized in the period in which the item was sold. If you sell advertising, revenue is the price at which you sold the advertising and it is recognized in the period in which the advertising actually ran on your media property. If you provide a subscription service, your revenue in any period will be the amount of the subscription that was provided in that period.

This leads to another important concept called "accrual accounting." When many people start keeping books, they simply record cash received for services rendered as revenue. And they record the bills they pay as expenses. This is called "cash accounting" and is the way most of us keep our personal books and records. But a business is not supposed to keep books this way. It is supposed to use the concept of accrual accounting.

Let's say you hire a contract developer to build your iPhone app. And your deal with him is you'll pay him $30,000 to deliver it to you. And let's say it takes him three months to build it. At the end of the three months you pay him the $30,000. In cash accounting, in month three you would record an expense of $30,000. But in accrual accounting, each month you'd record an expense of $10,000 and because you aren't actually paying the developer the cash yet, you charge the $10,000 each month to a balance sheet account called Accrued Expenses. Then when you pay the bill, you don't touch the P&L, its simply a balance sheet entry that reduces Cash and reduces Accrued Expenses by $30,000.

The point of accrual accounting is to perfectly match the revenues and expenses to the time period in which they actually happen, not when the payments are made or received.

With that in mind, let's look at the second part of the P&L, the expense section. In the Google P&L above, expenses are broken out into several categories; cost of revenues, R&D, sales and marketing, and general and administration. You'll note that in 2005, there was also a contribution to the Google Foundation, but that only happened once, in 2005.

The presentation Google uses is quite common. One difference you will often see is the cost of revenues applied directly against the revenues and a calculation of a net amount of revenues minus cost of revenues, which is called gross margin. I prefer that gross margin be broken out as it is a really important number. Some businesses have very high costs of revenue and very low gross margins. And example would be a retailer, particularly a low price retailer. The gross margins of a discount retailer could be as low as 25%.

Google's gross margin in 2009 was roughly $14.9bn (revenue of $23.7bn minus cost of revenues of $8.8bn). The way gross margin is most often shown is as a percent of revenues so in 2009 Google's gross margin was 63% (14.9bn divided by 23.7). I prefer to invest in high gross margin businesses because they have a lot of money left after making a sale to pay for the other costs of the business, thereby providing resources to grow the business without needing more financing. It is also much easier to get a high gross margin business profitable.

The other reason to break out "cost of revenues" is that it will most likely increase with revenues whereas the other expenses may not. The non cost of revenues expenses are sometimes referred to as "overhead". They are the costs of operating the business even if you have no revenue. They are also sometimes referred to as the "fixed costs" of the business. But in a startup, they are hardly fixed. These expenses, in Google's categorization scheme, are R&D, sales and marketing, and general/admin. In layman's terms, they are the costs of making the product, the costs of selling the product, and the cost of running the business.

The most interesting line in the P&L to me is the next one, "Income From Operations" also known as "Operating Income." Income From Operations is equal to revenue minus expenses. If "Income From Operations" is a positive number, then your base business is profitable. If it is a negative number, you are losing money. This is a critical number because if you are making money, you can grow your business without needing help from anyone else. Your business is sustainable. If you are not making money, you will need to finance your business in some way to keep it going. Your business is unsustainable on its own.

The line items after "Income From Operations" are the additional expenses that aren't directly related to your core business. They include interest income (from your cash balances), interest expense (from any debt the business has), and taxes owed (federal, state, local, and possibly international). These expenses are important because they are real costs of the business. But I don't pay as much attention to them because interest income and expense can be changed by making changes to the balance sheet and taxes are generally only paid when a business is profitable. When you deduct the interest and taxes from Income From Operations, you get to the final number on the P&L, called Net Income.

I started this post off by saying that the P&L is "one of the most important things in business." I am serious about that. Every business needs to look at its P&L regularly and I am a big fan of sharing the P&L with the entire company. It is a simple snapshot of the health of a business.

I like to look at a "trended P&L" most of all. The Google P&L that I showed above is a "trended P&L" in that it shows the trends in revenues, expenses, and profits over five years. For startup companies, I prefer to look at a trended P&L of monthly statements, usually over a twelve month period. That presentation shows how revenues are increasing (hopefully) and how expenses are increasing (hopefully less than revenues). The trended monthly P&L is a great way to look at a business and see what is going on financially.

I'll end this post with a nod to everyone who commented last week that numbers don't tell you everything about a business. That is very true. A P&L can only tell you so much about a business. It won't tell you if the product is good and getting better. It won't tell you how the morale of the company is. It won't tell you if the management team is executing well. And it won't tell you if the company has the right long term strategy. Actually it will tell you all of that but after it is too late to do anything about it. So as important as the P&L is, it is only one data point you can use in analyzing a business. It's a good place to start. But you have to get beyond the numbers if you really want to know what is going on.

#MBA Mondays

Accounting

I'm making up the curriculum for MBA Mondays on the fly. The end game is to lay out how to look a businesses, value it, and invest in it. We started with the time value of money and interest rates, we then talked about the corporate entity. Now I want to talk about how to keep track of the money in a company. That is called accounting. This will be a multi-post effort and will include posts on cash flow, profit and loss, balance sheets, GAAP accounting, audits, and financial statement analysis. But before we can get to those issues, we need to start with the basics of accounting.

Accounting is keeping track of the money in a company. It's critical to keep good books and records for a business, no matter how small it is. I'm not going to lay out exactly how to do that, but I am going to discuss a few important principals.

The first important principal is every financial transaction of a company needs to be recorded. This process has been made much easier with the advent of accounting software. For most startups, Quickbooks will do in the beginning. As the company grows, the choice of accounting software will become more complicated, but by then you will have hired a financial team that can make those choices.

The recording of financial transactions is not an art. It is a science and a well understood science. It revolves around the twin concepts of a "chart of accounts" and "double entry accounting." Let's start with the chart of accounts.

The accounting books of a company start with a chart of accounts. There are two kinds of accounts; income/expense accounts and asset/liability accounts. The chart of accounts includes all of them. Income and expense accounts represent money coming into and out of a business. Asset and liability accounts represent money that is contained in the business or owed by the business.

Advertising revenue that you receive from Google Adsense would be an income account. The salary expense of a developer you hire would be an expense account. Your cash in your bank account would be an asset account. The money you owe on your company credit card would be called "accounts payable" and would be a liability.

When you initially set up your chart of accounts, the balance in each and every account is zero. As you start entering financial transactions in your accounting software, the balances of the accounts goes up or possibly down. 

The concept of double entry accounting is important to understand. Each financial transaction has two sides to it and you need both of them to record the transaction. Let's go back to that Adsense revenue example. You receive a check in the mail from Google. You deposit the check at the bank. The accounting double entry is you record an increase in the cash asset account on the balance sheet and a corresponding equal increase in the advertising revenue account. When you pay the credit card bill, you would record a decrease in the cash asset account on the balance sheet and a decrease in the "accounts payable" account on the balance sheet.

These accounting entries can get very complicated with many accounts involved in a single recorded transaction, but no matter how complicated the entries get the two sides of the financial transaction always have to add up to the same amount. The entry must balance out. That is the science of accounting.

Since the objective of MBA Mondays is not to turn you all into accountants, I'll stop there, but I hope everyone understands what a chart of accounts and an accounting entry is now.

Once you have a chart of accounts and have recorded financial transactions in it, you can produce reports. These reports are simply the balances in various accounts or alternatively the changes in the balances over a period of time.

The next three posts are going to be about the three most common reports; 

  • the profit and loss statement which is a report of the changes in the income and expense accounts over a certain period of time (month and year being the most common)
  • the balance sheet which is a report of the balances all all asset and liability accounts at a certain point in time
  • the cash flow statement which is report of the changes in all of the accounts (income/expense and asset/liability) in order to determine how much cash the business is producing or consuming over a certain period of time (month and year being the most common)

If you have a company, you must have financial records for it. And they must be accurate and up to date. I do not recommend doing this yourself. I recommend hiring a part-time bookkeeper to maintain your financial records at the start. A good one will save you all sorts of headaches. As your company grows, eventually you will need a full time accounting person, then several, and at some point your finance organization could be quite large.

There is always a temptation to skimp on this part of the business. It's not a core part of most businesses and is often not valued by tech entrepreneurs. But please don't skimp on this. Do it right and well. And hire good people to do the accounting work for your company. It will pay huge dividends in the long run.

#MBA Mondays