I have an excel sheet of 10 comparable companies with their P/B, P/E, Market Cap, etc. I was asked to valuate this company to see if the sponsor is paying an acceptable price and I have no idea how to start. Can someone help?
| +133 | Do people still want to go PE? | 39 | 2h |
| +108 | UBS Tech layoff | 48 | 4h |
| +95 | UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT | 22 | 5h |
| +44 | How do YOU manage networking requests? | 9 | 6h |
| +37 | Lazard hirevue | 11 | 2d |
| +36 | What Differentiates the Best Analysts as AI Improves? | 9 | 2d |
| +33 | MBB Pay Raises | 21 | 2h |
| +31 | Cornell Club T10 Rankings (UPDATED 10/2026) | 19 | 6h |
| +31 | Quitting After First 4 months | 11 | 1h |
| +30 | Are target prospects getting dumber? | 12 | 4h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Problem is that I only have P/B and P/E ratios on this excel sheet. Am I supposed to look at other ratios?
Problem is that I only have P/B and P/E ratios on this excel sheet. Am I supposed to look at other ratios?
http://macabacus.com/valuation/comparable-companies
is it possible to valuate using P/B and P/E?
P/E is one metric you can use but P/B is going to be worthless in this case. get some forward EBIT and EBITDA multiples as well as premiums paid
DISCLAIMER: Not in finance yet
If you have their next year dividend (current div x 1+g), growth (ROE x b) and the investors required return (WACC//CAPM) ::: D1/(r-g) = Price
Compare that to the price being asked to see if under/overvalued. Would be my best guess I'm interested to see other approach.
outside of intro to corporate finance the above idea isn't going to hold much weight. Ideally you have the time and resources to do a full DCF, trading and transaction comps and possible an LBO if this is a take-private transaction.
What type of transaction is this?
it's an acquisition. I don't know why the sponsor just sent us a model with that little information.
For an adequate multiple analysis you'd better check the comparable companies ROIC/expected growth.
what industry is the company in?
market cap X share price duh!
Impedit corporis suscipit dolor voluptate. Ab cupiditate architecto praesentium unde. Iure velit sed qui et ut delectus atque. Consequatur sequi nulla debitis sunt. Sunt distinctio incidunt ab consequatur sunt doloribus amet.
Reprehenderit veritatis magni fugit molestias qui magnam rerum. Tempore incidunt reprehenderit id sint omnis quis.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...