Posts by: Guest 1
Ability to Pay Analysis
- the Net Income of $10m is the Target company Net Income? Not sure here since Change in NI assumes NIL accretion/dilution at break even PE, right? If so then it would be NI of Target & Acquiror since accretion/dilution is calculated on the new NI? Confused here - If it is Target NI then why is ... Read More
- the Net Income of $10m is the Target company Net Income? Not sure here since Change in NI assumes NIL accretion/dilution at break even PE, right? If so then it would be NI of Target & Acquiror since accretion/dilution is calculated on the new NI? Confused here - If it is Target NI then why is ... Read More
LBO of a public company
I am modeling out an private equity sponsored LBO of public company - using the construct of the core model. Naturually I have historical financials - in addition I have a proforma income statement and balance sheet -- to reflect the go-forward position of the company. I am having difficulty get... Read More
I am modeling out an private equity sponsored LBO of public company - using the construct of the core model. Naturually I have historical financials - in addition I have a proforma income statement and balance sheet -- to reflect the go-forward position of the company. I am having difficulty get... Read More
Distressed Credit Overview - Valuation questions
1. Slide 29 a. Where do bank vs bonds fall in this cap structure diagram (unclear) b. Senior debt i. Even though it has a 1st or 2nd lien on assets, is it always considered “unsecured” and not “secured”? why – i... Read More
1. Slide 29 a. Where do bank vs bonds fall in this cap structure diagram (unclear) b. Senior debt i. Even though it has a 1st or 2nd lien on assets, is it always considered “unsecured” and not “secured”? why – i... Read More
Circular reference problem in my model due to interest-HELP!
Full Question: I have created an interest tab where I would like to derive my interest expense and debt amortization schedule. I would like both of these to feed into the income statement and balance sheet in financials tab. In the debt amortization schedule I would like to derive the cash flow swe... Read More
Full Question: I have created an interest tab where I would like to derive my interest expense and debt amortization schedule. I would like both of these to feed into the income statement and balance sheet in financials tab. In the debt amortization schedule I would like to derive the cash flow swe... Read More
Re: Merger modeling - Purchase price allocation
And what was the reasoning for you guys to "choose the base of the %ages to be applied to the excess..."? That's what I am interested to understand... the logic you used here?
Thanks.
And what was the reasoning for you guys to "choose the base of the %ages to be applied to the excess..."? That's what I am interested to understand... the logic you used here?
Thanks.
Re: Modeling 'Names' used in IB/PE - Question
Hi, As rightly pointed out in the earlier post, there are no defined types of models that can be developed for valuation. Modeling involves understanding the situation in which you are developing a model. The characteristics of the industry in which the company is present plays a crucial role in de... Read More
Hi, As rightly pointed out in the earlier post, there are no defined types of models that can be developed for valuation. Modeling involves understanding the situation in which you are developing a model. The characteristics of the industry in which the company is present plays a crucial role in de... Read More
Footing my accretion/dilution model with reported numbers
Full Question:
Why is it that in attempting to replicate a merger analysis of an announced deal, an accretion/dilution merger model does not foot to companies' presentation materials even after including all relevant data items?
Full Question:
Why is it that in attempting to replicate a merger analysis of an announced deal, an accretion/dilution merger model does not foot to companies' presentation materials even after including all relevant data items?
Complex Trading Comps Analysis Treatment of gross profit
Haven't we overstated TGT's gross profit by including the net credit card revenues in our revenue line but excluding the "Credit card expenses" amount from our gross profit?
Haven't we overstated TGT's gross profit by including the net credit card revenues in our revenue line but excluding the "Credit card expenses" amount from our gross profit?
Re: Merger modeling - Merger BS
Hi, a quick follow up question here: my point is: if we are not subtracting the intangibles in the calculation of "Tangible book value" (it doesn't matter if it is $0 or not), we are actually calculating incremental Intangibles for the deal ONLY, so our formula on the BS (cell G17) should... Read More
Hi, a quick follow up question here: my point is: if we are not subtracting the intangibles in the calculation of "Tangible book value" (it doesn't matter if it is $0 or not), we are actually calculating incremental Intangibles for the deal ONLY, so our formula on the BS (cell G17) should... Read More
Where may I find the PDF file mentioned in the "Reference Range" lecture on creating a football field chart?