Posts by: WST Expert 1
RE: vlookup question
Yes - create a legend - a key. Then use vlookup to grab it in.
Let us know if you have questions on vlookup- it is covered in our advanced excel for data analysis class.
Yes - create a legend - a key. Then use vlookup to grab it in.
Let us know if you have questions on vlookup- it is covered in our advanced excel for data analysis class.
RE: Company Overview: Typo $3.34 not $3.33
Please note this applies to our WST Self-Study courses.
Please note this applies to our WST Self-Study courses.
Re: Reference Range: Valuation of other industries
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
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
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
Hi David,
We're unable to reproduce this issue on our Mac machines. Are you by any chance in the NYC area? If so, we would be open to meet up and troubleshoot directly on your computer to see what's going on.