Posts by: WST Expert 1
Re: Insurance financial modeling
This would get modified on the Sweep tab. Whatever row 37 on CF references on Sweep, should be the change in LTD which is a formula that acts as ultimate balancer. Insert a new row either above or below that row on Sweep sheet where you hard code any desired changes. Make sure your Ending Balance i... Read More
This would get modified on the Sweep tab. Whatever row 37 on CF references on Sweep, should be the change in LTD which is a formula that acts as ultimate balancer. Insert a new row either above or below that row on Sweep sheet where you hard code any desired changes. Make sure your Ending Balance i... Read More
RE: Modeling out pension expenses on the cash flow statement
Is the CF statement direct or indirect method? if direct method, then that means they paid GBP100, if indirect that means they paid GBP100 MORE THAN whatever was recognized as an expense, exclusive of adjustments.
Is the CF statement direct or indirect method? if direct method, then that means they paid GBP100, if indirect that means they paid GBP100 MORE THAN whatever was recognized as an expense, exclusive of adjustments.
RE: Reference Range: Valuation of other industries
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 ... 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 ... Read More
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
Yes, please sign up for our Excel Fundamentals for the Finance professional which will get you up to speed on Excel before the intensive financial modeling in Excel. http://www.wstselfstudy.com/packagetech.htmlhttp://www.wstselfstudy.com/packagetech.html Read More