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 (51 post(s))
- Package 1: Basic & Fundamental Concepts (54 post(s))
- Package 2: Core Fundamental Concepts (57 post(s))
- Package 3: Advanced Financial Modeling (134 post(s))
- Package 4: Valuation Modeling Topics (103 post(s))
- Package 5: Merger Modeling Topics (68 post(s))
- Package 6: Leveraged Buyout Modeling (51 post(s))
- Package: Technical Applications - Excel (31 post(s))
- Overview of Financial Markets + Exhibits (9 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 (10 post(s))
- Package: Bank Financial Modeling (4 post(s))
- Package: Insurance Financial Modeling (14 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
Formatting Using the ctrl + shift + D
For some reason every time I use the dollar formatting through the WST add in the default is no decimal places, not one decimal place. How do I change this?
For some reason every time I use the dollar formatting through the WST add in the default is no decimal places, not one decimal place. How do I change this?
shareholder loan
Hi can you shed light in which case is shareholder reported as debt vs equity (capital contribution) on the balance sheet in GAAP and IFRS? From what I understand it's classified as debt at least under IFRS. I am not as familiar with GAAP. In reference to points 1 and 2 below. 1. https://www.... Read More
Hi can you shed light in which case is shareholder reported as debt vs equity (capital contribution) on the balance sheet in GAAP and IFRS? From what I understand it's classified as debt at least under IFRS. I am not as familiar with GAAP. In reference to points 1 and 2 below. 1. https://www.... Read More
Formatting Cells D26 through I26
Hi, So in comparing my unformatted workbook to the already completed formatted workboook, I noticed that cells D26 through I26 multiplied profit by the mutiple in C12 rather than C26. Should I use C12 instead when creating the scenario analysis?
Hi, So in comparing my unformatted workbook to the already completed formatted workboook, I noticed that cells D26 through I26 multiplied profit by the mutiple in C12 rather than C26. Should I use C12 instead when creating the scenario analysis?
No Growth Model and Gordon Growth Model
Hi there, Why is it that capital gains are not mentioned in the equations for the Gordon Growth Model and No Growth Model? Thanks!
Hi there, Why is it that capital gains are not mentioned in the equations for the Gordon Growth Model and No Growth Model? Thanks!
Format
Hi, when I do the Ctrl+shift+x formula the 0 shows up as a dash rather than as 0.0x, so I was wondering how I can change that?
Hi, when I do the Ctrl+shift+x formula the 0 shows up as a dash rather than as 0.0x, so I was wondering how I can change that?
Formating 0.0% and 0.0x in Data Manipulation
When I use macros to convert cells to dollar, money, or percent form in the data manipulation spreadsheet, I get the correct results for all cells except for the cells containing 0 for percent and multiples. For these two cells, when I apply control+shift+c or control+shift+x, I get the same dashed ... Read More
When I use macros to convert cells to dollar, money, or percent form in the data manipulation spreadsheet, I get the correct results for all cells except for the cells containing 0 for percent and multiples. For these two cells, when I apply control+shift+c or control+shift+x, I get the same dashed ... Read More
WST Add-in
Hi! I have a newer Microsoft Excel and I was wondering how to download the WST add-in? I cannot seem to find where to download it onto my computer.
Hi! I have a newer Microsoft Excel and I was wondering how to download the WST add-in? I cannot seem to find where to download it onto my computer.
Cell Format
After using the macro shortcuts, I don't get the extra decimal point with a zero. I tried formatting the cells to change it, but that doesn't work. How can I fix this?
After using the macro shortcuts, I don't get the extra decimal point with a zero. I tried formatting the cells to change it, but that doesn't work. How can I fix this?
Treatment of Change in DAC in IS
Hi, I quite don't understand why 'change in DAC' would be booked as a negative item under the expenses section of the income statement. Shouldn't it be booked as a positive item, so that it can be conclusively deducted as a true expense in the calculation of operating income?
Hi, I quite don't understand why 'change in DAC' would be booked as a negative item under the expenses section of the income statement. Shouldn't it be booked as a positive item, so that it can be conclusively deducted as a true expense in the calculation of operating income?
for some reason when i try and use the shortcuts (control alt D/m/c/x) it changes my numbers into whole numbers only. for example 1508.4 becomes $1,508 and omits the .4... why is this?