Posts by: Guest 1

How to set up Sources & Uses for <100% LBO?
Full Question: What is the proper way to set up sources and uses for an LBO where the sponsor is acquiring less than 100% of the target? I have typically included lines for roll-over equity in both the S&U in order to get the value of the total equity (rollover and purchased) from the sources t... Read More
Go to post added 11 years ago
RE: Corporate Valuation: capital lease
Hi, in the valuation methodologies video it is mentioned that capital leases should not be added to debt because they could be considered operating leases. In the previous reply, however, it is mentioned that "rating agnecies always add back leases, both operating and capital". What is the correc... Read More
Go to post added 11 years ago
Capitalizing vs Expensing Interest
I am working through the accounting boot camp and have a question regarding the effect on cash flow when interest is capitalized versus expensed. I understand in theory that cash flow is supposedly unchanged in either scenario and that the difference is merely the allocation of the interest (if cap... Read More
Go to post added 11 years ago
Re: Options Exerciseable versus Outstanding - Complex LBO
What does in-the-money and out-of-the-money options mean? Thanks!!
Go to post added 11 years ago
Private Company M&A and LBO adjustments
Full Question: In the Core Merger Modelling Topics module, the models you build concern public listed companies either as acquirors or as targets. What are the effects on a model when the target is a private (not listed company) or a Business Unit that a corporation wants to dispose. For example le... Read More
Go to post added 11 years ago
How do I assign a shortcut key to previously created macros?
Full Question:
How do I add the keystroke shortcut if I have already initially bypassed the prompting to do so when you recording the macro?
Go to post added 11 years ago
Cost of Debt Sources
Do any companies provide cost of debt for WACC calculation purpose for the companies? Is there any such database that is used?

Thanks
Rohit
Go to post added 11 years ago
Employee Stock Purchase Plan
Some companies have employee stock purchase plans where employees can buy stock at a discounted price at certain dates.

Do shares purchased under the employee stock purchase plan increase "basic" share count? Or does it affect the diluted share counts only? Thanks!!
Go to post added 11 years ago
How to I automate blue and black cells for inputs/outputs?
Full Question:
I was wondering how to build a macro for formulas and constants to be black and blue.
Go to post added 11 years ago
Re: Capitalizing vs Expensing Interest
I think I understand. So what you're saying is that in any given fiscal period, the cash flow may not be the same for both scenarios (capitalize and expense) but in the lifetime, so to speak, of the interest the cash flows will ultimately be the same.
Go to post added 11 years ago