Posts by: Guest 1
Beverage total debt
For BUD in particular, there were $153mm of Other Long Term Liabilities that the quiz said counted as debt because they were “Other long term obligations”, but that is not how they are represented in the actual BUD financials – is this a mistake? (I would typically NOT include Other Liabilitie... Read More
For BUD in particular, there were $153mm of Other Long Term Liabilities that the quiz said counted as debt because they were “Other long term obligations”, but that is not how they are represented in the actual BUD financials – is this a mistake? (I would typically NOT include Other Liabilitie... Read More
Beverage cash
For the quizzes on the beverages, the answer key was NOT adding in Marketable/Investment Securities or Short Term Investments back to cash, yet typical practice, as well as Hamilton’s presentation, implied that at least Short Term Investments should be added to cash, as they are easily converted t... Read More
For the quizzes on the beverages, the answer key was NOT adding in Marketable/Investment Securities or Short Term Investments back to cash, yet typical practice, as well as Hamilton’s presentation, implied that at least Short Term Investments should be added to cash, as they are easily converted t... Read More
Capital Leases, and other scenarios
1. Why capital leases are not included in the total debt figure? Why operating leases are not included in interest expense ratios and debt ratios? 2. When you encounter that Total Debt/Total Capitalization is lower than the company's target ratio, will we see a spreadsheet in a different module t... Read More
1. Why capital leases are not included in the total debt figure? Why operating leases are not included in interest expense ratios and debt ratios? 2. When you encounter that Total Debt/Total Capitalization is lower than the company's target ratio, will we see a spreadsheet in a different module t... Read More
Beginning vs. Average Balance, and Diluted Shares Outstanding
1. Debt Sweep Tab, Interest Schedule, F67, in the case of Interest Income and Interest Expense, what is more commonly use, beginning balance or average balance?
2. Can you please explain again the Diluted Shares Outstanding formula (IS tab, cell I24)?
1. Debt Sweep Tab, Interest Schedule, F67, in the case of Interest Income and Interest Expense, what is more commonly use, beginning balance or average balance?
2. Can you please explain again the Diluted Shares Outstanding formula (IS tab, cell I24)?
Projecting minority interest
How should I project Minority Interest expense on the BS and CF?
How should I project Minority Interest expense on the BS and CF?
Cash requirement
For my job, I'm recently working on an US M&A transaction and come up with some practical questions, while I'd appreciate if you can provide me some insight. The vendor plan to distribute all of its excess cash before the closing, however, the managemnet is yet to provide us a cash requirement le... Read More
For my job, I'm recently working on an US M&A transaction and come up with some practical questions, while I'd appreciate if you can provide me some insight. The vendor plan to distribute all of its excess cash before the closing, however, the managemnet is yet to provide us a cash requirement le... Read More
Re: Editing WST Macros
So it is not possible to create a macro with a conflicting shortcut and have it take priority to the wst macro? Do wst's add-in shortcuts take global priority over all other custom macros with conflicting shortcuts?
So it is not possible to create a macro with a conflicting shortcut and have it take priority to the wst macro? Do wst's add-in shortcuts take global priority over all other custom macros with conflicting shortcuts?
Re: Editing WST Macros
Is there a way to override one of your shortcuts instead? I've written a macro that will do what I need but as soon as I enable the WST add-in, my written add-in stops working. Is there something in the WST code that overrides any other add-in installed?
Is there a way to override one of your shortcuts instead? I've written a macro that will do what I need but as soon as I enable the WST add-in, my written add-in stops working. Is there something in the WST code that overrides any other add-in installed?
Editing WST Macros
Hey guys, I'm embarking on a large modeling project and per a senior banker's request, I need to use specific formatting (colors, text type, etc.) for his model. Oh the joys of a power-hungry MD. Anyways, I've been using WST macros for years now and he's trying to make me stop using them and u... Read More
Hey guys, I'm embarking on a large modeling project and per a senior banker's request, I need to use specific formatting (colors, text type, etc.) for his model. Oh the joys of a power-hungry MD. Anyways, I've been using WST macros for years now and he's trying to make me stop using them and u... Read More
Finally, PEP had Preferred Equity line items that the answer key did not include in Debt or Equity (even for the purpose of the Capitalization Ratio), so just wanted to confirm that that, for the purposes of these exercises, we do not need to worry about Preferred Equity (I realize it was basically ... Finally, PEP had Preferred Equity line items that the answer key did not include in Debt or Equity (even for the purpose of the Capitalization Ratio), so just wanted to confirm that that, for the purposes of these exercises, we do not need to worry about Preferred Equity (I realize it was basically negative in this case, but still want to make sure as I go through the training modules.) Read More