BLAXLAND CONSULTING LIMITED

𝗛𝗲𝗹𝗽𝗶𝗻𝗴 𝗶𝗻𝘃𝗲𝘀𝘁𝗼𝗿𝘀 𝗮𝗻𝗱 𝗽𝗼𝗿𝘁𝗰𝗼𝘀 𝘁𝗼 𝗱𝗲𝗹𝗶𝘃𝗲𝗿 𝘁𝗵𝗲 𝗩𝗖𝗣 – 𝗶𝗻𝗰𝗹𝘂𝗱𝗶𝗻𝗴 𝗺𝗶𝗱-𝘁𝗲𝗿𝗺 𝗿𝗲𝘃𝗶𝗲𝘄, 𝗮𝗻𝗱 𝗽𝗿𝗲-𝗲𝘅𝗶𝘁 𝗽𝗿𝗲𝗽𝗮𝗿𝗮𝘁𝗶𝗼𝗻 

Diane is a senior adviser to private equity portfolio companies.  She helps investors and portcos to deliver robust growth against value creation plans - including via post-merger integration.  She has a sweet spot in Tech-enabled B2B Services including Professional Services in the UK and EMEA.

Her experience includes:

- pre-deal MDD and post-deal operating reviews of portcos - eg for Blackstone, Mercia, Silverfleet, LDC, Rockpool, Foresight
- rapid recovery of post-merger integration and transformation, ahead of an IPO (backed by TPG)
- commercial risk analysis for a PE portco, triggering an exit via secondary buyout (backed by ICG)
- recovery of an off-shore proposition, re-positioning for growth ahead of a merger
- design and global rollout of a post-merger data integration model.

Her skills include P&L management, business strategy, sales, operations, business transformation, and change management – drawing on her experience in startups, scaleups and global business.

Founder

Career Coaching by Diane Blaxland

🚩 How will you know if my Career Coaching is right for you? Five quick signs: 

•	there is a gap emerging between your career and your satisfaction level 
•	addressing the gap is increasingly important to you 
•	there are risks if you do something, and risks if you do nothing 
•	you have some advice, but you want to take a wider, longer term view 
•	talking it through with an experienced executive feels like a good place to start 

#ExpertLeaders #Careers #PersonalDevelopment

Catalysis Advisory Ltd

𝗥𝗲𝗰𝗲𝗻𝘁 𝘄𝗼𝗿𝗸 𝗳𝗼𝗿 𝗣𝗘 𝗶𝗻𝘃𝗲𝘀𝘁𝗼𝗿𝘀 𝘄𝗶𝘁𝗵 𝗽𝗼𝗿𝘁𝗰𝗼 𝗕𝗼𝗮𝗿𝗱𝘀 𝗮𝗻𝗱 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁 𝘁𝗲𝗮𝗺𝘀 𝗶𝗻𝗰𝗹𝘂𝗱𝗲𝘀:
🔺 𝗽𝗿𝗲-𝗲𝘅𝗶𝘁 𝗿𝗲𝘃𝗶𝗲𝘄 - 𝗕𝟮𝗕𝟮𝗖 𝗙𝗶𝗻𝗧𝗲𝗰𝗵 (𝗘𝘂𝗿𝗼𝗽𝗲)
🔺 𝗽𝗼𝘀𝘁-𝗱𝗲𝗮𝗹 𝗺𝗶𝗱-𝘁𝗲𝗿𝗺 𝗿𝗲𝘃𝗶𝗲𝘄 - 𝗕𝟮𝗕 𝗥𝗲𝗮𝗹 𝗘𝘀𝘁𝗮𝘁𝗲 𝗽𝗿𝗼𝗳𝗲𝘀𝘀𝗶𝗼𝗻𝗮𝗹 𝘀𝗲𝗿𝘃𝗶𝗰𝗲𝘀
🔺 𝗽𝗿𝗲-𝗱𝗲𝗮𝗹 𝗕𝟮𝗕 𝗥𝗲𝗴𝗧𝗲𝗰𝗵, 𝗕𝟮𝗚𝟮𝗖 𝗛𝗲𝗮𝗹𝘁𝗵𝗧𝗲𝗰𝗵, 𝗕𝟮𝗕𝟮𝗖 𝗠𝗮𝗿𝗧𝗲𝗰𝗵, 𝗕𝟮𝗕𝟮𝗖 𝗺𝗮𝗻𝘂𝗳𝗮𝗰𝘁𝘂𝗿𝗶𝗻𝗴, 𝗕𝟮𝗚 𝗳𝗼𝗿𝗲𝗻𝘀𝗶𝗰 𝘁𝗲𝗰𝗵

Business Advisor

Johnson Controls Inc

