Name check
Hi,

I have a column of names ( Column A - First then Last Name no commas) and another column of names ( Column B - Last Name comma First Name).

Is there a way to check whether names from Column B are on Column A through a lookup of some sort?

Re: Convertible Debt Adjustment
(1) & (4) Sorry! I guess the key words are "current Notes outstanding". This makes a lot more sense now. (2) (3) (4b) & (7) Thanks! (5) I think you may have missed my question 5 (you answered 4b). As an investor, why don't we compare the current stock price of Costco to its init... (1) & (4) Sorry! I guess the key words are "current Notes outstanding". This makes a lot more sense now.

(2) (3) (4b) & (7) Thanks!

(5) I think you may have missed my question 5 (you answered 4b). As an investor, why don't we compare the current stock price of Costco to its initial conversion price of $22 (per 10-K) for conversion decision making? Isn't that how you would deal with int-bearing debt? Is it because we are dealing with a zero-coupon bond? The way that i'm trying to make sense of it is that It seems there is a varying amount of shares that would be issued upon conversion, and that share count is determined by the PV of the principal. While that may be, I still don't understand why we don't do a direct stock price to conversion price comparison (in this case Costco's current price is clearly greater than its conversion price of $22)

(6) Thanks, this makes sense. However, does Common stock/APIC still go up since the company has effectively shifted some debt into equity? Read More

Merger Modeling Basics: Questions on Merger model
Hi, I have a couple of questions in relation to this module that I will need your assistance to understand: (1). I'm confused with the GW calculation. In our "Accretion Dilution Model" we did it one way (P. price - book value). While in this module, we did: P. price - book value + transaction fee... Hi, I have a couple of questions in relation to this module that I will need your assistance to understand:

(1). I'm confused with the GW calculation. In our "Accretion Dilution Model" we did it one way (P. price - book value). While in this module, we did: P. price - book value + transaction fees. Which one should I use? And why did you guys use it differently in each module?

(2). Why did we completely disconsider the target Book value when calculating the Pro Forma Shareholder's Equity? Does it have to do with the way we are funding the deal (debt vs. equity) or not?

(3). When we are linking the Enterprise Value with the %age of cash / equity in the deal structure, we are assuming that the target debt is being refinanced 1/2 by a new debt and retired by 1/2 equity raised. But how it happens if in the previous post in this forum, WST answered that you cannot pay your transaction fees in equity, as it is a cash coming out. So, the same concept applies here: considering that %age relates to the physical currency you pay, how can one retire the debt with shares (whereas you should be doing that with cash - in physical currency)?

(4). That percentage table (of %cash / %equity) relates to how you pay the target (physically speaking) or how you fund the transaction as a whole (raising debt and equity in the markets, and them using the proceeds to pay the purchase price, refinance target debt and pay for transaction fees)?

(5). Shouldn't we simply link the %cash / %equity to the purchase price (them assuming it is the way I'm paying the target in physical terms) and them include another line below "Stock issued" saying "Refinanced Target debt" in which we will assume we drawdown a new debt, pay off target's existing debt? Meaning that we refinance debt entirely w/ another debt (of course w/ better terms & rates), and not splitting the refinanced debt in equity and debt.

I appreciate your help in each of those questions.

Rgds. Read More

Re: Accounting For Held to Maturity Securities
I didn't quite understand Accounting For Held to Maturity Securities section: Please advise to help me understand this section. I have purchased the package 1 a few months ago, but I did not understand anything at all, so I purchased the Accounting bootcamp course as instructor advise, and now the ... I didn't quite understand Accounting For Held to Maturity Securities section: Please advise to help me understand this section.
I have purchased the package 1 a few months ago, but I did not understand anything at all, so I purchased the Accounting bootcamp course as instructor advise, and now the package 1 is no longer in my account anymore. Please advise what is happen.

Thanks, Read More

Merger Modeling Basics: 338(h)10 election
Hi there, In a 338(h)10 election deal structure, where we don't need to amortize the "GW" but we still have the tax credit, should we apply the tax credit to the difference between Purchase Price - Book Value ONLY, or the tax credit goes over Purchase Price - Book Value + Transaction fees? In oth... Hi there,

In a 338(h)10 election deal structure, where we don't need to amortize the "GW" but we still have the tax credit, should we apply the tax credit to the difference between Purchase Price - Book Value ONLY, or the tax credit goes over Purchase Price - Book Value + Transaction fees? In other words, does the "GW" calculation for a 338(h)10 election tax credit include or not the transaction fees?

Kind Regards. Read More