Posts by: WST Expert 1
Re: Inventory costing method
Assuming zero taxes, Net Income will indeed start off differently, but changes in inventory (i.e. cash paid to suppliers) are a cash outflow, and thus will be one of the adjustment line items immediately below. Any “increase” in net income due to the inventory costing method will simply come bac... Read More
Assuming zero taxes, Net Income will indeed start off differently, but changes in inventory (i.e. cash paid to suppliers) are a cash outflow, and thus will be one of the adjustment line items immediately below. Any “increase” in net income due to the inventory costing method will simply come bac... Read More
Re: Cash for Investment in exercise
That’s correct, apologies for the typos on the slide. In both these exercises, CFO increases, while CFI decreases.
That’s correct, apologies for the typos on the slide. In both these exercises, CFO increases, while CFI decreases.
Re: Reserve column
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... 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... Read More
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?
Assuming a rising-price and increasing-inventory environment, a company using FIFO will generate lower COGS, and higher taxable income. Therefore, this FIFO company would pay more taxes (using cash) and thus have lower cash flow.