$5b EMEA region of $20b Business Services division of $40b Fortune100 listed company

Director Change Management, EMEA

Blaxland Consulting

Advising clients on operational and commercial change.

CPA Global

£100m global Business Services company, backed by Private Equity

Director Strategy

Williams Lea

£20m Division of this £1b global Business Services company, part of DAX30 company DeutschePost

Managing Director 

Clifford Chance LLP

£100m+ M&A practice of this £1bn global Professional Services firm

Head Business Development Operations

Blake Dawson Waldron

A$350m international Professional Services firm (now part of £1b Ashurst LLP)

Business Development, Sales & Marketing management

CEO & Founder Expert Leaders™ | Career Direction & CV Coaching | £1B PSF | $40B Fortune100 | PE scaleups | London Business School

I help professionals step into clarity, confidence, and growth - especially when navigating complex career transitions in challenging or unfamiliar markets.

My clients are technically brilliant, ambitious … and many are internationally experienced. They’re often MBAs, engineers, M&A/finance experts, consultants, lawyers, or technology & data/AI specialists. 

They're ready to step into senior leadership, but something isn’t landing. Their pitch isn’t quite resonating. The growth opportunities they seek feel just out of reach.

That’s where I come in.

With more than 10 years in senior leadership - including as Managing Director responsible for 550 people - I’ve led growth, transformation, and turnaround across organisations from under £10m to over $5Bn. 

I’ve advised private equity investors and portfolio companies on operations, building robust solutions to complex problems. 

And I bring that same level of focus, clarity, and strategic thinking into my coaching practice.

My sweet spot lies in tech-enabled B2B services - including engineering, data/AI, finance, legal, and consulting. 

Highlights of my work include: 

▪️Steering post-merger integration for a $6Bn PE-backed global professional services firm, resolving operational failures, client complaints, and transformation across 15 countries.
▪️Leading the recovery of a £1bn NHS Trust’s lab project post-dispute, bringing together investors, clinicians, scientists, suppliers, and engineers to co-create a viable solution.
▪️Delivering commercial risk analysis that identified a -70% risk to a target exit valuation for a PE-backed £100m B2B services firm, unlocking a £1Bn exit in under three months.
▪️Repositioning a struggling new BPO offshore (India) proposition for profitable growth, delivering 50% savings to the client in a new £3m contract while also tripling profit margins.
▪️Rolling out a post-merger Sales/Marketing/Finance integration model for a £1Bn global professional services firm across 30 offices in 20 countries, deployed to 4,000+ staff.

All of that senior experience now feeds directly into my career coaching.

Many of my clients are mid-career or post-MBA, and sense a need to reframe their narrative, sharpen their presence, and navigate a system that may not easily understand their value. 

We don’t just talk. We rehearse. We edit. We test. We build influence from the inside out.

Whether you're preparing for interview, pitching for promotion, or making a full pivot, I’ll help you to tailor your story, build trust, and move forward with strategic clarity.

🎯 Diane Blaxland

👇50% off all Financial Modeling Courses this week only.

Theory is great until someone sends you 17 blurry PDFs and says "hey what's our business worth?"

This is the wake-up call that happens in the real world.

Businesses still need cash to operate, and they need profit if they eventually want to sell, but 9 times out of 10 the underlying data is a mess, and the "finance team" isn't sophisticated enough to build a forecast.

That's where YOU come in, right?  Just jump in and "stand up the model."

It's easy enough to understand on paper, but when you open that blank spreadsheet, suddenly, you can just freeze up.

Having spent over 15 years in Private Equity & FP&A, I know exactly how that feels.

When it's just you, some incomplete data, and AI isn't helping at all, how do you move forward?

That's where I can help -- I teach you to build (and own) the financial models that run real companies -- completely from scratch.

