Posts by: WST Expert 1
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
Re: WORLDCOM (video 13:00 timeslot())
Actually it was $500MM of costs in that year - so if life is 10 years, that means they misclassified $5 BIL (assuming straight line) in total assets.
Worldcom actually ended up with over $8 BIL in total expenses misclassified => that implies $80 BIL of assets assuming 10 year straight line.
Actually it was $500MM of costs in that year - so if life is 10 years, that means they misclassified $5 BIL (assuming straight line) in total assets.
Worldcom actually ended up with over $8 BIL in total expenses misclassified => that implies $80 BIL of assets assuming 10 year straight line.
Re: Gain/Loss on Derivative for Oil & Gas Company
It shouldn't matter. Non-cash gains /losses are typically due to mark to market and go through OCI as they are likely classified as AFS securities and shouldn't change original analysis.
It shouldn't matter. Non-cash gains /losses are typically due to mark to market and go through OCI as they are likely classified as AFS securities and shouldn't change original analysis.
Re: Year of statements inquiry
Recall that for the retail sector, fiscal years end in January. Thus, January 2006 = Fiscal 2005 per the videos.
Recall that for the retail sector, fiscal years end in January. Thus, January 2006 = Fiscal 2005 per the videos.
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).