Best Advanced Financial Modeling Course?

I work at a small PE firm who wants to send myself (2nd yr analyst) and an Associate (MBA grad) to an advanced modeling course. We both have solid modeling and excel skills, but need to be fine-tuned. What are the top advanced modeling courses out there that would fit our experience?

I know there are plenty of beginner courses, but we need something a little more advanced that is worth the expense and work time lost. Any thoughts?

Edit: I've looked into Training the Street which appears to have a solid 5-day program, but hard to tell looking at a brochure.

 

They were wanting something a little more in depth and intense with in-person classes. Essentially, because my PE shop is pretty small, they do not have their own standardized practices. We are going to attempt to take the best of what we learn and establish the framework going forward.

 

TMA does some sweet online seminars about cash flow modeling that could be useful... got exposure to it through the firm I interned with this summer, definitely helpful stuff outside of the normal realm of IB/PE modeling

'Before you enter... be willing to pay the price'
 

they are all fine (a few of them are identical) - how in depth do you want to get? i think you should get the investment banking book by rosenbaum and pearl for the best / economical combination of self study materials.

in all honesty, there's only so much these training programs will teach you. its the on the job training that really teaches you.

------------ I'm making it up as I go along.
 

Yep, I have that book. The LBO model there is pretty good, probably the best section of the book.

But I feel it's still not enough. I'm looking to go deep into certain topics not covered in usual modeling courses (taxes, NOLs, PP&E schedules, etc., all done in LBOs and normal mergers). I've got the general aspect of A/D and LBO down more or less.

 

In all honesty:

  • as far as commonly used excel functionality, thats something you'll learn with experience. Someone can list offsets, match, choose, etc... but you wont really need it until you come to a point where you need to do something specific and figure it out on your own.

  • IMO, there is nothing sophisticated about alternate scenarios. You've got your base case which is founded on a plethora of assumptions which are determined on a case by case situation. The downside case may just be EBITDA margins capped at historical levels as opposed to the very optimistic levels forecasted in the base case, or EBITDA margins/rev growth achieving historic levels at terminal year and trended between now and then. Or EBITDA margins taken down for X, Y, Z consideration, you get the hint.

An easy way to build a downside case is to take a basket of Wall Street analyst reports(which may or may not be hard to come by depending on the resources available to you) and have a mean EBITDA margin and Revenue growth for an industry, or even for your specific subject company if its well covered. In crude terms, you have your base case which you came up with in Oct 08, you take the mean analyst Rev and EBITDA margin from Oct analyst reports, and you take the mean from most recent analyst reports and proportionally adjust your forecasts downward for the appropriate periods depending on how Wall St analysts future expectations have changed. Thats a simple method for your purposes (I'm assuming you a college student trying to teach yourself).

  • Deal structures can be very very made to order. I read a book when I was in college published by Harvard Business review, it was called.... HBS: Mergers & Acquisitions, a round table discussion... I think, I could be wrong. It was good for my purposes at that time.

  • lbo models... Damadoran has a simple lbo model on his site, I took it apart while I was in college and didn't learn much from it, but thats me. A self-study or prep course may be best for this.

IMO, the absolute best way to learn this stuff is to look at SEC filings and press releases of actual deals that are going on and try to model them. That will teach you a lot, especially in terms of deal structure/stragey. And it will bring you to a point where you need to learn how to do certain things and learn how to be efficient in excel and otherwise.

 

thx for the feedback so far guys.

excel functionality: I know what you mean, but thats exactly why when I come to that point where I need to look up on how to do a certain thing, I would like a decent book where it shows me how a corporate finance issue can be efficiently modelled making use function x (that function being one which I probably previously didnt even know existed)....I'm not interesseded in modelling portfolios, bonds, complex options, etc many Excel books discuss.

Downside scenario: thx for the insight...it adresses how you would directly adjust EBITDA margin sensibly in a downside case...however I was thinking more alongside the structural step by step development of a downside case...ideally you would want to arrive at EBITDA by adjusting top line, capex, etc. etc..

deal structure: do you mean this one?

http://www.Amazon.com/Harvard-Business-Review-Mergers-Acquisitions/dp/1578515556/ref=pd_bbs_sr_1?ie=UTF8&s=books&qid=1231424065&sr=8-1

lbo models: could it really be that there is no proper material out there that covers LBO modelling in detail?? (i.e. for use in PE)

another issue I have:

all those introductory materials, such as dealmaven, WSPREP, etc...are ok for getting passed the interview stage i.e. superficially....but many blantly treat as an exapmle Net debt as: Debt-Cash. ....a highly simplistic approach...what about a text which goes into proper detail i.e. talking about debt like items to watch out for e.g. unfunded pension obligations...or informs the reader that cash positions need to be adjusted for trapped cash, etc... So what I am more talking about is: developing the ability to intelligently discuss/apply financial Issues/structures with MDs, helping in not only executing but also making my own suggestions...there must be something which assists this process, can't be that you can only wait to till an issue comes along on the job...

Thx for your help guys!

 

Excel is made with a very broad range of applications. Outside of IRR, NPV, PV, and FV functions there isn't anything that address corporate finance.

Structurally making a downside case, anchor certain variables to the appropriate assumptions (WC as a % of sales etc...) You'd be surprised at how few adjustments (atleast I've seen) are made for a downside case. In a downside case you should slant revenues downward, squeeze margins, and reduce discretionary cash outflow(reduce CapEx, eliminate optional amortization, decrease minimum cash balance if possible), simplified: yes, adequate: yes.

