A Practical Guide to Financial Modeling and Projections for Growing Businesses

A Practical Guide to Financial Modeling and Projections for Growing Businesses

CFOs are prioritizing improvements in the financial planning and analysis capabilities of their businesses in 2022. In a recent Deloitte survey, financial planning and analysis (FP&A) topped the list of the finance functions North American CFOs are focused on improving. Financial leaders also want to strengthen the data analytics and forecasting capabilities of their finance teams.

As FP&A skills become a must-have for all finance professionals, it’s worth revisiting a core analytics discipline they need to understand and can continually improve upon: financial projections and the modeling techniques used to produce them. Enhancing these skills has grown more important to remaining agile, resilient and profitable in the wake of unpredictable business, economic and supply chain events, as well as to inform strategies for future growth as the economy starts to expand.

Financial projections and the modeling techniques that shape them are in sharp focus because they help companies input assumptions, see the projected outcomes and choose the most favorable ones so they can take the best steps to move the organization forward.

Businesses of any size can take advantage of financial projections and modeling. What’s more, while much of the basic work can be done in spreadsheet applications, more sophisticated tools are now accessible for smaller organizations. This ebook will explain the value of financial projections, what information you need to get started, a few popular models and how your business can leverage these techniques to thrive and grow.

What Are Financial Projections and How Do They Differ From Forecasts?

The term financial projection is often used interchangeably with forecast, but there are key differences. Financial projections and financial forecasts are alike in that they both aim to predict outcomes based on specific assumptions. But where forecasts present the assumptions that reflect what the business expects to happen, financial projections apply a financial model to play out various assumptions to see what might happen. The output, projections, is a forecast of what might happen as a result of those assumptions along a spectrum of best-case and worst-case scenarios, what ifs and more. All that information allows the business to plan and think about its actions in the event that any of these outcomes—good, bad or neutral—occur.

In the past, forecasts provided a sort of internal map to guide business decision-making, and projections were used to show outside investors how their money would be used. For instance, if a bank gives you a loan for $200,000, what will you do with it? How do you plan to pay it back?

More recently, projections have become essential business tools to recalibrate strategies and build contingency plans in light of unanticipated supply chain disruptions, changing expectations from the workforce (like a growing preference for working remotely) and more.

Watch the Video: What is Financial Modeling?

Why Do Companies Use Financial Projections?

A financial projection predicts a likely outcome based on one or more hypothetical assumptions. Those assumptions are the inputs of the financial model, which is a statistical tool used to predict what might happen as a result of different business decisions, market scenarios and more. With that information, the model can then show the expected financial position, operational results and cash flow.

Calculating several financial projections simultaneously in order to evaluate multiple scenarios and the possible responses is a common practice. Projections help a company better plan for risks, like a natural disaster that prevents it from getting a key part from a supplier or a sudden drop in demand after a competitor launches a superior product. They also help prepare for positive outcomes, like a spike in demand for a certain product or the increased capacity from opening a third warehouse. They give the business a much better idea of how external factors will impact its financials and the adjustments and investments it needs to make to achieve its goals.

Projections cover multiple financial metrics. Revenue projections can give investors and lenders a sense of how, for example, a 20% increase in sales could impact operating expenses on the income statement. Cash flow projections show where you will get that money—from receivables, loans, a line of credit or another source. A balance sheet projection can suggest the anticipated rate of return for someone who invests in your company.

Financial projections are useful for:

  • Developing business plans. The financial section of a business plan should provide quarterly or even monthly projections for the first year and annual projections for the four years after These include projected income statements, balance sheets, cash flow statements and budgets for capital expenditures. The projections are important internally to determine everything from break-even points to growth plans, and to measure the company’s performance in its early years.
  • Informing growth strategies and business management. Financial projections show discipline in financial management, and better financial management increases the chance of overall business success in a big way. By using a financial model to make projections, you can see if, when and whether your business will make a profit with its initial business model, what could happen if it added new products or services, when to hire new people to support the company, when to make capital investments and their potential payoff, and
  • Due diligence for investors and lenders. The people and institutions investing and lending money will need to see proof that you can pay them back, and have a solid understanding of how you plan to do that. Some common benchmarks to project include how long it will take until the company turns a profit, sales in years three and five and data showing how your numbers compare to industry standards.

What Do You Need to Get Started?

Both financial forecasts and financial projections rely on current and historical transactional data, coupled with information on market conditions and industry trends.

Financial projections take the analysis a step further by applying a financial model to determine how certain variables will change the assumptions. Financial projections use information from current and past financial statements and external market information from government agencies, such as the U.S. Department of Labor, or market and industry projections from leading research and advisory firms.

Many finance leaders complete their first models in a spreadsheet program like Microsoft Excel, and the formulas allow you to model assumptions you’ve made. To build a financial model, you will ideally have at least three years of historical data, and the Journal of Accountancy provides a comprehensive list of financial data and metrics to include, such as:

  • Revenue (including revenue levers, drivers, revenue driver activity assumptions and pricing)
  • Cost of sales
  • Selling, general and administrative (SG&A) expenses
  • Capital investments

