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 (58 post(s))
- Package 1: Basic & Fundamental Concepts (72 post(s))
- Package 2: Core Fundamental Concepts (61 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 (35 post(s))
- Overview of Financial Markets + Exhibits (11 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 (18 post(s))
- Package: Insurance Financial Modeling (14 post(s))
- Package: Real Estate Development Modeling (7 post(s))
- Package: REIT Financial Modeling (0 post(s))
- Package: Buy-Side Series (6 post(s))
Verification
Certification
Last 10 posts
Cash Flow Statement: Future Minimum Cash Payments
Hi, during the 'How to Analyze a 10K' portion of my course, Mr. Lin mentions, "future minimum cash payments must be reflected on the cash flow statement." I'm curious where this would be included. Thanks so much for the help!
Hi, during the 'How to Analyze a 10K' portion of my course, Mr. Lin mentions, "future minimum cash payments must be reflected on the cash flow statement." I'm curious where this would be included. Thanks so much for the help!
Question about Change in Comprehensive Income
Hi Mr. Lin, for the change in Comprehensive Income, you include (from the S/H - EQ section of the 10K): $963 (unrealized gain on derivative contracts, net of deferred tax expense of $643) and $678 (Other). Why don't you include $502 from the Balance Sheet (unrealized loss on interest rate swaps)?
Hi Mr. Lin, for the change in Comprehensive Income, you include (from the S/H - EQ section of the 10K): $963 (unrealized gain on derivative contracts, net of deferred tax expense of $643) and $678 (Other). Why don't you include $502 from the Balance Sheet (unrealized loss on interest rate swaps)?
Interest Reserve
Let's say the construction loan is good for 24 months but the actual construction period is only 22 months. Hypothetically it has been determined revenue will not be sufficient enough to make any payments on a loan until month 25 resulting in two additional months beyond construction completion that... Read More
Let's say the construction loan is good for 24 months but the actual construction period is only 22 months. Hypothetically it has been determined revenue will not be sufficient enough to make any payments on a loan until month 25 resulting in two additional months beyond construction completion that... Read More
IRR Calculation
I get 23.5% for IRR (with TV) not 29.6%
I get 23.5% for IRR (with TV) not 29.6%
Control D
when you used control d to paste down, then had to underline the bottom cell, if you used paste special - formulas instead, the bottom cell would still be underlined
when you used control d to paste down, then had to underline the bottom cell, if you used paste special - formulas instead, the bottom cell would still be underlined
2008 Diluted EPS
That number should be 3.34, not 3.33. this changes the growth rate from the erroneous 10.5% in the video to the correct 10.2%
That number should be 3.34, not 3.33. this changes the growth rate from the erroneous 10.5% in the video to the correct 10.2%
Control R vs Paste Special
Why use Control R over Paste Special when pasting to the right? Control R may paste over some unwanted stuff or remove borders. For example, for Diluted EPS growth if you'd pasted it in it removes the bottom borders. I know you redid the formulas for that one, but Paste Special Formulas worked perfe... Read More
Why use Control R over Paste Special when pasting to the right? Control R may paste over some unwanted stuff or remove borders. For example, for Diluted EPS growth if you'd pasted it in it removes the bottom borders. I know you redid the formulas for that one, but Paste Special Formulas worked perfe... Read More
Costco Interest Expense
For TGT and WMT, interest expense was taken as the gross total (including interest income). But, for COST only interest expense is included. Should that number be 144 instead of 34? (143.533 rounded, which is the interest expense (34,437) and interest income (109,096) summed to get gross interest)
For TGT and WMT, interest expense was taken as the gross total (including interest income). But, for COST only interest expense is included. Should that number be 144 instead of 34? (143.533 rounded, which is the interest expense (34,437) and interest income (109,096) summed to get gross interest)
Location of additional file that is referened?
Hello, Where can I find the exhibit for changes in NWC that Hamilton refers to? I can't seem to find it.
Hello, Where can I find the exhibit for changes in NWC that Hamilton refers to? I can't seem to find it.
Hi there, I'm looking for the PDF with the instructions to download the macros. I cannot find them anywhere. Thanks for the help!