The Monthly Projections — Critical Importance in setting up realistic monthly budgets


Growth Chart

In a previous blog where I describe how companies will live or die based on their spreadsheets, I talked about several examples that would raise the red flag to any investor. One flagrant example came to my attention recently not mentioned in that blog, yet equally important.  The startup company had put together several years of revenues and expenses.  During a presentation, the investor commented that he preferred to see the details to the projections shown earlier.

When I inquired the CEO for me to look at the spreadsheet that led to the annual projections, I discovered that the expenses were only tracked on a quarterly basis and the revenues were based on an annual basis. I then asked, where were the monthly numbers? – they did not exist!  His team decided to throw caution to the wind and only put together a sketchy balance sheet.

A month-to-month setup is critically important. Now whenever a professional investor makes a financial commitment to a company, they will monitor that company on a monthly basis to see the variances from the projections. With the monthly model, the investor can determine the capital needs per quarter or semi-annually.

Contrary to what many entrepreneurs believe, once an investor states in the term sheet that it will invest one million, as an example, it does not mean that the company will get its one million in one shot.  In fact, they dispense the cash in chunks and then see how that works.  Why?  If the company fails to deliver after several months whatever product or sales, the investor might reconsider walking away or undertake some additional actions. In some term sheets or investment documents, the entrepreneur’s equity percentage might even change as a penalty for not meeting the projections.

The monthly model represents to the investor whether that entrepreneur bothered to do a due diligence on setting up a budget.  At another company, I informed the entrepreneur what was the monthly budget for an office, for paying standard legal fees for various legal matters, and the monthly costs of an outside accountant?  Getting these figures right shows to any investor that the entrepreneur has some experience in running a business and/or made the effort to find out what it costs. Interestingly, that entrepreneur simply ignored putting that budget together. To me, that represents a blatant inability to run an enterprise.  No experienced investor would place capital at risks for such an entrepreneur.  Cash flow is the life blood of a company.  The month-to-month model reveals the pulse of that company.

Currently, I am working with a medical device development company.  Part of the analysis to get monthly figures is determining what are the incremental costs for embedded electronics?  I also asked questions from the engineer how long and how much for the development costs for a Beta.  How many units need to be manufactured to get a decent incremental cost. With this information, I can set up a decent budget on a monthly basis that includes the capital expenditure for the product, the number of months for development, the COGS of the product by units and in months. Then, it is a simple exercise to make a quarterly and an annual model.  With these details, I am prepared to answer any questions during due diligence regarding the pre-production costs for the product. The investor will now know where his investment is going for the first six months and how much of the total investment can be allocated over several quarters.

If an entrepreneur needs to gain the confidence from a potential investor, the best way to do so is setting up detailed financial models.  It demonstrates to the investor the entrepreneur’s knowledge and experience in the market sector.  Without such details, it is a very risky proposition to present a sketchy business model to any investor.

Advertisements

About Juan Ramón Zarco, SVVGP 胡安•雷蒙•扎尔科

Juan Ramon Zarco, 胡安•雷蒙•扎尔科, Silicon Valley Ventures Growth Partners llp, Hygieia Healthcare Technologies Company, AllRest Technologies LLC, Crimson Growth Partners LLP, jrzarco2001@yahoo.com, is an experienced as CxO, General Counsel and Secretary to public and private companies with global operations. Established track record of producing practical, revenue-focused solutions. As Counselor and Secretary, demonstrating vision, integrity, and sound business judgment, to CxOs. Managed complex, strategic transactions, M&A, contracts support, PE Financing, IPO, SEC compliance, Corporate/HR governance, IP licensing, Budgeting, Staff, outside counsel management, International market access strategies, Domestic & foreign government relations and advocacy. Creative in designing and implementing market access strategies. Practices law beyond conventional model with low-overhead and project-based fees. Effective at managing departments, formulating marketing strategies, balancing budgets, and implementing cost-saving measures. Extensive in-house and private practice experience, advising clients on commercial, corporate, international business, and technology law and policy. http://www.docstoc.com/video/89135472/make-your-business-an-international-presence; http://www.youtube.com/watch?v=fx5gijf3yoc For Sprint, he managed iDen international development in Southeast Asia, Middle East, and Africa, and contractual issues with Verizon. In Private Equity, he worked with Pegasus in vetting international investment deals and interim President for portfolio companies, such as Data Foundation, a data storage company, handling marketing, strategy, fund raising, and accounting. Before Pegasus, Mr. Zarco, as CLO and V.P. of Corporate Development, played a principal role in the structuring, international expansions for 2 telecom companies, U.S. Cable Group and Viatel, Inc. in financing and M&A deals exceeding $200 million. Mr. Zarco earned a J.D. from NYU Law School, M.B.A. from Cornell, and B.A. from Williams College; is fluent in Spanish, Portuguese, French, and German, with working knowledge of Russian, Arabic and Japanese.
This entry was posted in Capital and Management, Entrepreneurship, Management and Capital, Marketing, Presentations, ROI. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s