Posts by: WST Expert 1
Re: Shares Outstanding
Yes, you must match historicals, this is especially important when you normalize. this is covered extensively in our Complex Trading Comps course.
It would be highly beneficial for you to take that course.
Yes, you must match historicals, this is especially important when you normalize. this is covered extensively in our Complex Trading Comps course.
It would be highly beneficial for you to take that course.
RE: Accounting for Discontinued Ops on financial statements
As you know, typically, we would ignore the effect of Discontinued Operations in our projections. However, for recently announced Discontinued Operations such as WMT's Germany operations, you would need the segment breakdown of the assets and liabilities or they'd have to disclose it to you. In shor... Read More
As you know, typically, we would ignore the effect of Discontinued Operations in our projections. However, for recently announced Discontinued Operations such as WMT's Germany operations, you would need the segment breakdown of the assets and liabilities or they'd have to disclose it to you. In shor... Read More
RE: Quick & Dirty Basic LBO Model: Modeling Private Cos
Thank you for your inquiry. We answer your questions listed in this course's video (Quick & Dirty LBO Modeling) using simple figures and go into great detail on the full blown Sources & Uses for an LBO in our Complex LBO course, thus, to quickly answer your questions here: 1) Cash doesn'... Read More
Thank you for your inquiry. We answer your questions listed in this course's video (Quick & Dirty LBO Modeling) using simple figures and go into great detail on the full blown Sources & Uses for an LBO in our Complex LBO course, thus, to quickly answer your questions here: 1) Cash doesn'... Read More
Re: Is there a premium paid to the existing shareholders?
This topic is covered in our LBO courses:
http://www.wallst-training.com/self-stu ... l#package6
In short, yes, due to control premium if the target is public.
This topic is covered in our LBO courses:
http://www.wallst-training.com/self-stu ... l#package6
In short, yes, due to control premium if the target is public.
RE: Amortizing debt out month by month vs annually
You could - but since we built an annual model, we use annual numbers. If you want to get extremely technical and precise, you would model that out, but since this isn't an LBO where you need extremely precise numbers, the additional precision gained isn't worth it, since it would only translate to ... Read More
You could - but since we built an annual model, we use annual numbers. If you want to get extremely technical and precise, you would model that out, but since this isn't an LBO where you need extremely precise numbers, the additional precision gained isn't worth it, since it would only translate to ... Read More
Re: dollar sign to "R"
Thank you for your inquiry and we are most happy to hear you learned from our courses. In reference to our custom WST macros, Ctrl+Shift+D, it will provide the default currency on your computer. If you are seeing $, most likely your computer setting is set to US region. If you change your region set... Read More
Thank you for your inquiry and we are most happy to hear you learned from our courses. In reference to our custom WST macros, Ctrl+Shift+D, it will provide the default currency on your computer. If you are seeing $, most likely your computer setting is set to US region. If you change your region set... Read More
RE: Forecasting working capital off future quarters' sales?
Your logic isn't a bad one - to base days outstanding off future forecasted quarterly sales. However, you will find that if you do that, you will create circular references. Any difference between using same quarter vs future quarter sales will be minimal unless you are a huge growth company. The ad... Read More
Your logic isn't a bad one - to base days outstanding off future forecasted quarterly sales. However, you will find that if you do that, you will create circular references. Any difference between using same quarter vs future quarter sales will be minimal unless you are a huge growth company. The ad... Read More
RE: Quick & Dirty Basic LBO: transaction enterprise value
Yes, you are clear. The $750 we assumed in the model was an assumption of the minimum level of cash we require. You would arrive at this figure when you build your full standalone projection model in the Debt Sweep calculation (i.e. our Advanced Financial Modeling - Core Model course). So if you ass... Read More
Yes, you are clear. The $750 we assumed in the model was an assumption of the minimum level of cash we require. You would arrive at this figure when you build your full standalone projection model in the Debt Sweep calculation (i.e. our Advanced Financial Modeling - Core Model course). So if you ass... Read More
Re: revolver
The revoler is meant to balance the entire model and replicate what happens in the real world, from a corporate finance point of view. Any shortfalls that year is picked up by the revolver. Please see our Circular Reference and Excel Iterations free online videos at Read More
The revoler is meant to balance the entire model and replicate what happens in the real world, from a corporate finance point of view. Any shortfalls that year is picked up by the revolver. Please see our Circular Reference and Excel Iterations free online videos at Read More
You can view our Advanced Financial Modeling - Enhancements course which contains our DCF module (or our Basic Financial Modeling module). The good news is that all the inputs to the DCF (from financials perspective) will all come from the Core Model, so it's just a matter of justifying the discount... You can view our Advanced Financial Modeling - Enhancements course which contains our DCF module (or our Basic Financial Modeling module).
The good news is that all the inputs to the DCF (from financials perspective) will all come from the Core Model, so it's just a matter of justifying the discount rate and terminal value assumptions (fully explained in the Basic FM module). Please email us at info@wallst-training.com if you need further assistance on ordering the course.
Thank you. Read More