Posts by: Guest 1
M&A Debt Sweep CF Recapture Feature
Hello,
I was just wondering what the rationale behind the CF Recapture feature (switch) is on the Debt Sweep for the advanced M&A model. What is the rationale? How does it work and its practicality? Thank you.
Hello,
I was just wondering what the rationale behind the CF Recapture feature (switch) is on the Debt Sweep for the advanced M&A model. What is the rationale? How does it work and its practicality? Thank you.
Merger modeling - Purchase price allocation
Hi there, a couple of doubts here: 1. In the purchase price allocation, why do we allocate the excess (Purchase price of equity – Tangible Book value) without the transaction costs? Any specific rule here? 2. In the same purchase price allocation, shouldn’t we have to add a line in that purcha... Read More
Hi there, a couple of doubts here: 1. In the purchase price allocation, why do we allocate the excess (Purchase price of equity – Tangible Book value) without the transaction costs? Any specific rule here? 2. In the same purchase price allocation, shouldn’t we have to add a line in that purcha... Read More
AFM Enhancements: Valuation of negative earnings
What if we must value a company with a 5 year projected cash flows with the first two FCFF being negative?
What if we must value a company with a 5 year projected cash flows with the first two FCFF being negative?
Merger modeling - Merger IS
In relation to some concepts in the 'MERGER IS' tab, I have some questions that you guys may be able to help me with: 1. From line 25 to 28 in the ‘MERGER IS’ tab, could we have used the MIN formula to amortize those items? Only because we cannot amortize more than what we have as beginning bal... Read More
In relation to some concepts in the 'MERGER IS' tab, I have some questions that you guys may be able to help me with: 1. From line 25 to 28 in the ‘MERGER IS’ tab, could we have used the MIN formula to amortize those items? Only because we cannot amortize more than what we have as beginning bal... Read More
Adjusted EBITDA - Core Model
I have been through your basic financial modeling and all parts of the Core Model and Enhancements. Right now I am going through the Complex Trading comps to get a handle on all adjustments that might be out there. However, (if memory serves me right), it was only in the basic course that you ac... Read More
I have been through your basic financial modeling and all parts of the Core Model and Enhancements. Right now I am going through the Complex Trading comps to get a handle on all adjustments that might be out there. However, (if memory serves me right), it was only in the basic course that you ac... Read More
Re: M&A Debt Sweep CF Recapture Feature
What's really interesting to me is that there is also a switch on the mandatory debt repayment? If it's mandatory why would there be a switch that tells you not to pay it? Thoughts? Thank you.
What's really interesting to me is that there is also a switch on the mandatory debt repayment? If it's mandatory why would there be a switch that tells you not to pay it? Thoughts? Thank you.
Accounting: Files available for Download
How can I download the interactive chart in this session ? Also, is it possible to dl the exercises so that I can do them offline ?
thx
How can I download the interactive chart in this session ? Also, is it possible to dl the exercises so that I can do them offline ?
thx
Merger modeling - Merger BS
Hi, On the ‘MERGER BS’, cell G17, why are we reducing the target’s existing “Intangible Assets” balance (in the pro forma adj. column) if the calculation that we have in the ‘MERGER Summary’ for Intangibles is not a post-transaction Intangibles (opposed to GW, that is a post-transactio... Read More
Hi, On the ‘MERGER BS’, cell G17, why are we reducing the target’s existing “Intangible Assets” balance (in the pro forma adj. column) if the calculation that we have in the ‘MERGER Summary’ for Intangibles is not a post-transaction Intangibles (opposed to GW, that is a post-transactio... Read More
Please clarify if any value is gained by buying back stock-2
Full Question: So I understand your example. But my understanding is that M&M proposition II says that in a world with taxes, increasing debt means increasing the value of the firm or Enterprise Value. In the examples you provided me, the enterprise value of the firm stayed constant. I'm saying... Read More
Full Question: So I understand your example. But my understanding is that M&M proposition II says that in a world with taxes, increasing debt means increasing the value of the firm or Enterprise Value. In the examples you provided me, the enterprise value of the firm stayed constant. I'm saying... Read More
If its a large cap, well covered company, shouldn't analyst projection be used as the base case?
In general, if using analyst projections, does it make sense to mix GAAP historicals with analyst (non-GAAP) forecasts?