Blog
Unlocking Advanced Excel: Using INDEX/MATCH with Multiple Columns
In today's data-driven environment, mastery of Excel is a non-negotiable skill. While functions like VLOOKUP and HLOOKUP are widely known, professionals... more ยป
The Art of Financial Modeling: Understanding and Leveraging the Revolver Schedule
In a previous post, I introduced the concept of the 'Revolver Schedule' in financial modeling. If you recall, a Revolver is a term we use to describe a... more ยป
Here's what an Adjusted EBITDA schedule looks like...
Here's what an Adjusted EBITDA schedule looks like:First though -- what are we building here?Adj EBITDA = an APPROXIMATION of the free cash flow of a... more ยป
Mastering Inventory Forecasting: A Practical Guide for FP&A and Private Equity Professionals
What is Inventory? In the simplest terms, Inventory is the stuff you're trying to sell. It is usually recorded as a current asset on the balance sheet.... more ยป
One my favorite little Excel tricks
One my favorite little Excel tricks:๐ฆ๐ถ๐ป๐ด๐น๐ฒ ๐๐ฐ๐ฐ๐ผ๐๐ป๐๐ถ๐ป๐ด format.It lets you add just the tiniest little space b/t your headers for a much cleaner look.Ta... more ยป
Anyone Designing FP&A Software Please Check This Out
Anyone designing FP&A software please check this out:Something I constantly run into in the Private Equity world is the concept of "add-backs."Meaning,... more ยป
11 abbreviations I thought might be helpful to clear up
11 abbreviations I thought might be helpful to clear up:โผ๏ธFP&A: Financial Planning & Analysis๐ ๐ค๐ข๐ฏ ๐ด๐ต๐ช๐ญ๐ญ ๐ฉ๐ฆ๐ข๐ณ ๐ฎ๐บ ๐ฅ๐ข๐ฅ, "๐๐ฉ๐ณ๐ช๐ด ๐ธ๐ฉ๐ข๐ต'๐ด ๐๐&๐ ๐ด... more ยป
An easy way to forecast capex
An easy way to forecast capex ↓Here's my favorite part about the budgeting process:It's late October... Revenue and EBITDA look good,you're about... more ยป
And here's another time I was completely stumped in private equity...
And here's another time I was completely stumped in private equity...We're all standing around the conference table and the partner says,"we can probably... more ยป
How does someone make money in private equity?
How does someone make money in private equity?I mean beyond base salary anyway?The primary upside for someone in Private Equity is called "carried... more ยป
Ever googled directions to the airport?
Ever googled directions to the airport?How many routes do you get?Two?Three?Is one the clear choice?Usually. But — do they all get you there within... more ยป
A beautiful, yet tricky, part of the modeling equation...
A beautiful, yet tricky, part of the modeling equation...What are the ๐ฆ๐ผ๐๐ฟ๐ฐ๐ฒ๐ & ๐จ๐๐ฒ๐?๐ญ๐ผ๐ผ๐บ ๐ข๐๐: the Sources & Uses show ๐ฉ๐ฐ๐ธ a company is purcha... more ยป
Semi-controversial statement...
Semi-controversial statement:(well, controversial for Excel at least...)I'm actually not a huge fan of "input pages."In some instances, sure, like:-- Model start date--... more ยป
Your ๐๐๐ฒ๐ป๐ถ๐ป๐ด ๐๐ ๐ฐ๐ฒ๐น๐ฒ๐ฟ๐ฎ๐๐ผ๐ฟ โ one Excel tip to boost your financial modeling skills.
Your ๐๐๐ฒ๐ป๐ถ๐ป๐ด ๐๐ ๐ฐ๐ฒ๐น๐ฒ๐ฟ๐ฎ๐๐ผ๐ฟ — one Excel tip to boost your financial modeling skills.Tonight's Topic:๐๐๐ถ๐ป๐ด ๐ก๐() ๐ถ๐ป ๐๐ผ๐๐ฟ ๐ฐ๐ต๐ฎ๐ฟ๐๐Ever wish you could sh... more ยป
Modeling a detailed Private Equity waterfall
How to model a private equity waterfall. I see this modeled incorrectly all the time. Enterprise Value or "EV" aka the price/value of the... more ยป
Is that all you ever want to do, modeling?
Is that all you ever want to do, modeling?I've heard that a lot. Modeling, for some reason, is dismissed as a "junior skill."I struggled with it for a... more ยป
Want to simplify your Excel model?
Want to simplify your Excel model?Try rebuilding it in Google Sheets. I'll bet you cut out 1/2 of the noise. I've done some GS lately and while it's... more ยป
New to the workforce? These 3 things will make your life so much easier
New to the workforce? These 3 things will make your life so much easier:1. Confirm receiptI'm not asking you sit by your phone. Just let me know when... more ยป
Thinking of selling your business?
Thinking of selling your business?Here's what used to drive me nuts when I looked at deals in private equity:๐ต ๐ก๐ผ ๐ฏ๐ถ๐ด ๐ฝ๐ถ๐ฐ๐๐๐ฟ๐ฒ ๐ฐ๐น๐ฎ๐ฟ๐ถ๐๐โช๏ธ Assume that I... more ยป
That model you just sent out... did you check it for errors?
That model you just sent out... did you check it for errors?...how closely?I hate to break it to you, but 90% of all spreadsheets contain errors.That's an... more ยป
10 Ways to Prepare if You're a CFO that Might Get Acquired
CFOs... if you might be acquired, here are 10 ways to prepare (having looked at several PE deals over the years): 1. Company Financials Might seem obvious,... more ยป
I'm pretty good at Excel...
I'm pretty good at Excel,but did you know I only use 2 "advanced" formulas?Don't get me wrong,Excel's got some ๐ข๐ฎ๐ข๐ป๐ช๐ฏ๐จ functionality.But, I still find a... more ยป
A Gantt Chart of the Private Equity Deal Process...
1. Review the Investment Teaser Examine the initial pitch highlighting the company's value proposition. 2. Sign NDA Protect sensitive information with a... more ยป
Your ๐๐ฒ๐๐ฒ๐ฟ๐ฎ๐ด๐ฒ๐ฑ ๐๐๐-๐๐ป โ demystifying Private Equity one term at a time.
Your ๐๐ฒ๐๐ฒ๐ฟ๐ฎ๐ด๐ฒ๐ฑ ๐๐๐-๐๐ป — demystifying Private Equity one term at a time.Tonight's term:"๐ฝ๐น๐ฎ๐๐ณ๐ผ๐ฟ๐บ"———When a private equity firm... more ยป
Everyday I use Excel, Krisp, Loom, & Zoom
Everyday I use Excel, Krisp, Loom, & Zoom,but lately I've been doing the unthinkable...I've been printing my models.On...... PAPER.... more ยป