Posts by: WST Expert 1
Re: End of Year vs Beginning of Year
Yes, that is correct! As explained earlier in the course (or another related course), the period ending Jan 2007 we are calling 2006 since 11 months of the 2006 are included. The reason why some retailers end their fiscal year in January as opposed to December is to account for the after-Christmas/H... Read More
Yes, that is correct! As explained earlier in the course (or another related course), the period ending Jan 2007 we are calling 2006 since 11 months of the 2006 are included. The reason why some retailers end their fiscal year in January as opposed to December is to account for the after-Christmas/H... Read More
Re: Bank Financial Modeling
Yes, our bank modeling courses, in particular, the Advanced version indeed is to determine profits/cash flow and intrinsic value based on forecasts of key inputs and drivers. The models are based on Basel II, not Basel III or CECL. Most, if not all of the inputs required to update to Basel III woul... Read More
Yes, our bank modeling courses, in particular, the Advanced version indeed is to determine profits/cash flow and intrinsic value based on forecasts of key inputs and drivers. The models are based on Basel II, not Basel III or CECL. Most, if not all of the inputs required to update to Basel III woul... Read More
Re: Bank Financial Modeling
Hello, Thank you for your inquiry. Our Bank Modeling course is focused primary on the integration of the financial statements for a bank. We do spend some time on justifying the inputs from the footnotes and additional disclosures. However, our courses is not meant to be a deep dive forensic ac... Read More
Hello, Thank you for your inquiry. Our Bank Modeling course is focused primary on the integration of the financial statements for a bank. We do spend some time on justifying the inputs from the footnotes and additional disclosures. However, our courses is not meant to be a deep dive forensic ac... Read More
Re: Feedback
That is correct, we never mentioned that we have captions. Regarding increase/decrease playback speed, we will look into it. Thank you.
That is correct, we never mentioned that we have captions. Regarding increase/decrease playback speed, we will look into it. Thank you.
Re: Turning the default Excel cell backgrounds to gray
It is best practice to allow maximum flexibility in your financial model. We would not teach this step if it was not the superior setup to maximize your success building complex financial models.
It is best practice to allow maximum flexibility in your financial model. We would not teach this step if it was not the superior setup to maximize your success building complex financial models.
Re: Depreciation Schedule
Hello, Thank you for your inquiry. The useful life of the various PPE assets are disclosed in the footnotes of the 10K filing. You would then guesstimate the remaining life of each asset category based on the remaining life which is calculated based off the weight % accumulated metric. Hope... Read More
Hello, Thank you for your inquiry. The useful life of the various PPE assets are disclosed in the footnotes of the 10K filing. You would then guesstimate the remaining life of each asset category based on the remaining life which is calculated based off the weight % accumulated metric. Hope... Read More
Re: Adv LBO Modeling TL Logic
Please review the Intermediate LBO Modeling course that explains this in greater detail. High level, the TL has an Excess Cash Flow Sweep.
Please review the Intermediate LBO Modeling course that explains this in greater detail. High level, the TL has an Excess Cash Flow Sweep.
Re: Completed work sheet
Hi Fanar, Thank you for your question. I understand that some of the courses are a bit more faster paced and difficult to follow than others. However, we have a strict policy of not disseminating the "answers" for any of our models in order to protect the integrity of our WST Verification and WST... Read More
Hi Fanar, Thank you for your question. I understand that some of the courses are a bit more faster paced and difficult to follow than others. However, we have a strict policy of not disseminating the "answers" for any of our models in order to protect the integrity of our WST Verification and WST... Read More
Re: Historical Cash & Equivalent Reconciliation
Hello, If you have your quarterly IS and BS projections, then the CF should be easy as long as you are using the indirect method of cash flow construction. Recall that the CF starts with NI, adds D&A and changes in working capital, the latter being derived from BS changes quarter to quarter. CapE... Read More
Hello, If you have your quarterly IS and BS projections, then the CF should be easy as long as you are using the indirect method of cash flow construction. Recall that the CF starts with NI, adds D&A and changes in working capital, the latter being derived from BS changes quarter to quarter. CapE... Read More
Hi Ty, We got the Excel file that you emailed us earlier. We disabled the WST Macros add-in and the error still appeared. This looks like an issue with at least one formula that's causing issues. To me, it looks like cell H15 on the "Check" worksheet is the problem, because when I delete it, t... Hi Ty,
We got the Excel file that you emailed us earlier. We disabled the WST Macros add-in and the error still appeared. This looks like an issue with at least one formula that's causing issues.
To me, it looks like cell H15 on the "Check" worksheet is the problem, because when I delete it, the errors go away. The purpose of this cell seems to be look for cell errors on one specific worksheet by checking every single cell on it. This seems to be highly inefficient, because it's iterating through over 17 billion cells just to detect any errors.
We'd recommend checking for errors in another way, and simply deleting this formula in H15. Let us know if that helps! Read More