Posts by: Guest 1

AFM Enhancements: Cond. Format Credit & Leverage Stats
Is there anywhere in the program where you go step by step in how exactly you program the specific conditional shading format in assessing the credit rating? The conditional formatting doesn't appear to be included in the excel template and I'd like to learn the logic of programming the conditional... Read More
Go to post added 11 years ago
Re: Urgent: Automating Scorecard Metrics grading
Dear WST, Thank you so much! I would recommend Hamilton Lin's Advanced Excel for Data Analysis course without reservation. It is worth every penny spent. I have a few follow-up questions: 1. The scorecard is evaluating a dozen of project initiatives and each with 10 metrics to reach an overall ... Read More
Go to post added 11 years ago
Diluted shares vs basic shares for WACC
Full Question:
Should companies ever use diluted shares to figure out WACC (instead of basic shares)?
Go to post added 11 years ago
Re: TEV and negative net debt clarification
Even after watching the Corporate Valuation video and reading your previous responses, I still feel a bit unclear about Equity Value being greater than Enterprise Value. I think going over my understanding of these topics might help you identify where my confusion lies. Under an 'unlevered' valuat... Read More
Go to post added 11 years ago
Re: CFA certification
Hi guys, As earlier pointed out in the forum, CFA would be very relevant for career in equity research, portfolio management etc. Further it provides a basic understanding of all other fields of finance. It also depends on your present state of work, If you are working in a non-related filed and wa... Read More
Go to post added 11 years ago
WACC: market vs book value & what regulated industries?
Full Question: 1) Would you suggest for calculating the WACC (to be used as the discount rate) using the market value of the securities rather than book value in order to determine the weightings for the cost of debt and equity securities? (2) same question, but...If an industry was regulated (... Read More
Go to post added 11 years ago
AFM Enhancements: book value of equity to calc total capital
when you are calculating the total capital here, you are using the book value of equity to calculate, why we cann't use the market value of the equity, becuase that is more up-to-date.

thanks
Go to post added 11 years ago
Re: CFA certification
Hi, I have come across several individuals who have graduated without having an exposure to financial industry (typically been working in the IT domain) and are looking forward to switch to equity research/ analyst roles with financial services industries. Here CFA gives an adequate platform to le... Read More
Go to post added 11 years ago
WACC - preferred debt tax deductibility & levered beta
Full Question: 1) Your Corporate Valuation Methodologies course states that Unlevered beta = (levered beta/ (1+(1-Tax rate)x(debt/equity+preferred/equity) - why the denomintors are equity not TEV? 2) The Company Profiles module says assume preferred stock is not tax-deductible which is different ... Read More
Go to post added 11 years ago
Re: Urgent: Automating Scorecard Metrics grading
Thank you so much! WST is the best!
Go to post added 11 years ago