Posts by: WST Expert 1

Re: Super-advanced merger modeling
Actually, those percentages were chosen at random. You have one full year until AFTER the close of the deal to solidify those numbers, which means basically it's a moving target. You would pick the numbers based on the industry you are in. For instance, a pharmeceutical company would probably result... Read More
Go to post added 11 years ago
Re: M&A Cash Purchase Question
The answer is yes and no.
This is covered extensively in our M&A Deal Structuring course online!
Please re-review the course.
Thanks.
Go to post added 11 years ago
Re: Questions on basic Accretion/Dilution model
We still call it GW amortization in our model because the calculation is GW, not the entire purchase price. In our M&A Deal Structuring course, we give the example of a $200 asset. A common mistake is to depreciation the $200 but since you are adding Target Net Income in the simple accretion dil... Read More
Go to post added 11 years ago
Re: Urgent: Automating Scorecard Metrics grading
This should be pretty straightforward - use a vlookup or match combined with offset. say your market growth is in cell A1 in A2:A4, put down -100% 10% 20% in B2:B4, put down 4 8 12 in cell say B1, where you want the point equivalent of whatever is in cell A1: =vlookup(A1,A2:B4,2,1) you have to ... Read More
Go to post added 11 years ago
Re: Merger modeling - Purchase price allocation
The trx costs are allocated 100% to trx costs and GW. Since we chose the base of the %ages to be applied to the excess, don't allocate any trx costs to intangibles etc. Yes, correct. One should account for the grossed up DTL specifically due to any FMV. We didn't do that on our model since it was a... Read More
Go to post added 11 years ago
Re: Shareholder momentum analysis
This is typically done in an "ownership" run via one of the data vendors (i.e. Cap iq or factset) that easily downloads the top shareholders and allows you to compare quarter by quarter changes. Absent that, start with the proxy statement which will list top holders and work backwards as y... Read More
Go to post added 11 years ago
Re: Manufacturer With Captive Finance Co.
We would model out the businesses separately to achieve separate financials and then obviously consolidate them at the end. For valuation purposes, we would to sum-of-parts on the businesses. Think of GM and GMAC back in the day - split them separately and treat GMAC as arms length, third party, and... Read More
Go to post added 11 years ago
RE: AFM Enhancements: Cond. Format Credit & Leverage Stats
If you re-download the Excel template provided, you will see the conditional formatting automated as this was previously not included in the supplied template. then, to learn the specific conditional formatting technique, view our Advanced Excel for Data Analysis course, in particular, the Condition... Read More
Go to post added 11 years ago
Re: Core Model DCF - terminal cashflow
This is explained in our Basic FM course in the DCF section. Pls view the other posts in the valuation topics (or search for more info). In short, CapEx and D&A cancel out over time for a mature company and we assume minimal changes to WC.
Go to post added 11 years ago
Re: Urgent: Automating Scorecard Metrics grading
Glad you find our stuff helpful! To answer your questions: 1) please AVOID nested IF's at ALL costs. period! in this case, given what we outlined previously for you, vlookup works best. offset & match are overkill and not required. You do not have to worry about Excel crashing. It holds up quite... Read More
Go to post added 11 years ago