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 (59 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 (6 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
Macros Addin Excel 2017
Hi, I followed the instructions, however when i go to tools in excel the add-ins cant be clicked? im using microsoft excel for mac version 16.9 2017
Hi, I followed the instructions, however when i go to tools in excel the add-ins cant be clicked? im using microsoft excel for mac version 16.9 2017
Terminal EBITDA multiple
Why is it inappropriate to assume terminal multiple expansion or contraction relative to the current year?
Why is it inappropriate to assume terminal multiple expansion or contraction relative to the current year?
why Revolver is reduced after you put 6000$ in cash in 2006 ? Please answer urgently thank you
why Revolver is reduced after you put 6000$ in cash in 2006 ? Please answer urgently thank you
why Revolver is reduced after you put 6000$ in cash in 2006 ? Please answer urgently thank you
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?
It would be useful to have a completed worksheet of the model. It is not always easy to follow the instructions. Is it possible you can send a completed model for the advanced model. Thanks. Fanar