Microsoft Azure Certification Training

Looking to the Future: 5 Steps to Better Financial Projections During Covid-19

By Kuran Malhotra

Shelves are empty. Hand sanitizer sold out. Cleaning supplies nowhere to be found. This was the scene across many American towns and cities at the beginning of March 2020. Almost overnight, a global pandemic turned the status quo on its head, and individuals and businesses were left scrambling to adapt and overcome the challenges they faced.

For some businesses, that was a loss in foot traffic or a change in consumer behavior. For others, it was a problem downstream in their supply chain, distribution network, or development pipeline, which reverberated back.

Every business is going through its own set of uncertainties in today’s environment, but those uncertainties provide the opportunity to reflect and to better understand the core of the business, its key profit drivers, and how those drivers can be used to create a path back to a new normal.

The importance of projections

As a small business owner, you got into business to make or sell the products and services you love to the customers you enjoy working with. Business financials are intimidating, and you don’t really see the need for them right now, so you’re happy to put them off for another day.

My business, a coffee company, was in a similar position. We had built some basic financial projections prior to the Covid-19 pandemic as we worked to expand our business and make decisions about where to allocate resources. Recently, though, we found a renewed need and importance for them. As the pandemic raged throughout D.C., our partners, landlords, and more looked to our projected financials not only as a measure of future success and profitability, but also as a measure of our confidence in the business, our team, and the future.

Especially now, as small businesses continue to face new challenges, landlords and banks will want to see updated financial projections before they evaluate your business for a deferral, refinance, or other type of relief. Grantors and government initiatives often look to P&L projections as a measure of how much the pandemic has harmed your business, and so the more accurate they are, the better they will serve you.

Beyond that, you can look at your business financials down the line to analyze key aspects of your business such as the unit economics. For us, that involved understanding how much it costs to produce a tin of coffee and what that cost depended on. From there, we calculated how much we were making per tin, and then how many tins needed to sell in order to cover our overhead.

While coffee tins may be a niche example, this general concept of unit economics really can apply to any business: what are you making, for how much, and how many do you need to sell to cover your costs?

1. Find a good starting point: Setting up the income statement

An income statement is the best place for a small business to start its projections. It’s really the heart of the business at the smaller stage, and will give you visibility into the metrics and drivers you may want to consider down the line. Once you have your income statement, you can use it to build out a balance sheet, and a statement of cash flow if you need to.

The best starting point for setting up your template income statement is a public company’s corporate filings. Public companies are required to file their income statements, balance sheets, and cash flow statements (amongst other things) every quarter, and by finding one or two in your industry, you can get a sense of what the business world at large considers to be the most important information.

Take note of the key line items, such as the various revenue categories, cost of goods sold/cost of services, and operating expense breakdowns. Don’t worry too much about the more complex accounting lines, such as goodwill or noncontrolling interests, unless you know they pertain directly to your business.

2. Projecting revenues

Once you have a baseline for what line items you’re looking for, revenues are a great place to start. You already have a good understanding of how your business makes money. The key here is breaking down your revenue into different “streams” that make the most sense for your business and industry. Maybe you sell items in a brick and mortar store and online. Those would be two different revenue streams.

Alternatively, your revenue streams could be the products you sell and the service revenue that comes along with continued maintenance of those products. For us, we noticed that our industry looks at in-store revenue versus the revenue that comes from selling our coffee wholesale or to grocery stores, so that’s where we started.

What drives each one of those streams? For our cafés, it’s a factor of how many people come in each day and how much money they spend.

The goal here is to take the abstract number of “Café Revenue” and break it down into each of its critical pieces, which are concrete and much easier to conceptualize and project. From there, you multiply them together.

For my company, it looks something like this:

Daily Café Revenue = number of cafés x number of people per day x average cups of coffee per person

Those numbers are much easier to find and track than trying to run trend analyses or looking just at the historical dollar values. You can get more nuanced with them as well—maybe your business has a seasonal tendency, or maybe there’s a weekly cadence to your business flow. As long as you can break it down into its different parts, you’ll be able to make these projections happen!

