Models from advisors that aren't linked

Still new to PE, and I got a hardcoded model from a sell-side advisor. They have a linked model (i.e. they broke the links and gave us the resulting output) but will only release the linked version to those who make it past NBO stage. 2 questions occurred to me:

1. Is this a common practice based on anyone's experience? And if so, what's the rationale? For context, I'm based in Asia.

2. How do folks here deal with such models? Do you re-build your own linked version, or try to link the version you got? If you're doing the latter, any advice on doing so efficiently, especially for models that are detailed?

4 Comments

chihayafull

PE

4y

Most Helpful

This is common, and it's to "limit information flow" so you don't get the finer details about the actual model drivers and how they flow through. The only practical effect of this is that it makes your life as an associate harder and makes your NBO less informed. That being said, if I was the CEO of the Company I also wouldn't wanna blast out a fully detailed business plan to 30+ sponsors, so I get it.
If the business model is straightforward (e.g., limited segments, MRR bookings flows down to revenue, etc), then it should be simple to re-link, you probably have to build your own KPI drivers tab with implied metrics and then flow it through the sell-side model. If it's a super detailed hard-coded model (even if not hardcoded), then I tend to re-build the whole thing and collapse detailed line items into groups.
1. Example 1: Company operates on subscriber-based MRR model, you only know current subscriber count, but you get hardcoded svc revenue projection. You now have a proxy for ARPU, and you can make assumptions around ARPU growth, use that to imply net subs growth, and you can take a stab at gross adds versus churn. It'll never be clean or exact but it's a good proxy.
2. Example 2: Company projects out 5 business segments with 10 SKUs each and you don't know the difference/won't get that detail in a first round. Just rebuild and collapse into a blended business segment-level view first with implied KPIs as noted above. Should give you a good high-level "what do you need to believe" without getting yourself lost in the sauce

Reply

Quote

Report

Other

Authored by: Certified Private Equity Professional - 2nd Year AssociateCertified Private Equity Pro

IB

Analyst 1 in IB - Gen

4y

This is helpful thanks

Reply

Quote

Report

Other

Authored by: Certified Private Equity Professional - 1st Year AssociateCertified Private Equity Pro

pierheld

?

4y

Cheers, very helpful. Just bugs me cos it doesn't feel like a good use of one's time to have to re-link or re-build a model.

When you started out in PE, were you given guidance on when to relink/rebuild, or was it a sense you built up yourself over time/based on your banking experience?

Reply

Quote

Report

Other

OverlyAdjustedEBITDA

PE

4y

Fugiat veniam pariatur beatae perspiciatis aut animi. Impedit qui doloremque soluta cumque. Sapiente autem voluptatem ea commodi. Distinctio eum sunt rem vel laborum. Accusamus voluptatem excepturi consectetur nostrum libero.

Ipsum quisquam error voluptate labore quia dignissimos aut atque. Asperiores excepturi corporis mollitia non autem qui. Labore minus blanditiis dolorem omnis. Magnam dolore expedita fugit et quidem sit. Officia dolore sequi ut facere vel vel voluptate aut. Vel aut aut rem quibusdam et. Accusamus quaerat sunt laborum praesentium facere voluptatum nisi illo.

Debitis temporibus facilis autem dolorem. Et sunt recusandae rem praesentium voluptatem atque. Velit non quam quod culpa omnis aut nemo. Exercitationem voluptatem ut sint et corporis.

Sit odio nemo est aliquid. Sequi qui dolores tempore reiciendis explicabo numquam et. Qui inventore itaque et et. Provident et ea doloremque reiciendis rerum omnis.

Reply

Quote

Report

Other

Authored by: Certified Private Equity Professional - PrincipalCertified Private Equity Pro

+80	Nothing to do at work & bored to hell	7	7h
+63	Do people over-index on 'moats'	19	1d
+41	Biggest (avoidable) failures in PE Investments?	23	17h
+40	Predicted Net Worth in Trodden Finance Path by 60?	18	7h
+38	Why is ROIC never really a topic when looking at companies IRL	11	2d
+26	SGE Final Round (Investment Summer Analyst) - Case Study & Technicals?	10	5h
+25	Large Cap PE Value Creation vs RX shops? (Coming from McK)	2	5d
+18	Senior IR Lifestyle	3	4d
+12	How to approach Buyside Recruiting	3	3d
+11	Honest opinions needed about lateraling	4	11h

1	redever	99.2
2	Secyh62	99.0
3	BankonBanking	99.0
4	kanon	99.0
5	DrApeman	98.9
6	dosk17	98.9
7	CompBanker	98.9
8	GameTheory	98.9
9	Betsy Massar	98.9
10	numi	98.8

Elite Career Bootcamp. Top Job Offer Guaranteed.

Elite Career Bootcamp. Top Job Offer Guaranteed.

Models from advisors that aren't linked

Elite Career Bootcamp. Top Job Offer Guaranteed.

Elite Career Bootcamp. Top Job Offer Guaranteed.

Models from advisors that aren't linked

See All Comments - 100% Free

Trending Content - Private Equity Forum