Posts by: Guest 1
Re: Core Model DCF - terminal cashflow
I know that, my question still stands...
I know that, my question still stands...
Bank Modeling
My query pertains to the accounting for credit losses for banks. When there is a recovery by a bank, it should reduce the provision expense on the income statement and also reduce the loan reserve. Per the provision for credit losses video, recoveries increase the loan reserve balance on the balance... Read More
My query pertains to the accounting for credit losses for banks. When there is a recovery by a bank, it should reduce the provision expense on the income statement and also reduce the loan reserve. Per the provision for credit losses video, recoveries increase the loan reserve balance on the balance... Read More
Accessing the file location for auto-starting macro toolbar
Full Question:
I do not understand how to save the macro toolbar file into the assigned folder (C:\Documents and Settings\<USER NAME>\Application Data\Microsoft\Excel\XLSTART)
Full Question:
I do not understand how to save the macro toolbar file into the assigned folder (C:\Documents and Settings\<USER NAME>\Application Data\Microsoft\Excel\XLSTART)
RE: Complex Trading Comps Analysis: Weighs question
Thank you fro the quick reply but this is not what i was looking for. In the wacc calculation of WMart in cells H21:H24 you have hard inputed some numbers. In cell K21 you have a D/E ratio of 20% which is derived from the division of cells H21/H23. My question id the following: If the target c... Read More
Thank you fro the quick reply but this is not what i was looking for. In the wacc calculation of WMart in cells H21:H24 you have hard inputed some numbers. In cell K21 you have a D/E ratio of 20% which is derived from the division of cells H21/H23. My question id the following: If the target c... Read More
Re: Ability to Pay Analysis
Understood but in this case we should not assume any synergies, the synergies point is the one confusing me since it is not the target NI that benefits but rather the new combined Net Income.
Understood but in this case we should not assume any synergies, the synergies point is the one confusing me since it is not the target NI that benefits but rather the new combined Net Income.
adv lbo model questions
a bunch of questions in the advanced lbo model. Sources and uses: uses: this is likely a stock (not asset) purchase (as debt is refi'd/purchased/needs to be taken care of...)? what is the equity prem based from? if co has lot of cash, them would this affect eq prem? don't see cash or min int in u... Read More
a bunch of questions in the advanced lbo model. Sources and uses: uses: this is likely a stock (not asset) purchase (as debt is refi'd/purchased/needs to be taken care of...)? what is the equity prem based from? if co has lot of cash, them would this affect eq prem? don't see cash or min int in u... Read More
Selecting two or more non-adjacent cells to quicky get sum
Full Question:
Is there any way to highlight two or more NON-ADJACENT cells to make formatting changes to? Also, would like to highlight two non-adjacent cells to get a quick sum of the values.
Full Question:
Is there any way to highlight two or more NON-ADJACENT cells to make formatting changes to? Also, would like to highlight two non-adjacent cells to get a quick sum of the values.
Quick & Dirty LBO
I have just done the online Quick & Dirty LBO and have some questions versus the Quick & Dirty we did with Hamiliton in class in September: - Shareholders equity: should be the equity we pay less transaction costs per online version. We did not do this in class but rather took the equity pa... Read More
I have just done the online Quick & Dirty LBO and have some questions versus the Quick & Dirty we did with Hamiliton in class in September: - Shareholders equity: should be the equity we pay less transaction costs per online version. We did not do this in class but rather took the equity pa... Read More
Working Capital in FCF for Valaution Purposes
I would like if I may, to get your insight on why Changes in Working capital are relevant to calculating FCF for valuation purposes as I currently hold the opinion that it is largely not and would appreciate your insight. In calculating Working capital for valuation purposes text books focus on cur... Read More
I would like if I may, to get your insight on why Changes in Working capital are relevant to calculating FCF for valuation purposes as I currently hold the opinion that it is largely not and would appreciate your insight. In calculating Working capital for valuation purposes text books focus on cur... Read More
Full Question: I would like to know how to correctly estimate exchange ratios in case of all-stock-transactions based on leverage-adjusted EBITDA, TEV, Equity Value, and Earnings contribution analysis. Think an adjustment needs to be made to account for the difference in capital structure of both c... Full Question:
I would like to know how to correctly estimate exchange ratios in case of all-stock-transactions based on leverage-adjusted EBITDA, TEV, Equity Value, and Earnings contribution analysis. Think an adjustment needs to be made to account for the difference in capital structure of both companies. Read More