Posts by: Guest 1
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
Re: Selling Receivables
Thank you, this has been very educational and helpful!
Thank you, this has been very educational and helpful!
Re: Selling Receivables
does this ever happen in the real world? I don't recall seeing any companies with a negative cash balance on their B/S
does this ever happen in the real world? I don't recall seeing any companies with a negative cash balance on their B/S
Re: Selling Receivables
Ok I got it. Is it theoretically and practically possible to have a negative cash balance on a Company's B/S?
Ok I got it. Is it theoretically and practically possible to have a negative cash balance on a Company's B/S?
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... 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 that includes this scenario, so we can see the automatic adjustment?
3. Do you have S&P Median Industry by Sector Rating Statistics that you can provide?
4. In the Reference Range Tab, in the section of Discounted Cash Flow Analysis, row 45 & 46, why the numbers on the Implied Enterprise Value, Implied Equity Value and Implied Price per Share are not the same as the ones estimated in the DCF tab? Read More