Forum Search: technical analysis
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
RE: Excel Question
Use trim function first to remove extra spaces. This is actually covered in the adv excel for data analysis online course. To take out periods and commas use substitute function. Then sometimes you might have abbreviations like microsoft corporation vs microsoft corp. Use the left function and pick ... Read More
Use trim function first to remove extra spaces. This is actually covered in the adv excel for data analysis online course. To take out periods and commas use substitute function. Then sometimes you might have abbreviations like microsoft corporation vs microsoft corp. Use the left function and pick ... 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... 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 capital structure is D/E 20% how did you cmae up with the D/Cap and E/Cap in cells I 21 and I23 (16.7% and 83.3% respectively). Those figures are the result of the calculations wiht the use of the hard input figures i mentioned before. How did you came up with those hard inpout figures of 20(cell H21) 100(cell H23) and 120(cell H24)? Read More