Posts by: WST Expert 1
Re: D&A is different on the I/S and CF, which to use ??
If the purpose is to calculate EBITDA, then we always use D&A from the CF Statement because that is the better indication of the "true" non-cash amount of D&A. D&A on the IS and CF really should be the same and when it's not it's usually due to a specific accrual method of acc... Read More
If the purpose is to calculate EBITDA, then we always use D&A from the CF Statement because that is the better indication of the "true" non-cash amount of D&A. D&A on the IS and CF really should be the same and when it's not it's usually due to a specific accrual method of acc... Read More
RE: Pesky Technical Question
1) when you say "self-fill", what exactly do you mean? do you enter a cell and when hitting ENTER, another cell auto-fills? or are you talking about the difference between Ctrl+R and Ctrl+Shift+Alt+R on our macros else, we don't know what you are referring to! 2) usually forma... Read More
1) when you say "self-fill", what exactly do you mean? do you enter a cell and when hitting ENTER, another cell auto-fills? or are you talking about the difference between Ctrl+R and Ctrl+Shift+Alt+R on our macros else, we don't know what you are referring to! 2) usually forma... Read More
RE: DCF EBITDA multiple approach
Please make sure you view our courses previously stated. These are fundamentally simple concepts to DCF. Terminal Value values the company at end of terminal year. But what about the interim cash flows? Those have value as well.
Please make sure you view our courses previously stated. These are fundamentally simple concepts to DCF. Terminal Value values the company at end of terminal year. But what about the interim cash flows? Those have value as well.
Re: Automated S&P Debt Rating
In our Advanced Financial Modeling - Enhancements course, on the Credit tab, we have the automated S&P ratios that dynamically illustrate the potential rating based purely on quantitative factors. If you have that file/worksheet, then it's a series of complex conditional formatting. If you don't... Read More
In our Advanced Financial Modeling - Enhancements course, on the Credit tab, we have the automated S&P ratios that dynamically illustrate the potential rating based purely on quantitative factors. If you have that file/worksheet, then it's a series of complex conditional formatting. If you don't... Read More
Re: Reference Range (Corporate Valuation)
If you recall from class, the blue cells are hard-coded inputs, not black calculations. Correct, you base your "final" valuation range based on all the qualitative and quantitative factors of the industry, sector and company-specific. The tendency is to estimate based on the Stock Price ... Read More
If you recall from class, the blue cells are hard-coded inputs, not black calculations. Correct, you base your "final" valuation range based on all the qualitative and quantitative factors of the industry, sector and company-specific. The tendency is to estimate based on the Stock Price ... Read More
RE: Excel 2007 adoption
Excel 2007 is horrendous and we would support a campaign called "Fight Excel 2007" should anyone care to join us vs. Microsoft. If you are on our mailing list, we sent out an email listing all the reasons why Excel 2007 is inferior. Banks are NOT switching to Excel 2007 but probably would in a f... Read More
Excel 2007 is horrendous and we would support a campaign called "Fight Excel 2007" should anyone care to join us vs. Microsoft. If you are on our mailing list, we sent out an email listing all the reasons why Excel 2007 is inferior. Banks are NOT switching to Excel 2007 but probably would in a f... Read More
Re: daily number and quarterly data on chart
Since you have daily stock price data, you have stock price dates. Make sure your inventory numbers are as of date, and not in format of 2012 Q1, but a date. First column is dates Second column is stock prices Third column is a vlookup function that brings in inventory, make sure to say "1&quo... Read More
Since you have daily stock price data, you have stock price dates. Make sure your inventory numbers are as of date, and not in format of 2012 Q1, but a date. First column is dates Second column is stock prices Third column is a vlookup function that brings in inventory, make sure to say "1&quo... Read More
Re: D&A is different on the I/S and CF, which to use ??
What is your beginning figure, ending figure and number of years increment?
What is your beginning figure, ending figure and number of years increment?
RE: LBO enhanced model question
You would need to build a stub period into your model. Add a new column after 2007 full year and use that to add with adjustments for pro forma. Your financials (IS and CF etc) would need to make sure 2008 column are stub year (say sept to dec 2008).
You would need to build a stub period into your model. Add a new column after 2007 full year and use that to add with adjustments for pro forma. Your financials (IS and CF etc) would need to make sure 2008 column are stub year (say sept to dec 2008).
Please take our Corporate Valuation Methodologies course, which is part of Package 4: http://www.wstselfstudy.com/programs.html ... Please take our Corporate Valuation Methodologies course, which is part of Package 4:
http://www.wstselfstudy.com/programs.html
http://www.wstselfstudy.com/package4.html Read More