Forget excel models, just use a pocket calculator to do your valuations!

I am interning with a boutique corporate advisory firm in an APAC emerging market when I saw this (peculiar?) incident:

A client came in one morning looking to sell a majority stake in his private company. Being the eager beaver intern, I quickly started to look into the company's financials, research about their target segments, revenue drivers, debt structures etc. and started to build a basic model to value the company. After some elbow grease I produced the standard football field to present to my VP, feeling rather pleased with my analyses.

He didn't even look at it.

Forget excel models, my VP just used a calculator (his phone) to do some simple multiple valuations or even simple mathematical proportions to arrive at a selling price based on the asking premiums of the client, which he found a few investors willing to take up the offer. After some minor tweaks, negotiations legal DD lasting a few months, the deal went through. No questioning projection assumptions, no teasers, no CIMs,....boom, deal done and the company gets paid.

I was just wondering, is this informal process commonplace where you are working? or is there some other background work that i am not aware of? or it it just a practice in emerging markets where these financial transactions are still nascent?

 

I've interned at an investment bank that deals with lower middle market firms (like $1-5mm EBITDA) and my MD never needed a model. He just told me to build models just for my own good (he's a really nice guy) so that he can teach me, but he just used an EBITDA multiple that he thought the company was going to sell at. He was previously a MD at HW/William Blair/Lincoln though, so his experience might be enough to win clients of these size.

But I did have to create teasers, CIMs, and bunch of other things necessary in the deal process, just not valuations.

 

From an analyst's perspective, it makes more sense to use DCF because it provides the intrinsic value of the company based on free cashflow. For private companies in emerging economies, the lack of information in the market makes comps rather inaccurate (theoretically).

But (IMO) from an investor's perspective, industry multiple expansions/contractions simply provides a barometer to sense investor opinions and provide a macro-view of the industry. Ultimately, beyond industry reports and market studies, in an economy where info is a scarcity, the most effective multiple is the one in the buyer's mind.

 

You really only need to do "sound" valuation work to prove to investors why the value of something they already own is not correct or will never be higher, and for the people selling the company to have a third party to point to so that they can claim no conflict of interest.

At the end of the day, owners will not sell for a price they don't like and so long as the sellers do not commit fraud, the buyers will pay whatever they think is fair and makes economic sense to them.

Your VP did what I described above - that is, he knew what would get the deal done, and based on his market knowledge proved it out as a reasonable valuation.

 

Really depends who you're selling for, and who you're selling to.

MD's friend, small company, private deal, great, they probably have an idea of what it's worth, from the "how much will someone pay for this" view. Further, the smaller the company, the more BS the assumptions going into the model.

Other side: Selling a public company to PE vehicle, buckle up, that's a wall of paperwork you're speeding towards. PE needs to paper down everything for CYA with the Investment Committee. Public company needs evidence that the deal was 'fair', board papers need to go through, everything needs to be lawyered up.

 

You made an interesting point about how assumptions becoming less valid due to the size of the company. I would add that this observation extend to quite a number of firms/transactions in APAC EMs. Especially if ratios were used, the difference in market conditions, demographic behaviors and regulation makes it such that much of the financial literature and wisdom from more advanced economies rarely applies. Everything has to be customized, a problem which is exacerbated by a dearth of information in a nascent market.

I suppose it is under such conditions, the art of deal-making becomes more significant than number crunching.

 

a PAC-MAN, you should still practice financial modeling because this is a skill that is very important for lateraling and M&A interviews in general.

That being said, no one actually cares what the model itself says. Deals are never completed because a merger model says the deal is Accretive or because the DCF says the target is drastically undervalued or because the LBO shows that a PEG could realize a 40% IRR. The entire purpose of the model is for when shit hits the fan. It's so that, as some other poster pointed out, we can show our board and investors that we properly valued the target. It is so that we can show investors that we received a fair deal for our divestiture. It is so that our IB can show our investors that they actually did their job. But when it comes time to sell the actual business, the market will price the business independant of what some model says. This is why M&A is an art form, not a science. This is why an MD will ask you to tweak your model to match what he/she wants it to spit out.

 

At my bulge bracket we'd look at LTM and NTM trading and M&A comps in a few related sub-industries to get a general sense of value / make sure we weren't leaving any money on the table. The operating model, DCF, and lbo models were more to sanity check and also get a sense for how much changes in certain assumptions would move the needle on value. Comps were always the most important though. DCFs in particular are very fudgeable and so not to be taken too seriously, especially given the outsized impact of the discount rate and the terminal value assumptions.

The one situation I ran into where accretion / dilution was truly make-or-break for a deal was synthetic capital raises, where a company is acquired below book value to be book value Accretive, so the 1-2 year BVPS and EPS bumps mattered more.

 

A company is only worth what someone is willing to pay for it. A model shows a single case scenario with many assumptions around revenues, discounts, risks, etc - great for having a fall-back number to support your position but not the real value of the transaction.

Lower MM is especially dismissive of models because the companies carry such high risk and low overall valuations that a few simple multiples will get you "close enough".

That being said, I have had a few situations now where shit has gone haywire in the last few days before a close, and the only saving grace was the model that kept everyone calm and rational.

 

I can make the model say whatever we want, depending on if we want to bring the price up, or push it down.

Off the cuff: 1. Adjust the total synergies to be recognised, and schedule for synergy realisation to tweak EV by a few points up or down 2. Justify transaction value based upon post transaction re-rating 3. Add a control premium to the cost to justify valuation 4. Insert 'Pricing Premium Achieved' based upon the market control exerted by the proforma company to boost DCF

That said, we were negotiating a sale of a stake in an asset to an infra fund, where we actually went back and forth arguing the minutia of the model for weeks, including a session with about ten bankers, ten to fifteen people from their respective companies, and a translator, which lasted almost five hours.

 

This is an experience. But in any case you have done a good job and these analyzes are important. After all, even small skills of working with Excel (not to mention some analytical abilities) are today preferable in different spheres: logical functions, division by categories, classification of objects, macros, etc. So this is a useful experience anyway.

If you are interested in writing, take a look at example that will help organize a different objects by category, part or element on https://answershark.com/writing/essay-writing/classification-essay/how-to-write-classification-essay.html
 

Fugit maxime dolorem amet animi sed. Odit vel est magnam aut ut. Molestias aut aut praesentium non est aliquam aut odit. Possimus magni quasi ipsum reiciendis. Eveniet dolore possimus fugit eveniet est qui sed. Dignissimos fuga vel molestiae consequatur velit inventore.

In ea vero doloribus deleniti dolor soluta. Aut fuga voluptatum nobis delectus. Perspiciatis qui quia id perferendis.

Repellendus est accusamus rem deleniti qui dolorem non. Modi consequatur dolores officiis voluptate occaecati sed illo.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (145) $101
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

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...”