Posts by: Guest 1
RE: AFM Enhancements: Valuation Question
Just relized that you have already responded to my question. A follow up question: if we know for sure that the capital increase is to happen, like you suggested, we model out the company as a going concern with all known facts. I think we should calculate the valuation of our current holding by m... Read More
Just relized that you have already responded to my question. A follow up question: if we know for sure that the capital increase is to happen, like you suggested, we model out the company as a going concern with all known facts. I think we should calculate the valuation of our current holding by m... Read More
Valuation Question
If we take the pepsi model you went over for example. once we have taken the PV of unlevered FCF and the terminal value (by taking a multiple to EBITDA), how should we think about the cash and debt in arriving at the equity value? If we had projected the balance sheet out to the terminal value date ... Read More
If we take the pepsi model you went over for example. once we have taken the PV of unlevered FCF and the terminal value (by taking a multiple to EBITDA), how should we think about the cash and debt in arriving at the equity value? If we had projected the balance sheet out to the terminal value date ... Read More
Re: Debt Extinguishment - Equity offered
Sorry, here are all the numbers and factors. The company is privately held but is registered with the SEC. So no need I guess for hiding some of the details.... At year end 12.31.09 the cap structure was: $125 MM ABL Revolver $360 MM Sub notes 9% due 2012 $700 MM Secured Notes 11.75% due 2013 ... Read More
Sorry, here are all the numbers and factors. The company is privately held but is registered with the SEC. So no need I guess for hiding some of the details.... At year end 12.31.09 the cap structure was: $125 MM ABL Revolver $360 MM Sub notes 9% due 2012 $700 MM Secured Notes 11.75% due 2013 ... Read More
Modeling/Projecting Floating Rates
I just completed the quick and dirty and advanced LBO courses and had a real world question: With bank debt being at a spread above LIBOR, how do u usually deal with projecting/modeling floating rate interest rates (for bank debt) in leveraged models? Do you assume a constant libor for say 5 yea... Read More
I just completed the quick and dirty and advanced LBO courses and had a real world question: With bank debt being at a spread above LIBOR, how do u usually deal with projecting/modeling floating rate interest rates (for bank debt) in leveraged models? Do you assume a constant libor for say 5 yea... Read More
RE: How do I treat Deferred Maintenance Revenues in TEV?
Thank you for your email. The deferred maintenance liabilities relates to software maintenance contracts. Normally the company receives cash upfront at the start of the 3 year maintenance contract and then has an obligation to perform on such contract over the 3 year period. These obligations are wh... Read More
Thank you for your email. The deferred maintenance liabilities relates to software maintenance contracts. Normally the company receives cash upfront at the start of the 3 year maintenance contract and then has an obligation to perform on such contract over the 3 year period. These obligations are wh... Read More
Re: Debt Extinguishment - Equity offered
I hope you saw my first reply to your message. Another question, how do I handle the new $150MM sub debt issuance on 1/11/10? There does not seem to be a slot for new debt issuances onthe debt sweep. thanks again
I hope you saw my first reply to your message. Another question, how do I handle the new $150MM sub debt issuance on 1/11/10? There does not seem to be a slot for new debt issuances onthe debt sweep. thanks again
Re: Cannot FULLY use WSTMacros3.4.2.xla on Excel 2013
I have tried "Alt+X+S" and doesn't work. I can see that the add-in is installed when I go through the "Excel Options" menu, but do not see the add-in when typing in "Alt+X+S". All other functionality works. I have also tried to uninstall/ install a few times and stil... Read More
I have tried "Alt+X+S" and doesn't work. I can see that the add-in is installed when I go through the "Excel Options" menu, but do not see the add-in when typing in "Alt+X+S". All other functionality works. I have also tried to uninstall/ install a few times and stil... Read More
RE: How to project minority interest?
Should net income always be net of minority interest? And should we caluclate earning/share based on earning net or minority interest?
Should net income always be net of minority interest? And should we caluclate earning/share based on earning net or minority interest?
RE: AFM Enhancements: Valuation Question
Thanks.
Thanks.
Any functionality that requires you to start with "Alt+S" doesn't work on Excel 2013.