Hey guys,
This might be a simple question, but what is the reason that banks and companies unlink the formulas in excel and just paste values before sending across excel sheets to clients etc.?
Thanks,
| +156 | Think Twice before Recruiting for HOUSTON IB!! | 65 | 2d |
| +146 | Investment Banks Ranked By Your Divorced Blue Collared Uncle | 15 | 4h |
| +128 | UBS Exits 2026 | 35 | 3m |
| +50 | How cooked am I as an incoming WF IB SA 2027? | 17 | 5d |
| +42 | Congrats on the ROs. I Still Don’t Know Which One You Were | 2 | 20h |
| +40 | Mid-Level UBS Departure for another BB (Grass Isn’t Greener…) | 31 | 3d |
| +36 | IB RO Discussion | 6 | 2d |
| +36 | Did not get a return offer due to headcount, but happy to move on. | 8 | 4h |
| +32 | GS - Low Bonus | 23 | 10h |
| +28 | Early VP promo timeline | 15 | 1d |
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.
If I had to guess, it could be because the client might break the model if they don't understand it. Or also because banks believe that the Excel formulas are their proprietary information. I'm probably wrong though.
You are correct - my firm thinks that the excel models we build are proprietary information. Also, it's MUCH easier to do this from our perspective since we don't have to answer questions about them blowing up the model.
I was actually pretty surprised by this when I got here. I still think most banks send full models to clients.
Pretty much this. If you've ever been sent any model (or have looked at some old models), you'll notice links might refer to " 'C:\User\Folder[Filename.xlsx]TabName'!A1' " If you send a model with that link, it'll REF out (since that file doesn't exist on their computer).
Either because model links to original source files in separate files that tends to #REF out when you send to different people via email so they just paste values everything, and/or it's harder to find a bust in the model when it's all values.
Harum id ut non tempora voluptatem in iusto. Est magni nulla quos eum alias excepturi nobis. Officia et rerum alias officiis. Sed qui quam qui.
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...