Posts by: WST Expert 1
Re: Five questions (merger premiums, capex, leveraged beta, etc.)
1. Typically, the premiums paid in a merger of equals is less than premiums paid in an outright acquisition. 2. Strictly speaking, the model should say "Less: CapEx". The “net” is there in this case because there were some industry-specific things done to recapture some of the CapEx that resu... Read More
1. Typically, the premiums paid in a merger of equals is less than premiums paid in an outright acquisition. 2. Strictly speaking, the model should say "Less: CapEx". The “net” is there in this case because there were some industry-specific things done to recapture some of the CapEx that resu... Read More
Re: Shortcut Keys for Macros Not Working
Could you try disabling the hot keys in Bloomberg? There should be a Hot Key Manager or something similar. If you disable the hot keys, and restart Excel, there should no longer be any conflicts.
Could you try disabling the hot keys in Bloomberg? There should be a Hot Key Manager or something similar. If you disable the hot keys, and restart Excel, there should no longer be any conflicts.
Re: Shortcut Keys for Macros Not Working
Do you have a Bloomberg Excel add-in installed on that desktop? You can check under the Tools -> Add-Ins menu and see if it's listed there with a checked checkbox.
Do you have a Bloomberg Excel add-in installed on that desktop? You can check under the Tools -> Add-Ins menu and see if it's listed there with a checked checkbox.
Re: Shortcut Keys for Macros Not Working
The removal instructions are somewhat hidden on the bottom of the first page on that PDF file, but here's how. There are only two steps: 1. In Tools -> Add-Ins (Alt, T, I), uncheck the box for WST Macros, then hit OK. 2. Again, go to Tools -> Add-Ins (Alt, T, I), hit Browse, select the file, the... Read More
The removal instructions are somewhat hidden on the bottom of the first page on that PDF file, but here's how. There are only two steps: 1. In Tools -> Add-Ins (Alt, T, I), uncheck the box for WST Macros, then hit OK. 2. Again, go to Tools -> Add-Ins (Alt, T, I), hit Browse, select the file, the... Read More
Re: Shortcut Keys for Macros Not Working
The WST Macros add-in is actually designed to be an .xla or .xlam file that you place in a folder. Every time Excel starts up, it will look for it and load all the functions, so you won't need to have a blank WST Macros spreadsheet open at all times. For step-by-step installation instructions, pl... Read More
The WST Macros add-in is actually designed to be an .xla or .xlam file that you place in a folder. Every time Excel starts up, it will look for it and load all the functions, so you won't need to have a blank WST Macros spreadsheet open at all times. For step-by-step installation instructions, pl... Read More
Re: Shortcut Keys for Macros Not Working
It sounds like Excel sees that shortcut as corresponding to a WST Macros function, but the function itself isn't being called or executed correctly (i.e., nothing happens).
Which version of Excel are you using? Have you already tried removing WST Macros and doing a fresh installation of it?
It sounds like Excel sees that shortcut as corresponding to a WST Macros function, but the function itself isn't being called or executed correctly (i.e., nothing happens).
Which version of Excel are you using? Have you already tried removing WST Macros and doing a fresh installation of it?
Re: Shortcut Keys for Macros Not Working
Hi Tom,
What are the shortcut keys that you've tried assigning? Is it possible there's a conflict between that and a keyboard shortcut from either WST Macros and/or some other Excel add-in that you have installed?
Hi Tom,
What are the shortcut keys that you've tried assigning? Is it possible there's a conflict between that and a keyboard shortcut from either WST Macros and/or some other Excel add-in that you have installed?
Re: TEV and ¨significant¨Cap/Op Leases
Just because company has to pay significant amounts for leases does not automatically qualify for "Adjusted TEV". Primarily, it's for industries in which there is a significant buy vs. lease decision (again, mostly transport) and comparison of traditional EBITDA would be distorted because of the ren... Read More
Just because company has to pay significant amounts for leases does not automatically qualify for "Adjusted TEV". Primarily, it's for industries in which there is a significant buy vs. lease decision (again, mostly transport) and comparison of traditional EBITDA would be distorted because of the ren... Read More
Re: DCF Analysis: Using Tax-Effected EBIT as Perpetuity in the Perpetuity Growth Method (PGM) to calculate Terminal Value
Hello Peter, This is covered in one of the packages that you did not purchase, specifically Package 2, under Basic Financial Modeling, which is the very first spot that we cover DCF Modeling if one were starting from our more basic courses. The short explanation is that in order for perpetuity... Read More
Hello Peter, This is covered in one of the packages that you did not purchase, specifically Package 2, under Basic Financial Modeling, which is the very first spot that we cover DCF Modeling if one were starting from our more basic courses. The short explanation is that in order for perpetuity... Read More
The table is shown from Company A’s perspective, so that last column does not necessarily refer to Retained Earnings. Company B is the one who has things going on with their Retained Earnings (specifically, they reduce it by the total amount of dividends paid out). Under the Cost Method, yes, C... The table is shown from Company A’s perspective, so that last column does not necessarily refer to Retained Earnings. Company B is the one who has things going on with their Retained Earnings (specifically, they reduce it by the total amount of dividends paid out).
Under the Cost Method, yes, Company A in this situation would have to note down the dividend income both on the income statement and as an operating cash in-flow. Read More