Forum Search: technical analysis
RE: Complex Trading Comps Analysis: Weighs question
Thank you fro the quick reply but this is not what i was looking for. In the wacc calculation of WMart in cells H21:H24 you have hard inputed some numbers. In cell K21 you have a D/E ratio of 20% which is derived from the division of cells H21/H23. My question id the following: If the target c... Read More
Thank you fro the quick reply but this is not what i was looking for. In the wacc calculation of WMart in cells H21:H24 you have hard inputed some numbers. In cell K21 you have a D/E ratio of 20% which is derived from the division of cells H21/H23. My question id the following: If the target c... Read More
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
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
RE: Merger Modeling Basics: about the goodwill amortization
If a deal is considered an Asset Deal or under a 338(h)(10) election, correct, technically there is no goodwill amortization, and instead, there is regular depreciation since the purchase price is thought of as an acquisition of assets as opposed to an acquisition of stock. If it is a true Asset Dea... Read More
If a deal is considered an Asset Deal or under a 338(h)(10) election, correct, technically there is no goodwill amortization, and instead, there is regular depreciation since the purchase price is thought of as an acquisition of assets as opposed to an acquisition of stock. If it is a true Asset Dea... Read More
RE: Quick & Dirty Basic LBO Model: Modeling Private Cos
Thank you very much for the quick response. Just one clarification when you say TEV i suppose you mean Transaction Eneterpise Value? I got my answer with regards to the LBO. How about when it comes to the acquisition of a private company and on the merger model. When we have to create the B/S ... Read More
Thank you very much for the quick response. Just one clarification when you say TEV i suppose you mean Transaction Eneterpise Value? I got my answer with regards to the LBO. How about when it comes to the acquisition of a private company and on the merger model. When we have to create the B/S ... Read More
Advanced Excel: Pivot Tables Error Message
I'm trying to create the Pivot Table in the Advanced Excel for Data Analysis module and am getting an error message when i'm trying to set up the layout in the PivotChart Wizard. The error is: Cannot open PivotTable source file '[AdvancedExcelDataAnalysisTemplate(1).xls]7) Pivot Table' Know ho... Read More
I'm trying to create the Pivot Table in the Advanced Excel for Data Analysis module and am getting an error message when i'm trying to set up the layout in the PivotChart Wizard. The error is: Cannot open PivotTable source file '[AdvancedExcelDataAnalysisTemplate(1).xls]7) Pivot Table' Know ho... Read More
Reference Range: Valuation of other industries
How are we suppose to value and build reference range inclusive of Deal comps and complex trading comps of other industries apart from retail segment.?In all of the modules the common example have been Wall mart(retail store). How about health care industry, financial industry, energy sector? How ar... Read More
How are we suppose to value and build reference range inclusive of Deal comps and complex trading comps of other industries apart from retail segment.?In all of the modules the common example have been Wall mart(retail store). How about health care industry, financial industry, energy sector? How ar... Read More
Merger Modeling Basics: Amortization
Hi, I was analysing the ability to pay model once more and came out with the following doubt: in theory, our sensitivity table shows how much I can afford to pay at a given Pre-tax cost of debt and a given level of synergy, however I simulated one $ amount from that table and got a dilution in my... Read More
Hi, I was analysing the ability to pay model once more and came out with the following doubt: in theory, our sensitivity table shows how much I can afford to pay at a given Pre-tax cost of debt and a given level of synergy, however I simulated one $ amount from that table and got a dilution in my... Read More
RE: Merger Modeling Basics: Synergies and Cash PE question
The ability to pay analysis is an extremely quick and dirty analysis that analyzes the maximum purchase price an acquiror can pay based on the funding cost of debt (as cash consideration). As a result, it works regardless of who the acquiror is since there is no stock component to the analysis. Syne... Read More
The ability to pay analysis is an extremely quick and dirty analysis that analyzes the maximum purchase price an acquiror can pay based on the funding cost of debt (as cash consideration). As a result, it works regardless of who the acquiror is since there is no stock component to the analysis. Syne... Read More
RE: Merger Modeling Basics: Amortization
As this is a quick and dirty analysis, goodwill amortization (usually zero) and any tax deducts (i.e. 338(h)(10) elections) are based on purchase price of equity and as such are not included in this short analysis. Don't think too much into this analysis - the concepts are discussed in the M&A ... Read More
As this is a quick and dirty analysis, goodwill amortization (usually zero) and any tax deducts (i.e. 338(h)(10) elections) are based on purchase price of equity and as such are not included in this short analysis. Don't think too much into this analysis - the concepts are discussed in the M&A ... Read More
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... 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 sensitize the capital structure for actual (no debt) and a industry average.
There are no silly questions - unless you are asking what LTM stands for! Read More