I once did some consulting for a very well known person in the financial services industry, a recognized leader in the field. As part of that work I got to see his financial "models". They took the form of the most incredibly complicated Excel spreadsheets I have ever encountered. They were real monsters with hundreds of thousands of rows, dozens of workbooks.
Being a software engineer, I wrote some code to reverse-engineer them. I wrote some VB to dump all the formulas as text, and then wrote a parser and code analyzer. The result was a real eye-opener. 90% of the formulas were dead code that didn't actually play into the results at all. The rest was still a mess, but when I started combing through it I discovered that even the live code didn't really matter to the results because at the end there was a "fudge factor" that the guy just set according to his gut feel about the market, and this was the main thing that determined the final result.
I didn't last long in that job.