Posts by: Guest 1
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
Distressed Debt Model
In the distressed debt model Hamilton went over, can this model be used to evaluate High Yield bonds? Or High Yield Bonds are a complete separate animal where the distressed model cannot be applied? As I understand, In distressed you are more concerned about figuring out what security to invest an... Read More
In the distressed debt model Hamilton went over, can this model be used to evaluate High Yield bonds? Or High Yield Bonds are a complete separate animal where the distressed model cannot be applied? As I understand, In distressed you are more concerned about figuring out what security to invest an... Read More
RE: Quick & Dirty Basic LBO Model: text book
ok,,, but till you finish your book, can you please recommend me a book that would help me in understanding the LBO further (process, leverage, equity). i need some text in addition to your very useful models, notes and videos.
ok,,, but till you finish your book, can you please recommend me a book that would help me in understanding the LBO further (process, leverage, equity). i need some text in addition to your very useful models, notes and videos.
Calculating Equity and Debt base for WACC
There are two ways to calculate your equity and debt base that go into your WACC calculation. On one side you use book value (shareholders’ equity and total debt). This seems intuitive because it reflects the actual capital structure of the company. On the other side you use market values (mark... Read More
There are two ways to calculate your equity and debt base that go into your WACC calculation. On one side you use book value (shareholders’ equity and total debt). This seems intuitive because it reflects the actual capital structure of the company. On the other side you use market values (mark... 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? ... 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? I tend to see the effective tax rate most often in 10k and 10q Thanks Read More