Oftentimes, the hardest part for startups and younger small businesses is getting these numbers in the first place.

Startups often run into the problem of trying to figure out what data to use for the foundation of their financial models since they have little to no sales history or metrics to work from. One source is industry and market research, like Standard and Poor’s (S&P) or Dun & Bradstreet, which provide national averages for businesses in different markets.

Newer companies can then pare down that information into the numbers most relevant to their organization. These figures can include the standard costs of revenue in every industry, the percentage of revenue attributed to the direct cost of sales or what percentage of revenue goes to overhead.

Another approach is to base calculations on the market share you want to capture in a certain time frame (top-down) or based on the resources at hand and the current data (bottom- up). Bottom-up forecasts are usually best for the shorter term (one to two years) and top-down for the longer term (three to five years). Used together, these two strategies offer a healthy balance between ambition and the reality of how much market share you can capture.

What Financial Models Should My Business Use?

Once you have these inputs, you can build and apply a financial model.

The three-statement model is the most important financial model and the one on which every other financial model is based.

True to its namesake, it takes the three core financial statements—income statement, balance sheet and cash flow statement—and uses assumptions and formulas to create a forecast for a given time period. The forecast starts with revenue and can also calculate expenses, debtors, creditors, fixed assets and more. Once the three-statement financial model is in place, employees can apply other financial models to conduct scenario planning and sensitivity analysis.

An employee building a financial model in a spreadsheet will create tabs for the income statement (showing revenue and expenses), balance sheet (detailing assets and liabilities), cash flow statement (money in versus money out), capital expenses and depreciation costs to establish a clear picture of the current financial health of its business. A finance professional then uses the assumptions as inputs and applies formulas to drive outputs that are projections. On the income statement, for example, assumptions can include revenue, average order value, refunds as a percentage of revenue, discounts as a percentage of revenue, cost of goods sold (COGS) as a percentage of revenue and operating expenses as a percentage of revenue.

Once the three-statement financial model is in place, other financial models can be applied to further understand the impact of various assumptions. These include:

  • Sensitivity Analysis (What-If Analysis): A sensitivity analysis shows the effects of changes in assumptions such as selling price, supply chain costs, fixed costs, forecasted sales, delivery costs and other Sensitivity analysis models generally change one variable at a time and then demonstrate the impact of that change. For instance: How does changing the price of packaging or the advertising budget affect the forecast? Can the company boost profits if it changes the average selling price? For this reason, sensitivity analysis is also called what-if analysis. It challenges the person looking at the numbers to consider the reliability of the assumptions made. What happens if actual results turn out to be much different than expectations? Which factors have the biggest impact on the forecast or projections?
  • Scenario Analysis: This financial model is closely related to sensitivity analysis but involves changing all or many variables at the same time, rather than one at a time. A scenario analysis looks at what happened in the past and what could happen in the future, including major changes that would have a lasting impact on the company. It typically includes base-case, worst-case and best-case scenarios. Scenario analysis could be used, for instance, to model the impact on total revenue of launching a direct-to-consumer channel, adding a new enterprise customer or, on the more challenging end, a natural disaster or the loss of a critical customer.
  • Strategic Forecast Model: Businesses use a strategic forecast model to see how various initiatives they’re considering would affect long-term, strategic Also called long-range forecasting, this model helps organizations evaluate the impact of corporate projects, major finance initiatives and marketing and analysis plans on its long-term strategy. For example, a company may use the strategic forecast model to project the costs and potential revenue of opening a second manufacturing plant, building stores in another country or launching a new product line. It can then help leaders determine whether it’s in the business’s best interest to pursue those projects.
  • Discounted Cash Flow Analysis: A dollar today is always worth more than a dollar two years from now. If you do nothing to your business and it makes a predictable amount of money each month, you know your cash flow. If you make an investment now—acquiring another company, for instance—that will produce new revenue streams in the future, that future money is not worth as much on a dollar- per-dollar basis as the money you’re spending right now. If you have a customer who is ready to sign a five-year contract to purchase a specific quantity of your product, that’s the basis for your new investment. As long as that customer has a strong business, you have a sure thing— you know the company will receive a certain amount of income for five years. You can use the interest rate on some other sure thing (like a five-year Treasury bill) to determine your discounted cash flow. If your estimated return on investments has historically been 90% of what you initially expected, then your discount rate needs to reflect that. In that way, your discount rate reflects both what you could earn if you just invested the money, plus a measure of risk based on market trends, your own history or both. You’ll use that discount rate to calculate the net present value of your investment, and if it’s positive, you’re making a good investment.

Calculating the net present value of investments is the best way to determine whether an investment is a good one or not. But the quality of calculation is highly dependent on your ability to set the right discount rate.

Step-by-Step Guide to Creating Financial Projections

