Xero Analysis - 2 year review

Despite Xero’s relatively high profile and the recent media coverage of the capital raising and financial results there has been little or no analysis of the implications for investors of the capital raising and latest financial results. This post considers the implications of the recent capital raising, the number of customers Xero requires to reach break even and deliver the required rate of return to investors.

Summary of Analysis

Xero has now raised over $45 million in equity (a great effort for a NZ startup) and burned through approximately $15 million cash developing their product and securing 7,500 paying customers. Xero has not yet reached break even but the recent $29 million capital raising ensures that they can continue to grow and execute their strategy over the next 2-3 years. The $29 million capital raising has diluted ownership of non-participating shareholders by ~35%. This reduced ownership has been offset by the certainty provided by additional capital, the addition of strategic investor Craig Winkler to the board and the potential to enter the US market.

Xero have not yet reached break even. Based on the current average revenue per user (ARPU) and estimated annual expenses of $11 million Xero would need ~28,000 customers to break even. At the current growth rate (250 customers per week) Xero could reach break even by the end of November 2010.

Any estimate of the number of customers Xero require to justify their valuation is very subjective. I have created a workbook that estimates the number required based on the purchase price, investment horizon, required rate of return, ARPU, EBITDA margin and EV/EBITDA multiple. Based on some high level assumptions Xero need approximately 110,000 customers in 5 years to justify the $0.90 share price in the recent capital raising. This is a personal view and I recommend that you read through the assumptions I have made and try out some of your own.

Clearly the market opportunity exists but these numbers highlight that despite their achievements to date Xero are still in the early stages of their journey.

Background

Just over two years ago online accounting software provider Xero raised $15 million via an IPO on the NZX. The decision to list a company on the NZX with a limited product offering, a handful of customers and no revenue was a bold alternative to the traditional venture capital path. The high profile approach adopted by Xero and the disclosure requirements of being a listed company allows extended analysis of the performance of a technology startup.

Since listing in mid 2007 Xero have enjoyed considerable success. During this period they have grown to 7,500 cutomers (including 1,500 in the 6 weeks to 10 May 2009) across 25 countires. The company’s performance has been recognised by countless awards. Recently investors endorsed the performance to date and potential of Xero with a $29 million capital raising. This $29 million included an $18 million investment from MYOB founder and former majority shareholder Craig Winkler.The one area of potential concern for investors over the past two years is the decline in the ARPU. In their prospectus Xero estimated an ARPU of $75 per month. Shortly after listing Xero reduced the price of their NZ offering to $50 per month. Xero have further reduced their average price as they have entered new markets and announced an ARPU of $33 per month in their latest financial result. This reduced ARPU has facilitated Xero’s growth but has also significantly increased the number of customers required to break even and deliver the required rate of return to investors.

Xero’s $29 million Capital Raising

In April 2009 Xero announced a strategic placement that would raise over $23 million. This placement involved MYOB founder and former major shareholder Craig Winkler (and associates) subscribing to $18 million of new Xero shares. A capital raising of this size by an early stage NZ company is a great result in the best of times and is outstanding in the current environment. The announcement of Xero’s strategic placement was followed by the announcement of a share purchase plan (SPP) that allowed shareholders to purchase up to 5,000 shares at $0.90 each. Approximately 70% of shareholders participated in the SPP raising a further $5.8 million.

Why does Xero need to raise more money now?

Xero is a growing company that is investing in product development, marketing and sales and has yet to reach profitability.

Based on Xero’s cash position at 31 March 2009 ($3.81 million) and an operating deficit exceeding $600k per month (based on $7.2 million in the year ended 31 March) they would otherwise be running low on cash by late 2009.

What will Xero use the cash for?

As outlined in the Independent Adviser’s Report provided by Deloittes, plans include:

  • Entering the US market
  • Marketing partnerships in the UK and Australia
  • Additional staff based in NZ and overseas - sales, marketing, customer service, development, support and training
  • Setting up a physical presence in Australia
  • Ongoing product development including market specific features/functionality
  • Scaling of back office operations to accommodate growth

