Posts by: WST Expert 1

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
Go to post added 5 months ago
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
Go to post added 2 years ago
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
Go to post added 2 years ago
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
Go to post added 2 years ago
Re: 2008 Diluted EPS
You've got a keen eye - that's correct. This error has been pointed out in past comments as well.
Go to post added 2 years ago
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.
Go to post added 2 years ago
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.
Go to post added 2 years ago
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
Go to post added 2 years ago
Re: Quiz and Exam locations??
The Accounting-related quiz is actually an exercise that's now part of the first course in Package 1: Accounting & Financial Statement Integration. You should already have access to that - specifically, the accounting exercise (with answers) is in the third and fourth chapter of the course, right af... Read More
Go to post added 2 years ago
Re: Location of additional file that is referened?
Hello, there's an exhibit video discussing depreciation vs. capital expenditures here: "Overview of Financial Markets + Exhibits" package -> "Supplementary Video Exhibits" -> "Depreciation in Future" Please let us know if you're looking for something else and we'll point you in the right directio... Read More
Go to post added 2 years ago
1 2 3 ...104Next