Posts by: WST Expert 1
RE: Create a simplified model from the full blown core model
Conversion from full blown Core Model to simplified, no debt model: 1) remove all Debt related items from Balance Sheet 2) remove Debt Sweep completely 3) in Cash Flow, CFF, there will be no stock or debt, just have one line called Capital Infusion (like CapEx) and set CFF equal to that. 4) Ch... Read More
Conversion from full blown Core Model to simplified, no debt model: 1) remove all Debt related items from Balance Sheet 2) remove Debt Sweep completely 3) in Cash Flow, CFF, there will be no stock or debt, just have one line called Capital Infusion (like CapEx) and set CFF equal to that. 4) Ch... Read More
Re: a quick question about formatting
Use our following macros (install the WST add-ins):
Ctrl+ Shift+D for dollar formatting
Ctrl+ Shift+M for number formatting ("money" macro)
Ctrl + U for underline (we overwrote excel's built-in Ctrl+U since in Excel 2007 and 2010 the underline changes the row height in most cases.
Use our following macros (install the WST add-ins):
Ctrl+ Shift+D for dollar formatting
Ctrl+ Shift+M for number formatting ("money" macro)
Ctrl + U for underline (we overwrote excel's built-in Ctrl+U since in Excel 2007 and 2010 the underline changes the row height in most cases.
Re: Macro error: compile error in hidden module: thiswork
Hi David, We have just released an update to our WST Macros Add-In. Could you please download version 3.7 from our Free Resources page (http://wallst-training.com/about/resources.html) and let us know... Read More
Hi David, We have just released an update to our WST Macros Add-In. Could you please download version 3.7 from our Free Resources page (http://wallst-training.com/about/resources.html) and let us know... Read More
RE: DCF Terminal Value Discount Period
Yes, same time period. Whether its whole years or stub years, same. Why? Because perpetuity growth rate method starts with 1+g. So in essence its next years growth that you start to receive. That gets discounted back. The formula you provided correctly is the terminal value as of today, not one year... Read More
Yes, same time period. Whether its whole years or stub years, same. Why? Because perpetuity growth rate method starts with 1+g. So in essence its next years growth that you start to receive. That gets discounted back. The formula you provided correctly is the terminal value as of today, not one year... Read More
Re: LBO "Super Complex Course"
If you have previously paid for the Quick & Dirty LBO course previously, yes, you can upgrade by paying the difference. Do you know which account representative you previously spoke to?
If you have previously paid for the Quick & Dirty LBO course previously, yes, you can upgrade by paying the difference. Do you know which account representative you previously spoke to?
Re: Interest Schedule calcs
what is the exact ERROR you receive? Sounds like you have a pre-existing circ, which is why your interest income is zero. We recommend THIS YEAR'S BEGINNING balance which is LAST YEAR'S ENDING balance when avoiding the use of circular reference. For AVERAGE balance (which creates the circ), it woul... Read More
what is the exact ERROR you receive? Sounds like you have a pre-existing circ, which is why your interest income is zero. We recommend THIS YEAR'S BEGINNING balance which is LAST YEAR'S ENDING balance when avoiding the use of circular reference. For AVERAGE balance (which creates the circ), it woul... Read More
RE: Adjusting historical financials for non-recurring/XO items
We'll have to direct you to our Complex Trading Comps course online..
that entire class is focused on that and how to correctly capture all the adjustments (we cover 98% of all adjustments you'll ever hit)
We'll have to direct you to our Complex Trading Comps course online..
that entire class is focused on that and how to correctly capture all the adjustments (we cover 98% of all adjustments you'll ever hit)
RE: Advanced Valuation Modeling: Share repurchase
Pls view our Share Repurchase video. This course is included free in your login.
Pls view our Share Repurchase video. This course is included free in your login.
Re: Altman Z-Score
It's not that hard! a quick wikipedia search brings up the formula: http://en.wikipedia.org/wiki/Altman_Z-score once you have the financials in your model, it's a couple of additional ratios to calculate;... Read More
It's not that hard! a quick wikipedia search brings up the formula: http://en.wikipedia.org/wiki/Altman_Z-score once you have the financials in your model, it's a couple of additional ratios to calculate;... Read More
treasury stock on BS is a DOLLAR amount. so the change would be the total dollar amount in stock purchased that year. of course the negative number becomes a bigger negative number