The largest individual component of Xero’s cash burn is employee expenses, totaling $4.6 million in the last financial year (during this time staff numbers have increased from 44 to 55). Following the placement Xero announced they hope to recruit an additional 36 staff, which would increase total staff numbers to 91.  At an estimated average cost of $90k per employee (based on $4.6 million in the last financial year and assuming constant staff growth) the 36 additional staff adds $3.25 million to Xero’s annual expenses taking employee expenses to an estimated $8.2 million per year.

It is difficult to quantify the cost of expansion into new markets and building partnerships without more data, and the company has provided no guidance, but it’s possible that Xero’s annual operating expenses (before depreciation and amortisation and excluding capitalised costs) could exceed $11 million this financial year.

What are the implications for existing shareholders?

The $29 million placement/SPP provides certainty for existing shareholders (and customers) that Xero will have sufficient cash to continue to execute their strategy for the next two to three years. The placement/SPP involves issuing 32 million new shares at $0.90, so will dilute the ownership stake of existing shareholders.

For example, a shareholder who purchased 10,000 shares in the 2007 IPO held 0.018% of the company after the IPO. This shareholder would now own 0.012% of the shares if they did not participate in the SPP and 0.017% if they purchased 5,000 shares in the SPP.  The ownership percentage of shareholders who did not participate in the SPP would have decreased by approximately 35%.

It’s important to note that the reduced ownership percentage does not translate directly into a dilution of value. Although less than the $1.00 IPO price the $0.90 placement price is consistent with the share price prior to the announcement of the placement. The view here should be that existing shareholders now own a smaller slice of a larger pie. This view is supported by the significant increase in the Xero share price following the announcement of the placement. Sources of this increased value include the certainty provided by the additional capital, the potential of the US market and the strategic input of MYOB founder and new board member Craig Winkler.

Breakeven Analysis

A key milestone for any startup is reaching break even. There is no problem with operating at a loss when creating value by investing in product development and building a presence in key markets. The key metric in Xero’s break even analysis is the ARPU. Based on the ARPU of $33 per month implied in the 2009 financial year results and estimated operating expenses of $11 million Xero would require ~28,000 customers to break even (at the EBITDA line). This figure is consistent with the 15,000 to 30,000 range suggested by CEO Rod Drury. Based on the average growth rate of 250 per week (based on the 6 weeks to 10 May 2009), an ARPU of $33 per month, $11million annual expenses Xero would reach breakeven (at the EBITDA line) by the end of November 2010. If Xero’s growth rate continues to increase this date will come forward. Any increase in expenses (over the $11 million assumption) or decline in APRU will push this date back.

Xero have often cited the potential to sell additional products to customers to increase the ARPU. Any additional product offerings will require an investment in development and ongoing support. As an example a $5 per month product adopted by 10% of Xero’s customers would add $0.50 to the ARPU. There would need to be significant investment in value added products and high adoption rates to lift the current ARPU to $50 before getting close to the $75 quoted in the prospectus.A key driver of Xero’s growth over the last 6 months has been expansion into the UK market (representing 2,000 of Xero’s 6,000 customers at 31 March 2009). This expansion into the UK has coincided with the decline in the ARPU from $54 per month to $33 per month. If the expansion into the UK has been at an ARPU below Xero’s average there is the potential for the ARPU to drop below $33 per month given the UK is currently Xero’s largest market. A lower ARPU would increase the number of customers required to break even and deliver the required return investors. At an ARPU of $30 per month the estimated break even point increases to approximately 30,500 customers.

Valuation and Customer Number Analysis

