Posts by: Guest 1
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
Re: Bank Modeling
I understand that gross recoveries are netted against gross charge offs to arrive at net charge offs and also that gross charge offs don't have any income statement impact as the loan reserve and loan asset are both reduced with no impact statement impact. Please take a look at the JP Morgan Allowan... Read More
I understand that gross recoveries are netted against gross charge offs to arrive at net charge offs and also that gross charge offs don't have any income statement impact as the loan reserve and loan asset are both reduced with no impact statement impact. Please take a look at the JP Morgan Allowan... Read More
Summarize ways to copy & paste efficiently in Excel
Full Question:
The commands that move data/formats/formulas over such as Ctrl+R, highlighting and hitting Ctrl Enter, etc. I know some bring just the formula over and some bring the formula over as well as the formatting. Can you provide a summery of which provides which?
Full Question:
The commands that move data/formats/formulas over such as Ctrl+R, highlighting and hitting Ctrl Enter, etc. I know some bring just the formula over and some bring the formula over as well as the formatting. Can you provide a summery of which provides which?
Merger Modeling Basics: about the goodwill amortization
Hi, if there is no goodwill amortization, but under certain circumstances, the deal can be considered as asset deal , or can be applied the normal asset depreciation, even there is no amortization on goodwill in this case, I think you still have to incorporate the depreciation into the model, becaus... Read More
Hi, if there is no goodwill amortization, but under certain circumstances, the deal can be considered as asset deal , or can be applied the normal asset depreciation, even there is no amortization on goodwill in this case, I think you still have to incorporate the depreciation into the model, becaus... Read More
GAAP requirement to recognize all known liabilities
In the M&A module, when illustrating the different effective tax rates in the Pre-/Post-142/338 election scenarios, it is stated that GAAP requires all companies to recognize all known liabilities as soon as possible, hence why under a 338 election, the reported GAAP effective tax rate is lower ... Read More
In the M&A module, when illustrating the different effective tax rates in the Pre-/Post-142/338 election scenarios, it is stated that GAAP requires all companies to recognize all known liabilities as soon as possible, hence why under a 338 election, the reported GAAP effective tax rate is lower ... Read More
List of random numbers from -1 to 1 with given std dev
Full Question:
Is it possible to create a list of random numbers from -1 to 1 with a given standard deviation?
Full Question:
Is it possible to create a list of random numbers from -1 to 1 with a given standard deviation?
Hedge Fund - why the double counting ???
isn't the SHORT & LONG(from SHORT) exactly the same (in & out) ? so why are we double counting them when we calculate the Total Invested Capital?????
isn't the SHORT & LONG(from SHORT) exactly the same (in & out) ? so why are we double counting them when we calculate the Total Invested Capital?????
Merger Modeling Basics: the question about the Fees
I have question about the place we can add the deal fees on the pro forma statement, in your presentation, you simply added the fees on the acquiring firm's pro forma debt balance, why you cann't split up the amount, put 50% of the fees on debt and 50% on equity. great thanks.
I have question about the place we can add the deal fees on the pro forma statement, in your presentation, you simply added the fees on the acquiring firm's pro forma debt balance, why you cann't split up the amount, put 50% of the fees on debt and 50% on equity. great thanks.
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.