Blog
Mastering Financial Modeling: Essential Best Practices Part 1
What are Financial Modeling Best Practices? Modeling "best practices" simply means building your model in such a way that is organized, understandable,... more »
What's a Financial Model?
"The Year Was..." I'll never forget my early days on the job. "Excel" was one thing. But "Financial Modeling" was something else. Some elusive,... more »
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 »