Posts by: WST Expert 1
Re: Dividends from Subsidiary
1) Since over 50% ownership, it is consolidated into HoldCo. If SUB is paying dividends, then the Minority Interest expense (now called NCI) is a cash outflow (assuming 100% of NI paid out physically). If zero dividends, then CFO is adjusted up and MI (now NCI) on BS up as well. Same logic for whate... Read More
1) Since over 50% ownership, it is consolidated into HoldCo. If SUB is paying dividends, then the Minority Interest expense (now called NCI) is a cash outflow (assuming 100% of NI paid out physically). If zero dividends, then CFO is adjusted up and MI (now NCI) on BS up as well. Same logic for whate... Read More
RE: Macro formatting question
Thanks for you suggestions and ideas. Our comments in return: On the %ages: the % sign is already aligned. if you talking about the right parenthesis for negative %ages, we wouldn't want the extra space for the positive - it would look funny. On our dollar formatting - we intentionally put ... Read More
Thanks for you suggestions and ideas. Our comments in return: On the %ages: the % sign is already aligned. if you talking about the right parenthesis for negative %ages, we wouldn't want the extra space for the positive - it would look funny. On our dollar formatting - we intentionally put ... Read More
RE: AFM Core Model: Interest Schedule Video
Please note this applies to our WST Self-Study courses.
Please note this applies to our WST Self-Study courses.
Re: Pref stock included in debt for target M&A?
Please view our videos on Corporate Valuation or search the topic forums here.
In short, preferred debt is considered a form of capital tha tmust be taken out before arriving at true equity value of the current shareholders.
Please view our videos on Corporate Valuation or search the topic forums here.
In short, preferred debt is considered a form of capital tha tmust be taken out before arriving at true equity value of the current shareholders.
Re: Reference Range (Corporate Valuation)
Thank you for your inquiry. The reference ranges are our best final guess of the valuation parameters in question. Notice that they are hard coded in blue, meaning they are inputs as opposed to calculated formulas. Thus, this is what we believe is the valuation range for that particular valuation me... Read More
Thank you for your inquiry. The reference ranges are our best final guess of the valuation parameters in question. Notice that they are hard coded in blue, meaning they are inputs as opposed to calculated formulas. Thus, this is what we believe is the valuation range for that particular valuation me... Read More
RE: INDEX vs CHOOSE
if you are using index, i'd recommend vlookup or offset instead (offset is more applicable atually). index is really powerful for other things (like the fact it can return a cell reference instead of just the value), such as when combining into an array formula. if it's working and you manu... Read More
if you are using index, i'd recommend vlookup or offset instead (offset is more applicable atually). index is really powerful for other things (like the fact it can return a cell reference instead of just the value), such as when combining into an array formula. if it's working and you manu... Read More
Re: Software for Financial Analyst
Please take our Corporate Valuation Methodologies course, which is part of Package 4: http://www.wstselfstudy.com/programs.html ... Read More
Please take our Corporate Valuation Methodologies course, which is part of Package 4: http://www.wstselfstudy.com/programs.html ... Read More
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
The current industry models that are available: Banking Insurance Real Estate (REIT) Oil & Gas coming very soon Alternative Energy coming very soon. Unfortunately, they are not yet in our online format. For more information, see: The current industry models that are available:
Banking
Insurance
Real Estate (REIT)
Oil & Gas coming very soon
Alternative Energy coming very soon.
Unfortunately, they are not yet in our online format. For more information, see:
http://www.wallst-training.com/topics.html
http://www.wstselfstudy.com/packageindustry.html Read More