Posts by: WST Expert 1
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
Re: Merger modeling - Merger IS
1) You could definitely. However, since we were clear in making sure the term on Merger Summary is greater than the length of the 5 yr model, then we didn't bother. On a real deal, you would also have 1st yr debt financing fees and differences of Book and Tax depreciation. 2) Assuming you are takin... Read More
1) You could definitely. However, since we were clear in making sure the term on Merger Summary is greater than the length of the 5 yr model, then we didn't bother. On a real deal, you would also have 1st yr debt financing fees and differences of Book and Tax depreciation. 2) Assuming you are takin... Read More
Re: Urgent: Automating Scorecard Metrics grading
also, please post in correct topic forum. thanks!
also, please post in correct topic forum. thanks!
Re: TEV and negative net debt clarification
You are confusing the concept of Equity Value/Enterprise Value with DCF. WACC is used in the DCF because it is discounting cash flows to the entire firm (vs cost of equity and Equity Value). Once you arrive at your DCF value (TEV as of today), you're done with DCF. No more reference to WACC. Then... Read More
You are confusing the concept of Equity Value/Enterprise Value with DCF. WACC is used in the DCF because it is discounting cash flows to the entire firm (vs cost of equity and Equity Value). Once you arrive at your DCF value (TEV as of today), you're done with DCF. No more reference to WACC. Then... 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 ... 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 put -100% on top since vlookup's approximate match (the last 1 or TRUE), acn only look up in descending order.
For more on advanced vlookup methods, go to our Advanced Excel for Data Analysis class at http://www.wstselfstudy.com/programs.html Read More