### WST Self-Study Q&A

Topics related specifically to our WSTSS online courses (www.wstselfstudy.com) including ERRATA postings

### Packages

# Core Modules

- Package: Intensive Accounting Boot Camp (39 post(s))
- Package 1: Basic & Fundamental Concepts (52 post(s))
- Package 2: Core Fundamental Concepts (53 post(s))
- Package 3: Advanced Financial Modeling (105 post(s))
- Package 4: Valuation Modeling Topics (81 post(s))
- Package 5: Merger Modeling Topics (68 post(s))
- Package 6: Leveraged Buyout Modeling (51 post(s))
- Package: Technical Applications - Excel (17 post(s))
- Overview of Financial Markets + Exhibits (7 post(s))

# Advanced & Industry Modules

- Package: Private Company Valuation (2 post(s))
- Package: Super-Complex M&A LBO Modeling (70 post(s))
- Package: Distressed Financial Modeling (8 post(s))
- Package: Bank Financial Modeling (4 post(s))
- Package: Insurance Financial Modeling (12 post(s))
- Package: Real Estate Development Modeling (4 post(s))
- Package: REIT Financial Modeling (0 post(s))
- Package: Buy-Side Series (6 post(s))

# Verification

# Certification

### Last 10 posts

**I answered my own "SQRT(260)" multiple factor in "WMT 10 Day Volatility" calculation question**

After checking my old "statistics" and "physics" college textbooks and B-school Finance book, I realized (i.e. I had forgot) that : 1. Volatility is standard deviation of returns; 2. Volatility, or standard deviation is the square root of variamce; 3. The assumption that common option pricing ... Read More

**"SQRT(260)" multiple factor in "WMT 10 Day Volatility" calculation**

Would you please let me know why you include the "SQRT(260)" multiple factor in each "WMT 10 Day Volatility" and "S&P 500 10-Day Volatility" calculation? Does the "260" mean "260 Trading Days and assuming No Holidays, 5 Trading Days * 52 Weeks per Year?" Thank you very much in advance for your ... Read More

**VLOOK and MATCH**

Good afternoon. => I just finished the VLOOK and MATCH self-study module. => I want to make sure that I know how to apply them, VLOOK, MATCH and OFFSET functions, => So, I used the data provided in the course to try to display the Closing Stock Price in a descending order with corresponding Trading... Read More

**Valuation Summary - Private Company Differences**

Hello. What differences are there in Valuation Summary for a private company vs. a public company (as shown on slide 14)?

**Color Coding**

I am confused about the color coding. Some cells with a formula that only uses inputs from the filings and do not reference other cells get coded black while other times they are coded blue. How should I think about this in terms of the certification exam?

**NPV**

For the NPV calculation, wouldn't you need to take out the original investment of $10? I get 4.2 for my NPV. Thanks!

**Following up to my (Peter) question RE: Complex LBO Modeling Enhancements - Mezzanine / Warrants Holder Investor Returns**

A follow-up to my previous question, it just occurred to me : Did you mean ==> if the warrants conversion right is exercised, then the annual Cash Flow prior to the Exit Year will be = Common Dividends Received * E102 (Equity due to Warrants) + Mezzanine Notes - Cash Interest; and ==> Exit Y... Read More

**Complex LBO Modeling Enhancements - Mezzanine / Warrant Holder Investment Return (with PIK and Warrants)**

I am confused by your comment re: "if warrants are converted..." ==> Does it mean that If conversion right is exercised and warrants are converted to equity interest based upon the conversion ratio, my Total Equity Interest will then be = (1) % of equity due to warrants conversion to equity inte... Read More

**Windows 10 - Data Value for Default Background Colour of White**

What is the data value to input if I want to change by background colour to that of white, before I changed it to grey? After changing it to grey, I can't seem to revert back to the default - the grey colour spreads to my other themes as well! :/

Suitable courseDear Sir, If standard financial knowledge is available, which course is suitable to make standard infrastructure project finance model from scrutch?