Platform Updates: October 2023

1 - Fully Customizable P&Ls

Mosaic’s founding product set its sights on streamlining transaction returns math (IRR, MOIC) with “assumptions-driven” modeling. This release extends our defining approach to the operating model – the investment industry’s non-GAAP combination of the Income Statement and relevant Cash Flow elements that comprise Unlevered Free Cash Flow. Our latest update hands users the reins to fully control the building blocks of organic growth driving Revenue, EBITDA, Capital Expenditures and Net Working Capital (“NWC”).

Mosaic now comes pre-loaded with several quick-start elements (e.g., multi-segment Revenue & EBITDA builds, common cost structures like COGS / Gross Margin / S&M / R&D / G&A, and NWC builds for software or physical products businesses). It also allows you to define your own custom elements to build to each core cash flow row – because every business is different, and understanding these building blocks is a core part of diligence.

2 - Quarterly & Monthly Modeling

) used to take hours of painstaking manual Excel work. Mosaic will transition your annual models to quarterly and monthly at the click of a button – cleanly rolling up to quarters / years without the linking (and the warranted fear of mis-linking).

3 - Dynamically Generated, Customizable Excel

Say good-bye to the 50,000-cell Excel template (with 35,000 unused cells and a handful of #REFs) that was handed down to you by some VP who is no longer at the firm. Mosaic now smartly outputs only the tables that match your specific analysis needs. No more orphan second tranche of debt on that uni-tranche deal. No more M&A tables cluttering up a deal with no roll-up prospects. Every cell has a purpose, so you can focus on what matters.

Want to align it with your brand's aesthetics? Customize it with your firm’s unique colors and fonts.

4 - Stub Entry & Exit

10 out of 10 Investment Professionals agree – they’d rather stub a toe than stub a model. Those few bps of added precision require hours of focused work to layer in, and expose your model to a high risk of a mis-linking bust (i.e., should I stub interest in the cash flow schedule or the debt schedule? What about the tax schedules? How’s this going to impact my yields – surely those shouldn’t be stubbed? Nightmare).

Simply select your entry and exit dates and let Mosaic’s field-tested algorithm handle the table-stakes math. Just because you can do it, doesn’t mean you should.

5 - Enhanced Sensitivity Analysis

Step-up your scenario analysis with our enhanced sensitivity tables – now displaying MOIC, IRR, or both, shown to two decimal places for greater precision.

Additional Productivity Boosters

Because every second counts when you’re sprinting to the finish line – below are a handful of additional enhancements included in this release to make your life easier:

• Drive Net Working Capital as a balance or model the change directly

• Alternate between entering values as dollar amounts or margins with a click

• Navigate effortlessly using our intuitive hotkeys. Just hit ALT (or command on Mac) to pull up on-screen prompts:

Let us know what you think 📣

Mosaic has been built over the years by the collective intelligence of the private equity industry - specifically, by you, our users - through your thoughtful product feedback.

Your feedback is instrumental in helping us build a product that you'll continue to love far into the future. Please reach out if there is anything we can do to make your Mosaic experience even better.

That's all for now! Shoot us a note at support@mosaic.pe if you can think of anything else you'd like to see in Mosaic!