Posts by: WST Expert 1
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.
The answer is yes and no.
This is covered extensively in our M&A Deal Structuring course online!
Please re-review the course.
Thanks.
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
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
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
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
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
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
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
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
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
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
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
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
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.
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.
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
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
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... 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 in more intangibles such as patents, etc, than a service based business (the latter might have more non-competes and customer lists, etc). As such, you make the most intelligent guess you can based on prior deals. The intangible asset valuation experts (i.e. Big Four Transaction Services) would be able to provide more input on those comps as there are databases for that.
In terms of the base for the percentage - it could be either - whatever you wish. We just happened to decide to do it based on unallocated portion, that's all. As long as the final number is reasonable, you could even hard code that as well. Read More