Xero valued at NZ$5.1 billion: 3.1 million customers by 2020?

Xero is the standout company on the NZX and on any measure has been a huge success. Listing seven years ago with a handful of customers and a market capitalisation of $60m Xero has grown to 211,000 customers around the world (30 September 2013), 584 staff (30 September 2013) and a market capitalistion of NZ$5.1 billion (18 February 2014). The exciting thing about Xero is that late last year it raised NZ$180m to fund the ongoing push into the US market. Growing at ~80% p.a. and with NZ$221m in cash at 31 December 2013 Xero is in prime position to become the global leader in online accounting solutions for SMEs.

Xero Share Price CHT 20140219

 

From an execution point of view Xero have been exceptional and to date investors have been rewarded handsomely for their faith in the company. Xero’s current valuation is a reflection of performance to date and the company’s potential but at a market capitalistion of $5.1 billion. Xero is trading at an enterprise value of approximately 70x the forecast NZ$71m revenue for the 2014 financial year.

Given Xero’s cash reserves and momentum it seems like only a matter of time before they reach 1 million customers but how many customers are required to support the current NZ$5.1 billion valuation?

Continue reading

Posted in Business, New Zealand, SaaS, Stocks, valuation | Tagged , , , , | Leave a comment

Indicative Economics of Solar PV in New Zealand

Update: The previous analysis has been updated to reflect the variable component of the residential tariff and a correction to the levelised cost calculation

Rooftop solar PV won’t make sense for everyone but even without a Government subsidy it represents an opportunity for some households to hedge against increasing electricity costs.

High-level Assumptions (Further analysis and refinement required)

  • Real, pre-tax hurdle rate range of 7.5% – 12.5%;
  • Retail prices reflect the variable component (i.e. excluding the fixed daily charge) of the residential tariff for selected regions from the powerswitch.org website. Selected retail prices include the prompt payment and direct debit discounts;
  • The analysis does not differentiate between generation to meet household demand and excess generation exported to the grid i.e. no consideration of feed-in tariff impact on economics;
  • The analysis does not attempt to reconcile the solar resource and potential load factors with the residential electricity price in different distribution areas;
  • The analysis assumes a 1% p.a. degradation in solar PV system efficiency; and
  • The analysis does not include maintenance and cleaning costs or replacement of parts such as the inverter.

Rooftop Solar PV New Zealand - Indicative Economics - 20140218

Note: The levelised cost approach alone is not suitable for a final investment decision and amongst other criteria individuals should also evaluate the NPV of any solar PV investment under consideration

Posted in Electricity, New Zealand, Solar PV, Uncategorized | Tagged , , | Leave a comment

How much is GeoOp worth? Four ways to value an early stage company

GeoOp is an early stage New Zealand company that provides mobile workforce job management solutions. Late last year the company listed on the NZAX following a $10m capital raising via a private share offering. GeoOp had 5,300 customers at 31 December 2013 representing approximately $600,000 of annualised revenue. GeoOp is targeting 50,000 customers in the medium term with aspirations to grow significantly beyond that.

In the three months since listing the GeoOp share price has increased by 175% to $2.75 (31 January 2014) representing a market capitalisation of $75m. As illustrated by the chart below GeoOp’s share price has been extremely volatile and shares have traded as high as $3.64 ($99m market capitalisation). This level of volatility is common for thinly traded stocks like GeoOp.

GeoOp Share Price Image 20140202

 

Given the early stage (sub $1m revenues) of GeoOp and the volatility of its share price I thought it would be interesting to undertake a valuation of GeoOp.

Continue reading

Posted in Business, GeoOp, New Zealand, SaaS, Startup, valuation | 1 Comment

Why after losing to Nadal for the 23rd time Federer is still the greatest tennis player of the open era

Last week Roger Federer made the Australian Open semi-final for the 11th consecutive year and for the 34th time in a Grand Slam tournament before losing to Rafael Nadal. Friday’s semi final was the 23rd time Federer has lost to Nadal and the 9th time in a Grand Slam tournament. Both players are regarded as all time greats and their rivalry will go down as one of the most storied in sports history.

Federer is considered by many to be the greatest player of the open era but given the ongoing dominance of Nadal in their head to head encounters and Nadal’s broader success questions are being raised with regard to Federer’s legacy.

While Nadal may eventually become the open era’s greatest player, at this time, I believe Federer holds the mantle of all-time greatest based on the following criteria:

  1. Longevity
  2. Consistency
  3. Aggregate career statistics
  4. Domination of the game for an extended period

Continue reading

Posted in Sport | Tagged , , | Leave a comment

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.

Posted in Business, New Zealand, SaaS, Startup, Stocks, valuation | Tagged , | 9 Comments

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.

Posted in Sport | Tagged , , | Leave a comment

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.

Posted in Forecasting, Mathematics | Leave a comment

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

Posted in Business, New Zealand, SaaS, Stocks | Tagged , , , , | 5 Comments

Pick Me Video

From the billion dollar fantasy sports industry

Posted in Sport | Tagged | 1 Comment

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.

Posted in Mathematics | Tagged , | 1 Comment