While many finance departments rely on customized spreadsheets to do financial modeling and impact analysis for these models, there are several issues with this approach. Spreadsheets are challenging to manage, lack data transparency and integrity, do not integrate with operational plans, and are generally not efficient at handling financial modeling activities.

With planning and budgeting software, models don’t have to be created from scratch every time an executive asks for a projection. Cloud-based planning solutions enable users to create and compare multiple models that incorporate real- time financial and operational data. Since there’s less legwork required, the business can scale and apply this type of analysis to more business decisions, leading to faster insights for decision-makers. Despite those clear benefits, only 11% of small businesses surveyed by Robert Half said they have automated their financial modeling practices.

Small businesses just getting started with financial planning can create a basic model in Excel by following these steps below. 

1. Create a new spreadsheet and label the first row “Assumptions.” Label columns B, C, and D with three future fiscal In these columns, you’ll make predictions about your performance in each of those years for a variety of metrics.

2. Label rows with revenue, units, price, COGS and operating expenses like marketing, labor or other categories of expenses that are relevant to your business.

3. Fill in the values with your assumptions, based on financial forecasts and your current financial Use a font color that is easily distinguished from black in the corresponding cells (like blue). Remember to format any dollar figures with the accounting number format by right- clicking the cells, going to “format cells” and selecting “accounting” in the “numbers” tab.

4. This is a good time to freeze panes. To do this, highlight cell B4 or its equivalent in your worksheet, go to “View” in the task bar, and click “Freeze panes.” This keeps your labels visible as you toggle around in the If you pay attention to the row numbers as we move on, you’ll see how this improves readability.

5. Next, move down a couple of rows to start calculating projections for your income statement, beginning with net The font for these values will be black. You will run the numbers in your assumptions through a formula to calculate net revenues by multiplying units by price (=B6*B7 in the sample from Figure 1). Copy and paste the formula to the next two cells to the right. The spreadsheet should automatically apply the formula appropriately for the year you’re working in, but it’s a good idea to make sure that it did by double-clicking the cell to view the formula. Ensure that the letters match the column for that cell. Make sure your number formatting is set to “accounting.”

6. Calculate COGS by multiplying units by unit cost (=B6*B10 in our example). Just as before, copy and paste that formula in the two cells to the right, checking to make sure it was applied appropriately for each column. Check your number formatting to ensure that it’s “accounting.”

Now, the format of your worksheet should resemble Figure 2.

7. Still within the income statement area, calculate gross profit by subtracting COGS from net revenue (=B18–B20 in our example). Copy and paste the formula to the next two cells to the Check the formulas and the number formatting for the correct column and “accounting.”

8. If you would like to see margins, you can divide the gross profit by revenue (=B22/B18 in Figure 3) and change the number format to percentage so you get the gross profit percentage.

9. While still within the income statement, calculate operating For our sample, this included labor and marketing in our assumptions—you may want to include additional costs—and we will reflect those same expenses in the income statement. Remember that you don’t want to enter the same value in two cells, so fill in these cells by using a formula to pull numbers from the source in the assumptions. In this example, we would compute labor for 2020 by entering =B13 because we got that number from the assumptions. That way, if we change the assumption later, the income statement will adjust along with it. Repeat this step for the remaining five cells in the operating expenses section of the income statement. Check your number formatting.

10. Calculate the total for operating expenses by adding all of the costs in this section together. In our case, we can simply add labor and marketing, but if you have more than two items here, you can use the sum formula. As always, check the number formatting.

11. Calculate operating income by subtracting operating expenses from gross profit (=B22–B28 in Figure 5, see next page). Copy and paste the formula in the cells to the Check your formula and number formatting.

12. Determine operating income margins by dividing operating income by revenue (=B30/B18 in Figure 5, see next page). Again, copy and paste the formula for the next two years, and check your formulas and change the number format to “Percentage.”

Now you have built a dynamic model using best practices that automatically calculates gross and operating margins as you change assumptions. While this is a basic model, it’s one of many that can help you set goals and make decisions for your company. It quickly gives you an idea of what your finances would look like based on projected revenue and expenses, and you could create multiple versions based on expected, high or low sales estimates.

Enabling Easier, Accurate Financial Projections With Software

There are clear advantages to automating financial modeling capabilities with a planning and budgeting tool. Software can process more data and create visualizations to make projections easier to consume and glean information from.

The automation enabled by these systems means less time spent finding and entering data, and more time using the outputs of the model to inform and shape business decisions.

But any investment in automated financial modeling or manual calculations will be for naught without reliable, accurate inputs. That’s why it’s so important to start any journey to financial analysis by first automating as many accounting and finance processes as possible, since all other activities will use those numbers. As noted earlier, accurate financial statements are the baseline for solid financial analysis. In that sense, an ERP platform with robust financial planning capabilities like NetSuite often serves as the foundation for financial modeling and projections. Having a central database that updates in real time assures decision-makers that they’re using trustworthy numbers across all departments.

