Question

Analyze and comment on the financial projections for start-up expenses and capital equipment.

Answer 1

REVENUE

Revenue will influence the rest of the profit and loss (P&L) assumptions. So if revenue estimates are materially misstated, the company risks overstaffing or understaffing and/or purchasing assets incorrectly. Revenue is also a key metric for potential investors. Estimates do not need to be precise, but they do need to be realistic and supported by a viable story.

Step 1: Collect critical inputs

Four crucial inputs are used to calculate revenue for a new business: revenue levers, revenue drivers, activity assumptions, and pricing.

Revenue levers: Revenue levers are the various opportunities to earn revenue. Levers can include products and/or services, software maintenance agreements, channel partner sales, etc. Start with a list of all the revenue levers that will produce income over the period of the financial projections.

Revenue drivers: Revenue drivers are the activities that influence how revenue levers produce income. Each revenue lever could potentially have a different driver. Think about what activity will increase or decrease revenue for each lever.

Revenue driver activity assumptions: Activity assumptions are the inputs that will indicate how the revenue driver will act. To determine assumptions, work with marketing, sales, or the CEO, depending on the company organization.

Pricing: Pricing is a necessary input to calculate total revenue. This article does not go into detail on pricing methodology. If prices have not yet been determined, read pricing guides and/or articles to ensure effective pricing methods are being implemented.

Step 2: Convert inputs into the revenue estimate

Now that the revenue inputs have been determined, it's as straightforward as inputting the data into a model that calculates total revenue. In its simplest form, the calculation is revenue driver assumption multiplied by price for each revenue lever. If the driver is marketing spend, there will be an additional step to convert dollars spent to revenue earned.

Create revenue calculations for three to five years by year, quarter, or month. A monthly calculation is helpful if your revenue driver is new clients, as clients will be attained throughout the year and will not provide a full year's revenue in year 1. The monthly or quarterly detail should be summarized by year to report the total annual impact.

Be sure to include an estimate for churn. Revenue can be easily overstated or understated without a reasonable estimate on the business that will be lost over the period of the pro forma.

Step 3: Review the final revenue outcome

Take a step back from the detail and reflect on the total revenue result.

On the SEC's website, check the public Forms 10K of competitors or companies in the same industry and compare net revenue. If there are no publicly listed companies to provide financial comparisons, perhaps check with the potential investment banker or capital provider. It may be able to provide a range of financials that are typical in a similar industry. If forecasted revenue in year 2 is higher than the industry leader, then review the calculations for accuracy and activity assumptions for reasonableness.

Consider the growth year over year. The business should show steady growth over the years at a realistic rate. Then calculate the compound annual growth rate (CAGR) to easily identify growth over a period of time. CAGR is an easy comparison tool for investors to use.

Revenue do's

• Use a range of activity assumptions to determine a worst-case scenario and an optimistic scenario. Determine what makes the most sense within this range.
• Build the revenue estimates using calculations of inputs so you can easily pivot and create new scenarios.
• Show revenue increasing over time at an attractive yet realistic rate.

Revenue don'ts

• Don't create revenue assumptions without having a calculation or story to support the total.
• Don't overcomplicate the calculations with additional details that do not materially change the result.
• Don't forget to reflect on the result.

COSTS OF SALES

Costs of sales (COS) are the costs directly related to a product or service, and they represent the cost of producing revenue. Product costs will include raw materials, labor, production equipment depreciation, etc. Service industry companies' COS include salaries of professional service providers; software-as-a-service companies' COS include hosting fees. Measuring the gross profit (revenue minus COS) and gross margin (gross profit as a percentage of revenue) assists in determining profitability and long-term viability.

Compare margins to industry benchmarks or similar companies. COS may be higher at the start, but it is important to show higher margins over time as efficiencies are gained.

SG&A EXPENSES

Selling, general, and administrative (SG&A) expenses include all other expenses outside of product costs and capital purchases. Consider the following major categories:

Salaries and benefits

Build a headcount plan by role for the pro forma period by month. This approach creates a hiring plan based on revenue timing to properly support the business. It also allows for quick adjustments when modeling revenue changes.

Sales staff hire dates should correspond with the sales cycle. If a full sales cycle is three months, then the headcount plan should include sales salaries at least three months before the first month of planned revenue. Ensure other variable sales expenses relate directly to the revenue estimates, including sales commissions, bonuses, and other selling expenses.

Include benefits and payroll taxes in addition to the base salary.

Marketing expenses

Business-to-business relationship building and business-to-consumer advertisement and promotions drive revenue. Marketing expenses as a percentage of revenue vary depending on the industry and the company's size, but they will typically fall somewhere between 5% and 20% of revenue. Years 1 and 2 require higher marketing spend as the company is promoting awareness; however, projections should show increased efficiencies over time.

Legal

Several one-time and recurring legal-related costs are associated with incorporating a new business. Consider the following to avoid expensive surprises:

• Negotiation of customer contracts.
• Business license fees.
• Industry-specific state licensing.
• Incorporation fees.
• Insurance.
• Other legal fees relating to copyrights and/or trademarks.

IT-related costs

Most new businesses require a website and have some technology needs, even if the industry is not technology specific. Technology ignorance is dangerous for any new business owner and can create unplanned expenses. Consider the following:

• Data storage.
• Help desk.
• Website hosting fees.
• Software and software maintenance.
• Data security efforts.

Other

Consider all other potential business expenses such as credit card fees, office rent, office supplies, etc. It is safe to create high-level estimates in this area based on revenue, location, industry, etc.

SG&A do's

• Stay familiar and current with technical terminology and cost structures to avoid expensive surprises.
• Ensure the staffing plan and marketing plan align with revenue assertions.
• Compare expenses as a percentage of revenue to industry averages and benchmarks.

SG&A don'ts

• Don't underestimate accounting and legal needs during inception.
• Don't forget business necessities like call centers and credit card fees.

CAPITAL INVESTMENTS

Estimate capital investment dollars needed by year and by category between hardware, software, equipment, inventory, etc. The capital plan should:

• Correspond with the revenue growth and demonstrate a return on assets.
• Show that the business can scale and that the capital investments can set the business up for continual growth.
• Create a purchasing plan for the business and describe to investors how funds will be allocated.

CASH FLOW

In the simplest form, cash flow equates to projected EBITDA (earnings before interest, taxes, depreciation, and amortization) less capital investments. There are many other balance sheet implications for cash flow (accounts receivable, payables, inventory, etc.). Depending on the industry and round of investing, that level of detail may be unnecessary. If the industry has an exceptionally long cash cycle or includes a large upfront inventory investment, then an annual cash implication estimate should be made on those pieces. Otherwise, EBITDA and capital investments will be sufficient for the seed round. After the seed round, working capital impact will be beneficial to get a full cash flow look.