Posts by: WST Expert 1
Re: Diluted Shares Outstanding - Market Cap
Yes - in a change of control context. If you're doing a DCF (even in the context of and M&A or LBO), you would use options EXERCISABLE because DCF is always standalone valuation, which his exercisable and not outstanding options. Options outstanding become exercisable upon change of control - ... Read More
Yes - in a change of control context. If you're doing a DCF (even in the context of and M&A or LBO), you would use options EXERCISABLE because DCF is always standalone valuation, which his exercisable and not outstanding options. Options outstanding become exercisable upon change of control - ... Read More
Re: Filled Out Template
Unfortunately, we have a strict firm policy of not disseminating completed models. It is our belief that one learns from individually building the models. We understand that sometimes, unexpected things happen, such as computers crashing and lost work. However, in order to maintain the integrity... Read More
Unfortunately, we have a strict firm policy of not disseminating completed models. It is our belief that one learns from individually building the models. We understand that sometimes, unexpected things happen, such as computers crashing and lost work. However, in order to maintain the integrity... Read More
Re: Two different NPV
Hello, The reason why the two NPV methods will NOT have the same outcomes is because the cost of capital for debt and equity is not the same. ONLY when the cost of capital for debt and equity is the same will you have the same NPV figures. For cost of debt, it would be after tax cost of interest ... Read More
Hello, The reason why the two NPV methods will NOT have the same outcomes is because the cost of capital for debt and equity is not the same. ONLY when the cost of capital for debt and equity is the same will you have the same NPV figures. For cost of debt, it would be after tax cost of interest ... Read More
Re: Averaging When Mixing IS and BS Items
Generally speaking for comparison purposes, you would take the average BS when mixing IS and BS items in a ratio.
However, for financial modeling purposes, to avoid lumpiness in the projections, we use ending BS values for Working Capital drivers.
Generally speaking for comparison purposes, you would take the average BS when mixing IS and BS items in a ratio.
However, for financial modeling purposes, to avoid lumpiness in the projections, we use ending BS values for Working Capital drivers.
Re: total debt definition
From the perspective of valuation and TEV calculation, preferred stock and minority interest are considered all forms of capital other than equity; therefore, generically speaking, that includes total debt, preferred stock and minority interest.
From the perspective of valuation and TEV calculation, preferred stock and minority interest are considered all forms of capital other than equity; therefore, generically speaking, that includes total debt, preferred stock and minority interest.
Re: Future Stock-Based Compensation and Adding it to Share Count
We've actually answered a few questions on this forum about stock-based compensation. Here's one example that covers a fair amount: https://www.wstuniversity.com/forum/financial_modeling_topics-3/financial_modeling-9?single=1651&parent=1650 In summary, the best way is typically to model it as a p... Read More
We've actually answered a few questions on this forum about stock-based compensation. Here's one example that covers a fair amount: https://www.wstuniversity.com/forum/financial_modeling_topics-3/financial_modeling-9?single=1651&parent=1650 In summary, the best way is typically to model it as a p... Read More
Re: WST Macros Add In do not appear on Microsoft Office 365
Does your Excel 365 setup allow you to download Excel 2013 for local access? If so, you should be just fine using that, except that the add-in won't show up in the ribbon. This means that you'll have to rely on keyboard shortcuts only, but all the functionality will still be available.
Does your Excel 365 setup allow you to download Excel 2013 for local access? If so, you should be just fine using that, except that the add-in won't show up in the ribbon. This means that you'll have to rely on keyboard shortcuts only, but all the functionality will still be available.
X
-0/excel_add_in_instructions-343?single=1957&parent=1944" class="comm_tool fl">Go to post
added 10 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: waterfall chart with multiple series
Hi Philip, We actually cover waterfall charts in our "Excel Charting & Graphing Techniques & PPT Integration" course, which is one part of our greater Excel package. In the videos, we use techniques that are valid for Excel 2003 through 2007/2010, so you should have no problem applying them accor... Read More
Hi Philip, We actually cover waterfall charts in our "Excel Charting & Graphing Techniques & PPT Integration" course, which is one part of our greater Excel package. In the videos, we use techniques that are valid for Excel 2003 through 2007/2010, so you should have no problem applying them accor... Read More
Re: I have
Hi Christopher,
Could you please provide a few more details on how your current implementation is set up (for non-GLOBAL situations)? This would help a bit more in adjusting what you already have. For example, perhaps you're using LEFT and FIND to isolate the hyphen, etc.
Hi Christopher,
Could you please provide a few more details on how your current implementation is set up (for non-GLOBAL situations)? This would help a bit more in adjusting what you already have. For example, perhaps you're using LEFT and FIND to isolate the hyphen, etc.
The HRH 10-K filing is one of the course materials (PDF) available on the full, paid product. The Free Trial here offers a cursory glimpse into the courses; hopefully you find them informative!