Posts by: Guest 1
Modeling 'Names' used in IB/PE - Question
Hi Fellas! I have an empty background (education/experience) except in snow-shoveling..and when I read about Private Equity or Investment Banking, I come across the modeling subject and this one and only question- How many [types of] financial models do IB & PE firms use? I mean what analyst, ... Read More
Hi Fellas! I have an empty background (education/experience) except in snow-shoveling..and when I read about Private Equity or Investment Banking, I come across the modeling subject and this one and only question- How many [types of] financial models do IB & PE firms use? I mean what analyst, ... Read More
Capital leases - exclude vs include
Full Question: When COSTCO's debt is being calculated, long-term debt and current portion of long-term debt from latest 10Q are simply added. However, long-term debt includes capital leases and there was no adjustment for that. Is there a special reason for not deducting the capital leases in case ... Read More
Full Question: When COSTCO's debt is being calculated, long-term debt and current portion of long-term debt from latest 10Q are simply added. However, long-term debt includes capital leases and there was no adjustment for that. Is there a special reason for not deducting the capital leases in case ... Read More
AFM Enhancements: Football Field PDF
Where may I find the PDF file mentioned in the "Reference Range" lecture on creating a football field chart?
Where may I find the PDF file mentioned in the "Reference Range" lecture on creating a football field chart?
Ability to Pay Analysis
- the Net Income of $10m is the Target company Net Income? Not sure here since Change in NI assumes NIL accretion/dilution at break even PE, right? If so then it would be NI of Target & Acquiror since accretion/dilution is calculated on the new NI? Confused here - If it is Target NI then why is ... Read More
- the Net Income of $10m is the Target company Net Income? Not sure here since Change in NI assumes NIL accretion/dilution at break even PE, right? If so then it would be NI of Target & Acquiror since accretion/dilution is calculated on the new NI? Confused here - If it is Target NI then why is ... Read More
LBO of a public company
I am modeling out an private equity sponsored LBO of public company - using the construct of the core model. Naturually I have historical financials - in addition I have a proforma income statement and balance sheet -- to reflect the go-forward position of the company. I am having difficulty get... Read More
I am modeling out an private equity sponsored LBO of public company - using the construct of the core model. Naturually I have historical financials - in addition I have a proforma income statement and balance sheet -- to reflect the go-forward position of the company. I am having difficulty get... Read More
Distressed Credit Overview - Valuation questions
1. Slide 29 a. Where do bank vs bonds fall in this cap structure diagram (unclear) b. Senior debt i. Even though it has a 1st or 2nd lien on assets, is it always considered “unsecured” and not “secured”? why – i... Read More
1. Slide 29 a. Where do bank vs bonds fall in this cap structure diagram (unclear) b. Senior debt i. Even though it has a 1st or 2nd lien on assets, is it always considered “unsecured” and not “secured”? why – i... Read More
Circular reference problem in my model due to interest-HELP!
Full Question: I have created an interest tab where I would like to derive my interest expense and debt amortization schedule. I would like both of these to feed into the income statement and balance sheet in financials tab. In the debt amortization schedule I would like to derive the cash flow swe... Read More
Full Question: I have created an interest tab where I would like to derive my interest expense and debt amortization schedule. I would like both of these to feed into the income statement and balance sheet in financials tab. In the debt amortization schedule I would like to derive the cash flow swe... Read More
Re: Merger modeling - Purchase price allocation
And what was the reasoning for you guys to "choose the base of the %ages to be applied to the excess..."? That's what I am interested to understand... the logic you used here?
Thanks.
And what was the reasoning for you guys to "choose the base of the %ages to be applied to the excess..."? That's what I am interested to understand... the logic you used here?
Thanks.
Re: Modeling 'Names' used in IB/PE - Question
Hi, As rightly pointed out in the earlier post, there are no defined types of models that can be developed for valuation. Modeling involves understanding the situation in which you are developing a model. The characteristics of the industry in which the company is present plays a crucial role in de... Read More
Hi, As rightly pointed out in the earlier post, there are no defined types of models that can be developed for valuation. Modeling involves understanding the situation in which you are developing a model. The characteristics of the industry in which the company is present plays a crucial role in de... Read More
You're gonna have to give me more than this. Even if capex/depr cancel out (which would never happen unless you spend exactly the same capex money for exactly the same capex items for infinity) by taking EBIT at the end of the fifth year this massively overestimates the TV which is discounted at fac... You're gonna have to give me more than this. Even if capex/depr cancel out (which would never happen unless you spend exactly the same capex money for exactly the same capex items for infinity) by taking EBIT at the end of the fifth year this massively overestimates the TV which is discounted at factor 5 whereas your assumption is that "over time" they cancel eachother out. "Over time" could be in 20 years which is a much larger discount factor. Taking EBIT as the final year cash flow in a business where capex totally eats up the EBIT is not right - please convince me otherwise. Read More