Posts by: WST Expert 1

RE: Complex Trading Comps Analysis: Weighs question
The weights for wacc in complex trading comps were estimated based on the target capital structure of the industry that is "normalized". If the weights are roughly the same as the actual, then it doesn't really matter which one to use. However, in a case of Costco, with no debt, one may want to sens... Read More
Go to post added 10 years ago
Re: Automatic Updates
The way to do this would be to create a named range that dynamically expands based on the count of the number rows utilized. This requires combination of OFFSET and COUNT to do so. This is covered in great detail with examples in our Excel Charting & Graphing Techniques course. http://www.wstselfstudy.com/packagetech-1.html

Use this discount code for 33% off through the end of August:
wst3mo33off
Read More
Go to post added 10 years ago
Re: Cash Flow and Balance Sheets for M&A Models
Generally speaking, when pitching, it is not required since its a bit overkill and you don't have all the required info from mgmt.

However, in real deals, it is critical to build the fully blown version. This is covered in our super-advanced m&a class
Go to post added 10 years ago
Re: Price to book
Sounds like you are trying to find an "intrinsic" price-to-book ratio of some sort? At first glance, we're not sure why this is relevant. P/B is a market multiple; so there is no "intrinsic" or "correct" answer, but rather, what investors (the market) are willing to pay... Read More
Go to post added 10 years ago
Re: Bank Modeling
You are not incorrect.
However, the convention is for Recoveries to be offset against GCO. Keeping in mind that GCO don't impact the IS, so hence you don't see it as a net against Provisions.
Go to post added 10 years ago
RE: Complex Trading Comps Analysis: Weighs question
Don't forget that Debt / Capital is Debt / (Capital + Equity) and so it's just a matter of simple algebra. If D/E = 20%, then you can assume that D=20;E=100, then D/(D+E) is 20/120 or 1/6, hence 16.67%. As previously stated, the initial D/E assumption of 20% was assumed based on a combination of ind... Read More
Go to post added 10 years ago
Re: adv lbo model questions
Sources & Uses: - from the Merger courses, the legal structure can be stock or asset (most likely stock for an LBO, but not necessarily) - regardless of stock vs asset deal, debt refi'ed, etc is same treatment: you are buying the entire company - equity premium: based on appropriate valuation of... Read More
Go to post added 10 years ago
Re: Core Model DCF - terminal cashflow
We are saying that NORMALIZED Terminal Year Unlevered Free Cash Flow is proxied with Tax-Effected EBIT b/c a mature, slow growth company has characteristics in which CapEx and depreciation net out over time. Please view the D&A video (part of our FREE resources in your login) for explanation as ... Read More
Go to post added 10 years ago
Re: Working Capital in FCF for Valaution Purposes
The idea behind changes in working capital is that when you value (or buy) an entity, you are buying the company on a going concern basis, able to support its own operations. if you agreed to purchase a company for $100 and it turns out that you still have to put in $10 MORE because there was no wor... Read More
Go to post added 10 years ago
Re: Bank Modeling
Think of it like this. If you understand that GCO reduces the allowance for credit losses, then recoveries are the opposite, and as such, ends up increasing the allowance for credit losses. As you make more provisions each year (IS impact), the allowance for credit losses go up. As you charge off th... Read More
Go to post added 10 years ago