3. Variable expenses

Variable expenses are those that depend directly on your revenue. You’ll see them on your income statement primarily as cost of goods sold/cost of service, with some as operating expenses.

Let’s look at a cup of coffee. We figured out in our previous example around how many cups we’ll be selling in a day, and now we want to figure out the variable costs: the cup and lid, the coffee itself, the water that goes into brewing, the syrup for flavor, and any milk or other add-ins. Adding those up and multiplying by the number of cups sold per day gives us our variable cost.

Of course, your business will probably be a little more complicated than this. Maybe your products have different sizes and costs, or different services cost different amounts to perform. As long as you can point to those numbers down the line and explain your assumptions, you are good to go!

Other Articles From AllBusiness.com:

The Complete 35-Step Guide for Entrepreneurs Starting a Business
25 Frequently Asked Questions on Starting a Business
50 Questions Angel Investors Will Ask Entrepreneurs
17 Key Lessons for Entrepreneurs Starting A Business

4. Projecting fixed costs

Fixed costs are much simpler to project. These are the costs that you will incur, regardless of how much you sell. They generally fall into a few categories, such as salaries, rent expenses, equipment costs, or other such costs that you know you’ll have to pay, regardless of if you sell one item or one million.

For many of these types of costs, they are either the same year-over-year, or grow at a fixed, predictable rate, like a rent increasing 2% each year. You can predict and project those out, and they will generally make up your operating costs, non-operating costs (such as interest on loans, etc.), and potentially a small part of your cost of goods sold.

From here, you just need to put the income statement all together, fill in any missing lines (taxes, for example), and you’re good to go!

5. Building out the balance sheet and statement of cash flows

These two statements are a bit more accounting heavy. A third party may only need to see the income statement projections, and then will simply ask for the actual balance sheet and cash flow statement as of your last fiscal year or quarter. In that case, you may not even need projections for these two as much as accurate statements from your past few periods of operation.

If you do choose to project out your balance sheet and statement of cash flows, the process is pretty similar. Take a public company or other comparable financial statement from your industry, and start filling in the lines. You should be able to go line by line with your income statement, and build out the statement of cash flows based on how much cash you started with. The bottom line of the cash flow statement is the cash on hand at the end of the period, which flows directly into your balance sheet.

Before you get started …

Building your business financials is no easy task. Projecting them out into the future is even harder. As you take this on, just remember that while it’s not the most exciting or interesting project, it can help you down the line, not only with your partners, but in planning and deciphering what areas of your business are poised for success, and what may need to be fine-tuned.

Keep track of your assumptions so you can explain them, and take the complicated items and break them down so you and your team can better predict and understand the key drivers. Finally, always remember that these are just projections. As useful as they are, they should play only one role in your decision-making process about what’s best for your business.

RELATED: What Advice Are Venture Capitalists Giving to Startups in Light of the Coronavirus Crisis?

About the Author

Post by: Kuran Malhotra

Kuran Malhotra is the Director of Corporate Development for Compass Coffee, a DC-based specialty coffee roaster and retailer. Originally from Northern New Jersey, Kuran joined Compass as a barista while attending Georgetown University’s McDonough School of Business, and now focuses on growing the Compass Coffee Consumer Packaged Goods segment. Kuran’s favorite drink is a maple latte, and beyond Compass, he is passionate about teaching financial literacy and is an avid foodie.

Company: Compass Coffee
Website: www.kuranmalhotra.com
Connect with me on Facebook, Twitter, and LinkedIn.

The post Looking to the Future: 5 Steps to Better Financial Projections During Covid-19 appeared first on AllBusiness.com. Click for more information about Guest Post. Copyright 2020 by AllBusiness.com. All rights reserved. The content and images contained in this RSS feed may only be used through an RSS reader and may not be reproduced on another website without the express written permission of the owner of AllBusiness.com.

To discover more visit: allbusiness.com

Add Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

mega888