Fundraising

8 steps for building a financial model to calculate your fundraising needs

Comment

Yellow Calculator On Purple Background; financial model to forecast fundraising
Image Credits: Javier Zayas Photography (opens in a new window) / Getty Images

Blair Silverberg

Contributor

Blair Silverberg is co-founder and CEO of Hum Capital, a financial services company using technology to accelerate the fundraising process.

More posts from Blair Silverberg

The ongoing market downturn and layoffs at tech companies have caused a great deal of alarm across the startup and venture capital worlds, but growth-stage startups are expected to bear the brunt of the impact.

Early-stage startups have an opportunity to capitalize, as investors with dry powder will eventually need to deploy it to secure their management fees. Investors are moving focus toward earlier deals, which may be less risky in the short term compared to investing in growth-stage companies at larger average check sizes during a downturn. This is because the closer a company is to an IPO, the more investors establish its worth as a function of public company valuations.

Even when times are bad, good businesses will get funding. The key to proving your business is solid to an investor is to adopt a data-backed approach when telling your company’s story.

To start off, founders first need to figure out how much capital they need to hit business goals.

As many funding rounds reach eight or nine figures, the details that go into those deals can seem abstract to new founders or sound like companies are playing with Monopoly money. For many founders, especially those from nontraditional or under-resourced backgrounds, it can be daunting to even say, “I’m looking to raise $20 million,” out loud and feel like you’ll be taken seriously.

A solid financial model is critical to bridging the expectation gap between founders and investors, and it will allow both parties to cut through the hype and focus on the fundamentals.

Here are eight steps to developing a financial model to accurately project your fundraising needs:

Understanding your magic number

Before we build a financial model to find the magic number your business needs to raise, we first need to understand what a good model looks like.

Your model should project your needs two years in the future and include a 2x margin of safety.

A two-year time frame puts enough pressure on the startup team to execute, but not so much that they can’t be thoughtful and strategic. If your business is not making significant progress in driving up your valuation or revenue every two years, it’s likely that there are problems with the business model.

It’s hard to establish projections beyond two years with rigor, and you risk going down an analytical rabbit hole. Founders should avoid doing so for investor presentations. That said, founders should also make a long-term model (10-plus years) to think about overall strategy.

The human brain is notoriously inaccurate when planning, and a margin of safety is a great tool to account for this. Additionally, we live in uncertain times, which makes it critical to account for unexpected future macroeconomic shifts. Building a buffer into your model helps provide a cushion that you can use to get over any unforeseen roadblocks between rounds.

Once you find the amount you need to operate for the next two years, multiply that number by at least 1.5 (2 to be extra safe) to get your magic fundraising goal number.

Building the model

The data points we’ll use to determine overall fundraising needs are:

  • Revenue: The total amount of money generated by the sale of goods and services related to the primary operations of the business.
  • Gross margin: The difference between revenue and cost of goods sold (COGS), divided by revenue: Revenue – COGS / Revenue.
  • Contribution margin: Revenue minus sales and marketing spend (S&M): Revenue – S&M.
  • Operating expenses (opex): Ongoing costs for running a business, including payroll, marketing, and research and development.

Step 1: Determine your LTV/CAC ratio

Sales and marketing will account for the largest share of cash in a growing business. The lifetime value (LTV) to customer acquisition cost (CAC) ratio explains the relationship between spending on S&M and generating revenue.

To understand how much money is required to keep the business running as it grows, founders need to have a clear picture of how spending on growth converts to revenue. The LTV/CAC ratio is a key tool in these calculations, so you should determine this ratio first.

Founders need to understand both the gross margin LTV as well as the unit LTV to get a better sense of how efficiently the business can grow.

Step 2: Estimate monthly S&M investment

Founders should ask themselves how much they can invest in sales and marketing on a monthly basis for the next two years without seeing their LTV/CAC curve relationship decay wildly. This last part is critical: You can spend $1 billion a month on sales and marketing if you want to, but your performance will be inefficient.

You should evaluate the way you currently sell and market, and think about increasing that by three to 10 times. Your growth limit is the multiple of your current efforts that you can see yourself executing without plunging into chaos. For some growth companies, that is 2x per year, and for others, it is 10x in the early days.

It all comes down to whether you can see yourself running an organization at that scale — as measured by the number of sales and marketing employees and the total spend on marketing campaigns.

Step 3: Project revenue

Multiply the S&M time series by your LTV/CAC curve shape to project revenue. At this point, you should have S&M and revenue tightly defined.

