Posts by: Guest 1
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
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
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?
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?
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
Do any companies provide cost of debt for WACC calculation purpose for the companies? Is there any such database that is used?
Thanks
Rohit
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!!
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!!
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.
Full Question:
I was wondering how to build a macro for formulas and constants to be black and blue.
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.
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.
LTM / Quarterly Financials
Is there a package or session that covers integrating quarterly info into the core model to create LTM financials?
Is there a package or session that covers integrating quarterly info into the core model to create LTM financials?
How do I get the file name automatically in a given cell?
Full Question:
Is there a formula or command that will state the file name you are currently working on in a cell? We wanted to have the title automatically update with the version we were working on. Thank you.
Full Question:
Is there a formula or command that will state the file name you are currently working on in a cell? We wanted to have the title automatically update with the version we were working on. Thank you.
Cash Flow Projection / Capital Structure Change Modeling
which would be the best package for modeling out cash flow projections based on capital structure changes? After completing the advanced modeling module, I know I can just input new tranches of debt with assumed interest rates and flow that to come up with free cash flow projections...but wondering... Read More
which would be the best package for modeling out cash flow projections based on capital structure changes? After completing the advanced modeling module, I know I can just input new tranches of debt with assumed interest rates and flow that to come up with free cash flow projections...but wondering... Read More
What does in-the-money and out-of-the-money options mean? Thanks!!