The $15 million IPO provided the capital required to start building a global offering, which has consistently been the stated aim. The $55 million post money valuation committed Xero to building a significant business to justify the valuation and produce the required rate of return for what was effectively a venture capital investment. Having raised $15 million at $55 million adopting a boot strapping approach based on re-investing retained earnings was not going to be sufficient. The recent capital raising could be interpreted as a double down by Xero (Xero and Craig Winkler clearly think they have a winning hand). Xero intend to increase investment in product development and to enter new and massive international markets. I am not criticizing the approach adopted, but simply highlighting that they have consistently pursued a higher risk and higher reward strategy. The higher risk relates to the amount of capital raised (now over $45 million) and the fact that they have burned nearly $15 million and have yet to break even. The higher potential reward is reflected by the size of the UK and US markets and earning potential of the subscription revenue model.

How many customers do they need to acquire to justify their current valuation?

I have updated the workbook I created approximately 18 months ago. This updated analysis is my personal view. This analysis considers the purchase price, investment horizon, APRU, EBITDA margin, required rate of return and future valuation metrics when estimating the number of customers Xero require. These inputs are uncertain, subjective and will vary depending on the individual. Because of these factors I encourage readers to download the workbook and play with the assumptions.

Assumptions

Investment Horizon: 5 years
Despite the recent share price activity Xero should be viewed as a long-term investment.

ARPU: $35
Based on the current ARPU and expected price pressure entering new markets with significant competition. This is slightly higher than the current ARPU reflecting the potential for additional revenue streams to be developed.

EBITDA Margin: 35%
Based on my previous analysis of SaaS companies.

EV/EBITDA Multiple: 12

Purchase Price: $0.90 and $1.45
I have applied my analysis to both the $0.90 strategic placement/SPP price and the closing price on Friday 22 May of $1.45.

Required Rate of Return: 20% per annum and 5x return on investment (~38% per annum)
These are subjective assumptions and will vary depending on the individual. I have applied a 20% per annum required rate of return reflecting a high risk listed equity investment. Over a five year horizon 20% per annum return equates to a 2.5x return on investment. The 5x return on investment (38% per annum) reflects the minimum rate of return expected from a later stage venture capital fund investing in a company in Xero’s position.

Estimated number of customers required by Xero in five years time:

20% p.a. Return on Investment 5x Return on Investment
Purchase Price: $0.90 110,000 225,000
Purchase Price: $1.45 180,000 360,000

The outputs highlight the wide range of potential outcomes and the sensitivity to key assumptions. This set of customer numbers are significantly higher than 36,000 figure estimated in late 2007. The key drivers of the increase is the lower ARPU and the shareholder ownership dilution resulting from the additional capital raised.

It is important to remember this analysis assumes a 5 year investment horizon and Xero would not need to hit these targets by Christmas.

Are these target customer numbers realistic/achievable?

To put these customer numbers into perspective they represent 1% to 3% of the addressable  Australian, New Zealand, UK and US market (Intuit estimate that 60% of US SMEs don’t use accounting software). These required customer numbers illustrate why Xero is expanding into the larger UK and US markets.

Small and medium sized business numbers

Market Market Size Addressable Market
New Zealand 322,000 128,800
Australia 1,200,000 480,000
United Kingdom 4,300,000 1,720,000
United States 26,000,000 10,400,000
Total 31,822,000 12,728,800

Source: New Zealand, Australian and UK figures from the Xero Prospectus. The US figure and 40% addressable market assumption are from the Intuit Annual Report 2006.

Xero’s ability to achieve these numbers won’t be constrained by the number of potential customers available. The challenge Xero face is managing the upfront investment and ongoing costs involved building  and maintaining the relationships/networks to acquire these customers. I think the 110,000 customers in 5 years is realistic and achievable. Growing at their current rate (250 customers per week) would result in 72,500 customers in 5 years. I don’t think I would invest at $1.45 if I required a 5x return on investment. I think the 360,000 target (70,000 customers per year) is unrealistic with Xero’s current sales and marketing infrastructure and they don’t have the capital required to fund this level growth.
Clearly the market opportunity exists but these numbers highlight that despite their achievements to date Xero are still in the early stages of their journey.
Please play with the assumptions in the interactive workbook.

