Posts by: Guest 1
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
Tax rate in WACC
Hello, I have a question in regards to the tax rate used in WACC. Per Hamilton's WACC calculation model, he puts Marginal Tax Rate as the rate to use in WACC. My question is where can we find the marginal tax rate? Is this something that's deduced, is using effective tax rate vastly incorrect? ... Read More
Hello, I have a question in regards to the tax rate used in WACC. Per Hamilton's WACC calculation model, he puts Marginal Tax Rate as the rate to use in WACC. My question is where can we find the marginal tax rate? Is this something that's deduced, is using effective tax rate vastly incorrect? ... Read More
Re: Insurance financial modeling
During the course the piece on CapEx depreciation wasn't working on my computer. The video got stuck somehow. Could you please post the formulas for: - CapEx depreciation (CF columns G-K rows 41-46), - PPE & Intangibles (BS columns F-K row 23), - Depreciation & Amortization (IS columns F-K... Read More
During the course the piece on CapEx depreciation wasn't working on my computer. The video got stuck somehow. Could you please post the formulas for: - CapEx depreciation (CF columns G-K rows 41-46), - PPE & Intangibles (BS columns F-K row 23), - Depreciation & Amortization (IS columns F-K... Read More
Balancing the Core Model
I am done with all the core and advanced financial modeling videos. I don't quite understand why the balance sheet balances in the end. I understand the logic behind the debt sweep pertaining to the revolver, and how its used to pay down or borrow cash, and the fact that the ending debt balances imp... Read More
I am done with all the core and advanced financial modeling videos. I don't quite understand why the balance sheet balances in the end. I understand the logic behind the debt sweep pertaining to the revolver, and how its used to pay down or borrow cash, and the fact that the ending debt balances imp... Read More
Re: Insurance financial modeling
During the course on CapEx depreciation, the video got stuck somehow. I couldn't watch it on my computer. Could you therefore please post the formulas for: - CapEx depreciation (CF rows 41-46) - PPE & Intangibles (BS row 23) - Depreciation & Amortization (IS row 23) - Existing Depreciation ... Read More
During the course on CapEx depreciation, the video got stuck somehow. I couldn't watch it on my computer. Could you therefore please post the formulas for: - CapEx depreciation (CF rows 41-46) - PPE & Intangibles (BS row 23) - Depreciation & Amortization (IS row 23) - Existing Depreciation ... Read More
Quick & Dirty Basic LBO Model: text book
hi guys,
do u know any good text books on leveraged buyouts? detailed process, valuation, etc...
appreciate it
ayman
hi guys,
do u know any good text books on leveraged buyouts? detailed process, valuation, etc...
appreciate it
ayman
How would you go about valuing a company?
I am aware of the valuation methodologies such as Discounted Cash Flow, Company Comparable Analysis etc. but am unsure of what the relevant steps are to come to a valuation for a company. Does it matter which valuation method should be used? Also, what could potentially impact a valuation that I cou... Read More
I am aware of the valuation methodologies such as Discounted Cash Flow, Company Comparable Analysis etc. but am unsure of what the relevant steps are to come to a valuation for a company. Does it matter which valuation method should be used? Also, what could potentially impact a valuation that I cou... Read More
Re: dollar sign to "R"
Hi again:
The assistance you have provided is very useful and accurate.
I am glad to have resolved my problem.
Thank you very much and I look forward to further collaborations and courses.
Jiten
Hi again:
The assistance you have provided is very useful and accurate.
I am glad to have resolved my problem.
Thank you very much and I look forward to further collaborations and courses.
Jiten
perfect, thank you