Forum Search: oil gas
Re: Creating a summary page for dozens of tabs
Yep! There's an easy of doing this: Step 1) use our macro: Add-Ins, WST, Worksheet, Create Worksheet Index => this creates a new worksheet with list of all your 200+ tabs as currently ordered in your file => the list of worksheets starts in cell A3 and goes down column A Step 2) in cell B2, type... Read More
Yep! There's an easy of doing this: Step 1) use our macro: Add-Ins, WST, Worksheet, Create Worksheet Index => this creates a new worksheet with list of all your 200+ tabs as currently ordered in your file => the list of worksheets starts in cell A3 and goes down column A Step 2) in cell B2, type... Read More
Re: equity IRR
1) IRR question: As with any IRR calculation, your "Year 0" equity investment (equity injection) is your initial cash outflow. If this were a company (structure as an asset acquisition), your terminal value would be the Equity Value of your ownership stake in the company. Interim cash flows would b... Read More
1) IRR question: As with any IRR calculation, your "Year 0" equity investment (equity injection) is your initial cash outflow. If this were a company (structure as an asset acquisition), your terminal value would be the Equity Value of your ownership stake in the company. Interim cash flows would b... Read More
Re: Cash
Recall our conversation that we adjust for capital structure in valuation at the END of the DCF valuation. FCFE, similar to PE is the root of all evil in valuation. Since the point of FCFF is to calculate pre-capital structure cash flow, we want to make sure that the taxes properly reflect this logi... Read More
Recall our conversation that we adjust for capital structure in valuation at the END of the DCF valuation. FCFE, similar to PE is the root of all evil in valuation. Since the point of FCFF is to calculate pre-capital structure cash flow, we want to make sure that the taxes properly reflect this logi... Read More
Re: Editing WST Macros
You must assign an unused shortcut combination to your macro else they will interfere. For instance if you assigned ctrl + c to your macro it will interfere with normal copy keystroke. Find an unused keystroke and voila no problems. For truly custom one-offs for specific client colors etc, that's th... Read More
You must assign an unused shortcut combination to your macro else they will interfere. For instance if you assigned ctrl + c to your macro it will interfere with normal copy keystroke. Find an unused keystroke and voila no problems. For truly custom one-offs for specific client colors etc, that's th... Read More
Re: Cash Circular
Several observations: 1) you have it set to average balance, so of course there will be circular references. Don't forget the entire explanation at the end of the WMT course about 1 for Beginning and 2 for Average. the GREAT news is that once you flip the switch to 1 for Beginning Balance, the circ... Read More
Several observations: 1) you have it set to average balance, so of course there will be circular references. Don't forget the entire explanation at the end of the WMT course about 1 for Beginning and 2 for Average. the GREAT news is that once you flip the switch to 1 for Beginning Balance, the circ... Read More
RE: Free Cash Flow to Firm vs. Free Cash Flow to Equity
In general, free cash flow to equity is a useless number. Free cash flow to firm is by far the superior method over free cash flow to equity. Free cash flow to firm takes into the account the capital structure differences between two companies, again per the enterprise value and equity value relatio... Read More
In general, free cash flow to equity is a useless number. Free cash flow to firm is by far the superior method over free cash flow to equity. Free cash flow to firm takes into the account the capital structure differences between two companies, again per the enterprise value and equity value relatio... Read More
RE: Please clarify if any value is gained by buying back stock.
You have to remember the core lessons from my valuation class! If nothing else has happened to the company, why should there be a change to the value of the company (enterprise value)? If the "core, recurring profitability from core operations" has not changed, there is no change to TEV. Capital str... Read More
You have to remember the core lessons from my valuation class! If nothing else has happened to the company, why should there be a change to the value of the company (enterprise value)? If the "core, recurring profitability from core operations" has not changed, there is no change to TEV. Capital str... Read More
RE: How do you maximize earnings accretion?
Aside from the favorite answer - SYNERGIES, there are several issues to consider when structuring a transaction to maximize earnings accretion. The first question is to whether to pay with stock, cash or a combination of the two. The next question is what are the relative P/E ratios of the Acquiror ... Read More
Aside from the favorite answer - SYNERGIES, there are several issues to consider when structuring a transaction to maximize earnings accretion. The first question is to whether to pay with stock, cash or a combination of the two. The next question is what are the relative P/E ratios of the Acquiror ... Read More
RE: Please clarify if any value is gained by buying back stock-2
You have to remember the core lessons from my valuation class! If nothing else has happened to the company, why should there be a change to the value of the company (enterprise value)? If the "core, recurring profitability from core operations" has not changed, there is no change to TEV. Capital str... Read More
You have to remember the core lessons from my valuation class! If nothing else has happened to the company, why should there be a change to the value of the company (enterprise value)? If the "core, recurring profitability from core operations" has not changed, there is no change to TEV. Capital str... Read More
Hi, Thanks for submitting your question. Generally speaking, it's more useful and practical to know how things work, not just their names! That said, the various types of models you'll encounter in finance are usually aptly named, and all are just that: models. Like you said, a valuation model can... Hi,
Thanks for submitting your question. Generally speaking, it's more useful and practical to know how things work, not just their names!
That said, the various types of models you'll encounter in finance are usually aptly named, and all are just that: models. Like you said, a valuation model can show much much a company is worth. Similarly, an LBO model represents a specific LBO deal, and can vary in complexity depending on the acquisition itself.
There is no official list that we know of that definitively determines which types of models exist or don't exist. For example, let's say you need to value an oil & gas company, which might involve various caveats that aren't applicable in, say, the pharmaceuticals industry. To do so, you calculate the company's value using the discounted cash flow method. Would you call that a DCF model, a valuation model, or an oil & gas company model? All three would be correct, though the third is probably the most effective at communicating its purpose.
One of our goals at WST is to be as comprehensive as possible in making sure firms on Wall Street know how to correctly build their financial models and analyze everything from the inputs to the outputs. You can find more information on the different industries and types of deals that we cover on our [url=http://wallst-training.com/self-study/courses.html:3idz0t5k]Self-Study Courses list[/url:3idz0t5k]. We hope that helps clarify things a bit! Read More