Disclosure: None

Disclaimer: This post is not intended to be investment advice. This is a high level framework populated with personal and subjective assumptions. Please don’t make investment decisions based on my conclusion or outputs of my high level workbook.

MLB Season Starts - Go Bombers!!

The 2009 Major League Baseball season starts tomorrow NZ/Aus time with the 2008 World Series winners Philadelphia hosting Atlanta. Although MLB enjoys a relatively small following in Australasia, I developed an interest during my university days watching Sammy Sosa and Mark McGuire’s home run record chase in 1998 when I should have been at class. With my San Francisco Giants only rated a 1.2% chance of winning the World Series my focus will be on managing the Brisbane Bombers in the Kiwi League Baseball fantasy league.

The Brisbane Bombers will be heavily relying on 2008 NL MVP Albert Pujols if they are to have any chance of reaching the playoffs.

The TAB odds provide an implied probability of winning the World Series but with an expected return of 72 cents on the dollar it is far from a fair game.

World Series Winner Odds (NZ TAB 5 April 2009)

Team

TAB Odds

Implied probability of winning World Series

NY Yankees

6.50

11.1%

Boston Red Sox

8.00

9.0%

Chicago Cubs

9.00

8.0%

Los Angeles Angels

10.00

7.2%

New York Mets

10.00

7.2%

Philadelphia Phillies

15.00

4.8%

Los Angeles Dodgers

15.00

4.8%

Tampa Bay Rays

15.00

4.8%

Cleveland Indians

20.00

3.6%

Detroit Tigers

20.00

3.6%

St Louis Cardinals

20.00

3.6%

Arizona Diamondbacks

20.00

3.6%

Chicago White Sox

25.00

2.9%

Minnesota Twins

25.00

2.9%

Houston Astros

30.00

2.4%

Toronto Blue Jays

30.00

2.4%

Atlanta Braves

30.00

2.4%

Florida Marlins

30.00

2.4%

Milwaukee Brewers

40.00

1.8%

Oakland Athletics

40.00

1.8%

Colorado Rockies

40.00

1.8%

Texas Rangers

50.00

1.4%

San Francisco Giants

60.00

1.2%

Cincinnati Reds

60.00

1.2%

San Diego Padres

80.00

0.9%

Seattle Mariners

100.00

0.7%

Washington Nationals

125.00

0.6%

Kansas City Royals

150.00

0.5%

Baltimore Orioles

150.00

0.5%

Pittsburgh Pirates

150.00

0.5%

Note:

There have been a number of high profile gambling scandals in baseball that form part of the game’s rich history.

Quote of the day

Essentially, all models are wrong, but some are useful. George E. P. Box

As somebody who spends a significant amount of time at work building and maintaining models I think it is important I remember this myself and remind stakeholders of the limitations and context of the model outputs.

Xero to Double Customer Numbers in Six Months

Today online accounting provider Xero announced they have added 1,000 customers over the last 50 days to take customer numbers to over 4,000. At this rate Xero are on track to double the 2,200 customers they had at 30 September 2008 by the end of their financial year (31 March 2009). The highlight of the announcement for me was the reporting of 1,000+ UK customers.

[Update: Xero have blown out my 4,000 figure announcing over 6,000 paying customers at 31 March 2009]

While impressive this is the growth rate required if Xero are to meet their target for the NZ market of 8,000 customers and break-even by May 2010. Xero still have some work to do to reach the estimated 12,000+ customers required to break-even. The estimated $2.6 million annualised revenue of their 4,000 customers (estimated revenue per customer $54 per month) will push back any possible requirement to raise additional capital. Current shareholders and potential investors will be looking forward to the release of the annual result later this year for an insight into revenue per customer, expenditure and balance sheet information.

