Posts by: Guest 1
Automatic Updates
Hi, Problem: I add data to an INPUT column in a spreadsheet monthly. How do I make my functions, other lists and charts, that also need to update accordingly based on the original INPUT column (some of them may be in another worksheet in the same excel file), to automatically recognize that ther... Read More
Hi, Problem: I add data to an INPUT column in a spreadsheet monthly. How do I make my functions, other lists and charts, that also need to update accordingly based on the original INPUT column (some of them may be in another worksheet in the same excel file), to automatically recognize that ther... Read More
Cash Flow and Balance Sheets for M&A Models
I just wanted to confirm that when building full-blown M&A models (like the PEP-TAP Intermediate Model in Module 5) that it is not common practice to build out the entire B/S and C/F statements, such as we did for the advanced financial model in Module 3.
I just wanted to confirm that when building full-blown M&A models (like the PEP-TAP Intermediate Model in Module 5) that it is not common practice to build out the entire B/S and C/F statements, such as we did for the advanced financial model in Module 3.
Leveraged-adjusted exchange ratios in M&A stock deals
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... 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... Read More
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
I ahve one question which may sound really silly and i would like your help. In the complex trading comps analysis we estimated the appropriate weighs in cells I21:I23 by using hard inputs in cells H21:H24. Could you please tell me how we reached to the numbers in the H column? (i.e 20, 100 and 1... I ahve one question which may sound really silly and i would like your help.
In the complex trading comps analysis we estimated the appropriate weighs in cells I21:I23 by using hard inputs in cells H21:H24. Could you please tell me how we reached to the numbers in the H column? (i.e 20, 100 and 120)? Read More