Posts by: WST Expert 1
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 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: 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.
Re: formula on how to dynamically average four quarters' numbers of each year
This could very well be a simple syntax issue -- as in, you have the right idea already. In the very last parameter, try separating the equals sign from the cell reference, and use an ampersand to concatenate the two. So, where you have: "=$BC5" ... try changing this to: "="&$BC5 Basi... Read More
This could very well be a simple syntax issue -- as in, you have the right idea already. In the very last parameter, try separating the equals sign from the cell reference, and use an ampersand to concatenate the two. So, where you have: "=$BC5" ... try changing this to: "="&$BC5 Basi... Read More
Re: formula on how to dynamically copy a cell
Don't be afraid to use an extra row here and there to calculate values as necessary. We would probably add a row that calculates the stock movement based on a index starting value (i.e. 100). Then take that new row and multiply by the invested stock amount from prior period multiplied by your 1 ... Read More
Don't be afraid to use an extra row here and there to calculate values as necessary. We would probably add a row that calculates the stock movement based on a index starting value (i.e. 100). Then take that new row and multiply by the invested stock amount from prior period multiplied by your 1 ... Read More
Re: Where can I find the other templates for these standalone clips or are these just teasers, must we purchase the advanced package to get the same tutorial as we did with the basic?
Hi, as you mentioned, the Excel templates and/or slide materials referenced in this free package act as a preview of the full package. For a more detailed glimpse at several specific courses, please feel free to sign up for the six-month free trial (head to our webpage at http://wallst-training.com ... Read More
Hi, as you mentioned, the Excel templates and/or slide materials referenced in this free package act as a preview of the full package. For a more detailed glimpse at several specific courses, please feel free to sign up for the six-month free trial (head to our webpage at http://wallst-training.com ... 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 ... 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 and for equity, it would be earnings yield. We have a GREAT exhibit explaining this in our online tutorials - look for Exhibits - "Share Repurchase" under your online course list in My Courses. If you don't see it, just re-sign up for a free trial (it's free!). Read More