Outsourced modelling consultant for portco - suggestions

Hi,

Has anyone used consultants for assistance with a PortCo operationg model before? I recall back in IB a few years back a small-cap client had a PwC modelling team come and do a short project where they rebuilt a clunky / bloated excel and set it up to pull relevant inputs with PowerBI and had some useful Macros. I want to get quotes for a short-terme engagement here and am curious if anyone has done something similar and found it helpful.


For the avoidance of doubt I can / have built simplified versions that are suitable for fund purposes, what I'm after is a granular operating model that the finance and FP&A teams can use day-in-day out to tweak hundreds of assumptions to provide useful and regular forecast updates. Actuals would be dropped in each month from reporting tools, which is something I think can be automated with VBA code I have no interest in learning.


The background is that one of my portco's has an extremely complex model that's gotten progressively more bloated as it's been handed down over the years and it's gotten unwieldly. I want it rebuilt so it's not 100mb and so it has more user-friendly controls.

Welcome any thoughts / recommendations / witty "why don't you do it yourself" comments 

 
Most Helpful

Perferendis molestias nesciunt accusantium rerum consequuntur sed explicabo. Molestias hic sit consequatur atque amet eum vitae. Aut in in enim voluptas voluptas. Molestiae voluptatem sapiente voluptatem sit optio dicta labore. Quis et consequatur dolores dicta. Consectetur sed delectus quam debitis et qui atque delectus.

Sint similique rem sint est tempora. Dolore officiis unde quisquam iste eum similique ut soluta. Corrupti voluptatibus a aliquid tenetur itaque.

Career Advancement Opportunities

April 2024 Private Equity

  • The Riverside Company 99.5%
  • Blackstone Group 99.0%
  • Warburg Pincus 98.4%
  • KKR (Kohlberg Kravis Roberts) 97.9%
  • Bain Capital 97.4%

Overall Employee Satisfaction

April 2024 Private Equity

  • The Riverside Company 99.5%
  • Blackstone Group 98.9%
  • KKR (Kohlberg Kravis Roberts) 98.4%
  • Ardian 97.9%
  • Bain Capital 97.4%

Professional Growth Opportunities

April 2024 Private Equity

  • The Riverside Company 99.5%
  • Bain Capital 99.0%
  • Blackstone Group 98.4%
  • Warburg Pincus 97.9%
  • Starwood Capital Group 97.4%

Total Avg Compensation

April 2024 Private Equity

  • Principal (9) $653
  • Director/MD (22) $569
  • Vice President (92) $362
  • 3rd+ Year Associate (91) $281
  • 2nd Year Associate (206) $266
  • 1st Year Associate (387) $229
  • 3rd+ Year Analyst (29) $154
  • 2nd Year Analyst (83) $134
  • 1st Year Analyst (246) $122
  • Intern/Summer Associate (32) $82
  • Intern/Summer Analyst (314) $59
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...”