That single source of information helps financial planning and analysis teams overcome their chief challenge: data collection.

One survey found that the teams spend 75% of their time gathering and processing data. A system like NetSuite Planning and Budgeting eliminates that work by automatically pulling in historical data and applying it to pre-built, industry-specific statistical models that include revenue and expense modeling. That allows businesses to more accurately model what-if scenarios and predict potential results. NetSuite’s planning and budgeting application then generates a dashboard summarizing those predictions, and users can apply predicted values directly into their plan or forecast. Finally, the module eases the presentation of those results with drag-and-drop capabilities to build reports for different audiences and make it easier to share them with various stakeholders.

Financial models and projections have become increasingly crucial for finance teams. As companies become more aware of the various risks that could have a dramatic impact on their operations and revenue, they’re doing everything they can to plan for such events and avoid scrambling. Although financial modeling may sound daunting, anyone with a basic understanding of your finances should be able to perform basic projections. An ERP solution and planning and budgeting software will take your efforts to the next level and make more complicated and frequent projections feasible.

Want to know more?

Our experts are more than happy to listen to your enquires and provide you with the information you need.

Related Post

7 Strategies for Growth

7 Strategies for Growth

It’s been 60 years since U.S. business leaders have had the chance to ride a 6% GDP expansion. Grabbing more than your share of new business requires innovative pricing, supply chain and customer acquisition actions. Our 7 strategic pillars range from fulfill inventory anywhere to making metric-driven decisions and capturing new revenue streams.

By Art Wittmann

We are in the midst of the biggest single-year economic expansion since the 1960s. That’s the consensus from the International Monetary Fund, various U.S. government agencies, the Federal Reserve and most leading economists. The Conference Board predicts 6% U.S. GDP growth for 2021 after a 3.5% decline in 2020, and the Bureau of Labor Statistics confirms that, in the first quarter of 2021, the country topped that 6% annualized figure.

With almost no institutional memory of those halcyon days of the 1960s remaining in C-suites, however, optimizing for success is uncharted territory for business leaders. Capitalizing on this opportunity will come down to planning, positioning and a careful reading of — and quick reaction to — incoming data.

To drive thinking about how to capitalize on the boom now underway, we’ve identified seven areas that warrant strategic consideration. We’ll discuss each briefly here, with links to some deeper dives, and continue to provide best practices as the year progresses.

As with any forecast, that 6% projection from The Conference Board comes with risk factors — both downside and upside. Keeping these in mind will help temper expectations and shape your own best practices.

Of all of these, the only risk that business leaders directly control is a productivity boost driven by digitalization. We will therefore recommend best practices for technology use throughout our discussion. Still, upside risks are more likely than downside, with the exception of unstable worldwide supply chains. In other words, if you aren’t already, treat this boom as fact, not forecast.

It’s time to move fast and make money.

Supply Chain Responsiveness

Many supply chains will remain unsettled through 2021, and some of the biggest, most sophisticated global manufacturers are affected. It’s been headline news that most automakers are slowing production because they can’t get the microchips they need. In the worst cases, some manufacturers will produce only half of their capacity in the coming months.

And yet, at least one Japanese automaker says its production won’t be affected because it has a four-month supply of these critical components on hand.

Clairvoyance, a fluke or exceptionally good luck?

None of the above, actually. These critical parts come from only a few foundries in Hong Kong and Taiwan, and this automaker understands the threats endemic to that region. It also calculated that the carrying costs of a four-month supply of chips isn’t all that high. So it stocked up, just in case.

The company didn’t take the same approach with other components, ranging from glass and leather to the myriad subassemblies that go into cars. It had multiple sources for these materials, and the risk of those supplies failing to appear on time was low.

Granted, that simplified explanation belies the intense statistical analysis that carmakers apply to their supply chains. But it is a useful anecdote to illustrate the need for differentiated supplier management.

Point is, when a necessary component is available from only a limited number of suppliers in a small geographic area, companies should carry more safety stock. That is, unless that supply chain hadn’t been substantially disrupted in decades, as was more or less the case for chips and other raw materials and finished goods coming from Pacific Rim countries.

A tanker blocking the Suez Canal. Brexit. A ransomware attack shutting down a major petroleum pipeline. Nobody would blame a supply chain manager for dismissing risks not seen in years, or ever. And if you had foreseen and presented a case to buy a few months’ worth of chips, leaders in the throes of the just-in-time craze would likely have dismissed your concerns as improbable — in which case, Scarlett Johansson or Morgan Freeman will play you in the upcoming sci-fi blockbuster about the one lone manager who knew a disaster was looming.

