Posts by: WST Expert 1
Re: Data skip blank and split window toggle
1) Assuming that your data is set up like the following: Column A: Year Column B: Quarter (1 thru 4) Column C: actual data We would recommend using a SUM array as covered in our Advanced Excel for Data Analysis class. Else you can do a pivot table. 2) Hit F6 function key to toggle the quadrants in... Read More
1) Assuming that your data is set up like the following: Column A: Year Column B: Quarter (1 thru 4) Column C: actual data We would recommend using a SUM array as covered in our Advanced Excel for Data Analysis class. Else you can do a pivot table. 2) Hit F6 function key to toggle the quadrants in... Read More
Re: Questions about total debt & preferred stock
A1) Generally, for credit ratios, we would include all forms of debt (non-equity essentially) as part of debt and capitalization. Whereas, in the slightly more detailed schedule on the left, since we have the breakdown, we said total debt. This blends in to the larger credit analysis course. A2) Pr... Read More
A1) Generally, for credit ratios, we would include all forms of debt (non-equity essentially) as part of debt and capitalization. Whereas, in the slightly more detailed schedule on the left, since we have the breakdown, we said total debt. This blends in to the larger credit analysis course. A2) Pr... Read More
Re: Complex Trading Comps Analysis
It depends on the reason for the lower state tax. If "normal" and "ordinary course of business", then no need to adjust.
If it is due to a specific one-time item, then perhaps we would adjust.
what is the specific nature of the tax benefit?
It depends on the reason for the lower state tax. If "normal" and "ordinary course of business", then no need to adjust.
If it is due to a specific one-time item, then perhaps we would adjust.
what is the specific nature of the tax benefit?
Re: Questions from Advanced Financial Modeling course
1) In short, we only consider financial related items in Capital Structure for valuation. Working capital items are considered operating related and not financial related. Don't get confused by the accountants' definition of debt which is all liabilities. Not the case in finance. For a thorough disc... Read More
1) In short, we only consider financial related items in Capital Structure for valuation. Working capital items are considered operating related and not financial related. Don't get confused by the accountants' definition of debt which is all liabilities. Not the case in finance. For a thorough disc... Read More
RE: Merger Modeling Basics: EPS x Net Income
In the case of convertible securities, the interest is no longer due if converted and so adjustments to Net Income must be made. This is covered in detail in the Basic Financial Modeling course so pls review that course. In our Corporate Valuation course, we explain that even in DCF, always use ... Read More
In the case of convertible securities, the interest is no longer due if converted and so adjustments to Net Income must be made. This is covered in detail in the Basic Financial Modeling course so pls review that course. In our Corporate Valuation course, we explain that even in DCF, always use ... Read More
Re: Cost of Equity and Debt
Take a look at our free Share Repurchase video class at www.wstselfstudy.com (FREE TRIAL link). That summarizes opportunity cost of capital changes. In the context of an LBO, the cost of equity becomes the private equity... Read More
Take a look at our free Share Repurchase video class at www.wstselfstudy.com (FREE TRIAL link). That summarizes opportunity cost of capital changes. In the context of an LBO, the cost of equity becomes the private equity... Read More
Re: Software for Financial Analyst
For the full accounting overview, you would need to take the Accounting Bootcamp course. this is equivalent to 1-2 semesters of accounting, taught by the Dean of NYU Stern: http://www.wstselfstudy.com/accountingboo... Read More
For the full accounting overview, you would need to take the Accounting Bootcamp course. this is equivalent to 1-2 semesters of accounting, taught by the Dean of NYU Stern: http://www.wstselfstudy.com/accountingboo... Read More
Re: Plugs
This is akin to saying "I want to get rich so let me rob a bank" - not only is it stupid advice, it will get you in trouble. Please note, we do not condone any illegal action of any type. Do yourself a favor - take our Advanced Financial Modeling - Core Model course at: Read More
This is akin to saying "I want to get rich so let me rob a bank" - not only is it stupid advice, it will get you in trouble. Please note, we do not condone any illegal action of any type. Do yourself a favor - take our Advanced Financial Modeling - Core Model course at: Read More
Re: DCF model - working capital item
Excellent question. Please go to our main website: http://www.wallst-training.com/ and click on FREE RESOURCES. Scroll down in the first section to: Financial Statement Assumptions Download that PDF and refer to the... Read More
Excellent question. Please go to our main website: http://www.wallst-training.com/ and click on FREE RESOURCES. Scroll down in the first section to: Financial Statement Assumptions Download that PDF and refer to the... Read More
Our courses use the same industry (retail as you noted) so that there is continuity. Other industries follow the same logic by and large, modified with industry-specific jargon. we do not have plans to come out with industry-specific online courses although we have non-video based industry-specific ... Our courses use the same industry (retail as you noted) so that there is continuity. Other industries follow the same logic by and large, modified with industry-specific jargon. we do not have plans to come out with industry-specific online courses although we have non-video based industry-specific models. Read More