Step 4: Estimate gross margin percentage over the next two years

Multiply revenue by this percentage to plot your gross margin curve. This margin will either be flat, contract or increase based on factors like potential pricing pressure, which raises it. Supplier costs can also increase gross margin if they fall and decrease gross margin if they rise in an inflationary environment.

Some factors are impacting gross margin right now. For example, a year or two ago, we would not have been able to accurately predict the increased labor costs and inventory pressure we’re seeing now due to the Great Resignation and supply chain disruptions. That’s why having a 2x safety margin is so important to future-proof a startup fundraise.

Step 5: Calculate your gross margin curve

Multiply revenue by this percentage to get your gross margin.

Step 6: Calculate contribution margin curve

Subtract S&M from gross margin to get contribution margin.

Step 7: Project operating expenses

Think about the staff needed to run the business at scale versus the staff you have now, and how those costs will evolve over time. Operating expenses should ramp up and then flatten out as you achieve scale.

Note that this flattening is often imperfect, but by growing operating expenses at a far slower pace than revenue, companies produce cash flow. This is called achieving “operating leverage.”

Step 8: Talk to your team

The work is not over once the initial model is finished. Once it is developed, the founder or CFO must bring the model back to the team to gather additional context and execution knowledge that may impact the inputs.

It is critical that the executive team comes to own the assumptions in the model. In a well-run company, these assumptions become your quarterly targets, and you track performance against those targets as leading indicators of whether you will hit your goals.

The fundraising team should do this exercise a few times to ensure everyone — top-down to bottom-up — believes in the model before approaching an investor.

With a believable model, you now have a conversational tool that diminishes bias and focuses the conversation on whether your assumptions are realistic. Although simplistic, you can think of pitching as simply getting an investor to buy into your model. If they do, you can successfully raise the capital you need.

Scaling your model

The fundamentals of your financial model will remain the same as you scale, but over time, all four inputs become more predictable as your LTV/CAC shapes the amount you can spend.

When a company is small, every prediction will be volatile. As companies grow and collect more data about the business, it becomes easier to anticipate gross margins, S&M and LTV/CAC precisely. The experience of hiring staff will also make operating expenditure projections more accurate.

As a result, the model will become more precise at later stages as overall risk decreases. This also allows for higher valuations.

Overcoming financial anxiety with data

The basics of a financial model are relatively straightforward, but, much like managing personal finances, people struggle with anxiety and discipline when it comes to money.

For founders, this often manifests in the tension between the wider vision for their company and the need to be realistic about finances. Most companies begin without a CFO, leaving many founders deeply focused on product development and clueless about financial best practices.

Early-stage founders can stand on surer footing in investor meetings by leaning on hard data to project what they need to raise in the first place.

More TechCrunch

With the release of iOS 18 later this year, Apple may again borrow ideas third-party apps. This time it’s Arc that could be among those affected.

Is Apple planning to ‘sherlock’ Arc?

TechCrunch Disrupt 2024 will be in San Francisco on October 28–30, and we’re already excited! This is the startup world’s main event, and it’s where you’ll find the knowledge, tools…

Meet Visa, Mercury, Artisan, Golub Capital and more at TC Disrupt 2024

Featured Article

The women in AI making a difference

As a part of a multi-part series, TechCrunch is highlighting women innovators — from academics to policymakers —in the field of AI.

1 hour ago
The women in AI making a difference

Ifeel is being offered as part of an employer’s or insurance provider’s healthcare coverage.

Mental health insurance platform ifeel  raises a $20 million Series B

Instead of opening the user’s actual browser or a WebView, Custom Tabs let users remain in their app while browsing.

Google Chrome becomes a ‘picture-in-picture’ app

Sanil Chawla remembers the meetings he had with countless artists in college. Those creatives were looking for one thing: sustainable economic infrastructure that could help them scale rather than drown…

Creator fintech Slingshot raises $2.2M

A startup called Firefly that’s tackling the thorny and growing issue of cloud asset management with an “infrastructure as code” solution has raised $23 million in funding. That comes on…

Firefly forges on after co-founder murdered by Hamas

Mistral, the French AI startup backed by Microsoft and valued at $6 billion, has released its first generative AI model for coding, dubbed Codestral. Like other code-generating models, Codestral is…

Mistral releases Codestral, its first generative AI model for code

Pinterest announced today that it is evolving its Creator Inclusion Fund to now be called the Pinterest Inclusion Fund. Pinterest teamed up with Shopify’s Build Black & Native program to…

