Posts by: WST Expert 1
Re: Best way to set grey background for Mac
Unfortunately, Mac OS does not have a setting to change background to gray as Windows does. Thus, you can temporarily use a black fill to shade those cells. Remember to download our Mac shortcut keys to use Office 2011 for Mac. http://www.wallst-training.com/resources.html and scroll down to Technical Resources section. Read More
Unfortunately, Mac OS does not have a setting to change background to gray as Windows does. Thus, you can temporarily use a black fill to shade those cells. Remember to download our Mac shortcut keys to use Office 2011 for Mac. http://www.wallst-training.com/resources.html and scroll down to Technical Resources section. Read More
Re: Historical Cash Flow statement
Yes, that is the correct approach that we would take and recommend. Much of this logic is explained in our courses. i.e., we take the liberty to recast the Income Statement and Balance Sheet as we see fit. Certain items, such as NCI (Non-Controlling Interest or the old Minority Interest), are below ... Read More
Yes, that is the correct approach that we would take and recommend. Much of this logic is explained in our courses. i.e., we take the liberty to recast the Income Statement and Balance Sheet as we see fit. Certain items, such as NCI (Non-Controlling Interest or the old Minority Interest), are below ... Read More
Re: Debt Extinguishment - Equity offered
Thank you for your inquiry. Can you clarify the corporate structure as well as the exact flow. With all the "Company" and "XYZ" reference, it's not straightforward to follow the ownership structure (to determine consolidation requirements) and ultimately the flow of funds. Howev... Read More
Thank you for your inquiry. Can you clarify the corporate structure as well as the exact flow. With all the "Company" and "XYZ" reference, it's not straightforward to follow the ownership structure (to determine consolidation requirements) and ultimately the flow of funds. Howev... Read More
RE: Capital leases revisited x2
Industry is important - they should not only be adding back minority interest but also subtracting out equity investments (opposite of minority interest). Rationale: match the numerator (valuation) with denominator (EBITDA). So that means, profitability on IS is increased by 100% of subsidiary, but ... Read More
Industry is important - they should not only be adding back minority interest but also subtracting out equity investments (opposite of minority interest). Rationale: match the numerator (valuation) with denominator (EBITDA). So that means, profitability on IS is increased by 100% of subsidiary, but ... Read More
Re: Cannot FULLY use WSTMacros3.4.2.xla on Excel 2013
Yes, for the new Excel on PC version (Excel 2007 and Excel 2010 and later), you will need to precede the "S" with an "X" to access the Add-ins ribbon.
Thus, ALT+X+S and then the rest.
Yes, for the new Excel on PC version (Excel 2007 and Excel 2010 and later), you will need to precede the "S" with an "X" to access the Add-ins ribbon.
Thus, ALT+X+S and then the rest.
RE: AFM Enhancements: Valuation Question
Correct, you would use your diluted ownership %age after the "certain and known" anticipated capital raising.
Correct, you would use your diluted ownership %age after the "certain and known" anticipated capital raising.
Re: Valuation Question
When calculating TEV and Equity Value for DCF, you use current Debt/Cash b/c you have already PV'ed the cash flows and Terminal Value to today. As such, all figures that you are working in are already in PV terms. Even if you have the projected BS, it doesn't matter at all, it would be incorrect to ... Read More
When calculating TEV and Equity Value for DCF, you use current Debt/Cash b/c you have already PV'ed the cash flows and Terminal Value to today. As such, all figures that you are working in are already in PV terms. Even if you have the projected BS, it doesn't matter at all, it would be incorrect to ... Read More
Re: Modeling/Projecting Floating Rates
Normally, we keep LIBOR constant for projection purposes. This is because accurately projecting LIBOR over next 5 years is very difficult. You can, however, feel free to be as fancy as you want in projecting LIBRO, but seriously, if you can correctly project rates in the future, go into rates tradin... Read More
Normally, we keep LIBOR constant for projection purposes. This is because accurately projecting LIBOR over next 5 years is very difficult. You can, however, feel free to be as fancy as you want in projecting LIBRO, but seriously, if you can correctly project rates in the future, go into rates tradin... Read More
Re: Goodwill and Minority Interest for less than 100%
We agree with your summary which neatly summarizes our summary.
As for in the case of a merger - you would have to use our super-advanced merger model!
Unfortunately, as we stated earlier, you cannot (should not) use a LBO model for a merger!
P.S. pls do email us the list of previous Q&A!
We agree with your summary which neatly summarizes our summary.
As for in the case of a merger - you would have to use our super-advanced merger model!
Unfortunately, as we stated earlier, you cannot (should not) use a LBO model for a merger!
P.S. pls do email us the list of previous Q&A!
To add a shortcut key to a macro, you can hit ALT+F8 to bring up the macro dialog box and then select your macro and click on Options and it should be straightfwd from there. Don't forget to save your macro file.