Posts by: WST Expert 1
Re: WST Macros Add-In not appearing on toolbar
In Excel for Mac 2016, the menu/ribbon does not show up, but the shortcut keys all work. The natural downside to this is that any functions without shortcut keys cannot be accessed. This is due to Microsoft’s decision to exclude certain code functionality in their latest versions of Excel for M... Read More
In Excel for Mac 2016, the menu/ribbon does not show up, but the shortcut keys all work. The natural downside to this is that any functions without shortcut keys cannot be accessed. This is due to Microsoft’s decision to exclude certain code functionality in their latest versions of Excel for M... Read More
X
-0/excel_add_in_instructions-343?single=1913&parent=1910" class="comm_tool fl">Go to post
added 9 years ago
NOTICE
Trying to get property of non-object
/home/pixelfind/product/html/resources/cache_p/dXNlcl91c2VyX3Bvc3Rz.php
Trying to get property of non-object
/home/pixelfind/product/html/resources/cache_p/dXNlcl91c2VyX3Bvc3Rz.php
#54
Re: Gain/Loss on Derivative for Oil & Gas Company
Historically, we typically do not adjust because it is considered recurring. Exceptions might be one-time shock events, but even then, it depends because chances are their comps will have similar impact. Exceptions apply of course - if one company hedges a lot and one doesn't, then you might want to... Read More
Historically, we typically do not adjust because it is considered recurring. Exceptions might be one-time shock events, but even then, it depends because chances are their comps will have similar impact. Exceptions apply of course - if one company hedges a lot and one doesn't, then you might want to... Read More
Re: Mac excel Background
Unfortunately, there is no option to set the gray window background on the Mac. This, among other reasons, is why we commonly suggest using VMware Fusion or similar products to run Excel on Windows even when using a Mac computer. Highlighting the entire sheet as gray may be a temporary solution w... Read More
Unfortunately, there is no option to set the gray window background on the Mac. This, among other reasons, is why we commonly suggest using VMware Fusion or similar products to run Excel on Windows even when using a Mac computer. Highlighting the entire sheet as gray may be a temporary solution w... Read More
Re: TEV
Yes, that is what we said in the original reply.
In the future, please provide more specifics in your questions.
Thank you.
Yes, that is what we said in the original reply.
In the future, please provide more specifics in your questions.
Thank you.
Re: TEV
Once again, TEV assumes appropriate level of working capital that does not required additional funds, i.e. a run-rate company and if you have working capital shortfalls, you may not be a going concern. If you have a (small) shortfall of working capital to sustain the day-to-day business, then ye... Read More
Once again, TEV assumes appropriate level of working capital that does not required additional funds, i.e. a run-rate company and if you have working capital shortfalls, you may not be a going concern. If you have a (small) shortfall of working capital to sustain the day-to-day business, then ye... Read More
Re: TEV
For traditional definition of TEV please refer to our Corporate Valuation class: Equity Value (market value) + Total Debt (financial interest bearing negotiated securities) - Cash (should be excess cash but most people use total cash) + Preferred + Minority Interest (or NCI). For specific sub-... Read More
For traditional definition of TEV please refer to our Corporate Valuation class: Equity Value (market value) + Total Debt (financial interest bearing negotiated securities) - Cash (should be excess cash but most people use total cash) + Preferred + Minority Interest (or NCI). For specific sub-... Read More
Re: Off-balance sheet Inventory Financing
That's very possible as well. We may need additional information on the specific situation at hand to come up a more accurate assessment. Of course, we understand that may not always be possible due a variety of reasons; however, any further details you can provide would be helpful.
That's very possible as well. We may need additional information on the specific situation at hand to come up a more accurate assessment. Of course, we understand that may not always be possible due a variety of reasons; however, any further details you can provide would be helpful.
Re: Growth Rate Math
Using gordon growth formula, you would essentially solve for g:
TV = CF (1+g) / (r-g)
using algebra, solve for g:
g = (TV * r - CF) / (CF + TV)
Using gordon growth formula, you would essentially solve for g:
TV = CF (1+g) / (r-g)
using algebra, solve for g:
g = (TV * r - CF) / (CF + TV)
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
The illustrative offer price comes out of your valuation model. The process for every transaction is the same: 1) build financial projection model for future profits and cash flow 2) build valuation model (fundamental and relative valuation) 3) do the deal - whether an M&A or LBO, etc Of cours... The illustrative offer price comes out of your valuation model. The process for every transaction is the same:
1) build financial projection model for future profits and cash flow
2) build valuation model (fundamental and relative valuation)
3) do the deal - whether an M&A or LBO, etc
Of course, then we sensitize the offer price to show different sensitivities and scenarios. Read More