how do you do a relative value stock price chart? if you have company A and 4 comps, can you use company A's stock price on the Y axis and still the 4 as its peers on the same Y axis? If Company's A and the 4 peers prices differ drastically, what's a solution that still shows the company's A stock prices throughout the timeline?
| +326 | UBS Tech MD hires Son (from no-name college) as an Intern | 57 | 19h |
| +256 | Evercore Intern Seizure | 38 | 5h |
| +90 | [Official] 2026 IB Analyst Bonus Megathread (with 2025 Consolidated Pay and Perks/Benefits) | 12 | 2d |
| +55 | JPM M&A is Gone??? Purely Coverage Banking??? | 22 | 9h |
| +54 | Is DCM actually underrated ? | 21 | 18h |
| +46 | Are all Tech / TMT groups sweaty? | 33 | 1d |
| +43 | Losing my personality in Banking | 7 | 2h |
| +39 | Am I behind? 31 Year Old Analyst | 9 | 1d |
| +39 | Associate & Above IB exits | 16 | 2d |
| +31 | Incoming IB Analyst: Best Ways to Prepare? | 8 | 2d |
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.
You want to index the prices.
So your Y axis will be in %'s, and you'll have two lines (your Company and the 4 peers indexed) both starting at 100%
To calculate the company, use a column next to your stock prices and take each price divided by your starting price. For example, say you start at 1/1/12, and the price is $10. At 1/7/12 the price went to $9, so your % will be 90%. Then the stock went to $10.50 at 1/14/12, so your $ will then be 105%. This % is the line you'll want to chart out.
To calculate the comps, there are two ways. You can do the same as above for each of the four (each being divided by its own starting share price), then average the four at each point in time.
Or, you can do one formula to calculate all at once. The formula is (assuming your 4 peers are in column C, D, E and F and the prices begin in row 5):
=( C5 / $C$5 + D5 / $D$5 + E5 / $E$5 + F5 / $F$5 ) / 4
Then drag that formula all the way down for all stock prices.
If you want to show the 4 peers relative to your company's stock price, just take the calculated average for the peers (using either method) and multiply by your company's beginning stock price.
Hope all that makes some sense!
As the previous poster said, you index them all either to the share price of Company A or to 100. The best way I found of doing it is:
Note that this exact method will only work if you derive your share prices from an input formula, if they are hardcoded numbers then you will need to make a new cell range referencing those numbers and apply the same method.
Impedit similique aspernatur magnam dolorem delectus. Quo et qui ea sint. Quia aut ab ab incidunt sint. Maiores distinctio non quis ad aut sit voluptatibus. Id sint voluptates autem velit quas quisquam dicta. Neque vitae quisquam nemo nemo molestiae rem.
Incidunt illo et quidem. Dolores animi maiores culpa cumque ea maiores consequuntur. Voluptatem labore commodi eius aut. Voluptatem sed maxime consequatur sapiente.
Numquam et dolore non voluptatem enim voluptas. Aperiam nihil consequatur voluptate ut. Voluptatibus fugiat qui unde in.
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...