Posts by: WST Expert 1
RE: Circular references clarified
Your question can be summarized as follows: What is a circular reference, how do you avoid circular references in a financial model and once you have a circular reference, what does the Iterations option in Excel do? The logic runs as follows: In general, there is NO good reason to have a circu... Read More
Your question can be summarized as follows: What is a circular reference, how do you avoid circular references in a financial model and once you have a circular reference, what does the Iterations option in Excel do? The logic runs as follows: In general, there is NO good reason to have a circu... Read More
RE: LBO enhanced model question
If its a true asset deal, you are buying an asset and there's no goodwill. If the lawyer says otherwisen go with the lawyer as they presumbaly have viewed deal specific structure. It also depends on if its a 338(h)(10) election and if so, there is goodwill as that is a tax election. In short, too ma... Read More
If its a true asset deal, you are buying an asset and there's no goodwill. If the lawyer says otherwisen go with the lawyer as they presumbaly have viewed deal specific structure. It also depends on if its a 338(h)(10) election and if so, there is goodwill as that is a tax election. In short, too ma... Read More
Re: Enhancements to the core model - Part II tax schedule
Please refer to our Accounting & Financial Statements Bootcamp course for accounting fundamentals.
http://www.wstselfstudy.com/accountingboot.html
Please refer to our Accounting & Financial Statements Bootcamp course for accounting fundamentals.
http://www.wstselfstudy.com/accountingboot.html
Re: Saving macros across workbooks in 2007
In addition, per previous post communication, the reduced functionality of Excel 2007 can be blamed on Microsoft!
viewtopic.php?f=8&t=582&p=1417#p1417
In addition, per previous post communication, the reduced functionality of Excel 2007 can be blamed on Microsoft!
viewtopic.php?f=8&t=582&p=1417#p1417
RE: How do I model out zero-coupon accretion / PIKs?
To answer your question on the best practices of treating discounted notes that accrete: you do have the right approach to a discount bond, which would also apply in the case of PIKs: 1) Increase Interest Expense on the Income Statement (via the Interest Schedule) by the amount of the accretion. ... Read More
To answer your question on the best practices of treating discounted notes that accrete: you do have the right approach to a discount bond, which would also apply in the case of PIKs: 1) Increase Interest Expense on the Income Statement (via the Interest Schedule) by the amount of the accretion. ... Read More
RE: Is DCF a pre- or post-tax value?
You run both methods (per the training) to make sure the numbers are fairly consistent. In that sense, it's comparable.
You run both methods (per the training) to make sure the numbers are fairly consistent. In that sense, it's comparable.
RE: How to calculate CAPM for emerging markets?
easy answer - take our emerging mkts class! seriously though, great question with easy answer - make sure that when you grab the beta from bloomberg that you use S&P 500 as your index as opposed to the default which may be FTSE 100. rationale - as you noted, you DO want to capture country spe... Read More
easy answer - take our emerging mkts class! seriously though, great question with easy answer - make sure that when you grab the beta from bloomberg that you use S&P 500 as your index as opposed to the default which may be FTSE 100. rationale - as you noted, you DO want to capture country spe... Read More
Re: The Financial Modeling Process
The Cash Available / (Required) Before Debt is calculated by taking the summation of Cash From Operating Activities (CFO); Cash From Investing Activities (CFI); and Cash From Financing Activities (CFF). In the case of our model, CFO, CFI, and CFF should equal $17274; (17,500); and (6,000), respectiv... Read More
The Cash Available / (Required) Before Debt is calculated by taking the summation of Cash From Operating Activities (CFO); Cash From Investing Activities (CFI); and Cash From Financing Activities (CFF). In the case of our model, CFO, CFI, and CFF should equal $17274; (17,500); and (6,000), respectiv... Read More
In general, financial models are good for a particular point in time, as these are not tracking models like quarterly Equity Research models but rather, transaction models. To adjust the model from end of 2004 to Q2 2005, you would have to build in a stub period. The stub period would reflect the 2n... In general, financial models are good for a particular point in time, as these are not tracking models like quarterly Equity Research models but rather, transaction models. To adjust the model from end of 2004 to Q2 2005, you would have to build in a stub period. The stub period would reflect the 2nd half of the year's earnings instead of full year. Likewise, the balance sheet would be updated for Q2 2005 numbers instead of year end 2004. Read More