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 (136 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 (12 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
Formula for F68-N72 on Value tab
Shouldn't the offset formula for Cell F68 on the Value Tab instead be: =$C68*F$9-OFFSET(IS!$F$61,F$4,Value!$A68)? This way, it will capture various CASES in the offset function. Please advise.
Shouldn't the offset formula for Cell F68 on the Value Tab instead be: =$C68*F$9-OFFSET(IS!$F$61,F$4,Value!$A68)? This way, it will capture various CASES in the offset function. Please advise.
New Student Question
Hello, Can I ask questions if I do not understand a concept? Please let me know. Thanks, CII
Hello, Can I ask questions if I do not understand a concept? Please let me know. Thanks, CII
shortcuts
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?
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?
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
why Revolver is reduced after you put 6000$ in cash in 2006 ? Please answer urgently thank you