Posts by: Guest 1
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
AFM Enhancements: Diluted Shares Oustanding figure
Hi there, Wouldn't be more accurate to calculate the "Implied Price per Share" by using the "Intrinsic value" from our valuation model as an input to the MAX function to calculate the potential dilution through the Treasury Stock method? And if I want to consider our "intrinsic value", how can I ... Read More
Hi there, Wouldn't be more accurate to calculate the "Implied Price per Share" by using the "Intrinsic value" from our valuation model as an input to the MAX function to calculate the potential dilution through the Treasury Stock method? And if I want to consider our "intrinsic value", how can I ... Read More
Core Model DCF - terminal cashflow
Why are you taking the EBIT as the terminal cashflow in your calculation of TV using he perpetuity method. I would have taken the final year Unlevered Free Cash Flow. Please clarify
Why are you taking the EBIT as the terminal cashflow in your calculation of TV using he perpetuity method. I would have taken the final year Unlevered Free Cash Flow. Please clarify
Credit Statistics
Hi there, A few months ago I took WST's financial modeling courses and I remember that in the "Advanced Financial Modeling - Enhancements" module there was a credit statistics tab where you have a Standard & Poors table with credit ratings based on certain leverage and coverage ratios... Read More
Hi there, A few months ago I took WST's financial modeling courses and I remember that in the "Advanced Financial Modeling - Enhancements" module there was a credit statistics tab where you have a Standard & Poors table with credit ratings based on certain leverage and coverage ratios... Read More
What if we must value a company with a 5 year projected cash flows with the first two FCFF being negative?