Posts by: WST Expert 1
Re: Video Glitch
Hi Mark, we're not able to reproduce that video error on our end. Could you please email us at support@wallst.training with the operating system and browser version you're using? Thanks!
Hi Mark, we're not able to reproduce that video error on our end. Could you please email us at support@wallst.training with the operating system and browser version you're using? Thanks!
Re: PDF with Instructions
Under My Courses, look for the WST Macros item. Under the "Assets" heading, download WSTMacrosAdd-In.zip to your computer. Extract the zip file into a folder of your choice. Then, open the “WST Macros Add-In Instructions PC Activate.pdf” file for instructions on how to install WST Macros properl... Read More
Under My Courses, look for the WST Macros item. Under the "Assets" heading, download WSTMacrosAdd-In.zip to your computer. Extract the zip file into a folder of your choice. Then, open the “WST Macros Add-In Instructions PC Activate.pdf” file for instructions on how to install WST Macros properl... Read More
Re: Costco Interest Expense
As a general statement, subtracting interest income from interest expense is typically referred to as "net interest expense." That said, for the purposes of these coverage ratios, it's better to use gross interest expense (i.e., disregard interest income). In practice, this often requires diggin... Read More
As a general statement, subtracting interest income from interest expense is typically referred to as "net interest expense." That said, for the purposes of these coverage ratios, it's better to use gross interest expense (i.e., disregard interest income). In practice, this often requires diggin... Read More
Re: Control D
That's correct, and you bring up a great point. Ctrl+D will copy down formatting as well , which is not suitable when you only want to Paste Special (Formulas). Note that this is a basic course, and in our more intermediate courses, we end up utilizing Ctrl+Enter more heavily for similar situations.... Read More
That's correct, and you bring up a great point. Ctrl+D will copy down formatting as well , which is not suitable when you only want to Paste Special (Formulas). Note that this is a basic course, and in our more intermediate courses, we end up utilizing Ctrl+Enter more heavily for similar situations.... Read More
Re: Control R vs Paste Special
Ctrl+R will indeed copy both the formula/value and formatting. In our courses, the templates are all pre-formatted, so Ctrl+R is vastly superior because the formatting is ready to be propagated to future columns. In general, Ctrl+R is simply faster and thus more efficient (fewer steps/keystrokes), a... Read More
Ctrl+R will indeed copy both the formula/value and formatting. In our courses, the templates are all pre-formatted, so Ctrl+R is vastly superior because the formatting is ready to be propagated to future columns. In general, Ctrl+R is simply faster and thus more efficient (fewer steps/keystrokes), a... Read More
Re: 2008 Diluted EPS
You've got a keen eye - that's correct. This error has been pointed out in past comments as well.
You've got a keen eye - that's correct. This error has been pointed out in past comments as well.
Re: Using average receivables
In our training, we do not advise using average receivables for balance sheet drivers. Of course, if there's a specific part of one of the videos that you'd like us to clarify, please let us know and we'll be glad to revisit them together.
That said, average should be used for comps.
In our training, we do not advise using average receivables for balance sheet drivers. Of course, if there's a specific part of one of the videos that you'd like us to clarify, please let us know and we'll be glad to revisit them together.
That said, average should be used for comps.
Re: Break out depreciation from cost of goods sold or operating expenses
The challenge is that depreciation belongs in both COGS and SG&A, but the proper breakdown is not usually provided in public documents. If you have access to management accounts, then you'd be able do a deeper dive and get more granular.
The challenge is that depreciation belongs in both COGS and SG&A, but the proper breakdown is not usually provided in public documents. If you have access to management accounts, then you'd be able do a deeper dive and get more granular.
Re: Using average receivables
In all our training and live deal models, we never use average receivables for balance sheet WC drivers for this very reason. For non-annual models (such as quarterly or monthly), cyclical fluctuations and the use of averages will yield very inaccurate numbers. Separately, if all numbers (such a... Read More
In all our training and live deal models, we never use average receivables for balance sheet WC drivers for this very reason. For non-annual models (such as quarterly or monthly), cyclical fluctuations and the use of averages will yield very inaccurate numbers. Separately, if all numbers (such a... Read More
When the item is sold, sales (or revenue) would technically increase first, thereby affecting equity (up in this case). Then when the COGS for the item is recorded, equity gets affected again (down). Ditto for SG&A and any other related items. Cash and A/R would be affected based on the terms (payme... When the item is sold, sales (or revenue) would technically increase first, thereby affecting equity (up in this case). Then when the COGS for the item is recorded, equity gets affected again (down). Ditto for SG&A and any other related items. Cash and A/R would be affected based on the terms (payment methods) of the sale itself and thus, doesn’t affect equity directly at the point of sale. Read More