Posts by: WST Expert 1
Re: Name check
Yep, you can do a countif function.
So countif(ref to B, column A) and it'll return the number of instances that B appears in column A.
Then you can an autofilter to screen out those that have or don't have duplicates - filter for those more or less than 0.
Yep, you can do a countif function.
So countif(ref to B, column A) and it'll return the number of instances that B appears in column A.
Then you can an autofilter to screen out those that have or don't have duplicates - filter for those more or less than 0.
Re: Convertible Debt Adjustment
5) Recall, your decision is as of today, as of now. So, if you convert NOW, you get $x of stock. If you hold on right now, you get $y of principal. Generally, whichever is bigger, you do. If $y is much larger than $x, then don't convert. If $x is much larger than $y, then convert. However, if $x is... Read More
5) Recall, your decision is as of today, as of now. So, if you convert NOW, you get $x of stock. If you hold on right now, you get $y of principal. Generally, whichever is bigger, you do. If $y is much larger than $x, then don't convert. If $x is much larger than $y, then convert. However, if $x is... Read More
Re: Name check
To clean up your data first so that column A and B match same format of names, you have to split up B to match A. So in our Adv Excel for Data Analysis class we teach you a combination of left, right, and len functions. http://www.wallst-training.com/self-stu ... tech-excel Read More
To clean up your data first so that column A and B match same format of names, you have to split up B to match A. So in our Adv Excel for Data Analysis class we teach you a combination of left, right, and len functions. http://www.wallst-training.com/self-stu ... tech-excel Read More
RE: Merger Modeling Basics: Questions on Merger model
It looks like you are a prime candidate for our Complex LBO and Super-Advanced Merger Modeling! As explained in the videos, your questions relate to our simple merger model which is meant to give a taste and a proxy of the all-out merger model. To answer your question: 1) Accretion/Dilution is a... Read More
It looks like you are a prime candidate for our Complex LBO and Super-Advanced Merger Modeling! As explained in the videos, your questions relate to our simple merger model which is meant to give a taste and a proxy of the all-out merger model. To answer your question: 1) Accretion/Dilution is a... Read More
Re: Off Balance Sheet Capital Commitment
To clarify then, this ODM company's commitment is to construct building/factory in future? Is this a one-time commitment or ongoing? If ongoing, we would question the need to capitalize since again, part of operations. BUT an ODM doesn't construct buildings/factories EVERY year (after growth phas... Read More
To clarify then, this ODM company's commitment is to construct building/factory in future? Is this a one-time commitment or ongoing? If ongoing, we would question the need to capitalize since again, part of operations. BUT an ODM doesn't construct buildings/factories EVERY year (after growth phas... Read More
RE: Merger Modeling Basics: 338(h)10 election
Transactions Fees go to GW directly, "one for one". When calculating GAAP financials, the "GW" calcuation for tax deducts would include Trx Fees. The actual deductibility depends on the country-specific tax laws and even state-specific tax laws, too difficult and more importantly, unnecessary for fi... Read More
Transactions Fees go to GW directly, "one for one". When calculating GAAP financials, the "GW" calcuation for tax deducts would include Trx Fees. The actual deductibility depends on the country-specific tax laws and even state-specific tax laws, too difficult and more importantly, unnecessary for fi... Read More
Re: Charts suddenly not visible/filled in box of one colour
This sounds like a bug in Excel. We encounter this every now and then except the chart is black instead of gray. Unfortunately there is no remedy other than to recreate the chart or retrieve an earlier version that is still good.
This sounds like a bug in Excel. We encounter this every now and then except the chart is black instead of gray. Unfortunately there is no remedy other than to recreate the chart or retrieve an earlier version that is still good.
Re: Off Balance Sheet Capital Commitment
Correct - this is a pro forma adjustment.
However, future depreciation and debt paydown should be incorporated in your projections (again, not in historicals).
Correct - this is a pro forma adjustment.
However, future depreciation and debt paydown should be incorporated in your projections (again, not in historicals).
Re: Identifiable Intangible Assets
1) FASB 141/142 However, tax deductibility is not a GAAP item, it is a tax-related item; as such you won't find info on it in the FASBs. Impairment tests are for Goodwill. Don't confuse book vs tax! 2) Tax accounting for stock deal falls under Section 368, Tax-Free Reorg. Intangibles are amortized ... Read More
1) FASB 141/142 However, tax deductibility is not a GAAP item, it is a tax-related item; as such you won't find info on it in the FASBs. Impairment tests are for Goodwill. Don't confuse book vs tax! 2) Tax accounting for stock deal falls under Section 368, Tax-Free Reorg. Intangibles are amortized ... Read More
For what purpose are you evaluating the company? Assuming the capital commitment is to build a building in the future: 1) for standalone going concern valuation, we don't think that this needs to be capitalized because it seems to be part of operations; if this is not the case, please provide more ... For what purpose are you evaluating the company?
Assuming the capital commitment is to build a building in the future:
1) for standalone going concern valuation, we don't think that this needs to be capitalized because it seems to be part of operations; if this is not the case, please provide more information on the company and industry
2) for M&A purposes, on first glance, without more information, we also don't think it needs to be capitalized if it's part of operations - it's like "paying for" rent (a future commitment)
3) for credit purposes, definitely yes capitalize, or include as part of debt in leverage statistics, because it is a known commitment in the future that increases potential indebtedness
4) for distressed/liquidation analysis, it depends - sounds like an executory contract, so unsecured creditor Read More