Posts by: WST Expert 1
Re: formula on how to dynamically copy a cell
Don't be afraid to use an extra row here and there to calculate values as necessary. We would probably add a row that calculates the stock movement based on a index starting value (i.e. 100). Then take that new row and multiply by the invested stock amount from prior period multiplied by your 1 ... Read More
Don't be afraid to use an extra row here and there to calculate values as necessary. We would probably add a row that calculates the stock movement based on a index starting value (i.e. 100). Then take that new row and multiply by the invested stock amount from prior period multiplied by your 1 ... Read More
Re: Where can I find the other templates for these standalone clips or are these just teasers, must we purchase the advanced package to get the same tutorial as we did with the basic?
Hi, as you mentioned, the Excel templates and/or slide materials referenced in this free package act as a preview of the full package. For a more detailed glimpse at several specific courses, please feel free to sign up for the six-month free trial (head to our webpage at http://wallst-training.com ... Read More
Hi, as you mentioned, the Excel templates and/or slide materials referenced in this free package act as a preview of the full package. For a more detailed glimpse at several specific courses, please feel free to sign up for the six-month free trial (head to our webpage at http://wallst-training.com ... Read More
Re: Run-time error 1004 when formatting numbers
This often happens with legacy (older) files. To get around this, try running the "Remove Unused Number Formats" function under the "Worksheet" section (From the Add-Ins ribbon -> WST).
This often happens with legacy (older) files. To get around this, try running the "Remove Unused Number Formats" function under the "Worksheet" section (From the Add-Ins ribbon -> WST).
Run-time error 1004 when formatting numbers
Some students have received this error message when formatting numbers via Ctrl + Shift + M, etc.: "Run-time error 1004: Unable to set the NumberFormat property of the Range class"
Some students have received this error message when formatting numbers via Ctrl + Shift + M, etc.: "Run-time error 1004: Unable to set the NumberFormat property of the Range class"
Windows 10
Hi, just a quick note: for Windows 10 instructions, please refer to the tutorial on the last page of the PDF file above. The video does not cover Windows 10 users. Thanks!
Hi, just a quick note: for Windows 10 instructions, please refer to the tutorial on the last page of the PDF file above. The video does not cover Windows 10 users. Thanks!
Re: Crude Inventory Product Financing Arrangement
Yes to both questions.
Yes to both questions.
Re: Off-balance sheet Inventory Financing
Honestly, we don't have enough information about the project to further advise you properly.
Honestly, we don't have enough information about the project to further advise you properly.
Re: Complex LBO Modeling Course (Super Complex M&A Modeling Course)
It is not mandatory for you to go through Package 6 - LBO before the Complex LBO modeling course. However, most, if not all, of the concepts and foundation for understanding the Complex LBO model is discussed in Package 6 and we reference the materials frequently. Unfortunately, there is no model fr... Read More
It is not mandatory for you to go through Package 6 - LBO before the Complex LBO modeling course. However, most, if not all, of the concepts and foundation for understanding the Complex LBO model is discussed in Package 6 and we reference the materials frequently. Unfortunately, there is no model fr... Read More
Re: Non-Controlling Interests IAS 10 accounting reclassification
Yes correct, we still treat MI / NCI as NOT part of Equity, therefore in our financial model and valuation analysis, we will reclassify MI / NCI back as part of Liability and make sure Equity does not include MI / NCI. This also applies to US GAAP, not just IFRS, since the same rule impacts US GAAP ... Read More
Yes correct, we still treat MI / NCI as NOT part of Equity, therefore in our financial model and valuation analysis, we will reclassify MI / NCI back as part of Liability and make sure Equity does not include MI / NCI. This also applies to US GAAP, not just IFRS, since the same rule impacts US GAAP ... Read More
This could very well be a simple syntax issue -- as in, you have the right idea already. In the very last parameter, try separating the equals sign from the cell reference, and use an ampersand to concatenate the two. So, where you have: "=$BC5" ... try changing this to: "="&$BC5 Basi... This could very well be a simple syntax issue -- as in, you have the right idea already. In the very last parameter, try separating the equals sign from the cell reference, and use an ampersand to concatenate the two.
So, where you have:
"=$BC5"
... try changing this to:
"="&$BC5
Basically you are splitting the cell reference out, because in your version, Excel is reading $BC5 as a literal string, consisting of of a dollar sign, an uppercase B, an uppercase C, then the number 5. Instead, you want Excel to interpret as the cell reference it is -- that is, a reference to cell BC5.
Please let us know if that works for you! Read More