Action Items

  • Diversify — no matter your company size: Big manufacturers know all about supply chain In our example above, Hong Kong and Taiwan are just 450 miles apart in the South China Sea. The political environment alone should be cause for significant concern. Whether you take a highly rigorous statistical approach or rely on your teams’ understanding of your supply chain, there’s a clear mandate to diversify if you can, hold more safety stock if you can’t. Geographic diversification is a first line of defense for critical supplies, and the time to develop those relationships is before there’s a crisis.
  • Adopt a hybrid JIT/JIC inventory approach: An obsession with just-in-time inventory — getting components in the door just before they’re needed on the line — is both ingrained and increasingly old school. When critical items are not available from multiple suppliers in geographically diverse parts of the world, carrying a larger stock of those items — a hybridized just-in-case model — is now the norm. Of course, you need to weigh carrying costs. A few months’ supply of microchips could probably fit in the automaker CEO’s conference room. Not so with most of the components it takes to make a car. And for most companies, carrying months of inventory of anything will impact cash flow. CFOs will want to bring a careful analysis to bear, but going forward, we expect a hybrid JIC/JIT inventory management strategy to become the norm. In the real world, it’s not one or the other.
  • Hone supply chain visibility and demand planning: If critical stock is an issue and carrying costs threaten margins, it’s time to The 80/20 rule states that 80% of results — sales, and more importantly, profits — come from 20% of efforts, customers or another unit of measurement, often a comparatively small set of products or services. An ABC inventory analysis exercise, where you group SKUs based on demand, cost and risk data, will typically reveal production priorities. Companies with a good grasp of unit economics tend to gain significant clarity. Hopefully, implementing systems and gathering data to better manage demand planning and supply chains, create forecasts and understand unit economics were part of your work in 2020. If not, now is the time.

Capturing New Revenue Streams

As we’ve discussed, the opportunity for substantial growth should extend into 2022, especially for businesses poised to capitalize on the opportunities that emerged in 2020. There are some challenges — disrupted supply chains, skills gaps, distribution and customer acquisition costs — we know will remain as headwinds. It’s less certain whether inflation and policies to manage it from central banks around the world will be a factor.

While the Fed increased its U.S. inflation forecast for 2021 from 1.8% in December to 2.2% in March, officials have long predicted “transitory inflation” as the economy reopens. With spiking demand for everything from rental cars to lumber, most experts don’t expect reactionary tightening of monetary policy as of now. But those March Fed numbers are way too optimistic. The U.S. Bureau of Economic Analysis says Q1 inflation clocked in at 6.4%. So unless we see some deflation in coming quarters, 2.2% for the year is a virtual impossibility.

CFOs need to chart a range of inflation scenarios and have plans in place for pricing strategy, supply chain diversification and how raising the cost of your goods and services might affect customer acquisition and retention. Standard customer churn analysis can shed light on the latter two factors.

One thing is for sure: Finance teams will have their hands full as they determine risks and margins with new revenue streams.

Action Items

  • Make that “temporary” new revenue channel permanent: Many companies planned for or opened new revenue channels in 2020, and that experience is a huge It may be tempting to look at those moves as temporary. Some owners of high-end restaurants, for instance, have talked about ending their takeout programs. They don’t want to compete in that market with what they consider to be inferior versions of their products. That’s a fair point. But most businesses, like manufacturers that stood up direct-to-consumer ecommerce sites or firms that dabbled in the subscription economy, will be happy to continue nurturing new revenue streams as long as the customer experience and margins remain acceptable.
  • Overcome the pricing challenge: Pricing may be one of the trickier factors to get right during the recovery, so it’s well worth adopting an analytical approach. Consumers with cash and pent-up demand don’t seem to be highly price conscious — at this point, simply being able to deliver goods and services that are in demand is a strong differentiator. At the same time, workers aren’t rushing back to jobs that both paid low wages and put them in harm’s way, whether from the virus or belligerent customers, so labor costs may rise. Want to get really serious about revamping your pricing? Consider adding a chief revenue officer to focus not just on price but on overall customer happiness and revenue optimization.
  • Make scenario planning part of your DNA: Everything from unit costs to customer satisfaction will likely be in flux over the next 12 to 18 Price hikes acceptable to the market could get chewed up by increases in other areas. 2020 required fine-tuned financial analysis to survive; 2021 and 2022 will require that level of analysis to thrive. Those scenario planning skills you gained in 2020? Refine and refocus plans as the level of unevenness in the recovery becomes apparent. Didn’t get started? There are a number of templates and formalized frameworks. What’s important is choosing a method that works for your team.

Flexible Fulfillment

This past year saw a number of customer engagement trends accelerate. Ecommerce took off as consumers became comfortable shopping for more, and more types of, goods from their homes. Manufacturers learned how to sell directly to consumers, and many traditional retailers doubled down on their already effective omnichannel approaches.

In service of those new channels, marketers are pushing hard on their own new ways to attract attention, from engaging social media influencers to flooding consumers with retargeted ads. And it’s working. Those efforts are bringing in new business that helps offset losses due to restricted in-person selling. And, in many cases, those new sales are via new fulfillment channels.

This year, the challenge is keeping customers happy with fast and predictable fulfillment. Success is bound to your ability to manage inventory holistically.

