The Right Way To Do Revenue Forecasting

team-startuped
TEAM STARTUPED 12 Jan 2022 . 4 min read
Rectangle

    Forecasting business revenue and expenses during the startup stage is really more art than science. Many entrepreneurs complain that building forecasts with any degree of accuracy takes a lot of time--time that could be spent selling rather than planning. But few investors will put money in your business if you're unable to provide a set of thoughtful forecasts. More important, proper financial forecasts will help you develop operational and staffing plans that will help make your business a success. Here's some detail on how to go about building financial forecasts when you're just getting your business off the ground and don't have the luxury of experience. When you're in the startup stage, it's much easier to forecast expenses than revenues. So start with estimates for the most common categories of expenses as follows:

    • Fixed Costs/Overhead
    • Rent
    • Utility bills
    • Phone bills/communication costs
    • Accounting/bookkeeping
    • Legal/insurance/licensing fees
    • Postage
    • Technology
    • Advertising & marketing
    • Salaries
    • Variable Costs
    • Cost of Goods Sold
    • Materials and supplies
    • Packaging
    • Direct Labor Costs
    • Customer service
    • Direct sales
    • Direct marketing

    Here are some rules of thumb you should follow when forecasting expenses

    1. Double your estimates for advertising and marketing costs since they always escalate beyond expectations.
    2. Triple your estimates for legal, insurance, and licensing fees since they're very hard to predict without experience and almost always exceed expectations.
    3. Keep track of direct sales and customer service time as a direct labor expense even if you're doing these activities yourself during the startup stage because you'll want to forecast this expense when you have more clients.
    4. Forecast revenues using both a conservative case and an aggressive case
    If you're like most entrepreneurs, you'll constantly fluctuate between conservative reality and an aggressive dream state which keeps you motivated and helps you inspire others. Rather than ignoring the audacious optimism and creating forecasts based purely on conservative thinking, you embrace your dreams and build at least one set of projections with aggressive assumptions. You won't become big unless you think big! By building two sets of revenue projections (one aggressive, one conservative), you'll force yourself to make conservative assumptions and then relax some of these assumptions for your aggressive case.

    For example, your conservative revenue projections might have the following assumptions

    1. Low price point
    2. Two marketing channels
    3. No sales staff
    4. One new product or service introduced each year for the first three years

    Your aggressive case might have the following assumptions:

    1. Low price point for the base product, higher price for a premium product
    2. Three to four marketing channels managed by you and a marketing manager (Read my column on paying employees during the startup stage to learn how you can afford a marketing manager.)
    3. Two salespeople paid on commission
    4. One new product or service introduced in the first year, five more products or services introduced for each segment of the market in years two and three
    By unleashing the power of thinking big and creating a set of ambitious forecasts, you're more likely to generate the breakthrough ideas that will grow your business.
    • Check the key ratios to make sure your projections are sound
    After making aggressive revenue forecasts, it's easy to forget about expenses. Many entrepreneurs will optimistically focus on reaching revenue goals and assume the expenses can be adjusted to accommodate reality if revenue doesn't materialize. The power of positive thinking might help you grow sales, but it's not enough to pay your bills! The best way to reconcile revenue and expense projections is by a series of reality checks for key ratios. Here are a few ratios that should help guide your thinking:
    • Gross margin
    What's the ratio of total direct costs to total revenue during a given quarter or given a year? This is one of the areas in which aggressive assumptions typically become too unrealistic. Beware of assumptions that make your gross margin increase from 10 to 50 percent. If customer service and direct sales expenses are high now, they'll likely be high in the future.
    • Operating profit margin
    What's the ratio of total operating costs--direct costs and overhead, excluding financing costs--to total revenue during a given quarter or given year? You should expect a positive movement with this ratio. As revenues grow, overhead costs should represent a small proportion of total costs and your operating profit margin should improve. The mistake that many entrepreneurs make is they forecast this break-even point too early and assume they won't need much financing to reach this point.
    • Total headcount per client
    If you're a one-man-army entrepreneur who plans to grow the business on your own, pay special attention to this ratio. Divide the number of employees at your company--just one if you're a jack-of-all-trades--by the total number of clients you have. Ask yourself if you'll want to be managing that many accounts in five years when the business has grown. If not, you'll need to revisit your assumptions about revenue or payroll expenses or both. Building an accurate set of growth projections for your startup will take time. When I first started my company, I avoided building a detailed set of projections because I knew the business model would evolve and change. But I regret not spending more time on business planning since I would have avoided several expenses along the way. The company's board of directors now requires me to prepare quarterly updates to our financial projections. Now when I lapse into fits of audacious optimism, the projections force me to forecast what these dreams mean for the company's bottom line.

    Team StartupEd

    The team @StartupEd is laser focused at creating high quality learning content for young student entrepreneurs who wish to learn about startups and entrepreneurship and are willing to pursue these subjects academically. Feel free to email us at content@startuped.net if you want to recommend or submit any content to us. Hope you like our work!

    Learn what StartupEd has to Offer!

    Get started easily with StartupEd through our free training & support.

    An error has occurred. This application may no longer respond until reloaded. An unhandled exception has occurred. See browser dev tools for details. Reload 🗙