Posts by: WST Expert 1
RE: Excel Question
Use trim function first to remove extra spaces. This is actually covered in the adv excel for data analysis online course. To take out periods and commas use substitute function. Then sometimes you might have abbreviations like microsoft corporation vs microsoft corp. Use the left function and pick ... Read More
Use trim function first to remove extra spaces. This is actually covered in the adv excel for data analysis online course. To take out periods and commas use substitute function. Then sometimes you might have abbreviations like microsoft corporation vs microsoft corp. Use the left function and pick ... Read More
Re: startups
Valuing startup companies is like throwing darts at the sun. None of the usual valuation methodologies apply because no one knows what will happen and the high risk and probability of failure despite the huge potential reward. Even multiples is sort of silly since who do you pick as your benchmark?... Read More
Valuing startup companies is like throwing darts at the sun. None of the usual valuation methodologies apply because no one knows what will happen and the high risk and probability of failure despite the huge potential reward. Even multiples is sort of silly since who do you pick as your benchmark?... Read More
Re: Off Balance Sheet Capital Commitment
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 ... 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 ... Read More
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
1) You would adjust the S/Out by the amount that still has not been converted. We don't remember the numbers off-hand, but it would not be the entire maximum amount of shares. 2) Yes, same for all convertible securities. There's no difference in this context between preferred or debt. The differen... 1) You would adjust the S/Out by the amount that still has not been converted. We don't remember the numbers off-hand, but it would not be the entire maximum amount of shares.
2) Yes, same for all convertible securities. There's no difference in this context between preferred or debt. The difference is in the convenants, but not from a valuation perspective (for non-distressed companies).
3) The general rule is to use whatever latest available information is around. Thus, using the 10K capital leases would be ok ASSUMING the numbers aren't that materially off. Chances are, the change isn't material and so, as a proxy, you would have no choice. We do discourage it, but absent any info, we have no other option.
4) Back to your #1. 9.4MM is the REMAINING amount. Read carefully. It's possible that Hamilton made a mistake, but unlikely!
Note that we're paid to say that!
5) The zero-coupon adds an extra layer of complexity because the current value on the books is what needs to be compared, not the full principal amount due at maturity. Please re-visit Hamilton's explanation in the videos on this point. (or ask a specific question that we can answer, thanks!)
6) Generally, the way converts work, you elect to take shares INSTEAD of receiving principal amount in the convertibility period. So, no, you do not have to buy the underlying stock. That is the case with options and warrants, but not converts.
7) You would have to re-do your analysis with each new reporting period. the stock price would have also changed at that point as well as the new carrying value on the books.
no problem with the volume of questions - that's what we're here for!
And apologies for the delay in responding - your account was locked and we didn't see the question coming in. Read More