Action Items

  • Connect inventory, fulfillment and ecommerce: Managing customer expectations as delivery services struggle to keep up is perhaps the most challenging part of opening and maintaining new sales channels. Businesses with storefronts can fulfill many orders and ease returns using existing facilities, leading to the rise of BOPIS. But success with “buy online, pick up in store” requires centralized inventory management, ideally connected to your order fulfillment system. Further, since ecommerce often accounts for a significant share of sales, those systems should connect to the ecommerce engine so that customers can see what’s in stock and when orders will be ready. Whether or not your business has a network of stores, it’s smart to think about alternate fulfillment channels. If business is brisk and getting serious about new channels will make it more so, using third-party logistics (3PL) companies for fulfillment is a good short-term strategy — and potentially long term as well, depending on your profit margin target and current fulfillment capabilities. If your operation is geared to fulfilling orders in pallet volumes, 3PL companies can help with smaller orders.
  • Beef up new ecommerce systems: In some cases, the ecommerce sites businesses stood up last year showed a fraction of available inventory or offered only rudimentary ecommerce functionality. For some, these sites were a first, quick foray into selling direct to consumers (D2C); for others, it was a way to sell unique goods, like PPE, that required a different channel than a direct sales team. Now it’s time to refine websites to offer more products, take better advantage of data for personalization programs and improve the ecommerce customer experience, including adding the ability to track shipments, estimate when orders will be fulfilled and accurately show available inventory. Success with every bit of this requires tying fulfillment management to the ecommerce site as well as tracking new order fulfillment and inventory KPIs.
  • Automate fulfillment: It’s a theme we’ll return to repeatedly. Automation is the next logical step once you’ve implemented cloud-based business and fulfillment/order management systems. A primary task when automating any process is to build in your business rules so that the system handles new transactions properly, minus the inefficient, legacy processes that are likely slowing you down now. Some rules are fairly generic. Say a customer pays for two-day delivery; that order goes toward the head of the FedEx or DHL queue. Other rules may be highly specific to your business. Perhaps long-term or high-value customers get full shipments of popular products, while smaller or newer retailers may receive only partial orders. Without automation, managing complex business fulfillment rules is an error-prone and confusing matter for staff. With automation initiatives to fine-tune business rules are more likely to come off without a hitch.

Automation for Scale

Automation, like exercising and reading more, always makes the annual resolutions list but never quite bubbles to the top. 2020 likely changed that. Whether it was to better support remote work, enable scenario planning or remote closes, get serious about ecommerce, improve supply chain management or all of the above, lots of companies at least laid the groundwork for automation.

So, unlike using the treadmill that’s now draped in clothes and shame, the automation resolution is one you can and should keep.

Adding better digital systems, or finally fully using existing capabilities, helped lots companies get through 2020. Now, many are looking at taking the next steps toward eliminating the rote, slow, error-prone, human-based processes that suck the life out of staffers and leave decision- makers with incomplete or suspect data. Once digitalization happens, leaders not only get more timely and accurate insights, they have more staff resources to devote to interpreting and acting on them.

Capturing that 6% expected growth for the second half of the year requires a fresh look at automation — it can be the difference between winning new business versus ceding ground to competitors because you’re too busy reading spreadsheets.

Action Items

  • Plan automation holistically: Automation by its nature needs to be a holistic exercise — develop a vision of your perfect system, then chip away at making it reality. Think about self-driving cars. Automating steering, acceleration and braking separately without a plan of how you’ll tie them together won’t get you a vehicle that safely drives itself. In business, operations groups want automatic visibility into activities across the company. Sales wants to acquire new customers and sell more to existing Marketing wants to understand the results of its campaigns. Production wants to automatically monitor supply chains, stock levels and output. And finally, finance wants to automate closes, AP and AR and get more timely data to improve its ability to provide financial planning and analysis for the company. But to really grow in a scalable way, sales needs to know about inventory and production. Marketing needs to know which products produce the most revenue and profit, and production needs to track sales forecasts so that it’s churning out items that are in demand. And finance needs a high-level understanding of how all these functions are performing so that it can guide the business toward growth and profit. That sort of powerful integrated business planning starts with a vision of data sharing as a means of empowering each part of the company to be better and more efficient at what it does.
  • Define processes, set business rules, repeat: As with automating fulfillment, a customer might get discounts if it maintains a $10,000-per-month spend, for example, while in another company that threshold might be $25,000. With automation, you define these rules in the applications you’re using and let the system implement them consistently and automatically. Rules can define how you recognize revenue, when you order more stock, how you set production quotas — whatever makes your company tick. What was once manual now happens according to defined policies, including requirements for approvals of various actions. Automated tasks happen faster and with fewer errors. Fraud is minimized. KPIs and dashboards are created automatically for executives, freeing up managers’ time to pay more attention to the business. In the end, you get more consistency, more timely data and more effective use of staff. All of which are needed to capitalize on current growth opportunities.
  • Drive payoffs in efficiency and productivity: On average, larger businesses drive more revenue on a per-employee basis than smaller ones, and automation is a big reason With automation, marketers can manage more campaigns, sales teams can deal with more customers and finance teams need fewer resources to close the books. This efficiency accrues with time, so it can be difficult — though not impossible — to lower your headcount through automation. Instead, a growing company shouldn’t need to add employees as rapidly as it would if it hadn’t automated its processes. That’s a critical competitive edge as you compete for talent. And, staff time moves from the tactical job of entering and verifying data to the strategic job of using that data to deliver better products and services. In other words, the ROI should be apparent early on, and break even on the investment should follow fast.

