Creating Dynamic Financial Models
Hyper growth shines a spotlight on the weaknesses of spreadsheet-based financial planning. Learn how Pipe skipped complex Excel planning by building their financial models in Mosaic instead.
Less time building OpEx and Headcount Plans
More time spent on cross-department collaboration
Faster fiscal year planning cycle
Pipe is a trading platform that provides direct access to the capital markets for companies of all sizes, ranging from early-stage all the way to publicly listed companies. In May 2021, Pipe became the fastest growing fintech to reach a $2 billion valuation. Pipe’s core mission is to help entrepreneurs scale without restrictive debt or dilution, so companies can grow on their terms.
The company operates a trading platform for recurring revenue streams, connecting companies to institutional investors to trade their recurring revenue as an asset for up-front capital offering more cash flow for scaling companies.
Forecast OpEx and Workforce Investments at the Speed of Business Growth
It’s easy for early finance hires at hyper growth companies to get locked into the role of data wrangler and spreadsheet manager. They end up spending so much time trying to keep last month’s, quarter’s, and year’s actuals organized that there’s little time left to focus on more strategic, forward-looking efforts. Tony Le and the small FP&A team at Pipe wanted to avoid that stereotype from the very start.
Pipe launched publicly in June 2020, making its rapid rise to $316 million raised and $2 billion valuation almost unheard of in the tech world. That’s great for generating excitement among customers and investors—but it puts significant pressure on traditional finance workflows.
Le and his early FP&A team couldn’t afford to spend days or weeks building models to plan out the business only to watch them go stale a week later. They wanted to embrace a more tech-forward approach to finance that enabled real-time visibility into the data and more dynamic, agile planning processes.
The team wanted to start by modernizing its expense and headcount modeling to help ensure Pipe was properly allocating capital as it quickly scaled. They needed a software solution that could bypass traditional Excel modeling while also helping them continue building a culture of strategic finance.
"Our team’s mission is to create a culture of collaboration by providing financial insights that support data-driven business decisions. To build strong partnerships across the organization, we needed to establish our processes around an agile financial modeling and planning platform from the beginning."
Centralize Modeling and Planning in Software, Not Spreadsheets
One of the main reasons Pipe wanted to avoid spreadsheet-based planning was because it doesn’t lend itself to collaboration with the rest of the business. Le and his team needed a software solution that would act as a central source of financial truth while also making the data digestible for non-finance users.
But the landscape of modern strategic finance software—the kind that can support young, hypergrowth companies in a way that Anaplan and Adaptive can’t—is still in its early days. Many vendors are promising the world and under-delivering as they try to build out features that matter most to companies like Pipe.
Pipe implemented Mosaic after trialing a different solution and realizing it couldn’t support the finance team’s strategic needs. There were benefits that Le and his team realize value almost immediately:
- Data Aggregation and Centralization: Mosaic connects to Pipe’s source systems to consolidate financial data from across the business. The platform automates data aggregation, eliminating hours of manual work each month to organize actuals.
- Dynamic Financial Modeling: Mosaic enables Pipe to quickly adjust the assumptions in its models to test new scenarios and map out growth plans. The flexibility of Mosaic makes it easy for the finance team to keep pace with rapid business changes.
- Collaborative OpEx and Headcount Planning: Mosaic’s intelligent planning tools allow Le and his team to visualize key metrics by department and share with relevant business partners. They can quickly present things like marketing spend and headcount growth on a department level and focus more time on explaining the story behind the numbers.
The problem isn’t that spreadsheets can’t handle these workflows. Rather, it’s that having to manually build out financial models and keep them updated makes it hard for finance to move quickly—especially when you’re a team of 3 like Pipe’s. With a platform like Mosaic, a small finance team can maintain visibility of expenses and provide strategic guidance on headcount allocation even as their company scales through hypergrowth.
Accelerated OpEx and headcount planning.
Created on-demand performance reports.
Established agile scenario planning using a single source of truth.
Faster, More Collaborative Headcount and Expense Planning
A strategic finance function is one that can automate tedious, backward-looking tasks and spend the majority of its time on uncovering forward-looking insights that can drive growth. In the past, adding more headcount was the only way to reach this level of finance maturity.
But with Mosaic, Pipe’s finance team has been able to establish itself as a strategic partner in the business in its most crucial periods of growth.
That starts with a streamlined financial planning cycle and quarterly financial review processes. Automated data aggregation and consolidation eliminates the most time-consuming aspects of those processes. And as a result, planning processes have gone from taking nearly two weeks to taking a couple of days while quarterly financial reviews take hours instead of days.
Now, Le and his team focus on collaborating with department leads and digging into the “why” behind things like budget variance instead of only identifying that it exists.
“Mosaic helped us leapfrog the traditional approach to finance. Instead of spending our early days building disconnected spreadsheet models, we jumped straight to strategic finance software.” — Tony Le, Director of Finance at Pipe
While Pipe’s early use cases for Mosaic revolve around OpEx and headcount planning, the team has bigger plans for the platform. As they (and the platform) continue to grow, Pipe will take advantage of more robust revenue planning features along with workflows like ERP class tagging to further improve data integrity and accuracy.
Pipe is now able to...
Quickly forecast OpEx and headcount.
Run effective meetings using live department dashboards.
Get ahead of planning cycles vs. chasing them.