Modelling Resource

December 10, 2024

by a searcher from University of Southern California - Marshall School of Business in Phoenix, AZ, USA

Does anyone have any good resources to help with building an excel model that can be updated when evaluating acquisition targets?

4 Likes

22 Replies

325 Views

Replies

Reply by an intermediary
from The University of Chicago in Chicago, IL, USA

Try the interactive software www.BVXCloud.com. Happy to give a demo. Few of its features are 1) Calculate price and the required equity to achieve target IRR. 2) Calculate price if debt (seller, bank) or equity is limited 3) Asset vs. Stock purchase 4) What if you could, or could not, growing WC and CapX? 5) What if you could or could not step up assets in an Asset purchase? 6) How to structure capital stack to service debt while meeting seller expectations? 7) When doe growth reduce value? 8) When is buyer's expected IRR is irrelevant? 9) How to structure earn-out? Is Earn-out an expense or an adjustment to price 10) Do more assets mean more value or lower value? 11) If you the price and equity, what would be the cash flow, DSCR and IRR? 12) and more.

Reply by a searcher
from Northwestern University in Chicago, IL, USA

Check out Live Oak Bank's resources - lots of simple, easy to use excel templates. Wall Street Prep also has a couple of good courses on the topic that come with lots of templates - https://www.wallstreetprep.com/wsp_course/lbo-lower-middle-market/

+20 more replies.

Join the discussion