Operate from Anywhere

Of the practices that got businesses through 2020, “work from home” was paramount. For those employees able to function remotely, productivity turned out to be surprisingly high, and morale often flourished as work got done, and done well. Various business leaders have expressed a full range of opinions on whether and how the practice should continue, and CFOs likely have their own thoughts on the matter in light of the tangle of tax implications that come with a geographically dispersed workforce.

Still, workers whose jobs allow are clearly for either a work-from-anywhere policy or a flexible arrangement, with some days in the office and others at home. In 2021, a strict “back to the cube farm” stance may cost you talent.

Whether you can, and/or intend to, allow remote work once restrictions are fully lifted, it’s smart to at least retain the muscle memory because things happen: Pipes break, hiring accelerates faster than you can add space, blizzards close schools. Coping is easier with remote-work capabilities and protocols in place.

Because employees favor it and productivity seems to benefit, we advocate flexibility. First, talent doesn’t have a zip code. If you find a perfect marketer or data analyst in Montana, it’s worth considering a fully remote arrangement. That same worker in San Francisco or Boston is likely going to cost a lot more, and some highly talented people are longing for more open spaces.

  • Adopt a cloud-centric policy for software systems: Assuming a hybrid or fully remote schedule works for your company, several actions taken in 2020 should now be made permanent. Primary among them is providing the tools workers need, preferably delivered from the cloud. Cloud providers live and die by the reliability and security of their products. Even the largest companies will be challenged to implement in-house versions of collaboration, productivity and core business systems that perform as well and reliably as cloud-based alternatives. Software delivered in an as-a-service model performs no matter where people are working and often costs less to boot.
  • Rethink your real estate: There are savings to be gained by providing employees with the flexibility they First, losing the commute increases hours worked, surveys show. Flexible schedules also give employers the opportunity to rethink how they use office space, including whether they need as much as they have. But don’t limit your thinking to simply number of workstations or square footage. Tuning for collaboration without the need to give everyone a desk can be a game changer. For example, an emerging trend is tracking work output versus hours logged. In a recent survey, only 36% of employees at organizations with standard, 9-to-5, 40-hour workweeks were classified as high performers compared with 55% at companies that offer employees choice in when and where they work. Maybe some people want to come back more or less full time, while others want to drop in on an irregular schedule to sit in on meetings. As with software, when thinking about office design, focus on flexibility.
  • Rethink core HR processes: All that sounds But some of you are thinking, “In the real world, there are challenges with remote workers, particularly new ones.” Getting them going on the technology kit is tricky, as is integrating new hires into the company and work team’s culture. That’s where HR comes in. Remote onboarding is its own discipline, all about bringing new employees up to speed so they’re productive, engaged and working toward company goals no matter where that work is done. This begins with the hiring process and continues with orientation, training and ongoing bi-directional feedback. Rethinking onboarding with a nod toward simplification and coworker mentoring will go a long way.

Metric-Driven Decisions

March 2020 demanded we make business decisions without much to back them up. There simply wasn’t data about how a once-in-a-century pandemic would impact global business and when to expect a recovery. Over in a few months? Years? Nobody could predict the extent of lockdowns. Hitting the brakes hard was a common first instinct, but for some it was an overreaction that left room for more daring competitors to take market share.

The sharp spike followed by a recovery in the unemployment rate is a good primary indicator of this overreaction.

Bottom line: There is a boom, but it’s a lumpy one, and if you expect workers to come back for less than $10 per hour, that’s probably not going to happen. On the other hand, consumer spending is also booming. Airports are packed. Many service-sector businesses simply can’t meet demand. If there was ever a time for careful data analysis, this is it.

But now, entering into what appears to be a V-shaped recovery, we do have data. Much of it is good, but not all of it. We’ve already talked about the worldwide supply chain issues that are likely to persist. Housing stock is below demand, building material prices are spiking, rental cars are impossible to get and summer gas shortages are predicted. Unemployment remains high even as companies are plagued by skills shortages. In March 2021, there were more unfilled job openings than during any month since we began recording that data more than 20 years ago.