Pinterest expands its Creator Fund to allow founders

Cadillac may seem a bit too traditional to hang its driving cap on EVs. And yet, that hasn’t stopped the GM brand from rolling out — or at least showing…

Cadillac’s new Optiq EV is designed to hook young hipsters

Alex Taub, a longtime founder with multiple exits under his belt, believes it’s time to disrupt the meme industry. “I have this big thesis that meme tech is going to…

This founder says meme tech is the next big thing

Lux, the startup behind popular pro photography app Halide and others, is venturing into video with its latest app launch. On Wednesday, the company announced Kino, a new video capture app…

Kino is a new iPhone app for videographers from the makers of Halide

DevOps startup Harness has shown itself to be an ambitious company, building a broad platform of services while also dabbling in M&A when it made sense to fill in functionality.…

Harness snags Split.io as it goes all in on feature flags and experiments

U.S. Rep. Elissa Slotkin will introduce a bill to Congress that would limit or ban the introduction of connected vehicles built by Chinese companies if found to pose a threat…

Chinese EVs – and their connected tech – are the next target of US lawmakers

Microsoft’s Copilot, a generative AI-powered tool that can generate text as well as answer specific questions, is now available as an in-app chatbot on Telegram, the instant messaging app.  Currently…

Microsoft’s Copilot is now on Telegram

HBO’s new documentary, “MoviePass, MovieCrash,” tells a story that many of us know about: how MoviePass, the subscription-based movie ticketing startup, was a catastrophic failure. After a series of mishaps…

MoviePass co-founders speak their truth in HBO’s new documentary 

The watch features a variety of different 3D games, unlocking more play time the more kids move.

Fitbit’s new kid smartwatch is a little Wiimote, a little Tamagotchi

In the video, a crowd is roaring at a packed summer music festival. As a beat starts playing over the speakers, the performer finally walks onstage: It’s the Joker. Clad…

Discord has become an unlikely center for the generative AI boom

After the Wirecard scandal, Germany’s financial regulator BaFin started to look more closely at young fintech startups that wanted to grow at a rapid pace — it’s better to be…

Germany’s financial regulator ends anti-money laundering cap on N26 signups after $10M fine

Among other things, this includes the ability to trace code from source to binary packages across both platforms, single sign-on support and unified project structures.

JFrog and GitHub team up to closely integrate their source code and binary platforms

The company’s public fund disbursement and e-commerce platform makes accepting school tuition and enabling educational enrichment more accessible. 

Tech startup Odyssey goes on journey to help states implement school choice programs

A new startup called Kinnect aims to help people privately save generational memories, traditions, recipes and more. The company’s app, launched this month, lets people create invite-only spaces where they…

Kinnect’s new app aims to help families record and store generational memories

Spotify has hiked its premium subscription in France by an eye-watering €0.13, in response to a new music-streaming tax.

Spotify hikes subscription price in France by 1.2% to match new music-streaming tax

The European Union has taken the wraps off the structure of the new AI Office, the ecosystem-building and oversight body that’s being established under the bloc’s AI Act. The risk-based…

With the EU AI Act incoming this summer, the bloc lays out its plan for AI governance

Solutions by Text, a company that gives people a way to pay their bills and apply for loans via text messaging, has secured $110 million in new growth funding. Edison…

Bootstrapped for over a decade, this Dallas company just secured $110M to help people pay bills by text

Owners of small- and medium-sized businesses check their bank balances daily to make financial decisions. But it’s entrepreneur Yoseph West’s assertion that there’s typically information and functions missing from bank…

Relay raises $32.2 million to help smaller businesses manage their cash flow

When other firms were investing and raising eye-popping sums, Clean Energy Ventures took a different approach. It appears to be paying off.

How Clean Energy Ventures avoided the pandemic bubble and raised a $305M fund

PwC, the management consulting giant, will become OpenAI’s biggest customer to date, covering 100,000 users.

OpenAI signs 100K PwC workers to ChatGPT’s enterprise tier as PwC becomes its first resale partner

Tech enthusiasts and entrepreneurs, the clock is ticking! With just 72 hours remaining until the early-bird ticket deadline for TechCrunch Disrupt 2024, now is the time to secure your spot…

72 hours left of the Disrupt early-bird sale

Avendus, the top investment bank for venture deals in India, confirmed on Wednesday it is looking to raise up to $350 million for its new private equity fund.  The new…

Avendus, India’s top venture adviser, confirms it’s looking to raise a $350M fund