Posts by: WST Expert 1
                  Re: Macros Addin Excel 2017 
Hi Joya, Could you please also let us know your current Mac OS version? Also, would it be possible to update your Excel for Mac to the latest version that Microsoft allows? Finally, if you could provide a screenshot of what you're seeing, that'd be great. You could email us at support@wallst.t... Read More
                
              Hi Joya, Could you please also let us know your current Mac OS version? Also, would it be possible to update your Excel for Mac to the latest version that Microsoft allows? Finally, if you could provide a screenshot of what you're seeing, that'd be great. You could email us at support@wallst.t... Read More
X
-0/excel_add_in_instructions-343?single=2397&parent=2396" class="comm_tool fl">Go to post
                
                
                added 6 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: Intangible Asset Amortization 
Amortization of intangibles is typically disclosed in the footnotes or MD&A of the 10K as it is required by the SEC as a disclosure. In the event this truly is not found in the 10K or otherwise, and if the company has indeed discussed amortization expense in COGS and OpEx (well actually that's your ... Read More
                
              Amortization of intangibles is typically disclosed in the footnotes or MD&A of the 10K as it is required by the SEC as a disclosure. In the event this truly is not found in the 10K or otherwise, and if the company has indeed discussed amortization expense in COGS and OpEx (well actually that's your ... Read More
                  Re: Over Estimating Depreciation 
If it is clear that there is salvage value, one must make a best estimate for such amount.
One method is to see what 3 year old assets are currently valued at as an estimate.
Despite that, a common convention in financial modeling indeed is to assume no salvage value.
                
              If it is clear that there is salvage value, one must make a best estimate for such amount.
One method is to see what 3 year old assets are currently valued at as an estimate.
Despite that, a common convention in financial modeling indeed is to assume no salvage value.
                  Re: new to finance 
Hello, Thank you for your inquiry. We feel taking the CFA is overkill to learn accounting, even if you focus on just the accounting portions. Our issue with books and textbooks is that they do not focus on what you need to know about accounting from the FINANCE perspective. And that's exactly how... Read More
                
              Hello, Thank you for your inquiry. We feel taking the CFA is overkill to learn accounting, even if you focus on just the accounting portions. Our issue with books and textbooks is that they do not focus on what you need to know about accounting from the FINANCE perspective. And that's exactly how... Read More
                  Re: Discount rate unwinding 
Hello! As you move into next year, do you add an extra column for an extra year - for instance, maintaining 5 years of projections? If so, then the difference may be due to the new projection year that is added not being the same growth or factor as the year that gets shifted out. If not,... Read More
                
              Hello! As you move into next year, do you add an extra column for an extra year - for instance, maintaining 5 years of projections? If so, then the difference may be due to the new projection year that is added not being the same growth or factor as the year that gets shifted out. If not,... Read More
                  Re: Beta for Cost of Equity 
One commonly accepted approach is to make a beta calculation using historical stock data. You could take a calendar year of daily closing prices for the S&P 500 index and the stock in question. Calculate each day's % change from the previous day, and then use something like the COVARIANCE.P or SL... Read More
                
              One commonly accepted approach is to make a beta calculation using historical stock data. You could take a calendar year of daily closing prices for the S&P 500 index and the stock in question. Calculate each day's % change from the previous day, and then use something like the COVARIANCE.P or SL... Read More
                  Re: Terminal EBITDA multiple 
If you assume multiple expansion or contraction, you would be distorting the value. For instance, if your entry multiple is 7x and you assume a 10x exit multiple then by definition your DCF value is going to increase and provide a higher value than the company or stock inherently has. Any multiple e... Read More
                
              If you assume multiple expansion or contraction, you would be distorting the value. For instance, if your entry multiple is 7x and you assume a 10x exit multiple then by definition your DCF value is going to increase and provide a higher value than the company or stock inherently has. Any multiple e... Read More
                  Re: why Revolver is reduced after you put 6000$ in cash in 2006 ? Please answer urgently thank you 
We are putting in a negative number for minimum cash balance which reduces the amount of cash that you can use. Therefore, you have to borrow on revolver to maintain minimum level of cash.
                
              We are putting in a negative number for minimum cash balance which reduces the amount of cash that you can use. Therefore, you have to borrow on revolver to maintain minimum level of cash.
                  Re: Formula for F68-N72 on Value tab 
Hello, YES, you are CORRECT. This was an errata that we have fixed subsequent to the course recording, but failed to note here. We apologize for the inconvenience and many kudos to catching this. Indeed it should be F$4 on as the second input to the OFFSET formula from the Value tab, and NOT cell F2... Read More
                
              Hello, YES, you are CORRECT. This was an errata that we have fixed subsequent to the course recording, but failed to note here. We apologize for the inconvenience and many kudos to catching this. Indeed it should be F$4 on as the second input to the OFFSET formula from the Value tab, and NOT cell F2... Read More
 
     
	
We never bother to reconcile historical cash flow statement. Why not? Because you'll never know the adjustments the the company made. For instance, the change in A/R or A/P contains write-downs or other accruals that will not make the BS change exactly equal to the CF figures.