Xero’s shares remain thinly traded (154,000 shares or $126,000 traded this year) with the share price of $0.75 representing a market capitalisation of $42 million. As I have stated previously Xero should be seen as a longer term investment (3 years +). Although the results to date have addressed some of the risks/uncertainties identified at the time of listing it is still early days for a company that aspires to be a global force in online accounting.

Conclusion

Great execution and result for the Xero team. This performance needs to be built on to meet projections, get to break-even and deliver the required return for investors.

Click here for a free trial of the “World’s easiest accounting system”

Disclosure: None

Pick Me Video

From the billion dollar fantasy sports industry

What is 57,683 squared?

Mathemagician Arthur Benjamin performs his lightening calculations at TED in 2005.

Working as a casino dealer I was occasionally required to perform detailed multiplication and addition operations in my head when calculating payouts (e.g. 9 x 17 + 13 x 35 + 7 x 11 …) but the magnitude of these calculations and the time taken is unbelievable.

7 Years Hard Work = Overnight Success

As Rowan has highlighted an overnight success typically requires a long night. Jeremy Liew at Light Speed Venture Partners illustrates this with the chart below based on a Dow Jones Venture One/E&Y Study.

Time from Initial Equity Funding to Acquisition

Time from Initial Equity Funding to Acquisition

This is a great chart for potential entrepreneurs and and investors. If you are interested in venture capital and particularly early stage gaming/app metrics Jeremy’s blog is a great resource.

General Motors (GM) Runway: 350 Days

General Motors (GM) have just released another awful quarterly result announcing a $2.5 billion loss on revenues of $37.9 billion (down $5.8 billion on Q3 2007). Over the last quarter GM burnt nearly $50 million cash per day. Based on a 30 September balance of $16.2 billion in cash, marketable securities and readily available assets GM has approximately 350 days of runway. This back of the envelope calculation is typically reserved for startups not a 100 year old company with a 1/4 million employees.

The current global economic situation will have a significant impact on GM but it is an accelerant rather than the cause of GM’s current woes.

Despite growing revenues GM has lost market share to competitors such as Toyota.

Source: Reuters

Source: Reuters

GM and the US auto industry in general have failed to address the key issues (labour costs, product development and supply chain management) they are facing.

Source: Reuters

Source: Reuters

Resulting in the destruction of shareholder value:

Clusterstock provides a summary of GM’s CEO Rick Wagoner’s performance at the helm including losing $67 billion over 8 years.

GM are in the process of implementing a series of actions to improve their liquidity position by $20 billion by the end of 2009. Despite these steps there are calls for the US Government to step in and ensure GM does not have to file for bankruptcy. Based on the recent bailout of the financial sector, potential job losses and historic actions in the automotive industry it is unlikely GM will be allowed to fail without some type of intervention.

The issues faced by GM are not going to be solved by an injection of capital or tax payer gauranteed loans. Given the track record of the board and management team any bailout will only delay the inevitable bankruptcy, sell off or merger of the US’s largest auto company.

Xero - 2,200 customers, $1.4 million annualised revenue

New Zealand based online accounting software provider Xero has announced 2,200 customers at 30 September 2008. Assuming average revenue per customer of $54 this equates to annualised customer revenues of $1.4 million.

Xero is a ~2 year old software startup that bypassed the traditional venture capital funding path and raised $15 million in an IPO on the New Zealand Stock Exchange (NZX) in June last year. The disclosure requirements of being a listed company and Xero’s open approach to communications have provided an interesting insight into the mechanics of a startup.

Mainstream media have focused again on accounting profit numbers and meaningless % growth rates. Despite their relatively high media profile and listed status Xero is a startup company. When assessing the status of early stage companies the key metrics are customer/revenue growth (gross not just percentage), cash burn and cash position/runway.

Customer/Revenue Growth

In their prospectus Xero forecast 1,300 customers by 11 May 2008 and profitability within 3 years based on break-even at 8,000 customers. Xero achieved there first milestone with 1,406 customers in May this year and have continued their strong growth. Since listing Xero have revised their pricing structure ($75 per month reduced to $50 per month) increasing the number of customers required to break-even.

