Posts by: Guest 1

Excel Question
If you have to worksheets; one is all the stocks in the S&P and another with just Argentinian stocks and you want to see which ones overlap, what do you do? I did a vlookup but the problem is that some have the same names but some have periods, commas or extra spaces in the names so you cant do ... Read More
Go to post added 11 years ago
startups
Can you provide some guidance on valuing startups?
Go to post added 11 years ago
Off Balance Sheet Capital Commitment
Hi WST, I am evaluating a company and come across a disclosure on its financial report stating that there is, say, XYZ amount of capital commitment for building construction not included in the financial statements. So my question is should we capitalize that capital commitment on the balance sheet... Read More
Go to post added 11 years ago
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?
Go to post added 11 years ago
Minority Interest in LBO Model
When doing a (UK) PtP LBO Model, I have to include in uses of fund the following (what I am quite sure about): Share Price (latest close) % Premium Offer Price per Share All Shares Outstanding Equity Offer Value =+Debt Refinancing =+Pensions =+Transaction Costs =+Tendering Costs =+... Read More
Go to post added 11 years ago
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... Read More
Go to post added 11 years ago
LBO enhanced model question
The LBO enhanced model, once I put in 2007 as the last full year, uses 2007 as the year to add the balance sheet deal adjustments--even though the deal will happen in, say, August 2008. It then gives the 2008P and 2009-2012E balance sheets. This seems counter-intuitive: Shouldn't the deal adjust... Read More
Go to post added 11 years ago
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... Read More
Go to post added 11 years ago
Re: Off Balance Sheet Capital Commitment
It's an ODM technology company contemplating a public new shares issue. The purpose of the exercise is to evaluate the fair market value of the company to decide whether or not to subscribe to the offering. So if to capitalize the off balance sheet building construction commitment, what would the ... Read More
Go to post added 11 years ago
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 ... Read More
Go to post added 11 years ago