A number of years back, I was approached by a company in that needed some help finding a strategic partner. The company, based in Asia, was doing pretty well. They had some partnerships with some top brands, a solid customer list, and revenues were growing nicely. What they needed was a US-based strategic partner with money to invest and the ability to push their products into that market.
Within a few months, I found them such a partner, based in the US, and worked with the company's bankers to create a good deal for the Asian firm. The term sheet we negotiated achieved the company's goals, and once we had it signed, we flew back home, ready to start preparing the due diligence package. And that's when the fun started.
The first thing we discovered, upon opening up the accounts for analysis, was a hole in the balance sheet. The "sweat equity", the unpaid work done by the company's founders since the company's inception, had not been reflected in the "Accrued Salary and Expenses" line in the Liabilities section of the Balance Sheet, or anywhere else.
Most of the company's senior management team had been working on half salary (and sometimes less) for years, since the company's formation. And, though the team had already been allocated some common stock based on their cash contributions upon founding the company, this oversight meant the team was in danger of losing significant additional value in the upcoming negotiation.
The second thing we discovered was that the company's financials had been quite literally "prepared by hand" - the person creating the spreadsheets - a much older gentleman - had literally entered every sales and vendor invoice and cost item manually and hand-calculated every output in Excel over the past two years.
Pre-trip, we had assumed he had used Excel's "Paste Special" function to remove the formulas (more proof of why assumption can be the mother of all screw-ups). He hadn't. When we showed him the "Sum All" function, he was amazed.
The third thing we discovered was that the sales projections for the next three years had been prepared the same way - using pencil and paper. There was no easy way to adjust for the probability of a bad quarter (or a great quarter), and no way to adjust any of the expenses short of re-calculating the entire spreadsheet. Adding a new opportunity involved a complete re-calculation of every worksheet. There was no tie-in with the Cost of Goods Sold worksheet, other than another hand-calculation.
With three days before the team arrived from the US, there was only one way to tackle these issues - fire the accountant, create an accurate Profit and Loss statement, including a set of historical accounts and projections, using the existing accounts and sales data, and create a revised Balance Sheet that accurately reflected the salary accrual strategy that management had been following.
We knew we'd have some explaining to do re the revised balance sheet, but we were comfortable the investor would understand our reasoning there. The revised Profit and Loss statements, Cash Flow, and Projections were our larger concerns, and needed to be addressed before their arrival, so due diligence could be completed to their satisfaction, and the funding closed.
For the accounting requirements, rather than stay with Excel, we chose to go with QuickBooks - an excellent and proven accounting system for companies fo small to medium size. For future projections, we used one of my financial models (a precursor to the models available for download on this site).
The evening before our guests arrived, thanks to these two sets of tools, four very tired entrepreneurs, and two tired consultants, we had every sales invoice loaded, every expense in place, and everything else dollar-perfect and ready for their analysis.
The good news? Despite the pencil and paper approach, the accounts turned out to be perfect with respect to the historical inputs, and the projections sheet was such a hit, the investors asked if they could share it with their financial group back at HQ. The even better news? Three weeks later, the deal - a US$10 million first-round funding - closed, at the full value agreed in the term sheet.
1. Be prepared. Had we not undertaken to revise the accounts of this company to be in line with international (GAAP) standards, there is a risk the investor may have looked at the accounts and made an adverse judgement about the quality of the company, based on the quality of the information being presented - which might have endangered the funding
2. Don't assume - know. Never assume that a spreadsheet was created by someone who knows what they're doing - they may have been created by hand-copying in numbers from a circa-1972 Casio calculator (!) - check every cell, every formula, and step back and look at the big picture - don't assume anything - ask to see the assumptions beneath every projection
3. Account for all possible options. Don't create projections that can't be dynamically adjusted to account for all possible events - positive or negative - a non-dynamic set of projections that fails to articulate a multitude of possible strategic options can sometimes signify a management team bent on executing a single strategy, come Hell or high water - Hell and high water can be avoided by articulating different sales and operating strategies in a dynamic financial plan - and when it comes to financing, though many VCs will use their own tools to conduct analysis during due diligence, having a dynamic approach to execution may shorten the time needed for due diligence
4. Include your founder value at full weight. Entrepreneurs, if you can only be bothered to learn a handful of accounting principles, learn this one: learn how to accrue your salary to the Balance Sheet, so you can be repaid what is owed later or have something of value you can convert into equity at the right time. Acknowledge the fact that you're working for half-salary (or less) using your accounts - - if you don't do this, you risk losing the value of your contribition*
*The importance of accruing salary pre-funding is especially true if there is any risk of losing control of your company, or its accounts (i.e., if you're re-assigned to Special Projects, fired, or otherwise leave the business before this value can be realized). Should that happen, the best defense you have against ending up with nothing to show for your efforts is an audited set of accounts - a set that includes your founder contribution at full value.
John is a serial entrepreneur and investor, and the co-founding Partner of Hatcher+, a data-driven, globally-focused venture investment platform based in Singapore. In addition to leading capital raising and deal syndication, he is the visionary and architect behind the Hatcher Stack, the company's proprietary research and technology platform. Over the past five years, John has led numerous venture investments in early-stage companies, including ASYX, DocDoc, Dropsuite, Heardable, Invit, Inzen Studio, SocialCops, ThoughtRiver, and Telr - and syndicated over US$100Mn of additional debt and equity co-investment. IPOs and trade sales in which he was acted for the majority shareholder include Dropsuite (ASX:DSE) and Inzen Studio (ASX:ICI). His M&A work includes the merger of payment leader Telr with Dubai-based Innovate Payments, and the merger of Singapore-based companies DocDoc, and DoctorPage. Prior to co-founding Hatcher, John founded cybersecurity technology leader Authentium (acquired by CYREN in 2010), and acted as a director for global payments aggregator Mozido, and an advisor to Africa-based Gateway Communications, satellite technology developer MDS America, Kuwait-based Internet marketplace Sheeel.com, and Orion Partners, a $2B private equity fund manager based in Hong Kong.
The Best Investor Deck Ever|
The Most Unrewarding, Misunderstood, Underrated Job on the Planet|
The First 100 Are Funded!|
Venture Capital Simplified - The Rule of 5X|
The AI-Powered, Highly-Automated, Global-Diversified, Exchange-Tradable VC|
|John Sharp (233)|
|Wissam Otaky (11)|
|Dan Hoogterp (4)|
|Manav Narang (1)|
|VC Impact Investing: A Primer|
|Looking for the Inflection Point – Tracking COVID-19|
|Keep Calm and Carry On Investing|
|Using AI to Match Investors and Entrepreneurs|
|50 Surprising Facts We Learned From Our First 100 Investments|
|The First 100 Are Funded!|
|The Power of Venture|
|US Immigrants Are Vital To VC Returns|
|Hatcher+ v2.0 Release|
|The Golden (Selection) Ratio|