Posts by: WST Expert 1
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
Re: Historical Cash & Equivalent Reconciliation
We never bother to reconcile historical cash flow statement. Why not? Because you'll never know the adjustments the the company made. For instance, the change in A/R or A/P contains write-downs or other accruals that will not make the BS change exactly equal to the CF figures.
We never bother to reconcile historical cash flow statement. Why not? Because you'll never know the adjustments the the company made. For instance, the change in A/R or A/P contains write-downs or other accruals that will not make the BS change exactly equal to the CF figures.
Re: Macros Addin Excel 2017
Hi Joya, Could you please also let us know your current Mac OS version? Also, would it be possible to update your Excel for Mac to the latest version that Microsoft allows? Finally, if you could provide a screenshot of what you're seeing, that'd be great. You could email us at support@wallst.t... Read More
Hi Joya, Could you please also let us know your current Mac OS version? Also, would it be possible to update your Excel for Mac to the latest version that Microsoft allows? Finally, if you could provide a screenshot of what you're seeing, that'd be great. You could email us at support@wallst.t... Read More
X
-0/excel_add_in_instructions-343?single=2397&parent=2396" class="comm_tool fl">Go to post
added 6 years ago
NOTICE
Trying to get property of non-object
/home/pixelfind/product/html/resources/cache_p/dXNlcl91c2VyX3Bvc3Rz.php
Trying to get property of non-object
/home/pixelfind/product/html/resources/cache_p/dXNlcl91c2VyX3Bvc3Rz.php
#54
Re: Intangible Asset Amortization
Amortization of intangibles is typically disclosed in the footnotes or MD&A of the 10K as it is required by the SEC as a disclosure. In the event this truly is not found in the 10K or otherwise, and if the company has indeed discussed amortization expense in COGS and OpEx (well actually that's your ... Read More
Amortization of intangibles is typically disclosed in the footnotes or MD&A of the 10K as it is required by the SEC as a disclosure. In the event this truly is not found in the 10K or otherwise, and if the company has indeed discussed amortization expense in COGS and OpEx (well actually that's your ... 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... 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 accounting or auditing of the loan book of a bank. As such, we do not do a detailed review of the newer Basel III and FASB CEEL methodologies, since absent additional non-public information that you simply will never have access to from public filings, we can only rely on historical trend reported and then modify for any impending crises or shock events you might see around the horizon. Hope that helps clarify. We are happy to hop on a call anytime to discuss further if necessary.
Thank you. Read More