It is difficult to accurately predict Xero’s growth profile (but it will probably fit a S-curve). Given this uncertainty it is important to follow Xero’s information releases on customer numbers and understand the revenue implications. Based on the $54 average revenue per customer assumption each customer represents $650 revenue per annum. The focus over the next 12 months should be on whether New Zealand growth continues to accelerate and if Xero can gain traction in Australia and the UK.

Cash Burn

Monitoring cash burn is crucial for any company that has yet to reach profitability. It is perfectly acceptable for high growth companies to burn cash. Understanding the cash burn provides an insight into the breakeven point of the company and the potential future profitability. In the six months to 30 September Xero had operating expenses of $3.85 million ($7.7 million annualised). Based on an average revenue per customer of $54 per month Xero will need 12,000+ customers to break even (at the EBITDA line). This break even calculation is subject to the accounting treatment of development costs and does not include the $673k that Xero capitalised in the six months to 30 September. In the six months to 30 September Xero’s net cash position decreased $3.25 million.

Cash Position/Runway

Given that Xero has not yet reached profitability it is important to understand their cash position. At 30 September Xero had cash and cash equivalents of $6.3 million. Based on the current cash burn and annual revenues of $1.4 million (and growing) Xero appears to have sufficient funding to operate for the next 12 months (assuming no extraordinary increases in expenses). Looking beyond 12 months will depend on the level of customer growth and costs associated with expanding into new markets. There is a real possibility that Xero will need to raise additional capital in the next 2 years. This is a common practice for growing companies and to be expected for early stage enterprises.

Xero have achieved all of their stated targets since listing and have a growing base of paying customers. Over the next 12 months it will be interesting to observe how the ground work they have put in developing partnerships will translate into scalable customer growth. It will also be interesting to see how this model can be replicated in the larger Australian and UK markets.

Click here for a free trial of the “World’s easiest accounting system”

Previous commentary on Xero on Valuecruncher

Disclosure: None

Six Rules for Effective Forecasting

The Harvard Business Review (HBR) IdeaCast has an excellent interview with Silicon Valley forecaster Paul Saffo as a follow up to HBR article Six Rules for Effective Forecasting (premium content).

Paul Saffo’s Six Rules for Effective Forecasting

  1. Define a cone of uncertainty - Visualise the uncertainty and try to encompass all reasonable possibilities
  2. Look for the S curve - Everything interesting behaves like an S-Curve e.g. Moore’s law
  3. Embrace the things that don’t fit - These anomalies/discrepancies maybe subtle indicators of future changes.
  4. Hold strong opinions weakly - Draw quick conclusions and  then systematically dismantle them. Forecasting proceeds as a sequence of failed forecasts, be your own worst critic.
  5. Look back twice as far as you look forward - Identify patterns, history does not repeat but it may rhyme.
  6. Know when not to make a forecast - There are situations where the level of uncertainty precludes the ability to make any sort of meaningful forecast.

Saffo illustrates these rules with examples from technology including forecasting the emergence of the iPhone and global events such as the fall of the Berlin Wall.

Additional important points Saffo raises include:

  • Differentiating between effective and accurate forecasting
  • Embracing uncertainty
  • Use the past as illumination not support
  • Don’t cherry pick history to support your conclusions
  • “Never mistake a clear view for a short distance” new technology will take time to become an overnight success

Two rules that I think are important for forecasters are:

Check your ego at the door

As a forecaster you will be wrong more often than you are correct. It is important to acknowledge and learn from your mistakes rather than denying them or trying to explain mistakes away.

Transparency

Utilise a transparent framework and engage stakeholders. Transparency will allow you to learn from your forecasts and allow stakeholders to understand the context and limitations of the forecast.

The podcast is definitely worth listening to if you are interested in forecasting.