Posts by: WST Expert 1
Re: Editing WST Macros
There is no setting in Excel or VBA to take global priority. It is random. Sometimes our macro takes priority, sometimes other macros take priority. As far as we can tell, it's not even based on the last set of macros installed.
There is no setting in Excel or VBA to take global priority. It is random. Sometimes our macro takes priority, sometimes other macros take priority. As far as we can tell, it's not even based on the last set of macros installed.
Re: Editing WST Macros
You must assign an unused shortcut combination to your macro else they will interfere. For instance if you assigned ctrl + c to your macro it will interfere with normal copy keystroke. Find an unused keystroke and voila no problems. For truly custom one-offs for specific client colors etc, that's th... Read More
You must assign an unused shortcut combination to your macro else they will interfere. For instance if you assigned ctrl + c to your macro it will interfere with normal copy keystroke. Find an unused keystroke and voila no problems. For truly custom one-offs for specific client colors etc, that's th... Read More
Re: Editing WST Macros
Our recommendation is to create your own custom macros and assign shortcut keys that do not interfere with the WST Macro shortcuts or Excel's built-in shortcuts. We do not allow customization of our macros at this point. For more information on macro creation, go to our Adv Excel course which has a ... Read More
Our recommendation is to create your own custom macros and assign shortcut keys that do not interfere with the WST Macro shortcuts or Excel's built-in shortcuts. We do not allow customization of our macros at this point. For more information on macro creation, go to our Adv Excel course which has a ... Read More
Re: Selling Receivables
You're welcome - that's what we are here for!
You're welcome - that's what we are here for!
Re: Selling Receivables
Only in cases of distressed companies.
Only in cases of distressed companies.
Re: Selling Receivables
n Excel, yes anything is possible. Some lazy ppl get lazy with best practices and have cash go negative. This means you're tapping into your overdraft account, which we prefer to call Revolver. The main difference in modeling implications is difference between your assumed interest income rate and ... Read More
n Excel, yes anything is possible. Some lazy ppl get lazy with best practices and have cash go negative. This means you're tapping into your overdraft account, which we prefer to call Revolver. The main difference in modeling implications is difference between your assumed interest income rate and ... Read More
Re: Selling Receivables
Sell A/R = raise debt.
Sell A/R = raise debt.
Re: Selling Receivables
I think we'd rather you increase debt instead of subtract cash. This will avoid negative cash balance, but the impact to Net Debt would be the same either way. Also, keep in mind, we would ONLY do this if only ONE company out of all your comp sets do this. We might even say we don't bother with this... Read More
I think we'd rather you increase debt instead of subtract cash. This will avoid negative cash balance, but the impact to Net Debt would be the same either way. Also, keep in mind, we would ONLY do this if only ONE company out of all your comp sets do this. We might even say we don't bother with this... Read More
Re: Selling Receivables
It depends on if you sell the receivables with or without recourse. Non-recourse (the bank takes the hit upon default by customer) factoring is considered to be SOLD to the buyer (the bank). In such a case, the "fee" is treated similar to regular Trade Discounts: Recall the four things that reduc... Read More
It depends on if you sell the receivables with or without recourse. Non-recourse (the bank takes the hit upon default by customer) factoring is considered to be SOLD to the buyer (the bank). In such a case, the "fee" is treated similar to regular Trade Discounts: Recall the four things that reduc... Read More
In an M&A deal, the minimum working capital requirement is similar to the min cash concept, but in practice, it makes it to the purchase agreements as a purchase price allocation. Making an estimate for it depends on the type of company it is. I.e. Manufacturing vs. services based. If services based... In an M&A deal, the minimum working capital requirement is similar to the min cash concept, but in practice, it makes it to the purchase agreements as a purchase price allocation. Making an estimate for it depends on the type of company it is. I.e. Manufacturing vs. services based. If services based, it’s usually anywhere from 30 to 60 days of expenses. For manufacturing really depends on cash conversion cycle. You’d really need to know from the CFO what the requirement is in order to run the business. They need that level in the company after you buy/invest. If they dividend in excess, purchase price goes down since you need to “replenish” to get working cap back to that level. Read More