Posts by: Guest 1
Re: Shares Outstanding
yes I understand the number you would use for valuation purposes, I guess what I meant was when spreading the historicals should I simply use the weighted average number they used to calculate EPS so that my spreaded figures tie in with historical EPS?
yes I understand the number you would use for valuation purposes, I guess what I meant was when spreading the historicals should I simply use the weighted average number they used to calculate EPS so that my spreaded figures tie in with historical EPS?
RE: Quick & Dirty Basic LBO Model: Modeling Private Cos
hi, can you give me a simple example on the changes that take place in the sources and uses in the balance sheet. what i need to understand is the following: 1) the sources of cash increases by the same amount of the uses, so the cash stays the same. right? 2) the old debt remains the same... Read More
hi, can you give me a simple example on the changes that take place in the sources and uses in the balance sheet. what i need to understand is the following: 1) the sources of cash increases by the same amount of the uses, so the cash stays the same. right? 2) the old debt remains the same... Read More
Short cut for increase/decrease decimal point
Can you please remind me how to put that short cut in - I had done it previously for it to appeart in the Format menu.
Can you please remind me how to put that short cut in - I had done it previously for it to appeart in the Format menu.
Is there a premium paid to the existing shareholders?
Is there a premium paid to the existing shareholders during the LBO transaction? i.e., the event of taking the company private? If so, why?
Is there a premium paid to the existing shareholders during the LBO transaction? i.e., the event of taking the company private? If so, why?
Complex LBO - putting short term and long term debt together
In the video Hamilton explains how to put in the current proporiton of the short term debt into the long term debt in order to allow for the fact that if we are modelling out various debt tranches we may not have the short term proportion of the debt available. He deletes the short term debt(481 i... Read More
In the video Hamilton explains how to put in the current proporiton of the short term debt into the long term debt in order to allow for the fact that if we are modelling out various debt tranches we may not have the short term proportion of the debt available. He deletes the short term debt(481 i... Read More
dollar sign to "R"
Hi: I have found your course extremely useful in assisting me to quickly develop financial models. your work is much appreciated. i kindly enquire how one would change the excel to use "R" for south african rand instead of the dollar sign in one's financial model? example: R 8602 inste... Read More
Hi: I have found your course extremely useful in assisting me to quickly develop financial models. your work is much appreciated. i kindly enquire how one would change the excel to use "R" for south african rand instead of the dollar sign in one's financial model? example: R 8602 inste... Read More
Re: Shares Outstanding
perfect, thank you
perfect, thank you
Quick & Dirty Basic LBO: transaction enterprise value
Hi. when you are calculating the transaction enterprise value,you use the sum of the equity acquisition and the existing net debt refinanced to arrive at the transaction enterprise value. But the $750 maintained on books has the significant effect on the amount of the existing net debt refinanced... Read More
Hi. when you are calculating the transaction enterprise value,you use the sum of the equity acquisition and the existing net debt refinanced to arrive at the transaction enterprise value. But the $750 maintained on books has the significant effect on the amount of the existing net debt refinanced... Read More
revolver
I forget what the discretionary revolver is intended to do. If I recall correctly from the lesson, there was no actual revolving line of credit from WMT, but you put in a revolver line item to calculate the discretionary debt sweep. Can you please give me a refresher and let me know why this is on... Read More
I forget what the discretionary revolver is intended to do. If I recall correctly from the lesson, there was no actual revolving line of credit from WMT, but you put in a revolver line item to calculate the discretionary debt sweep. Can you please give me a refresher and let me know why this is on... Read More
I recently completed the core model seminar. I would like to know how I can use my core model developed in class and add a DCF valuation tab to forecast the value of a firm? What information do I need to add the DCF valuation? Are there any templates available at Wall Street Training that I can... I recently completed the core model seminar. I would like to know how I can use my core model developed in class and add a DCF valuation tab to forecast the value of a firm?
What information do I need to add the DCF valuation? Are there any templates available at Wall Street Training that I can use?
Thank you for your help. Read More