(𝘣𝘦𝘤𝘢𝘶𝘴𝘦 𝘵𝘩𝘢𝘵'𝘴 𝘵𝘩𝘦 𝘰𝘯𝘭𝘺 𝘸𝘢𝘺 𝘵𝘰 𝘳𝘦𝘢𝘭𝘭𝘺 𝘭𝘦𝘢𝘳𝘯, especially in an unstructured environment).

This is financial modeling in the real world.

🌐 𝗟𝗲𝗮𝗿𝗻 𝗺𝗼𝗿𝗲 𝗵𝗲𝗿𝗲 👉 https://www.financialmodelingeducation.com/ 


———

𝗥𝗲𝗰𝗼𝗴𝗻𝗶𝘁𝗶𝗼𝗻 𝗶𝗻 𝘁𝗵𝗲 𝗺𝗮𝗿𝗸𝗲𝘁:

🏆 Trusted by over 91,000 students with 4.9/5.0 Star average rating

🏆 Over 100,000 followers on LinkedIn & other social media platforms

🏆 Recognized by Business Insider and Financial Modeling World Cup

🏆 Featured by Wharton Online, Wall Street Prep, & LinkedIn Learning


———

𝗥𝗲𝘃𝗶𝗲𝘄𝘀 𝗳𝗿𝗼𝗺 𝗽𝗿𝗼𝗴𝗿𝗮𝗺 𝗮𝗹𝘂𝗺𝘀:

"𝘛𝘳𝘢𝘪𝘯𝘪𝘯𝘨 𝘪𝘴 𝘧𝘢𝘯𝘵𝘢𝘴𝘵𝘪𝘤..."
⭐⭐⭐⭐⭐

"𝘉𝘦𝘴𝘵 𝘮𝘰𝘯𝘦𝘺 𝘦𝘷𝘦𝘳 𝘴𝘱𝘦𝘯𝘵..."
⭐⭐⭐⭐⭐

"𝘈𝘣𝘴𝘰𝘭𝘶𝘵𝘦 𝘨𝘢𝘮𝘦 𝘤𝘩𝘢𝘯𝘨𝘦𝘳..."
⭐⭐⭐⭐⭐

"𝘉𝘦𝘴𝘵 𝘤𝘰𝘶𝘳𝘴𝘦 𝘐'𝘷𝘦 𝘵𝘢𝘬𝘦𝘯 𝘰𝘯𝘭𝘪𝘯𝘦..."
⭐⭐⭐⭐⭐

"𝘔𝘰𝘴𝘵 𝘤𝘰𝘮𝘱𝘳𝘦𝘩𝘦𝘯𝘴𝘪𝘷𝘦 𝘤𝘰𝘶𝘳𝘴𝘦 𝘐'𝘷𝘦 𝘵𝘢𝘬𝘦𝘯..."
⭐⭐⭐⭐⭐

"𝘐 𝘩𝘢𝘷𝘦 𝘵𝘢𝘬𝘦𝘯 𝘴𝘦𝘷𝘦𝘳𝘢𝘭 𝘮𝘰𝘥𝘦𝘭𝘪𝘯𝘨 𝘤𝘰𝘶𝘳𝘴𝘦𝘴, 𝘵𝘩𝘪𝘴 𝘰𝘯𝘦 𝘪𝘴 𝘵𝘩𝘦 𝘣𝘦𝘴𝘵..."
⭐⭐⭐⭐⭐

🌐 𝗟𝗲𝗮𝗿𝗻 𝗺𝗼𝗿𝗲 𝗵𝗲𝗿𝗲 👉 https://www.financialmodelingeducation.com/

Chris Reilly

So this is called the "pro forma balance sheet."  It's what a PE deal looks like right after the deal closes.  Here's how I model it... 👇

It's a 5-minute video on social media, no captions (sorry).

BUT...

This is 𝗼𝗻𝗲 𝗼𝗳 𝘁𝗵𝗲 𝗵𝗮𝗿𝗱𝗲𝘀𝘁 𝗽𝗮𝗿𝘁𝘀 of building an LBO model.

So it takes a little longer to explain and I didn't have room for captions.

So take a few minutes, turn the sound on, and learn to model the Pro Forma Balance Sheet.

𝙉𝙚𝙭𝙩 𝙎𝙩𝙚𝙥𝙨 ⤵️

📥 Grab the template 👉 https://lnkd.in/ex6BKa4E

Private equity & FP&A veteran that teaches you to build the financial models that run real companies | 🎓 91,000+ students

The 13-week cash flow is the lifeblood of the business.  Can we actually keep the lights on?  Here's how I'd start 👇


🕜 𝗧𝗶𝗺𝗶𝗻𝗴?

13 weeks, 4 weeks, 7 weeks?

Doesn't matter.

I just need a general sense of what cash will do in the short term.

When will I collect payments?

Can I pay vendors?

Can I make payroll?


😡 𝗔 𝗙𝗿𝘂𝘀𝘁𝗿𝗮𝘁𝗶𝗼𝗻

What drives me nuts about these forecasts?

They have become so overly "professionalized" that no one understands them.

I just want to know:

"What will my bank account look like next week?"

"How about two weeks from now?"

Enough of the fluff.


📚 𝗤𝘂𝗶𝗰𝗸 𝗦𝘁𝗮𝗿𝘁 𝗚𝘂𝗶𝗱𝗲

Open a spreadsheet and whip this thing together.

You build it like this:

1. Stuff that comes in

-- minus --

2. Stuff that goes out

= What you have left.

(repeat for next week)

(💡𝗽𝗿𝗼 𝘁𝗶𝗽: add "float" to your beginning balance = cut checks that haven't been cashed)


🖼️ 𝗣𝗶𝗰𝘁𝘂𝗿𝗲 𝗧𝗶𝗺𝗲

In the example image I'm focused on three things:

1. Mapping out the past

2. Making reasonable estimates about the future

3. Figuring out if I have shortfall (so I can do something about it 𝙣𝙤𝙬)


➕ 𝗘𝘅𝘁𝗿𝗮 𝗧𝗶𝗽𝘀

💡𝗣𝗿𝗼 𝘁𝗶𝗽 𝟭: Build a "cushion" line called "unknowns" to make things conservative

💡𝗣𝗿𝗼 𝘁𝗶𝗽 𝟮: forecast expenses early, receipts late (making it conservative)

💡𝗣𝗿𝗼 𝘁𝗶𝗽 𝟯: forget about weeks, just 𝗯𝘂𝗶𝗹𝗱 𝗶𝘁 𝗯𝘆 𝗱𝗮𝘆

(you can always summarize by week later)


🧠 𝗟𝗲𝗮𝗿𝗻 𝗶𝗻 𝗬𝗼𝘂𝗿 𝗦𝗽𝗮𝗿𝗲 𝗧𝗶𝗺𝗲

The best way to practice?

𝗦𝘁𝗮𝗿𝘁 𝘄𝗶𝘁𝗵 𝘆𝗼𝘂𝗿 𝗼𝘄𝗻 𝗹𝗶𝗳𝗲:

   + paycheck in

   - expenses out

Build a short forecast, maybe 4 weeks at most.

How'd you do?

If you were even 𝘥𝘪𝘳𝘦𝘤𝘵𝘪𝘰𝘯𝘢𝘭𝘭𝘺 close,

you have the raw skills to do this at the business level.


📌 𝗧𝗟;𝗗𝗥

   1. Map out history
   2. Make conservative estimates about the future
   3. Make a plan now


𝙉𝙚𝙭𝙩 𝙎𝙩𝙚𝙥𝙨 ⤵️

Here's a personal cash flow template to get you started.

📥 https://lnkd.in/edmwgYCv

Financial models can get insanely complicated, so I made this simple video to show how just ONE inventory purchase travels all the way through, which helps you visualize the cash conversion cycle 👇


✔️ 𝗧𝗵𝗲 "𝗥𝗲𝗴𝘂𝗹𝗮𝗿" 𝗔𝗽𝗽𝗿𝗼𝗮𝗰𝗵

Model Revenue & COGS first.

Then, calculate 𝘪𝘮𝘱𝘭𝘪𝘦𝘥 working capital using DSO, DPO, or DOH.


📙 𝗔𝗻𝗼𝘁𝗵𝗲𝗿 𝗪𝗮𝘆 𝘁𝗼 𝗗𝗼 𝗜𝘁

Model Inventory 𝗣𝘂𝗿𝗰𝗵𝗮𝘀𝗲𝘀 𝙛𝙞𝙧𝙨𝙩, and:

   - Watch it flow through AP
   - Then your Income Statement
   - And lastly through AR where cash is received


📝 𝗠𝘆 𝗳𝗮𝘃𝗼𝗿𝗶𝘁𝗲 𝗽𝗮𝗿𝘁?

This is a great way to 𝗹𝗲𝗮𝗿𝗻 𝗮𝗰𝗰𝗼𝘂𝗻𝘁𝗶𝗻𝗴 𝘁𝗵𝗿𝗼𝘂𝗴𝗵 𝗺𝗼𝗱𝗲𝗹𝗶𝗻𝗴, and also helps you "see" the cash conversion cycle over a few months.


𝙉𝙚𝙭𝙩 𝙎𝙩𝙚𝙥𝙨 ⤵️

I wish I could give away the model in this video but it's a half-broken WIP I use to create one-off lessons (like this one).

So here's the next-best thing: a guide to help you build the Balance Sheet.

📥 Grab it here: https://lnkd.in/ew4nwaVx

Here's a video on how I build direct and indirect cash flows in the 𝘴𝘢𝘮𝘦 financial model (and it's an awesome double-check) 👇


📘 𝗥𝗲𝗴𝘂𝗹𝗮𝗿 𝗪𝗮𝘆:

Normally, a three statement model uses the 𝗶𝗻𝗱𝗶𝗿𝗲𝗰𝘁 method only.

That means Net Income + 𝘤𝘩𝘢𝘯𝘨𝘦𝘴 in the Balance Sheet.


🔑 𝗧𝗵𝗲 "𝗧𝗿𝗶𝗰𝗸" 𝘁𝗼 𝘁𝗵𝗲 𝗗𝗶𝗿𝗲𝗰𝘁 𝗠𝗲𝘁𝗵𝗼𝗱:

How do I build both?

I use something called the "𝗕𝗔𝗦𝗘" or "𝗖𝗼𝗿𝗸𝘀𝗰𝗿𝗲𝘄" modeling technique, which works like this:

𝗕𝗲𝗴𝗶𝗻𝗻𝗶𝗻𝗴 𝗕𝗮𝗹𝗮𝗻𝗰𝗲
   (➕) Plus: [additions]
   (➖) Less: [subtractions]
𝗘𝗻𝗱𝗶𝗻𝗴 𝗕𝗮𝗹𝗮𝗻𝗰𝗲


📜 𝗔𝗥 𝗘𝘅𝗮𝗺𝗽𝗹𝗲:

So for Accounts Receivable it would be:

𝗕𝗲𝗴𝗶𝗻𝗻𝗶𝗻𝗴 𝗔𝗥
   (➕) Plus: Revenue
   (➖) Less: Cash Receipts
𝗘𝗻𝗱𝗶𝗻𝗴 𝗔𝗥


🔁 𝗛𝗼𝘄 𝗜𝘁 𝗟𝗶𝗻𝗸𝘀 𝘁𝗼 𝗬𝗼𝘂𝗿 𝗠𝗼𝗱𝗲𝗹

You can 𝗹𝗶𝗻𝗸 𝘁𝗵𝗲 𝗰𝗮𝘀𝗵 𝗽𝗼𝗿𝘁𝗶𝗼𝗻 of these BASE accounts to your direct method cash flow.

This makes the overall cash section so much easier to understand and also serves as a great way to double-check the structure of your model.

I've been putting this "direct method double-check" into every model I build.


𝙉𝙚𝙭𝙩 𝙎𝙩𝙚𝙥𝙨 ⤵️

📥 𝗦𝘁𝗮𝗿𝘁: Grab this indirect one-pager › https://lnkd.in/ez9Af7er 

🎓 𝗔𝗱𝘃𝗮𝗻𝗰𝗲: Join 91k+ students › https://bit.ly/FMECourses

My simple process for refreshing Actuals each month (helpful if you're the person who "owns the model") 👇


𝗞𝗲𝗲𝗽 𝗶𝘁 𝘀𝗶𝗺𝗽𝗹𝗲:

It all starts with an IF trigger - a formula that identifies whether we're looking at "Actual" results or still in "Forecast" mode.

If Actuals are available, it pulls directly from the Chart of Accounts (its own tab).

If not, it uses the forecast formula.

I control this through a LATEST_ACTUALS named range on my control panel.

That way, one simple date change updates the entire model.


𝗟𝗼𝗴𝗶𝗰 𝗳𝗹𝗼𝘄:

This logic flows through everything:

- Income Statement updates based on actuals
- Balance Sheet pulls new actual data
- Cash Flow Statement is automatic (indirect method)
- Support schedules adjust accordingly


𝗪𝗮𝗶𝘁... 𝗶𝘀 𝘁𝗵𝗶𝘀 𝗿𝗶𝗴𝗵𝘁?

Most importantly, I always include validation checks on my Control Panel to ensure everything reconciles properly.

- Does net income match QuickBooks?
- Does the balance sheet balance?
- Does ending cash match?


𝗣𝘂𝗻𝗰𝗵𝗹𝗶𝗻𝗲:

The beauty of this system is its simplicity:

↳ Formulas do the heavy lifting
↳ Built-in validations catch errors
↳ No manual data entry needed
↳ One trigger cell controls everything

Hope this helps 🙂.


𝙉𝙚𝙭𝙩 𝙎𝙩𝙚𝙥𝙨 ⤵️

If you want help mapping out a model, grab this checklist.

📥 https://lnkd.in/eVTU67fY

I still see this mistake 𝘢 𝘭𝘰𝘵, so I just want to drive home the fundamentals on building the balance sheet / SCF 👇


❌ 𝗙𝗶𝗿𝘀𝘁, 𝘁𝗵𝗲 𝗺𝗶𝘀𝘁𝗮𝗸𝗲:

Using the Statement of Cash Flows to 𝗿𝗲𝘃𝗲𝗿𝘀𝗲 𝗲𝗻𝗴𝗶𝗻𝗲𝗲𝗿 the Balance Sheet.

That's a "no no."

I see it most often in the Cash from Investing section.

For example, if someone knows they're going to spend $10,000 on new equipment:

1. They'll add $10,000 to the Cash Flow Statement first, and 𝘵𝘩𝘦𝘯;

2. Add that amount to the Fixed Assets account in the Balance Sheet


👎 𝗧𝗵𝗲 𝗗𝗼𝘄𝗻𝘀𝗶𝗱𝗲

It's not "wrong" from an 𝗮𝗰𝗰𝗼𝘂𝗻𝘁𝗶𝗻𝗴 perspective.

That's actually fine, but...

It will likely mess you up from a 𝗺𝗼𝗱𝗲𝗹𝗶𝗻𝗴 perspective.

Once you've got stuff from the balance sheet going to the cash flow statement 𝘢𝘯𝘥 vice versa, it's very likely you will create an error or unintended circular reference.


✅ 𝗛𝗲𝗿𝗲'𝘀 𝘁𝗵𝗲 𝗰𝗼𝗿𝗿𝗲𝗰𝘁 𝘄𝗮𝘆 𝘁𝗼 𝗱𝗼 𝗶𝘁:

1. Build the Income Statement

2. Build the Balance Sheet

3. 𝘛𝘩𝘦𝘯 build the Statement of Cash Flows (using the "indirect method")

What do I mean by the "indirect method"?

It means you refer to items that 𝘢𝘭𝘳𝘦𝘢𝘥𝘺 𝘦𝘹𝘪𝘴𝘵 in your Income Statement and Balance Sheet, and calculate the difference b/t time periods.

It works like this:

= Net Income (from Income Statement)

+ D&A (from Income Statement)

+/- the 𝘤𝘩𝘢𝘯𝘨𝘦 𝘪𝘯 Assets, Liabilities, & Equity


➕ 𝗔𝘀𝘀𝗲𝘁𝘀

For Assets, it's the previous period minus the current period

(i.e., January's ending AR balance minus February's ending AR balance)


➖ 𝗟𝗶𝗮𝗯𝗶𝗹𝗶𝘁𝗶𝗲𝘀

For Liabilities, it's the current period minus the previous period

(i.e., February's ending AP balance minus January's ending AP balance)


🟰 𝗘𝗾𝘂𝗶𝘁𝘆

For Equity, it's the current period minus the previous period (same as Liabilities)

(i.e., February's ending Contributed Capital balance minus January's ending Contributed Capital balance)


⚠️ 𝗢𝗻𝗲 𝗘𝘅𝗰𝗲𝗽𝘁𝗶𝗼𝗻

The only exception to this rule is Fixed Assets, where you will also pull out the Depreciation because it's 𝘢𝘭𝘳𝘦𝘢𝘥𝘺 captured in the Cash from Operations.

(i.e., January's ending Fixed Asset balance minus February's ending Fixed Asset balance 𝘮𝘪𝘯𝘶𝘴 𝘍𝘦𝘣𝘳𝘶𝘢𝘳𝘺'𝘴 𝘋𝘦𝘱𝘳𝘦𝘤𝘪𝘢𝘵𝘪𝘰𝘯)


𝙉𝙚𝙭𝙩 𝙎𝙩𝙚𝙥𝙨 ⤵️

📥 𝗦𝘁𝗮𝗿𝘁 𝗵𝗲𝗿𝗲: one-pager download: https://lnkd.in/ez9Af7er 

🎓 𝗚𝗼 𝗱𝗲𝗲𝗽𝗲𝗿: master the full skillset: https://bit.ly/FMECourses

A short one-pager to explain "GRR" (Gross Revenue Retention) in SaaS 👇


𝗚𝗥𝗥 𝟭𝟬𝟭

GRR or "Gross Revenue Retention" is a common metric used in SaaS companies.

I like to think of it as, "here's how much ARR I have left after accounting for Downsells and Churn."

You're basically seeing how much your Revenue shrunk without accounting for anyone who might have upgraded (via an Upsell).

It's expressed as a percent, so the basic formula is:

(Beginning ARR - Downsells - Churn) / Beginning ARR


𝗤𝘂𝗶𝗰𝗸 𝗘𝘅𝗮𝗺𝗽𝗹𝗲

So if ARR looked like this:

Beginning ARR     $100,000
+ Upsells                $10,000
- Downsells            ($5,000)
- Churn                   ($3,000)
Ending ARR           $102,000

Then GRR would be:

GRR = ($100,000 - $5,000 - $3,000) / $100,000

GRR = $92,000 / $100,000

GRR = 92%


𝗦𝗮𝗶𝗱 𝗦𝗶𝗺𝗽𝗹𝘆...

"I only have 92% of the Recurring Revenue I started with."

 
𝗦𝗼 𝗪𝗵𝗮𝘁...?

Then, to actually do something about it, the next thing you'd ask is "why?"

Reach out to the customers, get the story, and hopefully make some changes in the future.


𝙉𝙚𝙭𝙩 𝙎𝙩𝙚𝙥𝙨 ⤵️

When it's time to take 𝘢𝘤𝘵𝘪𝘰𝘯 on what to do, this guide can help:

📥 Data storytelling guide: https://lnkd.in/dCt-P3Na

This remains my favorite "tagging" technique when building time-series models. Awesome guide that Jason Hershman put together 👇


Having trouble tagging him, but Jason Hershman put this together (https://bit.ly/PointFPA) -- he's a long-time modeler and fellow FTI Consulting alum.


𝗔 𝗳𝗿𝗲𝗾𝘂𝗲𝗻𝘁 𝗶𝘀𝘀𝘂𝗲 / 𝗾𝘂𝗲𝘀𝘁𝗶𝗼𝗻 𝗜 𝘀𝗲𝗲:

"𝘏𝘰𝘸 𝘤𝘢𝘯 𝘐 𝘣𝘶𝘪𝘭𝘥 𝘵𝘩𝘦 𝘮𝘰𝘥𝘦𝘭 𝘲𝘶𝘢𝘳𝘵𝘦𝘳𝘭𝘺 𝘰𝘳 𝘢𝘯𝘯𝘶𝘢𝘭𝘭𝘺?"


Here's the catch: you DON'T build it by quarter.

You 𝙗𝙪𝙞𝙡𝙙 𝙞𝙩 by month and then 𝙨𝙪𝙢𝙢𝙖𝙧𝙞𝙯𝙚 by quarter, year, etc.

You do this by building the "hooks."

Jason illustrates this on Slide 7 (sometimes called "tags" as well).

Those additional rows act as reference points for rolling into a larger summary.


𝗦𝘂𝗺𝗺𝗮𝗿𝗶𝘇𝗶𝗻𝗴

From there you can use SUMIFS, INDEX/MATCH, XLOOKUP, SUMPRODUCT to 𝙥𝙧𝙚𝙨𝙚𝙣𝙩 your data in a different format such as quarterly or annually.

But most importantly, you still have your detailed monthly model sitting underneath it all.


💡𝗣𝗿𝗼 𝗧𝗶𝗽: Fiscal vs Calendar year

If your 𝗳𝗶𝘀𝗰𝗮𝗹 𝘆𝗲𝗮𝗿 differs from your 𝗰𝗮𝗹𝗲𝗻𝗱𝗮𝗿 𝘆𝗲𝗮𝗿...

1. Create a lookup/mapping tab that maps calendar dates to fiscal dates, then;

2. Using a lookup function, you add the fiscal dates as another "hook" to the model

(i.e., another row as shown on Slide 7).

✓ This allows you to 𝘀𝘂𝗺𝗺𝗮𝗿𝗶𝘇𝗲 𝘆𝗼𝘂𝗿 𝗺𝗼𝗱𝗲𝗹 𝗯𝘆 𝗳𝗶𝘀𝗰𝗮𝗹 𝘆𝗲𝗮𝗿.


𝙉𝙚𝙭𝙩 𝙎𝙩𝙚𝙥𝙨 ⤵️

📥 Grab a copy here: https://bit.ly/excel-hooks

Building Excel tags/hooks to summarize your model

My first Private Equity interview started at 9am, 𝗲𝗻𝗱𝗲𝗱 𝗮𝘁 𝟭𝟬𝗽𝗺, and was a head-to-head competition with someone else 👇


𝗣𝗮𝗿𝘁 𝟭:

The day started normal enough: show up wearing "the suit," feeling jitters.

Told there was an "accidental schedule conflict," so I'd be interviewing alongside another candidate.

(deliberate of course, but I didn't realize it at the time).

Weird, I thought, but I just said "okay" and kind of moved on.

Regular day from there -- conversations with the team and a modeling test.

(I could 𝘯𝘰𝘵 get my balance sheet to balance, btw 🫠)


𝗣𝗮𝗿𝘁 𝟮:

We moved to dinner and drinks, much more casual.

But with another candidate there, I'm left wondering...

  - Am I saying enough?
  - Is he sounding smarter than me?

I've always been super introverted, so while I can "turn it on" in those social settings, it's not my comfort zone.


𝗣𝗮𝗿𝘁 𝟯:

The Partners "call it a night," and we head to the bar with the Associates.

The other candidate invites a girl to the bar, then kind of disappears.

I sat and talked with the Associates most of the time.

Eventually, we got an Uber back to my hotel, said thanks and goodbye, and parted ways.

I had no idea "how I did," but in my gut felt like it was decent that I at least finished the night with team members.

(and they were cool guys, so it was easy).


𝗣𝗼𝘀𝘁 𝗴𝗮𝗺𝗲:

I eventually got the job.

I'll never truly know how "well I did" vs the other guy, but since I submitted a busted model (🙃) , I have to assume the fit was better.‍


𝗧𝗵𝗲 𝗷𝗼𝗯 𝗶𝘁𝘀𝗲𝗹𝗳

It turned out to be really hard (at least for me).

I wasn't prepared for the hours or the travel schedule.

(I came from a more "comfy" 9-5 FP&A role).

Honestly, it was too much for me at times.

But, 𝗜 𝗹𝗲𝗮𝗿𝗻𝗲𝗱 𝗮 𝗧𝗢𝗡.  There was more growth in that one role than there was anywhere else in my career (other than going out on my own).

It's also why I created a modeling program: to help people learn faster and not struggle like I did: https://bit.ly/FMECourses 


𝗟𝗲𝘀𝘀𝗼𝗻𝘀 𝗹𝗲𝗮𝗿𝗻𝗲𝗱:

1️⃣ A huge part of PE is 𝘩𝘰𝘸 𝘺𝘰𝘶 𝘩𝘢𝘯𝘥𝘭𝘦 𝘺𝘰𝘶𝘳𝘴𝘦𝘭𝘧 𝘸𝘩𝘦𝘯 𝘵𝘩𝘪𝘯𝘨𝘴 𝘢𝘳𝘦 𝘶𝘯𝘦𝘹𝘱𝘦𝘤𝘵𝘦𝘥.

   - the "double booking"
   - unplanned travel
   - long hours

2️⃣ Also, 𝘩𝘰𝘸 𝘥𝘰 𝘺𝘰𝘶 𝘩𝘢𝘯𝘥𝘭𝘦 𝘺𝘰𝘶𝘳𝘴𝘦𝘭𝘧 𝘴𝘰𝘤𝘪𝘢𝘭𝘭𝘺?

Modeling skills get you in the door, but a huge part is spending time on the road meeting management teams.

That means all different types of personalities.

You need some level of EQ to build a partnership.

And although the travel was a lot for me, I loved the time onsite.

Meeting the entrepreneurs ultimately inspired me to do my own thing.


𝗣𝘂𝗻𝗰𝗵𝗹𝗶𝗻𝗲

PE is no joke, but it can be a really fulfilling career if you can find a good team and build genuine, human relationships with your portfolio companies.

I put this guide together as one small tool that can help.

📥 https://lnkd.in/ewh-x6_k

Private Equity Interview Guide

My quick thoughts on AI & financial modeling:

- AI is great in 𝗲𝘅𝗽𝗲𝗿𝗶𝗲𝗻𝗰𝗲𝗱 hands

- Experience can interpret what AI builds (and spot any mistakes)

- You gain this experience “the hard way,” building models from scratch

- By doing so, not only do you gain technical skills (Excel, etc.)…

- You 𝘭𝘦𝘢𝘳𝘯 𝘵𝘩𝘦 𝘣𝘶𝘴𝘪𝘯𝘦𝘴𝘴 along the way (which is ultimately your job)

AI can definitely save you time on the front end, but you’ll likely use that same time on the backend (1) interpreting/auditing the model and (2) learning the business.

That’s why I still prefer using the time to build by hand.  The total net time may be greater, but I’ll understand more.

𝗣𝗲𝗿𝘀𝗼𝗻𝗮𝗹 𝘀𝘁𝗼𝗿𝘆: taught myself to build a ROU Asset / Operating Lease with AI in a client model.  It worked because I already knew the underlying finance and accounting — my experience allowed me to take advantage of the tool.

I think the professionals best-suited for the future will have the foundation of old school learning coupled with new school tools.  That’s the edge.


𝗔𝗻𝗱 𝗮𝘀 𝗮 𝗻𝗲𝘅𝘁 𝘀𝘁𝗲𝗽...

If you're building a model from scratch, sometimes it's hard to know where to start.

📥 This checklist can help: https://lnkd.in/eVTU67fY

Which of the following is 𝘯𝘰𝘵 part of Cash from Investing Activities?

Take the full quiz here 👉 https://lnkd.in/eccYpT-R

Which of the following is not part of Cash from Investing Activities?

The author can see how you vote. Learn more

taplio

The Battle

🎯 Diane Blaxland

Chris Reilly

Followers

Posts

Engagements

Likes

Performance ScoreChris Reilly's LinkedIn Performance

Ready to grow your LinkedIn presence?

taplio

The Battle

🎯 Diane Blaxland

Chris Reilly

Followers

Posts

Engagements

Likes

Performance Score.css-goub6s{font-size:var(--chakra-fontSizes-md);font-weight:500;color:var(--chakra-colors-gray-600);display:block;margin-top:var(--chakra-space-1);}Chris Reilly's LinkedIn Performance

Ready to grow your LinkedIn presence?

Performance ScoreChris Reilly's LinkedIn Performance