Action Items

  • Expand your data view: Analysis needs to consider internal and external data sources. If that hasn’t been part of your approach, this is a good time to fix that. It’s also a good time for B2B companies to reach out to customers to gauge their own business outlooks and expected demand for your goods and services. They’ll be eager to hear how confident you are in terms of fulfilling their orders. Most B2C companies are seeing the result of pent-up demand. However, goods from appliances to furniture are currently in short supply, and so are the parts to make them. So your analysis needs to broaden to include the economic forces at hand. Demand planning is a cross-functional, data-driven process that helps businesses meet their customers’ needs without overshooting on inventory.
  • Instrument your operations: Do you have systems in place to report on operations throughout the business, from sales engagements to marketing lead generation to raw materials costs? How about traditional finance metrics ranging from the big three — cash flow, revenue and profits — to more tactical but still highly important measures that provide insights on efficiency and progress? For instance, customer acquisition costs are rising for many sectors and, in some cases, threaten to substantially reduce margins. But CAC is only one factor in customer lifetime value, and only one of many critical financial metrics to track. Your challenges may be around rising supply or shipping costs, or higher wage demands. In the current red-hot market, choosing the right KPIs is more important than ever.
  • Make financial analysis continuous: Whether or not your business had the right data to support scenario planning in 2020, most found a way to make plans for various contingencies. For finance teams, that often meant 55-hour-plus workweeks as they labored to understand cash flows, unit economics and other critical metrics that they’d never studied at the frequency or detail now required. Teams that had ERP systems in place, or that implemented them in 2020, have an automated way to gather data for ongoing financial analysis. As the volume and velocity of business increases in 2021, manual methods of analyzing data will be a strategic disadvantage.

Raising Capital

Is now the time to seek funding? A merger or acquisition target? Take your company public? There’s a lot of money out there looking for a home in a strong market. Many firms believe they could achieve growth, if they can just get some cash to seize the moment.

Attracting the attention of equity investors will require demonstrated growth and a clear path to profit for young companies — this was a loud trend heading into 2020, following a few years of perhaps irrational exuberance, and it’s here to stay.

If that sounds like you and your Rolodex doesn’t include many venture capitalists, get yourself to a pitch contest and make the case. Otherwise, consider other options.

Action Items

  • Don’t count on bank loans, which are likely to be more scarce after post-relief funding: Last year saw the federal government loan or grant hundreds of billions of dollars to businesses in the form of Paycheck Protection Program (PPP) loans and Economic Injury Disaster Loans. Some of that continued in this year’s pandemic relief bill, including targeted funds for the businesses most impacted, like restaurants and entertainment venues. Some money is still out there, but prospects for future government stimulus remain uncertain. As loan and grant programs wind down, regular bank loans will pick up again. However, if trends continue, total loan pools will slowly shrink. In 2007, banks held $721 billion in loans of $1 million or less, according to The Wall Street Journal. In 2019, that was down to $680 billion. Meanwhile, bigger business loans more than doubled during that period to $2.82 trillion. So, while loans to smaller businesses aren’t unheard of, the underwriting standards are historically tight.
  • If you’re angling for private equity funding, get your Rolodex out: Private equity is a path between conservative banks and high-growth-focused VCs. Last year as a group, PE funds raised over $200 billion, with much of it going to help stabilize companies that PEs already owned. Beyond that, tech/ IT deals grew by over 72%, according to PitchBook. Still, that’s only about one-third of PE investing — and an anemic number compared with the $2.9 trillion that’s sitting with PE companies uninvested.
  • The M&A market looks promising, so be bold: If fast growth and/or diversification are on your agenda, a merger or acquisition may make sense in 2021. Private equity plays here too, backing over one-quarter of last year’s M&A activity in 2020. Particularly for established businesses that have solid customer bases but aren’t up for making the technology investments seen as critical for success in 2021 and beyond, selling to, or buying, a company with tech chops may be the best course. For many such deals, you just need a few lawyers, an idea of your valuation and an interested buyer. In some sectors, that may be a SPAC or PE firm, or more commonly, you may have a complementary business in mind to sell to or buy. If yours is one of the sectors that’s turning sharply up, creating a win/win scenario should be very possible. As with a valuation exercise, stress your assets: historically strong cash flow, a healthy profit margin, high customer lifetime value, low employee churn, bookings for the near future. Larger firms can position themselves for acquisition by increasing margins or adopting key technologies popular within their sectors, but unless that’s been a work in progress, it’s likely your books will do most of the talking. Finally, while there is VC money up for grabs right now, historically this has been a small, albeit extremely visible, niche within the financing market. Venture investments hit $125 billion in the first quarter of 2021. That’s up 50% from the previous quarter and a 94% jump from a year ago. Crunchbase details how this money is distributed. The lion’s share goes to late-stage companies — that is, those that already have ties to VCs. Most, though certainly not all, early-stage investment also goes to companies familiar to VCs. If you believe you have a shot, here’s how to get some attention. But there are plenty of other funding sources. If you’re outside the tech hubs where VCs roam, a different finance route may be more doable.

Want to know more?

Our experts are more than happy to listen to your enquires and provide you with the information you need.

Related Post

Request a consultation with Us!