The other stuff you're talking about, yes the only way to learn it is on the job. No one on this board can teach it to you in a thread, nor will you be able to make any suggestions that aren't vocally or silently laughable, having never worked on a deal in your life.

It seems like you have a good understanding so far, if you're trying to get a leg up in interviews, what you know seems to be adequate so long as your comfortable talking about it. You will NEVER be able to make any suggestions to an MD about how to deal with a facet of a deal in an interview having never worked in IBD. Most likely you'll end up in over your head and either the interviewer will feel like "ok, atleast you knew more than most" or you will really rub them the wrong way by acting like a know-it-all and not being able to back it up. None of this stuff is really sophisticated stuff, its just stuff you learn through experience.

If you're interviewing, knowing this stuff shows a higher level of interest and initiative. Once you know more than most, as it seems you already do, you already accomplished that and by attempting to discuss it in any further detail opens you up to get blown out of the water, like interviewers like to do when a candidate starts talking about stuff he/she marginally understands. Truth be told, until you've done a deal, you marginally understand it, no matter how many books you've read.

Career Advancement Opportunities

March 2024 Private Equity

  • The Riverside Company 99.5%
  • Warburg Pincus 99.0%
  • Blackstone Group 98.4%
  • KKR (Kohlberg Kravis Roberts) 97.9%
  • Bain Capital 97.4%

Overall Employee Satisfaction

March 2024 Private Equity

  • The Riverside Company 99.5%
  • Blackstone Group 98.9%
  • KKR (Kohlberg Kravis Roberts) 98.4%
  • Ardian 97.9%
  • Bain Capital 97.4%

Professional Growth Opportunities

March 2024 Private Equity

  • The Riverside Company 99.5%
  • Bain Capital 99.0%
  • Blackstone Group 98.4%
  • Warburg Pincus 97.9%
  • Starwood Capital Group 97.4%

Total Avg Compensation

March 2024 Private Equity

  • Principal (9) $653
  • Director/MD (21) $586
  • Vice President (92) $362
  • 3rd+ Year Associate (89) $280
  • 2nd Year Associate (204) $268
  • 1st Year Associate (386) $229
  • 3rd+ Year Analyst (28) $157
  • 2nd Year Analyst (83) $134
  • 1st Year Analyst (246) $122
  • Intern/Summer Associate (32) $82
  • Intern/Summer Analyst (313) $59
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Betsy Massar's picture
Betsy Massar
99.0
3
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
DrApeman's picture
DrApeman
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
kanon's picture
kanon
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”